SSR_BR_RST_CONV(SQL Table) |
Index Back |
|---|---|
Results Conversion 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_BR_MONTH_FROM | Number(2,0) | SMALLINT NOT NULL | Maand vanaf |
| 10 | SSR_BR_MONTH_UNTIL | Number(2,0) | SMALLINT NOT NULL | Maand tot |
| 11 | END_DT_MONTH | Number(2,0) | SMALLINT NOT NULL | Month |
| 12 | SSR_BR_RSLT_CD_NLD | Character(1) | VARCHAR2(1) NOT NULL | Result Code |
| 13 | SAD_SL_BRIN_CODE | Character(4) | VARCHAR2(4) NOT NULL | Brincode institution |
| 14 | SSR_BR_ISAT_NLD | Character(4) | VARCHAR2(4) NOT NULL | ISAT |
| 15 | SAD_SL_PROG_CODE | Character(5) | VARCHAR2(5) NOT NULL | Program Code |
| 16 | SAD_SL_TRANS_DTTM | DateTime(26) | TIMESTAMP | Transaction DateTime |
| 17 | SAD_TEMPRSEQNR_NLD | Character(20) | VARCHAR2(20) NOT NULL | Result Sequence Number |
| 18 | SCC_SUBBRINCD_NLD | Character(2) | VARCHAR2(2) NOT NULL | Sub Institute |
| 19 | SSR_BR_AC_LDAP_NLD | Character(2) | VARCHAR2(2) NOT NULL |
Approved Academic Load
DT=Part-Time DU=Dual VT=Full-Time |
| 20 | 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 |
| 21 | SSR_BR_FRST_DT_NLD | Date(10) | DATE | First Date delivered |
| 22 | SSR_BR_FSTDEGR_NLD | Character(1) | VARCHAR2(1) NOT NULL | First degree |
| 23 | SAD_BR_ENR_END_DT | Date(10) | DATE | Enrollment End Date |
| 24 | SAD_SL_SOFI_NBR | Character(9) | VARCHAR2(9) NOT NULL | Social Fiscal Number |
| 25 | SAD_SL_O_NBR | Character(9) | VARCHAR2(9) NOT NULL | Onumber |
| 26 | SSR_BRHO_RESEQ_NLD | Character(20) | VARCHAR2(20) NOT NULL | BRON Result Seq Nbr |
| 27 | SAD_SL_SUBINST | Character(2) | VARCHAR2(2) NOT NULL | Sub Institute |
| 28 | SAD_BR_DIPL_DT_NLD | Date(10) | DATE | Diploma Completed Date |