Is there a DB Design document anywhere for PPM 14.2?

[Legacy User]

I have all kinds of other guides, but often I find I need to write SQL queries and at the moment I have to try and figure it out by looking at a bunch of data in a column I *think* might be what I'm looking for until I can confirm.  If there were any sort of documentation that said, "Hey, the PRASSIGNMENT table holds data about which resources are assigned to which tasks.  PRTASKID is a foreign key back to the task table, PRESTMAX is the maximum hours the resource is assigned to the task" etc, that would be EXTREMELY helpful.

[David Morton]

Try the links on this page; CA PPM Advanced Reporting and Database Schema Index - CA Technologies

 

and also the Technical Reference Guide ; https://support.ca.com/cadocs/7/CA%20Clarity%20PPM%2014%202%2000%20%20On%20Premise%20-%20Restricted%20Content%20-ENU/Bookshelf_Files/HTML/techref/index.htm 

the Entity Relationship Diagrams section of that holds a lot of the relationship info.  (that link is for the 14.2 version of the document, from 14.3 the info is in the docops platform)

[Allen Bollinger]

Try the technical reference guide attached.

Attachment(s)

CAClarityPPM_TechRefGuide_ENU.pdf   1.24 MB 1 version

[Legacy User]

Thank you, both of you, those documents are exactly what I was looking for!