BUSINESS_UNITWO_IDWO_TASK_IDRES_LN_NBR01=Open
02=Awaiting Schedule
03=Scheduled
04=Work In Progress
05=Complete
06=Closed
07=Canceled
08=On Hold
09=Work Order Created
IN_WO_DMDDTL_VW(SQL View) |
Index Back |
|---|---|
Work Order Tasks in Task Rec10/19/05 MEG CN#IN900: Added WO_INV_COMMIT_RULE. |
| SELECT DISTINCT a.business_unit , a.wo_id , a.wo_task_id , b.res_ln_nbr , %Substring(a.descr254,1,60) , a.business_unit_am , a.asset_id , a.location , a.sched_start_dt , a.sched_start_time , a.internal_status , b.wo_delivery_flag , b.wo_delivery_inst FROM PS_WM_WO_TSK a , ps_wm_wo_sched_mat b WHERE b.business_unit = a.business_unit AND b.wo_id = a.wo_id AND b.wo_task_id = a.wo_task_id |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 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 | RES_LN_NBR |
Number(5,0) | INTEGER NOT NULL | Resource Line No. |
| 5 | DESCR60 | Character(60) | VARCHAR2(60) NOT NULL | Description |
| 6 | BUSINESS_UNIT_AM | Character(5) | VARCHAR2(5) NOT NULL | AM Business Unit |
| 7 | ASSET_ID | Character(12) | VARCHAR2(12) NOT NULL | Asset Identification |
| 8 | LOCATION | Character(10) | VARCHAR2(10) NOT NULL | Location Code |
| 9 | SCHED_START_DT | Date(10) | DATE | Scheduled Start Date |
| 10 | SCHED_START_TIME | Time(15) | TIMESTAMP | Schedule Start Time |
| 11 | 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 |
| 12 | WO_DELIVERY_FLAG | Character(1) | VARCHAR2(1) NOT NULL | Flag used by Work Order parts list processing to signify special delivery instructions if needed |
| 13 | WO_DELIVERY_INST | Character(254) | VARCHAR2(254) NOT NULL | Delivery instructions for work order parts list |