WM_FTRK_MTRD_VW

(SQL View)
 Index Back

Failure Trackg Meter Read View

Failure Tracking Meter Reading View

SELECT A.BUSINESS_UNIT , A.WO_ID , A.WO_TASK_ID , A.BUSINESS_UNIT_AM , A.ASSET_ID , A.METER_TYPE , B.READING_DTTM , B.READING , B.CUM_READING , B.VARIATION , A.UNIT_OF_MEASURE , A.METER_OPTION , B.COMMENTS FROM PS_WM_FTRK_MTTP_VW A LEFT OUTER JOIN PS_AM_METER_READ B ON B.BUSINESS_UNIT = A.BUSINESS_UNIT_AM AND B.ASSET_ID = A.ASSET_ID AND B.METER_TYPE = A.METER_TYPE AND B.BUSINESS_UNIT_WO = A.BUSINESS_UNIT AND B.WO_ID = A.WO_ID AND B.WO_TASK_ID = A.WO_TASK_ID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Prompt Table: SP_BU_WM_NONVW

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 BUSINESS_UNIT_AM Character(5) VARCHAR2(5) NOT NULL AM Business Unit

Prompt Table: SP_BU_AM_NONVW

5 ASSET_ID Character(12) VARCHAR2(12) NOT NULL Asset Identification
6 METER_TYPE Character(30) VARCHAR2(30) NOT NULL Meter Type
7 READING_DTTM DateTime(26) TIMESTAMP As of Date/Time
8 READING Signed Number(15,6) DECIMAL(13,6) NOT NULL Reading
9 CUM_READING Signed Number(21,4) DECIMAL(19,4) NOT NULL Cumulative Reading
10 VARIATION Signed Number(21,4) DECIMAL(19,4) NOT NULL Increment/Decrement
11 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage

Prompt Table: UNITS_TBL

12 METER_OPTION Character(1) VARCHAR2(1) NOT NULL Meter Option
D=Decreasing
I=Increasing
R=Tolerance Range
13 COMMENTS Long Character CLOB Comment