OnLine Admissions Applications and ERP Integration

1
On-Line Admissions Applications and ERP
Integration

• Thursday, October 21, 2004
• 220 310 pm

2
Joint Effort

• The Catholic University of America
• Washington, DC
• PeopleSoft Student Administration, Financials,
  EPM, Enterprise Portal and Human Resource
  Management Systems
• Cedar
• PeopleSoft Alliance Partner
• 300 PS Consultants/125 Dedicated HE
• Continuous Client Relationships

3
Todays Presenters
Jim Gallamo Director of ISS, CUA Sonya Hughes
Web Specialist, CUA Louis LeClerc Managing
Principal, Cedar
4
Build Your Own or Outsource

• Application already in place
• Build on current resource investment
• Retain control of technology
• Leverage available system knowledge
• Maintain control of entire process
• Reduce reliance on third party vendors
• Minimize cost of ownership

5
Development Strategy

• ColdFusion used for web component
• PeopleTools and SQR used for integration
• PeopleSoft tables/views used as prompt
• Custom Oracle tables to host additional data
• Staging area for data validation and correction
• Extensive custom search/match
• Processes embedded within student system

6
Timeline
On-line Application and Prospect - May
1998 Rebuilt Application and Prospect - June
1999 PeopleSoft SAS in Production - October
1999 Prospect to PeopleSoft Integration January
2000 Application to PeopleSoft Integration -
January 2001 Added 6 New Applications December
2002
7
Timeline (cont.)
Added 3 New Applications June 2003 Rebuilt
Prospect Web Site February 2004 Added 8 New
Applications May 2004 Added On-line Fee
Collection June 2004 PeopleSoft v8 Upgrade
December 2004
8
Application Statistics
Year Hardcopy On-line 2000 6300 670 2001 5
100 1100 2002 3800 3100 2003 3100 3300 2
004 3000 4000
9
Process Statistics

• Hardcopy Application Entry Time
• 20 minutes
• Online Application Process Time
• lt 5 minutes

10
Application Data Flow
11
On-Line Applications
12
On-Line Applications (cont.)
13
On-Line Applications (cont.)
14
On-Line Applications (cont.)
15
On-Line Applications (cont.)
16
On-Line Applications (cont.)
17
On-Line Applications (cont.)
18
On-Line Applications (cont.)
19
On-Line Applications (cont.)
20
On-Line Applications (cont.)
21
On-Line Applications (cont.)
22
Application Integration
23
Application Integration (cont.)
24
Application Integration (cont.)
25
Application Integration (cont.)
26
Application Integration (cont.)
27
Application Integration (cont.)
28
Application Integration (cont.)
29
Application Integration (cont.)
30
Application Integration (cont.)
31
Application Integration (cont.)
32
Application Integration (contd)
33
Application Integration (contd)
34
Application Integration (contd)
35
Application Processing (cont.)
36
Summary

• Real time applicant and prospect processing
• Complete ownership of process
• Easy to add/change applications
• Bolt-on approach simplify SAS upgrades
• Low cost of on-going maintenance