FND Design Data [Home] [Help]

Table: IGF_AW_AWD_DIST_PLANS

Product: IGF - Financial Aid
Description: Award Distribution Plan Setup
Implementation/DBA Data: TableIGF.IGF_AW_AWD_DIST_PLANS
Primary Key: IGF_AW_AWD_DIST_PLANS_PK
  1. ColumnADPLANS_ID
Primary Key: IGF_AW_AWD_DIST_PLANS_UK
  1. ColumnAWD_DIST_PLAN_CD
  2. ColumnCAL_TYPE
  3. ColumnSEQUENCE_NUMBER
Foreign Keys
Table
Foreign Table Foreign Key Column
IGF_AW_AWD_DIST_PLANS FK Joins to TableIGS_CA_INST_ALL IGF_AW_AWD_DIST_PLANS.CAL_TYPE
IGF_AW_AWD_DIST_PLANS.SEQUENCE_NUMBER
TableIGF_AW_AWARD_ALL FK Joins to IGF_AW_AWD_DIST_PLANS IGF_AW_AWARD_ALL.ADPLANS_ID
TableIGF_AW_AWARD_LEVEL_HIST FK Joins to IGF_AW_AWD_DIST_PLANS IGF_AW_AWARD_LEVEL_HIST.OLD_ADPLANS_ID
TableIGF_AW_AWARD_LEVEL_HIST FK Joins to IGF_AW_AWD_DIST_PLANS IGF_AW_AWARD_LEVEL_HIST.NEW_ADPLANS_ID
TableIGF_AW_AWD_FRML_DET_ALL FK Joins to IGF_AW_AWD_DIST_PLANS IGF_AW_AWD_FRML_DET_ALL.ADPLANS_ID
TableIGF_AW_DP_TERMS FK Joins to IGF_AW_AWD_DIST_PLANS IGF_AW_DP_TERMS.ADPLANS_ID
TableIGF_AW_TARGET_GRP_ALL FK Joins to IGF_AW_AWD_DIST_PLANS IGF_AW_TARGET_GRP_ALL.ADPLANS_ID