WORKTERRAProject Type: software

WORKTERRA

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

IsApprovlPending is Null in Employee_Enrollment_WaivedbenefitTypes

    Details

    • Type: Bug
    • Status: Closed
    • Priority: High
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: None
    • Labels:
      None
    • Environment:
      Production
    • Bug Severity:
      Medium
    • Module:
      BenAdmin - Enrollment
    • Reported by:
      Harbinger
    • Item State:
      Production Complete - Closed
    • Sprint:
      WT Sprint 32-Bugs

      Description

      The eligibility routine was getting failed after import. When analysed, we found the value for IsApprovalPending is null in given table.

      We could not judge the reason but there's no default constraint for the column as it exists on Employee_Enrollment.

      The Default constraint may solve the issue.

      CC- Jaideep Vinchurkar, Amruta Lohiya, Avnish Yadav

        Attachments

        1. WT-10100 Code Review Checklist.doc
          26 kB
          Abhilash Warkari
        2. WT-10100 Affected Files.txt
          0.3 kB
          Abhilash Warkari

          Activity

          Ascending order - Click to sort in descending order
          Hide
          Permalink
          abhilash.warkari Abhilash Warkari (Inactive) added a comment -

          HI

          Please find below 3Cs :

          Concern IsApprovlPending is Null in Employee_Enrollment_WaivedbenefitTypes
          Cause There was no default constraint on IsApprovalPending column so value was set as Null
          Correction We have added default constraint on IsApprovalPending column to avoid value to be set as null

          Thanks and Regards
          Abhilash Warkari

          CC :Jyoti Mayne,Umesh Kadam

          Show
          abhilash.warkari Abhilash Warkari (Inactive) added a comment - HI Please find below 3Cs : Concern IsApprovlPending is Null in Employee_Enrollment_WaivedbenefitTypes Cause There was no default constraint on IsApprovalPending column so value was set as Null Correction We have added default constraint on IsApprovalPending column to avoid value to be set as null Thanks and Regards Abhilash Warkari CC : Jyoti Mayne , Umesh Kadam
          Hide
          Permalink
          alankar.chavan Alankar Chavan (Inactive) added a comment -

          This is tested on WT Stage - Worked Well

          Default constraint has been added with the column IsApprovalPending.
          By default the value for this field is Zero. When a Waive request goes for admin approval - this value becomes 1

          Ready for Stage

          CC - Sachin Hingole Prasad Pise Rakesh Roy Hrishikesh Deshpande

          Show
          alankar.chavan Alankar Chavan (Inactive) added a comment - This is tested on WT Stage - Worked Well Default constraint has been added with the column IsApprovalPending. By default the value for this field is Zero. When a Waive request goes for admin approval - this value becomes 1 Ready for Stage CC - Sachin Hingole Prasad Pise Rakesh Roy Hrishikesh Deshpande
          Hide
          Permalink
          alankar.chavan Alankar Chavan (Inactive) added a comment -

          This is tested on Stage - Worked Well

          Default constraint has been added with the column IsApprovalPending.
          By default the value for this field is Zero. When a Waive request goes for admin approval - this value becomes 1

          Ready for Production

          CC - Sachin Hingole Prasad Pise Rakesh Roy Hrishikesh Deshpande

          Show
          alankar.chavan Alankar Chavan (Inactive) added a comment - This is tested on Stage - Worked Well Default constraint has been added with the column IsApprovalPending. By default the value for this field is Zero. When a Waive request goes for admin approval - this value becomes 1 Ready for Production CC - Sachin Hingole Prasad Pise Rakesh Roy Hrishikesh Deshpande
          Hide
          Permalink
          alankar.chavan Alankar Chavan (Inactive) added a comment -

          This is tested on Production - Worked Well

          CC - Prasad Pise Rakesh Roy

          Show
          alankar.chavan Alankar Chavan (Inactive) added a comment - This is tested on Production - Worked Well CC - Prasad Pise Rakesh Roy

            People

            Assignee:
            alankar.chavan Alankar Chavan (Inactive)
            Reporter:
            suraj.sokasane Suraj Sokasane (Inactive)
            Developer:
            Abhilash Warkari (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:
              Dev Due Date:
              Code Review Date:

                Time Tracking

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