Results for “igs_en_pig_cp_setup”

28 results




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

Overview

IGS_EN_PIG_CP_SETUP is a configuration table in the Oracle E-Business Suite Student System (IGS) product family. Its name expands to Person ID Group Enrollment Credit Points Setup, and it stores credit point thresholds associated with person identification groups. In the Oracle EBS 12.1.1 and 12.2.2 data models, this table acts as a setup or control table used by enrollment and academic progress processes to determine minimum and maximum credit point boundaries for a defined population of learners. Because it holds qualifying attributes that describe a parent business entity rather than the entity itself, a Data Vault classification heuristic suggests treating it as satellite-leaning — a descriptor table attached to the person ID group it qualifies.

Key Information Stored

The primary key is IGS_EN_PIG_CP_SETUP_PK, defined on GROUP_ID. A second unique index, IGS_EN_PIG_CP_SETUP_U1, also spans GROUP_ID, marking that column as the sole business-key candidate and enforcing a strict one-to-one association between a group and its credit point setup row. The documented columns are:

  • GROUP_ID — surrogate primary key and foreign key to the parent person ID group; each value identifies one enrollment credit point configuration record.
  • PRSID_MIN_CP — the minimum credit point threshold applied to a person within the group.
  • PRSID_MAX_CP — the maximum credit point threshold applied to a person within the group.
  • CREATED_BY, CREATION_DATE — audit columns capturing who created the setup row and when.
  • LAST_UPDATED_BY, LAST_UPDATE_DATE — audit columns recording the most recent modification and its author.
  • LAST_UPDATE_LOGIN — the login identifier of the session that performed the last update.

Together, PRSID_MIN_CP and PRSID_MAX_CP form the meaningful business payload of the table; the remaining columns are standard EBS WHO-column audit metadata.

Common Use Cases and Queries

Typical usage centers on validating whether a student's accumulated credit points fall within the bounds configured for their person ID group. A representative lookup for a single group is:

SELECT group_id, prsid_min_cp, prsid_max_cp FROM igs_en_pig_cp_setup WHERE group_id = :p_group_id;

Reporting scenarios include auditing all configured thresholds, comparing ranges across groups, and detecting overlaps or gaps in credit point coverage. A join to the parent group table supports descriptive reporting:

SELECT s.group_id, g.name, s.prsid_min_cp, s.prsid_max_cp FROM igs_en_pig_cp_setup s, igs_pe_persid_group_all g WHERE s.group_id = g.group_id;

Integration and data-migration exercises frequently extract this table to document enrollment rule baselines. Because the table is small and setup-oriented, it is often cached or referenced during batch enrollment validation rather than queried interactively at high volume.

Related Objects

  • IGS_PE_PERSID_GROUP_ALL — the parent person identification group table; joined on GROUP_ID (the documented foreign key relationship).
  • IGS_EN_PIG_CP_SETUP_PK / IGS_EN_PIG_CP_SETUP_U1 — the primary key constraint and unique index on GROUP_ID that enforce row uniqueness.
  • Person ID group child and enrollment tables within the IGS Student System that consume the configured credit point thresholds during eligibility evaluation.
  • Credit point and academic progress utilities in the IGS enrollment module that read PRSID_MIN_CP and PRSID_MAX_CP at runtime.

Because the metadata documents only one outbound foreign key, IGS_PE_PERSID_GROUP_ALL remains the single confirmed dependency for joins and referential analysis.