Product: | IGS - Student System (Obsolete) |
---|---|
Description: | Full View for UK Statistics Program Cost Center Details |
Implementation/DBA Data: | Not implemented in this database |
SELECT PC.HE_PROG_CC_ID HESA_STATS_PROGRAM_CC_ID
, PC.COURSE_CD PROGRAM_CODE
, PS.TITLE PROGRAM_TITLE
, PS.SHORT_TITLE PROGRAM_SHORT_TITLE
, PS.ABBREVIATION PROGRAM_ABBREVIATION
, PC.VERSION_NUMBER PROGRAM_VERSION_NUMBER
, PC.COST_CENTRE PROGRAM_COST_CENTRE
, ( SELECT VALUE_DESCRIPTION
FROM IGS_HE_CODE_VALUES
WHERE CODE_TYPE = 'OSS_COSTCN'
AND VALUE = PC.COST_CENTRE ) PROGRAM_COST_CENTRE_DESC
, PC.SUBJECT PROGRAM_SUBJECT
, ( SELECT DESCRIPTION
FROM IGS_PS_FLD_OF_STUDY_ALL
WHERE FIELD_OF_STUDY= PC.SUBJECT ) PROGRAM_SUBJECT_DESC
, PC.PROPORTION PROGRAM_COST_CENTRE_SUBJ_PROP
, PC.CREATED_BY CREATED_BY
, PC.CREATION_DATE CREATION_DATE
, PC.LAST_UPDATED_BY LAST_UPDATED_BY
, PC.LAST_UPDATE_DATE LAST_UPDATE_DATE
FROM IGS_HE_ST_PROG_CC PC
, IGS_PS_VER_ALL PS
WHERE PC.COURSE_CD = PS.COURSE_CD
AND PC.VERSION_NUMBER = PS.VERSION_NUMBER WITH READ ONLY