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

Rogers_UMR 1500_MED not exporting 2017 data information

    Details

    • Type: Analysis
    • Status: In Review
    • Priority: High
    • Resolution: Unresolved
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: BenAdmin
    • Labels:
      None
    • Environment:
      Production
    • Module:
      BenAdmin
    • Reported by:
      EDI
    • Company:
      Rogers Memorial Hospital
    • Item State:
      Development - In Analysis
    • Severity:
      Simple

      Description

      we have several employees that are exporting on the file but their plan information is not exporting. Example - 394906553 Alan,Joshua

      my build/mapping appears correct. the enrollment looks correct. can you assist on why these records are not exporting the plan information.

      Refer to positions 238 - 269 from the attached layout and prod file. Your assistance is appreciated.

      cc: Amanda Hagan

      PBEFL89_P_UHC_RogerMemorialHosp_201711300759_53658923049.txt 2017 UMR Standard Eligibility File - 1500 bytes.doc

        Attachments

          Activity

          Hide
          Prashant.samal Prashant Samal (Inactive) added a comment - - edited

          Hello Kevin Hale,

          There is no issue with the build/mapping.

          You have mapped Health Tier Policy No. in the mapping between positions 238 - 269 in layout on production file.

          After the verification from the backend, it is observed that Currently these employees do not have Health Tier Policy No in the system.

          Policy numbers which were active from 01/01/2017 - 12/31/2017 were termed with never effective date of 12/31/2016 on 11/16/2017.

          And the new policy no's for the plan are made effective from 01/01/2018 along with employee's change effective date of 01/01/2018
          Therefore presently these employees do not have policy numbers in the system due to which the plan information is blank on the files.

          Thanks
          S Prashant.
          __________________________________________
          Kevin Hale

          Show
          Prashant.samal Prashant Samal (Inactive) added a comment - - edited Hello Kevin Hale , There is no issue with the build/mapping. You have mapped Health Tier Policy No. in the mapping between positions 238 - 269 in layout on production file. After the verification from the backend, it is observed that Currently these employees do not have Health Tier Policy No in the system. Policy numbers which were active from 01/01/2017 - 12/31/2017 were termed with never effective date of 12/31/2016 on 11/16/2017. And the new policy no's for the plan are made effective from 01/01/2018 along with employee's change effective date of 01/01/2018 Therefore presently these employees do not have policy numbers in the system due to which the plan information is blank on the files. Thanks S Prashant. __________________________________________ Kevin Hale
          Hide
          Kevin.Hale Kevin Hale (Inactive) added a comment -

          Prashant Samal - thanks for your assistance

          Amanda Hagan - see the comments above. No active values to export. Let me know how to proceed.

          Show
          Kevin.Hale Kevin Hale (Inactive) added a comment - Prashant Samal - thanks for your assistance Amanda Hagan - see the comments above. No active values to export. Let me know how to proceed.
          Hide
          Amanda.Hagan Amanda Hagan (Inactive) added a comment -

          Hi Prashant Samal, are you saying they were termed with a date of 12/31/2016? The term date should have been 12/31/2017.

          Show
          Amanda.Hagan Amanda Hagan (Inactive) added a comment - Hi Prashant Samal , are you saying they were termed with a date of 12/31/2016? The term date should have been 12/31/2017.
          Hide
          Prashant.samal Prashant Samal (Inactive) added a comment -

          Yes Amanda Hagan, they were termed with 12/31/2016 earlier they were effective till 12/31/2017. this change happened on 11/16/2017.

          We can give this to enrollment team to find what caused this change:

          Jyoti Mayne:

          Issue : Policy numbers which were active from 01/01/2017 - 12/31/2017 were termed with never effective date of 12/31/2016 on 11/16/2017, can you please check what caused this and provide detailed view on same
          Sample Employee : social - 567456213 last name ACOSTA

          Show
          Prashant.samal Prashant Samal (Inactive) added a comment - Yes Amanda Hagan , they were termed with 12/31/2016 earlier they were effective till 12/31/2017. this change happened on 11/16/2017. We can give this to enrollment team to find what caused this change: Jyoti Mayne : Issue : Policy numbers which were active from 01/01/2017 - 12/31/2017 were termed with never effective date of 12/31/2016 on 11/16/2017, can you please check what caused this and provide detailed view on same Sample Employee : social - 567456213 last name ACOSTA
          Hide
          shailendra.honrao Shailendra Honrao (Inactive) added a comment -

          Hi Kevin Hale,

          Please find below details:

          Concern Policy Number active from 09/01/2017-12/31/2017 were termed as never effective.
          Cause We have analysed data for above mentioned EE Alan Joshua.
          • Prior to 11/16/2017, policy 'Plan B Choice Plus' was having eligibility rule set to Voluntary Life and All Active Status.
          • But on 11/16/2017, eligibility rule was changed to Deceased and policy number got recalculated from SA Utility, and EE policy number termed as never effective as he is ineligible.

          Thanks,
          Shailendra Honrao

          Cc: Amruta Lohiya,Jyoti Mayne

          Show
          shailendra.honrao Shailendra Honrao (Inactive) added a comment - Hi Kevin Hale , Please find below details: Concern Policy Number active from 09/01/2017-12/31/2017 were termed as never effective. Cause We have analysed data for above mentioned EE Alan Joshua. Prior to 11/16/2017, policy 'Plan B Choice Plus' was having eligibility rule set to Voluntary Life and All Active Status . But on 11/16/2017, eligibility rule was changed to Deceased and policy number got recalculated from SA Utility, and EE policy number termed as never effective as he is ineligible. Thanks, Shailendra Honrao Cc: Amruta Lohiya , Jyoti Mayne
          Hide
          Amanda.Hagan Amanda Hagan (Inactive) added a comment -

          Hi Shailendra Honrao, the Policy numbers should have termed 12/31/17. How do we get this corrected? We need to find out everyone that this has affected and get corrected.

          Kevin Hale Robyn Adkison

          Show
          Amanda.Hagan Amanda Hagan (Inactive) added a comment - Hi Shailendra Honrao , the Policy numbers should have termed 12/31/17. How do we get this corrected? We need to find out everyone that this has affected and get corrected. Kevin Hale Robyn Adkison
          Hide
          shailendra.honrao Shailendra Honrao (Inactive) added a comment - - edited

          Hi Amannda Johnson,

          In according to term policy number with 12/31/17 for EE Alan Joshua, please change eligibility rule of Plan B Choice Plus mapping.
          So that we will recalculate it.

          Thanks,
          Shailendra Honrao

          Cc: Amruta Lohiya ,Jyoti Mayne

          Show
          shailendra.honrao Shailendra Honrao (Inactive) added a comment - - edited Hi Amannda Johnson , In according to term policy number with 12/31/17 for EE Alan Joshua, please change eligibility rule of Plan B Choice Plus mapping. So that we will recalculate it. Thanks, Shailendra Honrao Cc: Amruta Lohiya , Jyoti Mayne
          Hide
          Robyn.Adkison Robyn Adkison (Inactive) added a comment -

          Hi Shailendra Honrao,
          In your previous message, it was mentioned that the eligibility rule was changed to "Deceased" for the plan design health tier mapping. Would you be able to let us know who changed this rule?
          Thanks
          Robyn

          Show
          Robyn.Adkison Robyn Adkison (Inactive) added a comment - Hi Shailendra Honrao , In your previous message, it was mentioned that the eligibility rule was changed to "Deceased" for the plan design health tier mapping. Would you be able to let us know who changed this rule? Thanks Robyn
          Hide
          shailendra.honrao Shailendra Honrao (Inactive) added a comment -

          Hi Robyn Adkison,

          The rule was changed by Cindy Wibbing on "2017-11-16 17:23:58.050"

          Thanks,
          Shailendra Honrao

          Cc;Amruta Lohiya, Jyoti Mayne

          Show
          shailendra.honrao Shailendra Honrao (Inactive) added a comment - Hi Robyn Adkison , The rule was changed by Cindy Wibbing on "2017-11-16 17:23:58.050" Thanks, Shailendra Honrao Cc; Amruta Lohiya , Jyoti Mayne
          Hide
          amitthorve Amit Thorve (Inactive) added a comment -

          Ganesh Sadawarte Can you please check this. We have to correct the numbers here.

          Call me if required. If you are not able to finish this in your work hours then assign it to Vinayak Kulkarni and ask him to call me.

          Show
          amitthorve Amit Thorve (Inactive) added a comment - Ganesh Sadawarte Can you please check this. We have to correct the numbers here. Call me if required. If you are not able to finish this in your work hours then assign it to Vinayak Kulkarni and ask him to call me.
          Hide
          amitthorve Amit Thorve (Inactive) added a comment -

          Cindy Wibbing, Amanda Hagan I assigned this to development person. We will co-ordinate together to get this fixed.

          Going forward if there is any feed issue or policy number issues related to EDI can you please copy me before sending it to development team. This issue must have got fixed 6 days back if handled with right communication.

          Show
          amitthorve Amit Thorve (Inactive) added a comment - Cindy Wibbing , Amanda Hagan I assigned this to development person. We will co-ordinate together to get this fixed. Going forward if there is any feed issue or policy number issues related to EDI can you please copy me before sending it to development team. This issue must have got fixed 6 days back if handled with right communication.
          Hide
          Amanda.Hagan Amanda Hagan (Inactive) added a comment -

          Amit Thorve I will make sure to include you on any more issues I have. Thank you!

          Show
          Amanda.Hagan Amanda Hagan (Inactive) added a comment - Amit Thorve I will make sure to include you on any more issues I have. Thank you!
          Hide
          Vinayak.Kulkarni Vinayak Kulkarni (Inactive) added a comment -

          Amit Thorve Calling you in few minutes.

          Show
          Vinayak.Kulkarni Vinayak Kulkarni (Inactive) added a comment - Amit Thorve Calling you in few minutes.
          Hide
          Vinayak.Kulkarni Vinayak Kulkarni (Inactive) added a comment -

          Hi Swapnil,

          We have policy numbers correction, Please check 2017 effective dates are populating when CY flag is YES and 2018 effective dates when CY flag is NO.

          Aniruddha Dev

          Show
          Vinayak.Kulkarni Vinayak Kulkarni (Inactive) added a comment - Hi Swapnil, We have policy numbers correction, Please check 2017 effective dates are populating when CY flag is YES and 2018 effective dates when CY flag is NO. Aniruddha Dev
          Hide
          swapnil.eksambekar Swapnil Eksambekar (Inactive) added a comment - - edited

          Hi Amit Thorve,

          Verified Rogers_UMR 1500_MED template with CY flag is YES ,2017 effective dates are populating as expected
          and CY flag NO, 2018 effective dates are populating as expected.

          So , assgining this to you.

          Thanks,
          Swapnil Eksambekar.

          CC-Rakesh RoyAniruddha DevHrishikesh Deshpande

          Show
          swapnil.eksambekar Swapnil Eksambekar (Inactive) added a comment - - edited Hi Amit Thorve , Verified Rogers_UMR 1500_MED template with CY flag is YES ,2017 effective dates are populating as expected and CY flag NO, 2018 effective dates are populating as expected. So , assgining this to you. Thanks, Swapnil Eksambekar. CC- Rakesh Roy Aniruddha Dev Hrishikesh Deshpande
          Hide
          amitthorve Amit Thorve (Inactive) added a comment -

          Swapnil Eksambekar Have you checked if 2018 policy numbers are also coming up when flag is set to NO?

          Show
          amitthorve Amit Thorve (Inactive) added a comment - Swapnil Eksambekar Have you checked if 2018 policy numbers are also coming up when flag is set to NO?
          Hide
          swapnil.eksambekar Swapnil Eksambekar (Inactive) added a comment - - edited

          Hello Amit Thorve,

          Yes, We have verified policy numbers also for 2018. Policy numbers exported properly along with its effective dates on file when CY flag is set to NO.

          Please let us know if we can help further on this.

          Thanks,
          Swapnil Eksambekar

          CC-Aniruddha DevRakesh RoyHrishikesh Deshpande

          Show
          swapnil.eksambekar Swapnil Eksambekar (Inactive) added a comment - - edited Hello Amit Thorve , Yes, We have verified policy numbers also for 2018. Policy numbers exported properly along with its effective dates on file when CY flag is set to NO . Please let us know if we can help further on this. Thanks, Swapnil Eksambekar CC- Aniruddha Dev Rakesh Roy Hrishikesh Deshpande

            People

            Assignee:
            amitthorve Amit Thorve (Inactive)
            Reporter:
            Kevin.Hale Kevin Hale (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            6 Start watching this issue

              Dates

              Created:
              Updated:

                Time Tracking

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