SAD_BR_FTO_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: FTO |
| 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 |