WORKTERRAProject Type: software

WORKTERRA

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

Prime Healthcare > St. Mary and CHMC > HR Simplified COBRA discrepancies

    Details

    • Type: Support Activity
    • Status: Closed
    • Priority: High
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: BenAdmin
    • Labels:
      None
    • Support Task Type:
      Configuration
    • Environment:
      Production
    • Reported by:
      Client
    • Company:
      Prime Healthcare
    • Module:
      BenAdmin - Export
    • Issue Importance:
      Must Have
    • Severity:
      Simple
    • Reported by Customer:
      Jamie Davis at HR Simplified COBRA

      Description

      Client: Prime Healthcare
      Facility: Saint Mary Regional Medical Center and CHMC
      Group Template:
      Prime Healthcare_NEW HRSimplified_COBRA Coverage_Group
      Prime Healthcare_NEW HR Simplified COBRA Participant_Group
      Prime Healthcare_NEW HR Simplified COBRA DEPENDENT_Group
      Company Template affected:
      NEW HRSimplified_COBRA Coverage
      NEW HR Simplified COBRA Participant
      NEW HR Simplified COBRA DEPENDENT
      Export date: 01/03/2018 and 01/04/2018 files

      Hello Vinayak Kulkarni,

      The carrier has loaded the 01/03/2018 COBRA files . This was the file that you worked on with fixes, but there's only a small number of missing records/discrepancies. Another file with some issues is the 01/04/18 that went out last week from the scheduler (PT file failed and was manually exported). I am attaching the discrepancies. There are two tabs "01032018* and 01042018 on the spreadsheet correspond to the files.

      The files will go out again tomorrow from scheduler. Should we take them off schedule while this gets resolve? Let me know if you need additional info. Will provide password in separate email.

      Thank you,

      Alex

      Amber Love-Jones Van Nguyen

        Attachments

          Activity

          Descending order - Click to sort in ascending order
          Hide
          Permalink
          alexn Alex Nguyen added a comment -

          Hi Vinayak Kulkarni,

          I'll let you know if there's further issue with the files. Thank you again for the help!

          Alex

          Show
          alexn Alex Nguyen added a comment - Hi Vinayak Kulkarni , I'll let you know if there's further issue with the files. Thank you again for the help! Alex
          Hide
          Permalink
          Vinayak.Kulkarni Vinayak Kulkarni (Inactive) added a comment -

          File sent through scheduler yesterday, let us know if you hear any discrepancy other than duplicates. Thanks.

          Show
          Vinayak.Kulkarni Vinayak Kulkarni (Inactive) added a comment - File sent through scheduler yesterday, let us know if you hear any discrepancy other than duplicates. Thanks.
          Hide
          Permalink
          alexn Alex Nguyen added a comment -

          Thank you, Vinayak. Resending with all data since current year flag flipped in 2017 should take care of it. Sorry, I set the participant file to 'Yes' on the dashboard because it's a COBRA demographic file and thought it's required during OE. Will update documentation to not flip the flag on next OE. There is going to be a lot of discrepancies regarding duplicates that already processed, but we can ignore those as long as others are processed.

          Alex

          Show
          alexn Alex Nguyen added a comment - Thank you, Vinayak. Resending with all data since current year flag flipped in 2017 should take care of it. Sorry, I set the participant file to 'Yes' on the dashboard because it's a COBRA demographic file and thought it's required during OE. Will update documentation to not flip the flag on next OE. There is going to be a lot of discrepancies regarding duplicates that already processed, but we can ignore those as long as others are processed. Alex
          Hide
          Permalink
          Vinayak.Kulkarni Vinayak Kulkarni (Inactive) added a comment -

          Hi Alex,

          As discussed, we can ignore 01/03 discrepancies.

          For 01/04 file, it happened due to Current year flag was flipped to YES in 2017 for participant file and no flipping occurred for coverage file.

          We will delete 01/04 run-date from group files, I will delete flag flipping data for participant file so that all files comes to same state and will let go all data on today's file. Thanks.

          Show
          Vinayak.Kulkarni Vinayak Kulkarni (Inactive) added a comment - Hi Alex, As discussed, we can ignore 01/03 discrepancies. For 01/04 file, it happened due to Current year flag was flipped to YES in 2017 for participant file and no flipping occurred for coverage file. We will delete 01/04 run-date from group files, I will delete flag flipping data for participant file so that all files comes to same state and will let go all data on today's file. Thanks.
          Hide
          Permalink
          Vinayak.Kulkarni Vinayak Kulkarni (Inactive) added a comment - - edited

          Hi Alex, Will have look on this tonight and we will decide tomorrow whether to take files off scheduler or not. Thanks.

          Show
          Vinayak.Kulkarni Vinayak Kulkarni (Inactive) added a comment - - edited Hi Alex, Will have look on this tonight and we will decide tomorrow whether to take files off scheduler or not. Thanks.

            People

            Assignee:
            alexn Alex Nguyen
            Reporter:
            alexn Alex Nguyen
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: