AM_MET_READ_VW2

(SQL View)
 Index Back

Meter Readings


SELECT A.BUSINESS_UNIT , A.ASSET_ID , A.METER_TYPE , A.READING_DTTM , A.READING , A.VARIATION , A.ROLLOVER , A.REPLACED , A.CUM_READING , A.OUT_OF_SEQ , A.ACT_DLY_AVERAGE , A.COMMENTS FROM PS_AM_METER_READ A , PS_ASSET_METER B WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.ASSET_ID = B.ASSET_ID AND A.METER_TYPE = B.METER_TYPE AND B.STATUS = 'A' AND A.READING_DTTM = ( SELECT MAX(C.READING_DTTM) FROM PS_AM_METER_READ C WHERE A.BUSINESS_UNIT = C.BUSINESS_UNIT AND A.ASSET_ID = C.ASSET_ID AND A.METER_TYPE = C.METER_TYPE )

  • Parent record: ASSET_METER

    • # 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_AM_NONVW

    2 ASSET_ID Character(12) VARCHAR2(12) NOT NULL Asset Identification

    Prompt Table: ASSET

    3 METER_TYPE Character(30) VARCHAR2(30) NOT NULL Meter Type

    Prompt Table: ASSET_METER_VW

    4 READING_DTTM DateTime(26) TIMESTAMP NOT NULL As of Date/Time

    Default Value: %DATE

    5 READING Signed Number(15,6) DECIMAL(13,6) NOT NULL Reading
    6 VARIATION Signed Number(21,4) DECIMAL(19,4) NOT NULL Increment/Decrement
    7 ROLLOVER Character(1) VARCHAR2(1) NOT NULL Allow Rollover

    Y/N Table Edit

    8 REPLACED Character(1) VARCHAR2(1) NOT NULL Replaced

    Y/N Table Edit

    9 CUM_READING Signed Number(21,4) DECIMAL(19,4) NOT NULL Cumulative Reading
    10 OUT_OF_SEQ Character(1) VARCHAR2(1) NOT NULL Out of Sequence Reading

    Y/N Table Edit

    11 ACT_DLY_AVERAGE Signed Number(21,4) DECIMAL(19,4) NOT NULL Actual Daily Average
    12 COMMENTS Long Character CLOB Comment