Results for “unit_set_reduc_cd”

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

Overview

IGS_AD_I_ENTRY_STATS is a table in the IGS (Student System) product schema of Oracle E-Business Suite, owner IGS, documented as VALID in the ETRM metadata for releases 12.1.1 and 12.2.2. Its stated purpose is to store inquiry entry statuses; the ETRM description explicitly annotates the object as "Obsolete," which indicates that it is retained for backward compatibility and referential integrity rather than as an active participant in current functional flows.

The table functions as a configuration/reference entity within the admissions inquiry area of the Student System. Its primary key, IGS_AD_I_ENTRY_STATS_PK, is defined on the surrogate column INQ_ENTRY_STAT_ID, while the unique index IGS_AD_I_ENTRY_STATS_U1 on INQ_ENTRY_STAT identifies the business key. From a Data Vault modeling perspective (heuristic classification mined from the foreign-key structure), this object is best treated as a hub: it holds a stable, uniquely identified business concept around which dependent entities cluster. The documented physical schema for 12.1.1 lists 20 columns, and the table serves as the parent of several detail tables that carry the INQ_ENTRY_STAT_ID foreign key.

Key Information Stored

The most significant column is INQ_ENTRY_STAT_ID, the surrogate primary key that uniquely identifies each inquiry entry status record and is propagated to all dependent child tables. INQ_ENTRY_STAT is the business-key candidate, enforced by the unique index IGS_AD_I_ENTRY_STATS_U1, and carries the user-facing status value or code. DESCRIPTION provides the descriptive text associated with that status.

Classification and routing attributes include HIERARCHY_CD, which positions the status within a hierarchy; ENQUIRY_SOURCE_TYPE and ACTIVITY_SOURCE_CD, which categorize the origin of the enquiry and its associated activity; and INSTITUTION_TYPE, which scopes the status to an institution type. The columns TEST_SOURCE_ID and IMP_SOURCE_TYPE_ID act as reference/foreign-key pointers into code and source-type definitions. Reduction control columns — PROG_CODE_REDUC_CD, UNIT_SET_REDUC_CD, and PKG_ITEM_REDUC_CD — govern the reduction behavior applied to programs, unit sets, and package items respectively, while EMAIL_LINK and CONFIGURABILITY_FUNC_NAME support notification and configurability behavior. CLOSED_IND marks whether the status represents a closed state. Standard audit columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN) complete the record.

Common Use Cases and Queries

Because the object is marked obsolete, most reporting against it is retrospective — validating historical inquiry data, auditing configuration carried forward from earlier releases, or reconciling migrated records. A typical lookup retrieves a status by its business key:

• SELECT INQ_ENTRY_STAT_ID, INQ_ENTRY_STAT, DESCRIPTION, CLOSED_IND FROM IGS.IGS_AD_I_ENTRY_STATS WHERE INQ_ENTRY_STAT = :status;
• Enumerating all statuses with their hierarchy and institution scoping: SELECT * FROM IGS.IGS_AD_I_ENTRY_STATS WHERE INSTITUTION_TYPE = :inst AND HIERARCHY_CD = :hier;
• Join-based counts of dependents, e.g. SELECT s.INQ_ENTRY_STAT, COUNT(e.INQ_ENTRY_STAT_ID) FROM IGS.IGS_AD_I_ENTRY_STATS s, IGS.IGS_IN_ENQUIRY_APPL_ALL e WHERE s.INQ_ENTRY_STAT_ID = e.INQ_ENTRY_STAT_ID GROUP BY s.INQ_ENTRY_STAT;

Such queries are most often used for data-cleansing audits before decommissioning or for reconstructing historical inquiry statuses during migration to current structures.

Related Objects

The table sits at the centre of a well-defined referential cluster. It references IGS_AD_CODE_CLASSES via TEST_SOURCE_ID, IGS_IN_ENQ_SRC_TYPE via ENQUIRY_SOURCE_TYPE, IGS_OR_ORG_INST_TYPE_ALL via INSTITUTION_TYPE, and IGS_PE_SRC_TYPES_ALL via IMP_SOURCE_TYPE_ID. In the reverse direction, seven documented child tables carry INQ_ENTRY_STAT_ID back to this hub: IGS_AD_ENT_ORG_UNITS, IGS_AD_ENT_PKG_ITEMS, IGS_AD_ENT_INQ_PROGS, IGS_AD_ENT_TEST_TYPS, IGS_AD_ENT_INQ_USET, IGS_AD_SS_REGIONS, and IGS_IN_ENQUIRY_APPL_ALL. Collectively these define how entry statuses drive organisational units, package items, inquiry programs, test types, inquiry user settings, self-service regions, and enquiry applications. Analysts should treat IGS_IN_ENQUIRY_APPL_ALL as the primary transactional satellite for reporting and the remaining IGS_AD_ENT_* tables as configuration satellites.