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

Austin - Additional Eligibility

    Details

    • Type: Bug
    • Status: Production Complete
    • Priority: Medium
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: None
    • Environment:
      Stage
    • Bug Severity:
      Medium
    • Module:
      BenAdmin - EDS
    • Reported by:
      Support
    • Company:
      Austin
    • Item State:
      Production Complete - Closed
    • Sprint:
      WT Sprint 40 - Bugs, WT- Sprint 43

      Description

      Hi Dev -

      It looks like when the copy from Prod to stage was completed, there was an error with the additional eligibility for the following plans: (2018 are new but cloned)

      2018 Tobacco Employee and Spouse Surcharge 01/01/2018 0 Rate Mapped
      2018 Tobacco Employee and Spouse Surcharge Industrial 01/01/2018 0 Rate Mapped
      2018 Tobacco Surcharge Industrial 01/01/2018 0 Rate Mapped
      2018 Tobacco Surcharge Plan 01/01/2018 0 Rate Mapped
      Tobacco Surcharge Industrial 01/01/2017 - 12/31/2017 2 Rates Mapped
      Tobacco Surcharge Plan 01/01/2017 - 12/31/2017 2 Rates Mapped

      The form " Tobacco Affidavit Form" (Renamed from Tobacco Affidavit 2017) is showing up as
      "Preferred Email" - This was there even before we changed the form name.

      Can you please look into this ASAP?

      Thanks!
      Jenni

        Attachments

        1. LB.jpg
          LB.jpg
          155 kB
        2. screenshot-1.png
          screenshot-1.png
          20 kB
        3. WT_11664LB.jpg
          WT_11664LB.jpg
          147 kB
        4. WT-11664_Stage_prod_data.xlsx
          12 kB

          Activity

          Hide
          jjsassy99 Jennifer Johnson (Inactive) added a comment -

          Show
          jjsassy99 Jennifer Johnson (Inactive) added a comment -
          Hide
          rohit.shete Rohit Shete (Inactive) added a comment -

          Hi Jennifer Johnson

          Please provide us sample employee detail who have issue.

          Thanks And Regards,
          Rohit Shete.

          CC:Amruta Lohiya,Rohan J Khandave

          Show
          rohit.shete Rohit Shete (Inactive) added a comment - Hi Jennifer Johnson Please provide us sample employee detail who have issue. Thanks And Regards, Rohit Shete. CC: Amruta Lohiya , Rohan J Khandave
          Hide
          amit.kumawat Amit Kumawat (Inactive) added a comment - - edited

          Hello,

          Concern:-
          Austin - Additional Eligibility.
          Cause:-
          While updating page field configuration, if base field and additional field id's are same, additional field display label was getting updated.
          Correction:-
          We have handled this while updating page field configuration.

          Impacted Areas:- Eligibility on Fields.
          Affected files:- OES_TR_FIELDS_AFT_UPD.Trigger.sql, OES_TR_FIELDS_AFT_DEL.Trigger.sql

          Note: There was also issue with delete trigger, so made changes accordingly in delete trigger.

          CC: Swapnil Pandhare, Sheetal Bodhale, Satya

          Thanks & Regards,
          Amit Kumawat

          Show
          amit.kumawat Amit Kumawat (Inactive) added a comment - - edited Hello, Concern :- Austin - Additional Eligibility. Cause :- While updating page field configuration, if base field and additional field id's are same, additional field display label was getting updated. Correction :- We have handled this while updating page field configuration. Impacted Areas :- Eligibility on Fields. Affected files :- OES_TR_FIELDS_AFT_UPD.Trigger.sql, OES_TR_FIELDS_AFT_DEL.Trigger.sql Note: There was also issue with delete trigger, so made changes accordingly in delete trigger. CC: Swapnil Pandhare , Sheetal Bodhale , Satya Thanks & Regards, Amit Kumawat
          Hide
          amit.kumawat Amit Kumawat (Inactive) added a comment -

          Hello Jennifer Johnson,

          We have executed script at Austin company for now and for others script will be executed with patch.

          CC: Swapnil Pandhare, Sheetal Bodhale, Satya

          Thanks & Regards,
          Amit Kumawat

          Show
          amit.kumawat Amit Kumawat (Inactive) added a comment - Hello Jennifer Johnson , We have executed script at Austin company for now and for others script will be executed with patch. CC: Swapnil Pandhare , Sheetal Bodhale , Satya Thanks & Regards, Amit Kumawat
          Hide
          amit.kumawat Amit Kumawat (Inactive) added a comment - - edited

          Hello Sheetal Bodhale,

          As per discussion with Swapnil Pandhare, we have found duplicate Display Label in attached companies list at Stage & Production.
          Please find attached document and make data corrections in listed companies by Monday 23-Oct.-2017.

          CC: Sheetal Bodhale, Swapnil Pandhare, Satya

          Thanks & Regards,
          Amit Kumawat

          Show
          amit.kumawat Amit Kumawat (Inactive) added a comment - - edited Hello Sheetal Bodhale , As per discussion with Swapnil Pandhare , we have found duplicate Display Label in attached companies list at Stage & Production . Please find attached document and make data corrections in listed companies by Monday 23-Oct.-2017. CC: Sheetal Bodhale , Swapnil Pandhare , Satya Thanks & Regards, Amit Kumawat
          Hide
          sachin.hingole Sachin Hingole (Inactive) added a comment -

          [~meghana joshi]

          Show
          sachin.hingole Sachin Hingole (Inactive) added a comment - [~meghana joshi]
          Hide
          priya.handepatil Priya Handepatil (Inactive) added a comment -

          Hi Amit Kumawat

          I have verified this issue on LB

          Verified with Partner login

          Verified with Company " City Of Durham"

          Its working fine

          Hence, Marking it as Ready for stage

          cc: Sachin Hingole Prasad Pise Rakesh Roy Hrishikesh Deshpande

          Thank You !

          Show
          priya.handepatil Priya Handepatil (Inactive) added a comment - Hi Amit Kumawat I have verified this issue on LB Verified with Partner login Verified with Company " City Of Durham" Its working fine Hence, Marking it as Ready for stage cc: Sachin Hingole Prasad Pise Rakesh Roy Hrishikesh Deshpande Thank You !
          Hide
          rashmita.dudhe Rashmita Dudhe (Inactive) added a comment -

          Verified on Stage consider below scenarios:

          1]Add tow three Fileds on an additional form
          2]additonal eligibility criteria used above fields.
          3]Change Fileds name on the additional form.
          4]Cross verified on eligibility criteria.
          5]Clone the filed and cross verified on eligibility criteria.
          6]not showing any duplicate filed name

          working fine as expected

          Show
          rashmita.dudhe Rashmita Dudhe (Inactive) added a comment - Verified on Stage consider below scenarios: 1]Add tow three Fileds on an additional form 2]additonal eligibility criteria used above fields. 3]Change Fileds name on the additional form. 4]Cross verified on eligibility criteria. 5]Clone the filed and cross verified on eligibility criteria. 6]not showing any duplicate filed name working fine as expected
          Hide
          rashmita.dudhe Rashmita Dudhe (Inactive) added a comment -

          Verified on production consider below scenarios:
          1]Add tow three Fileds on an additional form
          2]additonal eligibility criteria used above fields.
          3]Change Fileds name on the additional form.
          4]Cross verified on eligibility criteria.
          5]Clone the filed and cross verified on eligibility criteria.
          6]not showing any duplicate filed name
          working fine as expected

          Show
          rashmita.dudhe Rashmita Dudhe (Inactive) added a comment - Verified on production consider below scenarios: 1]Add tow three Fileds on an additional form 2]additonal eligibility criteria used above fields. 3]Change Fileds name on the additional form. 4]Cross verified on eligibility criteria. 5]Clone the filed and cross verified on eligibility criteria. 6]not showing any duplicate filed name working fine as expected
          Hide
          rashmita.dudhe Rashmita Dudhe (Inactive) added a comment -

          Hi Jennifer Johnson

          This is Deployed and Verified on production.
          Kindly, Update Jira accordingly.

          Thanks,
          Rashmita

          Show
          rashmita.dudhe Rashmita Dudhe (Inactive) added a comment - Hi Jennifer Johnson This is Deployed and Verified on production. Kindly, Update Jira accordingly. Thanks, Rashmita

            People

            Assignee:
            jjsassy99 Jennifer Johnson (Inactive)
            Reporter:
            jjsassy99 Jennifer Johnson (Inactive)
            Developer:
            Amit Kumawat (Inactive)
            QA:
            Priya Handepatil (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            6 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:
              Dev Due Date:
              Pre-Prod Due Date:
              Production Due Date:
              Code Review Date:

                Time Tracking

                Estimated:
                Original Estimate - 0h
                0h
                Remaining:
                Remaining Estimate - 0h
                0h
                Logged:
                Time Spent - 54.25h
                54.25h