Results for “as_event_fac_rooms”

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

Overview

AS_EVENT_FAC_ROOMS is a table in the Oracle E-Business Suite Sales Foundation (AS) product, owned by the OSM schema. It stores the individual rooms or spaces that belong to an event facility, such as conference halls, ballrooms, breakout rooms, or meeting suites. Because event facilities are frequently marketed and contracted for trade shows, conferences, and promotional events, the room-level detail captured here supports downstream pricing, capacity planning, and promotion configuration. The table is validated and present in both EBS 12.1.1 and 12.2.2.

From a Data Vault modeling perspective, the supplied heuristic classifies this object as standalone. It carries a single-column surrogate primary key and one outbound foreign key, but no dependent child tables other than a reference from promotions. Functionally it behaves as a hub-like reference entity: each row is a uniquely identified facility room, with descriptive attributes (capacity, area, cost) stored in the same table rather than split into a separate satellite.

Key Information Stored

The table contains 31 documented columns. The most significant are:

• EVENT_FAC_ROOM_ID — Surrogate primary key; defined by AS_EVENT_FAC_ROOMS_PK and also unique via AS_EVENT_FAC_ROOMS_U1.
• NAME — Descriptive room name; combined with EVENT_FACILITY_ID in unique index AS_EVENT_FAC_ROOMS_U2, making (NAME, EVENT_FACILITY_ID) the business-key candidate.
• EVENT_FACILITY_ID — Foreign key to AS_EVENT_FACILITIES_ALL; identifies the parent facility.
• CAPACITY — Seating or attendance capacity, used for venue selection and reporting.
• AREA — Physical floor area of the room.
• CEILING_HEIGHT — Vertical clearance, relevant for staging and equipment.
• COST_PER_DAY and CURRENCY_CODE — Daily rental cost and its currency, supporting pricing and promotion setup.
• DIRECT_PHONE_LINE_FLAG — Indicates whether the room has a dedicated phone line.
• COMMENTS — Free-form notes.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1..ATTRIBUTE15 — The standard EBS descriptive flexfield columns for extensible, customer-defined attributes.
• Audit columns — CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN.

Common Use Cases and Queries

Typical scenarios include venue capacity reporting, room cost analysis, and promotion eligibility. The user search "TOTAL CHECK IN ROOMS - 05" suggests a count-based report of rooms, possibly filtered by facility or by an attribute segment.

A representative query counting rooms by facility:

• SELECT f.FACILITY_NAME, COUNT(r.EVENT_FAC_ROOM_ID) total_rooms FROM AS_EVENT_FAC_ROOMS r JOIN AS_EVENT_FACILITIES_ALL f ON r.EVENT_FACILITY_ID = f.EVENT_FACILITY_ID GROUP BY f.FACILITY_NAME;

A query retrieving capacity and cost detail:

• SELECT r.NAME, r.CAPACITY, r.AREA, r.COST_PER_DAY, r.CURRENCY_CODE FROM AS_EVENT_FAC_ROOMS r WHERE r.EVENT_FACILITY_ID = :facility_id;

Because of the (NAME, EVENT_FACILITY_ID) unique index, lookups by facility and room name are efficient and safe for de-duplication. Reporting layers frequently denormalize CAPACITY and COST_PER_DAY into venue-utilization dashboards.

Related Objects

• AS_EVENT_FACILITIES_ALL — Parent facility; joined on EVENT_FACILITY_ID = EVENT_FACILITY_ID.
• AS_PROMOTIONS_ALL — References this table via EVENT_FAC_ROOM_ID, allowing promotions to be tied to specific rooms.
• AS_EVENT_FAC_ROOMS_PK / AS_EVENT_FAC_ROOMS_U1 / AS_EVENT_FAC_ROOMS_U2 — Primary and unique indexes enforcing identity and business keys.

The table is primarily a setup and reference object, consumed by promotions and venue-reporting logic rather than through a dedicated public API.