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

ACA - Mandatory field data missing for employee on Valmet Benefit Import FEB change file

    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
    • Reported by:
      Harbinger
    • Item State:
      Production Complete - Closed
    • Issue Importance:
      Must Have

      Description

      for below 5 EEs missing OFFR, ELIG, COVG data.
      Below are employees from FEB change file, FEB change file is exported from Valmet production

      671 Dan Lanning
      715 Ronnie Steen
      899 David Larry
      1087 Chad Surunis
      1156 Mark Tierney

        Attachments

          Issue Links

            Activity

            revansiddha.gaur Revansiddha Gaur (Inactive) logged work - 24/Nov/16 05:32 AM
            • Time Spent:
              4h
               

              Analysis of Issue and found the cause as below for EmployeeID -671..
              Concern: Event Data & Eligibility Data not reflected on the file.
              Cause : Event Data will capture only those records whose enrollment datetimestamp is greater than last full exported date.
              So Last full file export date is ..2016-10-21 04:43:44.000
              And Enrollment Date TimeStamp is..2016-10-02 01:08:09.517
              Expected datetimestamp must be greater than Last exported date i.e. .2016-10-21 04:43:44.000 but actually its not like that. This is incorrect data

              @Nandkumar, @Yogesh

            nandkumar Nandkumar Prabhakar Karlekar (Inactive) logged work - 24/Nov/16 06:44 AM
            • Time Spent:
              1h
               
              <No comment>
            revansiddha.gaur Revansiddha Gaur (Inactive) logged work - 25/Nov/16 06:37 AM
            • Time Spent:
              1h
               

              Analysis

              Ref : EmployeeID 899,715

              Concern:
              Blank Offer Element populated , Blank Eligibility Element populated but covg element is populated as employees are enrolled in Medical Opt-Out plan.

              Cause :
              Blank Eligibility element : Medical Opt-Out Plan is not an ACA Plan.

              Blank Offer element : Only populated the events which are related to ACA Plans.

              Correction:
              As per discussion with Nandkumar & Export Team Members,
              1. To populate the events on file, removal the check of IsACAPlans and refer the selected plans from the template customization.-(Implementation is needed)
              2. ELIG element line should not be populated in case of required field value is not present
              (Implementation is needed)

              @Sachin

            nandkumar Nandkumar Prabhakar Karlekar (Inactive) logged work - 25/Nov/16 06:44 AM
            • Time Spent:
              0.5h
               
              <No comment>
            nandkumar Nandkumar Prabhakar Karlekar (Inactive) logged work - 25/Nov/16 01:02 PM
            • Time Spent:
              2h
               

              production issue tracing the issue on all servers

            revansiddha.gaur Revansiddha Gaur (Inactive) logged work - 25/Nov/16 02:16 PM
            • Time Spent:
              7h
               

              Export Error Causing Analysis.
              Found issue on Valmet Company while exporting & find out the root cause issue.
              Due to bad data export reporting an error.

              Whoes employee id is not exist in demographic table that ids are present in Ratechange log table.

            revansiddha.gaur Revansiddha Gaur (Inactive) logged work - 28/Nov/16 07:03 AM
            • Time Spent:
              20m
               

              Code Checkins trunk & LB

            sachin.hingole Sachin Hingole (Inactive) logged work - 29/Nov/16 05:38 AM
            • Time Spent:
              0.5h
               
              <No comment>
            sachin.hingole Sachin Hingole (Inactive) logged work - 30/Nov/16 07:06 AM
            • Time Spent:
              1h
               
              <No comment>
            revansiddha.gaur Revansiddha Gaur (Inactive) logged work - 01/Dec/16 04:04 AM - edited
            • Time Spent:
              1h
               

              Production Checkin- & Veriifcation

            sachin.hingole Sachin Hingole (Inactive) logged work - 02/Dec/16 07:08 AM
            • Time Spent:
              0.75h
               
              <No comment>

              People

              Assignee:
              sachin.hingole Sachin Hingole (Inactive)
              Reporter:
              sachin.hingole Sachin Hingole (Inactive)
              Developer:
              Revansiddha Gaur (Inactive)
              QA:
              Sachin Hingole (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:
                Dev Due Date:

                  Time Tracking

                  Estimated:
                  Original Estimate - 21h
                  21h
                  Remaining:
                  Time Spent - 19h 5m Remaining Estimate - 1h 55m
                  1h 55m
                  Logged:
                  Time Spent - 19h 5m Remaining Estimate - 1h 55m
                  19h 5m