SAD_BR_BPV_NLD

#	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: BPV
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	NATIONAL_ID	Character(20)	VARCHAR2(20) NOT NULL	National ID
7	SAD_BR_ENRL_SQ_NLD	Character(3)	VARCHAR2(3) NOT NULL	Enrollment Sequence number
8	SAD_BR_BPV_SEQ_NLD	Number(2,0)	SMALLINT NOT NULL	BPV sequence number
9	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
10	ACAD_CAREER	Character(4)	VARCHAR2(4) NOT NULL	Academic Career BAC=Bachelor (NLD) BBL=Vocational Coaching (NLD) BOL=Vocational Training (NLD) BUSN=Graduate Business CNED=Continuing Education CRED=Semester Credit EDU=Education (NLD) EXED=Extended Education GRAD=Graduate LAW=Law MEDS=Medical School NONA=Non Award PGRD=Postgraduate RSCH=Research TECH=Technical UENG=Undergraduate Engineering UGRD=Undergraduate VAVO=Advanced General Educ. (NLD) VETM=Veterinary Medicine
11	STDNT_CAR_NBR	Number(3,0)	SMALLINT NOT NULL	Student Career Nbr
12	SAD_BR_BPV_CRT_DT	Date(10)	DATE NOT NULL	BPV End Date for BRON
13	SAD_BR_BDT_BPV_NLD	Date(10)	DATE NOT NULL	BRON BPV begin date
14	SAD_BR_PDT_BPV_NLD	Date(10)	DATE NOT NULL	Planned End Date BPV
15	SAD_BR_RDT_BPV_NLD	Date(10)	DATE	Real end date BPV
16	SAD_BR_HRS_BPV_NLD	Number(4,0)	SMALLINT NOT NULL	BRON Hours BPV
17	SAD_BR_INTSHIP_NLD	Character(40)	VARCHAR2(40) NOT NULL	BRON Internship Company