Clarity: How does NBI_PROJ_RES_RATES_AND_COSTS generate rows in the table?

Document ID : KB000052134
Last Modified Date : 14/02/2018
Show Technical Document Details

Description:

The rate matrix is to allow users to select rate for day instead of for a date range. Once the rates generated, they will be stored in NBI_PROJ_RES_RATES_AND_COSTS table.

Solution:

The logic behind how the rows created into NBI_PROJ_RES_RATES_AND_COSTS is:

It creates date blocks for the project-resources(team)-tasks combination based on the rate matrix's from date. The from date includes all ppa_matrix values' from_date which falls between project_from_date and project_to_date for the rate matrix assigned to that project. The dates are sliced and put into table NBI_PRJ_MATRIX_DATES table. Dates/rows in nbi_prj_matrix_dates table are generated based on algorithm with the combination dates of project, task, assignment and rate matrix dates. After creating the date blocks, it uses the from_date in date block and role to get the matching cost and updates it in the NBI_PROJ_RES_RATES_AND_COSTS.

Keywords: rate matrix, claritykb