GPES_CLND_H_VW(SQL View) |
Index Back |
|---|---|
Working Hours / MonthWorking Hours / Month based on the Schedule |
| SELECT A.SETID , A.SCHEDULE_ID , B.THE_DATE , C.THE_DATE , SUM(A.SCHED_HRS) , COUNT(*) FROM PS_SCH_CLND_DTL_VW A , PS_TL_DATES_TBL B , PS_TL_DATES_TBL C WHERE A.DUR BETWEEN B.THE_DATE AND C.THE_DATE AND SCHED_HRS<>0 GROUP BY A.SETID, A.SCHEDULE_ID, B.THE_DATE, C.THE_DATE |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID | Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 2 | SCHEDULE_ID | Character(16) | VARCHAR2(16) NOT NULL | The Schedule ID is a field used to uniquely identify a Schedule Definition or Schedule Calendar (built out Schedule Definition). |
| 3 | THE_DATE | Date(10) | DATE | Date |
| 4 | TO_DATE | Date(10) | DATE | Latest Date to be sent to PYR |
| 5 | SCHED_HRS | Signed Number(6,2) | DECIMAL(4,2) NOT NULL | Scheduled Work Hours |
| 6 | SHIFTNUM | Number(2,0) | SMALLINT NOT NULL | Shift Sequence Number |