Enrollment Data Overview - FAST IR Module

Why the change?

In the Fast Student Module enrollment reports were based on the assumption that all apps were being entered through Salesforce first. This was not the case, some data was being entered into Banner only, causing a de-sync in data.

What caused the problems?

  1. Data in Salesforce was changed after replicating to Banner.
  2. Data was changed in Banner and not in Salesforce.
  3. Applications were deleted in one system but not the other.
  4. Applications were added to Banner directly.
  5. Salesforce applications were not replicated to Banner.
  6. Two apps in Salesforce are updating one app in Banner.
  7. Two apps in banner are updating one app in Saleforce.
  8. Salesforce Contacts were merged, but application IDs did not get updated.

How did IS fix it?

What IS has done is report duplicate applications per student as one application. This means when there is 1 Salesforce App matched with 1 Banner App, we have 1 application to report.

When we have an application in Salesforce and an application Banner, if the Banner app does not match the SF app, then we have to count both. This is a possible data error, or could be two distinct apps were submitted via two separate methods.

Example of one student

Salesforce App Banner App Same app in both Report count
SF_App A Ban_App_2 Yes 1
SF_App B Ban_App_1 Yes 1
SF_App C No 1
SF_App D Ban_App_3 Yes 1
Ban_App_4 No 1
SF_App E Ban_App_5 No 2

Total Apps reported 7

Enrollment - User Guide

https://docs.google.com/document/d/11RQIsraJvhUbpiLKDPAUTxn7KQJa7KJm_Yt4J5DQHgg/edit#heading=h.frkephcxe721

Data table outlines

Custom Validations

https://docs.google.com/spreadsheets/d/115bVKrpkhxyS1ky5AyCP5Hynd1knelWTJSTjvxqzGEw/edit#gid=95639280

Warehouse Tables

https://docs.google.com/spreadsheets/d/1FBIYOy4JBNqCy55XgEF0LxPoNuQpDRCsbpjn4cX1I1c/edit#gid=1483903629

List of Stage Tables

https://docs.google.com/spreadsheets/d/100IFRIH68Ike-r4eAAudxQHX7OHJILWQFUsmfmMp91k/edit#gid=0

Territory Mapping Table

https://docs.google.com/spreadsheets/d/1JZI6U0IERhkMgpb6NzBcQ73uLaXlHzmDFUWB15TStng/edit#gid=0

Was this FAQ helpful?
FAQ details:
Published date: 12/30/2019 9:51PM
Last updated: 04/07/2020 8:51PM (Jaco Thompson)
Author: Jaco Thompson
^ Top of Page