Results for “igs_en_cpd_ext_all_u2”

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

Overview

IGS.IGS_EN_CPD_EXT_ALL is a transactional setup table in the Oracle E-Business Suite Student System (IGS) schema. It stores the enrollment eligibility setup information — the rule-driven configuration that governs whether a learner may proceed through a given enrollment or registration step. In the context of Oracle EBS 12.1.1 and 12.2.2, the table acts as the extension of the core enrollment eligibility definition, binding an enrollment category, an enrollment method type, and a student commencement type to the eligibility step that must be evaluated, its validation order, and the notification or denial behavior applied when the validation fails.

Because the table's primary key is a system-generated surrogate (IGS_EN_CPD_EXT_ID) and its payload consists of descriptive attributes attached to that identifier, the heuristic Data Vault classification mined from the foreign-key structure suggests a satellite-like role, with the referenced IGS_EN_ENROLMENT_CAT, IGS_EN_METHOD_TYPE, IGS_RU_RULE, and IGS_RU_CALL objects supplying the surrounding hub and link semantics. The table is owned by IGS, marked VALID, and is held in the APPS_TS_TX_DATA tablespace with a PCT FREE of 10, consistent with a low-volatility configuration table that is read frequently during registration processing.

Key Information Stored

The table documents sixteen columns. The surrogate primary key is IGS_EN_CPD_EXT_ID, a NUMBER(15) that uniquely identifies each eligibility setup row and is enforced by the primary key IGS_EN_CPD_EXT_ALL_PK. The business-key candidate is defined by the unique index IGS_EN_CPD_EXT_ALL_U2, which enforces uniqueness across the combination of ENROLMENT_CAT, ENR_METHOD_TYPE, ORG_ID, S_ENROLMENT_STEP_TYPE, and S_STUDENT_COMM_TYPE. This composite constraint is the functional heart of the table: it guarantees that only one eligibility configuration exists for a given category, method, operating unit, step, and commencement type.

The most significant columns are:

• ENROLMENT_CAT — the enrollment category against which eligibility is configured; foreign key to IGS_EN_ENROLMENT_CAT.
• ENR_METHOD_TYPE — the enrollment method type; foreign key to IGS_EN_METHOD_TYPE.
• S_STUDENT_COMM_TYPE — the student commencement type qualifying the setup.
• S_ENROLMENT_STEP_TYPE — the eligibility step type validated for the combination above.
• STEP_ORDER_NUM — the sequence in which eligibility steps are validated.
• NOTIFICATION_FLAG — controls whether a failed validation issues a WARN or DENY response.
• S_RULE_CALL_CD and RUL_SEQUENCE_NUMBER — the rule hook and sequence used by the rules engine, referencing IGS_RU_CALL and IGS_RU_RULE respectively.
• STUD_AUDIT_LIM — the maximum number of audit units a student may enroll into.
• ORG_ID — the organization identifier, enabling multi-org partitioning of the setup.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — the standard WHO audit columns.

Common Use Cases and Queries

The principal operational use is validation during registration: before a student is permitted to enroll, the registration engine reads the eligibility configuration for the applicable category, method, commencement type, and step, then invokes the referenced rule to decide whether to warn or deny. Reporting use cases include auditing which steps are configured for a category and identifying categories with missing or permissive notification settings.

A typical lookup pattern resolves the ordered steps for a given configuration:

• SELECT step_order_num, s_enrolment_step_type, notification_flag, stud_audit_lim FROM igs.igs_en_cpd_ext_all WHERE enrolment_cat = :p_cat AND enr_method_type = :p_method AND s_student_comm_type = :p_comm AND org_id = :p_org ORDER BY step_order_num;
• SELECT c.igs_en_cpd_ext_id, c.s_rule_call_cd, r.rul_sequence_number FROM igs.igs_en_cpd_ext_all c, igs.igs_ru_rule r WHERE c.rul_sequence_number = r.rul_sequence_number;
• A diagnostic query joining to IGS_EN_ENROLMENT_CAT to list all categories lacking an eligibility row, which exposes configuration gaps.

Related Objects

The most significant related objects are defined by the documented foreign-key relationships:

• IGS.IGS_EN_ENROLMENT_CAT — joined on ENROLMENT_CAT; the enrollment category master.
• IGS.IGS_EN_METHOD_TYPE — joined on ENR_METHOD_TYPE; the enrollment method type master.
• IGS.IGS_RU_RULE — joined on RUL_SEQUENCE_NUMBER; holds the rule definition evaluated at runtime.
• IGS.IGS_RU_CALL — joined on S_RULE_CALL_CD; the rule call code invoked by the rules engine.
• IGS_EN_CPD_EXT_ALL_PK / IGS_EN_CPD_EXT_ALL_U1 and IGS_EN_CPD_EXT_ALL_U2 — the primary and unique indexes that enforce identity and the composite business key.

Collections in the enrollment and registration flows that consume eligibility setup information depend on these relationships when resolving configured steps for a learner.