Table: IGS_EN_SU_ATTEMPT_ALL

Product:	IGS - Student System
Description:	This entity describes a student's attempt at studying a particular unit offered by the university. This table is modified to capture the Organizational unit code for the student finance requirements.
Implementation/DBA Data:	IGS.IGS_EN_SU_ATTEMPT_ALL

Primary Key: IGS_AS_SU_ATTEMPT_ALL_PK

1. PERSON_ID
2. COURSE_CD
3. UNIT_CD
4. CAL_TYPE
5. CI_SEQUENCE_NUMBER

Primary Key: IGS_EN_SU_ATTEMPT_ALL_PK

1. PERSON_ID
2. COURSE_CD
3. UOO_ID

Foreign Keys

Table		Foreign Table	Foreign Key Column
IGS_EN_SU_ATTEMPT_ALL		HZ_PARTIES	IGS_EN_SU_ATTEMPT_ALL.RULE_WAIVED_PERSON_ID
IGS_EN_SU_ATTEMPT_ALL		IGS_AD_ADM_UNIT_STAT_ALL	IGS_EN_SU_ATTEMPT_ALL.ADMINISTRATIVE_UNIT_STATUS
IGS_EN_SU_ATTEMPT_ALL		IGS_CA_INST_ALL	IGS_EN_SU_ATTEMPT_ALL.CAL_TYPE IGS_EN_SU_ATTEMPT_ALL.CI_SEQUENCE_NUMBER IGS_EN_SU_ATTEMPT_ALL.CI_START_DT IGS_EN_SU_ATTEMPT_ALL.CI_END_DT
IGS_EN_SU_ATTEMPT_ALL		IGS_CA_INST_ALL	IGS_EN_SU_ATTEMPT_ALL.CAL_TYPE IGS_EN_SU_ATTEMPT_ALL.CI_SEQUENCE_NUMBER IGS_EN_SU_ATTEMPT_ALL.CI_START_DT IGS_EN_SU_ATTEMPT_ALL.CI_END_DT
IGS_EN_SU_ATTEMPT_ALL		IGS_AD_LOCATION_ALL	IGS_EN_SU_ATTEMPT_ALL.EXAM_LOCATION_CD
IGS_EN_SU_ATTEMPT_ALL		IGS_EN_STDNT_PS_ATT_ALL	IGS_EN_SU_ATTEMPT_ALL.PERSON_ID IGS_EN_SU_ATTEMPT_ALL.COURSE_CD
IGS_EN_SU_ATTEMPT_ALL		IGS_PS_UNIT_VER_ALL	IGS_EN_SU_ATTEMPT_ALL.SUP_UNIT_CD IGS_EN_SU_ATTEMPT_ALL.SUP_VERSION_NUMBER
IGS_EN_SU_ATTEMPT_ALL		IGS_PS_UNIT_OFR_OPT_ALL	IGS_EN_SU_ATTEMPT_ALL.UNIT_CD IGS_EN_SU_ATTEMPT_ALL.VERSION_NUMBER IGS_EN_SU_ATTEMPT_ALL.CAL_TYPE IGS_EN_SU_ATTEMPT_ALL.CI_SEQUENCE_NUMBER IGS_EN_SU_ATTEMPT_ALL.LOCATION_CD IGS_EN_SU_ATTEMPT_ALL.UNIT_CLASS
IGS_EN_SU_ATTEMPT_ALL		IGS_PS_UNIT_OFR_OPT_ALL	IGS_EN_SU_ATTEMPT_ALL.UOO_ID
IGS_EN_SU_ATTEMPT_ALL		IGS_PS_UNIT_OFR_OPT_ALL	IGS_EN_SU_ATTEMPT_ALL.UOO_ID
IGS_EN_SU_ATTEMPT_ALL		IGS_PS_UNIT_VER_ALL	IGS_EN_SU_ATTEMPT_ALL.UNIT_CD IGS_EN_SU_ATTEMPT_ALL.VERSION_NUMBER
IGS_AS_ANON_ID_US		IGS_EN_SU_ATTEMPT_ALL	IGS_AS_ANON_ID_US.PERSON_ID IGS_AS_ANON_ID_US.COURSE_CD IGS_AS_ANON_ID_US.UOO_ID
IGS_AS_SUA_SES_ATTS		IGS_EN_SU_ATTEMPT_ALL	IGS_AS_SUA_SES_ATTS.PERSON_ID IGS_AS_SUA_SES_ATTS.COURSE_CD IGS_AS_SUA_SES_ATTS.UOO_ID
IGS_FI_DSB_DTL_ALC		IGS_EN_SU_ATTEMPT_ALL	IGS_FI_DSB_DTL_ALC.PERSON_ID IGS_FI_DSB_DTL_ALC.COURSE_CD IGS_FI_DSB_DTL_ALC.UNIT_CD IGS_FI_DSB_DTL_ALC.TEACH_CAL_TYPE IGS_FI_DSB_DTL_ALC.TEACH_CI_SEQUENCE_NUMBER
IGS_EN_SPLACEMENTS		IGS_EN_SU_ATTEMPT_ALL	IGS_EN_SPLACEMENTS.PERSON_ID IGS_EN_SPLACEMENTS.COURSE_CD IGS_EN_SPLACEMENTS.UOO_ID
IGS_EN_SU_ATTEMPT_H_ALL		IGS_EN_SU_ATTEMPT_ALL	IGS_EN_SU_ATTEMPT_H_ALL.PERSON_ID IGS_EN_SU_ATTEMPT_H_ALL.COURSE_CD IGS_EN_SU_ATTEMPT_H_ALL.UOO_ID
IGS_AS_MSHT_SU_ATMPT		IGS_EN_SU_ATTEMPT_ALL	IGS_AS_MSHT_SU_ATMPT.PERSON_ID IGS_AS_MSHT_SU_ATMPT.COURSE_CD IGS_AS_MSHT_SU_ATMPT.UOO_ID
IGS_AS_CHN_GRD_REQ		IGS_EN_SU_ATTEMPT_ALL	IGS_AS_CHN_GRD_REQ.PERSON_ID IGS_AS_CHN_GRD_REQ.COURSE_CD IGS_AS_CHN_GRD_REQ.UOO_ID
IGS_AS_SUA_AI_GROUP		IGS_EN_SU_ATTEMPT_ALL	IGS_AS_SUA_AI_GROUP.PERSON_ID IGS_AS_SUA_AI_GROUP.COURSE_CD IGS_AS_SUA_AI_GROUP.UOO_ID
IGS_AS_SU_ATMPT_ITM		IGS_EN_SU_ATTEMPT_ALL	IGS_AS_SU_ATMPT_ITM.PERSON_ID IGS_AS_SU_ATMPT_ITM.COURSE_CD IGS_AS_SU_ATMPT_ITM.UOO_ID
IGS_AS_SU_ATMPT_PAT		IGS_EN_SU_ATTEMPT_ALL	IGS_AS_SU_ATMPT_PAT.PERSON_ID IGS_AS_SU_ATMPT_PAT.COURSE_CD IGS_AS_SU_ATMPT_PAT.UNIT_CD IGS_AS_SU_ATMPT_PAT.CAL_TYPE IGS_AS_SU_ATMPT_PAT.CI_SEQUENCE_NUMBER
IGS_AS_SU_STMPTOUT_ALL		IGS_EN_SU_ATTEMPT_ALL	IGS_AS_SU_STMPTOUT_ALL.PERSON_ID IGS_AS_SU_STMPTOUT_ALL.COURSE_CD IGS_AS_SU_STMPTOUT_ALL.UOO_ID
IGS_AS_SUA_REF_CDS		IGS_EN_SU_ATTEMPT_ALL	IGS_AS_SUA_REF_CDS.PERSON_ID IGS_AS_SUA_REF_CDS.COURSE_CD IGS_AS_SUA_REF_CDS.UOO_ID
IGS_PS_STDNT_UNT_TRN		IGS_EN_SU_ATTEMPT_ALL	IGS_PS_STDNT_UNT_TRN.PERSON_ID IGS_PS_STDNT_UNT_TRN.COURSE_CD IGS_PS_STDNT_UNT_TRN.UOO_ID