SOX Report Specifics
End of Period Adjustments Report (EPA)
FortiDB Version 3.2 Utilities User Guide
15-32000-81369-20081219
49
Determining Your Reporting Period
Reporting Period is the time frame surrounding a user-defined period-end day
(PED). The reporting period extends a user-defined number of days before
(UDDB) and a user-defined number of days after (UDDA) the PED.
Assumptions:
PED = the 1st day of each month
UDDB = 8
UDDA = 15
Case 1
Assumption:
You are running your End of Period Adjustments (EPA) report sometime before
midnight on the first day of August
Assertions:
a) the most recent PED is the first day of July
b) the reporting period is (July 1)- 8 days until (July 1) + 15 days
Conclusion:
The resulting report period is June 23 until July 16, inclusive.
Case 2
Assumption:
You are running your End of Period Adjustments (EPA) report sometime before
midnight on the second day of August
Assertions:
a) the most recent PED is the first day of August
b) the reporting period is (Aug 1)- 8 days until (Aug 1) + 15 days
Conclusion:
Object
The name and owner of the database object that was directly manipulated by
the flagged activity
Time Stamp
The exact time the flagged activity was conducted.
Terminal Name
The terminal IP address or name.
Origin Application
The name, or other identifier, for the originating application, if the activity
originated from an external application or from an application server.
Action
The type of action successfully completed by the User ID.
Column
Description
