SSR_BR_ZEHO_NLD

(SQL Table)
Index Back

Prior Ed ho enrl(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_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 SCC_SUBBRINCD_NLD Character(2) VARCHAR2(2) NOT NULL Sub Institute
11 CIP_CODE Character(13) VARCHAR2(13) NOT NULL CIP code
12 SSR_BR_ED_PHS_NLD Character(1) VARCHAR2(1) NOT NULL Educational phase
1=Eerste fase
2=Tweede fase
A=Associate Degree
B=Bachelor
D=Propedeuse bachelor
H=Kort hbo
I=Initi�le opleiding
K=Kandidaats
L=Universitaire lerarenopleiding
M=Master
O=Oude stijl
P=Propedeuse
Q=Postiniti�le Master-opleiding
T=Tussentijds doctoraal examen
V=Vervolgopleiding
W=Voortgezette opleiding