Results for “decision_code”

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

Overview

IGS_UC_SYS_DECISION is a seeded reference table within the Oracle E-Business Suite Student System (IGS) product family, specifically belonging to the UC (Universities and Colleges Admissions Service, or UCAS) integration component. It stores the system decision codes used to represent admissions decisions exchanged between the institution and the external admissions service. As a seeded table, its contents are delivered by Oracle and are not intended for routine end-user maintenance; changes are typically applied through patches or controlled setup activities. The table resides in the IGS schema and is marked VALID in the ETRM 12.1.1 and 12.2.2 documentation sets.

Under a heuristic Data Vault classification mined from the foreign key structure, this object is hub-leaning. In Data Vault terms, a hub captures a distinct business key and its descriptive context. Here the composite business key is formed by SYSTEM_CODE and DECISION_CODE, which together provide the durable identity of each decision record. Modeling this table as a hub is therefore a reasonable suggestion, with dependent attributes such as outcome status, closure indicator, and decision type treated as satellite-style descriptive payload.

Key Information Stored

The documented physical schema contains five columns. The business identity of each row is defined by the combination of SYSTEM_CODE and DECISION_CODE, which together form the primary key IGS_UC_SYS_DECISION_PK and are also captured in the unique index IGS_UC_SYS_DECISION_U1. This pairing constitutes the business-key candidate rather than a single surrogate identifier.

• SYSTEM_CODE — Identifies the source system or processing context to which the decision code belongs. This column participates in the primary key and carries a foreign key to IGS_UC_DEFAULTS.
• DECISION_CODE — The seeded code representing a specific system decision. It completes the composite primary key and is referenced by dependent mapping tables.
• S_ADM_OUTCOME_STATUS — Holds the admissions outcome status associated with the decision code, supporting downstream status derivation and reporting.
• CLOSED_IND — A flag indicating whether the decision represents a closed or terminal state within the admissions decision lifecycle.
• DECISION_TYPE — Classifies the decision into a categorical type, enabling grouping and filtering of decision codes across reports.

Common Use Cases and Queries

This table is most often used as a lookup source when interpreting admissions decision data, resolving seeded codes into meaningful outcome statuses, and driving mapping logic for external responses and output statuses. A typical reporting query joins the decision table to dependent mapping tables to translate codes into descriptive values.

• Validating that an inbound or outbound decision code exists in the seeded reference set before processing.
• Reporting on decisions grouped by DECISION_TYPE, with counts filtered by CLOSED_IND to distinguish open from closed cases.
• Building mapping extracts that link SYSTEM_CODE and DECISION_CODE to officer-responsibility and output-status mappings.
• Reconciliation queries that expose decision codes present in transaction tables but absent from the seeded reference table.

A representative join pattern selects the decision code alongside its outcome status and type, joining on SYSTEM_CODE and DECISION_CODE to the relevant mapping table. Because the table is seeded and relatively small, it is usually accessed as a driving lookup rather than a large fact source.

Related Objects

The foreign key relationships documented in the ETRM metadata identify the principal dependent and referenced objects. These joins should be constructed on the composite key where indicated.

• IGS_UC_DEFAULTS — Referenced by IGS_UC_SYS_DECISION.SYSTEM_CODE; supplies default system-level configuration.
• IGS_UC_MAP_OFF_RESP — References this table via SYSTEM_CODE and DECISION_CODE, mapping decisions to officer responsibilities.
• IGS_UC_MAP_OUT_STAT — References this table via SYSTEM_CODE and DECISION_CODE, mapping decisions to output statuses.
• IGS_UC_SYS_DECISION_PK — Primary key constraint enforcing uniqueness of SYSTEM_CODE and DECISION_CODE.
• IGS_UC_SYS_DECISION_U1 — Unique index supporting the same business-key combination.

Together these objects form the reference and mapping layer that underpins UC admissions decision processing, with IGS_UC_SYS_DECISION acting as the authoritative seeded source for system decision codes.