.Costpoint has four new tables that improve the processing performance of the Compute Revenue and Calculate Standard Bills applications. If you are upgrading from Costpoint 5.x, you must run the Synchronize Project Performance Tables utility to add existing project data to the four new tables. If you use scripts to upload data to the PROJ, PROJ_REV_SETUP, PROJ_BILL_INFO, or TM_RT_ORDER tables, you also need to run this utility. If you frequently use scripts to upload data, you may need to run this utility at month end, before loading labor rates, posting revenue, or calculating standard bills, to ensure that the performance tables are in synch. You can schedule this utility on the process server.
The new tables are
Project Hierarchy (PROJ_HIERARCHY) — This table stores the child project number and the parent project number. This table derives from the PROJ table. Having this data in one table benefits processing applications (such as the Compute Revenue process during the aggregate ceiling calculation) and, potentially, posting applications.
Source Project Mapping (PROJ_SRCE_PROJ) — This table stores each project number and the associated source project number. The source project number is used for PLC defaulting and validations. This table initially derives from the PROJ table. If data also exists in the TM_RT_ORDER table, the PROJ_SRCE_PROJ table is re-evaluated and the appropriate source project number is updated based upon the T&M Rate Sequence Search for PLC Source Project setting on the Configure Project Settings screen and the TM_RT_ORDER table (Manage Rate Sequence Orders screen).
Invoice Level Mapping (PROJ_INVC_PROJ) — This table stores the billing level project number and all child project numbers. This table derives from the PROJ_BILL_INFO table, which provides the invoice project number, and the PROJ table, which provides the child project numbers.
Revenue Level Mapping (PROJ_REV_PROJ) — This table stores the revenue level project number and all child project numbers. This table derives from the PROJ_REV_SETUP table, which provides the revenue project number, and the PROJ table, which provides the child project numbers.
To execute this application, click .
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.