eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

Table: EAM_FAILURE_COMBINATIONS

Product:	EAM - Enterprise Asset Management
Description:	Stores the unique Failure/Cause/Resolution Code Combinations
Implementation/DBA Data:	EAM.EAM_FAILURE_COMBINATIONS

Primary Key: EAM_FAILURE_COMBINATIONS_PK

COMBINATION_ID

Primary Key: EAM_FAILURE_COMBINATIONS_UK

CAUSE_CODE
SET_ID
RESOLUTION_CODE
FAILURE_CODE

Foreign Keys

Table	Foreign Table	Foreign Key Column
EAM_FAILURE_COMBINATIONS	EAM_FAILURE_SETS	EAM_FAILURE_COMBINATIONS.SET_ID
EAM_FAILURE_COMBINATIONS	EAM_FAILURE_CODES	EAM_FAILURE_COMBINATIONS.FAILURE_CODE
EAM_FAILURE_COMBINATIONS	EAM_CAUSE_CODES	EAM_FAILURE_COMBINATIONS.CAUSE_CODE
EAM_FAILURE_COMBINATIONS	EAM_RESOLUTION_CODES	EAM_FAILURE_COMBINATIONS.RESOLUTION_CODE