pears.IQXPopulateAccountStatisticsPayroll

CREATE PROCEDURE "pears"."IQXPopulateAccountStatisticsPayroll"( 
  IN @IQXPayrollCompany CHAR(1),IN @YEAR SMALLINT,IN @Week SMALLINT ) 
BEGIN
  -- USAGE  job to select payco, yr and week then call   (should be 1 job calling both)
  --  populate temp table ("pears"."TEMPIQXAccountsStatistics") from payroll system or timesheets
  -- do lookups
  -- table indexes need reviewing when this written
  -- insert into IQXAccountStatistics
END
GO
 
COMMENT TO PRESERVE FORMAT ON PROCEDURE "pears"."IQXPopulateAccountStatisticsPayroll" IS 
{CREATE PROCEDURE IQXPopulateAccountStatisticsPayroll 
( IN @IQXPayrollCompany CHAR(1),IN @YEAR SMALLINT,IN @Week SMALLINT ) 
BEGIN
  -- USAGE  job to select payco, yr and week then call   (should be 1 job calling both)
  --  populate temp table ("pears"."TEMPIQXAccountsStatistics") from payroll system or timesheets
  -- do lookups
  -- table indexes need reviewing when this written
  -- insert into IQXAccountStatistics
END
}