BUSINESS_UNITWO_IDWO_TASK_IDRQMT_LN_NBRPrompt Table:
WM_DWNTME_RSN
Set Control Field: BUSINESS_UNIT_AM
WM_WO_DWNTMEVW(SQL View) |
Index Back |
|---|---|
Work Task Downtime EntryWork Task Downtime Entry view |
| SELECT BUSINESS_UNIT , WO_ID , WO_TASK_ID , RQMT_LN_NBR , REASON_DOWNTIME , PLAN_STARTDT , PLAN_ENDDT , PLAN_DUE_TIME , PLAN_START_TIME , EST_DOWN_HOURS , ACTL_START_DT , ACTL_START_TIME , ACTL_END_DT , ACTL_END_TIME , DOWN_HOURS FROM PS_WM_WO_DWNTME A WHERE EXISTS ( SELECT 'X' FROM PS_WM_WO_TSK TSK WHERE A.BUSINESS_UNIT = TSK.BUSINESS_UNIT AND A.WO_ID = TSK.WO_ID AND A.WO_TASK_ID = TSK.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 | RQMT_LN_NBR |
Number(5,0) | INTEGER NOT NULL | Requirement Line Number |
| 5 | REASON_DOWNTIME | Character(10) | VARCHAR2(10) NOT NULL |
Downtime Reason
Prompt Table:
WM_DWNTME_RSN
|
| 6 | PLAN_STARTDT | Date(10) | DATE | Planned Start Date |
| 7 | PLAN_ENDDT | Date(10) | DATE | Planned End Date |
| 8 | PLAN_DUE_TIME | Time(15) | TIMESTAMP | Planned Due Time |
| 9 | PLAN_START_TIME | Time(15) | TIMESTAMP | Planned Due Time |
| 10 | EST_DOWN_HOURS | Signed Number(10,2) | DECIMAL(8,2) NOT NULL | Estimated DownTime Hours |
| 11 | ACTL_START_DT | Date(10) | DATE | Actual Start Date |
| 12 | ACTL_START_TIME | Time(15) | TIMESTAMP | Actual Start Time |
| 13 | ACTL_END_DT | Date(10) | DATE | Actual End Date |
| 14 | ACTL_END_TIME | Time(15) | TIMESTAMP | Actual End Time |
| 15 | DOWN_HOURS | Signed Number(10,2) | DECIMAL(8,2) NOT NULL | Downtime Hours |