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

Caring Healthcare (Marshall Manor) - Historical Data Load

    Details

    • Type: Support Activity
    • Status: Resolved
    • Priority: Medium
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: BenAdmin
    • Labels:
      None
    • Support Task Type:
      Data Load
    • Environment:
      Stage
    • Reported by:
      White Label
    • Company:
      Caring Healthcare
    • Module:
      BenAdmin - Import
    • Severity:
      Simple

      Description

      I have uploaded the Caring Healthcare data to Samir's folder on the FTP site. Please review the data and provide your initial analysis tomorrow.

      Also can you please change "Marshall Manor" in Jira company list to "Caring Healthcare"

        Attachments

        1. BadFiles.7z
          17 kB
        2. caring_ACC_CI_Badfiles.zip
          18 kB
        3. image-2017-12-04-16-45-57-069.png
          image-2017-12-04-16-45-57-069.png
          6 kB
        4. screenshot-1.png
          screenshot-1.png
          15 kB

          Activity

          Hide
          jayshree.nagpure Jayshree Nagpure (Inactive) added a comment -

          Hi Snehal Katkar,

          Verified Data loaded on Caring healthcare for hspl on production

          Verified below imported data and following are observation :

          • Employee Import - Data imported correctly also core plans are allocated.
          • Spouse Import - Data imported correctly
          • Child Import - Data imported correctly
          • Medical Plan - For Medical Plan(PPO) employee and employer cost is zero, for other medical plans its looking correct.
          • Dental - Employees are enrolled in plan
          • Vision plan - Employees are enrolled in plan
          • Life Plan - Employees are enrolled in plan with proper coverage, except spouse not enrolled in Spouse voluntary Life plan as most of them went for bad record
          • Disability plan – Employees enrolled in plan with proper coverage
          • Acc CI Plan - For accident Plan cost and coverage showing zero and For critical illness cost is zero, coverage is proper.

          Thanks,
          Jayshree

          cc : Rakesh Roy Prasad Pise Jaideep Vinchurkar Hrishikesh Deshpande Sachin Hingole

          Show
          jayshree.nagpure Jayshree Nagpure (Inactive) added a comment - Hi Snehal Katkar , Verified Data loaded on Caring healthcare for hspl on production Verified below imported data and following are observation : Employee Import - Data imported correctly also core plans are allocated. Spouse Import - Data imported correctly Child Import - Data imported correctly Medical Plan - For Medical Plan(PPO) employee and employer cost is zero, for other medical plans its looking correct. Dental - Employees are enrolled in plan Vision plan - Employees are enrolled in plan Life Plan - Employees are enrolled in plan with proper coverage, except spouse not enrolled in Spouse voluntary Life plan as most of them went for bad record Disability plan – Employees enrolled in plan with proper coverage Acc CI Plan - For accident Plan cost and coverage showing zero and For critical illness cost is zero, coverage is proper. Thanks, Jayshree cc : Rakesh Roy Prasad Pise Jaideep Vinchurkar Hrishikesh Deshpande Sachin Hingole
          Hide
          snehal.katkar Snehal Katkar (Inactive) added a comment - - edited

          Hello Debbie,

          Please find attached zip folder for bad files. I have shared password with you in an email.
          QA verification is in progress. We will update you once it's done.

          Also, as mentioned above, Please check data file for Beneficiary and provide your inputs.

          BadFiles.7z

          Show
          snehal.katkar Snehal Katkar (Inactive) added a comment - - edited Hello Debbie, Please find attached zip folder for bad files. I have shared password with you in an email. QA verification is in progress. We will update you once it's done. Also, as mentioned above, Please check data file for Beneficiary and provide your inputs. BadFiles.7z
          Hide
          jaideep.vinchurkar Jaideep Vinchurkar (Inactive) added a comment -

          Hi Debbie Kulling,

          Our team is working on points reported by QA, meanwhile please look at the bad files and beneficiary file. ACC and CI plans are still under set up, we have loaded the data, but do you need us to load it again for ACC and CI?

          Show
          jaideep.vinchurkar Jaideep Vinchurkar (Inactive) added a comment - Hi Debbie Kulling , Our team is working on points reported by QA, meanwhile please look at the bad files and beneficiary file. ACC and CI plans are still under set up, we have loaded the data, but do you need us to load it again for ACC and CI?
          Hide
          ankur.deshpande Ankur Deshpande (Inactive) added a comment -

          Hi Debbie Kulling,

          I have attached the zip file of bad files for which I have mailed you the password.

          caring_ACC_CI_Badfiles.zip

          Regards,
          Ankur

          Show
          ankur.deshpande Ankur Deshpande (Inactive) added a comment - Hi Debbie Kulling , I have attached the zip file of bad files for which I have mailed you the password. caring_ACC_CI_Badfiles.zip Regards, Ankur
          Hide
          jaideep.vinchurkar Jaideep Vinchurkar (Inactive) added a comment -

          We are done with data load. Please reopen if any action is needed

          Show
          jaideep.vinchurkar Jaideep Vinchurkar (Inactive) added a comment - We are done with data load. Please reopen if any action is needed

            People

            Assignee:
            dkulling Debbie Kulling
            Reporter:
            dkulling Debbie Kulling
            Account Executive:
            Debbie Kulling
            Votes:
            0 Vote for this issue
            Watchers:
            6 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:

                Time Tracking

                Estimated:
                Original Estimate - Not Specified
                Not Specified
                Remaining:
                Remaining Estimate - 0h
                0h
                Logged:
                Time Spent - 43.5h
                43.5h