WORKTERRAProject Type: software

WORKTERRA

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

Rehire employee is not coming on the file.

    Details

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

      Description

      Env: LB
      Company: ACA Automation
      SSN:100000030

      Step:-
      1.Login to application
      2.Navigate to Import Export > Manual Import Export >Select Export radio button>BSG-S
      3.From date -07/01/2016-07/15/2016
      4.Click on Export button
      5.Download file

      Employee enrolled in Medical plan on 01/01/2016.
      Terminated on 04/01/2016.

      Rehired on 07/01/2016

      Actual:-Employee was not on the full file of Jan and Jul
      Expected:-Employee should come on the file of Jan and Jul if deleted run rate maintenance

      Note: Please delete run-rate maintenance as its a full file. Let us know if you need any additional information.

        Attachments

          Issue Links

          relates to

          Enhancement - An improvement or enhancement to an existing feature or task. WT-2601 BSG ACA Reporting

          • High - Serious problem that could block progress.
          • Closed

            Activity

            Ascending order - Click to sort in descending order
            Hide
            Permalink
            revansiddha.gaur Revansiddha Gaur (Inactive) added a comment -

            Please correct the description. As export file period is of July but expected results of Jan and Sept.

            Show
            revansiddha.gaur Revansiddha Gaur (Inactive) added a comment - Please correct the description. As export file period is of July but expected results of Jan and Sept.
            Hide
            Permalink
            revansiddha.gaur Revansiddha Gaur (Inactive) added a comment - - edited

            Concern : Rehire employee is not coming on the file

            Cause : Used EmploymentDate in select query condition.

            Correction : Instead of employementdate used StatusChangeDate to get reflected on the file.
            COID_NETSECUREID_BenefitsImport_20160811_153750.txt

            Show
            revansiddha.gaur Revansiddha Gaur (Inactive) added a comment - - edited Concern : Rehire employee is not coming on the file Cause : Used EmploymentDate in select query condition. Correction : Instead of employementdate used StatusChangeDate to get reflected on the file. COID_NETSECUREID_BenefitsImport_20160811_153750.txt
            Hide
            Permalink
            smita.pawar Smita Pawar (Inactive) added a comment -

            We have verified above mentioned fix on LB. [ACA Automation company].
            Its working fine, We have verified scenario with same mentioned employee.

            Scenarios tested are as follows
            1.Tested whether employee is on the file when employee's status is Active
            2.Tested whether employee is on the file when employee's status is Terminated
            3.Tested whether employee is on the file when employee's status is Rehire

            We will move this fix to Stage with BSG file implementation,
            Hence currently marking as LB Hold

            Show
            smita.pawar Smita Pawar (Inactive) added a comment - We have verified above mentioned fix on LB. [ACA Automation company] . Its working fine, We have verified scenario with same mentioned employee. Scenarios tested are as follows 1.Tested whether employee is on the file when employee's status is Active 2.Tested whether employee is on the file when employee's status is Terminated 3.Tested whether employee is on the file when employee's status is Rehire We will move this fix to Stage with BSG file implementation, Hence currently marking as LB Hold
            Hide
            Permalink
            smita.pawar Smita Pawar (Inactive) added a comment - - edited

            We have verified above mentioned issue on Stage [For ACA BSG Test ACAAutomation].
            Its working fine.
            We have verified for same employee i.e having SSN: 100000030

            Show
            smita.pawar Smita Pawar (Inactive) added a comment - - edited We have verified above mentioned issue on Stage [For ACA BSG Test ACAAutomation] . Its working fine. We have verified for same employee i.e having SSN: 100000030
            Hide
            Permalink
            smita.pawar Smita Pawar (Inactive) added a comment -

            We will move this with BSG-ACA enhancement

            Show
            smita.pawar Smita Pawar (Inactive) added a comment - We will move this with BSG-ACA enhancement
            Hide
            Permalink
            smita.pawar Smita Pawar (Inactive) added a comment -

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

            EEID|100000030|100000030|PAUL||TUNNERO|M|08/07/1979
            OFFR|100000030|Qualifying Event - Admin Change|Qualifying Event - Admin Change|01/01/2016|01/01/2016|01/01/2016|12/31/2016|08/08/2016 07:15:25.937000 PM
            ELIG|100000030|Qualifying Event - Admin Change|BSGPlanFour+OLD|BSG Plan Four|EE|Employee|Yes|240.00|410.00|Y|Y|Y|Y|Y|63.08|Y|
            ELIG|100000030|Qualifying Event - Admin Change|BSGPlanFour+OLD|BSG Plan Four|EE+Family|Employee + Family|No|250.00|420.00|Y|Y|Y|Y|Y|62.69|Y|
            ELIG|100000030|Qualifying Event - Admin Change|BSGPlanFour+OLD|BSG Plan Four|EE + CH|Employee + 1|No|250.00|420.00|Y|Y|Y|Y|Y|62.69|Y|
            ELIG|100000030|Qualifying Event - Admin Change|BSGPlanFour+OLD|BSG Plan Four|EE + SP|Employee + Spouse|No|250.00|420.00|Y|Y|Y|Y|Y|62.69|Y|
            ELIG|100000030|Qualifying Event - Admin Change|BSGPlanFive_OLD|BSG Plan Five|EE|Employee|Yes|50.00|350.00|Y|Y|Y|Y|Y|87.50|Y|
            ELIG|100000030|Qualifying Event - Admin Change|BSGPlanFive_OLD|BSG Plan Five|EE+Family|Employee + Family|No|75.00|175.00|Y|Y|Y|Y|Y|70.00|Y|
            ELIG|100000030|Qualifying Event - Admin Change|BSGPlanFive_OLD|BSG Plan Five|EE + CH|Employee + 1|No|65.00|160.00|Y|Y|Y|Y|Y|71.11|Y|
            ELIG|100000030|Qualifying Event - Admin Change|BSGPlanFive_OLD|BSG Plan Five|EE + SP|Employee + Spouse|No|60.00|175.00|Y|Y|Y|Y|Y|74.47|Y|
            ELIG|100000030|Qualifying Event - Admin Change|BSGPlanFive_OLD|BSG Plan Five|Employee + Child|Employee + Child|No|70.00|180.00|Y|Y|Y|Y|Y|72.00|Y|
            COVG|100000030|Qualifying Event - Admin Change|01/01/2016|BSGPlanFour+OLD|BSG Plan Four|EE|Employee|240.00|410.00|01/01/2016|04/01/2016|||||||08/08/2016 07:19:29.000000 PM

            Show
            smita.pawar Smita Pawar (Inactive) added a comment - We have verified above mentioned issue on Production [ACA Automation] . Its working fine EEID|100000030|100000030|PAUL||TUNNERO|M|08/07/1979 OFFR|100000030|Qualifying Event - Admin Change|Qualifying Event - Admin Change|01/01/2016|01/01/2016|01/01/2016|12/31/2016|08/08/2016 07:15:25.937000 PM ELIG|100000030|Qualifying Event - Admin Change|BSGPlanFour+OLD|BSG Plan Four|EE|Employee|Yes|240.00|410.00|Y|Y|Y|Y|Y|63.08|Y| ELIG|100000030|Qualifying Event - Admin Change|BSGPlanFour+OLD|BSG Plan Four|EE+Family|Employee + Family|No|250.00|420.00|Y|Y|Y|Y|Y|62.69|Y| ELIG|100000030|Qualifying Event - Admin Change|BSGPlanFour+OLD|BSG Plan Four|EE + CH|Employee + 1|No|250.00|420.00|Y|Y|Y|Y|Y|62.69|Y| ELIG|100000030|Qualifying Event - Admin Change|BSGPlanFour+OLD|BSG Plan Four|EE + SP|Employee + Spouse|No|250.00|420.00|Y|Y|Y|Y|Y|62.69|Y| ELIG|100000030|Qualifying Event - Admin Change|BSGPlanFive_OLD|BSG Plan Five|EE|Employee|Yes|50.00|350.00|Y|Y|Y|Y|Y|87.50|Y| ELIG|100000030|Qualifying Event - Admin Change|BSGPlanFive_OLD|BSG Plan Five|EE+Family|Employee + Family|No|75.00|175.00|Y|Y|Y|Y|Y|70.00|Y| ELIG|100000030|Qualifying Event - Admin Change|BSGPlanFive_OLD|BSG Plan Five|EE + CH|Employee + 1|No|65.00|160.00|Y|Y|Y|Y|Y|71.11|Y| ELIG|100000030|Qualifying Event - Admin Change|BSGPlanFive_OLD|BSG Plan Five|EE + SP|Employee + Spouse|No|60.00|175.00|Y|Y|Y|Y|Y|74.47|Y| ELIG|100000030|Qualifying Event - Admin Change|BSGPlanFive_OLD|BSG Plan Five|Employee + Child|Employee + Child|No|70.00|180.00|Y|Y|Y|Y|Y|72.00|Y| COVG|100000030|Qualifying Event - Admin Change|01/01/2016|BSGPlanFour+OLD|BSG Plan Four|EE|Employee|240.00|410.00|01/01/2016|04/01/2016|||||||08/08/2016 07:19:29.000000 PM

              People

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

                Dates

                Created:
                Updated:
                Resolved: