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

          Kevin.Hale Kevin Hale (Inactive) created issue -
          Prashant.samal Prashant Samal (Inactive) made changes -
          Field Original Value New Value
          Assignee Satya [ ID10004 ] Prashant Samal [ prashant.samal ]
          Prashant.samal Prashant Samal (Inactive) made changes -
          Status New [ 10508 ] In Analysis [ 10008 ]
          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
          Prashant.samal Prashant Samal (Inactive) made changes -
          Status In Analysis [ 10008 ] In Review [ 10203 ]
          Prashant.samal Prashant Samal (Inactive) made changes -
          Assignee Prashant Samal [ prashant.samal ] Kevin Hale [ 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.
          Kevin.Hale Kevin Hale (Inactive) made changes -
          Assignee Kevin Hale [ kevin.hale ] Amanda Hagan [ amanda.hagan ]
          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
          Prashant.samal Prashant Samal (Inactive) made changes -
          Assignee Amanda Hagan [ amanda.hagan ] Jyoti Mayne [ jyoti.mayne ]
          jyoti.mayne Jyoti Mayne made changes -
          Assignee Jyoti Mayne [ jyoti.mayne ] Shailendra Honrao [ shailendra.honrao ]
          shailendra.honrao Shailendra Honrao (Inactive) made changes -
          Item State Parent values: Development(10200)Level 1 values: In Analysis(10204)
          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
          shailendra.honrao Shailendra Honrao (Inactive) logged work - 01/Dec/17 08:35 AM
          • Time Spent:
            2h
             

            understanding of the problem statement
            discussion with jyoti
            analysis of issue with the help of jyoti
            draft comment and get it reviewed by jyoti

          shailendra.honrao Shailendra Honrao (Inactive) made changes -
          Assignee Shailendra Honrao [ shailendra.honrao ] Kevin Hale [ kevin.hale ]
          shailendra.honrao Shailendra Honrao (Inactive) made changes -
          Remaining Estimate 0h [ 0 ]
          Time Spent 2h [ 7200 ]
          Worklog Id 94211 [ 94211 ]
          jyoti.mayne Jyoti Mayne logged work - 01/Dec/17 10:38 AM
          • Time Spent:
            1h
             

            analysis and comment review

          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
          jyoti.mayne Jyoti Mayne made changes -
          Assignee Kevin Hale [ kevin.hale ] Shailendra Honrao [ shailendra.honrao ]
          jyoti.mayne Jyoti Mayne logged work - 04/Dec/17 09:46 AM - edited
          • Time Spent:
            0.5h
             

            discussion

          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
          shailendra.honrao Shailendra Honrao (Inactive) logged work - 04/Dec/17 12:49 PM
          • Time Spent:
            8h
             

            restore company,
            data analysis
            generate script to scan data
            discussion with jyoti

          shailendra.honrao Shailendra Honrao (Inactive) made changes -
          Assignee Shailendra Honrao [ shailendra.honrao ] Kevin Hale [ kevin.hale ]
          shailendra.honrao Shailendra Honrao (Inactive) made changes -
          Time Spent 2h [ 7200 ] 10h [ 36000 ]
          Worklog Id 94580 [ 94580 ]
          Kevin.Hale Kevin Hale (Inactive) made changes -
          Assignee Kevin Hale [ kevin.hale ] Amanda Hagan [ amanda.hagan ]
          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.
          amitthorve Amit Thorve (Inactive) made changes -
          Assignee Amanda Hagan [ amanda.hagan ] Ganesh Sadawarte [ ganesh.sadawarte ]
          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!
          Ganesh.sadawarte Ganesh Sadawarte (Inactive) logged work - 07/Dec/17 12:36 AM
          • Time Spent:
            2h
             

            Checked current year and 2018 policy numbers. On current and future export.

          Ganesh.sadawarte Ganesh Sadawarte (Inactive) made changes -
          Time Spent 10h [ 36000 ] 12h [ 43200 ]
          Worklog Id 95032 [ 95032 ]
          Ganesh.sadawarte Ganesh Sadawarte (Inactive) made changes -
          Assignee Ganesh Sadawarte [ ganesh.sadawarte ] Vinayak Kulkarni [ vinayak.kulkarni ]
          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
          Vinayak.Kulkarni Vinayak Kulkarni (Inactive) made changes -
          Assignee Vinayak Kulkarni [ vinayak.kulkarni ] Swapnil Eksambekar [ swapnil.eksambekar ]
          swapnil.eksambekar Swapnil Eksambekar (Inactive) logged work - 07/Dec/17 01:40 PM
          • Time Spent:
            1h
             
            <No comment>
          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
          swapnil.eksambekar Swapnil Eksambekar (Inactive) made changes -
          Time Spent 12h [ 43200 ] 13h [ 46800 ]
          Worklog Id 95150 [ 95150 ]
          Amanda.Hagan Amanda Hagan (Inactive) made changes -
          Attachment Copy of K35_T_EBSBenefits_Nasco_201712051214_24014469540 (003).xlsx [ 69566 ]
          Amanda.Hagan Amanda Hagan (Inactive) made changes -
          Comment [ Hi [~Kevin.Hale] and [~amitthorve],

          In a previous file the location codes were showing for everyone. [^Copy of K35_T_EBSBenefits_Nasco_201712051214_24014469540 (003).xlsx]. There was an issue on this file with the wrong effective date showing and we created ticket Wt-12473 to that corrected. ]
          Amanda.Hagan Amanda Hagan (Inactive) made changes -
          Attachment Copy of K35_T_EBSBenefits_Nasco_201712051214_24014469540 (003).xlsx [ 69566 ]
          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?
          Vinayak.Kulkarni Vinayak Kulkarni (Inactive) logged work - 07/Dec/17 05:24 PM
          • Time Spent:
            6h
             
            <No comment>
          jyoti.mayne Jyoti Mayne made changes -
          Time Spent 13h [ 46800 ] 13.25h [ 47700 ]
          Worklog Id 96480 [ 96480 ]
          jyoti.mayne Jyoti Mayne made changes -
          Time Spent 13.25h [ 47700 ] 13.5h [ 48600 ]
          Worklog Id 96480 [ 96480 ]
          jyoti.mayne Jyoti Mayne made changes -
          Time Spent 13.5h [ 48600 ] 14.5h [ 52200 ]
          Worklog Id 96507 [ 96507 ]
          swapnil.eksambekar Swapnil Eksambekar (Inactive) logged work - 18/Dec/17 09:43 AM
          • Time Spent:
            2.5h
             

            Discussion with aniruddha
            Verification of policy numbers

          swapnil.eksambekar Swapnil Eksambekar (Inactive) made changes -
          Assignee Swapnil Eksambekar [ swapnil.eksambekar ] Amit Thorve [ amitthorve ]
          swapnil.eksambekar Swapnil Eksambekar (Inactive) made changes -
          Time Spent 14.5h [ 52200 ] 17h [ 61200 ]
          Worklog Id 96613 [ 96613 ]
          swapnil.eksambekar Swapnil Eksambekar (Inactive) made changes -
          Comment [ Hello [~amitthorve],

          We have verified 2018 policy numbers when flag is set to NO , They are coming as expected .


          Thanks,
          Swapnil e.

          CC-[~aniruddha.dev][~rakeshr][~hrishikesh.deshpande] ]
          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
          Vinayak.Kulkarni Vinayak Kulkarni (Inactive) made changes -
          Time Spent 17h [ 61200 ] 23h [ 82800 ]
          Worklog Id 96757 [ 96757 ]
          Transition Time In Source Status Execution Times
          Prashant Samal (Inactive) made transition -
          NEW In Analysis
          3h 25m 1
          Prashant Samal (Inactive) made transition -
          In Analysis In Review
          1h 55m 1

            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