700 likes | 1.02k Views
T2 PowerPark and SCT Banner. Debbie Brosch Indiana University of Pennsylvania Tuesday, November 22, 2005. Introduction.
E N D
T2 PowerPark and SCT Banner Debbie Brosch Indiana University of Pennsylvania Tuesday, November 22, 2005
Introduction • In 2004, IUP implemented T2 Systems PowerPark parking management software. All parking permit management, citation management, parking review board hearings etc are now handled in one complete system.
About IUP • 14,000 students; 1,800 employees • Largest Member of PASSHE • 3 campuses; 1 center; 1 academy • Doctoral I • Clock-hour programs
Banner at IUP • Live with 8 baseline modules and 6 Self Service products since 2000. • Banner 7.x – October 2005 • Oracle 9i Database • Oracle Application Server 10g • Sun Solaris – DB servers • INB Servers (4)
Topics of Discussion • Previous Parking and Citation Systems • Conversion • What Is T2 PowerPark? • Banner Interfaces • Future Plans • Summary • Questions And Answers
Previous System • IUP Custom Parking Permit System (MS Access) • Separate vendor created Citation System (Cardinal) • No link between the two systems.
Conversion Issues • Data in two separate systems. • Cardinal data had no Banner link (no Banner ID), just name • Individuals were duplicated in the Cardinal system. • When converted, we had a lot of duplicate records to merge.
T2 PowerPark • T2 PowerPark helps you manage all aspects of parking - citations, permits, cash management, payments, appeals, vehicle towing, license plate look-up, property maintenance, collections, tracking, wait lists, demand control, and more.
T2 PowerPark • Two Versions • T2 PowerPark Flex • T2 PowerPark
T2 PowerPark Flex • Thin client application, all data as well as the software resides on the server • The client PC accesses the functionality and data via the Web browser. • All updates are made on the server, not on each PC. • Yearly fees involved.
T2 PowerPark • PC installation of software with data stored in an Oracle database. • New updates need applied to each PC • Up front purchase price. No yearly fees other than maintenance. • This is the version used at IUP.
Banner Interfaces • Banner Updates • Demographic, Departmental etc • Online Permit Application • DMV File Processing • Student Holds – Citations
Banner Updates • Each night two files are created, one with active employees and one with active students that had record changes that day. • Every morning, the files get manually imported into PowerPark. • If the person is unavailable for a day or more, there will be multiple employee and student files that need imported into PowerPark. • Each file contains the date the file was created so they are easy to identify.
Online Permit Extract • Nightly Auto Extract from Web. • Program can be run manually for an “extra” run. • This program creates a customer file, vehicle file, and a permit assignment text file. • These 3 files must be imported in the correct order into Powerpark…Customer, Vehicle, Permit Assignment. • A customer permit letter file (mail merge document) is also created.
Banner Job Submissions- Online Permit Extract Address type parameters allow flexibility on which address to send permit to.