S
SJ_Digriz
I have approx 3500 people (this number will double soon) that I need to synch
to a financial db view (Oracle) that determines that persons rate.
I can't find a PS2003 table to put the rate for resources that are not
assigned to projects yet. I was hoping that a resource rate would already be
included when a PM allocated them to a task. I also need to use the A,B,C,D
rate structure for each resource. I just can't find a structure to perform
the mapping and updates against.
When the rate changes in the view I need to add the effective date of the
new rate and apply it to all projects the resource is currently assigned to.
I see the MSP_Resources and MSP_Resource_Rates, but the rates table doesn't
contain a resource unless it assigned to a project that I can see.
I could use any advice or a pointer to some FAQ etc..
Thanks much
to a financial db view (Oracle) that determines that persons rate.
I can't find a PS2003 table to put the rate for resources that are not
assigned to projects yet. I was hoping that a resource rate would already be
included when a PM allocated them to a task. I also need to use the A,B,C,D
rate structure for each resource. I just can't find a structure to perform
the mapping and updates against.
When the rate changes in the view I need to add the effective date of the
new rate and apply it to all projects the resource is currently assigned to.
I see the MSP_Resources and MSP_Resource_Rates, but the rates table doesn't
contain a resource unless it assigned to a project that I can see.
I could use any advice or a pointer to some FAQ etc..
Thanks much