Table: IGS_AD_APP_REQ

Product:	IGS - Student System
Description:	Holds applicant's application requirements
Implementation/DBA Data:	IGS.IGS_AD_APP_REQ

Primary Key: ADAR_UK

1. PERSON_ID
2. ADMISSION_APPL_NUMBER

Primary Key: IGS_AD_APP_REQ_PK

1. APP_REQ_ID

Primary Key: IGS_AD_APP_REQ_UK

1. PERSON_ID
2. ADMISSION_APPL_NUMBER
3. APPLICANT_FEE_TYPE

Foreign Keys

Table		Foreign Table	Foreign Key Column
IGS_AD_APP_REQ		IGS_AD_APPL_ALL	IGS_AD_APP_REQ.PERSON_ID IGS_AD_APP_REQ.ADMISSION_APPL_NUMBER
IGS_AD_APP_REQ		IGS_AD_CODE_CLASSES	IGS_AD_APP_REQ.APPLICANT_FEE_STATUS
IGS_AD_APP_REQ		IGS_AD_APPL_ALL	IGS_AD_APP_REQ.PERSON_ID IGS_AD_APP_REQ.ADMISSION_APPL_NUMBER
IGS_AD_APP_REQ		IGS_FI_ACC_ALL	IGS_AD_APP_REQ.REV_ACCOUNT_CD
IGS_AD_APP_REQ		IGS_FI_ACC_ALL	IGS_AD_APP_REQ.CASH_ACCOUNT_CD