Rics Foods Export

Parameters

• {mindate} - Start date for the export period
• {maxdate} - End date for the export period

Data Components

The report extracts and organizes the following data:

• Employee ID - Employee IDNUM
• Pay Designation - Pay designation number
• Workgroup - Workgroup code (from Workgroup 2)
• Rate - Pay rate formatted as 00.00
• Total Hours - Sum of hours rounded to 2 decimal places
• Dollars - Sum of dollars rounded to 2 decimal places
• Constants - Includes fixed values '1', '0YE', and '000000000.00'

Technical Implementation

The script uses:

• Filtering for specific workgroups (WG1=12 for Cannon, excluding WG2=11 for Store Director)
• Date range filtering using {mindate} and {maxdate}
• Aggregation to sum hours and dollars by employee and pay designation
• Formatting functions to ensure specific output formats for rates and amounts

T-SQL

SET NOCOUNT ON;
SET ANSI_WARNINGS OFF;

DECLARE @MIN DATE, @MAX DATE;

SET @MIN = {mindate};
SET @MAX = {maxdate};


SELECT
    e.idnum,
    pd.paydesnum,
    w2.code AS workgroup,
    '' AS space1,
    FORMAT(pd.rate, '00.00') as Rate,
    '' as space2,
    FORMAT(ROUND(SUM(pd.hours), 2), '00.00') AS TotalHours,
    '' AS space3,
    FORMAT(ROUND(SUM(pd.dollars),2), '00.00') as dollars,
    '' as space4,
    '1',
    '0YE',
    '' as space5,
    FORMAT(ROUND(SUM(pd.dollars),2), '00.00') as dollars2,
    '' as space6,
    '000000000.00'
FROM paydeshist pd
    INNER JOIN employees e
    ON pd.filekey = e.filekey
    INNER JOIN workgroup2 w2
    ON pd.wg2 = w2.WGNUM
WHERE pd.EVENTDATE BETWEEN @MIN AND @MAX
    AND e.wg1 IN (12) --Cannon
    AND e.wg2 NOT IN (11)
--Store Director
GROUP BY e.idnum, pd.paydesnum, w2.code, pd.rate
order by e.idnum, pd.paydesnum;

Download Alternative Formats

📥 Browser Export Format:

• Download Export File - Download this export for external processing

Content Inventory

• Doc File: content/docs/payroll_exports/rics_foods.mdx
• Browser Export: public/aod/browser_exports/payroll_exports/rics_foods.browser_export
• SQL Script: SQL/payroll_exports/rics_food.sql