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

Southland - Record missing group #

    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:
      Data Correction
    • Environment:
      Production
    • Reported by:
      EDI
    • Company:
      Southland
    • Module:
      BenAdmin - Export
    • Issue Importance:
      Must Have
    • Severity:
      Simple
    • Provider & Benefits:
      Blue Cross of CA-Medical

      Description

      Group Template: _Southland Blue Cross
      Company Template: _BlueCross Med
      Export date: 12/08/17
      File Name: ebs_stds_8w_elig120820171857_16206047059.txt

      Hello Development Team,

      Employee, Jason Alcott, and his medical family coverage is missing group # 1885CP according to the discrepancy report. This employee has 2 natural children and 1 domestic partner child enrolled into the plan Blue Cross HSA 497-CA PPO Plan Option 1. There was a new health tier recently added in WT called Employee + Children + Domestic Partners Child. I updated the existing health tier mapping 1885CN 1885CP and map this to 1885CP. I did a recalc on this employee but the group # still coming out blank. Please see screenshots. Let me know if you need additional info. Their next file is going out this Friday. Hopefully this can be resolve before then.

      Thank you,

      Alex

      CC: Rachel Baker

        Attachments

        1. coverage.png
          coverage.png
          13 kB
        2. recalc.png
          recalc.png
          15 kB
        3. screenshot-1.png
          screenshot-1.png
          100 kB

          Activity

          Hide
          Vinayak.Kulkarni Vinayak Kulkarni (Inactive) added a comment -

          Hi Alex,

          When we add new health tier then all existing enrollment which fall under that health-tier must be updated first before any recalc.

          here, enrollment did not have new health tier associated because it was not created when enrollment added. Later when health tier added then it will not allocated policy number even if you do a recalc.

          We have now updated enrollment with healthtier and recalculated policy number. it will appear correctly on file.

          Also, For new tier, all rates and policy mappings must be updated. this enrollment do not have cost due to rate is not updated with new tier, see below.

          We have recalc rate too for affected employees once all rates are updated with new tier. thanks.

          Show
          Vinayak.Kulkarni Vinayak Kulkarni (Inactive) added a comment - Hi Alex, When we add new health tier then all existing enrollment which fall under that health-tier must be updated first before any recalc. here, enrollment did not have new health tier associated because it was not created when enrollment added. Later when health tier added then it will not allocated policy number even if you do a recalc. We have now updated enrollment with healthtier and recalculated policy number. it will appear correctly on file. Also, For new tier, all rates and policy mappings must be updated. this enrollment do not have cost due to rate is not updated with new tier, see below. We have recalc rate too for affected employees once all rates are updated with new tier. thanks.
          Hide
          alexn Alex Nguyen added a comment -

          Thank you for the detail explaination, Vinayak Kulkarni. Now I know where to check for the rates and making sure the new health tier is updated before the recalc. This is something I will check with CT next time to confirm completion of the new tier and rates. Thank you for the fix.

          Alex

          Show
          alexn Alex Nguyen added a comment - Thank you for the detail explaination, Vinayak Kulkarni . Now I know where to check for the rates and making sure the new health tier is updated before the recalc. This is something I will check with CT next time to confirm completion of the new tier and rates. Thank you for the fix. Alex
          Hide
          alexn Alex Nguyen added a comment -

          Closing JIRA ticket. I was able to verify the group # is now passing on the exported file for the affected employee and children. Deleted 1/2/18 run date.

          Show
          alexn Alex Nguyen added a comment - Closing JIRA ticket. I was able to verify the group # is now passing on the exported file for the affected employee and children. Deleted 1/2/18 run date.

            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: