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

Health Efx Benefit File Format Version 1.0 7-3-2015 2017 Data extract

    Details

    • Type: Support Activity
    • Status: Closed
    • Priority: High
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: ACA
    • Labels:
      None
    • Support Task Type:
      Query Resolution
    • Reported by:
      Support
    • Company:
      Wacker Neuson Corporation
    • Module:
      ACA
    • Severity:
      Simple

      Description

      7/18/17 - New carrier contact:

      Christi Cain, CHRS | Account Manager
      Leading through change. | healthefx.us
      Direct: 612.844.0156 Ext. 1022 | Main: 888.963.9174

      Carrier confirmed receipt of file and was loaded.

      7/17/17 - Haven't heard back from Lori Miller at Health Efx, but found out today she won't be back until 7/24. I have left vm for her backup regarding the two ACA files post last Friday:

      Todd Hurst | Director – Client Services
      Leading through change. | healthefx.us
      Direct: 612.844.0156 Ext. 1063 | Mobile: 612.275.3071 | Main: 888.963.9174

      Need confirmation if files were received and loaded.

      5/12/17 - the scheduler is now working as expected and new april file was received and loaded. Carrier had just confirmed this today.

      4/12/17 - I have sent a non PGP test file "TEST_WackerNeuson_dependents_201703.txt" from the ACA dependent template. Carrier confirmed test file was received and view-able. They agreed to allow the files to be sent without PGP encryption as long as it's via SFTP. I have removed PGP from all 3 templates and are set to send with SFTP method. Will need Developers to confirm that after all the testing and changes made to the templates, that the automation can still pull previous months data to send before closing JIRA ticket.

      3/13/17 - Client requested for Feb 2017 files because it was due on 3/10/17. Exported following files....

      1.WackerNeuson_benefits_201702.txt
      2.WackerNeuson_dependents_201702.txt
      3.WackerNeuson_cobra_retiree_201702.txt

      Forwarded to Michelle Parker.

      3/9/17 - Client is requesting for files to be automated to the carrier, but would like to first audit before sending to the carrier. I have reached out to the carrier, Lori Miller lori.miller@healthefx.us, to gather more info. Carrier said she will provide us details regarding their file loading process next week.

      Hi,
      Per your request I have created a new ticket for the ACA file exports
      Can you please run the files out tonight for the Health Efx Benefit File for 01/01/2017 thru 01/31/2017. These are due to Phoenix at BSG for review tomorrow 02/09/2017.

      Alex Nguyen Can you please assist in getting the files to Michelle Parker or Debbie Kulling to forward to Phoenix at BSG.

      Thanks!
      Cindy

        Attachments

        1. ACA Check.xlsx
          289 kB
        2. FTP error.png
          FTP error.png
          40 kB
        3. Graig.png
          Graig.png
          79 kB
        4. Hagen.png
          Hagen.png
          77 kB
        5. history.png
          history.png
          185 kB
        6. Pelaez.png
          Pelaez.png
          88 kB
        7. SFTP_ERROR.png
          SFTP_ERROR.png
          18 kB
        8. Wacker Missing Waivers.png
          Wacker Missing Waivers.png
          96 kB

          Activity

          smita.pawar Smita Pawar (Inactive) logged work - 10/Feb/17 12:58 PM
          • Time Spent:
            4h
             
            <No comment>
          smita.pawar Smita Pawar (Inactive) logged work - 01/Mar/17 12:50 PM - edited
          • Time Spent:
            0.25h
             
            <No comment>
          smita.pawar Smita Pawar (Inactive) logged work - 01/Mar/17 01:38 PM
          • Time Spent:
            0.5h
             

            Jira updates

          smita.pawar Smita Pawar (Inactive) logged work - 02/Mar/17 11:30 AM
          • Time Spent:
            4h
             

            Analysis
            Draft
            Internal communication
            Jira updates

          smita.pawar Smita Pawar (Inactive) logged work - 23/Mar/17 01:23 PM - edited
          • Time Spent:
            2h
             

            Analysis
            Schedular functionality
            Jira Updates
            Draft

          Ganesh.sadawarte Ganesh Sadawarte (Inactive) logged work - 10/Apr/17 12:11 PM
          • Time Spent:
            2h
             

            1) Checked PGP Key
            2) Checked SFTP details.

          smita.pawar Smita Pawar (Inactive) logged work - 12/Apr/17 03:52 AM
          • Time Spent:
            0.5h
             

            Internal discussion

          jaideep.vinchurkar Jaideep Vinchurkar (Inactive) logged work - 12/Apr/17 11:17 AM
          • Time Spent:
            0.5h
             
            <No comment>
          smita.pawar Smita Pawar (Inactive) logged work - 19/Apr/17 10:57 AM
          • Time Spent:
            3h
             

            Scheduler testing
            Jira updates
            Email
            Internal communication with Export Team

          aniruddha.dev Aniruddha Dev (Inactive) logged work - 19/Apr/17 06:18 PM
          • Time Spent:
            0.5h
             

            Helping Smita for Scheduler

          smita.pawar Smita Pawar (Inactive) logged work - 28/Apr/17 02:36 PM
          • Time Spent:
            3.5h
             

            Schedular Testing
            Email
            Jira updates
            Internal communication

          revansiddha.gaur Revansiddha Gaur (Inactive) logged work - 11/May/17 09:00 AM
          • Time Spent:
            2h
             

            Query resolution.

          smita.pawar Smita Pawar (Inactive) logged work - 11/May/17 11:38 AM
          • Time Spent:
            6h
             

            File delivery

          smita.pawar Smita Pawar (Inactive) logged work - 13/Jul/17 11:08 AM
          • Time Spent:
            6h
             

            Waker neuson issue analysis
            File testing for May & Jun for waive entries
            Internal discussion

          revansiddha.gaur Revansiddha Gaur (Inactive) logged work - 13/Jul/17 09:00 PM
          • Time Spent:
            9h
             

            File testing & bug analysis.

          smita.pawar Smita Pawar (Inactive) logged work - 14/Jul/17 01:58 PM
          • Time Spent:
            4h
             

            File testing
            Internal discussion
            File uploading
            Jira updated

          yogita.bhadane Yogita Bhadane (Inactive) logged work - 14/Jul/17 06:03 PM
          • Time Spent:
            4h
             

            Discussion with smita.
            Tested may and june file according checklist and also for reported scenarios.

          yogesh.chaudhari Yogesh Chaudhari (Inactive) logged work - 30/Aug/17 10:13 AM
          • Time Spent:
            3.5h
             

            Analysis of employees reported by client and send feedback to them.

          smita.pawar Smita Pawar (Inactive) logged work - 30/Aug/17 10:51 AM
          • Time Spent:
            2h
             

            Analysis
            Internal discussion

          smita.pawar Smita Pawar (Inactive) logged work - 18/Dec/17 12:32 PM
          • Time Spent:
            5h
             

            testing Wacker neuson file after deployment of Jira WT-10365
            mail to Amit
            Internal discussion
            Draft

            People

            Assignee:
            alexn Alex Nguyen
            Reporter:
            Cindy.Wibbing Cindy Wibbing (Inactive)
            Account Executive:
            Michelle Parker (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            12 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:

                Time Tracking

                Estimated:
                Original Estimate - 8h Original Estimate - 8h
                8h
                Remaining:
                Remaining Estimate - 0h
                0h
                Logged:
                Time Spent - 62.25h
                62.25h