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_SCA_PRR_V

Product:	IGS - Student System (Obsolete)
Description:	This entity describes the fee types applicable to a fee category period (fee category calendar instance) for even the prior fee calendars.
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT SCA.PERSON_ID
, SCA.COURSE_CD
, SCA.VERSION_NUMBER
, SCA.CAL_TYPE
, SCA.LOCATION_CD
, SCA.ATTENDANCE_MODE
, SCA.ATTENDANCE_TYPE
, IGS_FI_GEN_001.FINP_GET_HECS_PYMNT_OPTN(SCA.PERSON_ID
, SCA.COURSE_CD
, SYSDATE
, FCFLV.FEE_CAL_TYPE
, FCFLV.FEE_CI_SEQUENCE_NUMBER
, FCFLV.START_DT_ALIAS
, FCFLV.START_DAI_SEQUENCE_NUMBER
, FCFLV.END_DT_ALIAS
, FCFLV.END_DAI_SEQUENCE_NUMBER) HECS_PAYMENT_OPTION
, SCA.COURSE_ATTEMPT_STATUS
, SCA.COMMENCEMENT_DT
, SCA.DISCONTINUED_DT
, SCAS.FEE_ASS_IND
, SCA.FEE_CAT
, FCFLV.FEE_CAL_TYPE
, FCFLV.FEE_CI_SEQUENCE_NUMBER
, FCFLV.FEE_TYPE
, FT.S_FEE_TYPE
, FT.S_FEE_TRIGGER_CAT
, FCFLV.FEE_LIABILITY_STATUS
, FCFLV.START_DT_ALIAS
, FCFLV.START_DAI_SEQUENCE_NUMBER
, IGS_CA_GEN_001.CALP_GET_ALIAS_VAL(FCFLV.START_DT_ALIAS
, FCFLV.START_DAI_SEQUENCE_NUMBER
, FCFLV.FEE_CAL_TYPE
, FCFLV.FEE_CI_SEQUENCE_NUMBER) START_DT
, FCFLV.END_DT_ALIAS
, FCFLV.END_DAI_SEQUENCE_NUMBER
, IGS_CA_GEN_001.CALP_GET_ALIAS_VAL(FCFLV.END_DT_ALIAS
, FCFLV.END_DAI_SEQUENCE_NUMBER
, FCFLV.FEE_CAL_TYPE
, FCFLV.FEE_CI_SEQUENCE_NUMBER) END_DT
, FCFLV.RETRO_DT_ALIAS
, FCFLV.RETRO_DAI_SEQUENCE_NUMBER
, IGS_CA_GEN_001.CALP_GET_ALIAS_VAL(FCFLV.RETRO_DT_ALIAS
, FCFLV.RETRO_DAI_SEQUENCE_NUMBER
, FCFLV.FEE_CAL_TYPE
, FCFLV.FEE_CI_SEQUENCE_NUMBER) RETRO_DT
, FCFLV.S_CHG_METHOD_TYPE
, FCFLV.RUL_SEQUENCE_NUMBER
, FCFLV.CURRENCY_CD
, FCFLV.CREATED_BY
, FCFLV.CREATION_DATE
, FCFLV.LAST_UPDATED_BY
, FCFLV.LAST_UPDATE_DATE
, FCFLV.LAST_UPDATE_LOGIN
, SCA.PRIMARY_PROGRAM_TYPE
, SCA.KEY_PROGRAM
FROM IGS_EN_STDNT_PS_ATT SCA
, IGS_LOOKUPS_VIEW SCAS
, IGS_FI_F_CAT_FEE_LBL_V FCFLV
, IGS_FI_FEE_TYPE FT
WHERE SCAS.LOOKUP_TYPE = 'CRS_ATTEMPT_STATUS'
AND SCAS.LOOKUP_CODE = SCA.COURSE_ATTEMPT_STATUS
AND FCFLV.FEE_CAT = SCA.FEE_CAT
AND NVL(SCA.COMMENCEMENT_DT
, IGS_EN_GEN_002.ENRP_GET_ACAD_COMM( NULL
, NULL
, SCA.PERSON_ID
, SCA.COURSE_CD
, SCA.ADM_ADMISSION_APPL_NUMBER
, SCA.ADM_NOMINATED_COURSE_CD
, SCA.ADM_SEQUENCE_NUMBER
, 'Y')) IS NOT NULL
AND ( ( NVL(SCA.COMMENCEMENT_DT
, IGS_EN_GEN_002.ENRP_GET_ACAD_COMM( NULL
, NULL
, SCA.PERSON_ID
, SCA.COURSE_CD
, SCA.ADM_ADMISSION_APPL_NUMBER
, SCA.ADM_NOMINATED_COURSE_CD
, SCA.ADM_SEQUENCE_NUMBER
, 'Y')) > SYSDATE
AND TRUNC(NVL(SCA.COMMENCEMENT_DT
, IGS_EN_GEN_002.ENRP_GET_ACAD_COMM( NULL
, NULL
, SCA.PERSON_ID
, SCA.COURSE_CD
, SCA.ADM_ADMISSION_APPL_NUMBER
, SCA.ADM_NOMINATED_COURSE_CD
, SCA.ADM_SEQUENCE_NUMBER
, 'Y'))) >= (SELECT TRUNC(DAIV.ALIAS_VAL) FROM IGS_CA_DA_INST_V DAIV WHERE DAIV.DT_ALIAS = FCFLV.START_DT_ALIAS
AND DAIV.SEQUENCE_NUMBER = FCFLV.START_DAI_SEQUENCE_NUMBER
AND DAIV.CAL_TYPE = FCFLV.FEE_CAL_TYPE
AND DAIV.CI_SEQUENCE_NUMBER = FCFLV.FEE_CI_SEQUENCE_NUMBER
AND DAIV.ALIAS_VAL IS NOT NULL)
AND TRUNC(NVL(SCA.COMMENCEMENT_DT
, IGS_EN_GEN_002.ENRP_GET_ACAD_COMM( NULL
, NULL
, SCA.PERSON_ID
, SCA.COURSE_CD
, SCA.ADM_ADMISSION_APPL_NUMBER
, SCA.ADM_NOMINATED_COURSE_CD
, SCA.ADM_SEQUENCE_NUMBER
, 'Y'))) <= (SELECT TRUNC(DAIV.ALIAS_VAL) FROM IGS_CA_DA_INST_V DAIV WHERE DAIV.DT_ALIAS = FCFLV.END_DT_ALIAS
AND DAIV.SEQUENCE_NUMBER = FCFLV.END_DAI_SEQUENCE_NUMBER
AND DAIV.CAL_TYPE = FCFLV.FEE_CAL_TYPE
AND DAIV.CI_SEQUENCE_NUMBER = FCFLV.FEE_CI_SEQUENCE_NUMBER
AND DAIV.ALIAS_VAL IS NOT NULL) ) OR ( NVL(SCA.COMMENCEMENT_DT
, IGS_EN_GEN_002.ENRP_GET_ACAD_COMM( NULL
, NULL
, SCA.PERSON_ID
, SCA.COURSE_CD
, SCA.ADM_ADMISSION_APPL_NUMBER
, SCA.ADM_NOMINATED_COURSE_CD
, SCA.ADM_SEQUENCE_NUMBER
, 'Y')) < SYSDATE ))
AND (SCA.DISCONTINUED_DT IS NULL OR (TRUNC(SCA.DISCONTINUED_DT) >= (SELECT TRUNC(DAIV.ALIAS_VAL) FROM IGS_CA_DA_INST_V DAIV WHERE DAIV.DT_ALIAS = FCFLV.START_DT_ALIAS
AND DAIV.SEQUENCE_NUMBER = FCFLV.START_DAI_SEQUENCE_NUMBER
AND DAIV.CAL_TYPE = FCFLV.FEE_CAL_TYPE
AND DAIV.CI_SEQUENCE_NUMBER = FCFLV.FEE_CI_SEQUENCE_NUMBER
AND DAIV.ALIAS_VAL IS NOT NULL)
AND TRUNC(SCA.DISCONTINUED_DT) <= (SELECT TRUNC(DAIV.ALIAS_VAL) FROM IGS_CA_DA_INST_V DAIV WHERE DAIV.DT_ALIAS = FCFLV.END_DT_ALIAS
AND DAIV.SEQUENCE_NUMBER = FCFLV.END_DAI_SEQUENCE_NUMBER
AND DAIV.CAL_TYPE = FCFLV.FEE_CAL_TYPE
AND DAIV.CI_SEQUENCE_NUMBER = FCFLV.FEE_CI_SEQUENCE_NUMBER
AND DAIV.ALIAS_VAL IS NOT NULL)))
AND FT.FEE_TYPE = FCFLV.FEE_TYPE
AND (FT.S_FEE_TRIGGER_CAT = 'INSTITUTN' OR IGS_FI_GEN_001.FINP_GET_FEE_TRIGGER( SCA.FEE_CAT
, FCFLV.FEE_CAL_TYPE
, FCFLV.FEE_CI_SEQUENCE_NUMBER
, FCFLV.FEE_TYPE
, FT.S_FEE_TRIGGER_CAT
, SCA.PERSON_ID
, SCA.COURSE_CD
, SCA.VERSION_NUMBER
, SCA.CAL_TYPE
, SCA.LOCATION_CD
, SCA.ATTENDANCE_MODE
, SCA.ATTENDANCE_TYPE) IS NOT NULL)

Columns

Name
PERSON_ID
COURSE_CD
VERSION_NUMBER
CAL_TYPE
LOCATION_CD
ATTENDANCE_MODE
ATTENDANCE_TYPE
HECS_PAYMENT_OPTION
COURSE_ATTEMPT_STATUS
COMMENCEMENT_DT
DISCONTINUED_DT
FEE_ASS_IND
FEE_CAT
FEE_CAL_TYPE
FEE_CI_SEQUENCE_NUMBER
FEE_TYPE
S_FEE_TYPE
S_FEE_TRIGGER_CAT
FEE_LIABILITY_STATUS
START_DT_ALIAS
START_DAI_SEQUENCE_NUMBER
START_DT
END_DT_ALIAS
END_DAI_SEQUENCE_NUMBER
END_DT
RETRO_DT_ALIAS
RETRO_DAI_SEQUENCE_NUMBER
RETRO_DT
S_CHG_METHOD_TYPE
RUL_SEQUENCE_NUMBER
CURRENCY_CD
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN
PRIMARY_PROGRAM_TYPE
KEY_PROGRAM