 |
 |
| Data Warehouse Update/Load Status |
- AWS Billing Data
- Admissions Data
- Business Services Data
- Chargeback Data
- Email Data
- Facilities Data
- Financial Data
- Gifts/Advancement Data
- Intellectual Property
- LMS Data
- Payroll Data
- Planning Data
- Research Data
- Student Data
Data Warehouse Home
Help 
Close
 |
 |
 |
Note: if a table is listed as being blocked, attempts to query it will return an ORA-00942 error (Table or View does not exist.) |
| Items appearing in pink completed within the last 24 hours. |
| AWS Billing Data | Job | Start Time | End Time |
|---|---|---|---|
| AWS Billing Extract | 10-Mar-2014 01:00 AM | 10-Mar-2014 01:00 AM | |
| AWS Billing Reporting Load | 10-Mar-2014 02:08 AM | 10-Mar-2014 02:08 AM | |
| AWS Billing Staging Load | 10-Mar-2014 02:00 AM | 10-Mar-2014 02:08 AM | |
| Admissions Data | Job | Start Time | End Time |
| Grad Admissions | 10-Mar-2014 09:53 PM |
*** In progress ***
Estimated completion: 10-Mar-2014 10:56 PM |
|
| SRS/Admissions | 08-Mar-2014 09:01 AM | 08-Mar-2014 09:03 AM | |
| Sequence Static | 10-Mar-2014 09:55 PM | 10-Mar-2014 10:05 PM | |
| UGA Mod1 Application | 10-Mar-2014 04:45 AM | 10-Mar-2014 04:46 AM | |
| Undergrad Admissions | 10-Mar-2014 08:00 PM | 10-Mar-2014 08:50 PM | |
| Undergrad Admissions Summary | 10-Mar-2014 08:51 PM | 10-Mar-2014 09:36 PM | |
| Business Services Data | Job | Start Time | End Time |
| Bookstore Extract | 09-Mar-2014 06:15 PM | 09-Mar-2014 06:16 PM | |
| Chargeback Data | Job | Start Time | End Time |
| ISC Billing | 08-Mar-2014 12:20 AM | 08-Mar-2014 01:10 AM | |
| Mainframe Chargeback | 05-Mar-2014 12:36 AM | 05-Mar-2014 12:37 AM | |
| Telecommunications | 05-Mar-2014 01:19 AM | 05-Mar-2014 05:49 AM | |
| Email Data | Job | Start Time | End Time |
| Email Listserv | 08-Mar-2014 08:26 AM | 08-Mar-2014 08:26 AM | |
| Facilities Data | Job | Start Time | End Time |
| Building Utilities | 08-Mar-2014 02:33 AM | 08-Mar-2014 02:38 AM | |
| Space@Penn | 10-Mar-2014 10:39 PM |
*** In progress ***
Estimated completion: 11-Mar-2014 12:26 AM |
|
| Work Request Mid-Day | 10-Mar-2014 01:30 PM | 10-Mar-2014 02:13 PM | |
| Work Requests | 07-Mar-2014 11:29 PM | 08-Mar-2014 05:13 AM | |
| Financial Data | Job | Start Time | End Time |
| Assets | 08-Mar-2014 02:21 AM | 08-Mar-2014 03:57 AM | |
| Assets Snapshot | 01-Mar-2014 10:56 AM | 01-Mar-2014 11:21 AM | |
| Balances | 08-Mar-2014 01:22 AM | 08-Mar-2014 02:33 AM | |
| BenReports Security | 08-Mar-2014 01:22 AM | 08-Mar-2014 01:56 AM | |
| Budget Periods | 10-Mar-2014 09:53 PM | 10-Mar-2014 09:53 PM | |
| CREF/PI Update | 08-Mar-2014 12:20 AM | 08-Mar-2014 12:21 AM | |
| Fund Status Update | 08-Mar-2014 02:33 AM | 08-Mar-2014 04:12 AM | |
| GAAP Report Template | 09-Mar-2014 11:17 PM | 10-Mar-2014 12:37 AM | |
| GL Detail | 08-Mar-2014 12:20 AM | 08-Mar-2014 01:35 AM | |
| GL Parent Reference | 08-Mar-2014 12:54 AM | 08-Mar-2014 01:22 AM | |
| GL Reference | 08-Mar-2014 12:01 AM | 08-Mar-2014 12:20 AM | |
| GL Report Templates | 08-Mar-2014 02:33 AM | 08-Mar-2014 02:41 AM | |
| Overhead Rates | 08-Mar-2014 02:33 AM | 08-Mar-2014 07:59 AM | |
| Responsible Org | 08-Mar-2014 07:59 AM | 08-Mar-2014 08:00 AM | |
| Summary Balances | 08-Mar-2014 02:33 AM | 08-Mar-2014 05:35 AM | |
| Gifts/Advancement Data | Job | Start Time | End Time |
| Atlas Ability Rating | 26-Apr-2013 11:50 PM | 27-Apr-2013 12:05 AM | |
| Atlas Ack Table Import | 27-Apr-2013 03:06 AM | 27-Apr-2013 03:35 AM | |
| Atlas Audit | 27-Apr-2013 01:42 AM | 27-Apr-2013 01:44 AM | |
| Atlas BFS | 26-Apr-2013 07:27 PM | 26-Apr-2013 07:27 PM | |
| Atlas Base Gifts Tables | 26-Apr-2013 07:08 PM | 26-Apr-2013 08:53 PM | |
| Atlas Constituents | 26-Apr-2013 07:39 PM | 26-Apr-2013 11:50 PM | |
| Atlas Contact Exclusions | 26-Apr-2013 07:27 PM | 26-Apr-2013 07:32 PM | |
| Atlas Core Table Copy | 26-Apr-2013 07:08 PM | 26-Apr-2013 07:08 PM | |
| Atlas Core Table Copy (Dblink) | 26-Apr-2013 05:28 PM | 26-Apr-2013 07:26 PM | |
| Atlas Couples | 26-Apr-2013 11:50 PM | 26-Apr-2013 11:53 PM | |
| Atlas Designations | 26-Apr-2013 09:48 PM | 26-Apr-2013 09:57 PM | |
| Atlas Gift Detail | 26-Apr-2013 08:58 PM | 26-Apr-2013 09:48 PM | |
| Atlas Gift MVs | 26-Apr-2013 10:34 PM | 27-Apr-2013 02:03 AM | |
| Atlas Gift Summary | 26-Apr-2013 09:57 PM | 26-Apr-2013 10:33 PM | |
| Atlas Giving Frequency | 27-Apr-2013 02:03 AM | 27-Apr-2013 04:53 AM | |
| Atlas Hard Credit | 26-Apr-2013 11:50 PM | 26-Apr-2013 11:51 PM | |
| Atlas Materialized Views | 27-Apr-2013 12:06 AM | 27-Apr-2013 01:33 AM | |
| Atlas Open Pledges | 26-Apr-2013 08:53 PM | 26-Apr-2013 08:56 PM | |
| Atlas Prospect Management | 27-Apr-2013 01:33 AM | 27-Apr-2013 01:41 AM | |
| Atlas Region Codes | 26-Apr-2013 07:27 PM | 26-Apr-2013 07:38 PM | |
| Atlas Reports Etl Import Olga Donation Tables | 27-Apr-2013 05:28 AM | 27-Apr-2013 05:29 AM | |
| Atlas Reports Etl Import Olga Giving Tables | 27-Apr-2013 05:28 AM | 27-Apr-2013 05:35 AM | |
| Atlas Soft Credit | 26-Apr-2013 11:50 PM | 26-Apr-2013 11:51 PM | |
| Atlas Transaction Detail | 26-Apr-2013 08:53 PM | 26-Apr-2013 08:58 PM | |
| Atlas Tribute All | 27-Apr-2013 02:03 AM | 27-Apr-2013 02:49 AM | |
| Atlas Whse_Cnst_Ac_Asgn_All Process | 27-Apr-2013 01:33 AM | 27-Apr-2013 02:07 AM | |
| Atlas Whse_Prospect_Status Table Polulation | 26-Apr-2013 07:27 PM | 26-Apr-2013 07:27 PM | |
| Atlas XLAT | 26-Apr-2013 07:27 PM | 26-Apr-2013 07:27 PM | |
| Atlas Year By School | 26-Apr-2013 07:27 PM | 26-Apr-2013 07:28 PM | |
| Intellectual Property | Job | Start Time | End Time |
| Intellectual Property Load | 10-Mar-2014 07:00 AM | 10-Mar-2014 07:57 AM | |
| LMS Data | Job | Start Time | End Time |
| LMS Collection Load (Delta) | 10-Mar-2014 02:49 AM | 10-Mar-2014 03:57 AM | |
| LMS Collection Load (Full) | 09-Mar-2014 05:32 AM | 09-Mar-2014 07:47 AM | |
| LMS Delta Staging Load | 10-Mar-2014 02:40 AM | 10-Mar-2014 02:48 AM | |
| LMS Full Staging Load | 09-Mar-2014 04:47 AM | 09-Mar-2014 05:32 AM | |
| Legacy Learning Management System | 16-Oct-2012 10:10 AM | 16-Oct-2012 03:02 PM | |
| Payroll Data | Job | Start Time | End Time |
| Emp Comp Dist Load | 08-Mar-2014 02:22 AM | 08-Mar-2014 02:46 AM | |
| Emp Comp Payment Load | 08-Mar-2014 02:47 AM | 08-Mar-2014 02:58 AM | |
| Employee SSN Change | 04-Mar-2014 08:36 PM | 04-Mar-2014 08:36 PM | |
| Employee/Position Snapshot | 01-Mar-2014 10:56 AM | 01-Mar-2014 04:54 PM | |
| Encumbrances | 04-Mar-2014 04:42 AM | 04-Mar-2014 05:23 AM | |
| PAR | 04-Mar-2014 01:54 AM | 04-Mar-2014 03:59 AM | |
| Payments | 04-Mar-2014 04:00 AM | 04-Mar-2014 04:41 AM | |
| Payroll Change Log | 10-Mar-2014 09:29 PM | 10-Mar-2014 09:44 PM | |
| Payroll/HR | 10-Mar-2014 09:44 PM | 10-Mar-2014 10:36 PM | |
| Payroll/HR Email | 08-Mar-2014 01:22 AM | 08-Mar-2014 02:22 AM | |
| PennWorks | 10-Mar-2014 10:48 PM |
*** In progress ***
Estimated completion: 10-Mar-2014 11:15 PM Tables blocked: Pennworks Address Pennworks Distribution Pennworks Distribution Ext Pennworks Person Pennworks Role Pennworks Salary Pennworks Salary Summary |
|
| Position | 10-Mar-2014 09:15 PM | 10-Mar-2014 09:24 PM | |
| Planning Data | Job | Start Time | End Time |
| GAAPHist Load | 10-Mar-2014 08:20 AM | 10-Mar-2014 08:32 AM | |
| Hyperion Revexp Load | 09-Mar-2014 10:52 PM | 09-Mar-2014 11:17 PM | |
| Hyperion Salary Load | 10-Mar-2014 10:00 PM |
*** In progress ***
Estimated completion: 10-Mar-2014 11:49 PM Tables blocked: Hyperion Salary |
|
| Research Data | Job | Start Time | End Time |
| BRIM | 08-Mar-2014 12:20 AM | 08-Mar-2014 08:40 AM | |
| GRAM Snapshot | 01-Mar-2014 07:58 PM | 01-Mar-2014 08:08 PM | |
| Human Subject Protocols | 08-Mar-2014 01:50 AM | 08-Mar-2014 04:15 AM | |
| PennERA People | 08-Mar-2014 02:22 AM | 08-Mar-2014 02:45 AM | |
| Proposal Tracking | 08-Mar-2014 02:49 AM | 08-Mar-2014 05:53 AM | |
| Protocol Status | 10-Mar-2014 10:00 PM |
*** In progress ***
Estimated completion: 11-Mar-2014 12:57 AM |
|
| Student Data | Job | Start Time | End Time |
| BRS Detail | 08-Mar-2014 08:26 AM | 08-Mar-2014 08:55 AM | |
| BRS GL Detail | 08-Mar-2014 08:26 AM | 08-Mar-2014 08:26 AM | |
| BRS SSN Changes | 10-Mar-2014 07:49 PM | 10-Mar-2014 07:49 PM | |
| Course Eval Staging | 04-Apr-2012 04:39 PM | 08-Mar-2014 08:34 AM | |
| DTA/Instructor | 08-Mar-2014 02:22 AM | 08-Mar-2014 08:49 AM | |
| DTA/Student Snapshot | 04-Mar-2014 06:22 AM | 04-Mar-2014 08:39 AM | |
| Financial Aid Reporting Load | 08-Mar-2014 06:23 AM | 08-Mar-2014 12:36 PM | |
| Financial Aid Staging Load | 10-Mar-2014 08:48 PM | *** In progress *** | |
| GAR Update | 10-Mar-2014 02:00 AM | 10-Mar-2014 02:01 AM | |
| Student | 09-Mar-2014 05:06 PM | 09-Mar-2014 06:15 PM | |
| Tuition Distribution | 08-Mar-2014 08:56 AM | 08-Mar-2014 08:56 AM |
Copyright © 2014, University of Pennsylvania. All rights reserved.
Statement on privacy