Published on University of Colorado (https://www.cu.edu)

Home > Data Model and Tooling Overview

Data Model and Tooling Overview [1]

November 2, 2023 by Melanie Jones [2]

The variety of campus goals necessitates a robust data model that connects multiple applications and systems.

The core data model to support campus efforts follows the Salesforce Education Data Model [3], which allows UIS to fully model the data relationships of CU constituents.

 

Integrations

UIS has built and supports the following integrations with third-party applications:

  • SIS - Application, enrollment and course data
  • Slate (Denver) - Campus applications
  • Slate (Boulder) - Prospect RFIs and campus applications
  • PharmCAS (Anschutz) - Pharmacy applications
  • NursingCAS (Anschutz) - Nursing applications
  • Collegis - 3rd party call center for lead qualification
  • Salesforce Admissions Connect (Colorado Springs) - Campus applications

[4]

Add-Ons

UIS provides a variety of additional Salesforce tools to assist campuses with marketing and recruitment:

  • FormAssembly - Forms
  • Drupal - Content management system
  • five9 - CTI functionality
  • Calendly - Calendars and appointment management
  • Mogli SMS - Texting capabilities
  • Collegis Education - 3rd party lead qualification call center

Your specific implementation may only leverage a subset of these applications. Please submit a help ticket [5] if you have further questions.

Data & Flow

Data flows into the IOS Salesforce org through three main buckets.

  • Marketing and Website
    • All leads from RFI forms, paid and organic advertising
  • Pre-Decision Applications
    • All in-progress and submitted applications
  • Post-Decision Applications and Enrollments
    • All Submitted applications with decision information or any active enrollment information.

All information about the lead can be found on the "Contact" object. Any Application and Program Enrollment-related information can be found on the "Application" or "Program Enrollment" objects linked to the Contact. 

IOS Entity Relationship Diagram

Review the d [6]etailed data flow. [6]

To learn more about how data is stored and labeled in our Salesforce, click below.

Learn More [7]

 

 

Related Wiki Posts

  • Intro to the Integrated Online Services Salesforce [7]
Display Title: 
Data Model and Tooling Overview
Send email when Published: 
No

Source URL:https://www.cu.edu/blog/integrated-online-services/data-model

Links
[1] https://www.cu.edu/blog/integrated-online-services/data-model [2] https://www.cu.edu/blog/integrated-online-services/author/39 [3] https://help.salesforce.com/s/articleView?id=sfdo.EDA_Welcome_to_EDA_Data_Model.htm&type=5 [4] https://lucid.app/documents/view/cf9daae8-5e46-4cc0-9067-f5986d338472 [5] https://www.cu.edu/crm/forms/integrated-online-services-ios-help-ticket [6] https://gitlab.com/universityofcolorado/uis/crm/ios/anschutz/college-of-nursing/uploads/9a7940879a44c00ea30631acc31de821/IOS_Data_Flows_v5_103023_JSB_v3_-_High_Level_Data_Flow.pdf [7] https://www.cu.edu/blog/integrated-online-services/intro-integrated-online-services-salesforce-org