Data Model

Business Edge uses a data model with many tables and fields for reporting. The model represents the relationships between tables. The data model is centered around three Business Edge entities (aka Edge Entities): initiatives, pursuits, and opportunities. Because these three entities can have hierarchical relationships (parent-child), the model allows you to build reports that can do rollup and drill down.

Full Data Model

The whole data model is here:

This view of the data model shows all tables, their relationships, and the primary keys.

This view of the full data model shows all tables, their relationships, and all fields.

IMPORTANT For the hierarchical relationships among the Edge entities, see EdgeEntity Table and Fields.

Opportunities

The Opportunity-related tables and fields are shown here:

For Opportunities, see Opportunity Tables and Fields.

Pursuits

The Pursuit-related tables and fields are shown here:

For Pursuits, see Pursuit Tables and Fields.

Initiatives

The Initiative-related tables and fields are shown here:

For Initiatives, see Initiative Tables and Fields.

Tasks

The Task-related tables and fields are shown here:

For Tasks, see Task Tables and Fields.

Data Tables

For tables describing both opportunities and pursuits, see Tables describing Opportunities and Pursuits.

For tables describing opportunities only, see Tables describing Opportunities only.

For date tables, see Date Tables.

For one-to-many relationships, see ListData.

For calculated and aggregated fields, see Measures.

 

Related topics