Data Categories

Below, each data category is explained. For each category, there are the following pieces of information:

Category Name – The name of the data category found in system.

Description – A high level description of the data category.

Grain – Indicates what one record (one row) represents. In most cases, the lowest level grain in a report will drive the grain of the report. For example, if you create a report that shows Campaign Order data (grain of one row per campaign order) and join that to Campaign Funding detail (one row per fund used on a campaign order), you may see multiple rows per campaign order if more than one fund was used on a campaign order.

Fields – Field names and descriptions are listed.

Key(s) – If applicable, keys are listed. P indicates primary key, which is guaranteed to be a unique identifier for each row in that data category.

Joins – The default join types for each category that can be joined to. Join types can be overridden on the reports themselves. Reports must be a standard report to modify joins.