BUSINESS_UNITWO_IDWO_TASK_IDWM_WOE_TWP(SQL View) |
Index Back |
|---|---|
Track Work Progress |
| SELECT T.BUSINESS_UNIT , T.WO_ID , T.WO_TASK_ID , T.DESCR254 , T.STATUS_CD , W.PRIORITY_CD , T.SCHED_START_DT , T.SCHED_END_DT , T.ACTL_START_DT , T.ACTL_END_DT , T.SCHEDULER_CODE , W.SHOP_ID , T.BUSINESS_UNIT_PC , T.PROJECT_ID , T.ACTIVITY_ID , T.BUSINESS_UNIT_AM , T.ASSET_ID FROM PS_WM_WO_HDR W , PS_WM_WO_TSK T WHERE %Join(COMMON_KEYS, WM_WO_HDR W, WM_WO_TSK T) |
| # | 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 | DESCR254 | Character(254) | VARCHAR2(254) NOT NULL | Description of length 254 |
| 5 | STATUS_CD | Character(4) | VARCHAR2(4) NOT NULL | User defined Status Code |
| 6 | PRIORITY_CD | Character(3) | VARCHAR2(3) NOT NULL | Priority Code |
| 7 | SCHED_START_DT | Date(10) | DATE | Scheduled Start Date |
| 8 | SCHED_END_DT | Date(10) | DATE | Scheduled End Date |
| 9 | ACTL_END_DT | Date(10) | DATE | Actual End Date |
| 10 | ACTL_START_DT | Date(10) | DATE | Actual Start Date |
| 11 | SCHEDULER_CODE | Character(10) | VARCHAR2(10) NOT NULL | Scheduler Code |
| 12 | SHOP_ID | Character(10) | VARCHAR2(10) NOT NULL | Shop Identification |
| 13 | BUSINESS_UNIT_PC | Character(5) | VARCHAR2(5) NOT NULL | PC Business Unit |
| 14 | PROJECT_ID | Character(15) | VARCHAR2(15) NOT NULL | Project Id ChartField |
| 15 | ACTIVITY_ID | Character(15) | VARCHAR2(15) NOT NULL | Activity ID |
| 16 | BUSINESS_UNIT_AM | Character(5) | VARCHAR2(5) NOT NULL | AM Business Unit |
| 17 | ASSET_ID | Character(12) | VARCHAR2(12) NOT NULL | Asset Identification |