Clarity

I want to know how does the pac_mnt_resources table in clarity is populated. Which processes help to insert data in this table. Either a java code or database procedure or trigger which is used to populate this table. I am facing an issue where the details of an employee are not getting updated in this table. Also in the table odf_ca_resource, the column jp_active_feed, how does this column gets populated?

Hi Mukti,

Have a look at this similar post that may help to answer your query: 

How PAC_MNT_RESOURCES table populates in Clarity v13.3 

Kind Regards,

Brian

Hi Brian,

Thanks for your quick reponse. But I already had a look at that post, it din't help me so that's why posted this question. Can you please me. Which process helps to update this table?

Thanks in advance.

Hi Brian_Mathato - Any other ideas for muktipsm? Thanks! Chris

Hi Mukti

The pac_mnt_resources table contains financial information. It gets the resource entry inserted when the resource financial properties are entered. If your newly created resource is not financially enabled, it will not be in pac_mnt_resources.

Please go to Resource - Properties - Financial and enable the resource financially and you will see it in the table.

Concerning odf_ca_resource and the column jp_active_feed - this is a table containing your custom attributes. You should find your custom attribute jp_active_feed in the Resource properties view and populate it, then you will see it. If the attribute is not in the view, you will have to add it to Resource - Edit and then you will be able to see it and populate it.

Hope this helps -Nika

You could also go to Administration > Studio > Objects  - Resource and Attributes and see if the field is just a standard field, calculated, with a formula.

It could also be populated with a process or a trigger. For those you would have to go through the processes and triggers.

Attributes in processes can be queried and if you export all triggers from the database you can search the export.