RS_ED_WKR_AVA_F(SQL View) |
Index Back |
|---|---|
ETL Resource Utilization |
| SELECT A.EMPLID , A.BEGIN_DT , SUM(%Coalesce(B.SCHEDULED_HRS, 0)) FROM (%Sql(RS_ED_WKR_AVA_SEL)) A LEFT OUTER JOIN (%Sql(RS_ED_WKR_SCHED_SEL)) B ON B.EMPLID = A.EMPLID AND A.BEGIN_DT > %DateAdd(%CurrentDateIn,-7) AND B.DATE_UNDER_RPT BETWEEN A.BEGIN_DT AND A.END_DT GROUP BY A.EMPLID, A.BEGIN_DT |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | DATE_WEEK_BEGIN | Date(10) | DATE | 01/30/98 SCC CN#SCHEW-XZ6L8: New field. |
| 3 | SCHEDULED_HRS | Signed Number(10,4) | DECIMAL(8,4) NOT NULL | Scheduled Hours |