Results for “rank_code”

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

Overview

The AS_EVENT_FACILITIES_ALL table resides in the OSM schema and belongs to the AS – Sales Foundation product family within Oracle E-Business Suite (12.1.1 and 12.2.2). It stores the master definition of event facilities — physical venues or locations at which promotional or marketing events are conducted. Each row represents a facility with a code, name, address, contact information, and organizational context. The table is marked VALID in the ETRM repository and is documented with 43 columns.

From a Data Vault modeling perspective, the metadata's heuristic classification is hub-leaning. AS_EVENT_FACILITIES_ALL behaves as a business hub: it holds the durable business key (EVENT_FACILITY_ID, and the composite CODE/NAME/ORG_ID) around which transactional and descriptive satellite data (rooms, staff, promotion associations) revolve. Downstream tables such as AS_EVENT_FAC_ROOMS and AS_EVENT_FAC_STAFF act as satellites or links referencing this hub.

Key Information Stored

The table's primary key is the surrogate EVENT_FACILITY_ID (constraint AS_EVENT_FACILITIES_PK). Business-key candidates are captured by unique indexes: AS_EVENT_FACILITIES_U1 on EVENT_FACILITY_ID and AS_EVENT_FACILITIES_U2 on the natural composite (CODE, NAME, ORG_ID). The most significant columns include:

• EVENT_FACILITY_ID — surrogate primary key and the foreign-key target for all dependent tables.
• CODE and NAME — the human-readable facility identifier and description; combined with ORG_ID they form the unique business key.
• ENABLED_FLAG — controls whether the facility is active and selectable.
• RANK_CODE and TYPE_CODE — classification and ordering attributes used in reporting and prioritization.
• ORG_ID — the operating unit / organization that owns the facility record.
• ADDRESS1–ADDRESS4, CITY, STATE, PROVINCE, POSTAL_CODE, COUNTY, COUNTRY_CODE — the full postal address of the venue.
• AREA_CODE, PHONE_NUMBER, EXTENSION — contact telephony details.
• DIRECTIONS and COMMENTS — free-text logistical notes.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1–ATTRIBUTE15 — the standard EBS descriptive flexfield (DFF) segment set for client-specific extensions.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — the standard WHO audit columns.

Common Use Cases and Queries

Typical scenarios include venue lookup during event planning, address/contact reporting for logistics, and joining facilities to their associated promotions. A common query pattern joins the hub to AS_PROMOTIONS_ALL via EVENT_FACILITY_ID to list all promotions staged at a given venue, or restricts by operating unit with WHERE ORG_ID = :p_org_id. Inventory-style queries against AS_EVENT_FAC_ROOMS and AS_EVENT_FAC_STAFF list the rooms and personnel tied to a facility.

Sample SQL:

• SELECT EVENT_FACILITY_ID, CODE, NAME, CITY, STATE, COUNTRY_CODE FROM AS_EVENT_FACILITIES_ALL WHERE ENABLED_FLAG = 'Y' AND ORG_ID = :p_org_id;
• SELECT p.PROMOTION_NAME, f.NAME FROM AS_PROMOTIONS_ALL p JOIN AS_EVENT_FACILITIES_ALL f ON p.EVENT_FACILITY_ID = f.EVENT_FACILITY_ID;

Because the table exposes standard DFF attributes, reporting tools and concurrent programs can resolve ATTRIBUTE_CATEGORY against the flexfield definitions to surface client-specific descriptive data.

Related Objects

The ETRM metadata documents the following relationships, all keyed by EVENT_FACILITY_ID:

• AS_PROMOTIONS_ALL — references AS_EVENT_FACILITIES_ALL.EVENT_FACILITY_ID via AS_PROMOTIONS_ALL.EVENT_FACILITY_ID, linking promotions to their venue.
• AS_EVENT_FAC_ROOMS — references the facility, holding room-level detail for each facility.
• AS_EVENT_FAC_STAFF — references the facility, holding assigned personnel records.

These three dependent tables form the core of the event facility domain, with the hub providing the shared business key that satellites and association tables reuse through the EVENT_FACILITY_ID foreign key. Together they support end-to-end reporting on promotional venues, their resources, and their staffing.