to start purging the tables based on the parameters you selected.Use this screen to purge various outdated report tables that have grown over time because of the accumulation of report table rows that have been created to run different Costpoint reports. Many reports print from report tables that are created in a separate process. These report tables must be created each time a report is printed for a different fiscal year, period, and subperiod because new data will be used. Over a period, the report tables accumulate many rows of data, and the processing time slows. This process clears data and free disk storage resulting in faster processing time.
You can use this utility to purge all or some of the report tables. You can also select the purging age of the reports. This clears any report data more than a user-specified number of days old.
Include this utility as part of your database administration maintenance procedures.
After entering your preferences, click to start purging the tables based on the parameters you selected.
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 are also included in the saved parameter ID if there are any. You can change any of the associated selection defaults as necessary.
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 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 run the process more efficiently because you can select the parameter ID with its previously defined screen selections. After the default selections display in the screen, you can override the defaults.
Enter, or click to select, a parameter
description of up to 30 alphanumeric characters.
Use the this group box to specify the range of data you want to 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.
Select this option to purge report table data created beyond the specified number of days.
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.
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.
Use this field to enter, or use 
to select, a fiscal year.
Use this field to enter, or use to select, a period of the fiscal year.
Use this field to enter, or use to select, a subperiod of the period.
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.
Use this group box to specify options for the purging process.
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.
Select this option to purge all of the report 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.
This scroll box is active only if you selected the Specific Tables option in the Purge group box. Select the specific tables you want to purged by highlighting one or more table names in this list box.
The following table lists options you can select in this scroll box.
|
Option |
Report Table Purged |
|
PSR Header |
PSR_HDR |
|
PSR Final Data |
PSR_FINAL_DATA |
|
FS Comparison |
RPT_FS_COMPARE |
|
Project Labor Summary |
RPT_PROJ_LAB_SUM |
|
Project Unit Summary |
RPT_PROJ_UNIT_SUM |
|
Project Unbilled |
RPT_PROJ_UNBILLED |
|
Revenue Summary |
RPT_REV_SUM |
|
Revenue Error Log |
RPT_REV_ERROR_LOG |
|
Project T&M Analysis |
RPT_PROJ_TMA |
|
Project ETC Amounts |
RPT_ETC_AMT |
|
Revenue Worksheet |
RPT_REVENUE_WKS |
|
Project ETC GLC |
RPT_ETC_GLC |
|
Project ETC PLC |
RPT_ETC_PLC |