Product: | IGS - Student System (Obsolete) |
---|---|
Description: | Full View for UK Statistics Unit Details |
Implementation/DBA Data: | Not implemented in this database |
SELECT UNT.HESA_ST_UNT_VS_ID HESA_STATS_UNIT_ID
, UNT.UNIT_CD UNIT_CODE
, UV.TITLE UNIT_TITLE
, UV.SHORT_TITLE UNIT_SHORT_TITLE
, UV.ABBREVIATION UNIT_ABBREVIATION
, UNT.VERSION_NUMBER UNIT_VERSION_NUMBER
, UNT.PROP_OF_TEACHING_IN_WELSH PROP_TAUGHT_IN_WELSH
, UNT.LOCATION_CD UNIT_LOCATION_CODE
, ( SELECT DESCRIPTION
FROM IGS_AD_LOCATION_ALL
WHERE LOCATION_CD = UNT.LOCATION_CD) LOCATION_DESC
, UNT.CREDIT_TRANSFER_SCHEME CREDIT_TRANSFER_SCHEME
, ( SELECT VALUE_DESCRIPTION
FROM IGS_HE_CODE_VALUES
WHERE CODE_TYPE = 'OSS_CRDTSCM'
AND VALUE = UNT.CREDIT_TRANSFER_SCHEME) CREDIT_TRANSFER_SCHEME_DESC
, UNT.PROPORTION_OF_FTE PROP_OF_FTE
, UNT.MODULE_LENGTH MODULE_LENGTH
, UNT.EXCLUDE_FLAG EXCLUDE_FLAG
, UNT.CREATED_BY CREATED_BY
, UNT.CREATION_DATE CREATION_DATE
, UNT.LAST_UPDATED_BY LAST_UPDATED_BY
, UNT.LAST_UPDATE_DATE LAST_UPDATE_DATE
FROM IGS_HE_ST_UNT_VS_ALL UNT
, IGS_PS_UNIT_VER_ALL UV
WHERE UNT.UNIT_CD = UV.UNIT_CD
AND UNT.VERSION_NUMBER = UV.VERSION_NUMBER WITH READ ONLY