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: IGS_HE_ST_UNT_VS

Product:	IGS - Student System (Obsolete)
Description:	HESA Unit Details
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT A.ROWID ROW_ID
, A.HESA_ST_UNT_VS_ID HESA_ST_UNT_VS_ID
, A. UNIT_CD UNIT_CD
, A. VERSION_NUMBER VERSION_NUMBER
, A.PROP_OF_TEACHING_IN_WELSH PROP_OF_TEACHING_IN_WELSH
, A.CREDIT_TRANSFER_SCHEME CREDIT_TRANSFER_SCHEME
, A.MODULE_LENGTH MODULE_LENGTH
, A.PROPORTION_OF_FTE PROPORTION_OF_FTE
, A.LOCATION_CD LOCATION_CD
, A.CREATION_DATE CREATION_DATE
, A.CREATED_BY CREATED_BY
, A.LAST_UPDATE_DATE LAST_UPDATE_DATE
, A.LAST_UPDATED_BY LAST_UPDATED_BY
, A.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, A.EXCLUDE_FLAG EXCLUDE_FLAG
FROM IGS_HE_ST_UNT_VS_ALL A
WHERE NVL (ORG_ID
, NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 1)
, ' '
, NULL
, SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 10)))
, -99)) = NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 1)
, ' '
, NULL
, SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 10)))
, -99)

Columns

Name
ROW_ID
HESA_ST_UNT_VS_ID
UNIT_CD
VERSION_NUMBER
PROP_OF_TEACHING_IN_WELSH
CREDIT_TRANSFER_SCHEME
MODULE_LENGTH
PROPORTION_OF_FTE
LOCATION_CD
CREATION_DATE
CREATED_BY
LAST_UPDATE_DATE
LAST_UPDATED_BY
LAST_UPDATE_LOGIN
EXCLUDE_FLAG