TSK_SRCH_ST_VW2

(SQL View)
 Index Back

WO Task Status Search View #2

WO Task Search View -- this version of WO Task Status search view used to support display/selection of Material Readiness-applicable task statuses; i.e., this view explicitly removes any task status code which maps to internal statuses of 'Canceled', 'Closed', or 'Complete'

SELECT SETID , STATUS_CD , DESCR50_MIXED , DESCR , INTERNAL_STATUS FROM PS_WM_STATUS_TSK WHERE INTERNAL_STATUS NOT IN ('05','06','07')

  • Related Language Record: WM_STATUSTSK_LG

    • # 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 STATUS_CD Character(4) VARCHAR2(4) NOT NULL User defined Status Code
    3 DESCR50_MIXED Character(50) VARCHAR2(50) NOT NULL Description 50 characters, mixed case
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    5 INTERNAL_STATUS Character(2) VARCHAR2(2) NOT NULL Internal Status
    01=Open
    02=Awaiting Schedule
    03=Scheduled
    04=Work In Progress
    05=Complete
    06=Closed
    07=Canceled
    08=On Hold
    09=Work Order Created