SSR_BP_ZROV_NLD(SQL Table) |
Index Back |
|---|---|
Prior Ed va Rslt |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | SCC_BRINCD_NLD |
Character(4) | VARCHAR2(4) NOT NULL | BRINcode |
| 3 | SSR_BR_XRSL_SQ_NLD |
Character(20) | VARCHAR2(20) NOT NULL | Exam Result sequence Number |
| 4 | 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 |
| 5 | SSR_BR_ACD_YR_NLD | Character(4) | VARCHAR2(4) NOT NULL | Exam Regime Year |
| 6 | 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 |
| 7 | SSR_BR_RES_DT_NLD | Date(10) | DATE | Result Date |
| 8 | SSR_BR_OUTCOM_NLD | Character(1) | VARCHAR2(1) NOT NULL |
Outcome
A=Turned down D=Part exam G=Successful |
| 9 | SSR_BR_CUM_LAU_NLD | Character(1) | VARCHAR2(1) NOT NULL | Indication Cum Laude (Honors) |
| 10 | SSR_BR_PE_ERSQ_NLD | Character(20) | VARCHAR2(20) NOT NULL | Prior Education Enrol Seq Number |