WM_STATUS

(SQL Table)
 Index Back

Work Order Management Status

  • Related Language Record: WM_STATUS_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
    Set Control Field: SETID

    2 STATUS_CD Character(4) VARCHAR2(4) NOT NULL User defined Status Code
    3 WO_STATUS_TYPE Character(1) VARCHAR2(1) NOT NULL Status Type
    1=Header
    2=Task
    3=Service Request

    Default Value: 1

    4 DESCR50_MIXED Character(50) VARCHAR2(50) NOT NULL Description 50 characters, mixed case
    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    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

    Default Value: 01

    7 INITIAL_STATUS_SW Character(1) VARCHAR2(1) NOT NULL Initial Status field switch

    Y/N Table Edit

    Default Value: N

    8 STATUS_CD_HDR Character(4) VARCHAR2(4) NOT NULL Header Status

    Prompt Table: WM_STATUS_HDR
    Set Control Field: STATUS_CD

    9 STATUS_USED_SW Character(1) VARCHAR2(1) NOT NULL Status Used

    Y/N Table Edit

    Default Value: N