Results for “igs_as_su_atmpt_itm”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

IGS_AS_SU_ATMPT_ITM is a Student System (IGS) table that stores assessment items allocated to a student's unit attempt. Each row represents one assessment item assigned to a specific student unit attempt, whether the allocation was performed manually or inherited from the unit's default assessment item set. In the Oracle E-Business Suite 12.1.1 and 12.2.2 architecture, this object sits within the assessment and grading sub-domain of the Student System, recording the assessment components a student is expected to complete and the resulting outcome data such as marks, grades, and submission status. The table is documented as Obsolete in ETRM, and the implementation note states it is not implemented in the reference database.

From a Data Vault modeling perspective, the heuristic classification derived from the foreign key structure is satellite-leaning. This suggests the table behaves primarily as a descriptive satellite that captures changing attributes and outcomes attached to a composite business key, rather than acting as a pure hub or link. The composite key composed of PERSON_ID, COURSE_CD, UOO_ID, ASS_ID, and CREATION_DT reinforces that interpretation, since it combines multiple identifying references with a point-in-time discriminator.

Key Information Stored

The table contains 61 documented columns. The most significant are the following:

• PERSON_ID, COURSE_CD, UOO_ID, ASS_ID, CREATION_DT — Together these form the primary key IGS_AS_SU_ATMPT_ITM_PK and identify the student, the course, the unit offering occurrence, the assessment item, and the allocation timestamp.
• ASS_ID — The assessment item identifier; the column most directly associated with the search term and a foreign key to IGS_AS_ASSESSMNT_ITM_ALL.
• UNIT_CD, CAL_TYPE, CI_SEQUENCE_NUMBER — Part of the unique key IGS_AS_SU_ATMPT_ITM_UK (with ASS_ID, PERSON_ID, COURSE_CD), providing the business-key candidate combination that distinguishes a given assessment allocation within a calendar context.
• ATTEMPT_NUMBER — The student's attempt sequence for the unit.
• MARK, GRADE, GRADING_SCHEMA_CD, GS_VERSION_NUMBER — The recorded outcome and the grading schema applied, with the grading references linking to IGS_AS_GRD_SCH_GRADE.
• PERFORMANCE, OUTCOME_DT, OUTCOME_COMMENT_CODE — Additional outcome descriptors and dates.
• OVERRIDE_DUE_DT — A manually overridden due date for the assessment item.
• S_DEFAULT_IND — Indicates whether the allocation was inherited from the unit's default assessment items.
• SUA_ASS_ITEM_GROUP_ID — Foreign key grouping allocated items, referencing IGS_AS_SUA_AI_GROUP.
• TRACKING_ID, ASS_PATTERN_ID — References to tracking items and assessment patterns.
• LOGICAL_DELETE_DT — Supports logical deletion semantics.
• WAIVED_FLAG, PENALTY_APPLIED_FLAG, SUBMITTED_DATE — Flags capturing waiver and penalty status alongside submission timing.

The surrogate-style primary key is the composite PERSON_ID/COURSE_CD/UOO_ID/ASS_ID/CREATION_DT combination; the distinct business-key candidate documented is IGS_AS_SU_ATMPT_ITM_UK.

Common Use Cases and Queries

Typical reporting scenarios include retrieving all assessment items allocated to a student for a given unit attempt, reviewing marks and grades by assessment item, and identifying default versus manually added allocations. A representative query pattern follows.

• Joining to IGS_AS_ASSESSMNT_ITM_ALL on ASS_ID to obtain assessment item descriptions alongside the student's MARK and GRADE.
• Filtering by PERSON_ID and COURSE_CD to list every assessment allocation for a student, ordered by CREATION_DT or OVERRIDE_DUE_DT.
• Using S_DEFAULT_IND to separate system-generated default allocations from manual entries.
• Aggregating MIDTERM_WEIGHT_QTY and FINAL_WEIGHT_QTY to validate weighting against assessment patterns.
• Filtering on LOGICAL_DELETE_DT IS NULL to exclude logically deleted rows.

Related Objects

The most significant related objects, with their join columns, are:

• IGS_AS_ASSESSMNT_ITM_ALL — joined on ASS_ID, the master assessment item definition.
• IGS_EN_SU_ATTEMPT_ALL — joined on PERSON_ID, COURSE_CD, and UOO_ID, the parent student unit attempt.
• IGS_AS_SUA_AI_GROUP — joined on SUA_ASS_ITEM_GROUP_ID, the assessment item grouping.
• IGS_TR_ITEM_ALL — joined on TRACKING_ID.
• IGS_AS_UNTAS_PATTERN_ALL — joined on ASS_PATTERN_ID, the assessment pattern definition.
• IGS_AS_GRD_SCH_GRADE — joined on GRADING_SCHEMA_CD, GS_VERSION_NUMBER, and GRADE.
• IGS_PS_UNITASS_ITEM and IGS_AS_UNITASS_ITEM_ALL — joined on UNIT_SECTION_ASS_ITEM_ID and UNIT_ASS_ITEM_ID respectively.
• Downstream referencing tables include IGS_AS_SUAAI_OUHIST, IGS_AS_SPL_CONS_APPL, and IGS_AS_STD_EXM_INSTN_ALL, each joining on PERSON_ID, COURSE_CD, UOO_ID, ASS_ID, and CREATION_DT.