WM_FANL_BSDT_VW

(SQL View)
Index Back

Fail Anlys Basis Date View

WM Failure Analysis Basis Date 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.ASSET_DESCR30 , A.ASSET_TYPE , A.ASSET_SUBTYPE , A.MFG_ID , A.MODEL , A.IN_SERVICE_DT , B.BUSINESS_UNIT_FROM , B.WO_ID_FROM , B.WO_TASK_ID_FROM , B.FAILURE_ID_FROM , B.PREV_FAILURE_DT , CASE WHEN B.PREV_FAILURE_DT IS NOT NULL AND B.PREV_FAILURE_DT > A.IN_SERVICE_DT THEN B.PREV_FAILURE_DT ELSE A.IN_SERVICE_DT END FROM PS_WM_FANL_ASST_VW A LEFT OUTER JOIN PS_WM_FANL_PVFL_VW B ON B.BUSINESS_UNIT = A.BUSINESS_UNIT AND B.WO_ID = A.WO_ID AND B.WO_TASK_ID = A.WO_TASK_ID AND B.FAILURE_ID = A.FAILURE_ID

# 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 ASSET_DESCR30 Character(30) VARCHAR2(30) NOT NULL Asset Description
9 ASSET_TYPE Character(3) VARCHAR2(3) NOT NULL Asset Type
010=IT Hardware
020=IT Software
040=Equipment
050=Property
060=Fleet
070=Machinery
080=Furniture
090=Facility
100=Intangible
200=Asset Retirement Obligations
999=Other
10 ASSET_SUBTYPE Character(15) VARCHAR2(15) NOT NULL Asset Subtype
11 MFG_ID Character(50) VARCHAR2(50) NOT NULL Manufacturer ID

Prompt Table: WM_MANUFACTURER

12 MODEL Character(30) VARCHAR2(30) NOT NULL Model

Prompt Table: WM_WO_MFGMOD_VW

13 IN_SERVICE_DT Date(10) DATE In Service Date
14 BUSINESS_UNIT_FROM Character(5) VARCHAR2(5) NOT NULL Business Unit From
15 WO_ID_FROM Character(10) VARCHAR2(10) NOT NULL Work Order ID From
16 WO_TASK_ID_FROM Number(5,0) INTEGER NOT NULL From Task ID
17 FAILURE_ID_FROM Character(10) VARCHAR2(10) NOT NULL From Failure ID
18 PREV_FAILURE_DT Date(10) DATE Previous Failure Date
19 FAIL_DAYS_BASIS_DT Date(10) DATE Days to Failure Basis Date