WM_MSP_STATUS

(SQL View)
Index Back

Work Order Header Status


SELECT SETID , STATUS_CD , DESCR50_MIXED , DESCR FROM PS_WM_STATUS_HDR

# 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