WM_PM_VW

(SQL View)
 Index Back

SELECT DISTINCT A.BUSINESS_UNIT , A.PM_SCHD_ID , A.BUSINESS_UNIT_AM , A.ASSET_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 , ' ' , ' ' , 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 , 0 , 0 , 0 , 0 , ' ' , A.SHOP_ID , A.PM_LEAD_DAYS FROM PS_WM_PM A WHERE A.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 BUSINESS_UNIT_AM Character(5) VARCHAR2(5) NOT NULL AM Business Unit
4 ASSET_ID Character(12) VARCHAR2(12) NOT NULL Asset Identification
5 MAINT_TYPE Character(10) VARCHAR2(10) NOT NULL This field is used for maintenance type
6 NEXT_DUE_DT Date(10) DATE Preventive Maintenance due date
7 NEXT_RDG Signed Number(21,4) DECIMAL(19,4) NOT NULL Next preventive maintenance due reading
8 PERCENT_DUE Signed Number(16,0) DECIMAL(15) NOT NULL Preventive Maintenance percent due
9 SETID Character(5) VARCHAR2(5) NOT NULL SetID
10 MAINT_LOOP_ID Character(15) VARCHAR2(15) NOT NULL Maintenance Loop ID
11 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code
12 WO_ID Character(10) VARCHAR2(10) NOT NULL Work Order Identification
13 STATUS_CD Character(4) VARCHAR2(4) NOT NULL User defined Status Code
14 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
15 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
16 CBM_SOURCE Character(1) VARCHAR2(1) NOT NULL CBM Alert source
1=AM Reading Tolerance
2=MM Alert
3=Alert set manually
17 CBM_ALERT Character(1) VARCHAR2(1) NOT NULL Force WO. Disregard options.
1=On
2=Off
18 COMPLTED_DT Date(10) DATE Completed Date
19 DATE_OF_MONTH Character(2) VARCHAR2(2) NOT NULL Date of the Month
20 THRESHOLD_PCT Number(3,0) SMALLINT NOT NULL Confidence %
21 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
22 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
23 INTERVAL_VAL Number(9,0) DECIMAL(9) NOT NULL Interval
24 INTERVAL_START_FRM Character(1) VARCHAR2(1) NOT NULL From the last PM completion
N=No
Y=Yes

Default Value: N

25 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
26 WEEK_OF_MONTH Character(1) VARCHAR2(1) NOT NULL Week of the month
1=1st
2=2nd
3=3rd
4=4th
5=Last
27 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.
28 LAST_WO_ID Character(10) VARCHAR2(10) NOT NULL Last Preventive Maintenance Work Order ID
29 LAST_PJC_DT Date(10) DATE Preventive Maintenance due date
30 METER_TYPE Character(30) VARCHAR2(30) NOT NULL Meter Type
31 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
32 REQ_START_DT Date(10) DATE Required Start
33 PM_PROC_OPT Character(1) VARCHAR2(1) NOT NULL Process Options
1=Preventive
2=Projection
34 MTR_CALC_FLG Character(1) VARCHAR2(1) NOT NULL Calculate Meter
35 BKP_CALC_FLG Character(1) VARCHAR2(1) NOT NULL Calculate Blackout Period
36 START_DATE Date(10) DATE NOT NULL Start Date for Gen Standing PO
37 CBM_ALERT_ID Number(15,0) DECIMAL(15) NOT NULL CBM Alert ID
38 CBM_ALERT_DATETIME DateTime(26) TIMESTAMP CBM Alert Datetime
39 LAST_SCHD_DT Date(10) DATE Last Preventive maintenance schedule date
40 EST_COST_LBR Signed Number(28,3) DECIMAL(26,3) NOT NULL Estimated Labor Cost
41 EST_COST_MAT Signed Number(28,3) DECIMAL(26,3) NOT NULL Estimated Material Cost
42 EST_COST_TLS Signed Number(28,3) DECIMAL(26,3) NOT NULL Estimated Tools Cost
43 EST_COST_PO Signed Number(28,3) DECIMAL(26,3) NOT NULL Estimated Procurement costs for a work order
44 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

Default Value: BUS_UNIT_TBL_WM.BASE_CURRENCY

45 SHOP_ID Character(10) VARCHAR2(10) NOT NULL Shop Identification
46 PM_LEAD_DAYS Number(3,0) SMALLINT NOT NULL LEAD DAYS