Table: IGS_AD_PS_APPL_INST_ALL

Product:	IGS - Student System
Description:	Holds the request for program entry for an admission period
Implementation/DBA Data:	IGS.IGS_AD_PS_APPL_INST_ALL

Primary Key: IGS_AD_PS_APPL_INST_PK

1. PERSON_ID
2. ADMISSION_APPL_NUMBER
3. NOMINATED_COURSE_CD
4. SEQUENCE_NUMBER

Foreign Keys

Table		Foreign Table	Foreign Key Column
IGS_AD_PS_APPL_INST_ALL		IGS_AD_APPL_ALL	IGS_AD_PS_APPL_INST_ALL.PERSON_ID IGS_AD_PS_APPL_INST_ALL.ADMISSION_APPL_NUMBER
IGS_AD_PS_APPL_INST_ALL		IGS_AD_PS_APPL_ALL	IGS_AD_PS_APPL_INST_ALL.PERSON_ID IGS_AD_PS_APPL_INST_ALL.ADMISSION_APPL_NUMBER IGS_AD_PS_APPL_INST_ALL.NOMINATED_COURSE_CD
IGS_AD_PS_APPL_INST_ALL		IGS_AD_CNDNL_OFRSTAT	IGS_AD_PS_APPL_INST_ALL.ADM_CNDTNL_OFFER_STATUS
IGS_AD_PS_APPL_INST_ALL		IGS_AD_DOC_STAT	IGS_AD_PS_APPL_INST_ALL.ADM_DOC_STATUS
IGS_AD_PS_APPL_INST_ALL		IGS_AD_ENT_QF_STAT	IGS_AD_PS_APPL_INST_ALL.ADM_ENTRY_QUAL_STATUS
IGS_AD_PS_APPL_INST_ALL		IGS_AD_FEE_STAT	IGS_AD_PS_APPL_INST_ALL.LATE_ADM_FEE_STATUS
IGS_AD_PS_APPL_INST_ALL		IGS_EN_ATD_MODE_ALL	IGS_AD_PS_APPL_INST_ALL.ATTENDANCE_MODE
IGS_AD_PS_APPL_INST_ALL		IGS_AD_OFRDFRMT_STAT	IGS_AD_PS_APPL_INST_ALL.ADM_OFFER_DFRMNT_STATUS
IGS_AD_PS_APPL_INST_ALL		IGS_AD_OFR_RESP_STAT	IGS_AD_PS_APPL_INST_ALL.ADM_OFFER_RESP_STATUS
IGS_AD_PS_APPL_INST_ALL		IGS_AD_OU_STAT	IGS_AD_PS_APPL_INST_ALL.ADM_OUTCOME_STATUS
IGS_AD_PS_APPL_INST_ALL		IGS_EN_ATD_TYPE_ALL	IGS_AD_PS_APPL_INST_ALL.ATTENDANCE_TYPE
IGS_AD_PS_APPL_INST_ALL		IGS_CO_CAT	IGS_AD_PS_APPL_INST_ALL.CORRESPONDENCE_CAT
IGS_AD_PS_APPL_INST_ALL		IGS_CA_INST_ALL	IGS_AD_PS_APPL_INST_ALL.DEFERRED_ADM_CAL_TYPE IGS_AD_PS_APPL_INST_ALL.DEFERRED_ADM_CI_SEQUENCE_NUM
IGS_AD_PS_APPL_INST_ALL		IGS_CA_INST_ALL	IGS_AD_PS_APPL_INST_ALL.ADM_CAL_TYPE IGS_AD_PS_APPL_INST_ALL.ADM_CI_SEQUENCE_NUMBER
IGS_AD_PS_APPL_INST_ALL		IGS_CA_INST_ALL	IGS_AD_PS_APPL_INST_ALL.FUTURE_ACAD_CAL_TYPE IGS_AD_PS_APPL_INST_ALL.FUTURE_ACAD_CI_SEQUENCE_NUMBER
IGS_AD_PS_APPL_INST_ALL		IGS_CA_INST_ALL	IGS_AD_PS_APPL_INST_ALL.FUTURE_ADM_CAL_TYPE IGS_AD_PS_APPL_INST_ALL.FUTURE_ADM_CI_SEQUENCE_NUMBER
IGS_AD_PS_APPL_INST_ALL		IGS_PS_COURSE	IGS_AD_PS_APPL_INST_ALL.COURSE_CD
IGS_AD_PS_APPL_INST_ALL		IGS_PS_VER_ALL	IGS_AD_PS_APPL_INST_ALL.COURSE_CD IGS_AD_PS_APPL_INST_ALL.CRV_VERSION_NUMBER
IGS_AD_PS_APPL_INST_ALL		IGS_EN_ENROLMENT_CAT	IGS_AD_PS_APPL_INST_ALL.ENROLMENT_CAT
IGS_AD_PS_APPL_INST_ALL		IGS_FI_FEE_CAT_ALL	IGS_AD_PS_APPL_INST_ALL.FEE_CAT
IGS_AD_PS_APPL_INST_ALL		IGS_FI_FUND_SRC_ALL	IGS_AD_PS_APPL_INST_ALL.FUNDING_SOURCE
IGS_AD_PS_APPL_INST_ALL		IGS_FI_HECS_PAY_OPTN	IGS_AD_PS_APPL_INST_ALL.HECS_PAYMENT_OPTION
IGS_AD_PS_APPL_INST_ALL		IGS_AD_LOCATION_ALL	IGS_AD_PS_APPL_INST_ALL.LOCATION_CD
IGS_AD_PS_APPL_INST_ALL		IGS_TR_ITEM_ALL	IGS_AD_PS_APPL_INST_ALL.ASS_TRACKING_ID
IGS_AD_PS_APPL_INST_ALL		IGS_TR_ITEM_ALL	IGS_AD_PS_APPL_INST_ALL.DEFERRED_TRACKING_ID
IGS_AD_PS_APPL_INST_ALL		IGS_EN_UNIT_SET_ALL	IGS_AD_PS_APPL_INST_ALL.UNIT_SET_CD IGS_AD_PS_APPL_INST_ALL.US_VERSION_NUMBER
IGS_AD_PS_APPL_INST_ALL		HZ_PARTIES	IGS_AD_PS_APPL_INST_ALL.ADM_OTCM_STATUS_AUTH_PERSON_ID
IGS_AD_PS_APPL_INST_ALL		IGS_AD_APPL_STAT	IGS_AD_PS_APPL_INST_ALL.APPL_INST_STATUS
IGS_AD_APLINS_ADMREQ		IGS_AD_PS_APPL_INST_ALL	IGS_AD_APLINS_ADMREQ.PERSON_ID IGS_AD_APLINS_ADMREQ.ADMISSION_APPL_NUMBER IGS_AD_APLINS_ADMREQ.COURSE_CD IGS_AD_APLINS_ADMREQ.SEQUENCE_NUMBER
IGS_AD_APPL_EVAL		IGS_AD_PS_APPL_INST_ALL	IGS_AD_APPL_EVAL.PERSON_ID IGS_AD_APPL_EVAL.ADMISSION_APPL_NUMBER IGS_AD_APPL_EVAL.NOMINATED_COURSE_CD IGS_AD_APPL_EVAL.SEQUENCE_NUMBER
IGS_AD_APPL_NOTES		IGS_AD_PS_APPL_INST_ALL	IGS_AD_APPL_NOTES.PERSON_ID IGS_AD_APPL_NOTES.ADMISSION_APPL_NUMBER IGS_AD_APPL_NOTES.NOMINATED_COURSE_CD IGS_AD_APPL_NOTES.SEQUENCE_NUMBER
IGS_AD_APPL_PGMAPPRV		IGS_AD_PS_APPL_INST_ALL	IGS_AD_APPL_PGMAPPRV.PERSON_ID IGS_AD_APPL_PGMAPPRV.ADMISSION_APPL_NUMBER IGS_AD_APPL_PGMAPPRV.NOMINATED_COURSE_CD IGS_AD_APPL_PGMAPPRV.SEQUENCE_NUMBER
IGS_AD_PS_APLINSTUNT_ALL		IGS_AD_PS_APPL_INST_ALL	IGS_AD_PS_APLINSTUNT_ALL.PERSON_ID IGS_AD_PS_APLINSTUNT_ALL.ADMISSION_APPL_NUMBER IGS_AD_PS_APLINSTUNT_ALL.NOMINATED_COURSE_CD IGS_AD_PS_APLINSTUNT_ALL.ACAI_SEQUENCE_NUMBER
IGS_AD_EDUGOAL		IGS_AD_PS_APPL_INST_ALL	IGS_AD_EDUGOAL.PERSON_ID IGS_AD_EDUGOAL.ADMISSION_APPL_NUMBER IGS_AD_EDUGOAL.NOMINATED_COURSE_CD IGS_AD_EDUGOAL.SEQUENCE_NUMBER
IGS_RE_CANDIDATURE_ALL		IGS_AD_PS_APPL_INST_ALL	IGS_RE_CANDIDATURE_ALL.PERSON_ID IGS_RE_CANDIDATURE_ALL.ACAI_ADMISSION_APPL_NUMBER IGS_RE_CANDIDATURE_ALL.ACAI_NOMINATED_COURSE_CD IGS_RE_CANDIDATURE_ALL.ACAI_SEQUENCE_NUMBER
IGS_HE_AD_DTL_ALL		IGS_AD_PS_APPL_INST_ALL	IGS_HE_AD_DTL_ALL.PERSON_ID IGS_HE_AD_DTL_ALL.ADMISSION_APPL_NUMBER IGS_HE_AD_DTL_ALL.NOMINATED_COURSE_CD IGS_HE_AD_DTL_ALL.SEQUENCE_NUMBER
IGS_AD_APPL_ARP		IGS_AD_PS_APPL_INST_ALL	IGS_AD_APPL_ARP.PERSON_ID IGS_AD_APPL_ARP.ADMISSION_APPL_NUMBER IGS_AD_APPL_ARP.NOMINATED_COURSE_CD IGS_AD_APPL_ARP.SEQUENCE_NUMBER
IGS_AD_APPQUAL_CODE		IGS_AD_PS_APPL_INST_ALL	IGS_AD_APPQUAL_CODE.PERSON_ID IGS_AD_APPQUAL_CODE.ADMISSION_APPL_NUMBER IGS_AD_APPQUAL_CODE.NOMINATED_COURSE_CD IGS_AD_APPQUAL_CODE.SEQUENCE_NUMBER
IGS_AD_PANEL_DTLS		IGS_AD_PS_APPL_INST_ALL	IGS_AD_PANEL_DTLS.PERSON_ID IGS_AD_PANEL_DTLS.ADMISSION_APPL_NUMBER IGS_AD_PANEL_DTLS.NOMINATED_COURSE_CD IGS_AD_PANEL_DTLS.SEQUENCE_NUMBER
IGS_PE_TYP_INSTANCES_ALL		IGS_AD_PS_APPL_INST_ALL	IGS_PE_TYP_INSTANCES_ALL.PERSON_ID IGS_PE_TYP_INSTANCES_ALL.ADMISSION_APPL_NUMBER IGS_PE_TYP_INSTANCES_ALL.NOMINATED_COURSE_CD IGS_PE_TYP_INSTANCES_ALL.SEQUENCE_NUMBER
IGS_AD_SPL_ADM_CAT		IGS_AD_PS_APPL_INST_ALL	IGS_AD_SPL_ADM_CAT.PERSON_ID IGS_AD_SPL_ADM_CAT.ADMISSION_APPL_NUMBER IGS_AD_SPL_ADM_CAT.NOMINATED_COURSE_CD IGS_AD_SPL_ADM_CAT.SEQUENCE_NUMBER
IGS_EN_STDNT_PS_ATT_ALL		IGS_AD_PS_APPL_INST_ALL	IGS_EN_STDNT_PS_ATT_ALL.PERSON_ID IGS_EN_STDNT_PS_ATT_ALL.ADM_ADMISSION_APPL_NUMBER IGS_EN_STDNT_PS_ATT_ALL.ADM_NOMINATED_COURSE_CD IGS_EN_STDNT_PS_ATT_ALL.ADM_SEQUENCE_NUMBER