Files Affected:

Database Objects/MasterCompanyDB/01_DDL/335_WT-2632_WTB_ACA_NewTable_ACAEmployeeCreditAmount.sql
Database Objects/MasterCompanyDB/02_UDFs/dbo.OES_UDF_ACA_GetCreditAmount.UserDefinedFunction.sql
Database Objects/MasterCompanyDB/04_Stored Procedures/dbo.OES_SP_ACA_GetCreditAmount.sql
Database Objects/MasterCompanyDB/04_Stored Procedures/dbo.OES_SP_Get_ACAIRS1095CData.StoredProcedure.sql

Sachin Hingole

Please verify this enhancement

As discussion with Ramya this is not an enhancement, so changing its type to change request.

Verified on LB, working fine.

Credit pool processing is working fine and codes are also shown correct.
Below is stat for 3500 employee.
Process Credit Pool - 33 Min
Download file - 10 Min

last year we were facing problems for credit pool processing of City of Irvine, CVHP so will take stat for these two companies too on stage.

Verified on stage, working fine.
Below are performance statistics.

Credit Pool Processing
Stage - City of Irvine HSPL
Employee count - 1036
Total Time to Show download pop up- 11:30 Min
Total Time to download files - 2 Min

Credit Pool Processing
Stage - CVHP for HSPL
Employee count - 3569
Total Time to Show download pop up- 21:04 Min
Total Time to download files - 8:42 Min

Verified on production, working fine.

Credit Pool Processing
Production - CVHP for HSPL
Employee count - 3717
Total Time to Show download pop up- 21.18 MIN
Total Time to download files - 15.30 MIN