SAD_UC_I_GCOURS(SQL Table) |
Index Back |
---|---|
cvgCourseStaging 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 |