University of Illinois System

Description

This Data Mart will contain a record for each “contact” made with a prospect (including both recruits and applicants), so there will be multiple records for each prospect. The contacts included here include primarily the Institution Contacts from the actual Contacts feature in Banner. In addition, contacts are included for when a recruit record is created, when an admissions application is received, and when the Decision Status of the application changes (e.g. application complete, applicant admitted, etc.). For each contact, associated information about the prospect (either a recruit or an applicant) is pulled in from various tables in the EDW. This includes biographic and demographic information, high school or prior college information, academic information such as test scores and GPA, college and department, academic program, student type and level, and residency.

Universe Guides

Find out how to use the Contact Analysis Data Mart universe to create custom reports: