# CA PPM: On the 'Rate Matrix Extraction' job page, what do the parameters 'Prepare Rate Matrix Data' and 'Update Rate Matrix Data' do?

**Document ID :**KB000027005

**Last Modified Date :**01/10/2018

**Description:**

On the 'Rate Matrix Extraction' job page, what do the parameters 'Prepare Rate Matrix Data' and 'Update Rate Matrix Data' do?

**Solution:**

Prior to adding the new parameters when the job ran the NBI_PROJ_RES_RATES_AND_COSTS table was truncated, then rebuilt with the most current rate information.

For large datasets the rebuilding of the table could take several minutes to hours. During this time projects did not have access to the information which lead to resources having a rate of zero.

We added the two new parameters so the NBI_PROJ_RES_RATES_AND_COSTS table will always have data available for use by the schedulers.

The 'Prepare Rate Matrix Data' parameter refreshes the NBI_PROJ_RES_RATES_AND_COSTSCP table with the most recent rate information. This may take a few seconds to hours depending on your data. During this time projects still have access to the rate information in the NBI_PROJ_RES_RATES_AND_COSTS table. The NBI_PROJ_RES_RATES_AND_COSTSCP is a 'staging' table that is only used to hold the data that is prepared. You only need to select this 'Prepare Rate Matrix Data' parameter after major changes / updates to the rate matrix have occurred.

The 'Update Rate Matrix Data' parameter copies the contents of the NBI_PROJ_RES_RATES_AND_COSTSCP table to the NBI_PROJ_RES_RATES_AND_COSTS table. This should take a matter of seconds to complete. The purpose of this option is to update the live table (NBI_PROJ_RES_RATES_AND_COSTS) with data in the 'staging' table (NBI_PROJ_RES_RATES_AND_COSTSCP).

Therefore, once the Rate Matrix Extraction Job has completed, the schedulers should now reflect the most current rate information, using the NBI_PROJ_RES_RATES_AND_COSTS table.

Starting in 15.4.X, for performance improvement, the "Team Only" parameter was introduced.

It will only produce breakout rates at the team level, without adding a row for each individual task the resource is assigned to.

https://docops.ca.com/ca-ppm/15-4-1/en/reference/ca-ppm-jobs-reference#CAPPMJobsReference-RateMatrixExtractionJob

If there are any XOG/integration jobs that read/write the PPA_MATRIX/PPA_MATRIX_VALUES, this will affect the NBI_PROJ_RES_RATES_AND_COSTS table, as the Rate Matrix Extraction job will process both these tables.

To run the full run with team only option, set the following parameters:

-Extract Cost and Rate Information for the Scheduler

-Prepare Rate Matrix Data

-Update Rate Matrix Data

-Team Only

To run the incremental run with team only option, set the following parameters:

-Extract Cost and Rate Information for the Scheduler

-Prepare Rate Matrix Data

-Update Rate Matrix Data

-Team Only

-Incremental only