SSR_BR_ENRL_DEL (SQL Table)	Index Back
BRON HO Msg Stage Table BRON HO Delivery of Enrollment Msg Stage Table

SSR_BR_ENRL_DEL

(SQL Table)

BRON HO Msg Stage Table

BRON HO Delivery of Enrollment Msg Stage Table

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SAD_SL_TRANS_INOUT Character(1) VARCHAR2(1) NOT NULL Transaction Direction
I=Inbound
O=Outbound

2 SAD_SL_TRANS_DTTM DateTime(26) TIMESTAMP Transaction DateTime

3 SAD_SL_TRANS_SEQ Number(3,0) SMALLINT NOT NULL Sequence Number

4 SSR_BR_INDEXID_NLD Character(50) VARCHAR2(50) NOT NULL Index ID

5 SAD_SL_STUD_NBR Character(12) VARCHAR2(12) NOT NULL Student Number

6 SSR_BRHO_ENRSQ_NLD Character(20) VARCHAR2(20) NOT NULL BRON Enrolment Seq Nbr

7 SAD_SL_SOFI_NBR Character(9) VARCHAR2(9) NOT NULL Social Fiscal Number

8 SAD_SL_O_NBR Character(9) VARCHAR2(9) NOT NULL Onumber

9 SCC_BRINCD_NLD Character(4) VARCHAR2(4) NOT NULL BRINcode

10 SCC_SUBBRINCD_NLD Character(2) VARCHAR2(2) NOT NULL Sub Institute

11 SSR_FORM_STUDY_NLD Character(4) VARCHAR2(4) NOT NULL Form of Study Higher Education
A=Auditor
D=Participant
E=Extraneus
S=Student
T=Coop/Dual

12 HEGIS_CODE Character(8) VARCHAR2(8) NOT NULL HEGIS Code

13 SSR_BR_AC_LDAP_NLD Character(2) VARCHAR2(2) NOT NULL Approved Academic Load
DT=Part-Time
DU=Dual
VT=Full-Time

14 SSR_ACAD_LEVEL_NLD Character(4) VARCHAR2(4) NOT NULL Academ. Level Higher Education
A=Associate Degree
B=Bachelor
D=Propaedeutic Bachelor
H=Main
I=Initial Phase
K=Candidate
L=University teacher education
M=Master
P=Propaedeutic Phase
Q=Post-Initial
T=Interim Doctoral Exam
V=Continuation Phase
W=Continuing study

15 ENROLLMENT_DT Date(10) DATE Original Enrollment Date

16 SAD_BR_ENR_END_DT Date(10) DATE Enrollment End Date

17 SSR_BR_END_RSN_NLD Character(80) VARCHAR2(80) NOT NULL Funding Source

18 SSR_FUNDING_CD_NLD Character(1) VARCHAR2(1) NOT NULL Funding Applies

19 SSR_BR_INTPRG_NLD Character(1) VARCHAR2(1) NOT NULL Indication Intensive Program
0=No
1=Yes
Default Value: 0

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SAD_SL_TRANS_INOUT	Character(1)	VARCHAR2(1) NOT NULL	Transaction Direction I=Inbound O=Outbound
2	SAD_SL_TRANS_DTTM	DateTime(26)	TIMESTAMP	Transaction DateTime
3	SAD_SL_TRANS_SEQ	Number(3,0)	SMALLINT NOT NULL	Sequence Number
4	SSR_BR_INDEXID_NLD	Character(50)	VARCHAR2(50) NOT NULL	Index ID
5	SAD_SL_STUD_NBR	Character(12)	VARCHAR2(12) NOT NULL	Student Number
6	SSR_BRHO_ENRSQ_NLD	Character(20)	VARCHAR2(20) NOT NULL	BRON Enrolment Seq Nbr
7	SAD_SL_SOFI_NBR	Character(9)	VARCHAR2(9) NOT NULL	Social Fiscal Number
8	SAD_SL_O_NBR	Character(9)	VARCHAR2(9) NOT NULL	Onumber
9	SCC_BRINCD_NLD	Character(4)	VARCHAR2(4) NOT NULL	BRINcode
10	SCC_SUBBRINCD_NLD	Character(2)	VARCHAR2(2) NOT NULL	Sub Institute
11	SSR_FORM_STUDY_NLD	Character(4)	VARCHAR2(4) NOT NULL	Form of Study Higher Education A=Auditor D=Participant E=Extraneus S=Student T=Coop/Dual
12	HEGIS_CODE	Character(8)	VARCHAR2(8) NOT NULL	HEGIS Code
13	SSR_BR_AC_LDAP_NLD	Character(2)	VARCHAR2(2) NOT NULL	Approved Academic Load DT=Part-Time DU=Dual VT=Full-Time
14	SSR_ACAD_LEVEL_NLD	Character(4)	VARCHAR2(4) NOT NULL	Academ. Level Higher Education A=Associate Degree B=Bachelor D=Propaedeutic Bachelor H=Main I=Initial Phase K=Candidate L=University teacher education M=Master P=Propaedeutic Phase Q=Post-Initial T=Interim Doctoral Exam V=Continuation Phase W=Continuing study
15	ENROLLMENT_DT	Date(10)	DATE	Original Enrollment Date
16	SAD_BR_ENR_END_DT	Date(10)	DATE	Enrollment End Date
17	SSR_BR_END_RSN_NLD	Character(80)	VARCHAR2(80) NOT NULL	Funding Source
18	SSR_FUNDING_CD_NLD	Character(1)	VARCHAR2(1) NOT NULL	Funding Applies
19	SSR_BR_INTPRG_NLD	Character(1)	VARCHAR2(1) NOT NULL	Indication Intensive Program 0=No 1=Yes Default Value: 0