Results for “class_meet_id”
15 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
IGS_PS_USO_CLAS_MEET is a transactional table within the IGS (Student System) product schema of Oracle E-Business Suite, present in both release 12.1.1 and 12.2.2. Its documented purpose is to record all Unit Section Occurrences that belong to a given Class Meet Group. In practical terms, the table acts as the associative container that ties scheduled meeting occurrences to the grouping structures used for class scheduling, so that multiple teaching occurrences can be collected and reported as a single class meet unit.
The table is owned by the IGS schema and holds a status of VALID. The heuristic Data Vault classification mined from its foreign key structure is link. This is a modeling suggestion rather than a shipped implementation detail: the table resolves a many-to-many style association between class meet groups and unit section occurrences, and its two foreign keys point outward to parent entities, which is the characteristic signature of a link table rather than a hub or a satellite.
Key Information Stored
The documented physical schema contains ten columns. The most significant are summarized below.
- CLASS_MEET_ID — The surrogate primary key, enforced through IGS_PS_USO_CLAS_MEET_PK and also carried by unique index IGS_PS_USO_CLAS_MEET_U1. It uniquely identifies each row in this table.
- CLASS_MEET_GROUP_ID — Foreign key to IGS_PS_USO_CM_GRP, identifying the class meet group to which the occurrence belongs.
- UOO_ID — Foreign key to IGS_PS_UNIT_OFR_OPT_ALL, linking the row to the unit offering option context. It is also part of unique index IGS_PS_USO_CLAS_MEET_U2, making it a documented business-key candidate.
- UNIT_SECTION_OCCURRENCE_ID — Documented as part of unique index IGS_PS_USO_CLAS_MEET_UK1, identifying the specific unit section occurrence attached to the group.
- HOST — The host or environment identifier retained in line with standard EBS multi-tier deployment conventions.
- CREATED_BY, CREATION_DATE — Standard EBS audit columns capturing row creation.
- LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard EBS audit columns capturing the most recent modification and the login session responsible for it.
Common Use Cases and Queries
Principal use cases center on schedule reporting and integrity validation. Typical patterns join the table to its parents to reconstruct the full scheduling context.
- Listing all occurrences for a given class meet group:
SELECT u.UNIT_SECTION_OCCURRENCE_ID, u.UOO_ID FROM IGS_PS_USO_CLAS_MEET u WHERE u.CLASS_MEET_GROUP_ID = :group_id; - Confirming that every occurrence in a group maps to a valid offering option via the IGS_PS_UNIT_OFR_OPT_ALL join on UOO_ID.
- Auditing recently maintained groupings using the LAST_UPDATE_DATE and LAST_UPDATED_BY columns.
- Reporting orphaned or duplicate associations, using the UK1 and U2 unique indexes as the expected uniqueness constraints.
Related Objects
- IGS_PS_USO_CM_GRP — Parent class meet group; joined on IGS_PS_USO_CLAS_MEET.CLASS_MEET_GROUP_ID.
- IGS_PS_UNIT_OFR_OPT_ALL — Unit offering option view/table; joined on IGS_PS_USO_CLAS_MEET.UOO_ID.
- IGS_PS_UNIT_OFR_OPT — Underlying unit offering option entity, transitively reachable through the UOO_ID relationship.
- IGS_PS_USO_CLAS_MEET_PK / _UK1 / _U1 / _U2 — Primary key and unique index constraints enforcing row identity and documented business keys.
-
This table contains all Unit Section Occurrences that are part of the Class Meet Group.
-
View: IGS_PS_USO_CLAS_MEET_V 12.1.1
APPS.IGS_PS_USO_CLAS_MEET_V·↳ IGS_AS_UNIT_CLASS·↳ IGS_CA_INST·↳ IGS_PS_UNIT_OFR_OPT·Explore IGS module →
-
View: IGS_PS_USO_CLAS_MEET_V 12.2.2
Not implemented in this database·Explore IGS module →
-
Table: IGS_PS_USO_CLAS_MEET 12.2.2
This table contains all Unit Section Occurrences that are part of the Class Meet Group.
Not implemented in this database·Explore IGS module →
-
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'.