Results for “seating_information”

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

Overview

The IGS_GR_VENUE_ALL table belongs to the IGS (Student System) product family within Oracle E-Business Suite, a module now classified as obsolete in the ETRM documentation. It represents the physical venue at which institutional events such as examinations, graduation ceremonies, and similar gatherings are accommodated. A venue may exist independently or be associated with a broader location, such as a campus, or with an examination location, such as a town hall. The entity therefore serves as a master reference for scheduling and logistics within the student system, capturing the properties of each facility used for formal events.

The table is physically implemented in the 12.1.1 schema under owner IGS and contains 21 documented columns. Its primary key is IGS_GR_VENUE_PK, defined on the VENUE_CD column, and a unique index IGS_GR_VENUE_ALL_U1 on VENUE_CD confirms that the venue code is the natural business key. From a heuristic Data Vault modeling perspective, the object is classified as hub-leaning: it holds a stable, uniquely identifiable business entity (the venue) around which descriptive and transactional attributes and multiple downstream references accumulate. The documentation notes this object is not implemented in the current database instance, so it should be treated as a reference definition rather than an active runtime structure.

Key Information Stored

The most significant columns support identification, capacity planning, ownership, and scheduling of each venue:

• VENUE_CD — the business key and primary key component; the unique code identifying a venue.
• EXAM_LOCATION_CD — foreign key to IGS_AD_LOCATION_ALL, linking the venue to its parent location or examination location.
• DESCRIPTION — the descriptive name or label of the venue.
• NUMBER_OF_SEATS — the seating capacity, used in capacity and allocation planning.
• BOOKING_COST — the cost associated with booking the venue.
• PRIORITY_CD — a code indicating the venue's priority ranking for scheduling decisions.
• SUPERVISOR_LIMIT — the maximum number of supervisors permitted at the venue.
• COORD_PERSON_ID — foreign key to HZ_PARTIES, identifying the coordinating person responsible for the venue.
• CLOSED_IND — a flag indicating whether the venue is closed or unavailable.
• RESOURCES_AVAILABLE, ANNOUNCEMENTS, BOOKING_INFORMATION, SEATING_INFORMATION, INSTRUCTIONS — descriptive text attributes relating to facilities, notices, and operational guidance.
• ORG_ID — the operating unit context, supporting multi-organization data partitioning.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard audit columns.

The surrogate primary key IGS_GR_VENUE_PK is distinct from the unique business-key candidate VENUE_CD; the former enforces row identity while the latter enforces the natural venue identifier.

Common Use Cases and Queries

Typical usage centres on identifying venues with sufficient capacity, filtering out closed venues, and locating the coordinator. A capacity inquiry might join the venue to its parent location:

• SELECT v.VENUE_CD, v.DESCRIPTION, v.NUMBER_OF_SEATS FROM IGS_GR_VENUE_ALL v WHERE v.CLOSED_IND = 'N' AND v.NUMBER_OF_SEATS >= :required_seats;
• SELECT v.VENUE_CD, v.EXAM_LOCATION_CD, l.DESCRIPTION FROM IGS_GR_VENUE_ALL v, IGS_AD_LOCATION_ALL l WHERE v.EXAM_LOCATION_CD = l.LOCATION_CD;
• Joining to IGS_AS_EXAM_INSTANCE_ALL on VENUE_CD to report all examinations scheduled at each venue.

Reporting scenarios include venue utilisation, booking cost summaries by operating unit (ORG_ID), and coordinator contact listings resolved through HZ_PARTIES.

Related Objects

The table participates in several documented foreign key relationships:

• HZ_PARTIES — referenced via COORD_PERSON_ID to identify the coordinating person.
• IGS_AD_LOCATION_ALL — referenced via EXAM_LOCATION_CD, defining the parent location.
• IGS_AS_EXAM_INSTANCE_ALL — references IGS_GR_VENUE_ALL.VENUE_CD, linking scheduled examination instances to their venue.
• IGS_AS_EXMVNU_SESAVL_ALL — references VENUE_CD, associating venue session availability records.
• IGS_GR_CRMN_ALL — references VENUE_CD, tying graduation ceremony records to their venue.

These relationships confirm the table's role as a hub-leaning reference entity at the centre of examination and graduation scheduling within the IGS Student System.