1. Have the business unit determine how the rate matrix should be configured.
The typical rate matrix will use the only one or two of the following fields to determine the rate.
a. Resource Role or
2. Up to 10 columns can be used, but it is best practice to keep it to a minimum because as the higher the number of columns are configured,
the higher chance that the Rate Matrix Extraction job will experience performance issues as more projects, resources, and tasks are added over time.
-Input Type Code
3. The rate is determined by the date range, then proceeds to funnel left to right finding a match in each column.
Once the match is found, that rate is assigned in the NBI_PROJ_RES_RATES_AND_COSTS table. That is why it is important to test rates and costs via the project > Financial Plans page to see if the correct rate is being retrieved before running the full Rate Matrix Extraction (with parameters Extract for Schedulers, Update, Prepare)
4. Once the Rate Matrix Extraction job completes, the snapshot rates at the time of the job completion are made available to the
the Post Timesheets job and various Project Earned Value calculations and baselines.