WM_PM_ARM_VW

(SQL View)
 Index Back

PM Maintainable Assets View

View on AM Asset Repository (ASSET) table -- selection includes "PM-maintainable" assets only; e.g., used as prompt table for PM Maint Loop Asset List selection

SELECT B.SETID , A.BUSINESS_UNIT AS BUSINESS_UNIT_AM , A.ASSET_ID , A.DESCR , A.DESCR_LONG , A.DESCRSHORT , A.TAG_NUMBER , A.SERIAL_ID , A.VIN , A.ASSET_TYPE , A.ASSET_SUBTYPE , A.MFG_ID , A.MANUFACTURER , A.MODEL , A.ASSET_RESOURCE_SW , A.SCHEDULABLE_SW , A.REPAIRABLE_FLG , A.EPL_TMPL_ID FROM PS_ASSET A , PS_SET_CNTRL_REC B WHERE A.REPAIRABLE_FLG IN ('Y','N',' ') AND B.SETCNTRLVALUE = A.BUSINESS_UNIT AND B.REC_GROUP_ID = 'AM_13' AND B.RECNAME = 'MAINT_TYPE_TBL'

  • Related Language Record: WM_PM_ARM_LVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

    Prompt Table: SP_SETID_NONVW

    2 BUSINESS_UNIT_AM Character(5) VARCHAR2(5) NOT NULL AM Business Unit

    Prompt Table: SP_BU_AM_NONVW

    3 ASSET_ID Character(12) VARCHAR2(12) NOT NULL Asset Identification
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    5 DESCR_LONG Character(254) VARCHAR2(254) NOT NULL Long Description
    6 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
    7 TAG_NUMBER Character(12) VARCHAR2(12) NOT NULL Tag Number
    8 SERIAL_ID Character(20) VARCHAR2(20) NOT NULL Serial ID
    9 VIN Character(18) VARCHAR2(18) NOT NULL VIN
    10 ASSET_TYPE Character(3) VARCHAR2(3) NOT NULL Asset Type
    010=IT Hardware
    020=IT Software
    040=Equipment
    050=Property
    060=Fleet
    070=Machinery
    080=Furniture
    090=Facility
    100=Intangible
    200=Asset Retirement Obligations
    999=Other
    11 ASSET_SUBTYPE Character(15) VARCHAR2(15) NOT NULL Asset Subtype

    Prompt Table: AM_SUBTYPE

    12 MFG_ID Character(50) VARCHAR2(50) NOT NULL Manufacturer ID

    Prompt Table: MANUFACTURER

    13 MANUFACTURER Character(60) VARCHAR2(60) NOT NULL Manufacturer Name

    Prompt Table: MANUF_FS_VW

    14 MODEL Character(30) VARCHAR2(30) NOT NULL Model
    15 ASSET_RESOURCE_SW Character(1) VARCHAR2(1) NOT NULL Field to indicate that an Asset is used as a tool or resource

    Y/N Table Edit

    Default Value: N

    16 SCHEDULABLE_SW Character(1) VARCHAR2(1) NOT NULL Schedulable Switch

    Y/N Table Edit

    Default Value: N

    17 REPAIRABLE_FLG Character(1) VARCHAR2(1) NOT NULL Repairable Flag

    Y/N Table Edit

    Default Value: N

    18 EPL_TMPL_ID Character(15) VARCHAR2(15) NOT NULL Parts List Template

    Prompt Table: EPL_LOOKUP_VW