PeopleSoft V7.5 Upgrade Plan
|
Task |
Person assigned |
Duration |
Date projected |
Status |
|
Phase I: Preparing for Upgrade |
||||
|
1- Organize the Upgrade |
Diep |
5 days |
2/1/99 |
Done |
|
Phase II: Installing Software |
||||
|
2- Install PeopleSoft Software |
Cara, Byron |
5 days |
2/10/99 |
Done |
|
3- Copy V7 database (UHDEV2K) to UHUPG2K |
Cara, Vernon |
1 day |
2/12/99 |
Done |
|
4- Clean up UHUPG2K a)Update Statisticsb)Audit reports c)Counts report d)Clean PSOJCHNG e)Delete obsolete view |
Vernon |
4 days |
2/15/99 |
Done |
|
Phase III: Upgrade PeopleTools |
15 days |
3/5/99 |
||
|
5- Upgrade PeopleTools System Tables |
Vernon |
Done |
||
|
6- Convert Query Definition |
Vernon, Diep |
Done |
||
|
7- Load Base Data, Messages and SQR String Data |
Vernon |
Done |
||
|
8- Verify the Version Numbers |
Cara, Diep |
Done |
||
|
9- Backup UHUPG2K |
Cara |
Done |
||
|
10- Run Grant and Synonym Scripts |
Vernon |
Done |
||
|
11- Compare PPLTLS75 |
Vernon |
Done |
||
|
12- Export/Copy PPLTLS75 Project |
Cara, Vernon, Diep |
Done |
||
|
13- Load Model Definitions and Stored Statements |
Cara, Diep |
Done |
||
|
14- Audit the Database |
Vernon |
Done |
||
|
Phase IV: Comparing, Reporting and Copying the Upgrade |
3/23/99 |
|||
|
15- Run Rename Scripts |
Vernon |
1 day |
Done |
|
|
16- Backup UHUPG2K |
Cara |
1/2 day |
Done |
|
|
17- Run Upgrade Compare a)Remove Unused Language-Coded Itemsb)Run Upgrade Compare |
Vernon, Diep |
3 days |
Done |
|
|
18- Review Compate Reports |
Diep |
10 days |
Done |
|
|
19- Override Upgrade Compares |
Diep |
5 days |
Done |
|
|
20- Run Upgrade Copy a)Turn Off Change Controlb)Run Upgrade Copy |
Diep, Vernon |
3 days |
Done |
|
|
21- Copy the Non-Comparison Upgrade Projects |
Diep |
1 day |
Done |
|
|
22- Backup UHUPG2K |
Vernon |
1/2 day |
Done |
|
|
Phase V: Using SQL Alter and Create |
10 days |
4/6/99 |
||
|
23- Perform Pre-Alter Table Cleanup a)List Tablespace Namesb)Review EMPLMT_SGBL_SBR |
Vernon, Diep |
Done |
||
|
24- Using SQL to Alter Tables and Fields |
Vernon |
Done |
||
|
25- Use SQL to Create Tables |
Vernon |
Done |
||
|
26- Update Tablespace Names |
Vernon |
Done |
||
|
Phase VI: Converting Data |
Vernon, Diep |
12 days |
4/20/99 |
|
|
27- Refresh Data From UHPROD |
Cancelled |
|||
|
28- Load New Tables with Prompt Data |
Done |
|||
|
29- Backup UHUPG2K |
Done |
|||
|
30- Use SQL to Alter Tables Without Deletes |
Done |
|||
|
31- Copy Data for Renamed Record Fields |
Done |
|||
|
32- Run Data Conversion Scripts |
Done |
|||
|
33- Backup UHUPG2K |
Done |
|||
|
34- Use SQL to Alter Tables With Deletes |
Done |
|||
|
35- Use SQL to Create Views |
Done |
|||
|
36- Use SQL to Create Indexes |
Done |
|||
|
37- Setup for Post-Alter Conversion |
Done |
|||
|
38- Perform Post-Alter Conversion |
Done |
|||
|
39- Load Message and Application System Data |
Done |
|||
|
Phase VII: Clean Up and Testing Database |
||||
|
40- Cleanup and Manual Changes |
Diep, Vernon |
5 days |
5/1/99 |
Done |
|
41- Audit UHUPG2K |
Vernon |
2 days |
5/4/99 |
Done |
|
42- Apply UH Customization |
Lance, Diep |
15 days |
5/31/99 |
Done |