FND Design Data [Home] [Help]

Table: IGS_AD_PS_APPL_INST_ALL

Product: IGS - Student System (Obsolete)
Description: Holds the request for program entry for an admission period
Implementation/DBA Data: Not implemented in this database
Primary Key: IGS_AD_PS_APPL_INST_PK
  1. ColumnPERSON_ID
  2. ColumnADMISSION_APPL_NUMBER
  3. ColumnNOMINATED_COURSE_CD
  4. ColumnSEQUENCE_NUMBER
Foreign Keys
Table
Foreign Table Foreign Key Column
IGS_AD_PS_APPL_INST_ALL FK Joins to TableIGS_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 FK Joins to TableIGS_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 FK Joins to TableIGS_AD_CNDNL_OFRSTAT IGS_AD_PS_APPL_INST_ALL.ADM_CNDTNL_OFFER_STATUS
IGS_AD_PS_APPL_INST_ALL FK Joins to TableIGS_AD_DOC_STAT IGS_AD_PS_APPL_INST_ALL.ADM_DOC_STATUS
IGS_AD_PS_APPL_INST_ALL FK Joins to TableIGS_AD_ENT_QF_STAT IGS_AD_PS_APPL_INST_ALL.ADM_ENTRY_QUAL_STATUS
IGS_AD_PS_APPL_INST_ALL FK Joins to TableIGS_AD_FEE_STAT IGS_AD_PS_APPL_INST_ALL.LATE_ADM_FEE_STATUS
IGS_AD_PS_APPL_INST_ALL FK Joins to TableIGS_EN_ATD_MODE_ALL IGS_AD_PS_APPL_INST_ALL.ATTENDANCE_MODE
IGS_AD_PS_APPL_INST_ALL FK Joins to TableIGS_AD_OFRDFRMT_STAT IGS_AD_PS_APPL_INST_ALL.ADM_OFFER_DFRMNT_STATUS
IGS_AD_PS_APPL_INST_ALL FK Joins to TableIGS_AD_OFR_RESP_STAT IGS_AD_PS_APPL_INST_ALL.ADM_OFFER_RESP_STATUS
IGS_AD_PS_APPL_INST_ALL FK Joins to TableIGS_AD_OU_STAT IGS_AD_PS_APPL_INST_ALL.ADM_OUTCOME_STATUS
IGS_AD_PS_APPL_INST_ALL FK Joins to TableIGS_EN_ATD_TYPE_ALL IGS_AD_PS_APPL_INST_ALL.ATTENDANCE_TYPE
IGS_AD_PS_APPL_INST_ALL FK Joins to TableIGS_CO_CAT IGS_AD_PS_APPL_INST_ALL.CORRESPONDENCE_CAT
IGS_AD_PS_APPL_INST_ALL FK Joins to TableIGS_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 FK Joins to TableIGS_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 FK Joins to TableIGS_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 FK Joins to TableIGS_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 FK Joins to TableIGS_PS_COURSE IGS_AD_PS_APPL_INST_ALL.COURSE_CD
IGS_AD_PS_APPL_INST_ALL FK Joins to TableIGS_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 FK Joins to TableIGS_EN_ENROLMENT_CAT IGS_AD_PS_APPL_INST_ALL.ENROLMENT_CAT
IGS_AD_PS_APPL_INST_ALL FK Joins to TableIGS_FI_FEE_CAT_ALL IGS_AD_PS_APPL_INST_ALL.FEE_CAT
IGS_AD_PS_APPL_INST_ALL FK Joins to TableIGS_FI_FUND_SRC_ALL IGS_AD_PS_APPL_INST_ALL.FUNDING_SOURCE
IGS_AD_PS_APPL_INST_ALL FK Joins to TableIGS_FI_HECS_PAY_OPTN IGS_AD_PS_APPL_INST_ALL.HECS_PAYMENT_OPTION
IGS_AD_PS_APPL_INST_ALL FK Joins to TableIGS_AD_LOCATION_ALL IGS_AD_PS_APPL_INST_ALL.LOCATION_CD
IGS_AD_PS_APPL_INST_ALL FK Joins to TableIGS_TR_ITEM_ALL IGS_AD_PS_APPL_INST_ALL.ASS_TRACKING_ID
IGS_AD_PS_APPL_INST_ALL FK Joins to TableIGS_TR_ITEM_ALL IGS_AD_PS_APPL_INST_ALL.DEFERRED_TRACKING_ID
IGS_AD_PS_APPL_INST_ALL FK Joins to TableIGS_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 FK Joins to TableHZ_PARTIES IGS_AD_PS_APPL_INST_ALL.ADM_OTCM_STATUS_AUTH_PERSON_ID
IGS_AD_PS_APPL_INST_ALL FK Joins to TableIGS_AD_APPL_STAT IGS_AD_PS_APPL_INST_ALL.APPL_INST_STATUS
TableIGS_AD_APLINS_ADMREQ FK Joins to 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
TableIGS_AD_APPL_EVAL FK Joins to 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
TableIGS_AD_APPL_NOTES FK Joins to 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
TableIGS_AD_APPL_PGMAPPRV FK Joins to 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
TableIGS_AD_PS_APLINSTUNT_ALL FK Joins to 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
TableIGS_AD_EDUGOAL FK Joins to 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
TableIGS_RE_CANDIDATURE_ALL FK Joins to 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
TableIGS_HE_AD_DTL_ALL FK Joins to 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
TableIGS_AD_APPL_ARP FK Joins to 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
TableIGS_AD_APPQUAL_CODE FK Joins to 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
TableIGS_AD_PANEL_DTLS FK Joins to 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
TableIGS_PE_TYP_INSTANCES_ALL FK Joins to 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
TableIGS_AD_SPL_ADM_CAT FK Joins to 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
TableIGS_EN_STDNT_PS_ATT_ALL FK Joins to 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