Results for “expiry_dt”

50+ results




Overview
Explore in AI Chat

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

Overview

IGS_PE_CRS_GRP_EXCL is a table within the Oracle E-Business Suite IGS (Student System) product family, documented against releases 12.1.1 and 12.2.2. The ETRM metadata describes this entity as representing a course group from which a person has been excluded. In functional terms, the table records exclusion or encumbrance records that prevent a learner from being associated with a designated course group, typically as a result of an administrative, disciplinary, or eligibility-driven decision. Each row therefore captures the intersection of a person, an encumbrance context, and a course group, together with the effective-dating attributes that govern when the exclusion applies.

On the physical side, the ETRM documentation notes 14 columns owned by the IGS schema and states that the table is not implemented in the reference database. This is significant: availability varies by environment depending on whether the corresponding Student System functionality was licensed and installed. The metadata further classifies the object, using a heuristic derived from its foreign key structure, as a Data Vault link. Treated as a modeling suggestion rather than a normative fact, this positioning is consistent with the table's role as a relationship record connecting a person's encumbrance state to a course group rather than as a standalone descriptive hub or satellite.

Key Information Stored

The table's primary key, IGS_PE_CRS_GRP_EXCL_PK, is a composite business key spanning PERSON_ID, ENCUMBRANCE_TYPE, PEN_START_DT, S_ENCMB_EFFECT_TYPE, PEE_START_DT, PEE_SEQUENCE_NUMBER, COURSE_GROUP_CD, and PCGE_START_DT. The unique index IGS_PE_CRS_GRP_EXCL_U1 mirrors these same columns, confirming that the table relies on the natural key rather than a system-generated surrogate identifier.

  • PERSON_ID — identifies the excluded individual; part of the primary key and a foreign key to IGS_PE_PERSENC_EFFCT.
  • COURSE_GROUP_CD — the course group from which the person is excluded; foreign key to IGS_PS_GRP_ALL.
  • ENCUMBRANCE_TYPE — categorizes the nature of the encumbrance driving the exclusion.
  • PEN_START_DT — start date of the person encumbrance record.
  • S_ENCMB_EFFECT_TYPE — the encumbrance effect type associated with the person encumbrance.
  • PEE_START_DT and PEE_SEQUENCE_NUMBER — together identify the effective-dated person encumbrance entry, including its sequence within that date.
  • PCGE_START_DT — start date of the course group entry, providing the effective-dating anchor on the course group side.
  • EXPIRY_DT — the date on which the exclusion ceases to apply.
  • Audit columns — CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, and LAST_UPDATE_LOGIN carry standard Oracle EBS "WHO" auditing.

Common Use Cases and Queries

Reporting against this table typically serves three purposes: identifying all course groups from which a given learner is barred, auditing exclusions that were active during a specified period, and verifying that registration or enrollment logic honored the exclusion. A representative query joins the exclusion to the person encumbrance and course group masters:

  • SELECT e.person_id, e.course_grp_cd, e.encumbrance_type, e.pen_start_dt, e.expiry_dt FROM igs_pe_crs_grp_excl e WHERE e.person_id = :person_id AND (e.expiry_dt IS NULL OR e.expiry_dt > SYSDATE) — active exclusions for one person.
  • SELECT * FROM igs_pe_crs_grp_excl WHERE course_grp_cd = :group AND TRUNC(pcge_start_dt) BETWEEN :from_dt AND :to_dt — point-in-time review of exclusions for a course group.
  • Joining to IGS_PS_GRP_ALL on COURSE_GROUP_CD to resolve group descriptions for reporting.

Because exclusions are effective-dated on multiple axes, queries must account for both the person-encumbrance dates and the course-group start date. Analysts should treat EXPIRY_DT as the natural end-of-life marker and avoid assuming that absence of an expiry implies permanence without confirming business rules.

Related Objects

Two foreign key relationships are documented in the ETRM metadata, and they define the table's immediate integration surface.

  • IGS_PS_GRP_ALL — the course group master; joined via IGS_PE_CRS_GRP_EXCL.COURSE_GROUP_CD.
  • IGS_PE_PERSENC_EFFCT — the person encumbrance effect record; joined via PERSON_ID, ENCUMBRANCE_TYPE, PEN_START_DT, S_ENCMB_EFFECT_TYPE, PEE_START_DT, and PEE_SEQUENCE_NUMBER.

Beyond these documented relationships, related IGS entities such as the person and enrollment tables are reached transitively through those foreign keys. Because the table is flagged as obsolete, implementers should verify its presence and population in each target environment before relying on it as a system of record.