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

ACA_Cost on file and Enroll now screen is not matching for few employees

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Medium
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: ACA
    • Labels:
      None
    • Environment:
      Stage
    • Module:
      ACA - Reports
    • Reported by:
      Harbinger
    • Item State:
      Production Complete - Closed
    • Issue Importance:
      Must Have

      Description

      1.Login to Stage with partner.
      2.Edit company "Wacker Neuson Corporation".
      3.Export Health Efx template for the month of January 2016.

      Employee's SSN's who got 0 EE and ER cost

      394983240
      390947190
      388151345
      394463448
      385847304
      383022941
      390153007

      Actual: Few employees got 0 EE and ER cost
      Expected: Cost on Enroll now screen should match on file's cost.

      Note: Attaching file for ready information

        Attachments

        1. 5729.png
          5729.png
          142 kB
        2. Health Efx.png
          Health Efx.png
          253 kB
        3. WackerNeuson_benefits_201601 (2).txt
          60 kB

          Activity

          Hide
          revansiddha.gaur Revansiddha Gaur (Inactive) added a comment - - edited

          CONCERN : Cost is comming zero on the file

          CAUSE : (datediff(day,@RateEffectivedate,RateChanges_Log.EffectiveDate) <= 0 this condition never get evaluted to true

          CORRECTION: Rate Effective date also need to check such that falling in the range of provided StartDate and End Date values.

          Affected Files :
          \WTBranches\LB\App\BusinessLogic\ImportExportDTS\ACAExportProcessRowwise.vb
          \WTBranches\LB\Database Objects\MasterCompanyDB\04_Stored Procedures\dbo.OES_SP_ACA_Export_GetBillingDetailsWithDatewise.StoredProcedure.sql

          Yogesh Chaudhari Nandkumar Prabhakar Karlekar Smita Pawar Sachin Hingole

          Show
          revansiddha.gaur Revansiddha Gaur (Inactive) added a comment - - edited CONCERN : Cost is comming zero on the file CAUSE : (datediff(day,@RateEffectivedate,RateChanges_Log.EffectiveDate) <= 0 this condition never get evaluted to true CORRECTION: Rate Effective date also need to check such that falling in the range of provided StartDate and End Date values. Affected Files : \WTBranches\LB\App\BusinessLogic\ImportExportDTS\ACAExportProcessRowwise.vb \WTBranches\LB\Database Objects\MasterCompanyDB\04_Stored Procedures\dbo.OES_SP_ACA_Export_GetBillingDetailsWithDatewise.StoredProcedure.sql Yogesh Chaudhari Nandkumar Prabhakar Karlekar Smita Pawar Sachin Hingole
          Hide
          smita.pawar Smita Pawar (Inactive) added a comment -

          We have verified above mentioned issue on LB [ACA Automation].
          Its working fine.

          Tested scenarios are as follows
          1.Verified EE and ER cost on Screen and File
          2.Checked no other employee is getting zero reason without a reason.

          Fix is ready for Stage.

          Show
          smita.pawar Smita Pawar (Inactive) added a comment - We have verified above mentioned issue on LB [ACA Automation] . Its working fine. Tested scenarios are as follows 1.Verified EE and ER cost on Screen and File 2.Checked no other employee is getting zero reason without a reason. Fix is ready for Stage.
          Hide
          smita.pawar Smita Pawar (Inactive) added a comment - - edited

          We have verified above mentioned issue on Stage [Wacker Neuson Corporation for Hspl].
          Its working fine.

          Tested scenario are as followed
          1.Checked EE cost for Jan 2016
          2,Checked ER cost for Jan 2016.
          3.Verified employees on Sampling method

          This fix is ready for Production.
          Attaching screen shot for additional information.

          Show
          smita.pawar Smita Pawar (Inactive) added a comment - - edited We have verified above mentioned issue on Stage [Wacker Neuson Corporation for Hspl] . Its working fine. Tested scenario are as followed 1.Checked EE cost for Jan 2016 2,Checked ER cost for Jan 2016. 3.Verified employees on Sampling method This fix is ready for Production. Attaching screen shot for additional information.
          Hide
          smita.pawar Smita Pawar (Inactive) added a comment - - edited

          We have verified above mentioned issue on production [Wacker Neuson Corporation].

          Scenarios verified are as follows.

          1. EE cost on file and Enroll Now page
          2..ER cost on file and Enroll Now page/
          3.Verified employees on Sampling basis

          Attaching screen shot of verified file

          Show
          smita.pawar Smita Pawar (Inactive) added a comment - - edited We have verified above mentioned issue on production [Wacker Neuson Corporation] . Scenarios verified are as follows. 1. EE cost on file and Enroll Now page 2..ER cost on file and Enroll Now page/ 3.Verified employees on Sampling basis Attaching screen shot of verified file
          Hide
          smita.pawar Smita Pawar (Inactive) added a comment -

          This issue is fixed hence closing ticket

          Show
          smita.pawar Smita Pawar (Inactive) added a comment - This issue is fixed hence closing ticket

            People

            Assignee:
            smita.pawar Smita Pawar (Inactive)
            Reporter:
            smita.pawar Smita Pawar (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:
              Dev Due Date:
              Code Review Date: