FND Design Data [Home] [Help]

Table: IGS_PS_FEE_TRG

Product: IGS - Student System
Description: This entity describes the program based fee triggers. It is used during fee assessment processing to indicate a program-based fee applies for a fee type.
Implementation/DBA Data: TableIGS.IGS_PS_FEE_TRG
Primary Key: IGS_PS_FEE_TRG_PK
  1. ColumnFEE_CAT
  2. ColumnFEE_CAL_TYPE
  3. ColumnFEE_CI_SEQUENCE_NUMBER
  4. ColumnFEE_TYPE
  5. ColumnCOURSE_CD
  6. ColumnSEQUENCE_NUMBER
Foreign Keys
Table
Foreign Table Foreign Key Column
IGS_PS_FEE_TRG FK Joins to TableIGS_EN_ATD_MODE_ALL IGS_PS_FEE_TRG.ATTENDANCE_MODE
IGS_PS_FEE_TRG FK Joins to TableIGS_EN_ATD_TYPE_ALL IGS_PS_FEE_TRG.ATTENDANCE_TYPE
IGS_PS_FEE_TRG FK Joins to TableIGS_CA_TYPE IGS_PS_FEE_TRG.CAL_TYPE
IGS_PS_FEE_TRG FK Joins to TableIGS_PS_COURSE IGS_PS_FEE_TRG.COURSE_CD
IGS_PS_FEE_TRG FK Joins to TableIGS_FI_F_CAT_FEE_LBL_ALL IGS_PS_FEE_TRG.FEE_CAT
IGS_PS_FEE_TRG.FEE_CAL_TYPE
IGS_PS_FEE_TRG.FEE_CI_SEQUENCE_NUMBER
IGS_PS_FEE_TRG.FEE_TYPE
IGS_PS_FEE_TRG FK Joins to TableIGS_FI_FEE_TRG_GRP IGS_PS_FEE_TRG.FEE_CAT
IGS_PS_FEE_TRG.FEE_CAL_TYPE
IGS_PS_FEE_TRG.FEE_CI_SEQUENCE_NUMBER
IGS_PS_FEE_TRG.FEE_TYPE
IGS_PS_FEE_TRG.FEE_TRIGGER_GROUP_NUMBER
IGS_PS_FEE_TRG FK Joins to TableIGS_AD_LOCATION_ALL IGS_PS_FEE_TRG.LOCATION_CD