Results for “s_control_num”

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

Overview

The IGS_DA_SETUP_V view belongs to the Oracle E-Business Suite IGS — Student System product family, which is documented as obsolete in the ETRM 12.1.1 / 12.2.2 reference set. Its purpose, as stated in the ETRM metadata, is to retrieve the Degree Audit Interface configuration. In practice, this view exposes the single setup row (or rows) held in the IGS_DA_SETUP table that controls how the institution's Degree Audit process integrates with the Oracle Student System academic structure, container display, and third-party degree audit vendors.

Because it is a view rather than a table, IGS_DA_SETUP_V is intended for read-only consumption — reporting, lookups, and integration hand-off — rather than for direct DML. The user search term wif_minor_unit_set_cat corresponds directly to one of its columns, WIF_MINOR_UNIT_SET_CAT, indicating the searcher is investigating how minor unit-set categories are mapped for the Weakly-Integrated Format (WIF) degree audit interface.

Underlying Base Objects

Per the ETRM documentation, no referenced base objects are separately recorded for this view and the owner is not listed, though the view SQL clearly selects from a single base table:

• IGS_DA_SETUP — the Degree Audit setup table, aliased as DS in the view definition.

The view is a straight projection: it selects DS.ROWID AS ROW_ID plus every configured column from IGS_DA_SETUP, with no joins, unions, or aggregation. This means the row cardinality of the view matches the underlying table exactly. The ETRM record also notes "Not implemented in this database," which indicates the object exists in the ETRM documentation set for 12.2.2 but was not deployed in the reference environment where the metadata was captured — a common situation for obsolete Student System objects.

Key Columns

• ROW_ID — the base table's ROWID, exposed for reference but not a stable identifier across reorgs.
• S_CONTROL_NUM — the setup control number, effectively the primary configuration key.
• PROGRAM_DEFINITION_IND — flag controlling whether the program definition drives the audit.
• DEFAULT_STUDENT_ID_TYPE / DEFAULT_INST_ID_TYPE / DEFAULT_ADDRESS_TYPE — default identifier and address type codes used when the interface resolves student, institution, or address context.
• WIF_MAJOR_UNIT_SET_CAT, WIF_MINOR_UNIT_SET_CAT, WIF_TRACK_UNIT_SET_CAT — the unit-set categories mapped for the major, minor, and track dimensions of the WIF interface. The WIF_MINOR_UNIT_SET_CAT column is the specific value the user searched for.
• WIF_UNIT_SET_TITLE — the display title applied to the unit-set grouping in the WIF output.
• THIRD_PARTY_OPTIONS — configuration payload for external degree audit vendors.
• DISPLAY_CONTAINER_IND, CONTAINER_TITLE, LINK_TEXT, LINK_URL — controls for rendering the degree audit container and its hyperlink in the self-service page.
• Audit columns — CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN.

Common Use Cases and Queries

The primary use case is validating or extracting the Degree Audit interface configuration, particularly the WIF category mappings. A typical query to locate the minor unit-set category is:

• SELECT s_control_num, wif_major_unit_set_cat, wif_minor_unit_set_cat, wif_track_unit_set_cat, wif_unit_set_title FROM igs_da_setup_v WHERE wif_minor_unit_set_cat IS NOT NULL;
• Reviewing container display settings: SELECT s_control_num, display_container_ind, container_title, link_text, link_url FROM igs_da_setup_v;
• Auditing third-party integration: SELECT s_control_num, third_party_options, default_student_id_type, default_inst_id_type FROM igs_da_setup_v;
• Change tracking: SELECT s_control_num, last_updated_by, last_update_date FROM igs_da_setup_v ORDER BY last_update_date DESC;

Because the view is not implemented in the documented database and belongs to an obsolete product, any query should first confirm the object exists in the target instance (for example, via ALL_VIEWS or USER_VIEWS). Where the student system has been replaced or de-supported, equivalent configuration is typically maintained in the successor Student Information System.