DBA Data[Home] [Help]

VIEW: APPS.IGSBV_UNIT_UK_STATISTICS

Source

View Text - Preformatted

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
View Text - HTML Formatted

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