WM_PM_JTASST_VW

(SQL View)
 Index Back

PM Asset Schd Job Tmplt View

PM Asset Schedule Job Template View -- prompt view; used to search for active WO Job Template defns with effectivity less than or equal to current asset-type PM Sched effective record's effdt

SELECT B.SETID , A.BUSINESS_UNIT AS BUSINESS_UNIT_AM , A.ASSET_ID , B.WO_TEMPLATE_ID , C.EFFDT , B.DESCR50 , B.ASSET_TYPE , B.ASSET_SUBTYPE , B.MFG_ID , B.MODEL , C.RESOLUTION_CD , C.ITM_SETID , C.CRAFT_SETID , C.DESCR254 FROM PS_ASSET A , PS_WM_WO_TMPLT_HDR B , PS_WM_WO_JTMPL_EFF C WHERE B.WO_TEMPLATE_TYPE = '2' AND (B.ASSET_TYPE IN (A.ASSET_TYPE, ' ')) AND (B.ASSET_SUBTYPE IN (A.ASSET_SUBTYPE, ' ')) AND (B.MFG_ID IN (A.MFG_ID, ' ')) AND (B.MODEL IN (A.MODEL, ' ')) AND C.SETID = B.SETID AND C.WO_TEMPLATE_ID = B.WO_TEMPLATE_ID AND C.EFF_STATUS = 'A'

  • Related Language Record: WM_PM_JTASST_LV

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

    Default Value: OPR_DEF_TBL_FS.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 WO_TEMPLATE_ID Character(25) VARCHAR2(25) NOT NULL Work Order Task/Job Template ID
    5 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

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

    Prompt Table: AM_SUBTYPE

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

    Prompt Table: WM_MANUFACTURER

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

    Prompt Table: WM_WO_MFGMOD_VW

    11 RESOLUTION_CD Character(15) VARCHAR2(15) NOT NULL Resolution code

    Prompt Table: WM_RESOLUTN_VW

    12 ITM_SETID Character(5) VARCHAR2(5) NOT NULL Item SetID
    13 CRAFT_SETID Character(5) VARCHAR2(5) NOT NULL Foreign key SetID to RS_CRAFT_DETAIL table
    14 DESCR254 Character(254) VARCHAR2(254) NOT NULL Description of length 254