FND Design Data [Home] [Help]

Table: IGS_FI_FEE_AS_RATE

Product: IGS - Student System (Obsolete)
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: Not implemented in this database
Primary Key: FAR_UK_1
  1. ColumnFEE_TYPE
  2. ColumnFEE_CAL_TYPE
  3. ColumnFEE_CI_SEQUENCE_NUMBER
  4. ColumnRATE_NUMBER
  5. ColumnFEE_CAT
Primary Key: FAR_UK_2
  1. ColumnFEE_TYPE
  2. ColumnFEE_CAL_TYPE
  3. ColumnFEE_CI_SEQUENCE_NUMBER
  4. ColumnS_RELATION_TYPE
  5. ColumnRATE_NUMBER
  6. ColumnFEE_CAT
Primary Key: IGS_FI_FEE_AS_RATE_PK
  1. ColumnFAR_ID
Primary Key: IGS_FI_FEE_AS_RATE_UK1
  1. ColumnFEE_TYPE
  2. ColumnFEE_CAL_TYPE
  3. ColumnFEE_CI_SEQUENCE_NUMBER
  4. ColumnRATE_NUMBER
  5. ColumnFEE_CAT
Primary Key: IGS_FI_FEE_AS_RATE_UK2
  1. ColumnFEE_TYPE
  2. ColumnFEE_CAL_TYPE
  3. ColumnFEE_CI_SEQUENCE_NUMBER
  4. ColumnS_RELATION_TYPE
  5. ColumnRATE_NUMBER
  6. ColumnFEE_CAT
Foreign Keys
Table
Foreign Table Foreign Key Column
IGS_FI_FEE_AS_RATE FK Joins to TableIGS_EN_ATD_MODE_ALL IGS_FI_FEE_AS_RATE.ATTENDANCE_MODE
IGS_FI_FEE_AS_RATE FK Joins to TableIGS_EN_ATD_TYPE_ALL IGS_FI_FEE_AS_RATE.ATTENDANCE_TYPE
IGS_FI_FEE_AS_RATE FK Joins to TableIGS_PS_VER_ALL IGS_FI_FEE_AS_RATE.COURSE_CD
IGS_FI_FEE_AS_RATE.VERSION_NUMBER
IGS_FI_FEE_AS_RATE FK Joins to TableIGS_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 FK Joins to TableIGS_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 FK Joins to TableIGS_FI_GOVT_HEC_CNTB IGS_FI_FEE_AS_RATE.GOVT_HECS_CNTRBTN_BAND
IGS_FI_FEE_AS_RATE FK Joins to TableIGS_FI_GOV_HEC_PA_OP IGS_FI_FEE_AS_RATE.GOVT_HECS_PAYMENT_OPTION
IGS_FI_FEE_AS_RATE FK Joins to TableHZ_PARTIES IGS_FI_FEE_AS_RATE.ORG_PARTY_ID
IGS_FI_FEE_AS_RATE FK Joins to TableIGS_AD_LOCATION_ALL IGS_FI_FEE_AS_RATE.LOCATION_CD
IGS_FI_FEE_AS_RATE FK Joins to TableIGS_PE_CODE_CLASSES IGS_FI_FEE_AS_RATE.RESIDENCY_STATUS_ID
IGS_FI_FEE_AS_RATE FK Joins to TableIGS_PR_CLASS_STD IGS_FI_FEE_AS_RATE.CLASS_STANDING
IGS_FI_FEE_AS_RATE FK Joins to TableIGS_AS_UNIT_CLASS_ALL IGS_FI_FEE_AS_RATE.UNIT_CLASS
IGS_FI_FEE_AS_RATE FK Joins to TableIGS_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 FK Joins to TableIGS_PS_UNIT_TYPE_LVL IGS_FI_FEE_AS_RATE.UNIT_TYPE_ID
IGS_FI_FEE_AS_RATE FK Joins to TableIGS_AS_UNIT_MODE IGS_FI_FEE_AS_RATE.UNIT_MODE
IGS_FI_FEE_AS_RATE FK Joins to TableIGS_PS_UNIT IGS_FI_FEE_AS_RATE.UNIT_CD
IGS_FI_FEE_AS_RATE FK Joins to TableIGS_PS_UNIT_VER_ALL IGS_FI_FEE_AS_RATE.UNIT_CD
IGS_FI_FEE_AS_RATE.UNIT_VERSION_NUMBER
IGS_FI_FEE_AS_RATE FK Joins to TableIGS_PS_UNIT_LEVEL_ALL IGS_FI_FEE_AS_RATE.UNIT_LEVEL
TableIGS_FI_ELM_RANGE_RT FK Joins to 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
TableIGS_FI_SUB_ER_RT FK Joins to IGS_FI_FEE_AS_RATE IGS_FI_SUB_ER_RT.FAR_ID