| Value |
 Expression: "
IF 2=3
BEGIN
SELECT
CAST(0 AS INT) AS EmployeeAK
,CAST('aaa' AS VARCHAR(8)) AS PositionAK
,CAST('aaa' AS VARCHAR(20)) AS AssignmentAK
,CAST(0 AS INT) AS StartDateSK
,CAST(0 AS INT) AS EndDateSK
,CAST('aaa' AS VARCHAR(4)) AS TimeTypeAK
-- Calculate the average for the OverTime hours over the number of days in the Reporting Period
,CAST(0 AS NUMERIC(9,4)) AS HoursWorked
END
DECLARE @OverTimeType VARCHAR(4)
-- Find out what TimeType to use for OverTime Hours
SET @OverTimeType =
(
SELECT CAST(ISNULL(DESCRIPTION,'N/A') AS VARCHAR(4)) AS TimeTypeAK
FROM UTL_CODE_TABLE
WHERE TABLE_NAME = 'DW-PARMS'
AND CODE = 'HR-OVERTM'
AND STATUS = 'A'
)
SELECT
AttendWeek.PERSON_ID AS EmployeeAK
,POSITION_CODE AS PositionAK
,CAST(
REPLICATE('0', 9 - LEN(AttendWeek.PERSON_ID)) + CAST(AttendWeek.PERSON_ID AS VARCHAR(9))
+
CAST(AttendWeek.POSITION_CODE AS VARCHAR(8)) + REPLICATE(' ', 8 - LEN(AttendW
IF 2=3
BEGIN
SELECT
CAST(0 AS INT) AS EmployeeAK
,CAST('aaa' AS VARCHAR(8)) AS PositionAK
,CAST('aaa' AS VARCHAR(20)) AS AssignmentAK
,CAST(0 AS INT) AS StartDateSK
,CAST(0 AS INT) AS EndDateSK
,CAST('aaa' AS VARCHAR(4)) AS TimeTypeAK
-- Calculate the average for the OverTime hours over the number of days in the Reporting Period
,CAST(0 AS NUMERIC(9,4)) AS HoursWorked
END
DECLARE @OverTimeType VARCHAR(4)
-- Find out what TimeType to use for OverTime Hours
SET @OverTimeType =
(
SELECT CAST(ISNULL(DESCRIPTION,'N/A') AS VARCHAR(4)) AS TimeTypeAK
FROM UTL_CODE_TABLE
WHERE TABLE_NAME = 'DW-PARMS'
AND CODE = 'HR-OVERTM'
AND STATUS = 'A'
)
SELECT
AttendWeek.PERSON_ID AS EmployeeAK
,POSITION_CODE AS PositionAK
,CAST(
REPLICATE('0', 9 - LEN(AttendWeek.PERSON_ID)) + CAST(AttendWeek.PERSON_ID AS VARCHAR(9))
+
CAST(AttendWeek.POSITION_CODE AS VARCHAR(8)) + REPLICATE(' ', 8 - LEN(AttendWeek.POSITION_CODE))
+
REPLICATE('0', 3 - LEN(AttendWeek.ASSIGNMENT_INTERNAL_SEQ)) + CAST(AttendWeek.ASSIGNMENT_INTERNAL_SEQ AS VARCHAR(3))
AS VARCHAR(20)) AS AssignmentAK
,StartDate.SundayDate AS StartDateSK
,EndDate.SaturdayDate AS EndDateSK
,@OverTimeType AS TimeTypeAK
-- Calculate the average for the OverTime hours over the number of days in the Reporting Period
,CAST(ROUND(ISNULL(AttendWeek.TOTAL_OVERTIME_HOURS, 0) / (DATEDIFF(DD, CAST(AttendWeek.ATTENDANCE_START_DATE AS DATE), CAST(AttendWeek.ATTENDANCE_END_DATE AS DATE)) + 1),4) AS NUMERIC(9,4)) AS HoursWorked
FROM ATTENDANCE_AND_DAY_A AttendWeek
LEFT OUTER JOIN [EnterpriseDW].[dbo].[DimDate] Daily
ON
(
Daily.DateSK >= AttendWeek.ATTENDANCE_START_DATE
AND Daily.DateSK <= AttendWeek.ATTENDANCE_END_DATE
)
OUTER APPLY
(
SELECT MAX(DateSK) AS SundayDate
FROM [EnterpriseDW].[dbo].[DimDate] GetSun
WHERE GetSun.DayOfWeek = 1
AND GetSun.DateSK <= Daily.DateSK
) StartDate
OUTER APPLY
(
SELECT MIN(DateSK) AS SaturdayDate
FROM [EnterpriseDW].[dbo].[DimDate] GetSat
WHERE GetSat.DayOfWeek = 7
AND GetSat.DateSK >= Daily.DateSK
) EndDate
WHERE AttendWeek.ATTENDANCE_INTERNAL_ID IS NOT NULL
AND AttendWeek.TOTAL_OVERTIME_HOURS IS NOT NULL
AND AttendWeek.UNPROCESSED_IND = 0
|
| Expression |
"
IF 2=3
BEGIN
SELECT
CAST(0 AS INT) AS EmployeeAK
,CAST('aaa' AS VARCHAR(8)) AS PositionAK
,CAST('aaa' AS VARCHAR(20)) AS AssignmentAK
,CAST(0 AS INT) AS StartDateSK
,CAST(0 AS INT) AS EndDateSK
,CAST('aaa' AS VARCHAR(4)) AS TimeTypeAK
-- Calculate the average for the OverTime hours over the number of days in the Reporting Period
,CAST(0 AS NUMERIC(9,4)) AS HoursWorked
END
DECLARE @OverTimeType VARCHAR(4)
-- Find out what TimeType to use for OverTime Hours
SET @OverTimeType =
(
SELECT CAST(ISNULL(DESCRIPTION,'N/A') AS VARCHAR(4)) AS TimeTypeAK
FROM UTL_CODE_TABLE
WHERE TABLE_NAME = 'DW-PARMS'
AND CODE = 'HR-OVERTM'
AND STATUS = 'A'
)
SELECT
AttendWeek.PERSON_ID AS EmployeeAK
,POSITION_CODE AS PositionAK
,CAST(
REPLICATE('0', 9 - LEN(AttendWeek.PERSON_ID)) + CAST(AttendWeek.PERSON_ID AS VARCHAR(9))
+
CAST(AttendWeek.POSITION_CODE AS VARCHAR(8)) + REPLICATE(' ', 8 - LEN(AttendW |
Properties
