Results for “s_default_ind”

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

Overview

IGS_AS_SU_ATMPT_PAT is a table in the IGS schema (Oracle Student System) delivered with Oracle E-Business Suite 12.1.1 and 12.2.2. The ETRM metadata marks the object as VALID in the data dictionary but describes its functional purpose as Obsolete. In practice, this indicates a legacy structure retained for upgrade compatibility, historical data migration, and referential integrity rather than an active component of current Student System processing.

The name decomposes as Information Gateway Student Assessment — Student Unit — assessment attempt pattern. It associates a student's unit/course attempt with an assessment pattern definition, effectively capturing which assessment pattern applied to a particular attempt event. The suffix _PAT denotes the pattern association, distinguishing it from the attempt and attempt-all structures it references.

Based on the foreign key topology — references to IGS_EN_SU_ATTEMPT_ALL and IGS_AS_UNTAS_PATTERN_ALL — the Data Vault heuristic classifies this table as a link entity. As a modeling suggestion, it acts as an associative table resolving the many-to-many relationship between student assessment attempts and assessment patterns. It is not a hub (it owns no natural business key of its own) and not a pure satellite (it carries no descriptive attribute history), so link classification is the most defensible interpretation.

Key Information Stored

The documented physical schema for 12.1.1 contains 19 columns. The most significant are the composite primary key members and foreign key columns, which together define the business grain:

• PERSON_ID — the student identifier; also an FK to IGS_EN_SU_ATTEMPT_ALL.
• COURSE_CD — the course code of the attempt.
• UNIT_CD — the unit code, providing finer granularity than course.
• CAL_TYPE — the calendar type (e.g., academic period/year) qualifying the attempt.
• CI_SEQUENCE_NUMBER — the course-instance sequence, distinguishing repeat attempts within the same calendar.
• ASS_PATTERN_ID — FK to IGS_AS_UNTAS_PATTERN_ALL, identifying the assessment pattern applied.
• CREATION_DT — part of the primary key, distinguishing multiple pattern associations created over time.
• S_DEFAULT_IND — flag indicating whether this pattern is the default for the attempt.
• LOGICAL_DELETE_DT — soft-delete timestamp, consistent with the obsolete/legacy status.
• UOO_ID — unit offering option identifier, an additional structural link.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE — standard WHO audit columns; creation columns are typically NOT NULL.
• REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE — concurrent program context metadata.

The documented primary key is IGS_AS_SU_ATMPT_PAT_PK, a composite of UNIT_CD, COURSE_CD, PERSON_ID, CAL_TYPE, CI_SEQUENCE_NUMBER, ASS_PATTERN_ID, and CREATION_DT. There is no surrogate sequence-based key; the business key is therefore the full key set, and referential uniqueness is enforced through that composite.

Common Use Cases and Queries

Because the object is obsolete, query patterns center on data migration validation, historical reconciliation, and upgrade auditing rather than transactional reporting. Typical joins resolve a student attempt to the pattern applied:

• Attempt-to-pattern reconciliation — join IGS_AS_SU_ATMPT_PAT to IGS_EN_SU_ATTEMPT_ALL on PERSON_ID, COURSE_CD, UNIT_CD, CAL_TYPE, and CI_SEQUENCE_NUMBER to confirm each attempt carries a valid pattern association.
• Default-pattern audit — filter S_DEFAULT_IND = 'Y' and group by COURSE_CD/UNIT_CD to detect attempts with multiple or missing defaults.
• Soft-delete hygiene — identify rows where LOGICAL_DELETE_DT IS NULL versus populated, to determine whether legacy cleanup was completed.
• Concurrent program traceability — filter by REQUEST_ID or PROGRAM_APPLICATION_ID to trace which batch process inserted a given pattern linkage.

A representative pattern:
SELECT p.PERSON_ID, p.COURSE_CD, p.UNIT_CD, p.ASS_PATTERN_ID, p.S_DEFAULT_IND FROM igs_as_su_atmpt_pat p WHERE p.CAL_TYPE = :cal_type AND p.LOGICAL_DELETE_DT IS NULL;

Reporting should treat the table as historical; live assessment-pattern logic in 12.1.1/12.2.2 is served by the IGS_AS_UNTAS_PATTERN_ALL family rather than this linkage table.

Related Objects

The FK metadata identifies the principal dependencies. The most significant related objects are:

• IGS_EN_SU_ATTEMPT_ALL — parent attempt table; join on PERSON_ID, COURSE_CD, UNIT_CD, CAL_TYPE, CI_SEQUENCE_NUMBER. This is the primary referential dependency.
• IGS_AS_UNTAS_PATTERN_ALL — assessment pattern definition; join on ASS_PATTERN_ID. Supplies pattern descriptive context.
• IGS_AS_SU_ATMPT_PAT_PK — the supporting composite primary key index.
• Associated assessment/attempt staging and migration programs that populated this table prior to obsolescence.

Because the table is documented as obsolete, no current public APIs or active views are expected to depend on it. Its continued relevance is confined to upgrade scripts, historical reporting, and referential transparency with IGS_EN_SU_ATTEMPT_ALL and IGS_AS_UNTAS_PATTERN_ALL. Administrators auditing 12.1.1 to 12.2.2 upgrades should verify that no customizations still write to this link, since Oracle no longer maintains its functional behavior.