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

          Activity

          umesh.kadam Umesh Kadam (Inactive) logged work - 13/Jul/17 04:30 PM
          • Time Spent:
            1h
             

            Issue discussion
            Default constraint Query Optimization R&D and discussion
            Code review
            Unit testing

          abhilash.warkari Abhilash Warkari (Inactive) logged work - 13/Jul/17 04:30 PM - edited
          • Time Spent:
            4h
             

            Analysis of the issue .
            Added a script for adding Default constraint on the column.

          umesh.kadam Umesh Kadam (Inactive) logged work - 14/Jul/17 04:30 PM
          • Time Spent:
            1h
             

            LB and UiRefresh code commit issue discussion with Kumar, Ashwin and Abhilash
            DB Code revert and correction

          alankar.chavan Alankar Chavan (Inactive) logged work - 18/Jul/17 12:48 PM
          • Time Spent:
            3h
             

            wt stage testing

          alankar.chavan Alankar Chavan (Inactive) logged work - 19/Jul/17 12:49 PM
          • Time Spent:
            1h
             

            stage testing

            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