Search Results advisor_relationship_ind

Overview

IGS.IGS_DA_SETUP is a configuration table within the Oracle E-Business Suite (EBS) Student Systems / Oracle Student System (IGS) schema, used to control how the institution integrates with third-party academic advising or degree-audit software. Rather than storing transactional student records, the table holds a single, institution-level row of setup parameters that govern what identifiers, program information, address data, and self-service content are transmitted to or displayed alongside external software. Because it is a reference table with a single control number, it functions as a high-level control point for the Data at Setup (DA) feature set.

Its heuristic Data Vault classification is that of a link table. This reflects the fact that several of its columns act as foreign-key references to other IGS master tables — for example, DEFAULT_INST_ID_TYPE, DEFAULT_STUDENT_ID_TYPE, and the three WIF unit-set category columns — establishing associations between the DA setup record and the identifier-type and unit-set definitions that they depend upon.

Key Information Stored

The physical schema documents twenty columns. The most operationally significant include:

• S_CONTROL_NUM — the surrogate primary key (NUMBER, defaults to 1). This is the only documented unique index (IGS_DA_SETUP_PK) and therefore the sole business-key candidate; the table is effectively a singleton configuration row.
• PROGRAM_DEFINITION_IND, DEFAULT_STUDENT_ID_TYPE, DEFAULT_INST_ID_TYPE, DEFAULT_ADDRESS_TYPE — flags and type codes determining what program, student identifier, institution identifier, and address information is sent to third-party software.
• WIF_MAJOR_UNIT_SET_CAT, WIF_MINOR_UNIT_SET_CAT, WIF_TRACK_UNIT_SET_CAT, WIF_UNIT_SET_TITLE — govern which unit-set categories and titles are displayed for WIF majors, minors, tracks, and unit sets in self-service.
• THIRD_PARTY_OPTIONS — controls which request features appear in request template configuration.
• DISPLAY_CONTAINER_IND, CONTAINER_TITLE — determine whether a content container linking to the third-party software is displayed, and its title.
• LINK_TEXT and LINK_URL — provide the display label and destination URL for the external container link.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard EBS audit columns.

The ADVISOR_RELATIONSHIP_IND column is documented as obsolete and is not central to current configuration.

Common Use Cases and Queries

Administrators and technical consultants query this table to verify integration behavior, to confirm the correct identifier and address types are being passed to external advising systems, and to validate self-service display settings. A typical retrieval of the singleton configuration row uses the primary key:

• SELECT * FROM igs.igs_da_setup WHERE s_control_num = 1;
• Verifying the identifier and address types: SELECT default_student_id_type, default_inst_id_type, default_address_type FROM igs.igs_da_setup;
• Checking the third-party link presentation: SELECT display_container_ind, container_title, link_text, link_url FROM igs.igs_da_setup;

Reporting use cases include auditing whether the WIF unit-set categories are populated correctly before publishing self-service pages, and tracing the link URL configured for the external content container.

Related Objects

Several reference tables are joined to this setup record via the foreign-key columns, allowing display of descriptive values for the coded configuration:

• IGS_PE_PERSON_ID_TYP — referenced by DEFAULT_STUDENT_ID_TYPE.
• IGS_OR_ORG_ALT_IDTYP — referenced by DEFAULT_INST_ID_TYPE.
• IGS_EN_UNIT_SET_CAT — referenced three times, by WIF_MAJOR_UNIT_SET_CAT, WIF_MINOR_UNIT_SET_CAT, and WIF_TRACK_UNIT_SET_CAT.
• IGS_DA_SETUP_PK defines the unique key, so primary-key lookups resolve directly to the correct configuration row.

These joins make it possible to resolve category and identifier-type codes into meaningful descriptions for administrative review and reporting.