WM_NXTSTAT_DESC

(SQL View)
Index Back

Allowed Status Descriptions


SELECT B.SETID , B.STATUS_CD , A.INTERNAL_STATUS , B.NEXT_STATUS_CD , A.DESCR50_MIXED , A.DESCR FROM PS_WM_STATUS A , PS_WM_NEXT_STATUS B WHERE A.SETID = B.SETID AND A.STATUS_CD = B.NEXT_STATUS_CD AND A.WO_STATUS_TYPE = B.WO_STATUS_TYPE AND A.WO_STATUS_TYPE = '2'

  • Related Language Record: WM_NXTSTATDS_LG
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
    2 STATUS_CD Character(4) VARCHAR2(4) NOT NULL User defined Status Code
    3 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
    4 NEXT_STATUS_CD Character(4) VARCHAR2(4) NOT NULL Allowed Status Transition
    5 DESCR50_MIXED Character(50) VARCHAR2(50) NOT NULL Description 50 characters, mixed case
    6 DESCR Character(30) VARCHAR2(30) NOT NULL Description