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

ACA 2017: Percentage of salary calculation should depend on benefit salary flag on rates.

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Medium
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: ACA
    • Labels:
      None
    • Environment:
      Production
    • Bug Severity:
      Low
    • Module:
      ACA - 2017
    • Reported by:
      Client
    • Item State:
      Production Complete - Closed

      Description

      Percentage of salary calculation should depend on benefit salary flag on rates.
      If the benefit salary flag on rates is set to yes,then EE cost calculation should be calculated as per Percentage of benefit salary else it should consider gross annual salary.

      NOTE: Rate of pay not considered as there is no concept of rate of pay in BenAdmin.

      CC: Sachin Hingole,Smita Pawar,Mahendra Mungase,Nandkumar Prabhakar Karlekar

        Attachments

          Issue Links

            Activity

            ramya.tantry Ramya Tantry (Inactive) created issue -
            kumar.chhajed Kumar Chhajed (Inactive) logged work - 11/Jan/17 07:03 AM
            • Time Spent:
              0.75h
               

              Run 1095-C Reports and Compare with previous run

            kumar.chhajed Kumar Chhajed (Inactive) made changes -
            Field Original Value New Value
            Remaining Estimate 16h [ 57600 ] 15.25h [ 54900 ]
            Time Spent 0.75h [ 2700 ]
            Worklog Id 18383 [ 18383 ]
            ramya.tantry Ramya Tantry (Inactive) logged work - 11/Jan/17 12:23 PM - edited
            • Time Spent:
              2.5h
               

              coding
              testing

            ramya.tantry Ramya Tantry (Inactive) made changes -
            Remaining Estimate 15.25h [ 54900 ] 11.75h [ 42300 ]
            Time Spent 0.75h [ 2700 ] 4.25h [ 15300 ]
            Worklog Id 18436 [ 18436 ]
            ramya.tantry Ramya Tantry (Inactive) made changes -
            Remaining Estimate 11.75h [ 42300 ] 12.75h [ 45900 ]
            Time Spent 4.25h [ 15300 ] 3.25h [ 11700 ]
            Worklog Id 18436 [ 18436 ]
            ramya.tantry Ramya Tantry (Inactive) made changes -
            Item State Parent values: Development(10200)Level 1 values: In Analysis(10204) Parent values: Development(10200)Level 1 values: Ready for Review(10208)
            Hide
            ramya.tantry Ramya Tantry (Inactive) added a comment -

            Files Affected:

            dbo.OES_SP_Get_ACAEmployeeW2WagesInfoMonthly.StoredProcedure.sql
            dbo.OES_SP_Get_ACAIRS1095CData.StoredProcedure.sql

            Show
            ramya.tantry Ramya Tantry (Inactive) added a comment - Files Affected: dbo.OES_SP_Get_ACAEmployeeW2WagesInfoMonthly.StoredProcedure.sql 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)
            ramya.tantry Ramya Tantry (Inactive) made changes -
            Status Open [ 1 ] In Development [ 10007 ]
            ramya.tantry Ramya Tantry (Inactive) made changes -
            Code Reviewed By Nandkumar Karlekar [ 11904 ]
            ramya.tantry Ramya Tantry (Inactive) made changes -
            Remaining Estimate 12.75h [ 45900 ] 12.25h [ 44100 ]
            Time Spent 3.25h [ 11700 ] 3.75h [ 13500 ]
            Worklog Id 18579 [ 18579 ]
            Hide
            ramya.tantry Ramya Tantry (Inactive) added a comment -

            Concern:Percentage of salary calculation not depending on benefit salary flag on rates.
            Cause: As per implementation,salary that has been selected on ACA parameters is considered for calculation of rates. Benefit salary flag on rates is not considered.
            Correction: We have changed the implementation to consider benefit salary flag.
            If the benefit salary flag on rates is set to yes,then EE cost calculation should be calculated as per Percentage of benefit salary else it should consider gross annual salary.

            Note:Rate of pay not considered as there is no concept of rate of pay in BenAdmin.

            Show
            ramya.tantry Ramya Tantry (Inactive) added a comment - Concern :Percentage of salary calculation not depending on benefit salary flag on rates. Cause : As per implementation,salary that has been selected on ACA parameters is considered for calculation of rates. Benefit salary flag on rates is not considered. Correction : We have changed the implementation to consider benefit salary flag. If the benefit salary flag on rates is set to yes,then EE cost calculation should be calculated as per Percentage of benefit salary else it should consider gross annual salary. Note :Rate of pay not considered as there is no concept of rate of pay in BenAdmin.
            ashwin.wankhede Ashwin Wankhede (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)
            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 ]
            ramya.tantry Ramya Tantry (Inactive) logged work - 12/Jan/17 04:51 PM
            • Time Spent:
              0.5h
               

              LB checkin

            sachin.hingole Sachin Hingole (Inactive) made changes -
            Assignee Sachin Hingole [ sachin.hingole ] Smita Pawar [ smita.pawar ]
            smita.pawar Smita Pawar (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)
            ramya.tantry Ramya Tantry (Inactive) made changes -
            Link This issue causes WT-7768 [ WT-7768 ]
            smita.pawar Smita Pawar (Inactive) logged work - 16/Jan/17 11:39 AM - edited
            • Time Spent:
              5h
               

              Test cases and test scenarios writing

            smita.pawar Smita Pawar (Inactive) logged work - 17/Jan/17 11:26 AM - edited
            • Time Spent:
              1h
               

              LB Test cases and analysis

            smita.pawar Smita Pawar (Inactive) made changes -
            Remaining Estimate 12.25h [ 44100 ] 11.25h [ 40500 ]
            Time Spent 3.75h [ 13500 ] 4.75h [ 17100 ]
            Worklog Id 19576 [ 19576 ]
            smita.pawar Smita Pawar (Inactive) made changes -
            Remaining Estimate 11.25h [ 40500 ] 6.25h [ 22500 ]
            Time Spent 4.75h [ 17100 ] 9.75h [ 35100 ]
            Worklog Id 19739 [ 19739 ]
            smita.pawar Smita Pawar (Inactive) made changes -
            Remaining Estimate 6.25h [ 22500 ] 11.25h [ 40500 ]
            Time Spent 9.75h [ 35100 ] 4.75h [ 17100 ]
            Worklog Id 19739 [ 19739 ]
            Worklog Time Spent 5h [ 18000 ]
            smita.pawar Smita Pawar (Inactive) made changes -
            Remaining Estimate 11.25h [ 40500 ] 6.25h [ 22500 ]
            Time Spent 4.75h [ 17100 ] 9.75h [ 35100 ]
            Worklog Id 19740 [ 19740 ]
            smita.pawar Smita Pawar (Inactive) made changes -
            Worklog Id 19740 [ 19740 ]
            smita.pawar Smita Pawar (Inactive) made changes -
            Worklog Id 19576 [ 19576 ]
            smita.pawar Smita Pawar (Inactive) made changes -
            Worklog Id 19576 [ 19576 ]
            smita.pawar Smita Pawar (Inactive) logged work - 18/Jan/17 01:50 PM - edited
            • Time Spent:
              1.5h
               
              <No comment>
            smita.pawar Smita Pawar (Inactive) made changes -
            Remaining Estimate 6.25h [ 22500 ] 4.75h [ 17100 ]
            Time Spent 9.75h [ 35100 ] 11.25h [ 40500 ]
            Worklog Id 20032 [ 20032 ]
            smita.pawar Smita Pawar (Inactive) made changes -
            Worklog Id 20032 [ 20032 ]
            smita.pawar Smita Pawar (Inactive) logged work - 20/Jan/17 01:50 PM
            • Time Spent:
              1h
               

              Discussion with DEV & LB testing

            smita.pawar Smita Pawar (Inactive) made changes -
            Remaining Estimate 4.75h [ 17100 ] 3.75h [ 13500 ]
            Time Spent 11.25h [ 40500 ] 12.25h [ 44100 ]
            Worklog Id 20429 [ 20429 ]
            ramya.tantry Ramya Tantry (Inactive) logged work - 23/Jan/17 12:14 PM
            • Time Spent:
              2h
               

              internal discussion with QA
              Testing

            ramya.tantry Ramya Tantry (Inactive) made changes -
            Remaining Estimate 3.75h [ 13500 ] 1.75h [ 6300 ]
            Time Spent 12.25h [ 44100 ] 14.25h [ 51300 ]
            Worklog Id 20563 [ 20563 ]
            smita.pawar Smita Pawar (Inactive) made changes -
            Attachment screenshot-1.png [ 37981 ]
            Hide
            smita.pawar Smita Pawar (Inactive) added a comment -

            We have verified above mentioned issue on LB[ACA Automation Company].
            Scenarios tested are as follows.

            1.Checked 1095-C report when consider benefit salary is set to YES
            2.Checked 1095-C reports when consider benefit salary is set to NO
            3.Checked 1095-C report when multiple rates are mapped to plan

            PFA for additional information.

            Show
            smita.pawar Smita Pawar (Inactive) added a comment - We have verified above mentioned issue on LB [ACA Automation Company] . Scenarios tested are as follows. 1.Checked 1095-C report when consider benefit salary is set to YES 2.Checked 1095-C reports when consider benefit salary is set to NO 3.Checked 1095-C report when multiple rates are mapped to plan PFA for additional information.
            smita.pawar Smita Pawar (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)
            smita.pawar Smita Pawar (Inactive) logged work - 23/Jan/17 01:12 PM
            • Time Spent:
              4h
               

              Lb tetsing

            smita.pawar Smita Pawar (Inactive) made changes -
            Remaining Estimate 1.75h [ 6300 ] 0h [ 0 ]
            Time Spent 14.25h [ 51300 ] 18.25h [ 65700 ]
            Worklog Id 20614 [ 20614 ]
            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)
            rakeshr Rakesh Roy (Inactive) made changes -
            Status Local Testing [ 10200 ] Stage Testing [ 10201 ]
            rakeshr Rakesh Roy (Inactive) made changes -
            Item State Parent values: Stage QA(10202)Level 1 values: Stage Deployed(11602) Parent values: Stage QA(10202)Level 1 values: Ready for Production(10217)
            smita.pawar Smita Pawar (Inactive) logged work - 27/Jan/17 11:13 AM
            • Time Spent:
              2h
               

              lb testing

            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)
            smita.pawar Smita Pawar (Inactive) made changes -
            Time Spent 18.25h [ 65700 ] 20.25h [ 72900 ]
            Worklog Id 21878 [ 21878 ]
            ramya.tantry Ramya Tantry (Inactive) logged work - 31/Jan/17 03:56 PM
            • Time Spent:
              0.5h
               

              Production checkins

            rakeshr Rakesh Roy (Inactive) made changes -
            Status Stage Testing [ 10201 ] Production Testing [ 10202 ]
            rakeshr Rakesh Roy (Inactive) made changes -
            Resolution Fixed [ 1 ]
            Status Production Testing [ 10202 ] Production Complete [ 10028 ]
            rakeshr Rakesh Roy (Inactive) made changes -
            Item State Parent values: Production QA(10203)Level 1 values: Production Deployed(10221) Parent values: Production Complete(10222)Level 1 values: Closed(10223)
            ramya.tantry Ramya Tantry (Inactive) made changes -
            Time Spent 20.25h [ 72900 ] 20.75h [ 74700 ]
            Worklog Id 22155 [ 22155 ]
            mahendra.mungase Mahendra Mungase (Inactive) made changes -
            Status Production Complete [ 10028 ] Closed [ 6 ]
            rakeshr Rakesh Roy (Inactive) made changes -
            Bug Severity Low [ 16703 ]
            satyap Satya made changes -
            Environment_New Production [ 18442 ]
            Transition Time In Source Status Execution Times
            Ramya Tantry (Inactive) made transition -
            Open In Development
            1d 55m 1
            Sachin Hingole (Inactive) made transition -
            In Development In LB Testing
            6h 31m 1
            Rakesh Roy (Inactive) made transition -
            In LB Testing Stage Testing
            13d 4h 3m 1
            Rakesh Roy (Inactive) made transition -
            Stage Testing In Production Testing
            6d 2h 4m 1
            Rakesh Roy (Inactive) made transition -
            In Production Testing Production Complete
            7s 1
            Mahendra Mungase (Inactive) made transition -
            Production Complete Closed
            20d 11h 31m 1

              People

              Assignee:
              smita.pawar Smita Pawar (Inactive)
              Reporter:
              ramya.tantry Ramya Tantry (Inactive)
              Developer:
              Ramya Tantry (Inactive)
              QA:
              Sachin Hingole (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:

                  Time Tracking

                  Estimated:
                  Original Estimate - 16h Original Estimate - 16h
                  16h
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 20.75h
                  20.75h