Synchronize Project Performance Tables

Costpoint has four tables that improve the processing performance of the Compute Revenue and Calculate Standard Bills applications.

Note: This utility is for Oracle users only.

 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 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 Revenue tab of 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 .