SAD_BR_OOE_NLD(SQL Table) |
Index Back |
|---|---|
BRON SnapshotBRON Snapshot, |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  SAD_BR_RCTP_SN_NLD |
Character(3) | VARCHAR2(3) NOT NULL |
Recordtype Snapshot
BPV=BPV CTR=CTR EVA=EVA EXN=EXN FTO=FTO GEO=GEO GTR=GTR IBP=IBP IFO=IFO ISG=ISG OOE=OOE VED=VED VRD=VRD VVA=VVA Default Value: OOE |
| 2 | SAD_BR_EDU_SEC_NLD |
Character(2) | VARCHAR2(2) NOT NULL |
Educational Sector
BO=Professional Education ED=Education VA=VAVO Default Value: BO |
| 3 | SAD_BR_CONS_DT_NLD |
Date(10) | DATE NOT NULL | Consolidation Date |
| 4 | SAD_BR_SN_STAT_NLD |
Character(1) | VARCHAR2(1) NOT NULL |
Status Snapshot
1=1st snapshot 2=2nd Snapshot A=Actual snapshot D=Final Snapshot V=Provisional V=Provisional |
| 5 | SCC_BRINCD_NLD |
Character(4) | VARCHAR2(4) NOT NULL |
BRINcode
Prompt Table: SCC_BRINCD_NLD |
| 6 | NATIONAL_ID |
Character(20) | VARCHAR2(20) NOT NULL | National ID |
| 7 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 8 | SAD_BR_ENR_ST_DT | Date(10) | DATE | Eff Enrollment Start Date |
| 9 | SAD_BR_SEX_NLD | Character(1) | VARCHAR2(1) NOT NULL |
BRON Sex
M=Male O=Unknown V=Female |
| 10 | BIRTHDATE | Date(10) | DATE | Date of Birth |
| 11 | POSTAL | Character(12) | VARCHAR2(12) NOT NULL | Postal |
| 12 | SAD_BR_GBA_DEA_NLD | Date(10) | DATE | Date of Death |
| 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_CTY_GBA_NLD | Character(4) | VARCHAR2(4) NOT NULL | Birth Country |
| 16 | SAD_BR_CTY_PA1_NLD | Character(4) | VARCHAR2(4) NOT NULL | BirthCountry Parent 1 |
| 17 | SAD_BR_GBA_SX1_NLD | Character(1) | VARCHAR2(1) NOT NULL | Sex Parent 1 |
| 18 | SAD_BR_CTY_PA2_NLD | Character(4) | VARCHAR2(4) NOT NULL | Birthcountry Parent 2 |
| 19 | SAD_BR_GBA_SX2_NLD | Character(1) | VARCHAR2(1) NOT NULL | Sex Parent 2 |
| 20 | SAD_BR_GBA_CTY_NLD | Character(4) | VARCHAR2(4) NOT NULL | Left to Country |
| 21 | SAD_BR_GBA_RES_NLD | Character(2) | VARCHAR2(2) NOT NULL | Resident |
| 22 | SAD_BR_GBA_NA1_NLD | Character(4) | VARCHAR2(4) NOT NULL | Nationality 1 |
| 23 | SAD_BR_GBA_NA2_NLD | Character(4) | VARCHAR2(4) NOT NULL | Nationality 2 |
| 24 | SAD_BR_AGE1_NLD | Number(2,0) | SMALLINT NOT NULL | Age on date 1 |
| 25 | SAD_BR_AGEDT1_NLD | Date(10) | DATE NOT NULL | Age date 1 |
| 26 | SAD_BR_AGE2_NLD | Number(2,0) | SMALLINT NOT NULL | Age on date 2 |
| 27 | SAD_BR_AGEDT2_NLD | Date(10) | DATE NOT NULL | Agedate 2 |
| 28 | SAD_BR_AGE3_NLD | Number(2,0) | SMALLINT NOT NULL | Age on date 3 |
| 29 | SAD_BR_AGEDT3_NLD | Date(10) | DATE NOT NULL | Agedate 3 |
| 30 | SAD_BR_AGE4_NLD | Number(3,0) | SMALLINT NOT NULL | Age on date 4 |
| 31 | SAD_BR_AGEDT4_NLD | Date(10) | DATE NOT NULL | Agedate 4 |
| 32 | SAD_BR_AGE5_NLD | Number(2,0) | SMALLINT NOT NULL | Age on date 5 |
| 33 | SAD_BR_AGEDT5_NLD | Date(10) | DATE | Agedate 5 |