WM_PM_MTRRDG_VW

(SQL View)
 Index Back

Meter Readings


SELECT A.BUSINESS_UNIT , A.ASSET_ID , A.METER_TYPE , A.CUM_READING , A.READING_DTTM , A.READING , A.VARIATION , A.ROLLOVER , A.REPLACED , 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'

  • Parent record: ASSET_METER

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

    Default Value: OPR_DEF_TBL_FS.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 CUM_READING Signed Number(21,4) DECIMAL(19,4) NOT NULL Cumulative Reading
    5 READING_DTTM DateTime(26) TIMESTAMP NOT NULL As of Date/Time

    Default Value: %DATE

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

    Y/N Table Edit

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

    Y/N Table Edit

    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