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

          Issue Links

            Activity

            Hide
            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!
            Hide
            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
            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
            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
            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.

              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