Details

    • Type: Support Activity
    • Status: Closed
    • Priority: Critical
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: BenAdmin
    • Labels:
      None
    • Reported by:
      Support
    • Company:
      Prime Healthcare
    • Module:
      BenAdmin - Export

      Description

      Hi Dev,

      The HR Simplified file for Prime Healthcare (space) is not providing Overage Dependents. Here are some examples that have termed but are not on the files:

      Delvon Galloway, Andrea Adkins, Dalisha Johnson, Jeanette Domer, Michelle Simmons

      They are all with Centinela.

      Can you please review as to why they did not go over on the file?

      Thanks!

      David Rhodes Amit Thorve

        Attachments

        1. Event_Builder_OAD.png
          Event_Builder_OAD.png
          306 kB
        2. HR Simplified COBRA File Specifications 20111025.pdf
          362 kB
        3. OverAgeDependent Data.xls
          96 kB
        4. Prime_OAD_1.pdf
          492 kB
        5. Prime_OAD_2.pdf
          1.48 MB

          Activity

          Hide
          swapnil.pandhare Swapnil Pandhare (Inactive) added a comment -

          Hi Hrishikesh,

          Please review and assign to dev team if needed.

          Show
          swapnil.pandhare Swapnil Pandhare (Inactive) added a comment - Hi Hrishikesh, Please review and assign to dev team if needed.
          Hide
          rohan.khandave Rohan J Khandave (Inactive) added a comment -

          Please check

          Show
          rohan.khandave Rohan J Khandave (Inactive) added a comment - Please check
          Hide
          Vinayak.Kulkarni Vinayak Kulkarni (Inactive) added a comment -

          Hi Jennifer

          Prime HR simplified Cobra template uses new cobra reporting approach. And this approach has got this OAD issue.
          This is already reported to you, please refer attached emails.

          We are now analyzing this issue for possible solution. We will share details & ETA to you soon.

          Show
          Vinayak.Kulkarni Vinayak Kulkarni (Inactive) added a comment - Hi Jennifer Prime HR simplified Cobra template uses new cobra reporting approach. And this approach has got this OAD issue. This is already reported to you, please refer attached emails. We are now analyzing this issue for possible solution. We will share details & ETA to you soon.
          Hide
          amitthorve Amit Thorve (Inactive) added a comment -

          Samir, Sachin Khandge, Vinayak Kulkarni, Rohan J Khandave, We cannot have this issue. It is required by regulation to send a COBRA notice to overage dependent. This scenario is working with old implementation then why not with new one?

          Also as per my knowledge this implementation is love since last 7-8 months why we didnt fix the issue till now?

          CC - David Rhodes

          Show
          amitthorve Amit Thorve (Inactive) added a comment - Samir , Sachin Khandge , Vinayak Kulkarni , Rohan J Khandave , We cannot have this issue. It is required by regulation to send a COBRA notice to overage dependent. This scenario is working with old implementation then why not with new one? Also as per my knowledge this implementation is love since last 7-8 months why we didnt fix the issue till now? CC - David Rhodes
          Hide
          Vinayak.Kulkarni Vinayak Kulkarni (Inactive) added a comment -

          Hi Amit,

          Yes, This implementation is live since last 7-8 months but this issue was reported in November.
          Then we sent CCC for this issue & for correction we asked Dave's permission for code changes.
          As we did not receive response on that, so we followed up to same email but may be due to OE load & issues, it got missed from both the sides. You can refer attached email for this.

          We understand that this is critical issue & related to civil actions and tax penalties. We will get this resolved as early as possible. Meanwhile if you want OAD list from back-end then let us know.

          Show
          Vinayak.Kulkarni Vinayak Kulkarni (Inactive) added a comment - Hi Amit, Yes, This implementation is live since last 7-8 months but this issue was reported in November. Then we sent CCC for this issue & for correction we asked Dave's permission for code changes. As we did not receive response on that, so we followed up to same email but may be due to OE load & issues, it got missed from both the sides. You can refer attached email for this. We understand that this is critical issue & related to civil actions and tax penalties. We will get this resolved as early as possible. Meanwhile if you want OAD list from back-end then let us know.
          Hide
          amitthorve Amit Thorve (Inactive) added a comment -

          Vinayak Kulkarni Yes we need a report of all missed overage dependents (who are enrolled in the selected plans).

          CC- Amber Love-Jones, Jennifer Johnson

          Show
          amitthorve Amit Thorve (Inactive) added a comment - Vinayak Kulkarni Yes we need a report of all missed overage dependents (who are enrolled in the selected plans). CC- Amber Love-Jones , Jennifer Johnson
          Hide
          Vinayak.Kulkarni Vinayak Kulkarni (Inactive) added a comment -

          Aniruddha,

          Please check this on LB.

          CCC are given in attached email.

          File affected: Database stored procedure (OES_SP_Fetch_COBRAReason)

          Show
          Vinayak.Kulkarni Vinayak Kulkarni (Inactive) added a comment - Aniruddha, Please check this on LB. CCC are given in attached email. File affected: Database stored procedure (OES_SP_Fetch_COBRAReason)
          Hide
          rohan.khandave Rohan J Khandave (Inactive) added a comment -

          Amit Thorve Vinayak Kulkarni

          Hello,

          Please find attached over age dependent list.

          Show
          rohan.khandave Rohan J Khandave (Inactive) added a comment - Amit Thorve Vinayak Kulkarni Hello, Please find attached over age dependent list.
          Hide
          aniruddha.dev Aniruddha Dev (Inactive) added a comment -

          Hello Vinayak Kulkarni

          Verified this on LB by

          1) creating Overage Dependent Rule on Event Builder and Overage Dependent scenarios on for test employees with different tiers (EE+CH, EE+2CH, EE+SP+CH).
          2) Verified these scenarios on NEW HR Simplified COBRA Participant file.

          Overage Dependents records are exported on file with proper COBRA Reason.

          Also verified WT-687 along with this

          Working as expected on LB

          Show
          aniruddha.dev Aniruddha Dev (Inactive) added a comment - Hello Vinayak Kulkarni Verified this on LB by 1) creating Overage Dependent Rule on Event Builder and Overage Dependent scenarios on for test employees with different tiers (EE+CH, EE+2CH, EE+SP+CH). 2) Verified these scenarios on NEW HR Simplified COBRA Participant file. Overage Dependents records are exported on file with proper COBRA Reason. Also verified WT-687 along with this Working as expected on LB
          Hide
          rohan.khandave Rohan J Khandave (Inactive) added a comment -

          Hello ,

          Below are 3Cs for OAD issue.

          Concern: OAD are not populating on New Cobra Templates.

          Cause:
          1) Event builder rule is not defined: For new cobra feeds, event builder rule must be created for OAD. Please see screen shot for OAD event rule.

          2) We have also identified that, there are some code changes required to populate Cobra members if enrollment is terminated by Midnight service.

          Correction:
          1) Please create event in event builder for OAD.

          2) In Addition of creating OAD event rule, we also need to do code changes to populate OAD on cobra files.

          Show
          rohan.khandave Rohan J Khandave (Inactive) added a comment - Hello , Below are 3Cs for OAD issue. Concern: OAD are not populating on New Cobra Templates. Cause: 1) Event builder rule is not defined: For new cobra feeds, event builder rule must be created for OAD. Please see screen shot for OAD event rule. 2) We have also identified that, there are some code changes required to populate Cobra members if enrollment is terminated by Midnight service. Correction: 1) Please create event in event builder for OAD. 2) In Addition of creating OAD event rule, we also need to do code changes to populate OAD on cobra files.
          Hide
          hrishikesh.deshpande Hrishikesh Deshpande (Inactive) added a comment -

          Verified COBRA scenarios on Prime HSPL Company and it is working as expected..
          Scenario for Employee election dead and Overage dependent scenario is fixed now.

          Show
          hrishikesh.deshpande Hrishikesh Deshpande (Inactive) added a comment - Verified COBRA scenarios on Prime HSPL Company and it is working as expected.. Scenario for Employee election dead and Overage dependent scenario is fixed now.
          Hide
          jjsassy99 Jennifer Johnson (Inactive) added a comment -

          Hi All,

          I do not see a screen shot. Can you please send? Will this need to apply for every company? I want to make sure that everyone is aware. Is there a way to see what other OAD's are not going over for other clients?

          Jenni

          Show
          jjsassy99 Jennifer Johnson (Inactive) added a comment - Hi All, I do not see a screen shot. Can you please send? Will this need to apply for every company? I want to make sure that everyone is aware. Is there a way to see what other OAD's are not going over for other clients? Jenni
          Hide
          Vinayak.Kulkarni Vinayak Kulkarni (Inactive) added a comment -

          Jennifer,

          This issue was exists only for new cobra reporting type which is based on event builder. Older cobra logic does not have issues with OAD.

          If company is using new cobra reporting approach based on event builder then they must have cobra event defined in event builder. So to report OAD they must have OAD event configured as shown as attached, i just attached it.

          Please let us know if you have queries on this.

          Show
          Vinayak.Kulkarni Vinayak Kulkarni (Inactive) added a comment - Jennifer, This issue was exists only for new cobra reporting type which is based on event builder. Older cobra logic does not have issues with OAD. If company is using new cobra reporting approach based on event builder then they must have cobra event defined in event builder. So to report OAD they must have OAD event configured as shown as attached, i just attached it. Please let us know if you have queries on this.
          Hide
          Vinayak.Kulkarni Vinayak Kulkarni (Inactive) added a comment -

          Jennifer,

          This issue was exists only for new cobra reporting type which is based on event builder. Older cobra logic does not have issues with OAD.

          If company is using new cobra reporting approach based on event builder then they must have cobra event defined in event builder. So to report OAD they must have OAD event configured as shown as attached, i just attached it.

          Please let us know if you have queries on this.

          Show
          Vinayak.Kulkarni Vinayak Kulkarni (Inactive) added a comment - Jennifer, This issue was exists only for new cobra reporting type which is based on event builder. Older cobra logic does not have issues with OAD. If company is using new cobra reporting approach based on event builder then they must have cobra event defined in event builder. So to report OAD they must have OAD event configured as shown as attached, i just attached it. Please let us know if you have queries on this.
          Hide
          Vinayak.Kulkarni Vinayak Kulkarni (Inactive) added a comment - - edited

          We have also deployed this on Prime Healthcare Production. For other clients , we will deploy it in regular deployment process

          Show
          Vinayak.Kulkarni Vinayak Kulkarni (Inactive) added a comment - - edited We have also deployed this on Prime Healthcare Production. For other clients , we will deploy it in regular deployment process
          Hide
          rakeshr Rakesh Roy (Inactive) added a comment -

          Hrishikesh DeshpandeIs this a support task, if nit please change it to correct Type and also update the status.

          Show
          rakeshr Rakesh Roy (Inactive) added a comment - Hrishikesh Deshpande Is this a support task, if nit please change it to correct Type and also update the status.
          Hide
          jjsassy99 Jennifer Johnson (Inactive) added a comment -

          Is there a way to know who needs to add this? I am worried that the Admins are not aware of this - If this is new thing, then we need to make this a priority and figure out what clients are in need.

          I have added this to Production but I will need assistance on adding this to the carrier feed. Can someone please help with this ASAP?

          David Rhodes Jennifer Leugers Amit Thorve Steve Allison

          Thank you -

          Jenni

          Show
          jjsassy99 Jennifer Johnson (Inactive) added a comment - Is there a way to know who needs to add this? I am worried that the Admins are not aware of this - If this is new thing, then we need to make this a priority and figure out what clients are in need. I have added this to Production but I will need assistance on adding this to the carrier feed. Can someone please help with this ASAP? David Rhodes Jennifer Leugers Amit Thorve Steve Allison Thank you - Jenni
          Hide
          Vinayak.Kulkarni Vinayak Kulkarni (Inactive) added a comment -

          Jennifer Johnson
          There is no need to add it on carrier feed, feeds will start picking up OADs once you add it on company.

          But, please make sure that the reason "OAD" that you have put in this cobra event is expected.
          I believe it should be "DC" instead of "OAD" , but confirm with client before updating it.

          And yes, this is new thing but we have already provided set up guide for this & it has all these things are well mentioned.

          Let us know if you have any questions.

          Show
          Vinayak.Kulkarni Vinayak Kulkarni (Inactive) added a comment - Jennifer Johnson There is no need to add it on carrier feed, feeds will start picking up OADs once you add it on company. But, please make sure that the reason "OAD" that you have put in this cobra event is expected. I believe it should be "DC" instead of "OAD" , but confirm with client before updating it. And yes, this is new thing but we have already provided set up guide for this & it has all these things are well mentioned. Let us know if you have any questions.
          Hide
          amitthorve Amit Thorve (Inactive) added a comment -

          Vinayak Kulkarni and Jennifer Johnson Do we need to do anything from EDI side for this?

          Show
          amitthorve Amit Thorve (Inactive) added a comment - Vinayak Kulkarni and Jennifer Johnson Do we need to do anything from EDI side for this?
          Hide
          Vinayak.Kulkarni Vinayak Kulkarni (Inactive) added a comment -

          Amit Thorve

          No, we do not need to do anything from EDI perspective.
          Everything is set up properly & next file should pick up OADs.

          Show
          Vinayak.Kulkarni Vinayak Kulkarni (Inactive) added a comment - Amit Thorve No, we do not need to do anything from EDI perspective. Everything is set up properly & next file should pick up OADs.
          Hide
          jjsassy99 Jennifer Johnson (Inactive) added a comment -

          Amit Thorve - Someone will need to update the Code. I'm not sure what the code should be on the file. This would be based on HR Simplifed template - Maybe someone from EDI can assist - Van Nguyen can you help?

          Jenni

          Show
          jjsassy99 Jennifer Johnson (Inactive) added a comment - Amit Thorve - Someone will need to update the Code. I'm not sure what the code should be on the file. This would be based on HR Simplifed template - Maybe someone from EDI can assist - Van Nguyen can you help? Jenni
          Hide
          Van.Nguyen Van Nguyen (Inactive) added a comment -

          Sorry, Jennifer Johnson. I wouldn't be able to look into this since development generally manages how the terms get picked up on the back end of the database.

          Show
          Van.Nguyen Van Nguyen (Inactive) added a comment - Sorry, Jennifer Johnson . I wouldn't be able to look into this since development generally manages how the terms get picked up on the back end of the database.
          Hide
          Vinayak.Kulkarni Vinayak Kulkarni (Inactive) added a comment -

          Jennifer Johnson

          I have updated code to "DC" by confirming from specification document. You do not need to worry about it.
          I have also attached specification document for reference.

          Show
          Vinayak.Kulkarni Vinayak Kulkarni (Inactive) added a comment - Jennifer Johnson I have updated code to "DC" by confirming from specification document. You do not need to worry about it. I have also attached specification document for reference.
          Hide
          aniruddha.dev Aniruddha Dev (Inactive) added a comment -

          Hi Jennifer ,

          Please verify this at you end and Close this JIRA if its resolved .

          Let us know if we can help with any information ?

          Regards,
          Aniruddha

          Show
          aniruddha.dev Aniruddha Dev (Inactive) added a comment - Hi Jennifer , Please verify this at you end and Close this JIRA if its resolved . Let us know if we can help with any information ? Regards, Aniruddha
          Hide
          jjsassy99 Jennifer Johnson (Inactive) added a comment -

          Aniruddha Dev We can close this - we are looking at the OAD reports and comparing for future files - if we do not see them listed we will re-open.

          Jenni

          Show
          jjsassy99 Jennifer Johnson (Inactive) added a comment - Aniruddha Dev We can close this - we are looking at the OAD reports and comparing for future files - if we do not see them listed we will re-open. Jenni
          Hide
          jjsassy99 Jennifer Johnson (Inactive) added a comment -

          Jenni and team will run an OAD report to confirm that all OAD's will show as needed.

          Show
          jjsassy99 Jennifer Johnson (Inactive) added a comment - Jenni and team will run an OAD report to confirm that all OAD's will show as needed.

            People

            Assignee:
            jjsassy99 Jennifer Johnson (Inactive)
            Reporter:
            jjsassy99 Jennifer Johnson (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            9 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: