SAD_UC_REFCRS

(SQL View)
 Index Back

cvCourse

Staging table for storing UCAS view cvCourse

SELECT B.INSTITUTION ,B.SAD_UC_INST ,B.SAD_UC_COURSE ,B.SAD_UC_CAMPUS ,B.SAD_UC_ENTRYYEAR ,B.SAD_UC_ENTRYMONTH ,B.SAD_UC_TIMESTAMP ,B.SAD_UC_FACULTY ,B.SAD_UC_SHORTNAME ,B.SAD_UC_LONGNAME ,B.SAD_UC_JOINTADMS ,B.SAD_UC_OPENEXTRA ,B.SAD_UC_STATUS ,B.SAD_UC_STARTDATE ,B.SAD_UC_AGERESTR ,B.SAD_UC_COURSETYPE ,B.SAD_UC_IMPORTED ,B.SAD_UC_ACTIVE_IND ,B.sad_uc_intrv , B.sad_uc_portf_evid , B.SAD_UC_CRIMCHK_REQ FROM %Table(SAD_UC_I_COURSE) D , %Table(SAD_UC_COURSE) B WHERE D.INSTITUTION= B.INSTITUTION AND D.SAD_UC_INST = B.SAD_UC_INST AND D.SAD_UC_COURSE = B.SAD_UC_COURSE AND D.SAD_UC_CAMPUS =B.SAD_UC_CAMPUS AND D.SAD_UC_ENTRYYEAR = B.SAD_UC_ENTRYYEAR AND D.SAD_UC_ENTRYMONTH = B.SAD_UC_ENTRYMONTH

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution
2 SAD_UC_INST Character(3) VARCHAR2(3) NOT NULL UCAS Institution Code
3 SAD_UC_COURSE Character(4) VARCHAR2(4) NOT NULL UCAS Course Code
4 SAD_UC_CAMPUS Character(5) VARCHAR2(5) NOT NULL Campus
5 SAD_UC_ENTRYYEAR Number(4,0) SMALLINT NOT NULL Entry Year
6 SAD_UC_ENTRYMONTH Number(2,0) SMALLINT NOT NULL Entry Month
7 SAD_UC_TIMESTAMP DateTime(26) TIMESTAMP Timestamp
8 SAD_UC_FACULTY Character(20) VARCHAR2(20) NOT NULL Faculty
9 SAD_UC_SHORTNAME Character(20) VARCHAR2(20) NOT NULL Short Name
10 SAD_UC_LONGNAME Character(100) VARCHAR2(100) NOT NULL Long Name
11 SAD_UC_JOINTADMS Character(1) VARCHAR2(1) NOT NULL Joint Admission
12 SAD_UC_OPENEXTRA Character(1) VARCHAR2(1) NOT NULL Open Extra
13 SAD_UC_STATUS Character(20) VARCHAR2(20) NOT NULL Status
14 SAD_UC_STARTDATE DateTime(26) TIMESTAMP Start Date
15 SAD_UC_AGERESTR Character(1) VARCHAR2(1) NOT NULL Age Restriction
16 SAD_UC_COURSETYPE Character(1) VARCHAR2(1) NOT NULL Course Type
A=Art and Design
C=Former CATCH
D=Dentistry
M=Medicine
N=Former NMAS
V=Veterinary
17 SAD_UC_IMPORTED Character(1) VARCHAR2(1) NOT NULL Imported
18 SAD_UC_ACTIVE_IND Character(1) VARCHAR2(1) NOT NULL Active
19 SAD_UC_INTRV Character(1) VARCHAR2(1) NOT NULL Interview

Y/N Table Edit

20 SAD_UC_PORTF_EVID Character(1) VARCHAR2(1) NOT NULL Portfolio Required

Y/N Table Edit

21 SAD_UC_CRIMCHK_REQ Character(1) VARCHAR2(1) NOT NULL Criminal Check Required

Y/N Table Edit