Clarity PPM Entity Relationship Diagrams (ERD)

An entity relationship diagram (ERD) includes all relationships with only a few minor exceptions, such as not including simple lookups. Any incoming relationships from tables that are not primarily represented in a diagram are not shown. For example, if table A in the ABC diagram has a column that refers to table X in another diagram, table X is shown in the ABC diagram as an off-screen table. However, if table Y has a column that refers to table A, it is not shown. Instead table A is shown as an off-screen table in the diagram for table Y.
ccppmop1541
An entity relationship diagram (ERD) includes all relationships with only a few minor exceptions, such as not including simple lookups. Any incoming relationships from tables that are not primarily represented in a diagram are not shown. For example, if table A in the ABC diagram has a column that refers to table X in another diagram, table X is shown in the ABC diagram as an off-screen table. However, if table Y has a column that refers to table A, it is not shown. Instead table A is shown as an off-screen table in the diagram for table Y.
 For the following related content, see the CA PPM Advanced Reporting and Database Schema Index.
  • Database schema
  • Data warehouse schema
  • Data warehouse ERD
 
Legend
 
  •  
    Table: 
    A box with solid blue borders.
    This figure illustrates a table. 
  •  
    Off-screen Table: 
    A box with dotted black borders.
    This figure illustrates an offscreen table. 
  •  
    View: 
    A gray box with solid blue borders.
    This figure illustrates a view. 
  •  
    One to One Relationship: 
    The indicator for a one-to-one relationship.
    This figure illustrates a one to one indicator. 
  •  
    Many to One Relationship: 
    The indicator for a many-to-one relationship.
    This figure illustrates a many to one indicator. 
  •  
    Join: 
    The join expression (column=column) is used to label the relationship. However, when the ID (or prID) column participates in the join, it is not listed. Many relationships indicate only one column name to describe a column=ID join.
(Principal_Type='User')
 
 
2
 
 
Action Items
 This figure illustrates action items. 
Applications
 This figure illustrates applications. 
Assets
 This figure illustrates assets. 
Audit Trail
 This figure illustrates audit trail. 
Capacity
 This figure illustrates capacity. 
Chargebacks
 This figure illustrates chargebacks. 
Content Packages
 This figure illustrates content packages. 
Content Add-ins
 This figure illustrates content add-ins. 
Datamart
 This figure illustrates datamart. 
Departments
 This figure illustrates departments. 
Discussions
 This figure illustrates discussions. 
Document Manager
 This figure illustrates document manager. 
Financial Administration
 This figure illustrates financial administration. 
Financial Configuration
 This figure illustrates financial configuration. 
Financial Planning
 This figure illustrates financial planning. 
General
 This figure illustrates general. 
Ideas
 This figure illustrates ideas. 
Investments
 This figure illustrates investments. 
ITIL
 This figure illustrates ITIL. 
Links and Notes
 This figure illustrates links and notes. 
Matrix Management
 This figure illustrates matrix management. 
Notifications
 This figure illustrates notifications. 
Organizational Breakdown Structure
 This figure illustrates organizational breakdown structure. 
Other Work
 This figure illustrates other work. 
Partitions
 This figure illustrates partitions. 
Portfolios
 This figure illustrates portfolios. 
Products
 This figure illustrates products. 
Projects
 This figure illustrates projects. 
Resources
 This figure illustrates resources. 
Security
 This figure illustrates security. 
Services
 This figure illustrates services. 
Studio
 This figure illustrates studio. 
Transactions
 This figure illustrates transactions.