SSR_BR_ENR_CONV(SQL Table) |
Index Back |
|---|---|
BRON HO Conversion Pr Enrl RecBRON HO Conversion Process Enrollment Record |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SCC_BRINCD_NLD | Character(4) | VARCHAR2(4) NOT NULL | BRINcode |
| 2 | SAD_SL_CIOP_NBR | Character(12) | VARCHAR2(12) NOT NULL | Correspondence number |
| 3 | SAD_SL_STUD_NBR | Character(12) | VARCHAR2(12) NOT NULL | Student Number |
| 4 | 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 |
| 5 | ACAD_YEAR | Character(4) | VARCHAR2(4) NOT NULL | Academic Year |
| 6 | SSR_SL_PROG_CD_NLD | Character(5) | VARCHAR2(5) NOT NULL | Studielink Program Code |
| 7 | 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 |
| 8 | SAD_SL_ACAD_LOAD | Character(1) | VARCHAR2(1) NOT NULL |
Academic load
1=Full-time 2=Part-time 3=Dual |
| 9 | SSR_SL_STARTMO_NLD | Character(2) | VARCHAR2(2) NOT NULL | Start Month |
| 10 | END_DT_MONTH | Number(2,0) | SMALLINT NOT NULL | Month |
| 11 | SAD_SL_END_REASON | Character(1) | VARCHAR2(1) NOT NULL |
Reason for Ending
0=Student Suspended 1=Article 7.42.1a 2=Article 7.42.1d 3=Article 7.42.1c 4=HE and RP 1996 5=Article 7.42.1b 6=Post Exam 8=Death of Student 9=Article 7.42.1e |
| 12 | SSR_FUNDING_CD_NLD | Character(1) | VARCHAR2(1) NOT NULL | Funding Applies |
| 13 | SAD_SL_BRIN_CODE | Character(4) | VARCHAR2(4) NOT NULL | Brincode institution |
| 14 | SAD_SL_PROG_CODE | Character(5) | VARCHAR2(5) NOT NULL | Program Code |
| 15 | SSR_BR_ISAT_NLD | Character(4) | VARCHAR2(4) NOT NULL | ISAT |
| 16 | SSR_BR_AC_LDAP_NLD | Character(2) | VARCHAR2(2) NOT NULL |
Approved Academic Load
DT=Part-Time DU=Dual VT=Full-Time |
| 17 | SAD_SL_ENRL_MANNER | Character(1) | VARCHAR2(1) NOT NULL |
Enrolment Manner
A=Auditor D=Participant E=Extraneus S=Student T=Coop/Dual |
| 18 | ENROLLMENT_DT | Date(10) | DATE | Original Enrollment Date |
| 19 | SAD_BR_ENR_END_DT | Date(10) | DATE | Enrollment End Date |
| 20 | SSR_BR_END_RSN_NLD | Character(80) | VARCHAR2(80) NOT NULL | Funding Source |
| 21 | SAD_SL_TRANS_DTTM | DateTime(26) | TIMESTAMP | Transaction DateTime |
| 22 | SCC_SUBBRINCD_NLD | Character(2) | VARCHAR2(2) NOT NULL | Sub Institute |
| 23 | SAD_TEMPSEQNBR_NLD | Character(20) | VARCHAR2(20) NOT NULL | Enrollment Sequence Nbr |
| 24 | SAD_SL_ACAD_LEVEL | Character(1) | VARCHAR2(1) NOT NULL |
Academic Level
B=Bachelor D=Propaedeutic Bachelor H=Main I=Initial Phase M=Master P=Propaedeutic Phase V=Continuation Phase |
| 25 | SSR_BR_FRST_DT_NLD | Date(10) | DATE | First Date delivered |
| 26 | SSR_BR_EFST_DT_NLD | Number(1,0) | SMALLINT NOT NULL | First Enrollment Date |
| 27 | SSR_BR_INTPRG_NLD | Character(1) | VARCHAR2(1) NOT NULL |
Indication Intensive Program
0=No 1=Yes |
| 28 | SAD_SL_SOFI_NBR | Character(9) | VARCHAR2(9) NOT NULL | Social Fiscal Number |
| 29 | SAD_SL_O_NBR | Character(9) | VARCHAR2(9) NOT NULL | Onumber |
| 30 | SSR_BRHO_ENRSQ_NLD | Character(20) | VARCHAR2(20) NOT NULL | BRON Enrolment Seq Nbr |
| 31 | SAD_SL_SUBINST | Character(2) | VARCHAR2(2) NOT NULL | Sub Institute |