Results for “as_event_fac_staff”

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

Overview

AS_EVENT_FAC_STAFF is a table owned by the OSM schema within the AS — Sales Foundation product family of Oracle E-Business Suite (validated against 12.1.1 and 12.2.2). It stores the roster of personnel associated with a given event facility, capturing names, contact details, job titles, and a designation of which staff member is primary. The table therefore functions as the master record of facility staff used by downstream sales and promotions processes.

The object is documented with 34 physical columns, a single-row primary key, and one unique business-key index. Its status is VALID, and it carries the standard ETRM "Oracle Proprietary, Confidential Information" designation.

Under the heuristic Data Vault classification mined from its foreign-key structure, AS_EVENT_FAC_STAFF is modelled as a standalone entity. In Data Vault terms this suggests it behaves less like a pure satellite hanging off a parent hub and more like an independent hub with its own natural business key, since only one outbound foreign key is present and the table is itself referenced by another All table. The classification is a modelling suggestion only; the physical design remains a conventional EBS transactional/ descriptive table.

Key Information Stored

The table's surrogate primary key is EVENT_FAC_STAFF_ID, enforced through the constraint AS_EVENT_FAC_STAFF_PK. The same column also appears in the unique index AS_EVENT_FAC_STAFF_U1, so it serves as both the technical and the documented business-key candidate.

• EVENT_FACILITY_ID — foreign key linking each staff record to its parent facility in AS_EVENT_FACILITIES_ALL.
• PRIMARY_FLAG — identifies the principal contact for the facility.
• STATUS_CODE — lifecycle status of the staff record (e.g. active or inactive).
• LAST_NAME and FIRST_NAME — the staff member's name.
• JOB_TITLE — the role held at the facility.
• AREA_CODE, PHONE_NUMBER, EXTENSION — voice contact details.
• FAX_AREA_CODE and FAX_PHONE_NUMBER — facsimile contact details.
• COMMENTS — free-text notes.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1 through ATTRIBUTE15 — the standard EBS descriptive flexfield columns for client-specific extensions.

The audit columns LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, and LAST_UPDATE_LOGIN are present but are not part of the business key.

Common Use Cases and Queries

The most frequent scenario is retrieving the primary contact or full staff list for a facility, typically joined to the facility master:

• Primary contact lookup: SELECT s.FIRST_NAME, s.LAST_NAME, s.PHONE_NUMBER FROM AS_EVENT_FAC_STAFF s WHERE s.EVENT_FACILITY_ID = :facility_id AND s.PRIMARY_FLAG = 'Y' AND s.STATUS_CODE = 'ACTIVE'.
• Staff roster by facility: a simple join to AS_EVENT_FACILITIES_ALL on EVENT_FACILITY_ID to report facility name against each staff member.
• Promotion linkage: join AS_PROMOTIONS_ALL to AS_EVENT_FAC_STAFF on EVENT_FAC_STAFF_ID to determine which promotions are tied to a given staff record or facility contact.
• Data-quality reporting: identify records with null PHONE_NUMBER or AREA_CODE for contact-completeness audits.

Reporting typically filters on STATUS_CODE to exclude retired staff, and uses the ATTRIBUTEn columns only when a client has enabled a descriptive flexfield on the object.

Related Objects

• AS_EVENT_FACILITIES_ALL — parent facility; joined via AS_EVENT_FAC_STAFF.EVENT_FACILITY_ID → AS_EVENT_FACILITIES_ALL.
• AS_PROMOTIONS_ALL — references this table through AS_PROMOTIONS_ALL.EVENT_FAC_STAFF_ID.
• AS_EVENT_FAC_STAFF_PK — primary key constraint on EVENT_FAC_STAFF_ID.
• AS_EVENT_FAC_STAFF_U1 — unique index on EVENT_FAC_STAFF_ID.
• Standard EBS audit columns — LAST_UPDATED_BY / CREATED_BY resolve to FND_USER for ownership and change tracking.

No public API specific to this table is documented in the ETRM metadata; the object is consumed primarily through the Sales Foundation UI and through SQL access to the OSM schema.