| 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(DESCRIPTION AS VARCHAR(4)) AS TimeTypeAK
FROM UTL_CODE_TABLE
WHERE TABLE_NAME = 'DW-PARMS'
AND CODE = 'HR-OVERTM'
AND STATUS = 'A'
)
-- Get the Normal and OverTime hours if we are reporting per Day from Attendance-Day
SELECT
AttendDay.PERSON_ID_TD AS EmployeeAK
,POSITION_CODE_TD AS PositionAK
,CAST(
REPLICATE('0', 9 - LEN(AttendDay.PERSON_ID_TD)) + CAST(AttendDay.PERSON_ID_TD AS VARCHAR(9))
+
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(DESCRIPTION AS VARCHAR(4)) AS TimeTypeAK
FROM UTL_CODE_TABLE
WHERE TABLE_NAME = 'DW-PARMS'
AND CODE = 'HR-OVERTM'
AND STATUS = 'A'
)
-- Get the Normal and OverTime hours if we are reporting per Day from Attendance-Day
SELECT
AttendDay.PERSON_ID_TD AS EmployeeAK
,POSITION_CODE_TD AS PositionAK
,CAST(
REPLICATE('0', 9 - LEN(AttendDay.PERSON_ID_TD)) + CAST(AttendDay.PERSON_ID_TD AS VARCHAR(9))
+
CAST(AttendDay.POSITION_CODE_TD AS VARCHAR(8))
+ REPLICATE(' ', 8 - LEN(AttendDay.POSITION_CODE_TD)) +
REPLICATE('0', 3 - LEN(AttendDay.ASSIGNMENT_INTERNAL_SEQ)) + CAST(AttendDay.ASSIGNMENT_INTERNAL_SEQ AS VARCHAR(3))
AS VARCHAR(20)) AS AssignmentAK
,StartDate.SundayDate AS StartDateSK
,EndDate.SaturdayDate AS EndDateSK
,CAST(
CASE
WHEN TimeType.OVERTIME_IND = 1 THEN @OverTimeType
ELSE 'NORM'
END AS VARCHAR(4)) AS TimeTypeAK
,CAST(ISNULL(AttendDay.HOURS_USED,0) AS NUMERIC(9,4)) AS HoursWorked
FROM ATTENDANCE_AND_DAY_A AttendDay
-- Find the Sunday before the Reporting Day
OUTER APPLY
(
SELECT MAX(DateSK) AS SundayDate
FROM[EnterpriseDW ].[dbo].[DimDate] GetSun
WHERE GetSun.DayOfWeek = 1
AND GetSun.DateSK <= AttendDay.ATTENDANCE_DAY_DATE
) StartDate
-- Find the Saturday after the Reporting Day
OUTER APPLY
(
SELECT MIN(DateSK) AS SaturdayDate
FROM [EnterpriseDW ].[dbo].[DimDate] GetSat
WHERE GetSat.DayOfWeek = 7
AND GetSat.DateSK >= AttendDay.ATTENDANCE_DAY_DATE
) EndDate
LEFT OUTER JOIN TIME_TYPE_A TimeType
ON
(
TimeType.TIME_TYPE_CODE = AttendDay.TIME_TYPE_CODE
)
WHERE AttendDay.ATTENDANCE_DAY_INTERNAL_ID IS NOT NULL
AND (AttendDay.TIME_TYPE_CODE = 'NORM' OR TimeType.OVERTIME_IND = 1)
AND AttendDay.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(DESCRIPTION AS VARCHAR(4)) AS TimeTypeAK
FROM UTL_CODE_TABLE
WHERE TABLE_NAME = 'DW-PARMS'
AND CODE = 'HR-OVERTM'
AND STATUS = 'A'
)
-- Get the Normal and OverTime hours if we are reporting per Day from Attendance-Day
SELECT
AttendDay.PERSON_ID_TD AS EmployeeAK
,POSITION_CODE_TD AS PositionAK
,CAST(
REPLICATE('0', 9 - LEN(AttendDay.PERSON_ID_TD)) + CAST(AttendDay.PERSON_ID_TD AS VARCHAR(9))
+
|
Properties
