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

        abhijeet.khandagale Abhijeet Khandagale (Inactive) created issue -
        abhijeet.khandagale Abhijeet Khandagale (Inactive) made changes -
        Field Original Value New Value
        Dev Estimates 42
        abhijeet.khandagale Abhijeet Khandagale (Inactive) made changes -
        Status New Request [ 10029 ] Product Backlog [ 10100 ]
        abhijeet.khandagale Abhijeet Khandagale (Inactive) made changes -
        Item State Parent values: Development(10200)Level 1 values: Development Backlog(10205)
        Priority High [ 2 ] Medium [ 3 ]
        ramya.tantry Ramya Tantry (Inactive) made changes -
        Assignee Abhijeet Khandagale [ abhijeet.khandagale ] Ramya Tantry [ ramya.tantry ]
        ramya.tantry Ramya Tantry (Inactive) made changes -
        Status Product Backlog [ 10100 ] Pending for Approval [ 10002 ]
        ramya.tantry Ramya Tantry (Inactive) made changes -
        Status Pending for Approval [ 10002 ] Approved for Development [ 10003 ]
        ramya.tantry Ramya Tantry (Inactive) made changes -
        Status Approved for Development [ 10003 ] In Development [ 10007 ]
        ramya.tantry Ramya Tantry (Inactive) made changes -
        Item State Parent values: Development(10200)Level 1 values: Development Backlog(10205) Parent values: Development(10200)Level 1 values: Ready for Review(10208)
        Hide
        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
        ramya.tantry Ramya Tantry (Inactive) made changes -
        Item State Parent values: Development(10200)Level 1 values: Ready for Review(10208) Parent values: Development(10200)Level 1 values: Ready for Local Testing(10209)
        khandu.kshirsagar Khandu Kshirsagar (Inactive) made changes -
        Item State Parent values: Development(10200)Level 1 values: Ready for Local Testing(10209) Parent values: LB QA(10201)Level 1 values: LB Deployed(11600)
        Hide
        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
        ramya.tantry Ramya Tantry (Inactive) made changes -
        Assignee Ramya Tantry [ ramya.tantry ] Sachin Hingole [ sachin.hingole ]
        sachin.hingole Sachin Hingole (Inactive) made changes -
        Status In Development [ 10007 ] Local Testing [ 10200 ]
        sachin.hingole Sachin Hingole (Inactive) made changes -
        Item State Parent values: LB QA(10201)Level 1 values: LB Deployed(11600) Parent values: LB QA(10201)Level 1 values: In Testing(10210)
        khandu.kshirsagar Khandu Kshirsagar (Inactive) made changes -
        Item State Parent values: LB QA(10201)Level 1 values: In Testing(10210) Parent values: LB QA(10201)Level 1 values: LB Deployed(11600)
        sachin.hingole Sachin Hingole (Inactive) made changes -
        Item State Parent values: LB QA(10201)Level 1 values: LB Deployed(11600) Parent values: LB QA(10201)Level 1 values: In Testing(10210)
        sachin.hingole Sachin Hingole (Inactive) made changes -
        Item State Parent values: LB QA(10201)Level 1 values: In Testing(10210) Parent values: LB QA(10201)Level 1 values: Ready for Stage(10213)
        Hide
        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.
        sachin.hingole Sachin Hingole (Inactive) made changes -
        Issue Type Enhancement [ 4 ] Change Request [ 10002 ]
        Hide
        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.
        abhijeet.khandagale Abhijeet Khandagale (Inactive) made changes -
        Developer Abhijeet Khandagale [ abhijeet.khandagale ] Ramya Tantry [ ramya.tantry ]
        khandu.kshirsagar Khandu Kshirsagar (Inactive) made changes -
        Item State Parent values: LB QA(10201)Level 1 values: Ready for Stage(10213) Parent values: Stage QA(10202)Level 1 values: Stage Deployed(11602)
        sachin.hingole Sachin Hingole (Inactive) made changes -
        Item State Parent values: Stage QA(10202)Level 1 values: Stage Deployed(11602) Parent values: Stage QA(10202)Level 1 values: In Testing(10214)
        sachin.hingole Sachin Hingole (Inactive) made changes -
        Status Local Testing [ 10200 ] Pending for Stage Approval [ 10300 ]
        sachin.hingole Sachin Hingole (Inactive) made changes -
        Status Pending for Stage Approval [ 10300 ] Approved for Stage [ 10030 ]
        sachin.hingole Sachin Hingole (Inactive) made changes -
        Status Approved for Stage [ 10030 ] Stage Testing [ 10201 ]
        sachin.hingole Sachin Hingole (Inactive) made changes -
        Item State Parent values: Stage QA(10202)Level 1 values: In Testing(10214) Parent values: Stage QA(10202)Level 1 values: Ready for Production(10217)
        Hide
        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
        ashwin.wankhede Ashwin Wankhede (Inactive) made changes -
        Item State Parent values: Stage QA(10202)Level 1 values: Ready for Production(10217) Parent values: Production QA(10203)Level 1 values: Production Deployed(10221)
        sachin.hingole Sachin Hingole (Inactive) made changes -
        Status Stage Testing [ 10201 ] Pending for Production Approval [ 10301 ]
        sachin.hingole Sachin Hingole (Inactive) made changes -
        Status Pending for Production Approval [ 10301 ] Approved for production [ 10034 ]
        sachin.hingole Sachin Hingole (Inactive) made changes -
        Status Approved for production [ 10034 ] Production Testing [ 10202 ]
        sachin.hingole Sachin Hingole (Inactive) made changes -
        Item State Parent values: Production QA(10203)Level 1 values: Production Deployed(10221) Parent values: Production QA(10203)Level 1 values: In Testing(10218)
        sachin.hingole Sachin Hingole (Inactive) made changes -
        Item State Parent values: Production QA(10203)Level 1 values: In Testing(10218) Parent values: Production Complete(10222)Level 1 values: Closed(10223)
        Hide
        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
        sachin.hingole Sachin Hingole (Inactive) made changes -
        Resolution Fixed [ 1 ]
        Status Production Testing [ 10202 ] Production Complete [ 10028 ]
        sachin.hingole Sachin Hingole (Inactive) made changes -
        Status Production Complete [ 10028 ] Closed [ 6 ]
        Transition Time In Source Status Execution Times
        Abhijeet Khandagale (Inactive) made transition -
        New Request Product Backlog
        37m 7s 1
        Ramya Tantry (Inactive) made transition -
        Product Backlog Pending for Approval
        129d 20h 29m 1
        Ramya Tantry (Inactive) made transition -
        Pending for Approval Approved for Development
        3s 1
        Ramya Tantry (Inactive) made transition -
        Approved for Development In Development
        2s 1
        Sachin Hingole (Inactive) made transition -
        In Development In LB Testing
        17d 22h 56m 1
        Sachin Hingole (Inactive) made transition -
        In LB Testing Pending for Stage Approval
        24d 2h 6m 1
        Sachin Hingole (Inactive) made transition -
        Pending for Stage Approval Approved for Stage
        3s 1
        Sachin Hingole (Inactive) made transition -
        Approved for Stage Stage Testing
        2s 1
        Sachin Hingole (Inactive) made transition -
        Stage Testing Pending for Production Approval
        4d 1h 27m 1
        Sachin Hingole (Inactive) made transition -
        Pending for Production Approval Approved for production
        5s 1
        Sachin Hingole (Inactive) made transition -
        Approved for production In Production Testing
        3s 1
        Sachin Hingole (Inactive) made transition -
        In Production Testing Production Complete
        46s 1
        Sachin Hingole (Inactive) made transition -
        Production Complete Closed
        2s 1

          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: