WM_STATS_TSK_OL

(SQL View)
 Index Back

Work Order Task Status

Excludes Complete, Closed, and Canceled status. Used in PM Schedule setup.

SELECT A.SETID , A.STATUS_CD , LA.LANGUAGE_CD , LA.DESCR50_MIXED , LA.DESCR , A.STATUS_CD_HDR FROM PS_WM_STATUS A , PS_WM_STATUS_LG LA WHERE A.WO_STATUS_TYPE = '2' AND A.INTERNAL_STATUS NOT IN ('05', '06', '07') AND LA.SETID = A.SETID AND LA.STATUS_CD = A.STATUS_CD AND LA.WO_STATUS_TYPE = A.WO_STATUS_TYPE

  • Related Language Record for WM_STATUS_TSK_O

    • # 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 STATUS_CD Character(4) VARCHAR2(4) NOT NULL User defined Status Code
    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 DESCR50_MIXED Character(50) VARCHAR2(50) NOT NULL Description 50 characters, mixed case
    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    6 STATUS_CD_HDR Character(4) VARCHAR2(4) NOT NULL Header Status