Data Warehouse Update/Load Status


Data Warehouse Home
Help Help Log out Close
Data Warehouse
* 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 04-Aug-2015 01:00 AM 04-Aug-2015 01:00 AM
AWS Billing Reporting Load 03-Aug-2015 02:01 AM 03-Aug-2015 02:02 AM
AWS Billing Staging Load 03-Aug-2015 02:00 AM 03-Aug-2015 02:01 AM
Admissions Data Job Start Time End Time
Grad Admissions 03-Aug-2015 08:30 AM 03-Aug-2015 12:03 PM
SRS/Admissions 01-Aug-2015 03:27 AM 01-Aug-2015 03:29 AM
Sequence Static 03-Aug-2015 11:54 PM 04-Aug-2015 12:08 AM
UGA Mod1 Application 03-Aug-2015 04:44 AM 03-Aug-2015 04:45 AM
Undergrad Admissions 03-Aug-2015 08:00 PM 03-Aug-2015 09:31 PM
Undergrad Admissions Summary 03-Aug-2015 09:32 PM 03-Aug-2015 10:17 PM
Business Services Data Job Start Time End Time
Bookstore Extract 02-Aug-2015 07:13 PM 02-Aug-2015 07:13 PM
Chargeback Data Job Start Time End Time
ISC Billing 03-Aug-2015 11:18 PM 03-Aug-2015 11:50 PM
Mainframe Chargeback 03-Jul-2015 05:07 AM 03-Jul-2015 05:08 AM
Telecommunications 29-Jul-2015 12:15 AM 29-Jul-2015 01:29 AM
Email Data Job Start Time End Time
Email Listserv 01-Aug-2015 05:30 AM 01-Aug-2015 05:30 AM
Facilities Data Job Start Time End Time
Building Utilities 01-Aug-2015 08:29 AM 01-Aug-2015 08:30 AM
Space@Penn 03-Aug-2015 09:35 PM 03-Aug-2015 09:53 PM
Work Request Mid-Day 03-Aug-2015 01:30 PM 03-Aug-2015 01:46 PM
Work Requests 03-Aug-2015 11:13 PM 04-Aug-2015 12:20 AM
Financial Data Job Start Time End Time
Assets 04-Aug-2015 12:25 AM 04-Aug-2015 12:48 AM
Assets Snapshot 01-Aug-2015 05:25 AM 01-Aug-2015 05:33 AM
BBR Balances 01-Aug-2015 11:58 AM 01-Aug-2015 12:13 PM
Balances 04-Aug-2015 12:36 AM *** In progress ***

Estimated completion:
04-Aug-2015 01:56 AM

Tables blocked:

Balances
Balances CapProj
Fund Status
BenReports Security 01-Aug-2015 05:05 AM 01-Aug-2015 05:17 AM
Budget Periods 03-Aug-2015 06:00 AM 03-Aug-2015 06:01 AM
CREF/PI Update 04-Aug-2015 12:00 AM 04-Aug-2015 12:01 AM
Fund Status Update 02-Aug-2015 05:25 PM 02-Aug-2015 05:52 PM
GAAP Report Template 03-Aug-2015 12:09 AM 03-Aug-2015 02:23 AM
GL Detail 03-Aug-2015 11:18 PM 03-Aug-2015 11:53 PM
GL Parent Reference 04-Aug-2015 12:18 AM 04-Aug-2015 12:24 AM
GL Reference 03-Aug-2015 11:07 PM 03-Aug-2015 11:18 PM
GL Report Templates 02-Aug-2015 05:25 PM 02-Aug-2015 05:29 PM
Overhead Rates 02-Aug-2015 10:30 PM 02-Aug-2015 11:01 PM
Responsible Org 01-Aug-2015 09:19 AM 01-Aug-2015 09:41 AM
Summary Balances 02-Aug-2015 05:25 PM 02-Aug-2015 07:23 PM
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 16-Feb-2015 07:00 AM 16-Feb-2015 07:47 AM
LMS Data Job Start Time End Time
LMS Collection Load (Delta) 03-Aug-2015 02:45 AM 03-Aug-2015 03:58 AM
LMS Collection Load (Full) 02-Aug-2015 02:30 PM 02-Aug-2015 04:40 PM
LMS Delta Staging Load 03-Aug-2015 02:40 AM 03-Aug-2015 02:45 AM
LMS Full Staging Load 02-Aug-2015 01:49 PM 02-Aug-2015 02:30 PM
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 01-Aug-2015 05:30 AM 01-Aug-2015 05:35 AM
Emp Comp Payment Load 01-Aug-2015 05:35 AM 01-Aug-2015 05:37 AM
Employee SSN Change 28-Jul-2015 09:09 PM 28-Jul-2015 09:09 PM
Employee/Position Snapshot 01-Aug-2015 05:30 AM 01-Aug-2015 09:19 AM
Encumbrances 28-Jul-2015 04:53 AM 28-Jul-2015 05:22 AM
PAR 28-Jul-2015 02:46 AM 28-Jul-2015 04:36 AM
Payments 28-Jul-2015 04:37 AM 28-Jul-2015 04:52 AM
Payroll Change Log 03-Aug-2015 08:30 PM 03-Aug-2015 08:41 PM
Payroll/HR 03-Aug-2015 08:41 PM 03-Aug-2015 09:32 PM
Payroll/HR Email 01-Aug-2015 05:05 AM 01-Aug-2015 05:29 AM
PennWorks 03-Aug-2015 09:39 PM 03-Aug-2015 10:18 PM
Position 03-Aug-2015 09:19 PM 03-Aug-2015 09:26 PM
Planning Data Job Start Time End Time
GAAPHist Load 03-Aug-2015 08:11 AM 03-Aug-2015 08:25 AM
Hyperion Revexp Load 04-Aug-2015 12:25 AM 04-Aug-2015 01:02 AM
Hyperion Salary Load 03-Aug-2015 10:12 PM 03-Aug-2015 11:39 PM
Research Data Job Start Time End Time
BRIM 01-May-2014 01:44 PM 01-May-2014 05:52 PM
GRAM Snapshot 02-Aug-2015 05:25 PM 02-Aug-2015 05:33 PM
Human Subject Protocols 03-Aug-2015 10:39 PM 03-Aug-2015 11:04 PM
PennERA People 01-Aug-2015 05:30 AM 01-Aug-2015 05:41 AM
Proposal Tracking 01-Aug-2015 05:43 AM 01-Aug-2015 07:15 AM
Protocol Status 03-Aug-2015 10:00 PM 03-Aug-2015 10:38 PM
Student Data Job Start Time End Time
BRS Detail 01-Aug-2015 06:30 AM 01-Aug-2015 06:56 AM
BRS GL Detail 01-Aug-2015 03:42 AM 01-Aug-2015 03:42 AM
BRS SSN Changes 03-Aug-2015 06:15 PM 03-Aug-2015 06:15 PM
Course Eval Staging 04-Apr-2012 04:39 PM 01-Aug-2015 03:38 AM
DTA/Instructor 01-Aug-2015 05:30 AM 01-Aug-2015 05:30 AM
DTA/Student Snapshot 31-Jul-2015 06:44 AM 31-Jul-2015 06:44 AM
Financial Aid Reporting Load 01-Aug-2015 01:45 AM 01-Aug-2015 02:16 AM
Financial Aid Staging Load 03-Aug-2015 09:21 PM 03-Aug-2015 09:57 PM
GAR Update 03-Aug-2015 01:59 AM 03-Aug-2015 02:01 AM
Pennant Graduate Funding Load 03-Aug-2015 07:01 PM 03-Aug-2015 07:05 PM
Student 02-Aug-2015 06:09 PM 02-Aug-2015 07:13 PM
Tuition Distribution 01-Aug-2015 06:56 AM 01-Aug-2015 06:56 AM

Copyright © 2015, University of Pennsylvania. All rights reserved.
Statement on privacy