FND Design Data [Home] [Help]

Table: IGS_FI_UNIT_FEE_TRG

Product: IGS - Student System
Description: This entity describes the unit based fee triggers. It is used during fee assessment processing to indicate a unit based fee applies for a fee type.
Implementation/DBA Data: TableIGS.IGS_FI_UNIT_FEE_TRG
Primary Key: IGS_FI_UNIT_FEE_TRG_PK
  1. ColumnFEE_CAT
  2. ColumnFEE_CAL_TYPE
  3. ColumnFEE_CI_SEQUENCE_NUMBER
  4. ColumnFEE_TYPE
  5. ColumnUNIT_CD
  6. ColumnSEQUENCE_NUMBER
Primary Key: UFT_UK
  1. ColumnFEE_CAT
  2. ColumnFEE_CAL_TYPE
  3. ColumnFEE_CI_SEQUENCE_NUMBER
  4. ColumnFEE_TYPE
  5. ColumnUNIT_CD
  6. ColumnVERSION_NUMBER
  7. ColumnCAL_TYPE
  8. ColumnCI_SEQUENCE_NUMBER
  9. ColumnLOCATION_CD
  10. ColumnUNIT_CLASS
  11. ColumnCREATE_DT
Foreign Keys
Table
Foreign Table Foreign Key Column
IGS_FI_UNIT_FEE_TRG FK Joins to TableIGS_CA_TYPE IGS_FI_UNIT_FEE_TRG.CAL_TYPE
IGS_FI_UNIT_FEE_TRG FK Joins to TableIGS_CA_INST_ALL IGS_FI_UNIT_FEE_TRG.CAL_TYPE
IGS_FI_UNIT_FEE_TRG.CI_SEQUENCE_NUMBER
IGS_FI_UNIT_FEE_TRG FK Joins to TableIGS_FI_F_CAT_FEE_LBL_ALL IGS_FI_UNIT_FEE_TRG.FEE_CAT
IGS_FI_UNIT_FEE_TRG.FEE_CAL_TYPE
IGS_FI_UNIT_FEE_TRG.FEE_CI_SEQUENCE_NUMBER
IGS_FI_UNIT_FEE_TRG.FEE_TYPE
IGS_FI_UNIT_FEE_TRG FK Joins to TableIGS_FI_FEE_TRG_GRP IGS_FI_UNIT_FEE_TRG.FEE_CAT
IGS_FI_UNIT_FEE_TRG.FEE_CAL_TYPE
IGS_FI_UNIT_FEE_TRG.FEE_CI_SEQUENCE_NUMBER
IGS_FI_UNIT_FEE_TRG.FEE_TYPE
IGS_FI_UNIT_FEE_TRG.FEE_TRIGGER_GROUP_NUMBER
IGS_FI_UNIT_FEE_TRG FK Joins to TableIGS_AD_LOCATION_ALL IGS_FI_UNIT_FEE_TRG.LOCATION_CD
IGS_FI_UNIT_FEE_TRG FK Joins to TableIGS_AS_UNIT_CLASS_ALL IGS_FI_UNIT_FEE_TRG.UNIT_CLASS
IGS_FI_UNIT_FEE_TRG FK Joins to TableIGS_PS_UNIT IGS_FI_UNIT_FEE_TRG.UNIT_CD
IGS_FI_UNIT_FEE_TRG FK Joins to TableIGS_PS_UNIT_VER_ALL IGS_FI_UNIT_FEE_TRG.UNIT_CD
IGS_FI_UNIT_FEE_TRG.VERSION_NUMBER