SSR_BR_ZEBO_NLD

(SQL Table)
Index Back

Prior Ed mbo enrl(staging)

/* 2020-04-27: Changes for bug 31180515 */

# 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_PE_ERSQ_NLD Character(20) VARCHAR2(20) NOT NULL Prior Education Enrol Seq Number
6 SSR_BR_ED_PRV_NLD Character(7) VARCHAR2(7) NOT NULL BRON Education provider for VAVO
7 SSR_BR_LOC_CD_NLD Character(12) VARCHAR2(12) NOT NULL Location Code
8 ENROLLMENT_DT Date(10) DATE Original Enrollment Date
9 SSR_BR_ENR_END_DT Date(10) DATE Enrollment End Date
10 SSR_BR_LEAVEDT_NLD Date(10) DATE Planned Leave Date
11 HEGIS_CODE Character(8) VARCHAR2(8) NOT NULL HEGIS Code
12 SSR_BR_LVL_NLD Character(1) VARCHAR2(1) NOT NULL /* 2021-10-13: fix for Bug-ID: 32929597 - RIOv3 */ Additional translate value U.
1=MBO-1
2=MBO-2
3=MBO-3
4=MBO-4
U=Undetermined
13 SSR_BR_CAREER_NLD Character(3) VARCHAR2(3) NOT NULL 15-04-2020 changes for bug 30723216
BBL=BBL
BLT=BBL_DT
BOL=BOL
BOT=BOL_DT
CBL=CBL
CBT=CBL_DT
CLD=COL_DT
COL=COL
EX=EX
ODT=ODT
OVO=Other Education
14 SSR_BR_LEARNR_NLD Character(4) VARCHAR2(4) NOT NULL Learning Path
DLR=Continuous Learning Route
GLR=Integrated Learning Route
15 SSR_BR_LEARNF_NLD Character(4) VARCHAR2(4) NOT NULL Learning Phase
MBO=MBO
VO=VO