SSR_BR_ISP_OBO

(SQL Table)
Index Back

Enrollment Period Data Rec RO

Enrollment Period Data Record for RO 2020-04-15 bug 31180485 - enlarged enrollment seq nbr /* 2020-04-27: Changes for bug 31180515 */

# 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 SSR_BR_ENR_ST_DT Date(10) DATE NOT NULL Start Date
6 SSR_BR_ACAD_YR Character(4) VARCHAR2(4) NOT NULL Academic Year
7 SCC_BRINCD_NLD Character(4) VARCHAR2(4) NOT NULL BRINcode
8 SSR_BR_CREATE_DT Date(10) DATE Creation Date
9 HEGIS_CODE Character(8) VARCHAR2(8) NOT NULL HEGIS Code
10 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
11 SSR_BR_LVL_OBO_NLD Character(5) VARCHAR2(5) NOT NULL BRON Level
12 SSR_BR_FUNDING_NLD Character(1) VARCHAR2(1) NOT NULL Funding Indicator
N=No
Y=Yes
13 SSR_BR_OCT_1ST Character(1) VARCHAR2(1) NOT NULL Indication specifies whether the Enrollment is valid on Tally date October 1st
J=Yes
N=No
14 SSR_BR_DEC_1ST Character(1) VARCHAR2(1) NOT NULL Indication specifies whether the Enrollment is valid on Tally date December 1st
J=Yes
N=No
15 SSR_BR_LEARNR_NLD Character(4) VARCHAR2(4) NOT NULL Learning Path
DLR=Continuous Learning Route
GLR=Integrated Learning Route
16 SSR_BR_LEARNF_NLD Character(4) VARCHAR2(4) NOT NULL Learning Phase
MBO=MBO
VO=VO