Back to Basics:

New to Alliance or just looking for a refresher on some of that basic functionality? The Back to Basics pathway focuses on the fundamentals for new and seasoned users alike.

No relevant experience required

Great for all levels - functional users, technical developers, managers, and more.

Under 10 hours of total session time

You'll learn about

  • Recommendations on how to use existing features
  • Refreshers on techniques
  • Best practices for common functionality

Selected Sessions

Session 8662: Tips and Tricks on “My Oracle Support"

Track: Technical & Reporting

Primary Presenter: Ruth Chen [UTSIS Lead Developer of Campus Solutions - CS - University of Texas System]


Please come to this session to learn the tips and tricks on “My Oracle Support”

We will cover below topics:

  • MOS Dashboard
  • Searching Effectively
  • Open/Maintain Service Requests
  • Upgrades, PUMs and Patches
  • Important MOS Links
Session 8688: Understanding Query Security

Track: Technical & Reporting

Primary Presenter: Paula McDaniel [Data Analytics Education and Learning Instructor - Washington State Board for Community and Technical Colleges]


This presentation is designed to provide basic information on how query security works. It is not only for security administrators, but for all users of PeopleSoft Query. It is intended to give a high level overview to help achieve a solid foundational understanding of how queries are locked down by role.
Session 8561: Outer Join Schoumter Join ... Demystifying the Left Outer Join

Track: Technical & Reporting

Primary Presenter: Robert Fogarty, PMP [Reporting Team Lead | LionPATH Development and Maintenance Office - The Pennsylvania State University]


  • For sanity sake … am going to refer to is as an outer join (this is an apolitical presentation)
  • What is an outer join?
  • When to choose the outer join?
  • The On Clause v. the Where Clause
  • An effective date criteria has been automatically added for this effective dated record….
  • Optional prompts and the outer join
  • Hey this is cool … the Yes/No Table Prompt and the outer join
  • “Error in running query because of SQL Error, Code=904” …. UGGGGGGGHHHHH!!!!
  • Sub queries on the on clause
  • Is null / Is not null (what’s the goal !!!!)
  • What is null, anyway???
  • Got the perfect query then realize that my outer join should have been a standard join … any options???
  • Got the perfect query then realize that my standard join should have been an outer join … any options??? (Hint … maybe a glass of wine)
Session 8538: The Basics of Developing Effective Information Visualizations

Track: Technical & Reporting

Primary Presenter: Primary Presenter: Anna Kourouniotis [Database Analyst II - Duke University]


The main goal of this presentation is to list and illustrate ways to develop a strong foundation on information visualization that may be used for visual data analysis. The first objective is to provide the audience with the “vocabulary” to describe visualizations. Knowing the vocabulary is the necessary start for attempting to discern which designs are appropriate for answering a given question or solving a problem. Focus will be placed on some of the foundational charts and graphs. The presenter will attempt to answer questions like, what charts are there, which charts are popular, which charts to use - why and when? Recommendations for embedding user-friendly tips and instructions for navigating dashboards will also be made. Please note that the tool the examples and simulations are based on is Tableau, but the principles may be applied across other data visualization applications.
Session 8853: File Parser for Beginners

Track: Student Information System (SIS)

Primary Presenter: Richard Edwards [Sr. Systems Analyst - University of Texas at Arlington]


An introductory presentation on what is the file parser.
Session 8588: ElasticSearch 101 – What, Where, How and…Why is it needed?

Track: Student Information System (SIS)

Primary Presenter: David J Slater [Programmer/Analyst Level III - Clarkson University]


ElasticSearch is the tool/process Oracle has delivered to allow searching of objects and information within Peoplesoft. While Elastic search exists within all pillars (HR, FIN, CS) this discussion will focus on the use of ElasticSearch within Campus Solutions (CS). In my experience, ElasticSearch, in CS, was introduced primarily to work in tandem with the Fluid Class and Catalog Search and Enrollment functions. While ElasticSearch can be used for many other functional areas, Class and Catalog searching was the primary delivered purpose. We will look at the following areas of interest related to ElasticSearch without going too deep into any one of the topics:

  • Why set-up ElasticSearch?
  • What is needed to setup ElasticSearch?
  • Where are all the pages that can affect the set-up, testing and administration?
  • How we have used ElasticSearch at Clarkson.
  • Who needs to be involved?