Use this screen to view preset audit fields and to select/deselect additional fields to audit for changes, in accordance with Sarbanes-Oxley (SOX). The resulting audit tables provide an historical log of changes to key fields and tables that allow you and your auditors to determine any trends or irregular activities.
|
|
Note: This "WEB only" application requires a separate license to run. You must also have Lumigent 5.01 or higher to use the functionality within this interface. The combined Audit Field Tracking functions serve as a support device for auditors when adequate internal controls are a concern. Data generated by this application is not company specific. |
|
|
Special Note: To prevent unauthorized access to view or manipulate data within audit tables, access to this application should be very restrictive. Only users charged with Sarbanes-Oxley (SOX) and FAR 242.72 compliance and users actively involved in business control processes should have access to this application. Responsibility for maintenance of this application should reside with a senior level staff accountant - Comptroller or higher. |
The actual auditing of the field selections made in this screen is performed outside of Costpoint via a seamless interface with the AuditDB database auditing function provided by Lumigent Technologies. When this screen is opened, Costpoint checks AuditDB and displays a check in the Audit Flag checkbox for all fields selected for audit.
Save this screen to trigger the Lumigent auditing function.
|
|
Note: When you enter this screen for the first time, you will be asked to save the screen in order to synchronize the current Costpoint setup to the Lumigent AuditDB tool. This should be done at the time the system is initialized. |
View the results of this process in the Audit Field Tracking Report screen. Note that results are not available immediately. The processing time is controlled by Lumigent.
Use this screen routinely to track changes to key fields within the database. The choices made on this screen are sent to Lumigent where all changes made to the selected fields are recorded.
You may also use the Lumigent tool directly to select different fields to audit or to change the status of a field. This will override the selections made in this screen and users in Costpoint will not know what has been changed. In the future, Lumigent may be able to provide a report of changes made directly in their database. It is advisable not to make changes directly in the Lumigent tool until this report is available.
This application tracks:
Who made the change - records the user ID
When the change was made - records the date and time
What was changed - records the field and table
How the data changed - records both "before" and "after" values for the modified field
How the change was made - records whether the change was made through an application or with a database tool
The non-editable fields in this block display information enabling you to drill down to specific tables. Select a row in this block to display related field information in the Audit Field Tracking Detail block.
This field displays the ID for the domain:
AC - Accounting
PE - People
PB - Projects
MM - Materials
OT - Administration
This field displays the name associated with the Domain ID:
Accounting
People
Projects
Materials
Administration
This field displays the ID for the module within the selected domain.
This field displays the name of the module related to the Module ID.
This field displays the screen name within the selected module.
This field displays the ID for the table (or one of the tables) linked to the information on the selected screen. Each table linked to the selected screen displays on a new row.
This field displays the name associated with the Table ID.
The fields in this block list the details of the fields related to the table selected in the Identification block. Select the Audit Flag checkbox to include a field for auditing. The pre-checked (default) audit flags may also be excluded from the audit by un-checking the Audit Flag checkbox.
This field displays the name of the table selected in the Identification block.
This field displays the ID for one of the fields found in the selected table.
This field displays the name for the selected field ID.
Select this checkbox to include the selected field for audit. This checkbox is checked by default for preset audit fields.
You may un-check this checkbox to clear the preset audit for this field.
A check in this checkbox indicates a field pre-selected for auditing.
Select this pushbutton to populate all fields in the result set as selected for audit. The Audit Flag checkboxes will all be checked.
Lumigent is updated when this screen is saved.
Select this pushbutton to populate all fields in the result set as NOT selected for audit. The Audit Flag checkboxes will all be unselected.
Lumigent is updated when this screen is saved.
Reset All Fields to System Defaults
Select this pushbutton to populate all fields in the result set with the default information displayed in the Default Audit Flag field. The Audit Flag checkboxes are only checked if the corresponding default flag is checked.
Lumigent is updated when this screen is saved.
Data entered in this application is stored in the S_AUDIT_TRCKING table.
