SAD_BR_IFO_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: IFO |
| 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 | CREATION_DT | Date(10) | DATE NOT NULL | Creation Date |
| 7 | SAD_BR_DT_REC_NLD | Date(10) | DATE | Date Received by BRON |
| 8 | SAD_BR_ACC_DT_NLD | Date(10) | DATE | Receipt date Accountant |
| 9 | SAD_BR_DT_REP_NLD | Date(10) | DATE | BRON Report date |
| 10 | SAD_BR_ACTOT_NLD | Number(20,0) | DECIMAL(20) NOT NULL | Control total accountant |