COURSE (DIM_COURSE) COURSE (DIM_COURSE)

The columns on Course are as below.  In each Data Mart just the columns required are available for retrieval.

On the Data Warehouse this is referred to as Dim_Course.  In the Cubes it is referred to as <<Cube Name>> Course (eg Student Course on Cube_Student).

The dimension is at 'route code' level, because this is the level used to link to related items within SITS.

 

Column Name

Data Type

Description

Derivation

course_sk

integer

This uniquely identifies the course record.

The value increments each time a record is entered into the table.

course_route_code_src

char

The route code associated with the course, as stored on SITS..

srs_var.var_rouc on SITS

course_programme_src

char

The source system identifier for the student record.

Note: For SITS this is the same as applicant_id_src.

srs_mcr.mcr_crsc on SITS

source_system

char

The source system the course record comes from

'SITS' at present

start_date

date

Date the course record was entered onto the DW

NOT USED AT PRESENT

end_date

date

Date the record was superseded on the DW

NOT USED AT PRESENT

current_flag

char

Whether this is the latest version of the course held

ALWAYS SET TO 'YES' AT PRESENT

faculty_code

char

Short character code for the faculty 'owning' the course

See DW_Faculty in Warehouse Lookup Tables

faculty

char

Description of the faculty 'owning' the course

See DW_Faculty in Warehouse Lookup Tables 

dept_code

char

Short character code for the department 'owning' the course

See DW_Dept in Warehouse Lookup Tables 

dept

char

Description of the department 'owning' the course

See DW_Dept in Warehouse Lookup Tables  

admissions_sub_dept

char

Used purely by Admissions for grouping courses together, at level below department.

 

admissions_team

char

Admissions team responsible for processing applicants for the course

 NOT POPULATED AT PRESENT

course_name

char

Descriptive name for the course

ins_rou.rou_name 

ucas_jacs_code_std

char

UCAS JACS Code linked to the course.

Based upon characters 3-6 of srs_var.var_rouc. 

Additional derivation in code. 

course_level_code

char

Short code for level of course ('UG', 'PGR','PGT' 'SC'). 

See DW_Course_Level in Warehouse Lookup Tables.

course_level

char

Description of level of course: 'Undergraduate'..

See DW_Course_Level in Warehouse Lookup Tables. 

intended_hesa_qualification_level

(10_way/6_way/5_way/3_way)

char

HESA-supplied level of the course, broken down into 10/6/5 and 3 categories respectively.

See DW_Qualification_Level in Warehouse Lookup Tables.  

currently_offered

char

Whether the course is currently offered to applicants

srs_mcr.mcr_iuse - 'Y' = 'YES' else 'NO' 

foundation_flag

char

'YES' if the course is a foundation course. 

If course_name contains 'foundation' then 'YES' else 'NO'

 

course_full_or_part_time

char

'FT' if full-time, 'PT' if part-time

Taken from SITS Route Code: If 2nd char is '1' then full-time, if '2' then part-time.

exam_board 

char 

The code for the exam board linked to the course, used for Board Reporting 

ins_rou.rou_udf7 

metrics_subject_name

char

 

Lookup on DW_Interfaces Metrics_Subject_UCAS_Code_Lkp for jacs_code_std

course_director char As name Taken from rou.rou_udf7
course_name_aggregated char Combined some courses together for reporting purposes pwy.pwy_udfk is populated, else course_name.