Rate Matrix Extraction Job

This job extracts rate matrix information and populates the rate matrix extraction tables. Run this job each time the rate matrix has changed, when the financial properties of a project have changed, or when resources have been added to an investment.

You can prepare and update the rate matrix data. While the job is running, you can use the rate matrix data.

Best Practice: Preparing the rate matrix data takes more time than updating the rate matrix data. To minimize the time period during which the rate matrix data is unavailable, schedule two instances of the job, each with only one of the two parameters selected.

Requirements

A rate matrix must be set up.

Restrictions

This job cannot run concurrently with other instances of this job. You must delete all scheduled instances of this job and reschedule the job using the Prepare Rate Matrix Data parameter and/or the Update Rate Matrix Data parameter.

Parameters
Extract Cost and Rate Information for the Scheduler

Specifies whether you want cost and rate information extracted from a desktop scheduler.

Default: Cleared

Prepare Rate Matrix Data

Specifies whether you want the updated rate matrix data added to a temporary table. The data in the NBI_PROJ_RES_RATES_AND_COSTS table stays intact. The rate matrix data is available.

Default: Selected

Update Rate Matrix Data

Specifies whether you want to copy the updated rate matrix data from the temporary table to the NBI_PROJ_RES_RATES_AND_COSTS table. The rate matrix data is not available.

Default: Selected

More information:

Financial Matrices