WORKTERRAProject Type: software

WORKTERRA

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

ACA - When Sub Rate has setting Flat Amount and % of salary then Line 15 showing wrong cost on 1095C PDF

    Details

    • Type: Bug
    • Status: Closed
    • Priority: High
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: ACA
    • Labels:
      None
    • Environment:
      Production
    • Module:
      ACA - 2017
    • Reported by:
      Harbinger
    • Item State:
      Production Complete - Closed
    • Issue Importance:
      Can Wait

      Description

      This need to consider for 2017 IRS Reporting.
      Production Company - County of Del Norte
      Rate Name - EIAHealth PPO 80/60 ACTIVE
      Employee Name - Stormy L Borelli
      Rates shown on Enroll Now and PDF are different (Please Note Enroll Now rates are correct), refer JIRA WT-2965

      Prerequisite
      1 Rate is created and also sub rate is created
      2 Sub rate has setting Flat Rate + % of Monthly Rate for Calculate Contributions for this Plan by
      3 refer customization done for sub rate
      4 employee is created and eligible to plan which is mapped with rate created in above prerequisite and is enrolled in plan (Make sure employee only monthly cost should be greater than 9.5% of FPL (for 2015 FPL amount was about $11777))

      steps
      1] create 1095C report
      2] download 1095C and observe the employee Line 15 cost

        Attachments

          Activity

          Ascending order - Click to sort in descending order
          Hide
          Permalink
          nandkumar Nandkumar Prabhakar Karlekar (Inactive) added a comment -

          Please Update this ticket. this is completed

          Show
          nandkumar Nandkumar Prabhakar Karlekar (Inactive) added a comment - Please Update this ticket. this is completed
          Hide
          Permalink
          sachin.hingole Sachin Hingole (Inactive) added a comment -

          This issue was related to wrong customization, and its fixed for "County of Del Norte".
          But we need to fix this even if some one does wrong customization by mistake then system should consider only valid % amounts for cost calculations.

          Show
          sachin.hingole Sachin Hingole (Inactive) added a comment - This issue was related to wrong customization, and its fixed for "County of Del Norte". But we need to fix this even if some one does wrong customization by mistake then system should consider only valid % amounts for cost calculations.
          Hide
          Permalink
          rakeshr Rakesh Roy (Inactive) added a comment -

          Sachin Hingole Nandkumar Prabhakar Karlekar Is this open?

          Show
          rakeshr Rakesh Roy (Inactive) added a comment - Sachin Hingole Nandkumar Prabhakar Karlekar Is this open?
          Hide
          Permalink
          sachin.hingole Sachin Hingole (Inactive) added a comment -

          As ACA 1095C and IRS submissions are completed for current year, But we have to consider this for next year.

          As discussed with Nandkumar, assigning this JIRA to Ramya

          Show
          sachin.hingole Sachin Hingole (Inactive) added a comment - As ACA 1095C and IRS submissions are completed for current year, But we have to consider this for next year. As discussed with Nandkumar, assigning this JIRA to Ramya
          Hide
          Permalink
          ramya.tantry Ramya Tantry (Inactive) added a comment -

          Files affected:

          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/04_Stored Procedures/dbo.OES_SP_Get_ACAIRS1095CData.StoredProcedure.sql
          Hide
          Permalink
          ramya.tantry Ramya Tantry (Inactive) added a comment -

          Cause: When Sub Rate has setting Flat Amount and % of salary then Line 15 showing wrong cost on 1095C PDF
          Concern: When Sub Rate has setting Flat Amount and % of salary and if percentage is mentioned in both pre tax and post tax column,then we used to calculate cost irrespective of value present in monthly pre tax and monthly post tax. So cost was showing up different.
          Correction: We have made code correction,that percent value will be considered only if value is present in monthly pre tax/post tax column.

          Show
          ramya.tantry Ramya Tantry (Inactive) added a comment - Cause : When Sub Rate has setting Flat Amount and % of salary then Line 15 showing wrong cost on 1095C PDF Concern : When Sub Rate has setting Flat Amount and % of salary and if percentage is mentioned in both pre tax and post tax column,then we used to calculate cost irrespective of value present in monthly pre tax and monthly post tax. So cost was showing up different. Correction : We have made code correction,that percent value will be considered only if value is present in monthly pre tax/post tax column.
          Hide
          Permalink
          sachin.hingole Sachin Hingole (Inactive) added a comment -

          Verified on Stage, working fine.

          Now it shows correct cost on 1095C PDF.

          Show
          sachin.hingole Sachin Hingole (Inactive) added a comment - Verified on Stage, working fine. Now it shows correct cost on 1095C PDF.
          Hide
          Permalink
          sachin.hingole Sachin Hingole (Inactive) added a comment -

          Verified on production, working fine.

          It shows correct cost on 1095C report.

          Show
          sachin.hingole Sachin Hingole (Inactive) added a comment - Verified on production, working fine. It shows correct cost on 1095C report.

            People

            Assignee:
            sachin.hingole Sachin Hingole (Inactive)
            Reporter:
            sachin.hingole Sachin Hingole (Inactive)
            Developer:
            Nandkumar Prabhakar Karlekar (Inactive)
            QA:
            Sachin Hingole (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:
              Production Due Date: