SAD_BR_CTR_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: IBP |
| 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 | SAD_BR_TOT_MUT_NLD | Number(6,0) | INTEGER NOT NULL | Total Mutations |
| 7 | SAD_BR_NR_BPV_NLD | Number(6,0) | INTEGER NOT NULL | Total BPV |
| 8 | SAD_BR_NR_EX_NLD | Number(6,0) | INTEGER NOT NULL | Total Exams |
| 9 | SAD_BR_NR_IBP_NLD | Number(6,0) | INTEGER NOT NULL | Total IBPs |
| 10 | SAD_BR_NR_EVA_NLD | Number(6,0) | INTEGER NOT NULL | Total Exams VAVO |
| 11 | SAD_BR_NR_VVA_NLD | Number(6,0) | INTEGER NOT NULL | Total Results VAVO |
| 12 | SAD_BR_NR_GEO_NLD | Number(6,0) | INTEGER NOT NULL | Total Generic Test |