WM_WO_ALERT_STS(SQL Table) |
Index Back |
|---|
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  WO_ALERT_TYPE |
Character(2) | VARCHAR2(2) NOT NULL |
Work Order Alert Type
01=Problem Notification 02=Maintenance Type Notification 03=Work Order Type Notification 04=Priority Notification 05=Actual Cost Notification 06=Labor Hours Notification 07=Warranty Notification Default Value: 02 |
| 2 | SETID |
Character(5) | VARCHAR2(5) NOT NULL |
SetID
Prompt Table: SP_SETID_NONVW |
| 3 | STATUS_CD |
Character(4) | VARCHAR2(4) NOT NULL |
User defined Status Code
Prompt Table: %EDITTABLE |