Search Results igs_as_susa_v

Overview

The view IGS_AS_SUSA_V is an Oracle E-Business Suite database object owned by the APPS schema and classified under the IGS - Student System product family. It is documented in ETRM as a "View for Student unit bset attempt," and its status is marked VALID in both Oracle EBS 12.1.1 and 12.2.2. The view presents a hierarchical, indented representation of student unit set attempt records, derived from the base table IGS_AS_SU_SETATMPT. Because it exposes a flattened, level-prefixed description of the parent-child relationship between unit set attempts, it is intended primarily for reporting, inquiry, and integration scenarios where a readable, hierarchy-aware snapshot of student unit set enrollment is required rather than the raw normalized rows held in the underlying table.

Underlying Base Objects

The documented base object for this view is IGS_AS_SU_SETATMPT, the student unit set attempt table within the IGS (Student System) module. The ETRM metadata for IGS_AS_SUSA_V in 12.2.2 does not enumerate additional referenced base objects, and no other dependencies are documented. The view is a simple projection with a hierarchical transformation: it selects the identifying and auditing columns from IGS_AS_SU_SETATMPT and applies a CONNECT BY clause anchored on rows where PARENT_UNIT_SET_CD IS NULL, joining each level back to its parent through the combination of PERSON_ID, COURSE_CD, UNIT_SET_CD, and SEQUENCE_NUMBER. This creates a tree structure over the attempt records for a given person and course, so the view effectively maps one flat table row to one node in a student's unit set attempt hierarchy.

Key Columns

The view exposes the following columns, each aligned to a column in IGS_AS_SU_SETATMPT except for the display column, which is computed:

• PERSON_ID — Identifier of the student (person) to whom the unit set attempt belongs; the top-level partitioning key for the hierarchy.
• COURSE_CD — Code of the course under which the unit set attempt is recorded.
• UNIT_SET_CD — Code of the unit set being attempted; also the column used to establish the parent-child linkage.
• SEQUENCE_NUMBER — Sequence number qualifying the unit set attempt instance.
• US_VERSION_NUMBER — Version number of the unit set attempt record.
• UNIT_SET_CD_DISPLAY_LVL — A computed display column produced by SUBSTR(LPAD(' ', 2*(LEVEL-1)) || UNIT_SET_CD, 1, 40), which indents the unit set code according to its depth in the hierarchy. This is the primary reporting convenience of the view.
• END_DT — End date associated with the attempt record.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard Oracle EBS audit columns recording who created and last modified the row and when.

Common Use Cases and Queries

Typical usage centers on presenting a student's unit set attempt hierarchy in a human-readable, indented form. A common query filters by a specific person and course and orders by the display column:

• SELECT person_id, course_cd, unit_set_cd_display_lvl, sequence_number, end_dt FROM apps.igs_as_susa_v WHERE person_id = :person_id AND course_cd = :course_cd ORDER BY unit_set_cd_display_lvl; — produces an indented listing of attempts for reporting or a concurrent program output.
• SELECT person_id, course_cd, COUNT(*) FROM apps.igs_as_susa_v GROUP BY person_id, course_cd; — counts attempt nodes per student and course for summary reconciliation.
• A view definition or dependency report (for example through USER_DEPENDENCIES or ETRM) to confirm that IGS_AS_SU_SETATMPT is the sole underlying object before extending the view.

Because the view applies a CONNECT BY hierarchy, queries should filter on PERSON_ID and COURSE_CD wherever possible to avoid traversing unrelated hierarchies. Integration extracts that require the raw parent pointers should read IGS_AS_SU_SETATMPT directly, reserving IGS_AS_SUSA_V for presentation-oriented output.