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

            Ascending order - Click to sort in descending order
            Permalink
            mahendra.mungase Mahendra Mungase (Inactive) logged work - 23/Nov/16 06:11 AM
            • Time Spent:
              0.5h
               
              <No comment>
            Permalink
            yogesh.chaudhari Yogesh Chaudhari (Inactive) logged work - 23/Nov/16 06:13 AM
            • Time Spent:
              1h
               

              I have done analysis of feedback from client and reply.

            Permalink
            nandkumar Nandkumar Prabhakar Karlekar (Inactive) logged work - 23/Nov/16 01:00 PM
            • Time Spent:
              2h
               
              <No comment>
            Permalink
            nandkumar Nandkumar Prabhakar Karlekar (Inactive) logged work - 23/Nov/16 02:37 PM
            • Time Spent:
              5m
               
              <No comment>
            Permalink
            yogesh.chaudhari Yogesh Chaudhari (Inactive) logged work - 30/Nov/16 05:44 AM - edited
            • Time Spent:
              2h
               

              Discussion with team and call with the client

            Permalink
            sachin.hingole Sachin Hingole (Inactive) logged work - 30/Nov/16 09:57 AM
            • Time Spent:
              0.5h
               
              <No comment>
            Permalink
            revansiddha.gaur Revansiddha Gaur (Inactive) logged work - 30/Nov/16 10:03 AM
            • Time Spent:
              0.5h
               

              Internal Discussion.

            Permalink
            nandkumar Nandkumar Prabhakar Karlekar (Inactive) logged work - 30/Nov/16 02:38 PM
            • Time Spent:
              1h
               

              Analysis and discussion with yogesh

            Permalink
            mahendra.mungase Mahendra Mungase (Inactive) logged work - 30/Nov/16 05:12 PM
            • Time Spent:
              0.5h
               

              Discussion

            Permalink
            nandkumar Nandkumar Prabhakar Karlekar (Inactive) logged work - 01/Dec/16 10:23 AM
            • Time Spent:
              2h
               
              <No comment>
            Permalink
            sachin.hingole Sachin Hingole (Inactive) logged work - 01/Dec/16 01:26 PM
            • Time Spent:
              4h
               
              <No comment>
            Permalink
            yogesh.chaudhari Yogesh Chaudhari (Inactive) logged work - 01/Dec/16 02:58 PM
            • Time Spent:
              3h
               

              Exported file for Prime for Jan 2016

            Permalink
            mahendra.mungase Mahendra Mungase (Inactive) logged work - 05/Dec/16 12:17 PM
            • Time Spent:
              2h
               

              Discussion and reply for client comments

            Permalink
            nandkumar Nandkumar Prabhakar Karlekar (Inactive) logged work - 05/Dec/16 02:10 PM
            • Time Spent:
              0.5h
               
              <No comment>
            Permalink
            abhijeet.khandagale Abhijeet Khandagale (Inactive) logged work - 06/Dec/16 04:49 AM - edited
            • Time Spent:
              1h
               

              Analysis and resolution of client queries mentioned below,

              1. FEIN# 262887948 Knapp is on Employee file but NOT on Dependent file
              2. FEIN# 472819044 Suburban is on Employee file but Not on Dependent file, Should not be on either, we didn’t acquire them until 2/1/16
              3. FEIN# 208135307 BioMed is on Employee file but NOT on Dependent file
              4. FEIN# 473219615 Lake Huron Medical Grp is NOT on Employee file or on Dependent file
            Permalink
            yogesh.chaudhari Yogesh Chaudhari (Inactive) logged work - 06/Dec/16 09:58 AM
            • Time Spent:
              3.5h
               

              Analysis of Prime files issue and discussion with team.

            Permalink
            nandkumar Nandkumar Prabhakar Karlekar (Inactive) logged work - 06/Dec/16 12:28 PM
            • Time Spent:
              2h
               

              Prime audir

            Permalink
            mahendra.mungase Mahendra Mungase (Inactive) logged work - 06/Dec/16 05:32 PM
            • Time Spent:
              2h
               

              Discussion on feed back

            Permalink
            ramya.tantry Ramya Tantry (Inactive) logged work - 07/Dec/16 09:18 AM
            • Time Spent:
              0.5h
               

              Discussion with Nandkumar and Yogesh
              Analysis

            Permalink
            nandkumar Nandkumar Prabhakar Karlekar (Inactive) logged work - 07/Dec/16 12:28 PM
            • Time Spent:
              2h
               

              Employer change

            Permalink
            yogesh.chaudhari Yogesh Chaudhari (Inactive) logged work - 07/Dec/16 02:52 PM
            • Time Spent:
              7.5h
               

              Analysis and coding and exporting files for Jan 2016 and test this.

            Permalink
            mahendra.mungase Mahendra Mungase (Inactive) logged work - 07/Dec/16 03:07 PM
            • Time Spent:
              2h
               

              Testing of Prime Jan 16 file

            Permalink
            mahendra.mungase Mahendra Mungase (Inactive) logged work - 08/Dec/16 01:45 PM
            • Time Spent:
              0.5h
               
              <No comment>
            Permalink
            yogesh.chaudhari Yogesh Chaudhari (Inactive) logged work - 08/Dec/16 02:26 PM
            • Time Spent:
              0.5h
               

              Provide List of employee whose employer FEIN has changed by modifying its FEIN as per employee present in class in selected month.

            Permalink
            sachin.hingole Sachin Hingole (Inactive) logged work - 09/Dec/16 01:51 PM
            • Time Spent:
              2h
               
              <No comment>
            Permalink
            yogesh.chaudhari Yogesh Chaudhari (Inactive) logged work - 09/Dec/16 01:51 PM
            • Time Spent:
              7.5h
               

              Analysis of prime files as per request and export file for Jan 2016

            Permalink
            yogesh.chaudhari Yogesh Chaudhari (Inactive) logged work - 12/Dec/16 05:44 AM
            • Time Spent:
              1.5h
               

              Analysis of the data and provide inputs to client

            Permalink
            mahendra.mungase Mahendra Mungase (Inactive) logged work - 12/Dec/16 12:39 PM
            • Time Spent:
              1h
               

              Prime file discussion

            Permalink
            sachin.hingole Sachin Hingole (Inactive) logged work - 12/Dec/16 01:41 PM
            • Time Spent:
              1h
               
              <No comment>
            Permalink
            yogesh.chaudhari Yogesh Chaudhari (Inactive) logged work - 13/Dec/16 05:42 AM
            • Time Spent:
              10h
               

              Delete duplicate employee from the system and export files for first four months with all the required changes

            Permalink
            nandkumar Nandkumar Prabhakar Karlekar (Inactive) logged work - 13/Dec/16 08:15 AM
            • Time Spent:
              6h
               
              <No comment>
            Permalink
            abhijeet.khandagale Abhijeet Khandagale (Inactive) logged work - 13/Dec/16 01:10 PM
            • Time Spent:
              4h
               

              Eligibility processing on all prime companies.

            Permalink
            sachin.hingole Sachin Hingole (Inactive) logged work - 14/Dec/16 05:07 AM - edited
            • Time Spent:
              5.75h
               
              <No comment>
            Permalink
            revansiddha.gaur Revansiddha Gaur (Inactive) logged work - 14/Dec/16 05:11 AM
            • Time Spent:
              1h
               

              Employee ssn blank reason analysis.

            Permalink
            nandkumar Nandkumar Prabhakar Karlekar (Inactive) logged work - 14/Dec/16 12:24 PM
            • Time Spent:
              4h
               
              <No comment>
            Permalink
            abhijeet.khandagale Abhijeet Khandagale (Inactive) logged work - 14/Dec/16 01:23 PM
            • Time Spent:
              6.5h
               

              Data audit of 85 transferred prime employees.

            Permalink
            yogesh.chaudhari Yogesh Chaudhari (Inactive) logged work - 14/Dec/16 02:25 PM
            • Time Spent:
              7h
               

              Export files of Prime for All the months and did testing of all these files

            Permalink
            mahendra.mungase Mahendra Mungase (Inactive) logged work - 14/Dec/16 03:02 PM
            • Time Spent:
              8h
               

              Prime files testing

            Permalink
            yogesh.chaudhari Yogesh Chaudhari (Inactive) logged work - 02/Jan/17 02:44 PM
            • Time Spent:
              2.5h
               

              Run eligibility and start to export file for Dec 2016

            Permalink
            yogesh.chaudhari Yogesh Chaudhari (Inactive) logged work - 03/Jan/17 06:07 PM - edited
            • Time Spent:
              3.5h
               

              Export file for Prime all facilities for Dec 2016

            Permalink
            mahendra.mungase Mahendra Mungase (Inactive) logged work - 04/Jan/17 01:21 PM
            • Time Spent:
              4h
               

              DEC 16 file testing

            Permalink
            yogesh.chaudhari Yogesh Chaudhari (Inactive) logged work - 04/Jan/17 05:33 PM
            • Time Spent:
              1.5h
               

              Discussion with Qa team to discuss about issues faced in Prime file

            Permalink
            yogesh.chaudhari Yogesh Chaudhari (Inactive) logged work - 06/Jan/17 06:23 PM
            • Time Spent:
              1.5h
               

              Analysis of Automation of Prime files.

            Permalink
            yogesh.chaudhari Yogesh Chaudhari (Inactive) logged work - 17/Jan/17 08:46 AM
            • Time Spent:
              9.5h
               

              Meeting and discussion with team.
              Analysed issue reported by Prime and give them feedback. Calitnt call.

            Permalink
            mahendra.mungase Mahendra Mungase (Inactive) logged work - 17/Jan/17 11:31 AM - edited
            • Time Spent:
              3h
               

              Prime comments analysis and discussion

            Permalink
            nandkumar Nandkumar Prabhakar Karlekar (Inactive) logged work - 18/Jan/17 12:53 AM
            • Time Spent:
              1h
               
              <No comment>
            Permalink
            mahendra.mungase Mahendra Mungase (Inactive) logged work - 18/Jan/17 01:29 PM
            • Time Spent:
              0.5h
               

              Analysis and discussion on comments

            Permalink
            yogesh.chaudhari Yogesh Chaudhari (Inactive) logged work - 18/Jan/17 02:49 PM
            • Time Spent:
              1.5h
               

              Analysis and discussion of queries and feedback to client

            Permalink
            yogesh.chaudhari Yogesh Chaudhari (Inactive) logged work - 19/Jan/17 07:04 PM - edited
            • Time Spent:
              2h
               

              Analysis and provide feedback to client.

            Permalink
            nandkumar Nandkumar Prabhakar Karlekar (Inactive) logged work - 20/Jan/17 12:54 AM
            • Time Spent:
              1h
               
              <No comment>

              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