ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

Information on active resource list along with Financial location in Clarity

book

Article ID: 226829

calendar_today

Updated On:

Products

Clarity PPM SaaS

Issue/Introduction

How can I obtain list of active resources from clarity along with Financial location?

Environment

Release : 15.9.3

Component : CLARITY USERS, GROUPS, OBS ADMINISTRATION

Resolution

The active resource list and Financial location field information can be obtained from the 'SRM_RESOURCES'  and PAC_MNT_RESOURCES' tables.

Using a Dynamic lookup you can query for these records.

Both tables share the same IDs for the resources.