WM_FANL_PVFL_VW

(SQL View)
 Index Back

Fail Anlys Previous Failure Vw

WM Failure Analysis Previous Failure View - level 2 view, used to calculate MTBF

SELECT A.BUSINESS_UNIT , A.WO_ID , A.WO_TASK_ID , A.FAILURE_ID , A.FAILURE_DT , A.BUSINESS_UNIT_AM , A.ASSET_ID , A.IN_SERVICE_DT , B.BUSINESS_UNIT AS BUSINESS_UNIT_FROM , B.WO_ID AS WO_ID_FROM , B.WO_TASK_ID AS WO_TASK_ID_FROM , B.FAILURE_ID AS FAILURE_ID_FROM , B.FAILURE_DT AS PREV_FAILURE_DT FROM PS_WM_FANL_ASST_VW A , PS_WM_FANL_ASST_VW B WHERE B.BUSINESS_UNIT_AM = A.BUSINESS_UNIT_AM AND B.ASSET_ID = A.ASSET_ID AND B.FAILURE_DT = ( SELECT MAX(I.FAILURE_DT) FROM PS_WM_FANL_ASST_VW I WHERE I.BUSINESS_UNIT = B.BUSINESS_UNIT AND I.WO_ID = B.WO_ID AND I.WO_TASK_ID = B.WO_TASK_ID AND I.FAILURE_ID = B.FAILURE_ID AND I.FAILURE_DT < A.FAILURE_DT AND I.FAILURE_DT > A.IN_SERVICE_DT)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 WO_ID Character(10) VARCHAR2(10) NOT NULL Work Order Identification
3 WO_TASK_ID Number(5,0) INTEGER NOT NULL Task Number
4 FAILURE_ID Character(10) VARCHAR2(10) NOT NULL Failure ID
5 FAILURE_DT Date(10) DATE Failure date
6 BUSINESS_UNIT_AM Character(5) VARCHAR2(5) NOT NULL AM Business Unit

Prompt Table: BUS_UNIT_AM_VW

7 ASSET_ID Character(12) VARCHAR2(12) NOT NULL Asset Identification

Prompt Table: WM_ASSET_VWA

8 IN_SERVICE_DT Date(10) DATE In Service Date
9 BUSINESS_UNIT_FROM Character(5) VARCHAR2(5) NOT NULL Business Unit From
10 WO_ID_FROM Character(10) VARCHAR2(10) NOT NULL Work Order ID From
11 WO_TASK_ID_FROM Number(5,0) INTEGER NOT NULL From Task ID
12 FAILURE_ID_FROM Character(10) VARCHAR2(10) NOT NULL From Failure ID
13 PREV_FAILURE_DT Date(10) DATE Previous Failure Date