Subject: | Changing the employee ID from 321 does not change the ID in the Timesheet tables. |
Summary: | Issue: Changing the employee ID from 321 does not change the ID in the Timesheet tables. Steps - Log into PAFCO database.
- Log into ESS with user Tomasi. Go to Timesheet. User is able to review the time for employee 0061 from 01/01/2017.
- Change the employee ID for the employee from 0061 to AB96. Change the ID from 321.
- Log into ESS with user Tomasi. Go to Timesheet.
- The Employee ID is successfully changed.
- However, no records appear for the employee.
Diagnostic. - The employee ID is not changed in the LT_ESS_TimesheetImport_Archive. ID is still 0061.
Next. - Please validate the ID is successfully changed in the archive and staging tables when updated from 321.
Test Environment - Version - 10.1.1.2
- Database - CLIENT-PAFCO-LINKSOFT
- Server - 10.0.0.10
|
Audit Notes: | Edited by sanjay on 05/03/19 09:13. Edited by rashna on 06/11/18 14:43. |
06 Nov 2018 | 02:42PM Comment 1 by Rashna (Edge Business Solutions) Case 9692 added to project 10.1 |
07 Nov 2018 | 01:06PM Comment 2 by Sanjay (Link Technologies) Assigned To: Development Followup Date: 07-11-2018 01:06 PM Time Taken: 1.00 |
| Development work for this case has been completed. The change will be available in version: 10.1.1.3 1. The following changes were made(Include Database object names, Program classes and any other relevant information):| - Changed procedure for renaming employee id to include the following tables:
- LT_ESS_TimesheetImport_Archive
LT_ESS_TimesheetImport_EmployeeMapping LT_ESS_TimesheetImport_Staging LT_ESS_UnionRateEmployees
2. The issue was caused by: - Change "employee id" procedure was missing the ESS timesheet tables
3. Next Step - UAT
|
|
08 Nov 2018 | 08:17AM Comment 3 by Rashna (Edge Business Solutions) Assigned To: Sanjay (Link Technologies) Followup Date: 08-11-2018 08:17 AM Time Taken: 1.00 |
| Hi Sanjay QA Results Tests carried out according to requirements specified on the case header Test Results Summary Table 1 - Summarised list of issues No | Test Description | Pass/Fail | 1 | Created a timesheet for employee 0061. Validated that time for 01/01/2016 to 01/01/2016 is loaded for employee 0061. Validated the employee ID is 0061 under Employee Mapping.| Created an employee union rate for employee 0061. | Pass | 2 | Changed the employee ID from 0061 to AB96. | Pass | 3 | The prior timesheet should be seen for the employee under code AB96 | Pass | 4 | Validate that the employee mapping ID has been updated to AB96 | Pass | 5 | Validate that the employee ID has been updated for union rate | Pass | 6 | Create a new timesheet for the employee with ID AB96. This should be successfully seen under timesheets and | Pass |
Environment Details - OS version: Windows Server 2012
- Application version: 10
- Setup: Demo
- Server : 10.0.0.10
- Database: CLIENT-PAFCO-LINKSOFT
Steps to reproduce failed scenarios: Next Step: for closure
|
|
08 Nov 2018 | 08:48AM Comment 4 by Sanjay (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 08-11-2018 08:48 AM |
| Thanks Rashna |
|
09 Oct 2019 | 08:14AM Comment 5 by Sanjay (Link Technologies) Quality control status: Pass. QC Not required - This case was created before quality check was implemented in version 11 on 30/06/2019 |