WORKTERRAProject Type: software

WORKTERRA

Uploaded image for project: 'WORKTERRA'
  1. WORKTERRA
  2. WT-2632

ACA-2017 Credit pool performance enhancement

    Details

    • Type: Change Request
    • Status: Closed
    • Priority: Medium
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: ACA
    • Labels:
      None
    • Module:
      ACA - 2017
    • Reported by:
      Support
    • Item State:
      Production Complete - Closed
    • Issue Importance:
      Must Have

      Attachments

        Activity

        Ascending order - Click to sort in descending order
        Hide
        Permalink
        ramya.tantry Ramya Tantry (Inactive) added a comment -

        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

        Show
        ramya.tantry Ramya Tantry (Inactive) added a comment - 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
        Hide
        Permalink
        ramya.tantry Ramya Tantry (Inactive) added a comment -

        Sachin Hingole

        Please verify this enhancement

        Show
        ramya.tantry Ramya Tantry (Inactive) added a comment - Sachin Hingole Please verify this enhancement
        Hide
        Permalink
        sachin.hingole Sachin Hingole (Inactive) added a comment -

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

        Show
        sachin.hingole Sachin Hingole (Inactive) added a comment - As discussion with Ramya this is not an enhancement, so changing its type to change request.
        Hide
        Permalink
        sachin.hingole Sachin Hingole (Inactive) added a comment -

        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.

        Show
        sachin.hingole Sachin Hingole (Inactive) added a comment - 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.
        Hide
        Permalink
        sachin.hingole Sachin Hingole (Inactive) added a comment -

        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

        Show
        sachin.hingole Sachin Hingole (Inactive) added a comment - 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
        Hide
        Permalink
        sachin.hingole Sachin Hingole (Inactive) added a comment -

        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

        Show
        sachin.hingole Sachin Hingole (Inactive) added a comment - 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

          People

          Assignee:
          sachin.hingole Sachin Hingole (Inactive)
          Reporter:
          abhijeet.khandagale Abhijeet Khandagale (Inactive)
          Developer:
          Ramya Tantry (Inactive)
          QA:
          Sachin Hingole (Inactive)
          Votes:
          0 Vote for this issue
          Watchers:
          3 Start watching this issue

            Dates

            Created:
            Updated:
            Resolved: