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 01-Apr-2015 01:00 AM 01-Apr-2015 01:00 AM
AWS Billing Reporting Load 01-Apr-2015 02:03 AM 01-Apr-2015 02:03 AM
AWS Billing Staging Load 01-Apr-2015 02:00 AM 01-Apr-2015 02:02 AM
Admissions Data Job Start Time End Time
Grad Admissions 01-Apr-2015 08:30 AM *** In progress ***
SRS/Admissions 01-Apr-2015 04:03 AM 01-Apr-2015 04:05 AM
Sequence Static 01-Apr-2015 11:55 AM 01-Apr-2015 12:16 PM
UGA Mod1 Application 01-Apr-2015 04:45 AM 01-Apr-2015 04:45 AM
Undergrad Admissions 31-Mar-2015 08:00 PM 31-Mar-2015 10:50 PM
Undergrad Admissions Summary 31-Mar-2015 10:50 PM 31-Mar-2015 11:40 PM
Business Services Data Job Start Time End Time
Bookstore Extract 01-Apr-2015 04:02 AM 01-Apr-2015 04:02 AM
Chargeback Data Job Start Time End Time
ISC Billing 01-Apr-2015 05:37 AM 01-Apr-2015 06:09 AM
Mainframe Chargeback 04-Mar-2015 01:12 AM 04-Mar-2015 01:13 AM
Telecommunications 01-Apr-2015 06:10 AM 01-Apr-2015 07:50 AM
Email Data Job Start Time End Time
Email Listserv 01-Apr-2015 07:58 AM 01-Apr-2015 07:59 AM
Facilities Data Job Start Time End Time
Building Utilities 31-Mar-2015 10:34 AM 31-Mar-2015 10:35 AM
Space@Penn 31-Mar-2015 10:27 PM 31-Mar-2015 10:42 PM
Work Request Mid-Day 31-Mar-2015 01:30 PM 31-Mar-2015 02:22 PM
Work Requests 31-Mar-2015 11:16 PM 01-Apr-2015 12:31 AM
Financial Data Job Start Time End Time
Assets 01-Apr-2015 07:25 AM 01-Apr-2015 07:55 AM
Assets Snapshot 01-Apr-2015 07:55 AM 01-Apr-2015 08:12 AM
Balances 01-Apr-2015 11:53 AM *** In progress ***

Estimated completion:
01-Apr-2015 01:11 PM

Tables blocked:

Balances
Balances CapProj
Fund Status
BenReports Security 01-Apr-2015 07:25 AM 01-Apr-2015 07:54 AM
Budget Periods 01-Apr-2015 06:01 AM 01-Apr-2015 06:01 AM
CREF/PI Update 01-Apr-2015 05:37 AM 01-Apr-2015 05:38 AM
Fund Status Update 29-Mar-2015 06:20 AM 29-Mar-2015 06:57 AM
GAAP Report Template 31-Mar-2015 10:34 AM 31-Mar-2015 12:55 PM
GL Detail 01-Apr-2015 06:34 AM 01-Apr-2015 07:31 AM
GL Parent Reference 01-Apr-2015 06:42 AM 01-Apr-2015 07:25 AM
GL Reference 01-Apr-2015 05:26 AM 01-Apr-2015 05:37 AM
GL Report Templates 31-Mar-2015 10:34 AM 31-Mar-2015 10:38 AM
Overhead Rates 29-Mar-2015 06:20 AM 29-Mar-2015 06:39 AM
Responsible Org 31-Mar-2015 10:39 AM 31-Mar-2015 11:04 AM
Summary Balances 29-Mar-2015 06:20 AM 29-Mar-2015 07:37 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 16-Feb-2015 07:00 AM 16-Feb-2015 07:47 AM
LMS Data Job Start Time End Time
LMS Collection Load (Delta) 01-Apr-2015 02:47 AM 01-Apr-2015 04:24 AM
LMS Collection Load (Full) 29-Mar-2015 05:27 AM 29-Mar-2015 08:15 AM
LMS Delta Staging Load 01-Apr-2015 02:40 AM 01-Apr-2015 02:46 AM
LMS Full Staging Load 29-Mar-2015 04:45 AM 29-Mar-2015 05:27 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 01-Apr-2015 07:58 AM 01-Apr-2015 08:06 AM
Emp Comp Payment Load 01-Apr-2015 08:06 AM 01-Apr-2015 08:13 AM
Employee SSN Change 31-Mar-2015 08:33 PM 31-Mar-2015 08:34 PM
Employee/Position Snapshot 01-Apr-2015 07:58 AM *** In progress ***

Estimated completion:
01-Apr-2015 05:04 PM

Tables blocked:

Employee Benefits Snap
Employee Dist Snap
Employee General Snap
Employee Job Snap
Employee Pay Job Snap
Employee Snap
Employee Tax Snap
Job Class General Snap
Job Class Snap
Position Comparison Summary
Position Summary
Encumbrances 31-Mar-2015 07:31 AM 31-Mar-2015 08:26 AM
PAR 31-Mar-2015 05:42 AM 31-Mar-2015 07:15 AM
Payments 31-Mar-2015 07:15 AM 31-Mar-2015 07:30 AM
Payroll Change Log 31-Mar-2015 09:06 PM 31-Mar-2015 09:18 PM
Payroll/HR 31-Mar-2015 09:18 PM 31-Mar-2015 10:23 PM
Payroll/HR Email 01-Apr-2015 07:25 AM 01-Apr-2015 07:58 AM
PennWorks 31-Mar-2015 10:33 PM 31-Mar-2015 11:06 PM
Position 31-Mar-2015 08:34 PM 31-Mar-2015 08:43 PM
Planning Data Job Start Time End Time
GAAPHist Load 31-Mar-2015 01:49 PM 31-Mar-2015 02:03 PM
Hyperion Revexp Load 01-Apr-2015 07:25 AM 01-Apr-2015 08:26 AM
Hyperion Salary Load 31-Mar-2015 10:11 PM 31-Mar-2015 11:38 PM
Research Data Job Start Time End Time
BRIM 01-May-2014 01:44 PM 01-May-2014 05:52 PM
GRAM Snapshot 01-Mar-2015 08:00 PM 01-Mar-2015 08:07 PM
Human Subject Protocols 31-Mar-2015 10:39 PM 31-Mar-2015 11:25 PM
PennERA People 01-Apr-2015 07:58 AM 01-Apr-2015 08:12 AM
Proposal Tracking 01-Apr-2015 08:16 AM 01-Apr-2015 10:14 AM
Protocol Status 31-Mar-2015 10:00 PM 31-Mar-2015 10:39 PM
Student Data Job Start Time End Time
BRS Detail 01-Apr-2015 06:31 AM 01-Apr-2015 07:08 AM
BRS GL Detail 01-Apr-2015 05:37 AM 01-Apr-2015 05:37 AM
BRS SSN Changes 31-Mar-2015 07:36 PM 31-Mar-2015 07:36 PM
Course Eval Staging 04-Apr-2012 04:39 PM 01-Apr-2015 04:10 AM
DTA/Instructor 28-Mar-2015 03:16 AM 28-Mar-2015 03:17 AM
DTA/Student Snapshot 02-Mar-2015 01:29 PM 02-Mar-2015 02:53 PM
Financial Aid Reporting Load 01-Apr-2015 01:37 AM 01-Apr-2015 01:56 AM
Financial Aid Staging Load 31-Mar-2015 08:14 PM 31-Mar-2015 08:27 PM
GAR Update 01-Apr-2015 07:58 AM 01-Apr-2015 07:59 AM
Student 01-Apr-2015 01:37 AM 01-Apr-2015 04:00 AM
Tuition Distribution 01-Apr-2015 07:08 AM 01-Apr-2015 07:09 AM

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