SAD_BR_RET_NLD(SQL Table) |
Index Back |
---|---|
BRON return holding tableBron Return holding table |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | INSTITUTION | Character(5) | VARCHAR2(5) NOT NULL |
Academic Institution
Prompt Table: INSTITUTION_TBL |
2 | SCC_BRINCD_NLD | Character(4) | VARCHAR2(4) NOT NULL |
BRINcode
Prompt Table: SCC_BRINCD_NLD |
3 | BATCH_SERIAL_NUM | Number(5,0) | INTEGER NOT NULL | Last Sequence Nbr |
4 | SAD_BR_REC_TYP_NLD | Character(3) | VARCHAR2(3) NOT NULL | Record Type |
5 | SAD_BR_RCTP_RT_NLD | Character(3) | VARCHAR2(3) NOT NULL |
Record Type Return
400=400 402=402 405=405 406=406 410=410 411=411 420=420 421=421 422=422 423=423 425=425 426=426 427=427 428=428 430=430 431=431 432=432 499=499 |
6 | SAD_BR_SEQ_NBR_NLD | Number(6,0) | INTEGER NOT NULL | Sequence Number |
7 | SAD_BR_EDU_SEC_NLD | Character(2) | VARCHAR2(2) NOT NULL |
Educational Sector
BO=Professional Education ED=Education VA=VAVO |
8 | SAD_BR_BRON_BN_NLD | Number(3,0) | SMALLINT NOT NULL | BRON Batchnumber |
9 | SAD_BR_RTP_SEQ_NLD | Number(3,0) | SMALLINT NOT NULL | BRON Recordtype Sequence number |
10 | CREATION_DT | Date(10) | DATE | Creation Date |
11 | SAD_BR_TOT_MUT_NLD | Number(6,0) | INTEGER NOT NULL | Total Mutations |
12 | SAD_BR_TOT_REC_NLD | Number(6,0) | INTEGER NOT NULL | Total Nr. of records |
13 | SAD_BR_TOT_FIL_NLD | Number(6,0) | INTEGER NOT NULL | Nr. of Delivered files return |
14 | SAD_BR_TOT_APP_NLD | Number(6,0) | INTEGER NOT NULL | Nr. of Approved Enrollments |
15 | SAD_BR_TOT_REJ_NLD | Number(6,0) | INTEGER NOT NULL | Number of Rejected Enroll. |
16 | SAD_BR_NUM_REM_NLD | Number(6,0) | INTEGER NOT NULL | Number Remaining Enrollments |
17 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: HCR_PERSON_I |
18 | NATIONAL_ID | Character(20) | VARCHAR2(20) NOT NULL | National ID |
19 | SAD_BR_NAT_ID_NLD | Character(20) | VARCHAR2(20) NOT NULL | Educational Number |
20 | BIRTHDATE | Date(10) | DATE | Date of Birth |
21 | SAD_GBA_B_YR_NLD | Character(4) | VARCHAR2(4) NOT NULL | GBA Year of Birth |
22 | SAD_GBA_B_MN_NLD | Character(2) | VARCHAR2(2) NOT NULL | GBA Month of Birth |
23 | SAD_BR_SEX_NLD | Character(1) | VARCHAR2(1) NOT NULL |
BRON Sex
M=Male O=Unknown V=Female |
24 | POSTAL | Character(12) | VARCHAR2(12) NOT NULL | Postal |
25 | SAD_CBAP_CNTRY_NLD | Character(4) | VARCHAR2(4) NOT NULL | CBAP Country Code |
26 | SAD_BR_NATID_C_NLD | Character(20) | VARCHAR2(20) NOT NULL | Modified SOFI Number |
27 | SAD_BR_BIRTH_C_NLD | Date(10) | DATE | Modified Birthdate |
28 | SAD_GBA_BYRC_NLD | Character(4) | VARCHAR2(4) NOT NULL | Changed Birth Yr GBA |
29 | SAD_GBA_BMNC_NLD | Character(2) | VARCHAR2(2) NOT NULL | Changed Birth Month GBA |
30 | SAD_BR_SEX_C_NLD | Character(1) | VARCHAR2(1) NOT NULL |
Modified Sex
M=Male O=Unknown V=Female |
31 | SAD_BR_PSTAL_C_NLD | Character(12) | VARCHAR2(12) NOT NULL | Modified Postal |
32 | SAD_BR_CNTRY_C_NLD | Character(4) | VARCHAR2(4) NOT NULL | Modified Country code |
33 | FROM_DT | Date(10) | DATE | From Date |
34 | LAST_NAME | Character(30) | VARCHAR2(30) NOT NULL | Last Name |
35 | NAME_ROYAL_PREFIX | Character(15) | VARCHAR2(15) NOT NULL | Name Royal Prefix |
36 | FIRST_NAME | Character(30) | VARCHAR2(30) NOT NULL | First Name |
37 | MIDDLE_NAME | Character(30) | VARCHAR2(30) NOT NULL | MIDDLE_NAME |
38 | SAD_BR_FST_NMS_NLD | Character(200) | VARCHAR2(200) NOT NULL | Firstnames |
39 | ADDRESS3 | Character(55) | VARCHAR2(55) NOT NULL | Address 3 |
40 | NUM1 | Character(6) | VARCHAR2(6) NOT NULL | Number 1 |
41 | NUM2 | Character(6) | VARCHAR2(6) NOT NULL | Number 2 |
42 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
43 | NUM2_OTHER | Character(6) | VARCHAR2(6) NOT NULL | Number 2 Other |
44 | CITY | Character(30) | VARCHAR2(30) NOT NULL | City |
45 | ADDRESS1 | Character(55) | VARCHAR2(55) NOT NULL | Address 1 |
46 | ADDRESS2 | Character(55) | VARCHAR2(55) NOT NULL | Address 2 |
47 | ADDRESS3_OTHER | Character(55) | VARCHAR2(55) NOT NULL | Address 3 Other |
48 | SAD_BR_COUNTRY_NLD | Character(4) | VARCHAR2(4) NOT NULL | Country |
49 | SAD_BR_BRCNTRY_NLD | Character(4) | VARCHAR2(4) NOT NULL | Nationality 2 |
50 | SAD_BR_MUT_TYP_NLD | Character(1) | VARCHAR2(1) NOT NULL |
BRON Mutation Type
A=Change T=Add V=Remove |
51 | SAD_BR_ENRL_SQ_NLD | Character(3) | VARCHAR2(3) NOT NULL | Enrollment Sequence number |
52 | HEGIS_CODE | Character(8) | VARCHAR2(8) NOT NULL |
HEGIS Code
Prompt Table: HEGIS_CODE_TBL |
53 | ACAD_CAREER | Character(4) | VARCHAR2(4) NOT NULL |
Academic Career
BAC=Bachelor (NLD) BBL=Vocational Coaching (NLD) BOL=Vocational Training (NLD) BUSN=Graduate Business CNED=Continuing Education CRED=Semester Credit EDU=Education (NLD) EXED=Extended Education GRAD=Graduate LAW=Law MEDS=Medical School NONA=Non Award PGRD=Postgraduate RSCH=Research TECH=Technical UENG=Undergraduate Engineering UGRD=Undergraduate VAVO=Advanced General Educ. (NLD) VETM=Veterinary Medicine |
54 | STDNT_CAR_NBR | Number(3,0) | SMALLINT NOT NULL | Student Career Nbr |
55 | ACAD_LOAD_APPR | Character(1) | VARCHAR2(1) NOT NULL |
Approved Academic Load
B=Vocational Coaching (NLD) D=Dual (NLD) E=Part-time Vocational Tr (NLD) F=Full-Time O=Vocational Training (NLD) P=Part-Time |
56 | FORM_OF_STUDY | Character(4) | VARCHAR2(4) NOT NULL |
Form of Study
ABRD=Study Abroad CAND=Advanced to Candidacy DTCH=Detached Study ENRL=Class Enrollment |
57 | SAD_BR_CAREER_NLD | Character(3) | VARCHAR2(3) NOT NULL |
BRON Career
BBL=BBL BOL=BOL CBL=CBL COL=COL |
58 | SAD_BR_LOAD_NLD | Character(2) | VARCHAR2(2) NOT NULL |
BRON Intensity
DT=Parttime EX=Exam Student VT=Fulltime |
59 | ENROLLMENT_DT | Date(10) | DATE | Original Enrollment Date |
60 | LEAVE_DT | Date(10) | DATE | Leave Date |
61 | SAD_BR_E_ENRDT_NLD | Date(10) | DATE | Real Leave Date |
62 | SAD_BR_PRIO_ED_NLD | Character(2) | VARCHAR2(2) NOT NULL |
Highest Prior Education
01=No completed primary education 02=Primary Education 03=Basic Year AVO/VBO/VMBO 04=VMBO (Exl. Theoretical Educ.) 05=VMBO Theoretical Education 06=HAVO 07=VWO 08=MBO level 1-2 09=MBO level 3-4 10=Propedeuse HBO 11=HBO 12=Colloquium Doctrum 13=Disposal Admission WO 14=Propedeuse WO 15=Bachelor WO 16=Master WO |
63 | SAD_BR_RSK_STT_NLD | Character(1) | VARCHAR2(1) NOT NULL | Indicator Risk Student |
64 | DISABLED | Character(1) | VARCHAR2(1) NOT NULL | A flag that indicates whether or not (Y or N) a dependent is a disabled. |
65 | SAD_BR_LAPRED_NLD | Character(5) | VARCHAR2(5) NOT NULL |
BRON Last Prior Education field
05/24/05 - ICE1293104000 - Field length from 2 to 5
Prompt Table: SSR_PRE_EDU_NLD |
66 | POSTAL_OTHER | Character(12) | VARCHAR2(12) NOT NULL | Postal Other |
67 | TERM_BEGIN_DT | Date(10) | DATE | Term Begin Date |
68 | SAD_BR_IN_DIPL_NLD | Character(1) | VARCHAR2(1) NOT NULL |
BRON Indication Diploma
Default Value: N |
69 | SAD_BR_FUNDING_NLD | Character(1) | VARCHAR2(1) NOT NULL |
Funding Indicator
Default Value: N |
70 | SAD_BR_IN_TUIT_NLD | Character(1) | VARCHAR2(1) NOT NULL | Indication Tuition |
71 | SAD_BR_BPV_SEQ_NLD | Number(2,0) | SMALLINT NOT NULL | BPV sequence number |
72 | SAD_BR_EDT_BPV_NLD | Date(10) | DATE | BRON Contractdate BPV |
73 | SAD_BR_BDT_BPV_NLD | Date(10) | DATE | BRON BPV begin date |
74 | SAD_BR_PDT_BPV_NLD | Date(10) | DATE | Planned End Date BPV |
75 | SAD_BR_RDT_BPV_NLD | Date(10) | DATE | Real end date BPV |
76 | SAD_BR_INTSHIP_NLD | Character(40) | VARCHAR2(40) NOT NULL | BRON Internship Company |
77 | SAD_BR_HRS_BPV_NLD | Number(4,0) | SMALLINT NOT NULL | BRON Hours BPV |
78 | EXAM_DT | Date(10) | DATE | Exam Date |
79 | SAD_BR_NEW_ARR_NLD | Character(1) | VARCHAR2(1) NOT NULL |
BRON New Arrival
Default Value: N |
80 | UNITS_ACAD_PROG | Number(6,2) | DECIMAL(5,2) NOT NULL | Academic Progress Units |
81 | SAD_BR_SUB_SEQ_NLD | Number(2,0) | SMALLINT NOT NULL | Subject Sequence Number |
82 | SAD_BR_NT2_ABI_NLD | Character(2) | VARCHAR2(2) NOT NULL |
NT2 Ability
01=Speaking 02=Listening 03=Reading 04=Writing 05=Conversation |
83 | GRADE_DT | Date(10) | DATE | Grade Date |
84 | SAD_BR_NT2_ST_NLD | Character(2) | VARCHAR2(2) NOT NULL | NT2 Start Level |
85 | SAD_BR_NT2_END_NLD | Character(2) | VARCHAR2(2) NOT NULL | NT2 End Level |
86 | ACAD_YEAR | Character(4) | VARCHAR2(4) NOT NULL | Academic Year |
87 | SAD_BR_EXA_RES_NLD | Character(1) | VARCHAR2(1) NOT NULL |
BRON Exam Result
A=Rejected C=Cum Laude D=Certificates G=Passed T=Withdrawal |
88 | SAD_BR_DESC150_NLD | Character(150) | VARCHAR2(150) NOT NULL | Title Paper |
89 | SAD_BR_RES_PRA_NLD | Character(1) | VARCHAR2(1) NOT NULL |
Result Paper
G=Good O=Insufficient V=Adequate |
90 | SAD_BR_APL_PRA_NLD | Character(1) | VARCHAR2(1) NOT NULL |
Application Paper
D=Dispensation G=In exam Year I=Exchanged for Diploma V=Passed without Grade |
91 | ACAD_PROG | Character(5) | VARCHAR2(5) NOT NULL |
Academic Program
Prompt Table: ACAD_PROG_TBL |
92 | EFFDT | Date(10) | DATE | Effective Date |
93 | EFFSEQ | Number(3,0) | SMALLINT NOT NULL | Effective Sequence |
94 | SAD_BR_EX_CRSE_NLD | Character(4) | VARCHAR2(4) NOT NULL | Exam Subject |
95 | SAD_BR_EXA_LVL_NLD | Character(3) | VARCHAR2(3) NOT NULL | Program Level |
96 | SAD_BR_DPL_SBJ_NLD | Character(1) | VARCHAR2(1) NOT NULL |
Diploma Subject
Default Value: N |
97 | SAD_BR_APL_DPL_NLD | Character(1) | VARCHAR2(1) NOT NULL |
Appl. result exam subject
D=Dispensation G=In exam Year I=Exchanged for Diploma V=Passed without Grade |
98 | SAD_BR_IND_PAP_NLD | Character(1) | VARCHAR2(1) NOT NULL |
Indication Paper
Default Value: N |
99 | SAD_BR_RS_SCEX_NLD | Character(1) | VARCHAR2(1) NOT NULL |
Result Schoolexam
G=Good O=Insufficient V=Adequate |
100 | SAD_BR_GR_SCEX_NLD | Number(3,0) | SMALLINT NOT NULL | Grade School Exam |
101 | SAD_BR_GRA_CE1_NLD | Number(3,0) | SMALLINT NOT NULL | Grade Central Exam 1 |
102 | SAD_BR_GRA_CE2_NLD | Number(3,0) | SMALLINT NOT NULL | Grade Central exam 2 |
103 | SAD_BR_GRA_CE3_NLD | Number(3,0) | SMALLINT NOT NULL | Grade Central Exam 3 |
104 | SAD_BR_FI_GRA1_NLD | Number(2,0) | SMALLINT NOT NULL | Grade final exam 1 |
105 | SAD_BR_FI_GRA2_NLD | Number(2,0) | SMALLINT NOT NULL | Grade final exam 2 |
106 | SAD_BR_FI_GRA3_NLD | Number(2,0) | SMALLINT NOT NULL | Grade final exam 3 |
107 | SAD_BR_GRA_LST_NLD | Number(2,0) | SMALLINT NOT NULL | Grade Gradelist |
108 | SAD_BR_NXT_TRM_NLD | Character(1) | VARCHAR2(1) NOT NULL |
Indicator Enrollment Next Term
Default Value: N |
109 | SAD_BR_CERTIF_NLD | Character(1) | VARCHAR2(1) NOT NULL |
Indicator Certificate
Default Value: N |
110 | SAD_BR_DT_REC_NLD | Date(10) | DATE | Date Received by BRON |
111 | SAD_BR_DT_REP_NLD | Date(10) | DATE | BRON Report date |
112 | SAD_BR_REC_STA_NLD | Character(1) | VARCHAR2(1) NOT NULL |
Record Status
A=Rejected C=Created G=Approved V=Sent |
113 | SAD_BR_PST_GBA_NLD | Character(6) | VARCHAR2(6) NOT NULL | Postal According GBA |
114 | SAD_BR_CTY_GBA_NLD | Character(4) | VARCHAR2(4) NOT NULL | Birth Country |
115 | SAD_BR_CTY_PA1_NLD | Character(4) | VARCHAR2(4) NOT NULL | BirthCountry Parent 1 |
116 | SAD_BR_GBA_SX1_NLD | Character(1) | VARCHAR2(1) NOT NULL | Sex Parent 1 |
117 | SAD_BR_CTY_PA2_NLD | Character(4) | VARCHAR2(4) NOT NULL | Birthcountry Parent 2 |
118 | SAD_BR_GBA_SX2_NLD | Character(1) | VARCHAR2(1) NOT NULL | Sex Parent 2 |
119 | SAD_BR_CTY_ENT_NLD | Date(10) | DATE | Date immigration NL |
120 | SAD_BR_CTY_LVE_NLD | Date(10) | DATE | Date of Leaving NL |
121 | SAD_BR_GBA_CTY_NLD | Character(4) | VARCHAR2(4) NOT NULL | Left to Country |
122 | SAD_BR_GBA_NA1_NLD | Character(4) | VARCHAR2(4) NOT NULL | Nationality 1 |
123 | SAD_BR_GBA_DN1_NLD | Date(10) | DATE | Date Nationality 1 |
124 | SAD_BR_GBA_NA2_NLD | Character(4) | VARCHAR2(4) NOT NULL | Nationality 2 |
125 | SAD_BR_GBA_DN2_NLD | Date(10) | DATE | Date Nationality 2 |
126 | SAD_BR_GBA_RES_NLD | Character(2) | VARCHAR2(2) NOT NULL | Resident |
127 | SAD_BR_GBA_STT_NLD | Date(10) | DATE | Start date Resident |
128 | SAD_BR_GBA_END_NLD | Date(10) | DATE | End Date resident |
129 | SAD_BR_GBA_DEA_NLD | Date(10) | DATE | Date of Death |
130 | SAD_BR_RECID_NLD | Character(20) | VARCHAR2(20) NOT NULL | BRON Record Identification |
131 | SAD_BR_SIGNAL_NLD | Character(3) | VARCHAR2(3) NOT NULL | BRON Signal |
132 | SAD_BR_GRA_SIG_NLD | Character(1) | VARCHAR2(1) NOT NULL |
Severity of BRON signal
A=Rejected S=Signal |
133 | ACAD_PLAN | Character(10) | VARCHAR2(10) NOT NULL | Academic Plan |
134 | SAD_BR_CIJF_PRA_NL | Number(3,0) | SMALLINT NOT NULL | BRON VAVO field for interface change 8.4.0. |
135 | SAD_BR_COM_CIJF_NL | Character(1) | VARCHAR2(1) NOT NULL | BRON VAVO field for interface change 8.4.0. |
136 | SAD_BR_HIGHLVL_NL | Character(4) | VARCHAR2(4) NOT NULL | BRON VAVO field for interface change 8.4.0. |
137 | SAD_BR_EXT_ORG_NLD | Character(11) | VARCHAR2(11) NOT NULL | Field used to store EXT_ORG_ID for BRON delivery |
138 | SAD_BR_ORG_LOC_NLD | Number(3,0) | SMALLINT NOT NULL | Field used to store ORG LOCATION external organization for BRON delivery |
139 | SAD_BR_KCID_NLD | Character(11) | VARCHAR2(11) NOT NULL | Field used to store knowledge centre ID for BRON |
140 | SCC_LOB_CODE_NLD | Character(10) | VARCHAR2(10) NOT NULL | Lob Code |
141 | SAD_BR_HEG_BPV_NLD | Character(5) | VARCHAR2(5) NOT NULL | Field used to store CREBO code BPV students for BRON |
142 | SAD_BR_NM_BPV_NLD | Character(80) | VARCHAR2(80) NOT NULL | Field used to store descr name external Org for BRON |
143 | SAD_BR_PST_BPV_NLD | Character(12) | VARCHAR2(12) NOT NULL | Field used to store postcode external organization for BRON delivery |
144 | SAD_BR_NUM1_NLD | Number(5,0) | INTEGER NOT NULL | Field used to store house number external organization for BRON delivery |
145 | SAD_BR_ENRLEND_NLD | Character(2) | VARCHAR2(2) NOT NULL |
Enrollment End Reason
01=1. No Personal Reason 02=2. Personal Reasons 03=3. Institution Based 04=4. Program and Career based 05=5. Job Market/External 06=6. No diploma needed 07=7. Unknown 08=8. No End Reason |
146 | SAD_BR_FND_BY_NLD | Character(2) | VARCHAR2(2) NOT NULL |
Funded By
1=County 2=Participant 3=School 4=Government 5=Advanced Special Education 6=Institution |
147 | SAD_BR_COM_GRD_NLD | Number(2,0) | SMALLINT NOT NULL | Combination Grade |
148 | SAD_BR_EXM_CMP_NLD | Character(1) | VARCHAR2(1) NOT NULL |
Examination Component
A=General P=Specialization T=Test V=Elective |