EAM Tables (75)
EAM - Enterprise Asset Management — documented tables from Oracle EBS ETRM 12.2.2. Click any name for its documentation, columns and AI summary.
| Table | Columns | Description |
|---|---|---|
EAM_ASSET_EXPLOSION_TEMP |
4 | Asset Explosion Temp |
EAM_ASSET_FAILURES |
15 | Stores Information about failure events against the asset. |
EAM_ASSET_FAILURE_CODES |
12 | Stores detailed information captured for a failure event. |
EAM_ASSET_LOG |
40 | This table stores log information of operational status of assets which will be used to analyse the assets. |
EAM_ASSET_METERS |
30 | Asset Meter Association |
EAM_ASSET_MOVE_TEMP |
14 | |
EAM_ASSET_OPERATION_TXN |
29 | This table stores Asset Operational Transactions, Check-In and Check Out Operations on Assets. |
EAM_ASSET_RESULTS_GTT |
1 | |
EAM_ASSET_SAFETY_TYPES |
13 | Table to Store EAM Asset's Safety Type (Positional Asset or Lockout Device) |
EAM_ASSET_STATUS_HISTORY |
37 | Table for Asset Status History |
EAM_ASSET_TEXT |
7 | This table stores instance_id of all valid eAM asset defined in csi_item_instances. A text (intermedia) index will be created on the column |
EAM_CAUSE_CODES |
8 | Table to store the Cause Codes defined in the system |
EAM_CE_WORK_ORDER_LINES |
72 | This table contains consolidated work order lines for the estimate. The work order line can be a resource or material line depending upon th |
EAM_CONSTRUCTION_ESTIMATES |
28 | This table contains all the estimates header information. The header information include- Estimate name- Grouping option for the estimate- P |
EAM_CONSTRUCTION_UNITS |
27 | This table contains all the construction units defined in the system. The construction unit information include the following:- Construction |
EAM_CONSTRUCTION_UNIT_DETAILS |
12 | This contains all the activities and activity related details which are part of the construction unit. The information include - Activity |
EAM_CONTROL_EVENT |
8 | This table is used to store the information regarding the events which needs to be tracked for all Assets in each maintenance organization. |
EAM_DIFFICULTY_CODES |
11 | This table contains difficulty code mapping with resource multipliers. It also includes the effectivity period for defined resource multipli |
EAM_EMP_ASSIGNMENT_DETAILS_TBL |
16 | |
EAM_EMP_SEARCH_RESULT_TBL |
18 | |
EAM_ENABLE_WORKFLOW |
8 | This table stores the various maintenance object source values for which workflow is enabled/disabled |
EAM_ESTABLISHMENT_DETAILS |
52 | This table stores safety Establishment details. |
EAM_ESTIMATE_ASSOCIATIONS |
15 | This table contains all the association data for an estimate. The association data include the following |
EAM_FAILURE_CODES |
8 | Table to store the Failure Codes defined in the system |
EAM_FAILURE_COMBINATIONS |
11 | Stores the unique Failure/Cause/Resolution Code Combinations |
EAM_FAILURE_HISTORY_TEMP |
28 | Temporary table used by eAM to hold data about Failure History/Analysis |
EAM_FAILURE_SETS |
9 | All the failure set definitions are stored in this table. |
EAM_FAILURE_SET_ASSOCIATIONS |
9 | Stores the associations between an Item and an Failure Set. |
EAM_FORECASTED_WORK_ORDERS |
35 | Forecasted Work Orders |
EAM_FORECASTS |
57 | This table stores the criteria for forecasts and templates used in EAM maintenance budgeting and forecasting. It also stores the request id |
EAM_FORECAST_CEBBA |
26 | This table stores all of the costs associated with a forecasted work order for eAM maintenance budgeting and forecasting. This mirrors the |
EAM_FORECAST_WDJ |
123 | This table stores all of the work order information for a forecasted work order for eAM maintenance budgeting and forecasting. |
EAM_FORECAST_WEDI |
46 | This table stores the direct item information for forecasted work orders in eAM maintenance budgeting and forecasting. This mirrors the str |
EAM_FORECAST_WO |
77 | This table stores the operation level information for forecasted work orders for eAM maintenance budgeting and forecasting. |
EAM_FORECAST_WOR |
71 | This table stores the resource requirements associated with forecasted work orders for eAM maintenance budgeting and forecasting. |
EAM_FORECAST_WRO |
80 | This table stores the material requirements of forecasted work orders for eaM maintenance budgeting and forecasting. |
EAM_ISOLATIONS |
48 | This table stores safety Isolation Definition. |
EAM_JOB_COMPLETION_TXNS |
44 | Work Order Completion Transaction History |
EAM_LINEAR_LOCATIONS |
5 | This table is for linear location ids pushed into EAM from external sources. |
EAM_MATERIAL_IMPORT |
49 | Material Import Table |
EAM_METERS |
37 | Table for asset meter definition |
EAM_METER_READINGS |
34 | Table to store asset meter readings |
EAM_METER_READINGS_INTERFACE |
46 | Asset Meter Readings Interface table |
EAM_OPERATION_IMPORT |
40 | Work Order Operations Import |
EAM_OP_COMPLETION_TXNS |
48 | Work Order Operation Completion Transaction History |
EAM_ORG_MAINT_DEFAULTS |
21 | Maintenance Organization Specific Defaults For Several Type of Objects |
EAM_PM_ACTIVITIES |
12 | This table stores the PM Schedule activities and their associated attributes |
EAM_PM_LAST_SERVICE |
11 | PM Last Service Information |
EAM_PM_SCHEDULINGS |
57 | PM Scheduling Definition |
EAM_PM_SCHEDULING_RULES |
22 | Table to store PM scheduling rules |
EAM_PM_SET_NAMES |
27 | PM Set Names |
EAM_RESOLUTION_CODES |
8 | Table to store the Resolution Codes defined in the system |
EAM_RESOURCE_IMPORT |
49 | Work Order Resource |
EAM_RESOURCE_INSTANCE_IMPORT |
19 | Work Order Resource Instances |
EAM_RESOURCE_USAGE_IMPORT |
19 | Work Order Resource Usage |
EAM_SAFETY_ASSOCIATIONS |
45 | This table stores work order and safety association information |
EAM_SAFETY_HISTORY |
7 | Table for storing safety history |
EAM_SAFETY_USR_DEF_STATUSES_B |
11 | Table for storing safety user defined statuses |
EAM_SAFETY_USR_DEF_STATUSES_TL |
11 | This table contains translation information for Safety Entity Statuses. |
EAM_SAFETY_WORKFLOWS |
8 | Table for storing workflow item type and keys corresponding to safety objects |
EAM_SUPPRESSION_RELATIONS |
27 | Table to store PM suppression relations |
EAM_WOREP_LONG_ATTACH_TEMP |
1 | |
EAM_WORK_CLEARANCES |
51 | This table stores Safety Work Clearance definition. It would be attached to Establishment & Re-Establishment sequences, Work Orders and Work |
EAM_WORK_ORDER_BILLS |
39 | Work Order Billing Information. |
EAM_WORK_ORDER_DETAILS |
29 | eAM Work Order Details |
EAM_WORK_ORDER_IMPORT |
96 | Work Order Import |
EAM_WORK_ORDER_IMPORT_ERRORS |
9 | Work Order Import Errors |
EAM_WORK_ORDER_ROUTE |
8 | Route Asset History Table |
EAM_WORK_ORDER_TEXT |
8 | This table stores all the EAM workorders.This is used in Intermedia search for workorders |
EAM_WORK_PERMITS |
48 | This table stores safety work permit definition. Once permits are defined, they need to be associated to Work Orders. |
EAM_WO_RELATIONSHIPS |
13 | Eam Work Order Relationships |
EAM_WO_SERVICE_ASSOCIATION |
30 | Work Order Service Request Association |
EAM_WO_STATUSES_B |
10 | Table for storing user defined statuses |
EAM_WO_STATUSES_TL |
10 | This table contains translation information for Work Order Statuses. |
EAM_WO_WORKFLOWS |
8 | Table for storing workflow item type and keys corresponding to a work order |