SAD_UC_UNITS

(SQL Table)
Index Back

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

Prompt Table: INSTITUTION_TBL

2 SAD_UC_UNITID Number(10,0) DECIMAL(10) NOT NULL Unit ID
3 SAD_UC_BOARDCODE Character(10) VARCHAR2(10) NOT NULL Board Code
4 SAD_UC_YEAR Number(4,0) SMALLINT NOT NULL School Year
5 SAD_UC_SITTING Character(1) VARCHAR2(1) NOT NULL Sitting
A=Autumn
S=Summer
W=Winter
6 SAD_UC_UNITCODE Character(12) VARCHAR2(12) NOT NULL Unit Code
7 SAD_UC_UNITTITLE Character(100) VARCHAR2(100) NOT NULL Unit Title
8 SAD_UC_EXAMQUAL Character(4) VARCHAR2(4) NOT NULL Type of Qualification
9 SAD_UC_EXAMLVLTITL Character(10) VARCHAR2(10) NOT NULL Exam Level Title
10 SAD_UC_IMPORTED Character(1) VARCHAR2(1) NOT NULL Imported

Y/N Table Edit

Default Value: N

11 SAD_UC_ACTIVE_IND Character(1) VARCHAR2(1) NOT NULL Active

Y/N Table Edit

Default Value: Y

12 SAD_UC_TIMESTAMP DateTime(26) TIMESTAMP UCAS Timestamp
13 SAD_UC_UNITVALUE Character(6) VARCHAR2(6) NOT NULL Unit Value
14 SAD_UC_GRADED Character(1) VARCHAR2(1) NOT NULL Graded Unit

Y/N Table Edit