Table: IGS_FI_FEE_AS_RATE

Product:	IGS - Student System
Description:	This entity describes the method and parameters necessary for determining the amount to charge during fee assessment processing for a fee category fee liability.
Implementation/DBA Data:	IGS.IGS_FI_FEE_AS_RATE

Primary Key: FAR_UK_1

1. FEE_TYPE
2. FEE_CAL_TYPE
3. FEE_CI_SEQUENCE_NUMBER
4. RATE_NUMBER
5. FEE_CAT

Primary Key: FAR_UK_2

1. FEE_TYPE
2. FEE_CAL_TYPE
3. FEE_CI_SEQUENCE_NUMBER
4. S_RELATION_TYPE
5. RATE_NUMBER
6. FEE_CAT

Primary Key: IGS_FI_FEE_AS_RATE_PK

1. FAR_ID

Primary Key: IGS_FI_FEE_AS_RATE_UK1

1. FEE_TYPE
2. FEE_CAL_TYPE
3. FEE_CI_SEQUENCE_NUMBER
4. RATE_NUMBER
5. FEE_CAT

Primary Key: IGS_FI_FEE_AS_RATE_UK2

1. FEE_TYPE
2. FEE_CAL_TYPE
3. FEE_CI_SEQUENCE_NUMBER
4. S_RELATION_TYPE
5. RATE_NUMBER
6. FEE_CAT

Foreign Keys

Table		Foreign Table	Foreign Key Column
IGS_FI_FEE_AS_RATE		IGS_EN_ATD_MODE_ALL	IGS_FI_FEE_AS_RATE.ATTENDANCE_MODE
IGS_FI_FEE_AS_RATE		IGS_EN_ATD_TYPE_ALL	IGS_FI_FEE_AS_RATE.ATTENDANCE_TYPE
IGS_FI_FEE_AS_RATE		IGS_PS_VER_ALL	IGS_FI_FEE_AS_RATE.COURSE_CD IGS_FI_FEE_AS_RATE.VERSION_NUMBER
IGS_FI_FEE_AS_RATE		IGS_FI_F_CAT_FEE_LBL_ALL	IGS_FI_FEE_AS_RATE.FEE_CAT IGS_FI_FEE_AS_RATE.FEE_CAL_TYPE IGS_FI_FEE_AS_RATE.FEE_CI_SEQUENCE_NUMBER IGS_FI_FEE_AS_RATE.FEE_TYPE
IGS_FI_FEE_AS_RATE		IGS_FI_F_TYP_CA_INST_ALL	IGS_FI_FEE_AS_RATE.FEE_TYPE IGS_FI_FEE_AS_RATE.FEE_CAL_TYPE IGS_FI_FEE_AS_RATE.FEE_CI_SEQUENCE_NUMBER
IGS_FI_FEE_AS_RATE		IGS_FI_GOVT_HEC_CNTB	IGS_FI_FEE_AS_RATE.GOVT_HECS_CNTRBTN_BAND
IGS_FI_FEE_AS_RATE		IGS_FI_GOV_HEC_PA_OP	IGS_FI_FEE_AS_RATE.GOVT_HECS_PAYMENT_OPTION
IGS_FI_FEE_AS_RATE		HZ_PARTIES	IGS_FI_FEE_AS_RATE.ORG_PARTY_ID
IGS_FI_FEE_AS_RATE		IGS_AD_LOCATION_ALL	IGS_FI_FEE_AS_RATE.LOCATION_CD
IGS_FI_FEE_AS_RATE		IGS_PE_CODE_CLASSES	IGS_FI_FEE_AS_RATE.RESIDENCY_STATUS_ID
IGS_FI_FEE_AS_RATE		IGS_PR_CLASS_STD	IGS_FI_FEE_AS_RATE.CLASS_STANDING
IGS_FI_FEE_AS_RATE		IGS_AS_UNIT_CLASS_ALL	IGS_FI_FEE_AS_RATE.UNIT_CLASS
IGS_FI_FEE_AS_RATE		IGS_EN_UNIT_SET_ALL	IGS_FI_FEE_AS_RATE.UNIT_SET_CD IGS_FI_FEE_AS_RATE.US_VERSION_NUMBER
IGS_FI_FEE_AS_RATE		IGS_PS_UNIT_TYPE_LVL	IGS_FI_FEE_AS_RATE.UNIT_TYPE_ID
IGS_FI_FEE_AS_RATE		IGS_AS_UNIT_MODE	IGS_FI_FEE_AS_RATE.UNIT_MODE
IGS_FI_FEE_AS_RATE		IGS_PS_UNIT	IGS_FI_FEE_AS_RATE.UNIT_CD
IGS_FI_FEE_AS_RATE		IGS_PS_UNIT_VER_ALL	IGS_FI_FEE_AS_RATE.UNIT_CD IGS_FI_FEE_AS_RATE.UNIT_VERSION_NUMBER
IGS_FI_FEE_AS_RATE		IGS_PS_UNIT_LEVEL_ALL	IGS_FI_FEE_AS_RATE.UNIT_LEVEL
IGS_FI_ELM_RANGE_RT		IGS_FI_FEE_AS_RATE	IGS_FI_ELM_RANGE_RT.FEE_TYPE IGS_FI_ELM_RANGE_RT.FEE_CAL_TYPE IGS_FI_ELM_RANGE_RT.FEE_CI_SEQUENCE_NUMBER IGS_FI_ELM_RANGE_RT.S_RELATION_TYPE IGS_FI_ELM_RANGE_RT.RATE_NUMBER IGS_FI_ELM_RANGE_RT.FEE_CAT
IGS_FI_SUB_ER_RT		IGS_FI_FEE_AS_RATE	IGS_FI_SUB_ER_RT.FAR_ID