BUSINESS_UNITDefault Value: OPR_DEF_TBL_FS.BUSINESS_UNIT
WO_IDWO_TASK_IDPrompt Table: RS_CRAFT_DETAIL
2=Multiple Sources
A=Actual Hours
I=Mobile Inspection
M=My Tasks
T=Elapsed Time Entry
W=Work Order Completion
WM_WEEKLY_HRS(SQL View) |
Index Back |
|---|---|
Pivot Grid Hours view |
| SELECT DISTINCT A.BUSINESS_UNIT , A.WO_ID , A.WO_TASK_ID , A.CRAFT_ID , A.EMPLID , B.OPRID , %Sql(WM_WEEK_START_DT, A.ACTL_START_DT) , %DateAdd(A.ACTL_END_DT, 1 - %Sql(WM_WEEK_DAY, A.ACTL_END_DT)) , %DateAdd(A.ACTL_END_DT, 7 - %Sql(WM_WEEK_DAY, A.ACTL_END_DT)) , A.ACTL_SOURCE_CD , %Sql(WM_DAILY_HRS_SEL, A.TIME1, 1) , %Sql(WM_DAILY_HRS_SEL, A.TIME2, 2) , %Sql(WM_DAILY_HRS_SEL, A.TIME3, 3) , %Sql(WM_DAILY_HRS_SEL, A.TIME4, 4) , %Sql(WM_DAILY_HRS_SEL, A.TIME5, 5) , %Sql(WM_DAILY_HRS_SEL, A.TIME6, 6) , %Sql(WM_DAILY_HRS_SEL, A.TIME7, 7) , %Sql(WM_WEEKLY_HRS_SEL) FROM PS_WM_WO_SCHED_LBR A , PSOPRDEFN B WHERE A.ACTL_DURATION <> 0 AND A.ACTL_END_DT >= %DateAdd(%CURRENTDATEIN, -30) AND A.EMPLID = B.EMPLID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_FS.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 | CRAFT_ID | Character(16) | VARCHAR2(16) NOT NULL |
Craft Identification
Prompt Table: RS_CRAFT_DETAIL |
| 5 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 6 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 7 | WM_WEEK_START_DT | Character(20) | VARCHAR2(20) NOT NULL | Week Starting |
| 8 | SCHED_START_DT | Date(10) | DATE | Scheduled Start Date |
| 9 | SCHED_END_DT | Date(10) | DATE | Scheduled End Date |
| 10 | ACTL_SOURCE_CD | Character(2) | VARCHAR2(2) NOT NULL |
Actuals Source Code
2=Multiple Sources A=Actual Hours I=Mobile Inspection M=My Tasks T=Elapsed Time Entry W=Work Order Completion |
| 11 | SUN_HRS | Number(5,2) | DECIMAL(4,2) NOT NULL | Sunday |
| 12 | MON_HRS | Number(5,2) | DECIMAL(4,2) NOT NULL | Monday |
| 13 | TUES_HRS | Number(5,2) | DECIMAL(4,2) NOT NULL | Tuesday |
| 14 | WED_HRS | Number(5,2) | DECIMAL(4,2) NOT NULL | Wednesday |
| 15 | THURS_HRS | Number(5,2) | DECIMAL(4,2) NOT NULL | Thursday |
| 16 | FRI_HRS | Number(5,2) | DECIMAL(4,2) NOT NULL | Friday |
| 17 | SAT_HRS | Number(5,2) | DECIMAL(4,2) NOT NULL | Saturday |
| 18 | TOT_HRS | Signed Number(12,2) | DECIMAL(10,2) NOT NULL | Total Hours |