Search Results unit_set_code_id

Overview

IGS.IGS_AD_INQ_PRUNT_INT is an Oracle E-Business Suite interface table in the IGS (Student Systems / Higher Education) schema. It holds admission inquiry combined program and unit set information interface records — that is, staging rows that associate an admission inquiry program with one or more unit sets (academic subject groupings such as English, History, or Biology) and a preference ranking for each. The table functions as the inbound staging area for data that is validated and then migrated into the base admission inquiry program preference tables by an admissions concurrent program.

The table resides in the APPS_TS_INTERFACE tablespace with PCTFREE 10 and is registered under FND Design Data as IGS.IGS_AD_INQ_PRUNT_INT. Following the heuristic Data Vault classification mined from the foreign key structure, this object is best modeled as a link — it resolves the many-to-many association between an inquiry program and a unit set. It is not a hub (it carries no independently surviving business key) and not a pure satellite, since it holds its own unique identifier and preference attribute.

Key Information Stored

Every row is uniquely identified by INTERFACE_INQ_PRGUNT_ID, a NUMBER(15) surrogate key populated on insert. A unique index, IGS_AD_INQ_PRUNT_INT_U1, is defined on this column, which is also the primary key (IGS_AD_INQ_PRUNT_INT_PK). The remaining columns of interest include:

• INTERFACE_INQ_PRG_ID — foreign key to IGS_AD_INQ_PRG_INT; identifies the parent inquiry program interface row.
• UNIT_SET_CODE_ID — the inquired unit set code, for example English, History, or Biology.
• UNIT_SET_PREFERENCE — the ordinal preference (1, 2, 3) the applicant assigned to the unit set.
• DUP_INQ_PRG_PREF_USET_ID — duplicate inquiry program preference unit set identifier, used for de-duplication logic.
• STATUS — processing state: 1 = Completed, 2 = Pending, 3 = Error, 4 = Warning.
• MATCH_IND — match indicator for validated rows.
• ERROR_CODE — VARCHAR2(30) populated when validation fails.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard WHO audit columns.
• REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE — concurrent program context columns identifying the job that processed the row.

Common Use Cases and Queries

The principal scenario is pre-import validation: reviewing rows in STATUS 2 (Pending) before the import concurrent program runs, and remediating rows in STATUS 3 (Error) or 4 (Warning). Typical queries filter by unit set or error state.

• Error triage: SELECT INTERFACE_INQ_PRGUNT_ID, INTERFACE_INQ_PRG_ID, UNIT_SET_CODE_ID, ERROR_CODE FROM IGS_AD_INQ_PRUNT_INT WHERE STATUS = 3;
• Preference ordering for a program: join to IGS_AD_INQ_PRG_INT on INTERFACE_INQ_PRG_ID and sort by UNIT_SET_PREFERENCE.
• Volume reporting: GROUP BY UNIT_SET_CODE_ID to assess demand per subject.
• Concurrent program audit: filter by REQUEST_ID to trace a specific import run.

Related Objects

• IGS.IGS_AD_INQ_PRG_INT — the parent inquiry program interface table; joined via INTERFACE_INQ_PRG_ID (the documented foreign key).
• IGS.IGS_AD_INQ_PRUNT — the base (non-interface) table populated after successful validation and import.
• IGS_AD_INQ_PRG_INT-related base inquiry program tables holding the final program preference records.
• IGS.IGS_AD_INQ_PRUNT_INT_U1 / _PK — the unique index and primary key constraints enforcing row identity.
• Admissions import concurrent programs that read STATUS, MATCH_IND, and ERROR_CODE and write the WHO/concurrent columns.