Search Results eam_work_clearances_pk

Overview

EAM_WORK_CLEARANCES is a core table within the Oracle E-Business Suite Enterprise Asset Management (EAM) module, owned by the EAM schema. It stores the definition of Safety Work Clearances, which are formal safety control records used in industrial and process environments to isolate hazardous energy sources before maintenance work proceeds. A work clearance record is attached to Establishment and Re-Establishment sequences, to Work Orders, and to Work Permits, forming the safety envelope within which physical maintenance execution is authorized.

From a Data Vault modeling perspective, the metadata classifies this object heuristically as standalone, indicating no validated foreign-key dependencies to related hub tables within the documented FK structure. Analysts modeling EAM data in a dimensional or Data Vault warehouse should therefore treat EAM_WORK_CLEARANCES as a candidate hub keyed on WORK_CLEARANCE_ID, with attributes such as status, schedule dates, and approval information logically segregable into a satellite, and with establishment/re-establishment sequences and permit associations represented through separate link structures.

Key Information Stored

The table is defined physically with 51 columns in release 12.2.2. The most significant columns include:

• WORK_CLEARANCE_ID — the surrogate primary key, enforced by the EAM_WORK_CLEARANCES_PK constraint and also carried by the unique index EAM_WORK_CLEARANCES_U1.
• WORK_CLEARANCE_NAME and DESCRIPTION — the business-facing identifier and free-text description of the clearance.
• ORGANIZATION_ID — the inventory/asset organization that owns the clearance, which is the primary partitioning key in multi-org reporting.
• LAST_ISOLATION_ID — reference to the most recent isolation associated with the clearance, tying the safety record to locked-out equipment.
• SCHEDULED_ESTAB_START_DATE / SCHEDULED_ESTAB_END_DATE — the planned window for establishing isolation, and SCHEDULED_REESTAB_START_DATE / SCHEDULED_REESTAB_END_DATE for re-establishment on completion.
• COMPLETION_DATE and APPROVED_BY — audit fields capturing when the clearance was closed and by whom it was authorized.
• USER_DEFINED_STATUS_ID and STATUS_TYPE — the workflow or lifecycle status of the clearance.
• PENDING_FLAG and PERMIT_REQUIRED_FLAG — control indicators governing whether the clearance is awaiting action and whether a work permit is mandatory.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1–ATTRIBUTE30 — the standard EBS descriptive flexfield columns used for customer-specific extensions.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, and LAST_UPDATE_LOGIN — the standard EBS Audit Trail (WHO) columns.

Common Use Cases and Queries

Typical reporting scenarios include identifying clearances that are pending approval, tracking scheduled versus actual establishment windows, and reconciling clearances against work orders and permits. A common query pattern retrieves all dormant or pending clearances for an organization:

SELECT wc.work_clearance_id,
       wc.work_clearance_name,
       wc.status_type,
       wc.scheduled_estab_start_date,
       wc.scheduled_estab_end_date
FROM   eam_work_clearances wc
WHERE  wc.organization_id = :p_org_id
AND    wc.pending_flag = 'Y'
ORDER BY wc.scheduled_estab_start_date;

Safety and compliance reporting frequently joins the table to work order and permit structures to confirm approved_by and completion_date coverage. Schedule adherence analysis compares the scheduled establishment and re-establishment dates against the actual completion date to identify clearances closed outside their planned windows. Because the table is classified as standalone, joins must be constructed through the operational relationships documented in the associated Establishment/Re-Establishment and Work Permit entities rather than through declared foreign keys.

Related Objects

Although no enforced FK relationships are documented, the following objects are functionally significant:

• EAM_WORK_ORDERS — work orders are attached to clearances; the linkage is normally resolved through the work order's clearance reference.
• EAM_WORK_PERMITS — work permits are associated with clearances where PERMIT_REQUIRED_FLAG is set.
• EAM_ESTAB_REESTAB_SEQ (Establishment and Re-Establishment sequences) — the isolation sequences driven by work clearance establishment and re-establishment.
• EAM_ISOLATIONS — referenced through LAST_ISOLATION_ID.
• HR_ALL_ORGANIZATION_UNITS — joined via ORGANIZATION_ID for organization descriptions.
• FND_USER — joined through APPROVED_BY, CREATED_BY, and LAST_UPDATED_BY.