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:
- EXAM_MEET_GROUP_ID — the surrogate primary key, enforced by IGS_PS_USO_EMG_GRP_PK and a unique index IGS_PS_US_EMG_GRP_U1. This is the system-generated identifier used by all dependent records.
- EXAM_MEET_GROUP_NAME — the user-facing name of the exam meeting group; part of a business-key candidate.
- CAL_TYPE — the calendar type code, which identifies which academic calendar the group belongs to and forms part of the foreign key to IGS_CA_INST_ALL.
- CI_SEQUENCE_NUMBER — the calendar instance sequence number, the second component of the IGS_CA_INST_ALL foreign key, tying the group to a specific calendar instance (e.g., an academic year or period).
- CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard Oracle EBS WHO audit columns capturing creation and last-modification traceability.
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.
-
This table contains information about Meet With Exam Groups
-
TABLE: IGS.IGS_PS_US_EM_GRP 12.1.1
-
Table: IGS_PS_US_EM_GRP 12.2.2
This table contains information about Meet With Exam Groups
Not implemented in this database·Explore IGS module →
-
View: IGS_PS_US_EM_GRP_V 12.1.1
APPS.IGS_PS_US_EM_GRP_V·↳ IGS_CA_INST·↳ IGS_PS_US_EM_GRP·Explore IGS module →
-
View: IGS_PS_US_EM_GRP_V 12.2.2
Not implemented in this database·Explore IGS module →
-
This table contains Unit Sections that are part of the Meet With Exam Group.
-
Table: IGS_CA_INST_ALL 12.2.2
Describes an instance of a calendar type
Not implemented in this database·Explore IGS module →
-
12.1.1 DBA Data 12.1.1
-
12.1.1 DBA Data 12.1.1
-
12.1.1 FND Design Data 12.1.1
-
12.2.2 FND Design Data 12.2.2
-
12.1.1 DBA Data 12.1.1
-
12.1.1 DBA Data 12.1.1
-
eTRM - IGS Tables and Views 12.1.1
Holds applicant whose records are wrongly available . It is recommended that such applicant records are deleted from the system . It synchronizes with UCAS view 'ivStarW'.
-
eTRM - IGS Tables and Views 12.1.1
Holds applicant whose records are wrongly available . It is recommended that such applicant records are deleted from the system . It synchronizes with UCAS view 'ivStarW'.