SAD_UC_I_GCOURS

(SQL Table)
Index Back

cvgCourse

Staging table for storing UCAS view cvgCourse

# 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_MODULAR Character(1) VARCHAR2(1) NOT NULL Modular
N=No
Y=Yes
8 SAD_UC_PARTTIME Character(1) VARCHAR2(1) NOT NULL Part Time
B=Both Full time and Part time
F=Full time Only
P=Part Time only
9 SAD_UC_TIMESTAMP DateTime(26) TIMESTAMP NOT NULL Timestamp
10 SAD_UC_VACSTATUS Character(1) VARCHAR2(1) NOT NULL Vacancy Status
B=Vacancies Full and Part time
F=Vacancies for Full time
P=Vacancies for Part Time
11 SAD_UC_LONGNAME Character(100) VARCHAR2(100) NOT NULL Long Name
12 SAD_UC_CRSECANC Character(1) VARCHAR2(1) NOT NULL Course Cancelled
13 SAD_UC_CANCDATE DateTime(26) TIMESTAMP Course Cancelled Date
14 SAD_UC_ENGLISH Character(1) VARCHAR2(1) NOT NULL GCSE English
1=Obtained GCSE or equivalent
2=Taking GCSE in the coming year
3=Wishes to take special test
9=Only applying for FE courses
15 SAD_UC_MATHS Character(1) VARCHAR2(1) NOT NULL GCSE Mathematics
1=Obtained GCSE or equivalent
2=Taking GCSE in the coming year
3=Wishes to take special test
9=Only applying for FE courses
16 SAD_UC_SCIENCE Character(1) VARCHAR2(1) NOT NULL Science
0=Not required
1=Obtained GCSE or equivalent
2=Taking GCSE in the coming year
3=Wishes to take special test
9=Only applying for FE courses
17 SAD_UC_AGE Character(1) VARCHAR2(1) NOT NULL Age Range of Children
M=Middle
P=Primary
S=Secondary
18 SAD_UC_STATUS Character(20) VARCHAR2(20) NOT NULL Status
19 SAD_UC_CRIMCHK_REQ Character(1) VARCHAR2(1) NOT NULL Criminal Check Required

Y/N Table Edit

Default Value: N