ASSET_METER

(SQL Table)
 Index Back

Asset Meter

  • Parent Record Of AM_METER_READ AM_MET_READ_VW AM_MET_READ_VW2 AM_MET_READ_VW3 WM_METER_READ WM_PM_MTRRDG_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL 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: AM_MET_TYPE_VW
    Set Control Field: BUSINESS_UNIT

    4 STATUS Character(1) VARCHAR2(1) NOT NULL Status Indicator
    A=Active
    I=Inactive

    Default Value: A

    5 COPY_TO_COMP Character(1) VARCHAR2(1) NOT NULL Copy to Components

    Y/N Table Edit

    Default Value: N

    6 EST_DLY_AVERAGE Signed Number(21,4) DECIMAL(19,4) NOT NULL Estimated Daily Average
    7 ACT_DLY_AVERAGE Signed Number(21,4) DECIMAL(19,4) NOT NULL Actual Daily Average
    8 ACT_AVG_OVRRD Character(1) VARCHAR2(1) NOT NULL Actual Average Overridden

    Default Value: N

    9 REQUIRED_FOR_WO Character(1) VARCHAR2(1) NOT NULL Required for Work Order

    Y/N Table Edit

    10 PRIMARY_FLG Character(1) VARCHAR2(1) NOT NULL 10/18/99 SCC CN#IC800: Add label PRIMARY
    N=No
    Y=Yes

    Y/N Table Edit

    Default Value: N

    11 SYNCID Number(10,0) DECIMAL(10) NOT NULL The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle.
    12 SYNCDTTM DateTime(26) TIMESTAMP Synchronization Last Update Date Time