Search Results igsfv_venues

Overview

The view IGSFV_VENUES belongs to the IGS (Student System) product family within Oracle E-Business Suite, a module documented in ETRM but now classified as obsolete. In EBS 12.1.1 and 12.2.2 the object persists in the data dictionary for reference and backwards compatibility, even though the Student System functionality is no longer actively implemented. The view presents a denormalized, read-only representation of the physical venues at which examinations and graduation ceremonies can be accommodated. A venue may exist inside a broader location, such as a campus, or within an examination location, such as a town hall.

From a reporting and integration standpoint, IGSFV_VENUES exposes the venue catalogue together with the descriptive and operational attributes needed to plan, schedule, and cost examination logistics. Because the view joins venue data to location descriptions and to the coordinating party, it allows downstream reports and interfaces to resolve human-readable venue context without requiring callers to reconstruct the underlying joins. The inclusion of a read-only constraint ensures the view cannot be used for DML, positioning it purely as a query surface. The user search term "venue_code" maps directly to the primary display column exposed by this view.

Underlying Base Objects

The view text is defined over three base objects joined together:

• IGS_GR_VENUE_ALL — the driving table, aliased VEN, holding the venue master records and their operational attributes.
• IGS_AD_LOCATION_ALL — aliased LOC, joined on VEN.EXAM_LOCATION_CD = LOC.LOCATION_CD to supply the examination location description.
• HZ_PARTIES — aliased HP, joined via an outer join on VEN.COORD_PERSON_ID = HP.PARTY_ID(+) to resolve the coordinating person's party number.

The outer join on HZ_PARTIES permits venues that have no coordinating person assigned to still appear in the result set. The view is defined WITH READ ONLY. ETRM documents no owner and no separately listed referenced base objects beyond the join construct, so the base tables identified above are those inferred from the view text itself. In the documented 12.2.2 metadata the object is marked as not implemented in this database, consistent with its obsolete status.

Key Columns

• VENUE_CODE — exposed from VEN.VENUE_CD; the unique code identifying the venue and the principal lookup key.
• DESCRIPTION — the venue's descriptive name.
• EXAM_LOCATION_CODE — the examination location to which the venue belongs.
• NUMBER_OF_SEATS — seating capacity of the venue.
• BOOKING_COST — cost associated with booking the venue.
• SUPERVISOR_LIMIT — maximum number of supervisors supported.
• PRIORITY_CODE — scheduling priority assigned to the venue.
• CLOSED_INDICATOR — indicates whether the venue is closed for use.
• COMMENTS, RESOURCES_AVAILABLE, ANNOUNCEMENTS, SEATING_INFORMATION, BOOKING_INFORMATION, INSTRUCTIONS — free-text descriptive attributes.
• EXAM_LOCATION_DESC — location description drawn from IGS_AD_LOCATION_ALL.
• COORDINATE_PERSON_NUMBER / COORDINATE_PERSON_IDENTIFIER — coordinating party number and internal identifier.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE — standard audit columns.

Common Use Cases and Queries

Typical scenarios include venue catalogue reporting, capacity and cost analysis for examination planning, and resolving the coordinating person for a venue. The following query lists open venues with seating capacity and location.

• SELECT venue_code, description, exam_location_desc, number_of_seats FROM igsfv_venues WHERE closed_indicator = 'N';
• SELECT venue_code, booking_cost, supervisor_limit FROM igsfv_venues WHERE exam_location_code = :p_location;
• SELECT venue_code, coordinate_person_number FROM igsfv_venues WHERE coordinate_person_identifier IS NOT NULL;

Because the view is read-only, it should be used exclusively for extraction and reporting; any maintenance must be performed against the underlying base tables in systems where the Student System is still populated.