[Home] [Help]
| Product: | IGS - Student System (Obsolete) |
|---|---|
| Description: | Full View for Program Offering Option Unit Set HESA Details - Cost Center Details |
| Implementation/DBA Data: | Not implemented in this database |
SELECT POC.HESA_POOUS_CC_ID HESA_POOUS_CC_ID
, POC.COURSE_CD PROGRAM_CODE
, PS.TITLE PROGRAM_TITLE
, PS.SHORT_TITLE PROGRAM_SHORT_TITLE
, PS.ABBREVIATION PROGRAM_ABBREVIATION
, POC.CRV_VERSION_NUMBER PROGRAM_VERSION_NUMBER
, POC.CAL_TYPE CALENDAR_TYPE
, CA.DESCRIPTION CALENDAR_DESC
, CA.ABBREVIATION CALENDAR_ABBREVIATION
, POC.LOCATION_CD LOCATION_CODE
, ( SELECT DESCRIPTION
FROM IGS_AD_LOCATION_ALL
WHERE LOCATION_CD = POC.LOCATION_CD) LOCATION_DESC
, POC.ATTENDANCE_MODE ATTENDANCE_MODE
, ( SELECT DESCRIPTION
FROM IGS_EN_ATD_MODE_ALL
WHERE ATTENDANCE_MODE = POC.ATTENDANCE_MODE ) ATTENDANCE_MODE_DESC
, POC.ATTENDANCE_TYPE ATTENDANCE_TYPE
, ( SELECT DESCRIPTION
FROM IGS_EN_ATD_TYPE_ALL
WHERE ATTENDANCE_TYPE = POC.ATTENDANCE_TYPE ) ATTENDANCE_TYPE_DESC
, POC.UNIT_SET_CD UNIT_SET_CODE
, EN.TITLE UNIT_SET_TITLE
, EN.SHORT_TITLE UNIT_SET_SHORT_TITLE
, EN.ABBREVIATION UNIT_SET_ABBREVIATION
, POC.US_VERSION_NUMBER UNIT_SET_VERSION_NUMBER
, POC.COST_CENTRE PROGRAM_COST_CENTRE
, ( SELECT VALUE_DESCRIPTION
FROM IGS_HE_CODE_VALUES
WHERE CODE_TYPE = 'OSS_COSTCN'
AND VALUE = POC.COST_CENTRE ) PROGRAM_COST_CENTRE_DESC
, POC.SUBJECT PROGRAM_SUBJECT
, ( SELECT DESCRIPTION
FROM IGS_PS_FLD_OF_STUDY_ALL
WHERE FIELD_OF_STUDY = POC.SUBJECT ) PROGRAM_SUBJECT_DESC
, POC.PROPORTION PROGRAM_COST_CENTRE_SUBJ_PROP
, POC.CREATED_BY CREATED_BY
, POC.CREATION_DATE CREATION_DATE
, POC.LAST_UPDATED_BY LAST_UPDATED_BY
, POC.LAST_UPDATE_DATE LAST_UPDATE_DATE
FROM IGS_HE_POOUS_CC_ALL POC
, IGS_PS_VER_ALL PS
, IGS_EN_UNIT_SET_ALL EN
, IGS_CA_TYPE CA
WHERE POC.COURSE_CD = PS.COURSE_CD
AND POC.CRV_VERSION_NUMBER = PS.VERSION_NUMBER
AND POC.UNIT_SET_CD = EN.UNIT_SET_CD
AND POC.US_VERSION_NUMBER = EN.VERSION_NUMBER
AND POC.CAL_TYPE = CA.CAL_TYPE WITH READ ONLY