Pathways
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]
Description: Read more...
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]
Description: Read more...
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]
Description: Read more...
- 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 - PART 1
Track: Technical & Reporting
Primary Presenter: Primary Presenter: Anna Kourouniotis [Database Analyst II - Duke University]
Description: Read more...
Session 8538: The Basics of Developing Effective Information Visualizations - PART 2
Track: Technical & Reporting
Primary Presenter: Primary Presenter: Anna Kourouniotis [Database Analyst II - Duke University]
Description: Read more...
Session 8853: File Parser for Beginners
Track: Student Information System (SIS)
Primary Presenter: Richard Edwards [Sr. Systems Analyst - University of Texas at Arlington]
Description: Read more...
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]
Description: Read more...
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?