| Reporting View | Description | Key & Frequency | Recommended Search Columns |
| EM_CAMPAIGN
| Contains data for all enrollment management campaigns to which a person was assigned, including their campaign status, start and stop dates as well as general campaign details.One row per campaign, per person, per person campaign key.PERSON_EM_CAMPAIGN_KEY
EM_CAMPAIGN,���PERSON_UID
EM_CAMPAIGN_START_DATE
PERSON_EM_CAMPAIGN_STOP_DATE | | |
EM_COMMUNICATION
| Contains information for all communications sent to an entity including the type, method and status of a communication, sent time and date, folder and campaign details, if applicable. Also includes initial communication and opt out indicators.One row per person for all communications sent to the person.COMMUNICATION_ITEM_ID
FOLDER,���COMMUNICATION,���PERSON_UID
PERSON_UID | | |
EM_INTERACTION
| Source composite view contains information for all interactions for a person including the type, category, source and date.One row per person for each communication recorded for a person.| PERSON_INTERACTION_KEY,INTERACTION_SOURCE,��INTERACTION_CATEGORY,��INTERACTION_TYPE,��PERSON_UID,PERSON_UID | | |
EM_ORGANIZATION
| Source composite view contains information for all em organization that may be attached to an interaction.One row per organization used with the associated hierarchy of levels defined for that organization.| EM_ORGANIZATION | | |
EM_VALIDATION
| This view contains a number of the EM Relationship source systems' validation table records. This view was meant to be used with reporting tools to create list of values as well as for cleansing purposes in the Enterprise Data Warehouse.Multiple rows per table name, value, status, and valid from and to dates.| TABLE_NAME | | |