SSR_BR_TPRT_NLD (SQL Table)	Index Back
Tution Fees Feedbcak Edu Part Tution Fees Feedbcak Basis Educational participations

SSR_BR_TPRT_NLD

(SQL Table)

Tution Fees Feedbcak Edu Part

Tution Fees Feedbcak Basis Educational participations

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SAD_SL_TRANS_INOUT Character(1) VARCHAR2(1) NOT NULL Transaction Direction
I=Inbound
O=Outbound

2 SAD_SL_TRANS_DTTM DateTime(26) TIMESTAMP Transaction DateTime

3 SAD_SL_TRANS_SEQ Number(3,0) SMALLINT NOT NULL Sequence Number

4 SSR_BR_INDEXID_NLD Character(50) VARCHAR2(50) NOT NULL Index ID

5 SAD_SL_STUD_NBR Character(12) VARCHAR2(12) NOT NULL Student Number

6 SCC_SUBBRINCD_NLD Character(2) VARCHAR2(2) NOT NULL Sub Institute

7 SCC_BRINCD_NLD Character(4) VARCHAR2(4) NOT NULL BRINcode

8 SAD_SL_PROG_CODE Character(5) VARCHAR2(5) NOT NULL Program Code

9 SSR_FORM_STUDY_NLD Character(4) VARCHAR2(4) NOT NULL Form of Study Higher Education
A=Auditor
D=Participant
E=Extraneus
S=Student
T=Coop/Dual

10 SSR_ACAD_LEVEL_NLD Character(4) VARCHAR2(4) NOT NULL Academ. Level Higher Education
A=Associate Degree
B=Bachelor
D=Propaedeutic Bachelor
H=Main
I=Initial Phase
K=Candidate
L=University teacher education
M=Master
P=Propaedeutic Phase
Q=Post-Initial
T=Interim Doctoral Exam
V=Continuation Phase
W=Continuing study

11 ENROLLMENT_DT Date(10) DATE Original Enrollment Date

12 SAD_BR_ENR_END_DT Date(10) DATE Enrollment End Date

13 SSR_BR_INST_NM_NLD Character(200) VARCHAR2(200) NOT NULL Name of the Institution

14 DESCR Character(30) VARCHAR2(30) NOT NULL Description

15 DESCR60 Character(60) VARCHAR2(60) NOT NULL Description

16 SSR_BR_STD_LVL_NLD Character(10) VARCHAR2(10) NOT NULL BRON Study Level

17 SSR_BR_FND_CD_NLD Character(50) VARCHAR2(50) NOT NULL Funding Source
0=False
1=True

18 SSR_BR_FND_DUR_NLD Number(2,0) SMALLINT NOT NULL Funding Duration

19 SSR_BR_HE_SECT_NLD Character(80) VARCHAR2(80) NOT NULL Higher Education Section

20 SSR_BR_AC_LDAP_NLD Character(2) VARCHAR2(2) NOT NULL Approved Academic Load
DT=Part-Time
DU=Dual
VT=Full-Time

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SAD_SL_TRANS_INOUT	Character(1)	VARCHAR2(1) NOT NULL	Transaction Direction I=Inbound O=Outbound
2	SAD_SL_TRANS_DTTM	DateTime(26)	TIMESTAMP	Transaction DateTime
3	SAD_SL_TRANS_SEQ	Number(3,0)	SMALLINT NOT NULL	Sequence Number
4	SSR_BR_INDEXID_NLD	Character(50)	VARCHAR2(50) NOT NULL	Index ID
5	SAD_SL_STUD_NBR	Character(12)	VARCHAR2(12) NOT NULL	Student Number
6	SCC_SUBBRINCD_NLD	Character(2)	VARCHAR2(2) NOT NULL	Sub Institute
7	SCC_BRINCD_NLD	Character(4)	VARCHAR2(4) NOT NULL	BRINcode
8	SAD_SL_PROG_CODE	Character(5)	VARCHAR2(5) NOT NULL	Program Code
9	SSR_FORM_STUDY_NLD	Character(4)	VARCHAR2(4) NOT NULL	Form of Study Higher Education A=Auditor D=Participant E=Extraneus S=Student T=Coop/Dual
10	SSR_ACAD_LEVEL_NLD	Character(4)	VARCHAR2(4) NOT NULL	Academ. Level Higher Education A=Associate Degree B=Bachelor D=Propaedeutic Bachelor H=Main I=Initial Phase K=Candidate L=University teacher education M=Master P=Propaedeutic Phase Q=Post-Initial T=Interim Doctoral Exam V=Continuation Phase W=Continuing study
11	ENROLLMENT_DT	Date(10)	DATE	Original Enrollment Date
12	SAD_BR_ENR_END_DT	Date(10)	DATE	Enrollment End Date
13	SSR_BR_INST_NM_NLD	Character(200)	VARCHAR2(200) NOT NULL	Name of the Institution
14	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
15	DESCR60	Character(60)	VARCHAR2(60) NOT NULL	Description
16	SSR_BR_STD_LVL_NLD	Character(10)	VARCHAR2(10) NOT NULL	BRON Study Level
17	SSR_BR_FND_CD_NLD	Character(50)	VARCHAR2(50) NOT NULL	Funding Source 0=False 1=True
18	SSR_BR_FND_DUR_NLD	Number(2,0)	SMALLINT NOT NULL	Funding Duration
19	SSR_BR_HE_SECT_NLD	Character(80)	VARCHAR2(80) NOT NULL	Higher Education Section
20	SSR_BR_AC_LDAP_NLD	Character(2)	VARCHAR2(2) NOT NULL	Approved Academic Load DT=Part-Time DU=Dual VT=Full-Time