Results for “igs_en_cpd_ext_all”

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

Overview

IGS_EN_CPD_EXT_ALL is a transactional setup table within the Oracle E-Business Suite Student System (IGS) product family. It stores enrollment eligibility setup information, defining the criteria by which a student's eligibility to enroll in a given offering is determined. In ETRM terms, the table belongs to the IGS schema, carries VALID status, and is present in both 12.1.1 and 12.2.2 releases with a documented physical schema of sixteen columns.

The record represents the configuration of an eligibility rule step: which enrollment category and enrollment method type it applies to, which communication type and enrollment step are associated with it, and which rule call and rule sequence drive the evaluation. Because the table links independent reference entities (enrollment category, enrollment method type, rule definition, and rule call), the heuristic Data Vault classification mined from its foreign key structure is link. Under that modeling suggestion, IGS_EN_CPD_EXT_ALL functions as an associative structure connecting a rule definition to the categorical and methodological dimensions of eligibility rather than as a standalone hub or a descriptive satellite.

Key Information Stored

The table's surrogate primary key is IGS_EN_CPD_EXT_ID, enforced by the IGS_EN_CPD_EXT_ALL_PK constraint and mirrored by unique index IGS_EN_CPD_EXT_ALL_U1. This identifier uniquely distinguishes each eligibility configuration row and is the value most commonly supplied when the table is referenced programmatically or through a foreign key from dependent objects.

Business-key candidacy is expressed through the composite unique index IGS_EN_CPD_EXT_ALL_U2, which spans ENROLMENT_CAT, ENR_METHOD_TYPE, ORG_ID, S_ENROLMENT_STEP_TYPE, and S_STUDENT_COMM_TYPE. This combination reflects the grain of the setup: a single eligibility definition per enrollment category, enrollment method, operating unit, enrollment step, and student communication type.

• IGS_EN_CPD_EXT_ID — surrogate primary key for each eligibility setup record.
• ORG_ID — the operating unit (business unit) that owns the setup row, enabling multi-org partitioning.
• ENROLMENT_CAT — the enrollment category the eligibility definition applies to; foreign key to IGS_EN_ENROLMENT_CAT.
• ENR_METHOD_TYPE — the enrollment method type associated with the rule; foreign key to IGS_EN_METHOD_TYPE.
• S_ENROLMENT_STEP_TYPE — the enrollment step at which eligibility is evaluated.
• S_STUDENT_COMM_TYPE — the student communication type qualifying the setup.
• STEP_ORDER_NUM — ordering sequence in which the eligibility step is processed.
• NOTIFICATION_FLAG — controls whether a notification is generated when eligibility processing occurs.
• S_RULE_CALL_CD — the rule call code invoked for this eligibility definition; foreign key to IGS_RU_CALL.
• RUL_SEQUENCE_NUMBER — the rule sequence number evaluated; foreign key to IGS_RU_RULE.
• STUD_AUDIT_LIM — audit limitation indicator for the student-facing record.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — the standard Oracle EBS audit columns recording who created and last changed each row.

Common Use Cases and Queries

The principal reporting requirement is reconstructing the eligibility configuration for an operating unit, typically to verify that enrollment categories and enrollment methods have the correct rule call and rule sequence assigned. A representative query joins the setup table to its reference dimensions:

• Eligibility setup by operating unit: select IGS_EN_CPD_EXT_ID, ENROLMENT_CAT, ENR_METHOD_TYPE, S_STUDENT_COMM_TYPE, S_RULE_CALL_CD, RUL_SEQUENCE_NUMBER from IGS_EN_CPD_EXT_ALL where ORG_ID = :org_id, ordered by STEP_ORDER_NUM.
• Rule assignment audit: join IGS_EN_CPD_EXT_ALL to IGS_RU_RULE on RUL_SEQUENCE_NUMBER and to IGS_RU_CALL on S_RULE_CALL_CD to confirm each sequence and call code is defined and active.
• Notification impact analysis: filter on NOTIFICATION_FLAG = 'Y' to enumerate configurations that generate the prerequisite-check notification.
• Duplicate-grain detection: group by ENROLMENT_CAT, ENR_METHOD_TYPE, ORG_ID, S_ENROLMENT_STEP_TYPE, and S_STUDENT_COMM_TYPE to identify rows that violate the IGS_EN_CPD_EXT_ALL_U2 business key.
• Student-communication segmentation: resolve S_STUDENT_COMM_TYPE to group eligibility setups by communication channel for enrollment reporting.

Migration and reconciliation scripts frequently resolve rows by IGS_EN_CPD_EXT_ID, since that column is the declared primary key and the probable target of dependent foreign keys.

Related Objects

IGS_EN_CPD_EXT_ALL participates in four documented foreign key relationships, each anchoring a reference dimension used during eligibility evaluation.

• IGS_EN_ENROLMENT_CAT — joined on IGS_EN_CPD_EXT_ALL.ENROLMENT_CAT; supplies valid enrollment category values.
• IGS_EN_METHOD_TYPE — joined on IGS_EN_CPD_EXT_ALL.ENR_METHOD_TYPE; supplies valid enrollment method types.
• IGS_RU_RULE — joined on IGS_EN_CPD_EXT_ALL.RUL_SEQUENCE_NUMBER; holds the rule definition executed for the setup.
• IGS_RU_CALL — joined on IGS_EN_CPD_EXT_ALL.S_RULE_CALL_CD; holds the rule call invoked by the eligibility step.
• IGS_EN_CPD_EXT_ALL_PK / _U1 / _U2 — the primary key, surrogate unique index, and composite business-key index that constrain the setup table itself.

These relationships make the table a central junction for enrollment prerequisite and eligibility processing; any object that resolves eligibility results for a student offering will typically traverse IGS_EN_CPD_EXT_ALL on the way to IGS_RU_RULE and IGS_RU_CALL.