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

Employee effective date to expose on report

    Details

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

      Description

      On Five Guys company records on report are not as per Employee data. Please refer attached excel sheet for more details.

      We verified this issue at our end and we found in rdl query report consider Employee_Emergency EffectiveDate.

      CC- Jyoti Mayne,Satya

        Attachments

          Issue Links

            Activity

            Hide
            prasanna Prasanna Karlekar (Inactive) added a comment -

            Avnish Yadav,

            Converting this to change request as the Effective Date field exposed on Standard reports is from Employee_Emergency table. We need to change this field to show effective date from Employee table or add another field to display the employee effective date.

            Thank you!

            cc: Jyoti Mayne, Satya

            Show
            prasanna Prasanna Karlekar (Inactive) added a comment - Avnish Yadav , Converting this to change request as the Effective Date field exposed on Standard reports is from Employee_Emergency table. We need to change this field to show effective date from Employee table or add another field to display the employee effective date. Thank you! cc: Jyoti Mayne , Satya
            Hide
            meghana.joshi Meghana Joshi (Inactive) added a comment -

            Hi Prasanna Karlekar / surender kumar,

            Please find the attached test cases and let me know if any test cases needs to add .

            CC - Sachin Hingole

            Thanks,
            Meghana Kulkarni

            Show
            meghana.joshi Meghana Joshi (Inactive) added a comment - Hi Prasanna Karlekar / surender kumar , Please find the attached test cases and let me know if any test cases needs to add . CC - Sachin Hingole Thanks, Meghana Kulkarni
            Hide
            meghana.joshi Meghana Joshi (Inactive) added a comment -

            Verified all the attached test cases on LB for all types of standard report.
            Found one issue - WT-9020

            Dynamic Report testing is in progress.

            Venkatesh Pujari - Please update testing status of Invoice.

            CC - Sachin Hingole Prasanna Karlekar

            Show
            meghana.joshi Meghana Joshi (Inactive) added a comment - Verified all the attached test cases on LB for all types of standard report. Found one issue - WT-9020 Dynamic Report testing is in progress. Venkatesh Pujari - Please update testing status of Invoice. CC - Sachin Hingole Prasanna Karlekar
            Hide
            venkatesh.pujari Venkatesh Pujari (Inactive) added a comment -

            Hi [~meghana.kulkarni],

            I have tested the Invoice Management part and observed that the changes have been done and also working as expected. I verified this on Invoice as well as the file export from invoice.

            Thanks,
            Venkatesh

            Show
            venkatesh.pujari Venkatesh Pujari (Inactive) added a comment - Hi [~meghana.kulkarni] , I have tested the Invoice Management part and observed that the changes have been done and also working as expected. I verified this on Invoice as well as the file export from invoice. Thanks, Venkatesh
            Hide
            meghana.joshi Meghana Joshi (Inactive) added a comment -

            Verified all the attached test cases on LB for all types of standard report and Dynamic Report.
            Found one issue - WT-9020 and rest are working fine.

            Ready for Stage.

            CC - Sachin Hingole Prasanna Karlekar

            Show
            meghana.joshi Meghana Joshi (Inactive) added a comment - Verified all the attached test cases on LB for all types of standard report and Dynamic Report. Found one issue - WT-9020 and rest are working fine. Ready for Stage. CC - Sachin Hingole Prasanna Karlekar
            Hide
            meghana.joshi Meghana Joshi (Inactive) added a comment -

            Verified all the attached test cases on Stage for Standard and Dynamic Report.

            Working Fine.

            Venkatesh Pujari - Please update testing status of Invoice on Stage.

            CC - Sachin Hingole

            Show
            meghana.joshi Meghana Joshi (Inactive) added a comment - Verified all the attached test cases on Stage for Standard and Dynamic Report. Working Fine. Venkatesh Pujari - Please update testing status of Invoice on Stage. CC - Sachin Hingole
            Hide
            venkatesh.pujari Venkatesh Pujari (Inactive) added a comment -

            Hi [~meghana.kulkarni],

            I have tested the Invoice Management part and observed that the changes have been done and also working as expected. I verified this on Invoice as well as the file export from invoice.

            Thanks,
            Venkatesh

            Show
            venkatesh.pujari Venkatesh Pujari (Inactive) added a comment - Hi [~meghana.kulkarni] , I have tested the Invoice Management part and observed that the changes have been done and also working as expected. I verified this on Invoice as well as the file export from invoice. Thanks, Venkatesh
            Hide
            surender.kumar surender kumar (Inactive) added a comment -

            As per discussion with EDS team, Effective Date is getting displayed twice on Pending due to changes done for this enhancement.
            So reopen the issue.

            Regards,
            Surender Kumar

            Show
            surender.kumar surender kumar (Inactive) added a comment - As per discussion with EDS team, Effective Date is getting displayed twice on Pending due to changes done for this enhancement. So reopen the issue. Regards, Surender Kumar
            Hide
            surender.kumar surender kumar (Inactive) added a comment -

            Impacted Areas:
            Employee Effective Date and Emergency contact Effective Date should present Select Employee Fields section of Standard Report and Dynamic Report (except Commission Details, Fee Details).

            Last Login Date should not present in Select Employee Fields section of Standard Report and Dynamic Report .it only present in System Utilization report in System Utilization

            Also verify Effective Date is not getting displayed twice on Pending Queue

            Files effected:
            /Database Objects/MasterCompanyDB/04_Stored Procedures/dbo.OES_SP_Get_EmployeeFieldsForReports.StoredProcedure.sql

            Tested below scenarios:
            Standard Reports
            Dynamic Reports
            Pending Queue

            Show
            surender.kumar surender kumar (Inactive) added a comment - Impacted Areas: Employee Effective Date and Emergency contact Effective Date should present Select Employee Fields section of Standard Report and Dynamic Report (except Commission Details, Fee Details). Last Login Date should not present in Select Employee Fields section of Standard Report and Dynamic Report .it only present in System Utilization report in System Utilization Also verify Effective Date is not getting displayed twice on Pending Queue Files effected: /Database Objects/MasterCompanyDB/04_Stored Procedures/dbo.OES_SP_Get_EmployeeFieldsForReports.StoredProcedure.sql Tested below scenarios: Standard Reports Dynamic Reports Pending Queue
            Hide
            venkatesh.pujari Venkatesh Pujari (Inactive) added a comment -

            Hi [~meghana.kulkarni],

            I have tested the Invoice Management part on LB and observed that the changes have been done and also working as expected. I verified this on Invoice as well as the file export from invoice.

            Ready for Stage

            Thanks,
            Venkatesh

            Show
            venkatesh.pujari Venkatesh Pujari (Inactive) added a comment - Hi [~meghana.kulkarni] , I have tested the Invoice Management part on LB and observed that the changes have been done and also working as expected. I verified this on Invoice as well as the file export from invoice. Ready for Stage Thanks, Venkatesh
            Hide
            meghana.joshi Meghana Joshi (Inactive) added a comment -

            Verified all the attached test cases for Standard and Dynamic Report.
            Verified Pending Queue , Review Changes Pages.

            Working Fine.

            CC - Sachin Hingole

            Show
            meghana.joshi Meghana Joshi (Inactive) added a comment - Verified all the attached test cases for Standard and Dynamic Report. Verified Pending Queue , Review Changes Pages. Working Fine. CC - Sachin Hingole
            Hide
            meghana.joshi Meghana Joshi (Inactive) added a comment -

            Verified all the attached test cases for Standard and Dynamic Report on Stage
            Verified Pending Queue , Review Changes Pages.

            Working Fine.

            CC - Sachin Hingole

            Show
            meghana.joshi Meghana Joshi (Inactive) added a comment - Verified all the attached test cases for Standard and Dynamic Report on Stage Verified Pending Queue , Review Changes Pages. Working Fine. CC - Sachin Hingole

              People

              Assignee:
              meghana.joshi Meghana Joshi (Inactive)
              Reporter:
              avnish.yadav Avnish Yadav (Inactive)
              Developer:
              surender kumar (Inactive)
              QA:
              Meghana Joshi (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              4 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 - 60.25h
                  60.25h