文档介绍：Some Cool Tools for the PeopleSoft Support Team
Session #20649
March 13, 2006
Alliance 2006 Conference
Nashville, Tennessee
1
第一页，共44页。
Stanford University
Founded in 1891
Private university
6,753 undergraduate
8,093 graduate
1,775 faculty
7,565 staff
Located 30 miles south of San Francisco and just north of Silicon Valley.
2
第二页，共44页。
Stanford University and Oracle
Products currently installed:
Campus Solutions 8 SP1
PeopleTools
Enterprise Portal SP1
PeopleTools
Enterprise Learning Management SP1
PeopleTools
3
第三页，共44页。
Student & HR Systems
Student & HR systems is part of Administrative Systems
The infrastructure group is consists of a
1 - Manager
5 - system analysts,
3 - Oracle DBAs
2 - Windows Administrators.
A separate group of developers are also part of Student & HR Systems.
4
第四页，共44页。
Overview
Tools were developed to aid
developers
help maintain security
monitor environments
The Infrastructure Team Supports
6 learning management databases
5 enterprise portal databases
9 student administration databases
5
第五页，共44页。
The Tools
PS Developer’s Page
PS Security Page
PS Status Page
6
第六页，共44页。
Administrator’s Page
7
第七页，共44页。
The Cool Tools
8
第八页，共44页。
The Cool Tools
9
第九页，共44页。
PS Developer’s Page
Upload / Download
SQR
COBOL
Log Files
Input Files
Check Security Setups
Search for various objects
Lookup Database objects
PL/SQL
packages
procedures
functions
triggers
Run Oracle Explain Plans
Allows developers to
10
第十页，共44页。