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

Michael Best- Error in pulling Report issue

    Details

    • Type: Bug
    • Status: Production Complete
    • Priority: Critical
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: BenAdmin
    • Labels:
      None
    • Environment:
      Production
    • Bug Severity:
      Low
    • Module:
      BenAdmin - Report
    • Reported by:
      Client
    • Item State:
      Production Complete - Closed
    • Issue Importance:
      Must Have

      Description

      On field selection 'No. of working hours per day which 'is not in use so this is creating incorrect database query, which is resulting to error in generating report. The issue was reported in WT-8744

        Attachments

          Issue Links

            Activity

            Hide
            surender.kumar surender kumar (Inactive) added a comment -

            3C:

            Concern:Error in pulling Report issue on field selection on field selection No. of working hours per day

            Cause: No. of working hours per day field was pointing to the WorkedHoursPerweek which was same as No. of working hours per week hence make incorrect query.

            Correction: correction made such that No. of working hours per day field will not appear on Standard Report and Dynamic Report in Employee Related Fields.

            Impacted Areas:
            Employee Related Fields in following Reports
            Standard Report
            Dynamic Report

            Files effected:
            LB/Database Objects/MasterCompanyDB/07_Data/397_WT-4047_WTB_Repot_ModData_Fields.sql

            Tested below scenarios:
            Employee Related Fields in following Reports
            Standard Report
            Dynamic Report

            Show
            surender.kumar surender kumar (Inactive) added a comment - 3C: Concern:Error in pulling Report issue on field selection on field selection No. of working hours per day Cause: No. of working hours per day field was pointing to the WorkedHoursPerweek which was same as No. of working hours per week hence make incorrect query. Correction: correction made such that No. of working hours per day field will not appear on Standard Report and Dynamic Report in Employee Related Fields. Impacted Areas: Employee Related Fields in following Reports Standard Report Dynamic Report Files effected: LB/Database Objects/MasterCompanyDB/07_Data/397_ WT-4047 _WTB_Repot_ModData_Fields.sql Tested below scenarios: Employee Related Fields in following Reports Standard Report Dynamic Report
            Hide
            meghana.joshi Meghana Joshi (Inactive) added a comment - - edited

            Verified above issue on below types of Standard and Dynamic Report.

            1) Employee Census
            2) Dependent Census
            3) Eligibility
            4) Enrollment
            5) Billing Details
            6) Payroll Deduction
            7) System Utilization
            8) Benefit Wise Billing Details

            Working Fine

            CC - Sachin Hingole

            Show
            meghana.joshi Meghana Joshi (Inactive) added a comment - - edited Verified above issue on below types of Standard and Dynamic Report. 1) Employee Census 2) Dependent Census 3) Eligibility 4) Enrollment 5) Billing Details 6) Payroll Deduction 7) System Utilization 8) Benefit Wise Billing Details Working Fine CC - Sachin Hingole
            Hide
            meghana.joshi Meghana Joshi (Inactive) added a comment -

            Verified above issue on Stage for all types of Standard and Dynamic report.

            Working Fine

            CC - Sachin Hingole

            Show
            meghana.joshi Meghana Joshi (Inactive) added a comment - Verified above issue on Stage for all types of Standard and Dynamic report. Working Fine CC - Sachin Hingole
            Hide
            meghana.joshi Meghana Joshi (Inactive) added a comment -

            Verified on Production and it is working fine.

            Please verify from your side and Close Jira

            Show
            meghana.joshi Meghana Joshi (Inactive) added a comment - Verified on Production and it is working fine. Please verify from your side and Close Jira

              People

              Assignee:
              michelle.parker Michelle Parker (Inactive)
              Reporter:
              rakeshr Rakesh Roy (Inactive)
              Account Executive:
              Michelle Parker (Inactive)
              Developer:
              surender kumar (Inactive)
              QA:
              Meghana Joshi (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

                Dates

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

                  Time Tracking

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