SAD_BR_M411_NLD

(SQL Table)
Index Back

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution
2 SCC_BRINCD_NLD Character(4) VARCHAR2(4) NOT NULL BRINcode
3 SAD_BR_EDU_SEC_NLD Character(2) VARCHAR2(2) NOT NULL Educational Sector
BO=Professional Education
ED=Education
VA=VAVO
4 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
5 SAD_BR_GBA_DEA_NLD Date(10) DATE Date of Death
6 SAD_BR_PST_GBA_NLD Character(6) VARCHAR2(6) NOT NULL Postal According GBA
7 SAD_BR_FRM_DT_NLD Date(10) DATE Return From Date
8 SAD_BR_CTY_GBA_NLD Character(4) VARCHAR2(4) NOT NULL Birth Country
9 SAD_BR_CTY_PA1_NLD Character(4) VARCHAR2(4) NOT NULL BirthCountry Parent 1
10 SAD_BR_GBA_SX1_NLD Character(1) VARCHAR2(1) NOT NULL Sex Parent 1
11 SAD_BR_CTY_PA2_NLD Character(4) VARCHAR2(4) NOT NULL Birthcountry Parent 2
12 SAD_BR_GBA_SX2_NLD Character(1) VARCHAR2(1) NOT NULL Sex Parent 2
13 SAD_BR_CTY_ENT_NLD Date(10) DATE Date immigration NL
14 SAD_BR_CTY_LVE_NLD Date(10) DATE Date of Leaving NL
15 SAD_BR_GBA_CTY_NLD Character(4) VARCHAR2(4) NOT NULL Left to Country
16 SAD_BR_GBA_NA1_NLD Character(4) VARCHAR2(4) NOT NULL Nationality 1
17 SAD_BR_GBA_DN1_NLD Date(10) DATE Date Nationality 1
18 SAD_BR_GBA_NA2_NLD Character(4) VARCHAR2(4) NOT NULL Nationality 2
19 SAD_BR_GBA_DN2_NLD Date(10) DATE Date Nationality 2
20 SAD_BR_GBA_RES_NLD Character(2) VARCHAR2(2) NOT NULL Resident
21 SAD_BR_GBA_STT_NLD Date(10) DATE Start date Resident
22 SAD_BR_GBA_END_NLD Date(10) DATE End Date resident
23 SAD_BR_SIGNAL_NLD Character(3) VARCHAR2(3) NOT NULL BRON Signal