WM_PM_SCHD_VW

(SQL View)
 Index Back

PM Schedule View

PM Schedule View Used as search record

SELECT A.BUSINESS_UNIT , A.PM_SCHD_ID , A.BUSINESS_UNIT_AM , A.ASSET_ID , B.TAG_NUMBER , B.ASSET_TYPE , B.ASSET_SUBTYPE , B.MFG_ID , B.MODEL , A.MAINT_TYPE , A.DESCR100 FROM PS_WM_PM_SCHD A , PS_ASSET B WHERE A.BUSINESS_UNIT_AM <> ' ' AND A.ASSET_ID <> ' ' AND A.BUSINESS_UNIT_AM = B.BUSINESS_UNIT AND A.ASSET_ID = B.ASSET_ID

  • Related Language Record: WM_PM_SCHD_LV

    • # 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_WM.BUSINESS_UNIT

    Prompt Table: SP_BU_WM_NONVW

    2 PM_SCHD_ID Character(10) VARCHAR2(10) NOT NULL Preventive Maintenance Schedule ID

    Default Value: NEXT

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

    Default Value: OPR_DEF_TBL_WM.BUSINESS_UNIT_AM

    Prompt Table: SP_BU_AM_NONVW

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

    Prompt Table: WM_PMASSET_VW

    5 TAG_NUMBER Character(12) VARCHAR2(12) NOT NULL Tag Number

    Prompt Table: WM_ASSET_VW9T1

    6 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
    7 ASSET_SUBTYPE Character(15) VARCHAR2(15) NOT NULL Asset Subtype

    Prompt Table: AM_SUBTYPE
    Set Control Field: BUSINESS_UNIT_AM

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

    Prompt Table: MANUFACTURER
    Set Control Field: BUSINESS_UNIT_AM

    9 MODEL Character(30) VARCHAR2(30) NOT NULL Model

    Prompt Table: MFG_MODEL
    Set Control Field: BUSINESS_UNIT_AM

    10 MAINT_TYPE Character(10) VARCHAR2(10) NOT NULL This field is used for maintenance type

    Prompt Table: MAINT_TYPE_TBL
    Set Control Field: BUSINESS_UNIT

    11 DESCR100 Character(100) VARCHAR2(100) NOT NULL Length 100 Description