WORKTERRAProject Type: software

WORKTERRA

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

In enrollment trigger, columns are mismatch so it is not tracking enrollment details.

    Details

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

      Description

      Barton Wright his ADD is not age reducing correctly. His age reduction should be the same as life with a volume of $169,000.00. The system for ADD is crediting $110,000 and re-billing at a volume of $260,000 February through current month of August. It looks like the system has not been doing the ADD age reductions correctly from the beginning. The system was reducing the amount to $110,000 versus $169,000

      Cc: Satya, Prasanna Karlekar, Gaurav Sodani

        Attachments

          Activity

          Ascending order - Click to sort in descending order
          Hide
          Permalink
          rohit.shete Rohit Shete (Inactive) added a comment -

          Hi Prasad Pise,

          Please find below 3C's:

          Concern: In enrollment trigger, columns are mismatch so it is not tracking enrollment details.
          Cause: Reduction details from enrollment intermediate table are not getting stored in enrollment_ intermediate_history-table.
          Correction: We have added code for this.

          Thanks and Regards,
          Rohit Shete.

          Cc: Jyoti Mayne

          Show
          rohit.shete Rohit Shete (Inactive) added a comment - Hi Prasad Pise , Please find below 3C's: Concern: In enrollment trigger, columns are mismatch so it is not tracking enrollment details. Cause: Reduction details from enrollment intermediate table are not getting stored in enrollment_ intermediate_history-table. Correction: We have added code for this. Thanks and Regards, Rohit Shete. Cc: Jyoti Mayne
          Hide
          Permalink
          hrishikesh.deshpande Hrishikesh Deshpande (Inactive) added a comment -

          This is working as expected on LB. Ready for Stage.

          Scenarios tested -

          1) Done Current enrollment and verified on Employee_Enrollment and Employee_Enrollment_history table that all triggers are proper.

          2) Done Future enrollment and verified on Employee_Enrollment_Intermediate and Employee_Enrollment_Intermediate_history table that all triggers are proper.

          3) Set Reduction coverage and observe that triggers are proper.

          Show
          hrishikesh.deshpande Hrishikesh Deshpande (Inactive) added a comment - This is working as expected on LB. Ready for Stage. Scenarios tested - 1) Done Current enrollment and verified on Employee_Enrollment and Employee_Enrollment_history table that all triggers are proper. 2) Done Future enrollment and verified on Employee_Enrollment_Intermediate and Employee_Enrollment_Intermediate_history table that all triggers are proper. 3) Set Reduction coverage and observe that triggers are proper.
          Hide
          Permalink
          hrishikesh.deshpande Hrishikesh Deshpande (Inactive) added a comment -

          We have tested this on Stage. Working as expected.

          Ready for Production.

          Show
          hrishikesh.deshpande Hrishikesh Deshpande (Inactive) added a comment - We have tested this on Stage. Working as expected. Ready for Production.
          Hide
          Permalink
          hrishikesh.deshpande Hrishikesh Deshpande (Inactive) added a comment -

          This issue is Fixed on Production.

          Show
          hrishikesh.deshpande Hrishikesh Deshpande (Inactive) added a comment - This issue is Fixed on Production.

            People

            Assignee:
            hrishikesh.deshpande Hrishikesh Deshpande (Inactive)
            Reporter:
            jyoti.mayne Jyoti Mayne
            Developer:
            Rohit Shete (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Dates

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

                Time Tracking

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