There are several tables that hold configuration values that drive workflow and can cause reconciliation differences if configuration data is changed.

We need to keep an audit log.

Tasks to be performed:

1. Identify key tables
2. setup audit
3. script for new/demo/upgrade

Development meeting January 2018 Sanjay, Alvis, Sanjeet and Vineet.

Approved for development

1. The following changes were made(Include Database object names, Program classes and any other relevant information):|

1. Added a new menu in Web framework "Global -> Audit Data"
2. Created Audit framework to automatically create audit triggers based on table names
3. Configured audit on the following tables:
   1. Allowance/Benefit PR_ALLOW
   2. Bank SY_BANK
   3. Bank Accounts SY_BANK_ACCOUNT
   4. Bank Number Mapping SY_BANK_NumberMapping
   5. Branch Maintenance SY_BRANCH
   6. Calendar SY_CALENDAR
   7. Configuration LBS_CONFIG
   8. Cost Centre Maintenance SY_COSTCENTER
   9. Deduction PR_DEDUCT
   10. Direct Credit PR_EMP_PaySched
   11. Employee Payroll Tax PR_TAX_PAYE
   12. Employee Payroll Tax Scale PR_TAX_PAYE_SCALE
   13. Employee Positions HR_POSITION
   14. Employee Profile HR_EMPLOYEE
   15. Employee Profile Additional Tax PR_EMP_PAY_TaxScales
   16. Employee Profile Pay Details PR_EMP_PAY
   17. Employee Profile Service History LT_HRM_EmployeeService
   18. Employer Payroll Tax LT_PAY_STATE_RATES
   19. Employer Super Split PR_EMP_SuperSched
   20. Leave Maintenance HR_LEAVE
   21. Organisation Maintenance SY_Company
   22. Pay Codes PR_COMPONENT
   23. Pay Control PR_CONTROL
   24. Pay Rate PR_EMPRATE
   25. Pay Teams PR_PAY_GROUP
   26. Standard Pay PR_STD_PAY
   27. Territory Maintenance SY_DIVISION
   28. Work Shift HR_SHIFT
   29. Work Shift Allowance HR_SHIFT_ALLOWANCE
   30. Work Shift Time Control PR_TIME_CONTROL

Corrected issue with Audit form where the data refresh was not correctly loaded.

Proceed with UAT on 9.4

System test completed.

Verified the following:

1. Updated data in Work Shift menu in Payroll
2. Loaded Audit Data -> Work Shift and verified details on the grid
3. Date/Time columns should be formatted to show date and time. See screenshot below.

1. The following changes were made(Include Database object names, Program classes and any other relevant information):|

1. Date columns have been set to settings "g" which shows Time format based on regional settings.

System test completed.

Verified that date and time are displayed for date/time data.

Hi Alvis, 

This case has been tested.

Test Environment

• Version 9400 Beta 2
• Database - LINKSOFT on QA1
• Application on QA1
• OS- Windows 7

Test Plan

• Input data in the configured tables and audit data should be populated - Pass.
• The audit data should be clearly stated - Pass

Issue

The content on the page is too long for a day. Refer to data under LBS_Config. Users are required to scroll to the bottom to view details. Please add limit to the numbers of items displayed.

Notes: Documentation has been completed on the case. Global System -- Audit Data.

Thanks

Rashna

We will make the following changes:

1. Removed auto load when changing dates.
2. Increase Date Created column width
3. Add a search button.
4. Add a configurable limit to return the number of rows in the search. Default to 5000 rows.

1. The following changes were made(Include Database object names, Program classes and any other relevant information):|

1. Removed auto load when changing dates.
2. Increase Date Created column width
3. Add a search button.
4. Add a configurable limit to return the number of rows in the search. Default to 5000 rows.

System test completed.

Verified the following:

1. Removed auto load when changing dates. - Pass
2. Increase Date Created column width. Increasing column width does not add any value as the other columns would wrap the content. It is recommended to export the data to excel to filter and search.
3. Add a search button. - Pass
4. Add a configurable limit to return the number of rows in the search. Default to 5000 rows. -Pass

regards
Alvis

Hi Sanjay, 

This case has been successfully updated.

Documentation the case has been updated under Global System -- Audit Data.

Test Environment

• Version 9400 Beta 3
• Database - LINKSOFT on QA1
• Application on QA1
• OS - Windows 7

Test Plan

1. Set the "Date From" to "Date To" as 28/25/2018 and click on search. Audit data for the 28th should be loaded - Pass
2. Test data export in all formats - Pass
3. Search for transaction "RC000020" this should be successfully extracted - Pass

Thanks

Rashna