WM_PM_WO2_VW

(SQL View)
 Index Back

SELECT DISTINCT A.BUSINESS_UNIT , A.PM_SCHD_ID , A.MAINT_TYPE , A.NEXT_DUE_DT , A.NEXT_RDG , A.PERCENT_DUE , A.SETID , A.MAINT_LOOP_ID , A.LOCATION , A.WO_ID , B.STATUS_CD , B.INTERNAL_STATUS , A.PROCESS_INSTANCE , A.CBM_SOURCE , A.CBM_ALERT , A.COMPLTED_DT , A.DATE_OF_MONTH , A.THRESHOLD_PCT , A.PM_SCHD_OPT , A.PM_TM_SCHD_TYPE , A.INTERVAL_VAL , A.INTERVAL_START_FRM , A.DAY_OFWEEK , A.WEEK_OF_MONTH , A.HOLIDAY_LIST_ID , A.LAST_WO_ID , A.LAST_PJC_DT , A.METER_TYPE , A.PM_CALC_TYPE , A.REQ_START_DT , A.PM_PROC_OPT , A.MTR_CALC_FLG , A.BKP_CALC_FLG , A.START_DATE , A.CBM_ALERT_ID , A.CBM_ALERT_DATETIME , A.LAST_SCHD_DT , B.EST_COST_LBR , B.EST_COST_MAT , B.EST_COST_TLS , B.EST_COST_PO , B.CURRENCY_CD , A.WM_PM_LINK_FLAG , A.PM_LEAD_DAYS FROM PS_WM_PM A , PS_WM_WO_HDR B WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.WO_ID = B.WO_ID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 PM_SCHD_ID Character(10) VARCHAR2(10) NOT NULL Preventive Maintenance Schedule ID
3 MAINT_TYPE Character(10) VARCHAR2(10) NOT NULL This field is used for maintenance type
4 NEXT_DUE_DT Date(10) DATE Preventive Maintenance due date
5 NEXT_RDG Signed Number(21,4) DECIMAL(19,4) NOT NULL Next preventive maintenance due reading
6 PERCENT_DUE Signed Number(16,0) DECIMAL(15) NOT NULL Preventive Maintenance percent due
7 SETID Character(5) VARCHAR2(5) NOT NULL SetID
8 MAINT_LOOP_ID Character(15) VARCHAR2(15) NOT NULL Maintenance Loop ID
9 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code
10 WO_ID Character(10) VARCHAR2(10) NOT NULL Work Order Identification
11 STATUS_CD Character(4) VARCHAR2(4) NOT NULL User defined Status Code

Prompt Table: WM_STATUS_HDR

12 INTERNAL_STATUS Character(2) VARCHAR2(2) NOT NULL Internal Status
01=Open
02=Awaiting Schedule
03=Scheduled
04=Work In Progress
05=Complete
06=Closed
07=Canceled
08=On Hold
09=Work Order Created
13 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
14 CBM_SOURCE Character(1) VARCHAR2(1) NOT NULL CBM Alert source
1=AM Reading Tolerance
2=MM Alert
3=Alert set manually
15 CBM_ALERT Character(1) VARCHAR2(1) NOT NULL Force WO. Disregard options.
1=On
2=Off
16 COMPLTED_DT Date(10) DATE Completed Date
17 DATE_OF_MONTH Character(2) VARCHAR2(2) NOT NULL Date of the Month
18 THRESHOLD_PCT Number(3,0) SMALLINT NOT NULL Confidence %
19 PM_SCHD_OPT Character(1) VARCHAR2(1) NOT NULL Scheduling Option
1=One Cycle
2=Multiple Cycles Multiple WO
3=Multiple Cycles One WO
4=Non-recurring
20 PM_TM_SCHD_TYPE Character(1) VARCHAR2(1) NOT NULL Schedule Type
1=None
2=Specific Date
3=Daily
4=Weekly by Day
5=Monthly by Day
6=Monthly by Date
7=On Demand
21 INTERVAL_VAL Number(9,0) DECIMAL(9) NOT NULL Interval
22 INTERVAL_START_FRM Character(1) VARCHAR2(1) NOT NULL From the last PM completion
N=No
Y=Yes

Default Value: N

23 DAY_OFWEEK Character(1) VARCHAR2(1) NOT NULL Day
0=0: Sunday
1=1: Monday
2=2: Tuesday
3=3 :Wednesday
4=4: Thursday
5=5: Friday
6=6: Saturday
24 WEEK_OF_MONTH Character(1) VARCHAR2(1) NOT NULL Week of the month
1=1st
2=2nd
3=3rd
4=4th
5=Last
25 HOLIDAY_LIST_ID Character(10) VARCHAR2(10) NOT NULL This is used to identify what holiday calendar to use. This is the access field for all financials groups.
26 LAST_WO_ID Character(10) VARCHAR2(10) NOT NULL Last Preventive Maintenance Work Order ID
27 LAST_PJC_DT Date(10) DATE Preventive Maintenance due date
28 METER_TYPE Character(30) VARCHAR2(30) NOT NULL Meter Type
29 PM_CALC_TYPE Character(3) VARCHAR2(3) NOT NULL Preventive Maintenance Calculation type
100=Sampling days
101=Sampling Readings
102=Cycle
103=Average from Asset
2=Specific Date
200=Meter Reading
3=Day Interval
300=CBM Alert
4=Week interval
5=Month Interval by day
6=Month interval by date
30 REQ_START_DT Date(10) DATE Required Start
31 PM_PROC_OPT Character(1) VARCHAR2(1) NOT NULL Process Options
1=Preventive
2=Projection
32 MTR_CALC_FLG Character(1) VARCHAR2(1) NOT NULL Calculate Meter
33 BKP_CALC_FLG Character(1) VARCHAR2(1) NOT NULL Calculate Blackout Period
34 START_DATE Date(10) DATE NOT NULL Start Date for Gen Standing PO
35 CBM_ALERT_ID Number(15,0) DECIMAL(15) NOT NULL CBM Alert ID
36 CBM_ALERT_DATETIME DateTime(26) TIMESTAMP CBM Alert Datetime
37 LAST_SCHD_DT Date(10) DATE Last Preventive maintenance schedule date
38 EST_COST_LBR Signed Number(28,3) DECIMAL(26,3) NOT NULL Estimated Labor Cost
39 EST_COST_MAT Signed Number(28,3) DECIMAL(26,3) NOT NULL Estimated Material Cost
40 EST_COST_TLS Signed Number(28,3) DECIMAL(26,3) NOT NULL Estimated Tools Cost
41 EST_COST_PO Signed Number(28,3) DECIMAL(26,3) NOT NULL Estimated Procurement costs for a work order
42 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

Default Value: BUS_UNIT_TBL_WM.BASE_CURRENCY

43 WM_PM_LINK_FLAG Character(1) VARCHAR2(1) NOT NULL Linked
44 PM_LEAD_DAYS Number(3,0) SMALLINT NOT NULL LEAD DAYS