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

          Cindy.Wibbing Cindy Wibbing (Inactive) created issue -
          mahendra.mungase Mahendra Mungase (Inactive) made changes -
          Field Original Value New Value
          Assignee Mahendra Mungase [ mahendra.mungase ] Smita Pawar [ smita.pawar ]
          mahendra.mungase Mahendra Mungase (Inactive) made changes -
          Module Parent values: BenAdmin(10100) Parent values: ACA(10104)
          satyap Satya made changes -
          Component/s ACA [ 10004 ]
          smita.pawar Smita Pawar (Inactive) made changes -
          Remaining Estimate 8h [ 28800 ]
          Original Estimate 8h [ 28800 ]
          smita.pawar Smita Pawar (Inactive) made changes -
          Remaining Estimate 8h [ 28800 ] 4h [ 14400 ]
          Time Spent 4h [ 14400 ]
          Worklog Id 24391 [ 24391 ]
          smita.pawar Smita Pawar (Inactive) made changes -
          Assignee Smita Pawar [ smita.pawar ] Cindy Wibbing [ cindy.wibbing ]
          michelle.parker Michelle Parker (Inactive) made changes -
          Attachment Wacker Missing Waivers.png [ 40349 ]
          alexn Alex Nguyen made changes -
          Assignee Cindy Wibbing [ cindy.wibbing ] Alex Nguyen [ alexn ]
          alexn Alex Nguyen made changes -
          Assignee Alex Nguyen [ alexn ] Smita Pawar [ smita.pawar ]
          alexn Alex Nguyen made changes -
          Attachment history.png [ 41041 ]
          smita.pawar Smita Pawar (Inactive) made changes -
          Remaining Estimate 4h [ 14400 ] 3.5h [ 12600 ]
          Time Spent 4h [ 14400 ] 4.5h [ 16200 ]
          Worklog Id 28371 [ 28371 ]
          smita.pawar Smita Pawar (Inactive) made changes -
          Remaining Estimate 3.5h [ 12600 ] 0h [ 0 ]
          Time Spent 4.5h [ 16200 ] 8.5h [ 30600 ]
          Worklog Id 28520 [ 28520 ]
          smita.pawar Smita Pawar (Inactive) made changes -
          Attachment Graig.png [ 41207 ]
          Attachment Hagen.png [ 41208 ]
          Attachment Pelaez.png [ 41209 ]
          smita.pawar Smita Pawar (Inactive) made changes -
          Assignee Smita Pawar [ smita.pawar ] Alex Nguyen [ alexn ]
          smita.pawar Smita Pawar (Inactive) made changes -
          Time Spent 8.5h [ 30600 ] 8.75h [ 31500 ]
          Worklog Id 28578 [ 28578 ]
          smita.pawar Smita Pawar (Inactive) made changes -
          Worklog Id 28578 [ 28578 ]
          alexn Alex Nguyen made changes -
          Description 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.

          [~alexn] Can you please assist in getting the files to [~michelle.parker] or [~dkulling] to forward to Phoenix at BSG.

          Thanks!
          Cindy
          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.

          [~alexn] Can you please assist in getting the files to [~michelle.parker] or [~dkulling] to forward to Phoenix at BSG.

          Thanks!
          Cindy
          alexn Alex Nguyen made changes -
          Description 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.

          [~alexn] Can you please assist in getting the files to [~michelle.parker] or [~dkulling] to forward to Phoenix at BSG.

          Thanks!
          Cindy
          3/13/17 - Client requested for Feb 2017 files because it was due on 3/10/17. Exported and 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.

          [~alexn] Can you please assist in getting the files to [~michelle.parker] or [~dkulling] to forward to Phoenix at BSG.

          Thanks!
          Cindy
          alexn Alex Nguyen made changes -
          Description 3/13/17 - Client requested for Feb 2017 files because it was due on 3/10/17. Exported and 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.

          [~alexn] Can you please assist in getting the files to [~michelle.parker] or [~dkulling] to forward to Phoenix at BSG.

          Thanks!
          Cindy
          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.

          [~alexn] Can you please assist in getting the files to [~michelle.parker] or [~dkulling] to forward to Phoenix at BSG.

          Thanks!
          Cindy
          revansiddha.gaur Revansiddha Gaur (Inactive) made changes -
          Assignee Alex Nguyen [ alexn ] Smita Pawar [ smita.v.pawar ]
          smita.pawar Smita Pawar (Inactive) made changes -
          Assignee Smita Pawar [ smita.v.pawar ] Alex Nguyen [ alexn ]
          alexn Alex Nguyen made changes -
          Assignee Alex Nguyen [ alexn ] Smita Pawar [ smita.pawar ]
          smita.pawar Smita Pawar (Inactive) made changes -
          Assignee Smita Pawar [ smita.pawar ] Alex Nguyen [ alexn ]
          smita.pawar Smita Pawar (Inactive) made changes -
          Time Spent 8.75h [ 31500 ] 10.75h [ 38700 ]
          Worklog Id 33291 [ 33291 ]
          smita.pawar Smita Pawar (Inactive) made changes -
          Worklog Id 33291 [ 33291 ]
          alexn Alex Nguyen made changes -
          Resolution Fixed [ 1 ]
          Status Open [ 1 ] Resolved [ 5 ]
          alexn Alex Nguyen made changes -
          Status Resolved [ 5 ] Closed [ 6 ]
          Ganesh.sadawarte Ganesh Sadawarte (Inactive) made changes -
          Resolution Fixed [ 1 ]
          Status Closed [ 6 ] Reopened [ 4 ]
          Ganesh.sadawarte Ganesh Sadawarte (Inactive) made changes -
          Assignee Alex Nguyen [ alexn ] Ganesh Sadawarte [ ganesh.sadawarte ]
          Ganesh.sadawarte Ganesh Sadawarte (Inactive) made changes -
          Comment [ Hi [~alexn],

          We have checked below templates.
          ]
          Ganesh.sadawarte Ganesh Sadawarte (Inactive) made changes -
          Attachment SFTP_ERROR.png [ 44931 ]
          Ganesh.sadawarte Ganesh Sadawarte (Inactive) made changes -
          Time Spent 10.75h [ 38700 ] 12.75h [ 45900 ]
          Worklog Id 37184 [ 37184 ]
          Ganesh.sadawarte Ganesh Sadawarte (Inactive) made changes -
          Assignee Ganesh Sadawarte [ ganesh.sadawarte ] Alex Nguyen [ alexn ]
          Resolution Done [ 10000 ]
          Status Reopened [ 4 ] Resolved [ 5 ]
          vijays Vijay Siddha (Inactive) made changes -
          Assignee Alex Nguyen [ alexn ] Jaideep Vinchurkar [ jaideep.vinchurkar ]
          vijays Vijay Siddha (Inactive) made changes -
          Resolution Done [ 10000 ]
          Status Resolved [ 5 ] Reopened [ 4 ]
          jaideep.vinchurkar Jaideep Vinchurkar (Inactive) made changes -
          Assignee Jaideep Vinchurkar [ jaideep.vinchurkar ] Alex Nguyen [ alexn ]
          jaideep.vinchurkar Jaideep Vinchurkar (Inactive) made changes -
          Time Spent 12.75h [ 45900 ] 13.25h [ 47700 ]
          Worklog Id 37719 [ 37719 ]
          alexn Alex Nguyen made changes -
          Description 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.

          [~alexn] Can you please assist in getting the files to [~michelle.parker] or [~dkulling] to forward to Phoenix at BSG.

          Thanks!
          Cindy
          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.

          [~alexn] Can you please assist in getting the files to [~michelle.parker] or [~dkulling] to forward to Phoenix at BSG.

          Thanks!
          Cindy
          hrishikesh.deshpande Hrishikesh Deshpande (Inactive) made changes -
          Assignee Alex Nguyen [ alexn ] Smita Pawar [ smita.pawar ]
          smita.pawar Smita Pawar (Inactive) made changes -
          Status Reopened [ 4 ] In Progress [ 3 ]
          smita.pawar Smita Pawar (Inactive) made changes -
          Status In Progress [ 3 ] Waiting for Customer Input [ 10500 ]
          smita.pawar Smita Pawar (Inactive) made changes -
          Assignee Smita Pawar [ smita.pawar ] Alex Nguyen [ alexn ]
          alexn Alex Nguyen made changes -
          Assignee Alex Nguyen [ alexn ] Smita Pawar [ smita.pawar ]
          aniruddha.dev Aniruddha Dev (Inactive) made changes -
          Time Spent 13.25h [ 47700 ] 13.75h [ 49500 ]
          Worklog Id 41738 [ 41738 ]
          smita.pawar Smita Pawar (Inactive) made changes -
          Time Spent 13.75h [ 49500 ] 16.75h [ 60300 ]
          Worklog Id 42215 [ 42215 ]
          smita.pawar Smita Pawar (Inactive) made changes -
          Attachment FTP error.png [ 46630 ]
          smita.pawar Smita Pawar (Inactive) made changes -
          Time Spent 16.75h [ 60300 ] 20.25h [ 72900 ]
          Worklog Id 42486 [ 42486 ]
          alexn Alex Nguyen made changes -
          Link This issue relates to EDI-1772 [ EDI-1772 ]
          smita.pawar Smita Pawar (Inactive) made changes -
          Time Spent 20.25h [ 72900 ] 20.75h [ 74700 ]
          Worklog Id 42620 [ 42620 ]
          smita.pawar Smita Pawar (Inactive) made changes -
          Assignee Smita Pawar [ smita.pawar ] Alex Nguyen [ alexn ]
          alexn Alex Nguyen made changes -
          Assignee Alex Nguyen [ alexn ] Smita Pawar [ smita.pawar ]
          smita.pawar Smita Pawar (Inactive) made changes -
          Assignee Smita Pawar [ smita.pawar ] Alex Nguyen [ alexn ]
          smita.pawar Smita Pawar (Inactive) made changes -
          Time Spent 20.75h [ 74700 ] 26.75h [ 96300 ]
          Worklog Id 44756 [ 44756 ]
          revansiddha.gaur Revansiddha Gaur (Inactive) made changes -
          Time Spent 26.75h [ 96300 ] 28.75h [ 103500 ]
          Worklog Id 44774 [ 44774 ]
          alexn Alex Nguyen made changes -
          Description 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.

          [~alexn] Can you please assist in getting the files to [~michelle.parker] or [~dkulling] to forward to Phoenix at BSG.

          Thanks!
          Cindy
          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.

          [~alexn] Can you please assist in getting the files to [~michelle.parker] or [~dkulling] to forward to Phoenix at BSG.

          Thanks!
          Cindy
          alexn Alex Nguyen made changes -
          Status Waiting for Customer Input [ 10500 ] In Progress [ 3 ]
          alexn Alex Nguyen made changes -
          Resolution Fixed [ 1 ]
          Status In Progress [ 3 ] Resolved [ 5 ]
          alexn Alex Nguyen made changes -
          Status Resolved [ 5 ] Closed [ 6 ]
          Cindy.Wibbing Cindy Wibbing (Inactive) made changes -
          Resolution Fixed [ 1 ]
          Status Closed [ 6 ] Reopened [ 4 ]
          Cindy.Wibbing Cindy Wibbing (Inactive) made changes -
          Attachment ACA Check.xlsx [ 55200 ]
          revansiddha.gaur Revansiddha Gaur (Inactive) made changes -
          Time Spent 28.75h [ 103500 ] 37.75h [ 135900 ]
          Worklog Id 63337 [ 63337 ]
          smita.pawar Smita Pawar (Inactive) made changes -
          Time Spent 37.75h [ 135900 ] 41.75h [ 150300 ]
          Worklog Id 63533 [ 63533 ]
          alexn Alex Nguyen made changes -
          Description 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.

          [~alexn] Can you please assist in getting the files to [~michelle.parker] or [~dkulling] to forward to Phoenix at BSG.

          Thanks!
          Cindy
          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.

          [~alexn] Can you please assist in getting the files to [~michelle.parker] or [~dkulling] to forward to Phoenix at BSG.

          Thanks!
          Cindy
          alexn Alex Nguyen made changes -
          Description 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.

          [~alexn] Can you please assist in getting the files to [~michelle.parker] or [~dkulling] to forward to Phoenix at BSG.

          Thanks!
          Cindy
          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.

          [~alexn] Can you please assist in getting the files to [~michelle.parker] or [~dkulling] to forward to Phoenix at BSG.

          Thanks!
          Cindy
          alexn Alex Nguyen made changes -
          Resolution Done [ 10000 ]
          Status Reopened [ 4 ] Resolved [ 5 ]
          alexn Alex Nguyen made changes -
          Status Resolved [ 5 ] Closed [ 6 ]
          yogita.bhadane Yogita Bhadane (Inactive) made changes -
          Resolution Done [ 10000 ]
          Status Closed [ 6 ] Reopened [ 4 ]
          yogita.bhadane Yogita Bhadane (Inactive) made changes -
          Time Spent 41.75h [ 150300 ] 45.75h [ 164700 ]
          Worklog Id 65470 [ 65470 ]
          yogita.bhadane Yogita Bhadane (Inactive) made changes -
          Resolution Done [ 10000 ]
          Status Reopened [ 4 ] Closed [ 6 ]
          smita.pawar Smita Pawar (Inactive) made changes -
          Resolution Done [ 10000 ]
          Status Closed [ 6 ] Reopened [ 4 ]
          smita.pawar Smita Pawar (Inactive) made changes -
          Time Spent 45.75h [ 164700 ] 51.75h [ 186300 ]
          Worklog Id 67060 [ 67060 ]
          smita.pawar Smita Pawar (Inactive) made changes -
          Resolution Unresolved [ 10200 ]
          Status Reopened [ 4 ] Closed [ 6 ]
          Cindy.Wibbing Cindy Wibbing (Inactive) made changes -
          Resolution Unresolved [ 10200 ]
          Status Closed [ 6 ] Reopened [ 4 ]
          smita.pawar Smita Pawar (Inactive) made changes -
          Time Spent 51.75h [ 186300 ] 53.75h [ 193500 ]
          Worklog Id 75197 [ 75197 ]
          yogesh.chaudhari Yogesh Chaudhari (Inactive) made changes -
          Time Spent 53.75h [ 193500 ] 57.25h [ 206100 ]
          Worklog Id 76009 [ 76009 ]
          alexn Alex Nguyen made changes -
          Resolution Fixed [ 1 ]
          Status Reopened [ 4 ] Closed [ 6 ]
          smita.pawar Smita Pawar (Inactive) made changes -
          Resolution Fixed [ 1 ]
          Status Closed [ 6 ] Reopen [ 4 ]
          smita.pawar Smita Pawar (Inactive) made changes -
          Time Spent 57.25h [ 206100 ] 62.25h [ 224100 ]
          Worklog Id 98832 [ 98832 ]
          smita.pawar Smita Pawar (Inactive) made changes -
          Resolution Done [ 10000 ]
          Status Reopen [ 4 ] Closed [ 6 ]

            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