WM_PMLP_SCHD_VW

(SQL View)
 Index Back

PM Loop Schedule View

PM Loop Schedule View used as search record. If loop is inactive, PM Schedule defined for the loop will not be listed. Prompt for asset subtype and manufacturer is just for convenience since these attributes on one set of loop can come from multiple sets.

SELECT A.BUSINESS_UNIT , A.PM_SCHD_ID , A.MAINT_LOOP_ID , B.DESCR50 , B.ASSET_TYPE , B.ASSET_SUBTYPE , B.MFG_ID , B.MODEL , A.MAINT_TYPE , A.DESCR100 FROM PS_WM_PM_SCHD A , PS_WM_PM_LOOP_VW B , PS_SET_CNTRL_REC C WHERE A.MAINT_LOOP_ID <> ' ' AND A.MAINT_LOOP_ID = B.MAINT_LOOP_ID AND C.SETCNTRLVALUE = A.BUSINESS_UNIT AND C.REC_GROUP_ID = 'WM_01' AND C.RECNAME = 'WM_PM_LOOP_HDR' AND C.SETID = B.SETID

  • Related Language Record: WM_PMLP_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 MAINT_LOOP_ID Character(15) VARCHAR2(15) NOT NULL Maintenance Loop ID

    Prompt Table: WM_PM_LOOP_VW
    Set Control Field: BUSINESS_UNIT

    4 DESCR50 Character(50) VARCHAR2(50) NOT NULL Description of length 50
    5 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
    6 ASSET_SUBTYPE Character(15) VARCHAR2(15) NOT NULL Asset Subtype

    Prompt Table: AM_SUBTYPE
    Set Control Field: BUSINESS_UNIT

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

    Prompt Table: MANUFACTURER
    Set Control Field: BUSINESS_UNIT

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

    Prompt Table: MFG_MODEL
    Set Control Field: BUSINESS_UNIT

    9 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

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