WM_STATUS_ADD(SQL View) |
Index Back |
|---|---|
Work Order Management Status |
| SELECT SETID , STATUS_CD , WO_STATUS_TYPE , DESCR50_MIXED , DESCR , INTERNAL_STATUS FROM PS_WM_STATUS |
| # | 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 | 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 |