FND Design Data [Home] [Help]

Table: IGS_FI_F_TYP_CA_INST_ALL

Product: IGS - Student System
Description: This entity describes the periods of fee assessment fee calendar instances applicable to a fee type.
Implementation/DBA Data: TableIGS.IGS_FI_F_TYP_CA_INST_ALL
Primary Key: IGS_FI_F_TYP_CA_INST_PK
  1. ColumnFEE_TYPE
  2. ColumnFEE_CAL_TYPE
  3. ColumnFEE_CI_SEQUENCE_NUMBER
Foreign Keys
Table
Foreign Table Foreign Key Column
IGS_FI_F_TYP_CA_INST_ALL FK Joins to TableIGS_FI_ACC_ALL IGS_FI_F_TYP_CA_INST_ALL.ACCOUNT_CD
IGS_FI_F_TYP_CA_INST_ALL FK Joins to TableIGS_FI_ACC_ALL IGS_FI_F_TYP_CA_INST_ALL.REV_ACCOUNT_CD
IGS_FI_F_TYP_CA_INST_ALL FK Joins to TableIGS_FI_ACC_ALL IGS_FI_F_TYP_CA_INST_ALL.REC_ACCOUNT_CD
IGS_FI_F_TYP_CA_INST_ALL FK Joins to TableIGS_FI_ACC_ALL IGS_FI_F_TYP_CA_INST_ALL.RET_ACCOUNT_CD
IGS_FI_F_TYP_CA_INST_ALL FK Joins to TableIGS_CA_INST_ALL IGS_FI_F_TYP_CA_INST_ALL.FEE_CAL_TYPE
IGS_FI_F_TYP_CA_INST_ALL.FEE_CI_SEQUENCE_NUMBER
IGS_FI_F_TYP_CA_INST_ALL FK Joins to TableIGS_CA_DA_INST IGS_FI_F_TYP_CA_INST_ALL.END_DT_ALIAS
IGS_FI_F_TYP_CA_INST_ALL.END_DAI_SEQUENCE_NUMBER
IGS_FI_F_TYP_CA_INST_ALL.FEE_CAL_TYPE
IGS_FI_F_TYP_CA_INST_ALL.FEE_CI_SEQUENCE_NUMBER
IGS_FI_F_TYP_CA_INST_ALL FK Joins to TableIGS_FI_FEE_STR_STAT IGS_FI_F_TYP_CA_INST_ALL.FEE_TYPE_CI_STATUS
IGS_FI_F_TYP_CA_INST_ALL FK Joins to TableIGS_FI_FEE_TYPE_ALL IGS_FI_F_TYP_CA_INST_ALL.FEE_TYPE
IGS_FI_F_TYP_CA_INST_ALL FK Joins to TableIGS_CA_DA_INST IGS_FI_F_TYP_CA_INST_ALL.RETRO_DT_ALIAS
IGS_FI_F_TYP_CA_INST_ALL.RETRO_DAI_SEQUENCE_NUMBER
IGS_FI_F_TYP_CA_INST_ALL.FEE_CAL_TYPE
IGS_FI_F_TYP_CA_INST_ALL.FEE_CI_SEQUENCE_NUMBER
IGS_FI_F_TYP_CA_INST_ALL FK Joins to TableIGS_RU_RULE IGS_FI_F_TYP_CA_INST_ALL.RUL_SEQUENCE_NUMBER
IGS_FI_F_TYP_CA_INST_ALL FK Joins to TableIGS_FI_SUBACCTS_ALL IGS_FI_F_TYP_CA_INST_ALL.SUBACCOUNT_ID
IGS_FI_F_TYP_CA_INST_ALL FK Joins to TableIGS_CA_DA_INST IGS_FI_F_TYP_CA_INST_ALL.START_DT_ALIAS
IGS_FI_F_TYP_CA_INST_ALL.START_DAI_SEQUENCE_NUMBER
IGS_FI_F_TYP_CA_INST_ALL.FEE_CAL_TYPE
IGS_FI_F_TYP_CA_INST_ALL.FEE_CI_SEQUENCE_NUMBER
IGS_FI_F_TYP_CA_INST_ALL FK Joins to TableIGS_RU_RULE IGS_FI_F_TYP_CA_INST_ALL.SCOPE_RUL_SEQUENCE_NUM
IGS_FI_F_TYP_CA_INST_ALL FK Joins to Table% IGS_FI_F_TYP_CA_INST_ALL.ELM_RNG_ORDER_NAME
TableIGS_FI_CHG_MTH_APP_H_ALL FK Joins to IGS_FI_F_TYP_CA_INST_ALL IGS_FI_CHG_MTH_APP_H_ALL.FEE_TYPE
IGS_FI_CHG_MTH_APP_H_ALL.FEE_CAL_TYPE
IGS_FI_CHG_MTH_APP_H_ALL.FEE_CI_SEQUENCE_NUMBER
TableIGS_FI_CHG_MTH_APP FK Joins to IGS_FI_F_TYP_CA_INST_ALL IGS_FI_CHG_MTH_APP.FEE_TYPE
IGS_FI_CHG_MTH_APP.FEE_CAL_TYPE
IGS_FI_CHG_MTH_APP.FEE_CI_SEQUENCE_NUMBER
TableIGS_FI_DSBR_JNL_ALL FK Joins to IGS_FI_F_TYP_CA_INST_ALL IGS_FI_DSBR_JNL_ALL.FEE_TYPE
IGS_FI_DSBR_JNL_ALL.FEE_CAL_TYPE
IGS_FI_DSBR_JNL_ALL.FEE_CI_SEQUENCE_NUMBER
TableIGS_FI_DSBR_SPSHT FK Joins to IGS_FI_F_TYP_CA_INST_ALL IGS_FI_DSBR_SPSHT.FEE_TYPE
IGS_FI_DSBR_SPSHT.FEE_CAL_TYPE
IGS_FI_DSBR_SPSHT.FEE_CI_SEQUENCE_NUMBER
TableIGS_FI_ELM_RANGE_H_ALL FK Joins to IGS_FI_F_TYP_CA_INST_ALL IGS_FI_ELM_RANGE_H_ALL.FEE_TYPE
IGS_FI_ELM_RANGE_H_ALL.FEE_CAL_TYPE
IGS_FI_ELM_RANGE_H_ALL.FEE_CI_SEQUENCE_NUMBER
TableIGS_FI_ELM_RANGE FK Joins to IGS_FI_F_TYP_CA_INST_ALL IGS_FI_ELM_RANGE.FEE_TYPE
IGS_FI_ELM_RANGE.FEE_CAL_TYPE
IGS_FI_ELM_RANGE.FEE_CI_SEQUENCE_NUMBER
TableIGS_FI_FEE_AS_RT_H_ALL FK Joins to IGS_FI_F_TYP_CA_INST_ALL IGS_FI_FEE_AS_RT_H_ALL.FEE_TYPE
IGS_FI_FEE_AS_RT_H_ALL.FEE_CAL_TYPE
IGS_FI_FEE_AS_RT_H_ALL.FEE_CI_SEQUENCE_NUMBER
TableIGS_FI_ANC_RATES FK Joins to IGS_FI_F_TYP_CA_INST_ALL IGS_FI_ANC_RATES.FEE_TYPE
IGS_FI_ANC_RATES.FEE_CAL_TYPE
IGS_FI_ANC_RATES.FEE_CI_SEQUENCE_NUMBER
TableIGS_FI_FEE_AS_RATE FK Joins to 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
TableIGS_FI_FEE_AS_ALL FK Joins to IGS_FI_F_TYP_CA_INST_ALL IGS_FI_FEE_AS_ALL.FEE_TYPE
IGS_FI_FEE_AS_ALL.FEE_CAL_TYPE
IGS_FI_FEE_AS_ALL.FEE_CI_SEQUENCE_NUMBER
TableIGS_FI_F_CAT_FEE_LBL_ALL FK Joins to IGS_FI_F_TYP_CA_INST_ALL IGS_FI_F_CAT_FEE_LBL_ALL.FEE_TYPE
IGS_FI_F_CAT_FEE_LBL_ALL.FEE_CAL_TYPE
IGS_FI_F_CAT_FEE_LBL_ALL.FEE_CI_SEQUENCE_NUMBER
TableIGS_FI_FEE_DSB_FML_H_ALL FK Joins to IGS_FI_F_TYP_CA_INST_ALL IGS_FI_FEE_DSB_FML_H_ALL.FEE_TYPE
IGS_FI_FEE_DSB_FML_H_ALL.FEE_CAL_TYPE
IGS_FI_FEE_DSB_FML_H_ALL.FEE_CI_SEQUENCE_NUMBER
TableIGS_FI_FEE_ENCMB FK Joins to IGS_FI_F_TYP_CA_INST_ALL IGS_FI_FEE_ENCMB.FEE_TYPE
IGS_FI_FEE_ENCMB.FEE_CAL_TYPE
IGS_FI_FEE_ENCMB.FEE_CI_SEQUENCE_NUMBER
TableIGS_FI_F_TYPE_ACCTS_ALL FK Joins to IGS_FI_F_TYP_CA_INST_ALL IGS_FI_F_TYPE_ACCTS_ALL.FEE_TYPE
IGS_FI_F_TYPE_ACCTS_ALL.FEE_CAL_TYPE
IGS_FI_F_TYPE_ACCTS_ALL.FEE_CI_SEQUENCE_NUMBER
TableIGS_FI_F_PAY_SCHD_HT_ALL FK Joins to IGS_FI_F_TYP_CA_INST_ALL IGS_FI_F_PAY_SCHD_HT_ALL.FEE_TYPE
IGS_FI_F_PAY_SCHD_HT_ALL.FEE_CAL_TYPE
IGS_FI_F_PAY_SCHD_HT_ALL.FEE_CI_SEQUENCE_NUMBER
TableIGS_FI_FEE_PAY_SCHD FK Joins to IGS_FI_F_TYP_CA_INST_ALL IGS_FI_FEE_PAY_SCHD.FEE_TYPE
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_TYP_CA_INST_ALL IGS_FI_F_RET_SCHD_HT_ALL.FEE_TYPE
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_TYP_CA_INST_ALL IGS_FI_FEE_RET_SCHD.FEE_TYPE
IGS_FI_FEE_RET_SCHD.FEE_CAL_TYPE
IGS_FI_FEE_RET_SCHD.FEE_CI_SEQUENCE_NUMBER
TableIGS_FI_ANC_RT_SGMNTS FK Joins to IGS_FI_F_TYP_CA_INST_ALL IGS_FI_ANC_RT_SGMNTS.FEE_TYPE
IGS_FI_ANC_RT_SGMNTS.FEE_CAL_TYPE
IGS_FI_ANC_RT_SGMNTS.FEE_CI_SEQUENCE_NUMBER
TableIGS_FI_FTCI_ACCTS FK Joins to IGS_FI_F_TYP_CA_INST_ALL IGS_FI_FTCI_ACCTS.FEE_TYPE
IGS_FI_FTCI_ACCTS.FEE_CAL_TYPE
IGS_FI_FTCI_ACCTS.FEE_CI_SEQUENCE_NUMBER
TableIGS_FI_SPECIAL_FEES FK Joins to IGS_FI_F_TYP_CA_INST_ALL IGS_FI_SPECIAL_FEES.FEE_TYPE
IGS_FI_SPECIAL_FEES.FEE_CAL_TYPE
IGS_FI_SPECIAL_FEES.FEE_CI_SEQUENCE_NUMBER
TableIGS_FI_TP_RET_SCHD FK Joins to IGS_FI_F_TYP_CA_INST_ALL IGS_FI_TP_RET_SCHD.FEE_TYPE
IGS_FI_TP_RET_SCHD.FEE_CAL_TYPE
IGS_FI_TP_RET_SCHD.FEE_CI_SEQUENCE_NUMBER
TableIGS_PE_PND_FEE_ENCUM FK Joins to IGS_FI_F_TYP_CA_INST_ALL IGS_PE_PND_FEE_ENCUM.FEE_TYPE
IGS_PE_PND_FEE_ENCUM.FEE_CAL_TYPE
IGS_PE_PND_FEE_ENCUM.FEE_CI_SEQUENCE_NUMBER
TableIGS_FI_PER_PAY_SCHD_ALL FK Joins to IGS_FI_F_TYP_CA_INST_ALL IGS_FI_PER_PAY_SCHD_ALL.FEE_TYPE
IGS_FI_PER_PAY_SCHD_ALL.FEE_CAL_TYPE
IGS_FI_PER_PAY_SCHD_ALL.FEE_CI_SEQUENCE_NUMBER
TableIGS_FI_REFUNDS FK Joins to IGS_FI_F_TYP_CA_INST_ALL IGS_FI_REFUNDS.FEE_TYPE
IGS_FI_REFUNDS.FEE_CAL_TYPE
IGS_FI_REFUNDS.FEE_CI_SEQUENCE_NUMBER