Results for “igs_ps_us_em_grp”

23 results




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

Overview

IGS_PS_US_EM_GRP is a transactional configuration table owned by the IGS schema within the Oracle E-Business Suite Student System (formerly Student Records / Oracle Student System). Its documented purpose is to store information about Meet With Exam Groups — that is, the grouping definitions used to associate students who must sit an examination together, typically for scheduling, seating, or invigilation purposes. The table resides in the Academic Records domain of the IGS product and is populated as institutions define examination meeting arrangements against a calendar instance.

From a Data Vault modeling perspective, the mined relationship profile classifies this object as satellite-leaning. It carries a surrogate primary key, descriptive business attributes, and a foreign key to a calendar instance, with a single dependent child table referencing it. This suggests it behaves primarily as a descriptive satellite attached to a calendar/hub context rather than as a central hub or a pure many-to-many link.

Key Information Stored

The table contains nine documented columns in the 12.1.1 physical schema. The most significant are:

The unique index IGS_PS_US_EMG_GRP_U2 on (EXAM_MEET_GROUP_NAME, CAL_TYPE, CI_SEQUENCE_NUMBER) confirms the natural business key: a group name must be unique within a given calendar instance.

Common Use Cases and Queries

Typical reporting scenarios include listing all exam meeting groups for a calendar instance, resolving group names for downstream exam seating reports, and validating that groups are scoped to valid calendar instances. A representative query joining to the calendar instance follows:

  • Listing groups by calendar: SELECT g.EXAM_MEET_GROUP_ID, g.EXAM_MEET_GROUP_NAME, g.CAL_TYPE, g.CI_SEQUENCE_NUMBER FROM IGS.IGS_PS_US_EM_GRP g WHERE g.CAL_TYPE = :cal_type AND g.CI_SEQUENCE_NUMBER = :seq ORDER BY g.EXAM_MEET_GROUP_NAME;
  • Resolving the parent calendar instance: SELECT g.EXAM_MEET_GROUP_NAME, c.* FROM IGS.IGS_PS_US_EM_GRP g, IGS.IGS_CA_INST_ALL c WHERE g.CAL_TYPE = c.CAL_TYPE AND g.CI_SEQUENCE_NUMBER = c.CI_SEQUENCE_NUMBER;
  • Finding exam meetings within a group via the child table: SELECT m.* FROM IGS.IGS_PS_US_EXAM_MEET m WHERE m.EXAM_MEET_GROUP_ID = :group_id;

Audit queries frequently filter on LAST_UPDATE_DATE to detect recently altered groupings, and integration extracts commonly use the natural key (name plus calendar context) when loading into external scheduling systems.

Related Objects

  • IGS_CA_INST_ALL — parent calendar instance; joined via CAL_TYPE and CI_SEQUENCE_NUMBER.
  • IGS_PS_US_EXAM_MEET — child exam meeting records; joined via EXAM_MEET_GROUP_ID.
  • Other IGS calendar and exam-scheduling tables that reference the same calendar instance context for exam timetabling and invigilation reporting.

Together these relationships define the group as a configuration anchor for exam meeting records scoped to a calendar instance.