Use this screen to print a report that displays an historical record of changes made to fields selected for audit in the Audit Field Tracking screen (Administration\Maintain\Audit Tracking).
|
|
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. |
|
|
Warning: 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. |
|
|
Note: When Lumigent is configured, decisions are made as to how often the data gathered in log files will be processed. The log files must be processed to determine what fields have changed. The changes are inserted into Audit DB (Lumigent tool) for use by Costpoint for this report. Due to the timing of the processing of the log files, changes in the Costpoint database are not available in real time, but only after the log process has completed. |
Use this screen whenever you want to generate a report detailing any changes made to certain control files and master tables to effectively comply with Sarbanes-Oxley (SOX) audit requirements.
Use the fields in this block to create a new parameter ID or to retrieve a previously saved parameter ID. A parameter ID represents a set of screen selection parameters. Once you have saved a parameter ID and its related parameters, you can retrieve them using Query.
You can use the retrieved parameters to produce reports and run processes more efficiently and with greater consistency. Many users save a unique set of parameters for each different way they run a report or process. If you select a previously saved parameter ID or parameter description, the associated saved screen selection parameters will automatically display as selection defaults. You can change any of the associated selection defaults as necessary.
Enter, or use Query to select, a parameter ID of up to 15 alphanumeric characters. You should choose characters for your parameter ID that help identify the type of selections you made in the screen, such as “PERIOD” or “QUARTERLY.”
When you save your record, all the selections made in the screen are stored with the parameter ID. Later, you can retrieve the parameter using Query.
You can use the parameter to produce reports and run processes more efficiently because you can select the parameter ID with its previously defined screen selections. Once the default selections display in the screen, you can override the defaults as necessary.
Enter, or use Query to select, a parameter description of up to 30 alphanumeric characters.
Use the fields in this block to define the information to display in the report. You can define date ranges as well as users, domains, modules, applications, and specific tables that are set for tracking in the Audit Field Tracking screen (Administration\Maintain\Audit Tracking).
In addition, to limit the amount of information in the report, you have the ability to use non-contiguous ranges for user selections, specific domains, modules, or tables.
Date *
Select a Date option from this drop-down list:
All - includes all dates on the report.
One - includes only the date you select in the Start field. This is the default setting.
Range - includes the dates you enter in the Start and End fields and all dates between them.
From Beginning - includes all dates from the beginning of the list through the one you enter in the End field.
To End - includes all dates from the one you enter in the Start field through the end of the list of dates.
Enter, or use Date Lookup to select, a starting date. Complete this field if you have chosen "One," "Range," or "To End" in the Date field.
If you select "All" or "From Beginning" in the Date field, this field is not active.
Enter, or use Date Lookup to select, an ending date. Complete this field if you select "Range," or "From Beginning" in the Date field.
If you select "All", "One" or "To End" in the Date field, this field is not active.
User *
Select a User option from this drop-down list:
All - includes all users on the report. This field defaults to "All" when you select the User Selections checkbox to enable including non-contiguous users in your report.
One - includes only the user you select in the Start field.
Range - includes the users you enter in the Start and End fields and all users between them.
From Beginning - includes all users from the beginning of the list through the one you enter in the End field.
To End - includes all users from the one you enter in the Start field, through the end of the list of users.
Enter, or use Lookup to select, a starting user. Complete this field if you select "One," "Range," or "To End" in the User field.
If you select "All" in the User field, you can select the User Selections checkbox to enable including non-contiguous users in your report using the User Non-Contiguous Ranges subtask.
If you select "All" or "From Beginning" in the User field, this field is inactive.
Enter, or use Lookup to select, an ending user. Complete this field if you select "All," "Range," or "From Beginning" in the User field.
Select this checkbox to enable selecting users in non-contiguous ranges.
When this checkbox is selected, the User field defaults to "All" and the associated Start and End fields are inactive.
Domain *
Select a domain option from this drop down list. Your options are: "All" or "One."
This field defaults to "All" when you select the Domain Selections checkbox to enable including non-contiguous domains in your report.
If you select "One" in the Domain field, enter, or use Lookup to select, the domain you want to include in your report.
If you select "All" in the Domain field, this field is not active.
If you select "All" in the Domain field, check the Domain Selections checkbox to allow selecting non-contiguous domains in your report using the Audit Domain Non-Contiguous Ranges subtask.
Select this checkbox to enable selecting domains in non-contiguous ranges.
When this checkbox is selected, the Domain field defaults to "All" and the associated Start field is inactive.
Module *
Select a module option from this drop down list. Your options are: "All" or "One."
This field defaults to "All" when you select the Module Selections checkbox to enable including non-contiguous modules in your report.
If you select "One" in the Module field, enter, or use Lookup to select, the module to include in your report.
If you select "All" in the Module field, this field is not active.
If you select "All" in the Module field, select the Module Selections checkbox to allow selecting non-contiguous modules in your report using the Audit Module Non-Contiguous Ranges subtask.
Select this checkbox to enable selecting modules in non-contiguous ranges.
When this checkbox is selected, the Module field defaults to "All" and the associated Start field is inactive.
Select an application option from this drop down list. Your options are: "All" or "One."
You do not have the option to include non-contiguous applications in your report.
If you select "One" in the Application field, enter, or use Lookup to select, the application you want to include in your report.
If you select "All" in the Application field, this field is not active.
You do not have the option to include non-contiguous applications in your report.
Table *
Select a table option from this drop down list. Your options are: "All" or "One."
This field defaults to "All" when you select the Tables Selection checkbox to enable including non-contiguous tables in your report.
If you select "One" in the Table field, enter, or use Lookup to select, the table to include in your report.
If you select "All" in the Table field, this field is not active.
If you select "All" in the Table field, select the Tables Selection checkbox to allow selecting non-contiguous tables in your report using the Audit Table Non-Contiguous Ranges subtask.
Select this checkbox to enable selecting tables in non-contiguous ranges.
When this checkbox is selected, the Table field defaults to "All" and the associated Start field is inactive.
Use the fields in this block to set up sort parameters for your report. These sort options give you more flexibility in reporting since there could be large amounts of data available in the report.
Select your initial sort option from the drop-down list in this required field. Your options are: "None", "Date", "User", "Domain", "Module", "Application", and "Table."
This field defaults to "Date."
2nd Sort *
Select your secondary sort option from the drop-down list in this required field. Your options are: "Date", "User", "Domain", "Module", "Application", and "Table."
This field defaults to "User."
Use the fields in this block to set up types of actions to display in your report. The actions refer to the process used to change data. In other words, you can include data that changed via an update, an insert, a delete, or all three.
These action options give you more flexibility in reporting since there could be large amounts of data available in the report. You can only select one of these radio buttons for a report. "All" is the default selection.
Select this radio button to include updates made to the selected fields.
Select this radio button to include changes to the selected fields due to the addition of new records.
Select this radio button to include changes to the selected fields due to the deletion of selected records.
Select this radio button to include data that changed due to updates, insertions and deletions from the database.
This radio button is selected by default.
Use these display options to determine additional information to display on the report.
Select this option to display the domain and module on the report.
Select this option to display the field name on the report.
Select this option to display the application or table name on the report.
Select this option to display the description of the table keys on the report.
Select this link to view information for the User Non-Contiguous Ranges subtask.
Audit Domain Non-Contiguous Ranges
Select this link to view information for the Audit Domain Non-Contiguous Ranges subtask.
Audit Module Non-Contiguous Ranges
Select this link to view information for the Audit Module Non-Contiguous Ranges subtask.
Audit Table Non-Contiguous Ranges
Select this link to view information for the Audit Table Non-Contiguous Ranges subtask.
* A red asterisk denotes a required field
Data entered in this application is stored in the S_AUDIT_TRCKING table.
