Results for “enr_method_type”

50+ results




Overview
Explore in AI Chat

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

Overview

The IGS_EN_CAT_PRC_DTL table is a foundational configuration object within the IGS (Student System) product family of Oracle E-Business Suite. It describes the detail of an enrollment procedure type, capturing the business rules that govern how a specific enrollment category interacts with a student communication type and an enrollment method. In practical terms, the table stores the parameter-level settings that determine whether a given enrollment path permits package production, person additions, or course additions, and which date alias controls enforcement of the configured validation.

The table resides in the IGS schema and is marked VALID in ETRM for both 12.1.1 and 12.2.2. Heuristically, the mined foreign-key structure classifies this object as a link table in a Data Vault model. This is a modeling suggestion rather than a normative declaration: the table sits at the intersection of three independent business entities — enrollment category, student communication type, and enrollment method type — and records their combined configuration rather than describing any one of them in isolation. Its 13 documented columns are a mix of the composite business key, boolean-style indicator flags, validation thresholds, and standard EBS audit columns.

Key Information Stored

The primary key is IGS_EN_CAT_PRC_DTL_PK, defined over the composite of ENROLMENT_CAT, S_STUDENT_COMM_TYPE, and ENR_METHOD_TYPE. A documented unique index, IGS_EN_CAT_PRC_DTL_U1, covers exactly the same three columns. This correspondence is significant: the primary key is therefore a natural composite business key rather than a meaningless surrogate, and the unique index confirms that a single enrollment category can pair with a given communication type and enrollment method only once.

The three key columns carry the core meaning of each row. ENROLMENT_CAT identifies the enrollment category, S_STUDENT_COMM_TYPE identifies the student communication type a student is working under, and ENR_METHOD_TYPE identifies the enrollment method being applied. Together they define the scope of the configuration.

The behavioral columns determine what the configuration actually permits or requires. PRODUCE_PACKAGE_IND controls whether an enrollment package is produced for the combination. PERSON_ADD_ALLOW_IND and COURSE_ADD_ALLOW_IND govern whether persons and courses respectively may be added. CONFIG_MIN_CP_VALDN stores a minimum credit-point validation threshold used when validating the configuration. ENFORCE_DATE_ALIAS references a date alias that governs when the associated validation or rule is enforced. The remaining standard audit columns — CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, and LAST_UPDATE_LOGIN — record row provenance and are typical for EBS transactional and setup tables.

Common Use Cases and Queries

The most frequent use of this table is diagnostic: when enrollment behaves unexpectedly, administrators query the configuration to see which indicator flags apply to a specific category, communication type, and method. A typical pattern resolves all rules for a given enrollment category:

  • SELECT ENROLMENT_CAT, S_STUDENT_COMM_TYPE, ENR_METHOD_TYPE, PRODUCE_PACKAGE_IND, PERSON_ADD_ALLOW_IND, COURSE_ADD_ALLOW_IND, CONFIG_MIN_CP_VALDN, ENFORCE_DATE_ALIAS FROM IGS_EN_CAT_PRC_DTL WHERE ENROLMENT_CAT = :p_cat;
  • Joining to IGS_EN_ENROLMENT_CAT, IGS_EN_METHOD_TYPE, and IGS_CA_DA to present human-readable descriptions alongside the stored codes for reporting.
  • Auditing recently changed configuration, filtering on LAST_UPDATE_DATE and LAST_UPDATED_BY to trace who altered enrollment behavior and when.
  • Validating configuration completeness by counting rows per category against expected method and communication combinations.

Reporting extracts commonly flatten the composite key into a single display string, combining the category, communication type, and method type for reconciliation reports or setup migration workbooks.

Related Objects

Three foreign keys, all documented in the ETRM metadata, anchor this table to its parent entities:

  • IGS_EN_ENROLMENT_CAT — referenced via IGS_EN_CAT_PRC_DTL.ENROLMENT_CAT, supplying the enrollment category definition.
  • IGS_EN_METHOD_TYPE — referenced via IGS_EN_CAT_PRC_DTL.ENR_METHOD_TYPE, supplying the enrollment method type.
  • IGS_CA_DA — referenced via IGS_EN_CAT_PRC_DTL.ENFORCE_DATE_ALIAS, supplying the date alias used for enforcement timing.

Because it is a link table, IGS_EN_CAT_PRC_DTL depends on these parents and is itself looked up by enrollment processing logic that consults the indicator flags and validation threshold during enrollment transactions. Any change to a parent category or method definition therefore has a direct bearing on the applicability of these detail rows.