Table: IGF_AP_BATCH_AW_MAP_ALL

Product:	IGF - Financial Aid
Description:	Stores the ISIR batch year and award year mapping
Implementation/DBA Data:	IGF.IGF_AP_BATCH_AW_MAP_ALL

Primary Key: IGF_AP_BATCH_AW_MAP_ALL_PK

1. BAM_ID

Primary Key: IGF_AP_BATCH_AW_MAP_ALL_UK1

1. BATCH_YEAR
2. ORG_ID

Primary Key: IGF_AP_BATCH_AW_MAP_ALL_UK2

1. CI_CAL_TYPE
2. CI_SEQUENCE_NUMBER

Primary Key: IGF_AP_BATCH_AW_MAP_ALL_UK3

1. CI_CAL_TYPE_ACAD
2. CI_SEQUENCE_NUMBER_ACAD

Primary Key: IGF_AP_BATCH_AW_MAP_ALL_UK4

1. CI_CAL_TYPE_ADM
2. CI_SEQUENCE_NUMBER_ADM

Primary Key: IGF_AP_BATCH_AW_MAP_ALL_UK5

1. CSS_ACADEMIC_YEAR

Primary Key: IGF_AP_BATCH_AW_MAP_ALL_UK6

1. SYS_AWARD_YEAR

Foreign Keys

Table		Foreign Table	Foreign Key Column
IGF_AP_BATCH_AW_MAP_ALL		IGS_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		IGS_CA_INST_ALL	IGF_AP_BATCH_AW_MAP_ALL.CI_CAL_TYPE IGF_AP_BATCH_AW_MAP_ALL.CI_SEQUENCE_NUMBER