| |
Job Description |
Day (3/14 - 3/16) |
Estimated Completion Times |
Actual Completion Times |
| Level 0
Backup of PSPROD |
|
Fri |
12:00 PM |
|
| Student
Financial Aid |
Daily processing should be done by 4:30pm,
no batch jobs at night |
Fri |
3:53 PM |
4:30 PM |
| Contributor
Relations |
Daily processing until 3pm; all batch jobs
done by 6pm |
Fri |
4:14 PM |
6:00 PM |
| Student
Admissions |
Daily processing until 5pm; all batch jobs
done by 7pm |
Fri |
5:26 PM |
7:00
PM |
| Colts
Sync |
Sync of Colts Tables (from PS that support Colts) |
Fri |
7:15 PM |
7:00
PM |
| PS
Replication Layer Completed |
Replication Refresh: last job to run, 7pm |
Fri |
5:56 PM |
7:30 PM |
| Roll
Logs in PSPROD |
Potential Restore Point |
Fri |
7:30 PM |
7:40
PM |
| Production
Shut Down Completed |
Steps to Shut Down Production
have been completed and Production is now ready for SR Conversion |
Fri |
7:40 PM |
7:40
PM |
| |
START RUNNING CONVERSION |
Fri |
7:45 PM |
7:45
PM |
| CNVLD05 |
SQL Loader process to upload
data into STDT COURSE INFO table into Staging Table. |
Fri |
7:55 PM |
7:52
PM |
| CNVLD01 |
Run Analyze of Peoplesoft Tables |
Fri |
8:05 PM |
8:03 PM |
| CNVLD02 |
Load SIS to PS Mapping file into Oracle
table. |
Fri |
8:15 PM |
8:04
PM |
| CNVLD03 |
Read data from SIS extract files
STUDENT DEMO, STDT COLLEGE MAJOR, STDT ADVISOR NUM, and STDT HOLD INFO into
Staging Tables |
Fri |
8:25 PM |
8:13
PM |
| CNVLD04 |
Read
data from SIS extract files STUDENT SEMESTER, STDT S COLLEGE MAJOR, and
STUDENT NOTES into Staging Tables |
Fri |
8:45 PM |
8:29 PM |
| CNVLD06 |
Read
data from SIS extract files BURSAR DEMO into Staging Tables |
Fri |
8:55 PM |
8:30
PM |
| CNVLD07 |
Read
data from SIS extract files STUDENT ENROLL SP08 into Staging Tables |
Fri |
9:05 PM |
8:33
PM |
| CNVLD08 |
Read
data from SIS extract files COURSE EXTRACT SP08 into Staging Tables. |
Fri |
9:15 PM |
8:36
PM |
| CNVLD09 |
Read
data from GR extract files RECORD BIO, RECBIO DEGREE PGM, RECBIO SPEC COMM
into Staging Tables. |
Fri |
9:25 PM |
8:37
PM |
| CNVLD10 |
Read
data from GR extract files RECBIO AEXAM, RECBIO BEXAM, RECBIO MEXAM,
RECBIO QEXAM into Staging Tables. |
Fri |
9:35 PM |
8:40
PM |
| CNVLD11 |
Read
data from GR extract files RECORD SEM into Staging Tables. |
Fri |
9:50 PM |
8:49
PM |
| CNVLD12 |
Read
data from GR extract files FACULTY BIO, FACULTY FIELD,
FAC FIELD CONCENTRATIONS into Staging Tables. |
Fri |
10:00
PM |
8:51
PM |
| Run
Analyze Tables |
Run Analyze Staging Tables. |
Fri |
10:30 PM |
9:06
PM |
| Update
Conversion Population Column on Tables |
Mass update of a column located
on the Staging Tables. |
Fri |
10:50
PM |
9:13
PM |
| Roll
Logs in PSPROD |
Potential Restore Point |
Fri |
11:00
PM |
9:16
PM |
| |
| |
|
|
|
|
| SRCNV01 |
Term/Year - STRM Mapping |
Sat |
1:00 AM |
10:46
PM |
| SRCNV02 |
Bio/Demo Conversion (update
ethnicity, citizenship, visa, ssn, va benefit, ferpa, data of death, bday,
emergency contact, missing addr (home/local), missing phone
(home/local). Updates to existing
students' data in production if that data is unknown or absent. |
Sat |
1:30 AM |
11:24
PM |
| SRCNV03 |
Historical Course Catalog
Conversion |
Sat |
3:30 AM |
12:06
AM |
| SRCNV04 |
Historical Class Schedule
Conversion |
Sat |
5:30 AM |
9:39
AM |
| Roll
Logs in PSPROD |
Potential Restore Point |
Sat |
5:40 AM |
9:44 AM |
| SRCNV05 |
Program/Plan Conversion - Main
Conversion |
Sat |
7:20 AM |
11:02
AM |
| SRCNV05B |
Program/Plan Conversion - Grad
Concentration Conversion |
Sat |
7:25 AM |
11:07
AM |
| SRCNV05C |
Program/Plan Conversion -
Special Semester and Special Status - Plan Additions
|
Sat |
7:30 AM |
11:10
AM |
| SRCNV05D |
Program/Plan Conversion - Update
for Date of Death |
Sat |
7:35 AM |
11:11
AM |
| SRCNV05E |
Program/Plan Conversion -
Undergraduate Double Major Academic Plans |
Sat |
7:40 AM |
11:12
AM |
| Roll
Logs in PSPROD |
Potential Restore Point |
Sat |
7:50 AM |
11:14
AM |
| SRCNV06 |
Residency
Conversion - In-state or Out-of-state. |
Sat |
8:00 AM |
11:20
AM |
| SRCNV07 |
Term Activation Conversion |
Sat |
10:00
AM |
12:48
PM |
| SRCNV08 |
Historical Enrollment Conversion |
Sat |
11:30 AM |
1:50
PM |
| Roll
Logs in PSPROD |
Potential Restore Point |
Sat |
11:40 AM |
2:13
PM |
| SRCNV09 |
Transfer/Test Credit Conversion |
Sat |
12:25 PM |
2:38
PM |
| SRCNV10 |
Student Advisor/Special
Committee Conversion |
Sat |
12:55 PM |
3:01
PM |
| SRCNV12 |
Current Course Catalog
Conversion |
Sat |
1:00 PM |
3:05
PM |
| SRCNV13 |
Current Class Schedule
Conversion |
Sat |
1:10 PM |
3:12 PM |
| SRCNV14 |
Current Term Enrollment
Conversion |
Sat |
1:15 PM |
3:15
PM |
| SRCNV15 |
Inabsentia Enrollment Conversion |
Sat |
1:25 PM |
3:25
PM |
| SRCNV16 |
Graduate Milestones Conversion |
Sat |
1:55 PM |
3:45 PM |
| SRCNV17 |
Graduate and Undergraduate
Advisor Conversion |
Sat |
2:00 PM |
3:46
PM |
| Run
Stats |
Run Analyze/Stats on Peoplesoft
Tables. |
Sat |
2:30 PM |
4:15
PM |
| Roll
Logs in PSPROD |
Potential Restore Point |
Sat |
2:40 PM |
4:20
PM |
| Mass
Enrollment |
Delivered Peoplesoft Job to
enroll students (There are 6
Historical Enrollment Batches, 1 Current Enrollment Batch and 1 Inabsentia
Enrollment Batch). Completion of all 8
batches (5.9 Million Enrollments) has taken in our testing periods anywhere
from 12 to 20 hours. Officially
started Batch 1 at 5:45 PM. Note - Correction Made as Start. WE ARE DONE WITH MASS ENROLLMENT !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! Successfully Processed 5,905,286 Million
Enrollments. 0 left to process as of
7:28 PM. ----------> NO ERRORS : ) |
Sun |
1:10
PM |
7:28
PM |
| Run
Stats |
Run Analyze/Stats on Peoplesoft
Tables. |
Sun |
1:40 PM |
8:18
PM |
| Roll
Logs in PSPROD |
Potential Restore Point |
Sun |
1:50 PM |
8:20
PM |
| Transfer
Credit |
Delivered Peoplesoft Job to post
Transfer credit - STARTED AT 8:21 PM.
PROJECTED TO COMPLETE AT 11:20 PM |
Sun |
4:50 PM |
10:50
PM |
| SRCNV20 |
Miscellaneous Conversion (Dean's
List honors, Holds (Service Indicators in PS), Notes (Transcript Text in PS),
Swim Test (Milestones in PS), and Special Status codes/Tuition Cohorts
(Student Groups in PS)) PROJECTED TO
COMPLETE AT 11:10 PM |
Sun |
5:10 PM |
11:04
PM |
| SRCNV21 |
ACAD PROG Clean Up Job 1. PROJECTED TO COMPLETE AT 11:09 PM |
Sun |
5:15 PM |
11:07
PM |
| SRCNV22 |
ACAD PROG Clean Up Job 2. PROJECTED TO COMPLETE AT 11:12 PM |
Sun |
5:20 PM |
11:14
PM |
| Run
Stats |
Run Analyze/Stats on Peoplesoft
Tables. PROJECTED TO COMPLETE AT 11:44
AM. …...SPECIAL NOTE: There is the potential that this could run longer
than the estimated 30 minutes. A lot
more tables to analyze……….. |
Sun |
5:50 PM |
11:46
PM |
| Roll
Logs in PSPROD |
Potential Restore Point. PROJECTED TO COMPLETE AT 11:54 AM |
Sun |
6:00 PM |
11:47
PM |
| |
CONVERSION COMPLETE - PROJECTED
TO COMPLETE AT 11:47 PM |
Sun |
6:00 PM |
11:47
PM |
| Production
Power Up Completed |
Steps to Bring Production back
up have been completed and Production is now ready for FA Customization
Migration. PROJECTED TO COMPLETE AT
12:17 AM |
Sun |
6:30 PM |
12:18
PM |
| |
Many THANKS to the people who
stuck it out over the long, long, long weekend…. Sarah Christen, Shawn Bower,
Frank Libeau, Kevin Wood, Gary Chaika, Graham Hall. |
|
|
|
| |
|
|
|
|
