Transcript Campus Administrative Systems David Cook Information Technology Services [email protected] Objective Understand administrative systems and the responsibilities of the IT professional in this area.

Campus
Administrative
Systems
David Cook
Information Technology Services
[email protected]
Objective
Understand administrative systems and
the responsibilities of the IT professional in
this area
Overview

What are some example administrative
systems?










*DEFINE Inbox Web and 3270 interface
Advisor’s Toolkit
Technology Resource Account Center (TRAC)
What I Owe
Application development standards
Platforms and Tools
Data Access
Output
Training
Project IQ
Student Information Systems
Some of the applications SIS supports:







Online Transcripts
Interactive Degree Audit
(IDA)
Registration (ROSE)
Registration Waitlisting
Study Abroad
*NRRECS
*ADM






Course Schedule
Catalogs
Student Government
Elections
Be a Longhorn
Texas Common App
Electronic Transcript
Server
*DEFINE
Enterprise Resource Planning (ERP) - *DEFINE

Purchasing
 Accounts payable
 Accounts receivable
 Budget

Payroll
 Inventory
 Appointments
 Human Resources
*DEFINE information: http://www.utexas.edu/business/accounting/define/
What Are Some Other
Administrative Systems?


Each major business area has application developers
that write/integrate systems for their business area
Systems used for conducting the business of the
University








e-Proxy – authorization to represent
Bevo Bucks – electronic funds system
Task Manager – job submission
VIP – Alumni System
FAMIS – Facilities Management
TXCLASS system
Compliance Training
Within ITS, Applications and Administrative Systems
provide software infrastructure and support for
business area applications and developers
Administrative Applications

Mostly Web-based
Accessed through UT Direct Portal
 EID authenticated


Still some TN3270 or “green screen”
applications


Require mainframe logon ID
Transactional in nature
Mainframe Logons
and Authorizations

TN3270 applications require mainframe logon
IDs
 Departmental Contacts
 Mainframe orientation (IC 101)
 Beginning class for users with mainframe
logon IDs; see TXCLASS to register
 DPUSER/Apollo (within the mainframe
environment)
 Authorization for users
 Authorization for programs
Development Standards








Real-time integration
Data belongs to the business areas
Business areas build/buy their own
applications in consultation with IT specialists
Think globally act locally – share solutions
“Service” modules to share information and
functionality
Encapsulate audit, access and update
Consistent layer for business logic
Robust, secure and efficient
Platforms and Tools

Enterprise Servers



Natural/Adabas


IBM zOS/e and one Linux partition (mainframe)
Sun Solaris 10 servers (utdirect.utexas.edu)
Authoritative sources for most University data are
stored on mainframe in Adabas
Tamino (XML database) and Oracle
 webAgent
 Java/PHP/Cold Fusion
Accessing Adabas
Mainframe Data



Natural
External to mainframe environment
 uTED – Enterprise Directory (Open LDAP)
 AEMS – Active Directory
 XML Gateway – Web service calls to any
Administrative system
 Batch submission
Many academic systems depend on data from the
mainframe
 Active Directory
 Blackboard
Data Access Methods
Application Developer
Training

ITS Training program



Natural/ADABAS/webagent
Provides trained and vetted developers to campus
Open to current employees wanting to learn tools
SY 101 – Systems Analyst training
 IT Professional Development




Facilitate external training opportunities
Teach best practices and professional methodologies
Teach new technologies.
Contact Applications

Application Assistance from EIS
http://www.utexas.edu/its/
 [email protected]
 Contact training program through the
Education Manager – Sarah Holmes
 [email protected]

Project IQ
Darin Mattke
Information Quest
[email protected]
Jarrett Cole
Information Quest
[email protected]
What is Project IQ?
Project IQ (Information Quest)
Gives University leaders the information they
need in the way they want it …
• Quick extraction of data without custom
programming
• Systematically updated data
• Flexible formatting of data
• Appropriate security
Project IQ Transforms Data into Management
Information for University Leaders
What Is Included?
Phase I: Financials
• Financial Information / Trends
• Appointment Activity
• Budget Information
• Research Activity
Phase II: IQ/PBIS
• Performance Based Instruction System
• Course and Instruction Planning
• Enrollment Management
• Bi-Annual Compacts
• Accountability Systems
How Does Project IQ Work?
Data is extracted from the
mainframe transactional
systems and copied to the
data warehouse on a
nightly basis. The data
warehouse uses Oracle, a
relational database to
store the data.
Once the data is in the
warehouse, then you can
use Cognos web reporting
tools to look at the
information in reports.
More Information?
Web site: https://utdirect.utexas.edu/iq
 Training aids: class materials, Web tutorials,
answers to exercises, sample data
 How to get started
 What’s available
 Questions or suggestions?
 Contact us at [email protected]
Resources

Mailing lists


Contact e-mail addresses



Application developers – [email protected]
[email protected]
[email protected]
URLs








*Define – http://www.utexas.edu/business/accounting/define
TXShop – http://utdirect.utexas.edu/txshop
Group E-Mail – https://utdirect.utexas.edu/gs/oe/index.WBX
Events Calendar – http://utdirect.utexas.edu/events
Blackboard – http://courses.utexas.edu
Department System – http://utdirect.utexas.edu/dept
EIS – http://www.utexas.edu/its/eis
Project IQ – http://utdirect.utexas.edu/iq
Questions?
Activity