FND Design Data [Home] [Help]

Table: IGS_FI_F_CAT_CA_INST

Product: IGS - Student System (Obsolete)
Description: This entity describes the periods of fee assessment - fee calendar instances- applicable to a fee category.
Implementation/DBA Data: Not implemented in this database
Primary Key: IGS_FI_F_CAT_CA_INST_PK
  1. ColumnFEE_CAT
  2. ColumnFEE_CAL_TYPE
  3. ColumnFEE_CI_SEQUENCE_NUMBER
Foreign Keys
Table
Foreign Table Foreign Key Column
IGS_FI_F_CAT_CA_INST FK Joins to TableIGS_CA_INST_ALL IGS_FI_F_CAT_CA_INST.FEE_CAL_TYPE
IGS_FI_F_CAT_CA_INST.FEE_CI_SEQUENCE_NUMBER
IGS_FI_F_CAT_CA_INST FK Joins to TableIGS_CA_DA_INST IGS_FI_F_CAT_CA_INST.END_DT_ALIAS
IGS_FI_F_CAT_CA_INST.END_DAI_SEQUENCE_NUMBER
IGS_FI_F_CAT_CA_INST.FEE_CAL_TYPE
IGS_FI_F_CAT_CA_INST.FEE_CI_SEQUENCE_NUMBER
IGS_FI_F_CAT_CA_INST FK Joins to TableIGS_FI_FEE_CAT_ALL IGS_FI_F_CAT_CA_INST.FEE_CAT
IGS_FI_F_CAT_CA_INST FK Joins to TableIGS_FI_FEE_STR_STAT IGS_FI_F_CAT_CA_INST.FEE_CAT_CI_STATUS
IGS_FI_F_CAT_CA_INST FK Joins to TableIGS_CA_DA_INST IGS_FI_F_CAT_CA_INST.RETRO_DT_ALIAS
IGS_FI_F_CAT_CA_INST.RETRO_DAI_SEQUENCE_NUMBER
IGS_FI_F_CAT_CA_INST.FEE_CAL_TYPE
IGS_FI_F_CAT_CA_INST.FEE_CI_SEQUENCE_NUMBER
IGS_FI_F_CAT_CA_INST FK Joins to TableIGS_CA_DA_INST IGS_FI_F_CAT_CA_INST.START_DT_ALIAS
IGS_FI_F_CAT_CA_INST.START_DAI_SEQUENCE_NUMBER
IGS_FI_F_CAT_CA_INST.FEE_CAL_TYPE
IGS_FI_F_CAT_CA_INST.FEE_CI_SEQUENCE_NUMBER
TableIGS_FI_F_CAT_FEE_LBL_ALL FK Joins to IGS_FI_F_CAT_CA_INST IGS_FI_F_CAT_FEE_LBL_ALL.FEE_CAT
IGS_FI_F_CAT_FEE_LBL_ALL.FEE_CAL_TYPE
IGS_FI_F_CAT_FEE_LBL_ALL.FEE_CI_SEQUENCE_NUMBER
TableIGS_FI_FEE_ENCMB FK Joins to IGS_FI_F_CAT_CA_INST IGS_FI_FEE_ENCMB.FEE_CAT
IGS_FI_FEE_ENCMB.FEE_CAL_TYPE
IGS_FI_FEE_ENCMB.FEE_CI_SEQUENCE_NUMBER
TableIGS_FI_FEE_PAY_SCHD FK Joins to IGS_FI_F_CAT_CA_INST IGS_FI_FEE_PAY_SCHD.FEE_CAT
IGS_FI_FEE_PAY_SCHD.FEE_CAL_TYPE
IGS_FI_FEE_PAY_SCHD.FEE_CI_SEQUENCE_NUMBER
TableIGS_FI_F_RET_SCHD_HT_ALL FK Joins to IGS_FI_F_CAT_CA_INST IGS_FI_F_RET_SCHD_HT_ALL.FEE_CAT
IGS_FI_F_RET_SCHD_HT_ALL.FEE_CAL_TYPE
IGS_FI_F_RET_SCHD_HT_ALL.FEE_CI_SEQUENCE_NUMBER
TableIGS_FI_FEE_RET_SCHD FK Joins to IGS_FI_F_CAT_CA_INST IGS_FI_FEE_RET_SCHD.FEE_CAT
IGS_FI_FEE_RET_SCHD.FEE_CAL_TYPE
IGS_FI_FEE_RET_SCHD.FEE_CI_SEQUENCE_NUMBER