Agenda

Equation Engine - It's for more than just packaging and tuition calc! **FEE REQUIRED**

Track: Workshops

Session Number: 9864
Date: Sun, Feb 26th, 2023
Time: 8:00 AM - 11:00 AM

Description:

If you've used Equation Engine, you've probably used it for packaging or tuition calc.  But did you know that you can use it to update tables?  In fact, it's the only way to update CAF variables with different values for each student.  We'll talk about how you can do these updates, and when you should (and shouldn't) do it!  You can also use it for running a population selection in many places, and we'll go over how and why you might want to do that. 

This is an intermediate level workshop. In order to get the most out of this workshop, you will need the following UPDATE security in a TEST system that you’ll be able to access during the session:

Ability to add data tables:
Setup SACR > Common Definitions > Equation Engine > Equation Data Tables
Setup SACR > Security > Equation Tree Security > Tables and Views

Create SQL:
Setup SACR > Common Definitions > Equation Engine > Equation SQL Routines
Setup SACR > Security > Equation Tree Security > Callable SQL > Callable SQL

Test Equations:
Setup SACR > Common Definitions > Equation Engine > Equation Test Data
Setup SACR > Common Definitions > Equation Engine > Equation Test Results (View Only)
Sub-Categorization: Student Information System (SIS)
Session Type: Workshop

Session Length: Workshop (180 min)
Cross Listed Areas: trk-1593
ERP Systems: PeopleSoft
Platform Type: On-premise
Target Audience: Functional
Knowledge level: Intermediate
Tell us about you!: 20+ years Campus Solutions Experience, primarily in FA and Campus Community
More than 15 prior Alliance Presentations
5+ years as a Database Administrator
30+ years as a programmer
Sub-Categorization: Student Information System (SIS)
Session Type: Workshop

Session Length: Workshop (180 min)
Cross Listed Areas: trk-1593
ERP Systems: PeopleSoft
Platform Type: On-premise
Target Audience: Functional
Knowledge level: Intermediate
Tell us about you!: 20+ years Campus Solutions Experience, primarily in FA and Campus Community
More than 15 prior Alliance Presentations
5+ years as a Database Administrator
30+ years as a programmer

Speakers

Primary Presenter
Vic Goldberg
Part-time Retiree
University of Colorado