TSK_SRCH_ST_VW

(SQL View)
 Index Back

Task Search view

Task Search view

SELECT SETID , STATUS_CD , DESCR50_MIXED , DESCR , 'N' , INTERNAL_STATUS FROM PS_WM_STATUS_TSK

  • 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 CHECKED Character(1) VARCHAR2(1) NOT NULL Check box for Reason Code
    N=No
    Y=Yes

    Y/N Table Edit

    Default Value: N

    6 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