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

          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