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.

[Home] [Help]

View: IGSBV_UNIT_UK_STATISTICS

Product:	IGS - Student System (Obsolete)
Description:	Base View for UK Statistics Unit Details
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT UNT.HESA_ST_UNT_VS_ID HESA_STATS_UNIT_ID
, UNT.UNIT_CD UNIT_CODE
, UNT.VERSION_NUMBER UNIT_VERSION_NUMBER
, UNT.PROP_OF_TEACHING_IN_WELSH PROP_TAUGHT_IN_WELSH
, UNT.LOCATION_CD UNIT_LOCATION_CODE
, UNT.CREDIT_TRANSFER_SCHEME CREDIT_TRANSFER_SCHEME
, 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 WITH READ ONLY

Columns

Name
HESA_STATS_UNIT_ID
UNIT_CODE
UNIT_VERSION_NUMBER
PROP_TAUGHT_IN_WELSH
UNIT_LOCATION_CODE
CREDIT_TRANSFER_SCHEME
PROP_OF_FTE
MODULE_LENGTH
EXCLUDE_FLAG
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE