eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.IGSFV_UNIT_UK_STATISTICS

Source

View Text - Preformatted


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

View Text - HTML Formatted

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