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.