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.
ccppmod1561
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.