Hi Lowell,
If you can provide the exact error message when the job fails, it will help to find any existing tec docs we have.
It all depends on what financial info you are trying to find.
pac_mnt_resources and pac_mnt_projects are the 2 tables holding the financial values of the resource and projects. Note: This table will have a record of the project/resource only if they are financially enabled atleast once.
prteam - to check for the project role
prassignment - to check for the assignment role.
Depending on what info you are looking for, I can give you more tables.
Thanks,
Jerin