Table: IGS_AS_SU_ATMPT_ITM

Product:	IGS - Student System
Description:	Describes assessment item allocated to student unit attempt, either manually or by unit's default assessment items
Implementation/DBA Data:	IGS.IGS_AS_SU_ATMPT_ITM

Primary Key: IGS_AS_SU_ATMPT_ITM_PK

1. PERSON_ID
2. COURSE_CD
3. UOO_ID
4. ASS_ID
5. CREATION_DT

Primary Key: IGS_AS_SU_ATMPT_ITM_UK

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

Foreign Keys

Table		Foreign Table	Foreign Key Column
IGS_AS_SU_ATMPT_ITM		IGS_AS_ASSESSMNT_ITM_ALL	IGS_AS_SU_ATMPT_ITM.ASS_ID
IGS_AS_SU_ATMPT_ITM		IGS_AS_SUA_AI_GROUP	IGS_AS_SU_ATMPT_ITM.SUA_ASS_ITEM_GROUP_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_ITM		IGS_TR_ITEM_ALL	IGS_AS_SU_ATMPT_ITM.TRACKING_ID
IGS_AS_SU_ATMPT_ITM		IGS_AS_UNTAS_PATTERN_ALL	IGS_AS_SU_ATMPT_ITM.ASS_PATTERN_ID
IGS_AS_SU_ATMPT_ITM		IGS_AS_GRD_SCH_GRADE	IGS_AS_SU_ATMPT_ITM.GRADING_SCHEMA_CD IGS_AS_SU_ATMPT_ITM.GS_VERSION_NUMBER IGS_AS_SU_ATMPT_ITM.GRADE
IGS_AS_SUAAI_OUHIST		IGS_AS_SU_ATMPT_ITM	IGS_AS_SUAAI_OUHIST.PERSON_ID IGS_AS_SUAAI_OUHIST.COURSE_CD IGS_AS_SUAAI_OUHIST.UOO_ID IGS_AS_SUAAI_OUHIST.ASS_ID IGS_AS_SUAAI_OUHIST.CREATION_DT
IGS_AS_SPL_CONS_APPL		IGS_AS_SU_ATMPT_ITM	IGS_AS_SPL_CONS_APPL.PERSON_ID IGS_AS_SPL_CONS_APPL.COURSE_CD IGS_AS_SPL_CONS_APPL.UOO_ID IGS_AS_SPL_CONS_APPL.ASS_ID IGS_AS_SPL_CONS_APPL.CREATION_DT
IGS_AS_STD_EXM_INSTN_ALL		IGS_AS_SU_ATMPT_ITM	IGS_AS_STD_EXM_INSTN_ALL.PERSON_ID IGS_AS_STD_EXM_INSTN_ALL.COURSE_CD IGS_AS_STD_EXM_INSTN_ALL.UOO_ID IGS_AS_STD_EXM_INSTN_ALL.ASS_ID IGS_AS_STD_EXM_INSTN_ALL.CREATION_DT