SETA West

SETA West 2006
Sunday, November 5th – Tuesday, November 7th
Preconference Workshops – Saturday, November 4th

Preliminary Session & Workshop Information

A Distributed Maintenance Approach to Banner Security
Gudrun Kokoszka, Utah State University
Session #W06-96
Of Interest to General/Special Interest; Technical
            At Utah State University, Banner security maintenance relies on a distributed maintenance approach supported by a custom form called ZSASECR.  The session will present this custom form developed to reduce certain user maintenance tasks required to be performed by a DBA at USU.  The form allows designated Banner security module administrators to assign and deassign Banner security classes previously requested and created for their modules by the DBA.  The form can also be used to grant these Banner security administrators the ability to reset a user's password, lock / unlock a Banner account or create a Banner account.

Address Verification in Banner
Kevin Runner, Runner Technologies, Inc.
Session #W06-97
Of Interest to Admissions; Alumni; Finance; Financial Aid; General/Special Interest; Human Resources; Receivables; Student; Technical
            Address verification is now a low-cost reality for institutions using Banner.  Attendees will learn the basics of address verification and the simple integration required to support real-time address verification from Banner Forms, INB, or the web self-service applications.

Address/Telephone Maintenance, EASY!
Linda Norman, Western Washington University
Session #W06-164
Of Interest to General/Special Interest
            You have thousands of telephone & address records in Banner, but are they current?  Does your staff spend countless hours entering address and telephone changes?  Do student web entries dump garbage into your database? Does complex address logic result in inconsistent reports and processing?  Come see our solution: locally developed forms and processes that keep our data clean with minimal effort and no Banner mods!  Process electronic telephone & address changes from student web, housing, the Post Office, and telephone append services automatically.  Maintain quality control with a fast but effective review process.  Do periodic maintenance to detect, report, and repair problems. Standardize address and telephone processing and reporting with common code.  We will be sharing our code.

Alumni Membership
Christina Smith, Cal State/Chico
Session #W06-102
Of Interest to Advancement; Alumni; Development
            An overview of using the Alumni Membership Module based on C.S.U. Chico's Alumni Membership Program.

Application Management:  Improving Performance & Reducing Downtime
Duane Spencer, Quest Software
Session #W06-121
Of Interest to Technical
            A sound application management methodology involves three basic practices:  effective real-time triage, historical performance analysis, and forecasting and trending.  This session will cover how IT professionals can apply the Quest Application Management Methodology to improve the performance and availability of Banner:  proactively detecting, diagnosing, and resolving application performance problems before constituents and university business staff are affected by them; mapping the performance of constituent activities to related higher education services; determining how trends in growth and demand for services might affect the application and it users; delivering instant expertise in the infrastructure components supporting Banner.

Auto Packaging
Joan Riley, Pacific Lutheran University
Session #W06-136
Of Interest to Financial Aid
            Information on Financial Aid packaging and awarding

Automate Banner Jobs Using AppWorx
Reeve Fernandes, AppWorx
Session #W06-122
Of Interest to General/Special Interest
            This informative presentation will show you how automating Banner (v5, v6, v7) batch jobs eliminates manual effort, resulting in faster, more accurate processing with reduced latency and less down time. Learn how to streamline and error-proof tasks like Data Loads, Payroll, Letter Generation, etc. Automate output distribution, so that the report arrives in the hands of the person who needs it, when they need it. View job status online from any web browser; no more logging-in to check output files to determine process completion. Create business intelligent dependencies between Banner jobs. Find out why over 100 Higher-Ed institutions rely on AppWorx to automate, integrate and accelerate their Banner processing.

Automating the Admissions Process
Mark Kirkby, Western Washington University
Session #W06-163
Of Interest to Student
            As employees at our respective institutions, we strive to attract and attain the best students and the best for our students.  Chief among this process is being admitted to the institution.  Given the sheer number of applicants, this can be a daunting process.  Mark Kirkby will explain how WWU has automated the loading of admissions information into Banner, so that the time spent is on the correct selection, not the computer interaction.

Banner & ODS Reporting Foundations from Information Builders
Tim Beckett, Information Builders
Session #W06-134
Of Interest to Reporting
            How long will it take to get your operational reports from Banner and ODS done?  About one week per module if you're using the new WebFOCUS Reporting Foundations from Information Builders.  See them in action during this presentation.  We will show you some of the hundreds of reports that are delivered with these packages.

Banner Subcontracts
Connie Atchley, Oregon State University
Session #W06-154
Of Interest to Finance
            This session will include a description of the workflow that OSU has defined to deal with subcontracts on grants, how the subcontract data ties to baseline Banner data, a walk through a home-grown form to maintain the data, and the reports and processes to support the business process.

Banner/Blackboard Integration-One Schools Approach
James Kelly, Western Washington University
Session #W06-131
Of Interest to Technical
            How and what we have done here at Western to integrate our Banner student data into the Blackboard system, keeping user accounts and course registrations in sync.

BANSECR Security
Ernie Williams, Snow College
Session #W06-143
Of Interest to Technical
            Share some useful scripts for BANSECR security, roles, PIDMS, fixes, etc.  Show how to setup documentation for errors. Show documentation for clones, etc

Building a Black Box with Database Packages
Linda` Norman, Western Washington University
Session #W06-165
Of Interest to General/Special Interest
            Is your institution in a constant battle for consistency?  Does everyone have a different definition of an enrolled student?  Do different reports produce different results, depending on who wrote
them and when?  Do you find yourself re-coding the same logic over and over again?  Do you have to teach every new programmer how to look up a current address?  You don't have to be an auto mechanic to drive a car.  You shouldn't have to know every field and calculation in Banner to do accurate reporting.  Come see how we have worked to put commonly used calculations,
indicators, and data lookups in database packages, creating a central repository for all of our logic.  Analyze it once; code it once; debug it once; use it forever.  If question arise, there's just one place to look for the logic.  If changes need to be made, there's just one place to change it.  Existing code automatically inherits the new logic.  Feed the required information into the magic black box and receive consistent results without worrying about how they were generated.  We will be sharing all of our code.

Building Web Applications with Orbit -- Workshop
Kevin Runner, Runner Technologies, Inc.
Session #W06-101
Of Interest to Technical
            The workshop is divided into three parts.  Part 1 is an "Overview of Web Technologies" used to build Oracle based web applications.  This will cover the architecture, presentation layer, and application layer of several technologies, including JSP, Java Servlets, Java Applets, Cold Fusion, ASP (.Net), PHP, Perl, PL/SQL, PSP, and Orbit.  Part 2 will cover "Web Strategies and Solutions" in building we applications.  This is a technical discussion about the mechanics of building transactional applications in thin client.  Topics will include required skills, application flow, layout styles, handling GUI objects, transaction integrity, and security.  Part 3 will go into an in-depth discussion of the Orbit Web Application Development Suite by Runner Technologies.

College Administration & Assessment
Aspen apGaia, Western Washington University
Session #W06-158
Of Interest to Other; Student; Technical
            This session will present the system Western Washington University developed to support the needs of our Woodring College of Education, where ever possible leveraging Banner functionality and data to minimize redundancy, complexity and
development and maintenance effort. Special attention will be given to our solution for program and institutional assessment tracking.

Common Matching - Practical Steps for testing
Nancy Laurence, Oregon State University
Session #W06-126
Of Interest to Student
            Common Matching, step by step set-up instructions with practical suggestions for testing to get the results you want.

Creating Your Own Self-Service Web Pages
Robert Nitsos, Loyola Marymount University
Session #W06-111
Of Interest to Technical
            In this session, I will show you an example of a custom Self-Service page that I created.  Topics will include package creation, PL/SQL code to use, the htp/htf objects, creating custom user roles, WebTailor and downloading data to an Excel file.

Data Normalization
Ernie Williams, Snow College
Session #W06-142
Of Interest to General/Special Interest
            Goes through normalization of database, talks about referential integrity, primary and foreign keys.  The final half hour will be an actual exercise in doing a normalization (or 2 or 3). Session of Data Concepts is a prerequisite for this session!!

Database Concepts
Ernie Williams, Snow College
Session #W06-141
Of Interest to General/Special Interest
            Overview of basic concepts of a database vs traditional files with advantages and disadvantages of each.  Helps a non-techie understand the basics of a database.

Developing an Integrated Web Environment
Sharon Blanton & Louise Glogoff, Pima Community College
Session #W06-108
Of Interest to General/Special Interest
            Pima Community College is completing a multi-year project to completely redesign its web environment.  In 2005, the public web site was redesigned to focus on marketing College programs to potential students, businesses and the general community.  A complementary web portal has now been developed to deliver information and services needed by students, faculty and employees.  This presentation will focus on the processes used to manage our portal development and deliver the required training and support to end users.  You will also learn strategies to integrate web and portal content and deliver a seamless user experience.

Disaster Recovery with Oracle 9i & 10g Real World
Mark Schemmer, Western Washington University
Session #W06-130
Of Interest to Technical
            Data Guard; Standby Database senarios; Logical (Reporting Needs) / Physical standby's; In 9i and 10g.  Implementing a standby database that fits your business and operational goals in
providing the security from a database crash or hardware failure at your school.

Don't Need to be a DBA to Install Oracle 10g DB
James Keene, Loyola Marymount University
Session #W06-148
Of Interest to Technical
            This presentation will go through the steps of installing Oracle 10g Express Edition on a computer and demonstrate some security issues as well data manipulation issues.  10g Express installation includes Application Express (formerly HTML DB).

Easy Banner Customizations to Enhance Student Experience
Erica Grong, University of New Mexico
Session #W06-140
Of Interest to Student; Technical
            At UNM, we have created custom screens that have greatly enhanced the student experience... a revamped prospect & recruit form, View Printable Schedule (through self-service, not INB), and many more.

Employee Self Service and EPAF's
Linda Griffin, Washburn University
Session #W06-138
Of Interest to Human Resources
            Are you considering implementing Electronic Personnel Action Forms via Employee Self-Service?   Learn about the EPAF enhancement delivered with release 7.2.  From rules and setup, to a demonstration of the end user interface.

Enhancing Banner Job Submission
Steve Weinberg, Western Washington University
Session #W06-157
Of Interest to General/Special Interest
            We will present a number of extensions to Job Submission. We have developed a simple method of using Banner Job Submission to run multiple jobs in sequence. Any job, either Banner baseline or locally developed can be set up to run this way. Error checking and conditional execution of jobs in the sequence is included. Along with sequential, conditional execution of Banner jobs, we include a scheduling tool for sequenced jobs. The scheduling tool allows for one-time scheduling of sequences, or recurring scheduling. In addition we include a job status monitoring tool that, in real time, displays the status of any job run through Job Submission. End users can check to see if their job has completed at any time. The display also includes job information like the size, location and printer destination of the output file. Lastly, we include a method for restricting the number of concurrent jobs each user can submit. This allows us to limit Job Submission use if we need to increase system resources available for interactive users, such as during student registration. We have the software for each of these tools available for distribution.

Enhancing the Agility of Banner using Real Application
Erica Daniel, Oracle
Session #W06-145
Of Interest to Technical
            Oracle Real Application Clusters (RAC) 10g running on hardware clusters provides Oracle's highest level of capability in terms of availability, scalability, and low-cost computing. Oracle RAC provides very high availability for applications by removing the single point of failure with a single server. Reliability, flexibility and availability are key requirements for a distance learning implementation. Oracle Database 10g RAC provides the flexibility to make systems more adaptive, proactive, and agile.

Evisions ARGOS -- Reporting Redefined
Matt McLellan & Jennifer Vernacotola, Evisions, Inc.
Session #W06-115
Of Interest to Reporting
            You know the answers are in there.  You know it.  It's just fine that your existing tools are too expensive to roll out to everyone, too difficult to use, not secure enough, or there's just no support for Banner users.  Are you looking for reporting software that can actually meet your needs?  Based on years of experience in Higher Education, Evisions web based Ad Hoc reporting tool is your solution.  Argos takes an original new approach to report development and delivery by creating an environment where everyone can securely access information and contribute to the reporting process. The IT professionals develop a secure, logical environment for the data.  Your power users enrich it further and bring it closer to the users who can, in turn, view, edit and refine it as they need.  Simple.  Secure.  Easy.  Redefine your own reporting.

Evisions FormFusion Document Enhancement & Management System
Matt McLellan & Jennifer Vernacotola, Evisions
Session #W06-116
Of Interest to Admissions; Advancement; Alumni; Development; Finance; Financial Aid; General/Special Interest; Human Resources; Purchasing; Receivables; Student; Technical
            FormFusion is, by far, the most widely used Banner document enhancement and distribution system.  FormFusion affords unprecedented control over the design and delivery of your Banner output and it completely eliminates the need for pre-printed forms.  Rearrange data location, layout, and font.  Format with borders, shading, and images.  Add important information not included in baseline.  When you're done, choose delivery options that meet your wrokflow:  distributed laser printing, automated emailing, archiving, or feeding into a 3rd party imaging solution.  This demonstration will include several client examples to demonstrate how FormFusion users are saving time, increasing efficiency, and improving service.  The most popular applications include:  purchase orders, invoices, grade mailers, transcripts, schedules and bills, timesheets, receipts, tax forms, and letter generation.  FormFusion helps you to take raw output and turn it into professional digital documents -- come find out how!

Evisions IntelleCard -- Higher Ed Payment Card
Matt McLellan & Jennifer Vernacotola, Evisions, Inc.
Session #W06-117
Of Interest to Finance
            IntelleCard works exclusively with Evisions Intellecheck to provide paperless payments directly from Banner.  Use IntelleCard to seamlessly convert the existing process of printing checks into an electronic transfer onto the IntelleCard Student Visa Payment Card.  This process reduces staff time and printing costs, while affording students access electronically to funds without exposing them to the risks of credit.

Financial Aid BOF
Jared Hallows, Southern Utah University
Session #W06-104
Of Interest to Financial Aid
            Basic Financial Aid Birds Of a Feather

Handy Dandy Banner Screens
Claudia Jarrett, Snow College
Session #W06-152
Of Interest to Human Resources
            With so many different screens in Banner, it is understandable that some just arenâ t used or even known about. This short presentation is an overview of some of these screen that are easy to access and get great information in a hurry.

How to Effectively Use Householding
Keleigh Allen, Pacific Lutheran University
Session #W06-114
Of Interest to Advancement; Alumni; Development
            How and why we use the Householding enhancement from the Advancement perspective at PLU.  An overview of working out practical solutions to issues we faced with address updates in a shared system with all five modules in use on campus.  Specifically issues with sharing employees and spouses who are donors with Human Resources and sharing parents and students who are donors with Student / Admissions and how this affects our use of householding.

HR and Imaging
Joyce Scheck, Washburn University
Session #W06-127
Of Interest to General/Special Interest; Human Resources
            This session will show how Washburn is using XTender Solutions (BXS) in the Human Resources Department.

HR BOF
Carol Welch, University of Portland & Linda Griffin, Washburn University
Session #W06-137
Of Interest to Human Resources
            An informal discussion session on Human Resources and Payroll topics.  Share ideas, ask questions, make new contacts.

Implementing Calling Software
Dane Frazier, Cal State / Chico
Session #W06-109
Of Interest to Advancement; Alumni; Development
            Brief overview of implementing a calling center software package.

Implementing EPOS Voice Response - Challenges & Successes
Erica Grong, University of New Mexico
Session #W06-149
Of Interest to Student
            We will share our experiences with implementing EPOS Voice Response for Registration, Grades, Billing, Admissions, and Financial Aid. Also included:  preparing for upgrade to ver 7, security issues, and a customization (new menu item that allows student to retrieve their Banner ID & PIN by entering their SSN and birthdate).

Improving Operational Efficiency using Oracle's
Erica Daniel, Oracle
Session #W06-144
Of Interest to Reporting; Technical
            Compliance and performance are not options. Learn how information empowers the enterprise. Oracle Business Intelligence reduces the cost and complexity of delivering accurate and timely information.  Additionally, the Oracle Database is analysis ready, with embedded online analytical processing and data mining capabilities.

Letter Generation & FormFusion - Financial Aid
Jared Hallows & April Sims, Southern Utah University
Session #W06-156
Of Interest to Financial Aid; General/Special Interest
            Creating Financial Aid award letters and missing doc letters using Banner and Form Fusion.

Leveraging the Banner 7 API Methodology in Custom Applications & Interfaces
James Gutholm & Ralph Arnett, Evergreen State College
Session #W06-113
Of Interest to Technical
            This session will discuss the technical aspects of leveraging the SunGard delivered Banner 7 APIs and creating custom APIs following the SunGard methodology to develop applications on top of Banner 7.  The presentation will focus on 2 recent projects at TESC.  Building and using APIs, we reduced development time, increased quality, and insulated our applications form the internal intricacies of the Banner system.

Loan Change Transactions
Sasha Van Orman, UHEAA & Regina Smout, Weber State University
Session #W06-129
Of Interest to Financial Aid
            Discussion with Utah Higher Education Assistance Authority on doing electronic change transactions using RPAELAP.

Migrating Oracle Versions as a Management Project
April Sims, Southern Utah University
Session #W06-105
Of Interest to General/Special Interest; Technical
            A case study for the migration of Oracle software (both Database and Application Server) and the impact to your BANNER environment.  Recommendations for end-user testing, hardware upgrade and replacement, projected timelines and resource allocation.    This presentation is intended for management but anyone interested is welcome to attend.

Migrating to Linux
April Sims, Southern Utah University
Session #W06-103
Of Interest to Technical
            Southern Utah University is currently migrating our hardware from Solaris to Linux.  It is a multi-year project with several milestones.  Discussion will include 32bit vs 64bit, initial hardware costs, operating system costs, yearly contract maintenance and transition costs.  The project has changed several times as we found an easy workaround for one of the major issues: lack of a certified 64-bit Cobol compiler for Linux by running all gurjobs on a separate node.

Moving & Improving Data - Ban7 & ODS 3.0
Joyce Scheck, Washburn University
Session #W06-128
Of Interest to Reporting
            What it takes to prepare and install ODS ver 3.0.  Learn about the technical planning and the approach to install the new version of ODS 3.0.  Provide an overview and screenshots of the functionality of the ODS Admistration Tool.

Muddle Through with CAPP
Karen Thurmond, The University of Memphis
Session #W06-132
Of Interest to Student
            The University of Memphis is in the midst of a migration from Plus to Banner.  CAPP doesn't migrate or convert, so we start from scratch.  If you are planning to move from Plus to Banner,
or if you have already made the move, come share insights and ask questions.

Multiple PIDMs
Joe Belnap, Utah Valley State
Session #W06-166
Of Interest to General/Special Interest; Technical
            Multiple PIDMs should be avoided as much as possible, however, they can't be completely eliminated. This session offers preventative measures as well as automated processes that will quickly identify possible duplicates before they get out of hand. Also provided are scripts used to resolve multiple PIDM issues as painlessly as possible.

On-Demand Training for Business Services/Banner Finance Using the Camtasia Product
Julie Cannon, University of Montana
Session #W06-159
Of Interest to Finance
            This session will include an overview of the University of Montana's use of the Camtasia product for on demand finance training.  The Camtais product is used to record information on a computer screen in order to provide dynamic video tutorials and training presentations for Web delivery.

Online Course / Instructor Evaluations in Banner
Kevin Runner, Runner Technologies, Inc.
Session #W06-98
Of Interest to Student
            This presentation will explore Runner Technologies' Course and Instructor Evaluation System.  Miami University of Ohio recently replaced their Scantron course evaluation process with this Web based system, giving students more flexibility and anonymity when giving candid feedback about a course or instructor.  The survey management system is flexible enough to handle other anonymous or named surveys as well.  Administrators can reuse, modify, and clone surveys very efficiently with this system.

Oracle 10g New Features Highlighting Management Packs
Debbie Brennan, Oracle
Session #W06-146
Of Interest to Technical
            This session will show the new features of Oracle 10g database highlighting Grid Control.  Enterprise Manager 10g Grid Control provides a single interface for monitoring and managing your entire Oracle  co-system.  The base level functionality includes: enterprise health status including target availability, real-time monitoring and alerting, database/application server administration and maintenance, target grouping, job automation, and enterprise reporting.

Oracle BI Discoverer Reporting
April Sims, Southern Utah University
Session #W06-110
Of Interest to Technical
            Gain hands-on experience with Oracle Business Intelligence Products Discoverer Ad-Hoc Query and Administrator Tools, create queries against a live BANNER database.  This session will also discuss best practices when installing and maintenance of this reporting tool for campus-wide reporting.  Intended for technical staff in the process of evaluating different reporting options.

Payments onto Higher Ed Payment Card - The Wave of the Future
Carlene Holm, Dixie State College of Utah
Session #W06-125
Of Interest to Finance; Receivables
            Find out how Dixie State College is making a splash, tossing out checks, and moving towards paperless payments by using a Higher Ed Visa Debit Card.  Presentation will cover the history of implementing a Pay Card, How Dixie State is currently using the cards, and what the future plans for program are.

PCard Module Implementation
Margaret Taylor, Oregon State University
Session #W06-124
Of Interest to Finance
            We will walk through the implementation process for getting the Banner PCard module up and running.  We will highlight the key decision points for implementing and discuss the pitfalls and surprises we encountered in the process.  We'll cover additional reporting designed in-house and modifications that we made.

Personal Profile Channel for Luminis
Terence Stephens, Weber State University
Session #W06-123
Of Interest to Other; Technical
            Methodology & coding for creating a channel in Luminis that will show users what info we have concerning them (address, phone, etc...).  This channel will keep this info in front of the student on the portal and they will quickly be aware if the institution has incorrect information.  I will be presenting coding, implementation, benefit analysis, and methods for making the channel less server intensive (via AJAX, SOAP etc...)

Prospect Management Module Overview
Dana Reedy, California State University, Chico
Session #W06-147
Of Interest to Advancement
            Overview of the Prospect Management Module, to include necessary validation forms, linkages between forms, queries within forms, and reporting suggestions.

Reporting BOF
Joyce scheck, Washburn University
Session #W06-155
Of Interest to Reporting
            An informal discussion session on reporting topics.  Share ideas, ask questions, make new contacts.

Return to Title IV - Again
Barbara Burnett, University of Alaska Southeast
Session #W06-139
Of Interest to Financial Aid
            This session will walk attendees through the steps required to perform the Return to Title IV process using Banner 7.   We will also review the federal regulations concerning this required process, and the changes that occurred as a result of the Higher Education Reconcilliation Act.

RMAN for Backups, Cloning (Knock-on-Wood) and Recovery!
Deborah Lorraine, UC Davis
Session #W06-112
Of Interest to Technical
            Oracle's Recovery Manager gives the DBA a powerful and versatile tool -- and you already have it!  See how easy it is to put RMAN to work for your database backups, recovery and cloning.  Learn why many DBA's say RMAN is the best feature Oracle provides.  Tried and true sample scripts will be provided, and backup strategies will be discussed.  Updated for 10g.

Scholarships Made Easy
Denise Young, Utah Valley State College
Session #W06-135
Of Interest to Advancement; Financial Aid; General/Special Interest
            Denise Young at UVSC has created an amazing scholarship interface using Banner.  Her presentation will showcase what she has created and  show what is possible using Banner and Self Serv to create a user-friendly interface for both students and administrators.

Servant Leadership - Part 1 & 2
Joe Belnap, Utah Valley State
Session #W06-167 & 168
Of Interest to General/Special Interest; Reporting
            Today, organizations are faced with the daunting task of producing more and more with ever decreasing resources. In addition to the issue of employee retention, leaders must deal with the reality of waning loyalty and the necessity of seeking commitment over conformity.  Motivation and commitment are important but not enough to get us where we want to be. Highly committed and motivated incompetence is still incompetence.  The idea of a being simultaneously a leader and a follower to the same individuals may seem to be a complete paradox, though further examination identifies it as an innovative way to change, grow, and improve. When you turn the pyramid upside down, who is at the top of the organization? The customer-contact people. Who is really at the top of the organization? The customers. This one change, although it seems minor, makes a major difference. The difference is between who is responsible and who is responsive. With the traditional pyramid, the boss is always responsible, and the staff are supposed to be responsive to the boss. When you turn the pyramid upside down those
roles get reversed. Your people become responsible and the job of management is to be responsive to their people.  Remember, the word responsible means 'able to respond.' This session will show you how.

SETA's New Web Site & Code Repository
Bob Schneider, Western Washington University
Session #W06-162
Of Interest to General/Special Interest
            Live demo of the new SETA Web site.  The greatest new feature is the addition of a Code Repository.  With the Code Repository any SETA member can search a database for application code that has been submitted to the Repository by all other SETA members.  Are you looking for software enhancements to Banner, Plus, etc?  Do you have software you've written that could be contributed to the user community?  Other significant enhancements are:  new simplified look and navigation; automated job posting; automated presentation submittal; greatly improved individual and institution directory search capability.

SMART and ACG Grants &  Banner
Jared Hallows, Southern Utah University
Session #W06-133
Of Interest to Financial Aid
            Following NASFAA, there are a zillion questions and concerns with the new Federal SMART and ACG grant programs.  This session will allow us to discuss what we have done with banner concerning these two programs, what works and what does not.

The 5-Minute DBA -- SQL Tuning and the SQL Toolkit
Kevin Runner, Runner Technologies, Inc.
Session #W06-99
Of Interest to Technical
            Strong SQL skills are essential for both developers and DBAs.  This session focuses on the "tools of the trade" to improve your efficiency with Oracle SQL.  We will be using the freeware SQL Toolkit from Runner Technologies, and training on which scripts to run, and when.  SQL Toolkit is a freeware collection of over 150 SQL*Plus queries and utilities which run against an Oracle database.  This time saving collection of SQL scripts is designed for DBAs and developers, and run form the SQL*Plus command prompt.  Increase development efforts by reducing typing and automating common and complex database tasks.

The Collection Process Using the Campus Loan Manager Product
Debbie Sharp, Salt Lake Community College
Session #W06-161
Of Interest to Finance
            This session will give an overview of the Course Loan Manger product and how Salt Lake Community College uses the product for its collection process.

Time & Attendance System
Ron Jensen, Stephen Guzzetti, Ben Read & Cherrie Nelson, Weber State University
Session #W06-95
Of Interest to Human Resources; Technical
            A real time web based time and attendance system that tracks hourly employees time.  It allows hourly employees to clock in and out via the phone, web, and card swipe.  The system uses PL/SQL web services to interact with the front end users screen using .net and the back end Oracle database.  Reporting is done using Crystal Enterprise.

TOAD & Quest Central:  Tips & Tricks
Duane Spencer, Quest Software
Session #W06-120
Of Interest to Technical
            Just for data analysts, developers, and DBAs working with Banner, this session will cover how Banner and database professionals can become more productive in their daily tasks:  navigate the Banner database to get information, query data, and produce reports; analyze the Banner application workload, optimizing SQL queries and PL/SQL code with built-in, expert advice; build and maintain highly performing Banner databases; dramatically reduce the Oracle "learning curve".

TOAD:  In-Depth Tips 'n Tricks Workshop
Duane Spencer, Quest Software
Session #W06-119
Of Interest to Technical
            Just for data analysts, developers, and DBAs working with Banner, this workshop will take an in-depth look at how Banner and database professionals can become more productive in their daily tasks.

TouchNet's Bill Payment Suite with Banner & TouchNet's PCI compliant DataCenter
Steve Mairs, TouchNet
Session #W06-151
Of Interest to Finance
            See how schools are using the TouchNet Bill+Payment Suite to automate student account functions such as bill presentment, payment plan management, and electronic refunds in a secure environment. The session will include a brief overview of the TouchNet system and a brief product tour to demonstrate how the Bill+Payment system can enhance the Banner system. The session will also include an overview of TouchNet's PCI-compliant Data Center.

Using Discoverer Plus to Report Against USU's ODS or Reporting Warehouse
Ryan Merrill & Roy Sleight, Utah State University
Session #W06-107
Of Interest to Reporting; Technical
            A technical discussion describing the methods that USU has implemented to create the ODS and how Oracle's Discoverer Plus / Viewer reporting tools are used to easily create reports.  We will describe the process of extracting Banner's transactional style data into a staging area on the warehouse, the methods used to reogranize the data for intuitive reporting (including the use of Oracle's warehouse Builder, PL/SQL stored procedures, and materialized views), and demonstrate some of the capabilities of Discoverer Plus.

Using the Cognos Product for Finance Cubes & Reports
Jeannene Shocki, Seattle Pacific Universiy
Session #W06-160
Of Interest to Finance
            An overview of the implementation of the Cognos product by Seattle Pacific University.  This presentation will focus on defining Cognos financial cubes and the reports generated.

Web-based Travel Reimbursement
Joey Mitchell, Krista Borg & Nancy Cameron, University of Oregon
Session #W06-150
Of Interest to Finance
            The University of Oregon developed a web-based travel reimbursement form accessed through Web for Employee that went live in September of 2002.  We will demonstrate the electronic form, highlighting the built-in features such as per diem completion, mileage completion and Banner invoice creation.  Benefits of the form include increased accuracy, quicker payments, and ability to decentralize responsibility.  We will offer tips, and share our implementation plan.

What's New in AppWorx v.7 & Customer Discussions
Reeve Fernandes, AppWorx
Session #W06-118
Of Interest to General/Special Interest
            This session is for existing AppWorx customers.  We will show all the new features and functionality added to the newest AppWorx v.7 product.  We will discuss upgrade strategies for institutions moving from v5.x and v6.x to v7.  This new v7 of AppWorx has a number of components that benefit the Banner community significantly.  The second half of the hour will be opened for general discussion between Banner - AppWorx customers.  Here's a chance for you to ask questions to each other.  AppWorx has always encouraged our Banner customers to communicate with each other, exchange ideas, and also exchange AppWorx chains.  Come tell us how you have automated your payroll process, or your data loads, or many of the finance processes, etc.  We encourage you to bring in some of your AppWorx chains printouts.