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_FI_F_CAT_FEE_LBL_V

Product:	IGS - Student System (Obsolete)
Description:	This view represents the columns of the fee_cat_fee_liability table as well as including columns representing the s_chg_method_type, rul_sequence_number and start, end and retro date alias's that are applicable. These other columns may be t
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT FCFL.FEE_CAT
, FCFL.FEE_CAL_TYPE
, FCFL.FEE_CI_SEQUENCE_NUMBER
, FCFL.FEE_TYPE
, FCFL.FEE_LIABILITY_STATUS
, NVL(FCFL.START_DT_ALIAS
, SUBSTR(IGS_FI_GEN_001.FINP_GET_FCFL_DAI('START_DT_ALIAS'
, 'START_DAI_SEQUENCE_NUMBER'
, 'START_DT_ALIAS'
, FCFL.FEE_CAT
, FCFL.FEE_CAL_TYPE
, FCFL.FEE_CI_SEQUENCE_NUMBER
, FCFL.FEE_TYPE)
, 1
, 10)) START_DT_ALIAS
, NVL(FCFL.START_DAI_SEQUENCE_NUMBER
, TO_NUMBER(IGS_FI_GEN_001.FINP_GET_FCFL_DAI('START_DT_ALIAS'
, 'START_DAI_SEQUENCE_NUMBER'
, 'START_DAI_SEQUENCE_NUMBER'
, FCFL.FEE_CAT
, FCFL.FEE_CAL_TYPE
, FCFL.FEE_CI_SEQUENCE_NUMBER
, FCFL.FEE_TYPE))) START_DAI_SEQUENCE_NUMBER
, SUBSTR(IGS_FI_GEN_001.FINP_GET_FCFL_DAI('END_DT_ALIAS'
, 'END_DAI_SEQUENCE_NUMBER'
, 'END_DT_ALIAS'
, FCFL.FEE_CAT
, FCFL.FEE_CAL_TYPE
, FCFL.FEE_CI_SEQUENCE_NUMBER
, FCFL.FEE_TYPE)
, 1
, 10) END_DT_ALIAS
, TO_NUMBER(IGS_FI_GEN_001.FINP_GET_FCFL_DAI('END_DT_ALIAS'
, 'END_DAI_SEQUENCE_NUMBER'
, 'END_DAI_SEQUENCE_NUMBER'
, FCFL.FEE_CAT
, FCFL.FEE_CAL_TYPE
, FCFL.FEE_CI_SEQUENCE_NUMBER
, FCFL.FEE_TYPE)) END_DAI_SEQUENCE_NUMBER
, SUBSTR(IGS_FI_GEN_001.FINP_GET_FCFL_DAI('RETRO_DT_ALIAS'
, 'RETRO_DAI_SEQUENCE_NUMBER'
, 'RETRO_DT_ALIAS'
, FCFL.FEE_CAT
, FCFL.FEE_CAL_TYPE
, FCFL.FEE_CI_SEQUENCE_NUMBER
, FCFL.FEE_TYPE)
, 1
, 10) RETRO_DT_ALIAS
, TO_NUMBER(IGS_FI_GEN_001.FINP_GET_FCFL_DAI('RETRO_DT_ALIAS'
, 'RETRO_DAI_SEQUENCE_NUMBER'
, 'RETRO_DAI_SEQUENCE_NUMBER'
, FCFL.FEE_CAT
, FCFL.FEE_CAL_TYPE
, FCFL.FEE_CI_SEQUENCE_NUMBER
, FCFL.FEE_TYPE)) RETRO_DAI_SEQUENCE_NUMBER
, NVL(FCFL.S_CHG_METHOD_TYPE
, FTCI.S_CHG_METHOD_TYPE) S_CHG_METHOD_TYPE
, NVL(FCFL.RUL_SEQUENCE_NUMBER
, FTCI.RUL_SEQUENCE_NUMBER) RUL_SEQUENCE_NUMBER
, SUBSTR(IGS_FI_GEN_001.FINP_GET_CURRENCY(FCFL.FEE_CAL_TYPE
, FCFL.FEE_CI_SEQUENCE_NUMBER
, NULL
, FCFL.FEE_TYPE
, FCFL.FEE_CAT)
, 1
, 15) CURRENCY_CD
, NVL(FCFL.PAYMENT_HIERARCHY_RANK
, FTCI.PAYMENT_HIERARCHY_RANK) PAYMENT_HIERARCHY_RANK
, FCFL.CREATED_BY
, FCFL.CREATION_DATE
, FCFL.LAST_UPDATED_BY
, FCFL.LAST_UPDATE_DATE
, FCFL.LAST_UPDATE_LOGIN
, FTCI.SCOPE_RUL_SEQUENCE_NUM
, FTCI.ELM_RNG_ORDER_NAME
, FCFL.WAIVER_CALC_FLAG
, FTCI.MAX_CHG_ELEMENTS
FROM IGS_FI_F_CAT_FEE_LBL FCFL
, IGS_FI_F_TYP_CA_INST FTCI
WHERE FTCI.FEE_TYPE = FCFL.FEE_TYPE
AND FTCI.FEE_CAL_TYPE = FCFL.FEE_CAL_TYPE
AND FTCI.FEE_CI_SEQUENCE_NUMBER = FCFL.FEE_CI_SEQUENCE_NUMBER

Columns

Name
FEE_CAT
FEE_CAL_TYPE
FEE_CI_SEQUENCE_NUMBER
FEE_TYPE
FEE_LIABILITY_STATUS
START_DT_ALIAS
START_DAI_SEQUENCE_NUMBER
END_DT_ALIAS
END_DAI_SEQUENCE_NUMBER
RETRO_DT_ALIAS
RETRO_DAI_SEQUENCE_NUMBER
S_CHG_METHOD_TYPE
RUL_SEQUENCE_NUMBER
CURRENCY_CD
PAYMENT_HIERARCHY_RANK
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN
SCOPE_RUL_SEQUENCE_NUM
ELM_RNG_ORDER_NAME
WAIVER_CALC_FLAG
MAX_CHG_ELEMENTS