Search Results igs_da_setup_pk

Overview

IGS_DA_SETUP is a configuration table belonging to the IGS (Student System) product family in Oracle E-Business Suite. Its documented purpose is to store the configuration information required to execute degree audit processing. As a single-record control table, it holds a unique row that governs how the degree audit engine interprets academic structure, resolves identifier types, and presents results to end users. In Oracle EBS 12.1.1 the table is owned by the IGS schema and contains 20 documented columns; it retains the same identity and structure across 12.2.2, remaining a VALID object within the Student System data model.

From a modeling perspective, the metadata classifies this object heuristically as a link. This is consistent with its declaration of five foreign keys, each of which references a separate reference or setup table, thereby binding configuration values to organizational identifier types, person identifier types, and unit set categories. Practically, however, the table also exhibits satellite-like characteristics, since it carries descriptive policy attributes (such as indicator flags and display text) alongside the foreign key references. The single-record constraint is enforced through the primary key defined on S_CONTROL_NUM.

Key Information Stored

The surrogate primary key is S_CONTROL_NUM, supported by the unique index IGS_DA_SETUP_PK. Because this is a single-record table, S_CONTROL_NUM functions as the control-row identifier rather than a meaningful business key; no distinct business-key candidate is documented beyond this unique index. The most significant columns fall into three groups:

• Identifier defaults: DEFAULT_STUDENT_ID_TYPE references IGS_PE_PERSON_ID_TYP, and DEFAULT_INST_ID_TYPE references IGS_OR_ORG_ALT_IDTYP. DEFAULT_ADDRESS_TYPE selects the default address type used for degree audit output.
• Academic structure mapping: WIF_MAJOR_UNIT_SET_CAT, WIF_MINOR_UNIT_SET_CAT, and WIF_TRACK_UNIT_SET_CAT each reference IGS_EN_UNIT_SET_CAT, mapping major, minor, and track concepts to unit set categories. WIF_UNIT_SET_TITLE holds the descriptive title applied to those unit sets.
• Behavior and presentation controls: PROGRAM_DEFINITION_IND, ADVISOR_RELATIONSHIP_IND, and DISPLAY_CONTAINER_IND are decision flags; THIRD_PARTY_OPTIONS governs external exchange behavior; CONTAINER_TITLE, LINK_TEXT, and LINK_URL drive the displayed container and hyperlink elements.

Standard audit columns include CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, and LAST_UPDATE_LOGIN.

Common Use Cases and Queries

The most frequent access pattern is retrieving the single control row to inspect configuration before or after releasing degree audit results. A typical query joins the foreign key targets to resolve descriptive names:

• SELECT s.S_CONTROL_NUM, s.PROGRAM_DEFINITION_IND, s.WIF_MAJOR_UNIT_SET_CAT, s.CONTAINER_TITLE, p.PERSON_ID_TYPE FROM IGS.IGS_DA_SETUP s, IGS.IGS_PE_PERSON_ID_TYP p WHERE s.DEFAULT_STUDENT_ID_TYPE = p.PERSON_ID_TYPE;
• Reporting on audit configuration lineage, using LAST_UPDATED_BY and LAST_UPDATE_DATE to determine when defaults were last changed.
• Validating that major, minor, and track unit set categories are populated with active entries in IGS_EN_UNIT_SET_CAT prior to term rollover.
• Confirming identifier type defaults against IGS_OR_ORG_ALT_IDTYP to ensure institution identifiers resolve correctly during degree audit generation.
• Auditing display settings (DISPLAY_CONTAINER_IND, LINK_TEXT, LINK_URL) when embedded audit links fail to render.

Related Objects

The following objects participate directly in the documented foreign key relationships or represent the principal consumers of this configuration:

• IGS_PE_PERSON_ID_TYP — referenced through DEFAULT_STUDENT_ID_TYPE.
• IGS_OR_ORG_ALT_IDTYP — referenced through DEFAULT_INST_ID_TYPE.
• IGS_EN_UNIT_SET_CAT — referenced three times, through WIF_MAJOR_UNIT_SET_CAT, WIF_MINOR_UNIT_SET_CAT, and WIF_TRACK_UNIT_SET_CAT.
• IGS_DA_SETUP_PK — the unique index enforcing the single control record on S_CONTROL_NUM.
• The IGS degree audit processing components, which read this row to determine unit set mapping and presentation behavior.