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

          Transition Time In Source Status Execution Times
          Alex Nguyen made transition -
          Open Resolved
          42d 12h 41m 1
          Vijay Siddha (Inactive) made transition -
          Resolved Reopen
          1d 17h 45m 1
          Smita Pawar (Inactive) made transition -
          Reopen In Progress
          7d 7h 50m 1
          Smita Pawar (Inactive) made transition -
          In Progress Waiting for Customer Input
          14s 1
          Alex Nguyen made transition -
          Waiting for Customer Input In Progress
          23d 10h 53m 1
          Alex Nguyen made transition -
          In Progress Resolved
          21s 1
          Alex Nguyen made transition -
          Reopen Resolved
          5d 14h 44m 2
          Alex Nguyen made transition -
          Resolved Closed
          10s 3
          Smita Pawar (Inactive) made transition -
          Closed Reopen
          234d 2h 2m 6
          Smita Pawar (Inactive) made transition -
          Reopen Closed
          8d 17h 7m 4

            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