Search Results eam_work_permits

Overview

EAM.EAM_WORK_PERMITS is the master definition table for safety work permits within the Oracle Enterprise Asset Management (EAM) module. In Oracle EBS 12.1.1 and 12.2.2, this table stores the permit templates and permit records that authorize personnel to perform specific maintenance activities under controlled safety conditions. Once a permit is defined here, it must be associated to Work Orders before maintenance execution can proceed against the governed asset. The table resides in the EAM schema and is classified as VALID with 48 documented columns.

From a Data Vault modeling perspective, the heuristic classification mined from the FK structure is standalone. This suggests the table can be modeled as an independent hub with its own business key rather than as a dependent link or satellite. Modelers should treat the permit as a durable business concept rather than a transactional edge between two other entities.

Key Information Stored

The table's surrogate primary key is PERMIT_ID, enforced by the constraint EAM_PERMIT_PK and also covered by the unique index EAM_WORK_PERMIT_U1. This makes PERMIT_ID the strongest business-key candidate documented for the entity.

PERMIT_ID — surrogate primary key; the unique identifier for each work permit.
PERMIT_NAME — the descriptive name of the permit definition.
DESCRIPTION — free-text description of the safety permit scope.
ORGANIZATION_ID — the inventory organization / operating unit context in which the permit applies.
PERMIT_TYPE — the classification of the permit (e.g., hot work, confined space).
VALID_FROM / VALID_TO — effective date range during which the permit is valid.
PENDING_FLAG — indicates whether the permit is awaiting action.
COMPLETION_DATE — the date the permit was completed or closed.
STATUS_TYPE / USER_DEFINED_STATUS_ID — the system and user-defined status of the permit lifecycle.
APPROVED_BY — the approver responsible for authorizing the permit.
ATTRIBUTE_CATEGORY and ATTRIBUTE1–ATTRIBUTE30 — the standard EBS flexfield/descriptive segment columns for extensibility.
CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — standard audit columns.

Common Use Cases and Queries

Typical reporting use cases include retrieving all active permits for an organization, tracking permits approaching expiration, and identifying permits awaiting approval. A representative query follows:

SELECT permit_id, permit_name, permit_type, status_type,
       valid_from, valid_to, approved_by
FROM   eam.eam_work_permits
WHERE  organization_id = :org_id
AND    TRUNC(SYSDATE) BETWEEN valid_from AND valid_to
AND    pending_flag = 'N';

Auditors frequently query permits joined to work orders to verify that governed maintenance tasks had valid authorization at execution time. Dashboards can aggregate permits by STATUS_TYPE and PERMIT_TYPE to report safety compliance metrics.

Related Objects

Because the table is classified as standalone, it does not expose outgoing foreign keys in the mined metadata. Its practical relationships are realized logically through the EAM work order framework and reference the following objects:

EAM_WORK_ORDERS — associates permits to work orders (permit-to-work-order mapping).
EAM_WORK_ORDER_PERMITS (or equivalent association entity) — the join between work orders and permits.
EAM_WORK_PERMIT_APPROVERS / approver detail tables — resolve APPROVED_BY.
PER_USERS / FND_USER — lookup for CREATED_BY, LAST_UPDATED_BY, and APPROVED_BY.
HR_ALL_ORGANIZATION_UNITS / ORG_ORGANIZATION_DEFINITIONS — resolve ORGANIZATION_ID.
FND_LOOKUP_VALUES — resolves PERMIT_TYPE and STATUS_TYPE lookup codes.

Table: EAM_WORK_PERMITS 12.2.2
owner:EAM, object_type:TABLE, fnd_design_data:EAM.EAM_WORK_PERMITS, object_name:EAM_WORK_PERMITS, status:VALID, product: EAM - Enterprise Asset Management , description: This table stores safety work permit definition. Once permits are defined, they need to be associated to Work Orders. , implementation_dba_data: EAM.EAM_WORK_PERMITS ,
VIEW: APPS.EAM_WORK_PERMIT_DFV 12.2.2
APPS.EAM_PERMIT_VALIDATE_PVT SQL Statements 12.2.2
SYNONYM: APPS.EAM_WORK_PERMITS 12.2.2
owner:APPS, object_type:SYNONYM, object_name:EAM_WORK_PERMITS, status:VALID,
VIEW: EAM.EAM_WORK_PERMITS# 12.2.2
owner:EAM, object_type:VIEW, object_name:EAM_WORK_PERMITS#, status:VALID,
APPS.EAM_SAFETY_ASSOCIATION_PVT SQL Statements 12.2.2
APPS.EAM_SAFETY_REPORTS_PVT SQL Statements 12.2.2
VIEW: EAM.EAM_WORK_PERMITS# 12.2.2
APPS.EAM_PERMIT_UTILITY_PVT SQL Statements 12.2.2
VIEW: APPS.EAM_WORK_PERMIT_DFV 12.2.2
owner:APPS, object_type:VIEW, object_name:EAM_WORK_PERMIT_DFV, status:VALID,
PACKAGE BODY: APPS.EAM_PERMIT_VALIDATE_PVT 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:EAM_PERMIT_VALIDATE_PVT, status:VALID,
12.2.2 DBA Data 12.2.2
PACKAGE BODY: APPS.EAM_SAFETY_ASSOCIATION_PVT 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:EAM_SAFETY_ASSOCIATION_PVT, status:VALID,
12.2.2 DBA Data 12.2.2
PACKAGE BODY: APPS.EAM_PERMIT_UTILITY_PVT 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:EAM_PERMIT_UTILITY_PVT, status:VALID,
12.2.2 DBA Data 12.2.2
PACKAGE BODY: APPS.EAM_SAFETY_REPORTS_PVT 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:EAM_SAFETY_REPORTS_PVT, status:VALID,
12.2.2 FND Design Data 12.2.2
12.2.2 DBA Data 12.2.2
12.2.2 DBA Data 12.2.2
PACKAGE BODY: APPS.EAM_SAFETY_REPORTS_PVT 12.2.2
TABLE: EAM.EAM_WORK_PERMITS 12.2.2
owner:EAM, object_type:TABLE, fnd_design_data:EAM.EAM_WORK_PERMITS, object_name:EAM_WORK_PERMITS, status:VALID,
PACKAGE BODY: APPS.EAM_WORKORDERREP_PVT 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:EAM_WORKORDERREP_PVT, status:VALID,
PACKAGE BODY: APPS.EAM_PERMIT_UTILITY_PVT 12.2.2
APPS.EAM_PROCESS_PERMIT_PVT SQL Statements 12.2.2
PACKAGE BODY: APPS.EAM_PERMIT_VALIDATE_PVT 12.2.2
PACKAGE BODY: APPS.EAM_SAFETY_ASSOCIATION_PVT 12.2.2
APPS.EAM_WORKORDERREP_PVT SQL Statements 12.2.2
APPS.EAM_PERMIT_VALIDATE_PVT dependencies on EAM_WORK_PERMITS 12.2.2
APPS.EAM_SAFETY_REPORTS_PVT dependencies on EAM_WORK_PERMITS 12.2.2
APPS.EAM_WORKORDERREP_PVT dependencies on EAM_WORK_PERMITS 12.2.2
APPS.EAM_SAFETY_ASSOCIATION_PVT dependencies on EAM_WORK_PERMITS 12.2.2
APPS.EAM_PERMIT_UTILITY_PVT dependencies on EAM_WORK_PERMITS 12.2.2
PACKAGE BODY: APPS.EAM_WORKORDERREP_PVT 12.2.2
APPS.EAM_WORKORDERREP_PVT dependencies on EAM_PERMIT_STATUSES_VL 12.2.2
APPS.EAM_WORKORDERREP_PVT dependencies on EAM_SAFETY_ASSOCIATIONS 12.2.2
APPS.EAM_SAFETY_REPORTS_PVT dependencies on EAM_SAFETY_ASSOCIATIONS 12.2.2
APPS.EAM_PERMIT_UTILITY_PVT dependencies on EAM_PROCESS_WO_PVT 12.2.2
APPS.EAM_SAFETY_REPORTS_PVT dependencies on PER_PEOPLE_F 12.2.2
eTRM - EAM Tables and Views 12.2.2
description: Table for storing workflow item type and keys corresponding to a work order ,
APPS.EAM_SAFETY_REPORTS_PVT dependencies on EAM_PERMIT_STATUSES_VL 12.2.2
APPS.EAM_SAFETY_REPORTS_PVT dependencies on FND_USER 12.2.2
APPS.EAM_SAFETY_REPORTS_PVT dependencies on FND_DATE 12.2.2
APPS.EAM_SAFETY_REPORTS_PVT dependencies on EAM_WORK_CLEARANCES 12.2.2
APPS.EAM_SAFETY_REPORTS_PVT dependencies on MFG_LOOKUPS 12.2.2
APPS.EAM_WORKORDERREP_PVT dependencies on MFG_LOOKUPS 12.2.2
APPS.EAM_PERMIT_UTILITY_PVT dependencies on EAM_ERROR_MESSAGE_PVT 12.2.2
APPS.EAM_SAFETY_REPORTS_PVT dependencies on EAM_ISOLATIONS 12.2.2
APPS.EAM_SAFETY_REPORTS_PVT dependencies on EAM_WORK_ORDERS_V 12.2.2
APPS.EAM_WORKORDERREP_PVT dependencies on FND_MESSAGE 12.2.2