WORKTERRAProject Type: software

WORKTERRA

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

EQUIFAX - Prime (no space) Healthcare

    Details

    • Type: Support Activity
    • Status: Closed
    • Priority: Medium
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: None
    • Labels:
      None
    • Support Task Type:
      Configuration
    • Reported by:
      Support
    • Company:
      PrimeHealthcare
    • Module:
      ACA

      Description

      Hi Nandu,

      Currently we have a file export for Prime (Space) for the EQUIFAX ACA items. We will also need to add the Prime (no space) Healthcare as well. The new facilities are:

      Suburban (2/1/2016)
      Lake Huron (effective 1/1/16)

      Also – There are a few groups that have moved off of the Prime (space) company which are now on the Prime (no space). Those facilities are:

      Garden City HGC
      Garden City PMG
      Providence Medical Center
      Providence Place
      Saint John Hospital
      United Home Health Services

      There data will need to pull from this site (Prime no space) with 1/1/16 going forward.

      Can you please provide an ETA of when you think we can get a file for January

        Attachments

        1. Amber-workterra_Updated_Harbinger_17Jan17.xls
          135 kB
        2. Amber-workterra.xlsx
          68 kB
        3. Analysis_16May16.xls
          11 kB
        4. Analysis_16May16-Updated.xls
          33 kB
        5. Analysis_20May16_Verified.xls
          13 kB
        6. CHMC_Issues.xls
          8 kB
        7. CHRISTINA MCCARRICK.JPG
          CHRISTINA MCCARRICK.JPG
          43 kB
        8. Copy of WorkTerra FEIN.xlsx
          12 kB
        9. Data Book 8 (Orphan Employee Benefits) 11-9-16_received 11.16.2016.XLSX
          100 kB
        10. Duplicate_Employee_List.zip
          136 kB
        11. Emailing Jan2016_Emp_received 11.16.2016.msg
          7.50 MB
        12. Employee_For_FEIN# 262887948.xls
          8 kB
        13. Employee_List_WithoutSSN.xls
          7 kB
        14. Feb_HEMA JONNALAGADDA_IncorrectBenefitEffectiveDate.jpg
          Feb_HEMA JONNALAGADDA_IncorrectBenefitEffectiveDate.jpg
          184 kB
        15. Feb_Susan Beaver.jpg
          Feb_Susan Beaver.jpg
          241 kB
        16. FEIN-472819044_Suburban.jpg
          FEIN-472819044_Suburban.jpg
          167 kB
        17. FTP_Upload_10242016.jpg
          FTP_Upload_10242016.jpg
          38 kB
        18. FTPFile.png
          FTPFile.png
          40 kB
        19. Fw FEIN.msg
          150 kB
        20. image001.jpg
          image001.jpg
          4 kB
        21. image002.jpg
          image002.jpg
          1.0 kB
        22. image003.jpg
          image003.jpg
          1 kB
        23. image004.png
          image004.png
          1 kB
        24. image005.png
          image005.png
          5 kB
        25. image006.jpg
          image006.jpg
          64 kB
        26. image007.jpg
          image007.jpg
          2 kB
        27. image008.jpg
          image008.jpg
          2 kB
        28. image010.png
          image010.png
          0.6 kB
        29. Incorrect_FEIN_Employee_List.xls
          8 kB
        30. IRS Files Specs v1.7.0_received 11.16.2016.xlsx
          78 kB
        31. JAN2016_Emp (005).xls
          6.71 MB
        32. JIRA_663 screenshot_11.12.2016.docx
          120 kB
        33. Lake Huron Medical Grp.xlsx
          5.21 MB
        34. Mail Discussion.xls
          29 kB
        35. Manju Gupta.JPG
          Manju Gupta.JPG
          20 kB
        36. March_Malisa Moss_IncorrectBenefitTerminationDate.jpg
          March_Malisa Moss_IncorrectBenefitTerminationDate.jpg
          185 kB
        37. Micheal Ross.JPG
          Micheal Ross.JPG
          36 kB
        38. Prime_With_Space.xls
          11 kB
        39. Prime_WithoutSpace_09May16.xls
          10 kB
        40. Prime_WithoutSpace_Healthcare.xls
          11 kB
        41. Prime_WithoutSpace.xls
          10 kB
        42. Prime_WithoutSpace.xls
          9 kB
        43. Prime Benefit plan 2016.xls
          923 kB
        44. Prime Benefit plan 2016 - 21Jul2016.xls
          171 kB
        45. PrimeFTP.png
          PrimeFTP.png
          79 kB
        46. RE SecureIt - FW Data Book 15_received 11.16.2016.msg
          241 kB
        47. Review_Prime_CHMC_09June16.xls
          8 kB
        48. Review_Prime_Withoutspace_08Jun16.xls
          8 kB
        49. screenshot-1.png
          screenshot-1.png
          5 kB
        50. Updated_FEIN_Employee_List.xls
          9 kB
        51. Updated WorkTerra FEIN.xlsx
          12 kB
        52. Verified_Employee_List_PrimeWithSpace_07July16.xls
          10 kB
        53. WT_663 Data Book 15 example.xlsx
          15 kB
        54. WT-663_Jan2016_Emp.xls
          7.29 MB
        55. WT-663 01172017.docx
          156 kB
        56. WT-663 Data Book 8 (Orphan Employee Benefits) 11-9-16 revised.xlsx
          20 kB
        57. WT663 screenshot 01.18.2017.docx
          115 kB

          Issue Links

          relates to

          Support Activity - Support Activity WT-8076 Prime_Healthcare: Equifax ACA Reports

          • Medium - Has the potential to affect progress.
          • Resolved

          Support Activity - Support Activity WT-8253 EQUIFAX 2017 - Prime (no space) Healthcare

          • Critical - This problem will block progress.
          • Closed

            Activity

            Descending order - Click to sort in ascending order
            Hide
            Permalink
            alov Amber Love-Jones (Inactive) added a comment -

            Hello Yogesh Chaudhari,

            Yes, we can assume that the file set up for the 2016 files are true and correct. I will reopen the ticket if anything else arises.

            In the meantime, I will create a new JIRA ticket for the EQUIFAX file going forward.

            Thank you.

            Show
            alov Amber Love-Jones (Inactive) added a comment - Hello Yogesh Chaudhari , Yes, we can assume that the file set up for the 2016 files are true and correct. I will reopen the ticket if anything else arises. In the meantime, I will create a new JIRA ticket for the EQUIFAX file going forward. Thank you.
            Hide
            Permalink
            yogesh.chaudhari Yogesh Chaudhari (Inactive) added a comment -

            Hi Amber Love-Jones

            We are assuming that, files provided for year 2016 are perfect.

            Can you please close this ticket and open new Jira ticket for Prime files for year 2017 files?

            For sure we will provide monthly reports for prime on 10th of the each month.

            Jennifer JohnsonNandkumar Prabhakar KarlekarSachin HingoleMahendra MungaseBharti Satpute

            Show
            yogesh.chaudhari Yogesh Chaudhari (Inactive) added a comment - Hi Amber Love-Jones We are assuming that, files provided for year 2016 are perfect. Can you please close this ticket and open new Jira ticket for Prime files for year 2017 files? For sure we will provide monthly reports for prime on 10th of the each month. Jennifer Johnson Nandkumar Prabhakar Karlekar Sachin Hingole Mahendra Mungase Bharti Satpute
            Hide
            Permalink
            alov Amber Love-Jones (Inactive) added a comment -

            Hello Yogesh Chaudhari

            Please see Prime's response below:

            After deeper analysis on the Data Book 15 (orphan dependents), the files received by the benefit systems and the files transmitted to Equifax. I concluded that these orphan dependents are created by transmission of IRS Employee Benefits transactions from WORKTERRA and IRS Dependent Benefits transactions from LAWSON on the same FEIN.

            My apologies, the orphan dependents were created by my mistake not by WORKTERRA.

            Amber and Jennifer, at this point no action is required from WORKTERRA.

            Please resume with providing monthly reports for this client on the 10th of each month.

            Thank you!

            Show
            alov Amber Love-Jones (Inactive) added a comment - Hello Yogesh Chaudhari Please see Prime's response below: After deeper analysis on the Data Book 15 (orphan dependents), the files received by the benefit systems and the files transmitted to Equifax. I concluded that these orphan dependents are created by transmission of IRS Employee Benefits transactions from WORKTERRA and IRS Dependent Benefits transactions from LAWSON on the same FEIN. My apologies, the orphan dependents were created by my mistake not by WORKTERRA. Amber and Jennifer, at this point no action is required from WORKTERRA. Please resume with providing monthly reports for this client on the 10th of each month. Thank you!
            Hide
            Permalink
            yogesh.chaudhari Yogesh Chaudhari (Inactive) added a comment -

            Amber Love-Jones

            6 days back, we have already shared our views about mailed 686 dependents.
            Please refer attached Amber-workterra_Updated_Harbinger_17Jan17.xls file mentioned details about action needed against each records.
            Can you please join today's call at 8:30 AM PST? We have sent meeting request.

            If you can not join today's call or not receive meeting request, please let us know your convenient time or let us know your mobile number for call..

            Jennifer JohnsonNandkumar Prabhakar KarlekarMahendra MungaseSachin Hingole

            Show
            yogesh.chaudhari Yogesh Chaudhari (Inactive) added a comment - Amber Love-Jones 6 days back, we have already shared our views about mailed 686 dependents. Please refer attached Amber-workterra_Updated_Harbinger_17Jan17.xls file mentioned details about action needed against each records. Can you please join today's call at 8:30 AM PST? We have sent meeting request. If you can not join today's call or not receive meeting request, please let us know your convenient time or let us know your mobile number for call.. Jennifer Johnson Nandkumar Prabhakar Karlekar Mahendra Mungase Sachin Hingole
            Hide
            Permalink
            alov Amber Love-Jones (Inactive) added a comment -

            Hello Yogesh Chaudhari,

            Jennifer Fernandes and I had a call with the client this afternoon. They do not need to have the December reports run again. Jennifer Fernandes advised them of reports that they can run out of WorkTerra to capture termination dates entered at the facility level to the closest of their ability.

            One of the Prime employees did have the following question regarding dependent information:

            We transferred all IRS data to Equifax and we have the following dependents dropped from the 1095-C form (see attachment sent to Yogesh via email) due to missing employee benefits transaction or dependent transaction unable to map to an employee benefits transaction. The dependent benefit transaction has to match to four columns on the employee benefits transaction:

            1. EmployeeSSN
            2. EmployerFEIN
            3. BenefitsEffectiveDate
            4. BenefitsDecisionDate

            Please provide an employee benefits transaction for these dependents.

            Can you please review tonight so that we can provide an answer for Prime tomorrow (1/24/17)?

            Thank you!

            Show
            alov Amber Love-Jones (Inactive) added a comment - Hello Yogesh Chaudhari , Jennifer Fernandes and I had a call with the client this afternoon. They do not need to have the December reports run again. Jennifer Fernandes advised them of reports that they can run out of WorkTerra to capture termination dates entered at the facility level to the closest of their ability. One of the Prime employees did have the following question regarding dependent information: We transferred all IRS data to Equifax and we have the following dependents dropped from the 1095-C form (see attachment sent to Yogesh via email) due to missing employee benefits transaction or dependent transaction unable to map to an employee benefits transaction. The dependent benefit transaction has to match to four columns on the employee benefits transaction: 1. EmployeeSSN 2. EmployerFEIN 3. BenefitsEffectiveDate 4. BenefitsDecisionDate Please provide an employee benefits transaction for these dependents. Can you please review tonight so that we can provide an answer for Prime tomorrow (1/24/17)? Thank you!
            188 older comments

              People

              Assignee:
              jjsassy99 Jennifer Johnson (Inactive)
              Reporter:
              jjsassy99 Jennifer Johnson (Inactive)
              Account Executive:
              Jennifer Johnson (Inactive)
              Developer:
              Yogesh Chaudhari (Inactive)
              QA:
              Mahendra Mungase (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              12 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:
                Dev Due Date:

                  Time Tracking

                  Estimated:
                  Original Estimate - 24h Original Estimate - 24h
                  24h
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 137h 50m
                  137h 50m