SETIDSTATUS_CD01=Open
02=Asaiting Schedule
03=Scheduled
04=Work In Progress
05=Complete
06=Closed
07=Canceled
08=On Hold
09=Work Order Created
WM_STATUS_HDR(SQL Table) |
Index Back |
|---|---|
Work Order Management StatusThis record contains the status data used for work orders in FMS. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL | This field is used to store the value of SetID on various setup tables. |
| 2 | STATUS_CD |
Character(4) | VARCHAR2(4) NOT NULL | This field contains the status code for a work order in FMS. |
| 3 | DESCR50_MIXED | Character(50) | VARCHAR2(50) NOT NULL | Description 50 characters, mixed case |
| 4 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 5 | INTERNAL_STATUS | Character(2) | VARCHAR2(2) NOT NULL |
This field contains the internal status for a work order in FMS.
01=Open 02=Asaiting Schedule 03=Scheduled 04=Work In Progress 05=Complete 06=Closed 07=Canceled 08=On Hold 09=Work Order Created |