[Home] [Help]
View: IGS_HE_UT_CALC_LVL_V
Product: | IGS - Student System (Obsolete) |
Description: | Holds the HESA Tariff Levels for a Calculation Type |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT HUTCL.ROWID
, HUTCL.TARIFF_CALC_TYPE_CD
, HUTCL.TARIFF_LEVEL_CD
, LKUPS.MEANING
, HUTCL.CLOSED_IND
, HUTCL.CREATED_BY
, HUTCL.CREATION_DATE
, HUTCL.LAST_UPDATED_BY
, HUTCL.LAST_UPDATE_DATE
, HUTCL.LAST_UPDATE_LOGIN
FROM IGS_HE_UT_CALC_LVL HUTCL
, IGS_LOOKUP_VALUES LKUPS
WHERE HUTCL.TARIFF_LEVEL_CD = LKUPS.LOOKUP_CODE
AND LKUPS.LOOKUP_TYPE = 'IGS_HE_TARIFF_LEVELS'
Columns
Name |
ROW_ID |
TARIFF_CALC_TYPE_CD |
TARIFF_LEVEL_CD |
TARIFF_LEVEL_DESC |
CLOSED_IND |
CREATED_BY |
CREATION_DATE |
LAST_UPDATED_BY |
LAST_UPDATE_DATE |
LAST_UPDATE_LOGIN |