SAD_UC_ENT_PTM(SQL Table) |
Index Back |
---|---|
UCAS Entry point mapping |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | INSTITUTION | Character(5) | VARCHAR2(5) NOT NULL |
Academic Institution
Default Value: OPR_DEF_TBL_CS.INSTITUTION Prompt Table: INSTITUTION_TBL |
2 | SAD_UC_ENTRY_POINT | Number(1,0) | SMALLINT NOT NULL |
UCAS Entry Point
Default Value: 0 |
3 | ACAD_CAREER | Character(4) | VARCHAR2(4) NOT NULL |
Academic Career
BAC=Bachelor (NLD) BBL=Vocational Coaching (NLD) BOL=Vocational Training (NLD) BUSN=Graduate Business CNED=Continuing Education CRED=Semester Credit EDU=Education (NLD) EXED=Extended Education GRAD=Graduate LAW=Law MEDS=Medical School NONA=Non Award PGRD=Postgraduate RSCH=Research TECH=Technical UENG=Undergraduate Engineering UGRD=Undergraduate VAVO=Advanced General Educ. (NLD) VETM=Veterinary Medicine |
4 | ACADEMIC_LEVEL | Character(3) | VARCHAR2(3) NOT NULL |
Academic Level
00=Not Set 01=First Year 02=Second Year 03=Third Year 04=Fourth Year 05=Fifth Year 06=Sixth Year 10=Freshman 20=Sophomore 30=Junior 40=Senior 50=Post-Bacc Undergraduate GR=Graduate GRA=Graduate AUS HON=Honours IE=Industrial Experience MAS=Masters P1=Professional Year 1 P2=Professional Year 2 P3=Professional Year 3 P4=Professional Year 4 PHD=PhD |
5 | SSR_YR_OF_PROG | Character(4) | VARCHAR2(4) NOT NULL |
Year of Program
00=Not Set 01=01 - First Year 02=02 - Second Year 03=03 - Third Year 04=04 - Fourth Year 05=05 - Fifth Year 06=06 - Sixth Year |