Where to find the API Attribute ID for the OOTB Object's Attributes in the Database.

Products

• Clarity PPM On Premise
• Clarity PPM SaaS

Issue/Introduction

Is there a table in DB where I can find the API attribute IDs for OOTB attributes of several objects?

Environment

Clarity Application

Resolution

You can find the API attribute ID in the column api_alias, for example on the status report attribute name = overall status, and the api attribute id = overallStatus.

For other you will be able to find in the tables below:

Clarity Schema Documentation:

ODF_CUSTOM_ATTRIBUTES
Added column:
API_ALIAS

ODF_OBJECTS
Added columns:
API_ALIAS
IS_API_ENABLED