WM_PM_MTR

(SQL Table)
Index Back

Preventive Maintenance Meter

Preventive Maintenance Meter temporary table

# 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 NEXT_DUE_DT Date(10) DATE Preventive Maintenance due date
6 METER_TYPE Character(30) VARCHAR2(30) NOT NULL Meter Type
7 MAINT_TYPE Character(10) VARCHAR2(10) NOT NULL This field is used for maintenance type
8 METER_OPTION Character(1) VARCHAR2(1) NOT NULL Meter Options
D=Decreasing
I=Increasing
R=Tolerance Range
9 INTERVAL_MTR Signed Number(21,4) DECIMAL(19,4) NOT NULL Meter Reading Interval
10 PROJ_MTR_USAGE Character(1) VARCHAR2(1) NOT NULL Project Meter Usage
1=None
2=Average from Asset
3=Sampling
11 SAMPLING_METHOD Character(4) VARCHAR2(4) NOT NULL Used in Preventive Maintenance to allow the system to project the meter usage based on historic data (the sample).
CYCL=Cycles
DAYS=Days
READ=Readings
12 SAMPLING_SIZE Number(5,0) INTEGER NOT NULL Used in Preventive Maintenance to allow the system to project the meter usage based on historic data (the sample).
13 PROJECTED_FROM Character(4) VARCHAR2(4) NOT NULL Used in Preventive Maintenance to calculate PM's start date based on projection of meter usage.
LAST=Last PM Completion Date
THRU=Current System Date
14 FIRST_RDG_DT DateTime(26) TIMESTAMP First date
15 LAST_RDG_DT DateTime(26) TIMESTAMP Last date
16 CURRENT_RDG Signed Number(21,4) DECIMAL(19,4) NOT NULL Current meter reading
17 PJC_DAYS Signed Number(10,0) DECIMAL(9) NOT NULL Projected days
18 FIRST_RDG Signed Number(21,4) DECIMAL(19,4) NOT NULL First reading
19 LAST_RDG Signed Number(21,4) DECIMAL(19,4) NOT NULL Last reading
20 PJC_BASIS_DT Date(10) DATE Projection Basis Date
21 NEXT_RDG Signed Number(21,4) DECIMAL(19,4) NOT NULL Next preventive maintenance due reading
22 PERCENT_DUE Signed Number(16,0) DECIMAL(15) NOT NULL Preventive Maintenance percent due
23 SETID_MTR Character(5) VARCHAR2(5) NOT NULL SetID
24 BUS_UNIT_AM Character(5) VARCHAR2(5) NOT NULL Business Unit
25 ASSET_ID_TO Character(12) VARCHAR2(12) NOT NULL Asset ID to
26 PJC_AVG_RDG Signed Number(21,4) DECIMAL(19,4) NOT NULL Estimated Daily Average
27 LAST_WO_RDG Signed Number(21,4) DECIMAL(19,4) NOT NULL Last reading
28 DUE_DT Date(10) DATE Specifies the date that a transaction is due. It is a generic field used in multiple PeopleSoft applications including Receivables Payables and Purchasing. For example it represents the date that payment is due for a voucher or the date that a scheduled shipment is due to be received.