Hello Atul,
Thanks for your response. I am interested in your first point and would like more info on this approach. For #2 we don't want multiple rate matrices.
For your first point, I have a few questions but let me state what I understand we could do: We could pull data out of an HR system or create a new field in Clarity with a record profile and enter the rate there. There would be a nightly process that will pull new rates to the Rate Matrix. Will this process create new Matrix rows in the Rate Matrix or will it just update a matrix row if the resources rate has been updated?
For example:
Contractor A has just been hired. Their rate is entered in the new field on the Resource - Main - General - Properties tab of Contractor A. A nightly job runs and notices that Contractor A is not in the Rate Matrix and will create a new matrix row including the From and To Date, Resource Name and the Rate. Is that correct?
Also, could this same process also delete the Matrix Row when Contractor A no longer works for the company? Would this process only include a XOG process or would GEL or anything else also be involved?
Thanks,
Garrett