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

Current Year flag is getting flipped AFTER OE start date (during OE window)

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Critical
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: None
    • Environment:
      Production
    • Bug Severity:
      Medium
    • Module:
      BenAdmin - Export
    • Reported by:
      Support
    • Company:
      Sunnyvale School District
    • Item State:
      Production Complete
    • Sprint:
      WT Sprint 40 - Bugs

      Description

      We are experiencing a problem where CY flag is being set back to YES after the EDI analyst had set it to NO manually. This happens during the open enrollment. We asked the following question last week and the response indicates that this behavior is not a feature but is a bug, We are experiencing it for the company Sunnyvale School District.

      _When a company is in open enrollment, does the flag-flip service that runs every night reset the Current year flag to YES? We ask because there was a case where EDI analyst manually set the flag to NO – and it got flipped the next day.
      _
      Vinayak Kulkarni responded:
      Current Year Flag Flipping to YES happens in below two cases

      • Current Flag will be changed to YES if OE Start Date is matched to today's date i.e. the date on which service runs)
      • Or if the OE start date is less than today's date and it is updated a day before service runs. (This second case was identified as a redundant check and WT-11585 asked for it's removal.)

      CC Amit Thorve Van Nguyen Nathaniel Cornejo-Walker Cindy Wibbing

        Attachments

          Issue Links

            Activity

            Hide
            Ganesh.sadawarte Ganesh Sadawarte (Inactive) added a comment - - edited

            Hi Abhay Patil,

            Please find below 3C's

            Concern: We are experiencing a problem where CY flag is being set back to YES after the EDI analyst had set it to NO manually.

            Cause: This issue is occurred due to the WT-11585 second point of Vinayak Kulkarni comments i'e redundant check for current year flag flipping.

            Correction: As we have removing redundant check for current year flag flipping under WT-11585,so going forward this issue will never occur.

            Affected files: OES_SP_Export_SetCurrentYearFlagToYESFromOpenEnrollmentDashboard

            Impacted Areas: OE dashbaord's SQL JOB which set Current year flag to YES on OE start date.

            Swapnil Eksambekar please check this scenario.

            Please let me know any details needed.

            CC-Vinayak Kulkarni,

            Thanks,
            Ganesh

            Show
            Ganesh.sadawarte Ganesh Sadawarte (Inactive) added a comment - - edited Hi Abhay Patil , Please find below 3C's Concern : We are experiencing a problem where CY flag is being set back to YES after the EDI analyst had set it to NO manually. Cause : This issue is occurred due to the WT-11585 second point of Vinayak Kulkarni comments i'e redundant check for current year flag flipping. Correction : As we have removing redundant check for current year flag flipping under WT-11585 ,so going forward this issue will never occur. Affected files : OES_SP_Export_SetCurrentYearFlagToYESFromOpenEnrollmentDashboard Impacted Areas : OE dashbaord's SQL JOB which set Current year flag to YES on OE start date. Swapnil Eksambekar please check this scenario. Please let me know any details needed. CC- Vinayak Kulkarni , Thanks, Ganesh
            Hide
            swapnil.eksambekar Swapnil Eksambekar (Inactive) added a comment -

            Verified this issue on LB,It is working as expected.
            Ready for stage.

            CC-Aniruddha DevHrishikesh DeshpandeRakesh Roy

            Show
            swapnil.eksambekar Swapnil Eksambekar (Inactive) added a comment - Verified this issue on LB,It is working as expected. Ready for stage. CC- Aniruddha Dev Hrishikesh Deshpande Rakesh Roy
            Hide
            swapnil.eksambekar Swapnil Eksambekar (Inactive) added a comment -

            verified this on Stage,it is working as expected.
            Ready for Production Deployment.

            CC-Aniruddha DevRakesh RoyHrishikesh Deshpande

            Show
            swapnil.eksambekar Swapnil Eksambekar (Inactive) added a comment - verified this on Stage,it is working as expected. Ready for Production Deployment. CC- Aniruddha Dev Rakesh Roy Hrishikesh Deshpande
            Hide
            gaurav.sodani Gaurav Sodani (Inactive) added a comment -

            Hi All,
            Attaching production deployment approval email for reference:
            !Re Request for Production deployment - 25 Nov 2017.msg
            Regards
            Gaurav

            Show
            gaurav.sodani Gaurav Sodani (Inactive) added a comment - Hi All, Attaching production deployment approval email for reference: !Re Request for Production deployment - 25 Nov 2017.msg Regards Gaurav
            Hide
            swapnil.eksambekar Swapnil Eksambekar (Inactive) added a comment -

            Verified this issue on production,It is working as expected.
            So assigning this ticket to you,please verify at your end and close it;

            Thanku,
            Swapnil E.

            CC-Aniruddha DevRakesh RoyHrishikesh DeshpandeGaurav Sodani

            Show
            swapnil.eksambekar Swapnil Eksambekar (Inactive) added a comment - Verified this issue on production,It is working as expected. So assigning this ticket to you,please verify at your end and close it; Thanku, Swapnil E. CC- Aniruddha Dev Rakesh Roy Hrishikesh Deshpande Gaurav Sodani
            Hide
            abhay.patil Abhay Patil (Inactive) added a comment -

            Nathaniel, can you please confirm that we no longer face this problem? Thanks!

            Show
            abhay.patil Abhay Patil (Inactive) added a comment - Nathaniel, can you please confirm that we no longer face this problem? Thanks!

              People

              Assignee:
              nwalker Nathaniel Cornejo-Walker (Inactive)
              Reporter:
              abhay.patil Abhay Patil (Inactive)
              Developer:
              Vinayak Kulkarni (Inactive)
              QA:
              Swapnil Eksambekar (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:
                Dev Due Date:
                Production Due Date:

                  Time Tracking

                  Estimated:
                  Original Estimate - 1h Original Estimate - 1h
                  1h
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 7h
                  7h