pears.IQXPopulateAccountStatisticsPayroll [iqx]

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.

====== pears.IQXPopulateAccountStatisticsPayroll ======
<WRAP center round info>
Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace.
</WRAP>

===== Original SQL =====
<code sql>
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
}
</code>