Hi, It is stored in pac_mnt_resources table. PAC_MNT_RESOURCES - This table stores the financial properties of resources. DEPARTCODE -The department code. This is the home department.
TRANSCLASS
The transaction Class which assigned to the resource .(Always it is missed in this table under the Tech document)
LOCATIONID
The location code. It is the home location.
RESOURCE_CLASS
The resource class assigned to the resource. This refers to PAC_FOS_RESOURCE_CLASS.RESOURCE_CLASS. You need to create a temp table with the below columns.Resource Id,User who had updated,Timestamp,Column Name,Modified To (Column Value). create an db trigger which will fire whenever any one of the 4 columns (DEPARTCODE,LOCATIONID, RESOURCE_CLASS, TRANSCLASS )is modified and then the audit info will bestored in the above created temp table.you can generate it as an adhoc Report from database.Pls check withe DBA whether the trigger is working fine and not causing any performance issues. Important --> Again before using better to get an approval by providing valid resaons.(Business Requirements,Justifications etc). cheers,sundar