Contents of the Purge Report Table Data Screen
Use the fields and options to configure the Purge Report Table Data screen.
Identification
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. After 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. The saved parameters are also useful and necessary when you want to run the process as part of a batch job. Many users save a unique set of parameters for each different way they run a report or process. When you select a previously saved parameter ID or parameter description, the associated saved screen selection parameters automatically display as selection defaults. The page setup and print options, if there are any, are also included in the saved parameter ID. You can change any of the associated selection defaults as necessary.
| Field | Description |
|---|---|
| Parameter ID |
Enter, or click
When you save your record, all the selections made on the screen are stored with the parameter ID. Later, you can retrieve the parameter using Query. You can use the parameter to run the process more efficiently because you can select the parameter ID with its previously defined screen selections. After the default selections display on the screen, you can override the defaults. |
| Description |
Enter, or click
|
to select, a parameter ID of up to 15 alphanumeric characters. Choose characters for your parameter ID that help identify the type of selections you made on the screen, such as PERIOD or QUARTERLY.
Selection Ranges
Specify the range of data you want to purge.
Purge
Use this group box to specify the range of data you want to purge either by the day or the account period the data was created.
| Field | Description |
|---|---|
| By Days |
Select this option to purge report table data created beyond the specified number of days. |
| Purge report data created more than __ days ago |
Use this field to enter a number of days. All report table data that is older than this number of days entered (from the current date) is purged. |
| Prior to this Accounting Period |
Select this option to purge report table data created prior to the specified accounting period. Enter your desired accounting period in the Fiscal Year, Period, and Subperiod fields. |
| Fiscal Year |
Enter, or click
|
| Period |
Enter, or click
|
| Subperiod |
Enter, or click
|
| Purge report tables for all companies |
Select this check box to purge report tables for all companies. This optimizes the purging process since Costpoint will not preserve reporting data for companies other than the one that is currently active. Clear this check box to purge report tables for the current company only. |
to select, a fiscal year.
Options
Use this group box to specify options for the purging process.
| Field | Description | ||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Purge |
Use the options in this group box to specify whether to purge all report tables or specific tables specified in the Report Tables To Purge group box. |
||||||||||||||||||||||||||||
| All Report Tables |
Select this option to purge all of the report tables. |
||||||||||||||||||||||||||||
| Specific Tables |
Select this option to purge specific tables. Select the tables you want to purge by highlighting them in the Report Tables To Purge group box. |
||||||||||||||||||||||||||||
| Report Tables To Purge |
This scroll box is active only if you selected the Specific Tables option in the Purge group box. Highlight one or more table names to select the tables you want to purge. The following table lists options you can select in this scroll box.
|