SSR_BR_BPV_RO

(SQL Table)
Index Back

BPV Record for RO

BPV Record for RO 2020-04-15 bug 31180485 - enlarged enrollment seq nbr

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SSR_BR_REC_TYPE Character(3) VARCHAR2(3) NOT NULL Record Type
2 SAD_SL_SOFI_NBR Character(9) VARCHAR2(9) NOT NULL Social Fiscal Number
3 SSR_BR_NAT_ID_NLD Character(20) VARCHAR2(20) NOT NULL Educational Number
4 SSR_BR_ENRL_SQ_NLD Character(20) VARCHAR2(20) NOT NULL 2020-04-15 bug 31180485 - enlarged enrollment seq nbr
5 SAD_BR_BPV_SEQ_NLD Number(2,0) SMALLINT NOT NULL BPV sequence number
6 SAD_BR_BPV_CRT_DT Date(10) DATE NOT NULL BPV End Date for BRON
7 SAD_BR_BDT_BPV_NLD Date(10) DATE NOT NULL BRON BPV begin date
8 SAD_BR_PDT_BPV_NLD Date(10) DATE NOT NULL Planned End Date BPV
9 SAD_BR_RDT_BPV_NLD Date(10) DATE Real end date BPV
10 SAD_BR_HRS_BPV_NLD Number(4,0) SMALLINT NOT NULL BRON Hours BPV
11 SAD_BR_INTSHIP_NLD Character(40) VARCHAR2(40) NOT NULL BRON Internship Company
12 HEGIS_CODE Character(8) VARCHAR2(8) NOT NULL HEGIS Code
13 SSR_BR_CD_ELECTIVE Character(5) VARCHAR2(5) NOT NULL Field used to store CREBO code BPV students for BRON
14 SCC_BRINCD_NLD Character(4) VARCHAR2(4) NOT NULL BRINcode
15 SSR_BR_ST_DT_NLD Date(10) DATE Start Date
16 SSR_BR_END_DT_NLD Date(10) DATE End Date
17 SSR_BR_CREATE_DT Date(10) DATE Creation Date