FND Design Data [Home] [Help]

Table: IGF_AP_BATCH_AW_MAP_ALL

Product: IGF - Financial Aid (Obsolete)
Description: Stores the ISIR batch year and award year mapping
Implementation/DBA Data: Not implemented in this database
Primary Key: IGF_AP_BATCH_AW_MAP_ALL_PK
  1. ColumnBAM_ID
Primary Key: IGF_AP_BATCH_AW_MAP_ALL_UK1
  1. ColumnBATCH_YEAR
  2. ColumnORG_ID
Primary Key: IGF_AP_BATCH_AW_MAP_ALL_UK2
  1. ColumnCI_CAL_TYPE
  2. ColumnCI_SEQUENCE_NUMBER
Primary Key: IGF_AP_BATCH_AW_MAP_ALL_UK3
  1. ColumnCI_CAL_TYPE_ACAD
  2. ColumnCI_SEQUENCE_NUMBER_ACAD
Primary Key: IGF_AP_BATCH_AW_MAP_ALL_UK4
  1. ColumnCI_CAL_TYPE_ADM
  2. ColumnCI_SEQUENCE_NUMBER_ADM
Primary Key: IGF_AP_BATCH_AW_MAP_ALL_UK5
  1. ColumnCSS_ACADEMIC_YEAR
Primary Key: IGF_AP_BATCH_AW_MAP_ALL_UK6
  1. ColumnSYS_AWARD_YEAR
Foreign Keys
Table
Foreign Table Foreign Key Column
IGF_AP_BATCH_AW_MAP_ALL FK Joins to TableIGS_CA_INST_ALL IGF_AP_BATCH_AW_MAP_ALL.CI_CAL_TYPE_ACAD
IGF_AP_BATCH_AW_MAP_ALL.CI_SEQUENCE_NUMBER_ACAD
IGF_AP_BATCH_AW_MAP_ALL FK Joins to TableIGS_CA_INST_ALL IGF_AP_BATCH_AW_MAP_ALL.CI_CAL_TYPE
IGF_AP_BATCH_AW_MAP_ALL.CI_SEQUENCE_NUMBER