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

          Hide
          alexn Alex Nguyen added a comment -

          Hi Yogesh Chaudhari,

          Our account exec, Michelle Parker, already checked with Becky at BSG who confirmed Julius Jenkins needs to be waived. Please apply the waive and confirm which next file they will go on. Client needs to know for tracking purposes.

          Thank you,

          Alex

          Show
          alexn Alex Nguyen added a comment - Hi Yogesh Chaudhari , Our account exec, Michelle Parker, already checked with Becky at BSG who confirmed Julius Jenkins needs to be waived. Please apply the waive and confirm which next file they will go on. Client needs to know for tracking purposes. Thank you, Alex
          Hide
          yogesh.chaudhari Yogesh Chaudhari (Inactive) added a comment - - edited

          Hello Alex Nguyen,

          We have waived employee Julius Jenkins on the main company Wacker Neuson Corporation.
          Julius Jenkins will get populate on ACA next file.

          Thanks,
          Yogesh Chaudhari
          Nandkumar Prabhakar KarlekarSmita PawarRevansiddha Gaur

          Show
          yogesh.chaudhari Yogesh Chaudhari (Inactive) added a comment - - edited Hello Alex Nguyen , We have waived employee Julius Jenkins on the main company Wacker Neuson Corporation. Julius Jenkins will get populate on ACA next file. Thanks, Yogesh Chaudhari Nandkumar Prabhakar Karlekar Smita Pawar Revansiddha Gaur
          Hide
          alexn Alex Nguyen added a comment -

          Thank you Yogesh Chaudhari,

          I see the medical waive applied to the Julius Jenkins now and will wait until tomorrow to see if she and Szpiszar are on the 9/7 file before closing the ticket.

          Alex

          Show
          alexn Alex Nguyen added a comment - Thank you Yogesh Chaudhari , I see the medical waive applied to the Julius Jenkins now and will wait until tomorrow to see if she and Szpiszar are on the 9/7 file before closing the ticket. Alex
          Hide
          alexn Alex Nguyen added a comment -

          I verified both Julius Jenkins and Jay Szpiszar are on today's ACA file as waived along with 1 other record, Laura Plautz.

          Ran add/change/term shows total of 4 medical waived. Out of the 4 there's 1 waived by Venkatasailendra Pinnamaneni effective 9/1/17 and will be on the next ACA file (10/7/17).

          Closing ticket.

          Thank you,

          Alex

          Show
          alexn Alex Nguyen added a comment - I verified both Julius Jenkins and Jay Szpiszar are on today's ACA file as waived along with 1 other record, Laura Plautz. Ran add/change/term shows total of 4 medical waived. Out of the 4 there's 1 waived by Venkatasailendra Pinnamaneni effective 9/1/17 and will be on the next ACA file (10/7/17). Closing ticket. Thank you, Alex
          Hide
          smita.pawar Smita Pawar (Inactive) added a comment -

          Reopening issue to add work log

          Show
          smita.pawar Smita Pawar (Inactive) added a comment - Reopening issue to add work log

            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