SSR_BR_ZROV_NLD(SQL Table) |
Index Back |
|---|---|
Prior Ed va result (staging) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  SSR_BR_INDEX_ID |
Character(40) | VARCHAR2(40) NOT NULL | Transaction Index ID |
| 2 | SSR_BR_MSGUUID |
Character(50) | VARCHAR2(50) NOT NULL | Message ID |
| 3 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 4 | SCC_BRINCD_NLD |
Character(4) | VARCHAR2(4) NOT NULL | BRINcode |
| 5 | SSR_BR_XRSL_SQ_NLD |
Character(20) | VARCHAR2(20) NOT NULL | Exam Result sequence Number |
| 6 | SSR_BR_OUTCIND_NLD |
Character(1) | VARCHAR2(1) NOT NULL |
Outcome indicator only used as a static key in records MROV, MRPV, MRLV and MRGV records in VAVO
Default Value: Y |
| 7 | SSR_BR_ACD_YR_NLD | Character(4) | VARCHAR2(4) NOT NULL | Exam Regime Year |
| 8 | SCC_EDU_LEVEL_NLD | Character(4) | VARCHAR2(4) NOT NULL |
Education level
ATH=Atheneum BB=VMBO Basic Professional Ed GL=VMBO Mixed Professional Ed GYM=Gymnasium HA=HAVO HBO=College Degree KB=VMBO Kader Professional Ed KSB1=Kwalification Structure PrEd 1 KSB2=Kwalification Structure PrEd 2 KSB3=Kwalification Structure PrEd 3 KSB4=Kwalification Structure PrEd 4 TL=VMBO Theoretic Professional Ed VWO=VWO WO=University Degree |
| 9 | SSR_BR_RES_DT_NLD | Date(10) | DATE | Result Date |
| 10 | SSR_BR_OUTCOM_NLD | Character(1) | VARCHAR2(1) NOT NULL |
Outcome
A=Turned down D=Part exam G=Successful |
| 11 | SSR_BR_CUM_LAU_NLD | Character(1) | VARCHAR2(1) NOT NULL | Indication Cum Laude (Honors) |
| 12 | SSR_BR_PE_ERSQ_NLD | Character(20) | VARCHAR2(20) NOT NULL | Prior Education Enrol Seq Number |