How does the Update Earned Value and Cost Totals job calculate ETC cost at the assignment level?
The ETC Cost is calculated based on the corresponding rate for the resource/role in the Rate Matrix.
If a rate exists in the Rate Matrix that fits that resource/role's criteria and date range, then the Rate Matrix Extraction job will need to run to populate the rate in the NBI_PROJ_RES_RATES_AND_COSTS table in the database. The rate in this table is then the rate that is referenced when calculating the ETC cost for the assignment.
ETC Cost = (ETC Hours) x (Rate in the NBI_PROJ_RES_RATES_AND_COSTS table)