Search Results igs_en_cat_prc_dtl




Overview
Explore in AI Chat

Overview

The IGS_EN_CAT_PRC_DTL table is a core data object within the Oracle E-Business Suite Student System (IGS). It functions as a configuration and control table that defines the detailed procedures associated with different student enrollment categories. Specifically, it describes the detail of an enrollment procedure type, linking an enrollment category with specific communication types and enrollment methods. This table is essential for enforcing business rules and workflows during the student enrollment process, ensuring that the correct procedures are followed based on a student's classification and the method by which they are enrolling.

Key Information Stored

The table's structure centers on defining procedural rules for enrollment. Its primary key, which uniquely identifies each rule, is a composite of three columns: ENROLMENT_CAT, S_STUDENT_COMM_TYPE, and ENR_METHOD_TYPE. This combination dictates that for a given enrollment category, specific procedures are detailed per communication type and enrollment method. A critical column is ENFORCE_DATE_ALIAS, which references a date alias from the IGS_CA_DA table. This link allows the system to calculate and enforce critical dates within the enrollment procedure, such as deadlines for application steps or fee payments, based on configurable academic calendars.

Common Use Cases and Queries

This table is primarily accessed for configuring enrollment workflows and validating student enrollment transactions. A common operational use case is to determine the valid enrollment methods and associated procedural dates for a student based on their assigned enrollment category. For reporting and troubleshooting, administrators may query this table to audit the defined enrollment procedures. A typical query would join to its parent tables to retrieve descriptive information:

  • Identifying all procedural details for a specific enrollment category: SELECT * FROM igs.igs_en_cat_prc_dtl WHERE enrolment_cat = '<CATEGORY_CODE>';
  • Retrieving a full description of active rules by joining to reference tables: SELECT d.*, c.enrolment_cat_desc, m.enr_method_type_desc FROM igs.igs_en_cat_prc_dtl d, igs.igs_en_enrolment_cat c, igs.igs_en_method_type m WHERE d.enrolment_cat = c.enrolment_cat AND d.enr_method_type = m.enr_method_type;

Related Objects

The IGS_EN_CAT_PRC_DTL table maintains defined foreign key relationships with several key reference tables in the Student System, ensuring data integrity and enabling joins for descriptive reporting.

  • IGS_EN_ENROLMENT_CAT: Joined via the ENROLMENT_CAT column. This is the master table for enrollment categories.
  • IGS_EN_METHOD_TYPE: Joined via the ENR_METHOD_TYPE column. This table defines the types of enrollment methods available (e.g., online, paper-based).
  • IGS_CA_DA: Joined via the ENFORCE_DATE_ALIAS column. This table stores date aliases used for calculating schedule-based dates within academic calendars.

As the owner of the primary key IGS_EN_CAT_PRC_DTL_PK, this table may also be referenced as a parent in foreign key constraints within other transactional or configuration tables in the IGS schema.

  • Table: IGS_EN_CAT_PRC_DTL 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_EN_CAT_PRC_DTL,  object_name:IGS_EN_CAT_PRC_DTL,  status:VALID,  product: IGS - Student System ,  description: Describes the detail of enrollment procedure type ,  implementation_dba_data: IGS.IGS_EN_CAT_PRC_DTL , 

  • Table: IGS_EN_ENROLMENT_CAT 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_EN_ENROLMENT_CAT,  object_name:IGS_EN_ENROLMENT_CAT,  status:VALID,  product: IGS - Student System ,  description: This entity describes an enrolment category. This will define the processes which will be performed during enrolling of students controlled by this type. ,  implementation_dba_data: IGS.IGS_EN_ENROLMENT_CAT , 

  • View: IGS_EN_CAT_PRC_DTL_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:IGS.IGS_EN_CAT_PRC_DTL_V,  object_name:IGS_EN_CAT_PRC_DTL_V,  status:VALID,  product: IGS - Student System ,  description: Describes the Enrollment Category Eligibility Validation Details ,  implementation_dba_data: APPS.IGS_EN_CAT_PRC_DTL_V , 

  • Table: IGS_EN_METHOD_TYPE 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_EN_METHOD_TYPE,  object_name:IGS_EN_METHOD_TYPE,  status:VALID,  product: IGS - Student System ,  description: Describes the available method types that students can be enrolled to. For example, online, ivrs, batch key. This table is modified to capture the enrollment method type related to self service. ,  implementation_dba_data: IGS.IGS_EN_METHOD_TYPE , 

  • Table: IGS_CA_DA 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_CA_DA,  object_name:IGS_CA_DA,  status:VALID,  product: IGS - Student System ,  description: Describes available date alias types ,  implementation_dba_data: IGS.IGS_CA_DA ,