Chris Shaffer, CA PPM Principal Architect

Chris Shaffer, CA PPM Principal Architect, Rego University, Tampa 2015

Today Chris Shaffer, CA PPM Principal Architect at Rego Consulting, shows us how to find the Database Table and Attribute for a Field on an Object. Read his instructions and view the video below. 

CA PPM | Database Field and Attribute

To find the Database Table and Attribute for a particular Field on an Object, start within the Project screen.

In this demo, we want to find the Database Field for the Start Date. Since it’s a Project Object, we navigate through the following steps: Studio > Objects > Object Name > Attributes.

Now you’re looking at a screen full of Attributes. Scroll down and look for “Start.” This row has the “Start Date.” We can see that it’s “Active.” We can see that the “Data Type” is a “Date.”

There’s a “Database Table” cell, and the column just to the right is the actual “Database Column” containing that data.

And that’s how you find the Database Table and Attribute for a Field on an Object.

Watch Chris navigate the process in the video below.

Training Video | Find the Database Table and Attribute for a Field on an Object


Have an idea for a CA PPM Quick Tip? Tell us about it in the comments.

If you want to learn more from CA PPM Quick Tips, check out our demo on How to Update a Field through a Gel Script.

For free CA PPM educational resources, follow us on LinkedIn, browse our nonprofit library, the regoXchange, and join our mailing list below.