Results for “igs_en_cpd_ext”

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

Overview

IGS_EN_CPD_EXT is an Oracle E-Business Suite view owned by the APPS schema and classified under the IGS – Student System product family. It describes Enrollment Category Procedure Details, exposing the configuration rules that govern how enrollment categories, enrollment methods, and enrollment steps are processed within the student system. In EBS 12.1.1 and 12.2.2, the view serves as the operational interface through which enrollment procedure logic is queried by forms, concurrent programs, and reporting layers. Because it is a view rather than a base table, it provides a filtered, security-aware projection of the underlying _ALL table, which is the physical repository for the same enrollment category procedure data. The view is documented as VALID in the ETRM metadata, confirming that it compiles successfully and its dependencies are intact in the reference environment.

Underlying Base Objects

The view text identifies a single referenced base object: IGS_EN_CPD_EXT_ALL, aliased as ECE. The view is defined as a SELECT over this table, projecting all principal attribute columns along with the ROWID pseudo-column, which is exposed as ROW_ID. Critically, the definition includes a Multi-Org filter built on USERENV('CLIENT_INFO') and the ORG_ID column. This predicate compares the operating unit stored in the client information session context against the ORG_ID value on each row, using NVL and DECODE logic that returns -99 when no valid organization context is present. As a result, IGS_EN_CPD_EXT behaves as an operating-unit-secured view: rows are returned only for the organization currently set in the user's session. The ETRM metadata for 12.2.2 lists no additional documented base objects, and the view text confirms that IGS_EN_CPD_EXT_ALL is the sole table consumed.

Key Columns

• ROW_ID — the ROWID of the underlying IGS_EN_CPD_EXT_ALL row, useful for row-level addressing.
• IGS_EN_CPD_EXT_ID — the primary identifier for an enrollment category procedure detail record.
• ENROLMENT_CAT — the enrollment category to which the procedure detail applies.
• ENR_METHOD_TYPE — the enrollment method type associated with the procedure.
• S_STUDENT_COMM_TYPE — the student communication type used for notifications.
• STEP_ORDER_NUM — the sequence in which the enrollment step is executed.
• S_ENROLMENT_STEP_TYPE — the enrollment step type, defining the nature of the step.
• NOTIFICATION_FLAG — indicates whether a notification is generated for the step.
• S_RULE_CALL_CD — the rule call code that determines which validation or business rule is invoked.
• RUL_SEQUENCE_NUMBER — the sequence number controlling rule execution order.
• STUD_AUDIT_LIM — the student audit limit, the column most directly associated with the search term "stud_audit_lim". It constrains or records the audit threshold applicable to the enrollment procedure.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard EBS audit columns tracking record provenance.

Common Use Cases and Queries

Typical use cases include retrieving enrollment procedure configuration for a given category, reviewing step ordering and rule sequencing, and extracting student audit limits for enrollment auditing and compliance reporting.

• List procedure details for an enrollment category: SELECT enrolment_cat, enr_method_type, step_order_num, s_enrolment_step_type, stud_audit_lim FROM igs_en_cpd_ext WHERE enrolment_cat = :category ORDER BY step_order_num;
• Identify steps requiring notification: SELECT igs_en_cpd_ext_id, step_order_num, notification_flag FROM igs_en_cpd_ext WHERE notification_flag = 'Y';
• Audit-limit focused extraction matching the user search: SELECT enrolment_cat, enr_method_type, stud_audit_lim FROM igs_en_cpd_ext;

Because the view enforces operating unit security, queries return only rows for the organization in the current session context; cross-organization reporting should target IGS_EN_CPD_EXT_ALL directly, subject to appropriate access controls.