WM_WO_TSK_NCLSD(SQL View) |
Index Back |
---|---|
Work Orders not Closed/Cancel |
SELECT BUSINESS_UNIT , WO_ID , WO_TASK_ID , SCHED_START_DT , SCHED_START_TIME , DESCR254 FROM PS_WM_WO_TSK WHERE INTERNAL_STATUS NOT IN('06', '07') |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | BUSINESS_UNIT_WO | Character(5) | VARCHAR2(5) NOT NULL |
Business Unit Work Order
Prompt Table: SP_BU_WM_NONVW |
2 | WO_ID | Character(10) | VARCHAR2(10) NOT NULL | Work Order Identification |
3 | WO_TASK_ID | Number(5,0) | INTEGER NOT NULL | Task Number |
4 | SCHED_START_DT | Date(10) | DATE | Scheduled Start Date |
5 | SCHED_START_TIME | Time(15) | TIMESTAMP | Schedule Start Time |
6 | DESCR254 | Character(254) | VARCHAR2(254) NOT NULL | Description of length 254 |