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 23-Apr-2014 01:00 AM 23-Apr-2014 01:00 AM
AWS Billing Reporting Load 23-Apr-2014 02:02 AM 23-Apr-2014 02:02 AM
AWS Billing Staging Load 23-Apr-2014 02:00 AM 23-Apr-2014 02:01 AM
Admissions Data Job Start Time End Time
Grad Admissions 22-Apr-2014 08:30 AM 22-Apr-2014 12:20 PM
SRS/Admissions 22-Apr-2014 07:56 AM 22-Apr-2014 07:58 AM
Sequence Static 22-Apr-2014 11:55 PM 23-Apr-2014 12:06 AM
UGA Mod1 Application 22-Apr-2014 04:45 AM 22-Apr-2014 04:49 AM
Undergrad Admissions 22-Apr-2014 08:00 PM 22-Apr-2014 08:54 PM
Undergrad Admissions Summary 22-Apr-2014 08:54 PM 22-Apr-2014 09:42 PM
Business Services Data Job Start Time End Time
Bookstore Extract 22-Apr-2014 07:55 AM 22-Apr-2014 07:55 AM
Chargeback Data Job Start Time End Time
ISC Billing 23-Apr-2014 12:53 AM 23-Apr-2014 01:47 AM
Mainframe Chargeback 03-Apr-2014 12:19 AM 03-Apr-2014 12:21 AM
Telecommunications 23-Apr-2014 01:47 AM *** In progress ***

Estimated completion:
23-Apr-2014 03:28 AM
Email Data Job Start Time End Time
Email Listserv 22-Apr-2014 07:54 AM 22-Apr-2014 07:54 AM
Facilities Data Job Start Time End Time
Building Utilities 22-Apr-2014 07:22 AM 22-Apr-2014 07:23 AM
Space@Penn 22-Apr-2014 10:07 PM 23-Apr-2014 01:52 AM
Work Request Mid-Day 22-Apr-2014 01:30 PM 22-Apr-2014 02:37 PM
Work Requests 22-Apr-2014 11:31 PM *** In progress ***
Financial Data Job Start Time End Time
Assets 23-Apr-2014 02:01 AM *** In progress ***
Assets Snapshot 01-Apr-2014 08:43 AM 01-Apr-2014 09:11 AM
Balances 23-Apr-2014 02:01 AM *** In progress ***

Estimated completion:
23-Apr-2014 03:16 AM

Tables blocked:

Balances
Balances CapProj
Fund Status
BenReports Security 23-Apr-2014 02:01 AM *** In progress ***
Budget Periods 22-Apr-2014 06:01 AM 22-Apr-2014 06:01 AM
CREF/PI Update 23-Apr-2014 12:53 AM 23-Apr-2014 12:54 AM
Fund Status Update 22-Apr-2014 07:22 AM 22-Apr-2014 08:07 AM
GAAP Report Template 22-Apr-2014 07:22 AM 22-Apr-2014 09:17 AM
GL Detail 23-Apr-2014 01:28 AM *** In progress ***

Estimated completion:
23-Apr-2014 02:39 AM

Tables blocked:

GL Detail
GL Parent Reference 23-Apr-2014 01:18 AM 23-Apr-2014 02:01 AM
GL Reference 23-Apr-2014 12:28 AM 23-Apr-2014 12:53 AM
GL Report Templates 22-Apr-2014 07:22 AM 22-Apr-2014 07:26 AM
Overhead Rates 20-Apr-2014 02:46 AM 20-Apr-2014 07:01 AM
Responsible Org 19-Apr-2014 02:46 AM 19-Apr-2014 02:47 AM
Summary Balances 20-Apr-2014 02:46 AM 20-Apr-2014 04:11 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 21-Apr-2014 07:00 AM 21-Apr-2014 07:55 AM
LMS Data Job Start Time End Time
LMS Collection Load (Delta) 22-Apr-2014 03:22 AM 22-Apr-2014 06:34 AM
LMS Collection Load (Full) 20-Apr-2014 05:40 AM 20-Apr-2014 08:57 AM
LMS Delta Staging Load 22-Apr-2014 02:40 AM 22-Apr-2014 03:22 AM
LMS Full Staging Load 20-Apr-2014 04:47 AM 20-Apr-2014 05:39 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 22-Apr-2014 03:20 AM 22-Apr-2014 03:36 AM
Emp Comp Payment Load 22-Apr-2014 07:03 AM 22-Apr-2014 07:16 AM
Employee SSN Change 22-Apr-2014 08:32 PM 22-Apr-2014 08:32 PM
Employee/Position Snapshot 01-Apr-2014 12:07 PM 01-Apr-2014 08:35 PM
Encumbrances 22-Apr-2014 07:04 AM 22-Apr-2014 07:36 AM
PAR 22-Apr-2014 03:20 AM 22-Apr-2014 06:37 AM
Payments 22-Apr-2014 06:38 AM 22-Apr-2014 07:03 AM
Payroll Change Log 22-Apr-2014 08:48 PM 22-Apr-2014 09:08 PM
Payroll/HR 22-Apr-2014 09:09 PM 22-Apr-2014 10:04 PM
Payroll/HR Email 23-Apr-2014 02:01 AM *** In progress ***
PennWorks 22-Apr-2014 10:25 PM 22-Apr-2014 11:18 PM
Position 22-Apr-2014 08:33 PM 22-Apr-2014 08:40 PM
Planning Data Job Start Time End Time
GAAPHist Load 22-Apr-2014 10:27 AM 22-Apr-2014 10:39 AM
Hyperion Revexp Load 23-Apr-2014 02:01 AM *** In progress ***

Estimated completion:
23-Apr-2014 03:04 AM

Tables blocked:

Hyperion Revexp
Hyperion Salary Load 22-Apr-2014 10:00 PM 22-Apr-2014 11:00 PM
Research Data Job Start Time End Time
BRIM 22-Apr-2014 12:50 AM 22-Apr-2014 11:21 AM
GRAM Snapshot 02-Apr-2014 06:27 AM 02-Apr-2014 07:04 AM
Human Subject Protocols 23-Apr-2014 12:41 AM 23-Apr-2014 01:54 AM
PennERA People 22-Apr-2014 03:20 AM 22-Apr-2014 03:35 AM
Proposal Tracking 22-Apr-2014 03:42 AM 22-Apr-2014 06:55 AM
Protocol Status 22-Apr-2014 10:00 PM 23-Apr-2014 12:41 AM
Student Data Job Start Time End Time
BRS Detail 22-Apr-2014 07:54 AM 22-Apr-2014 08:32 AM
BRS GL Detail 22-Apr-2014 07:54 AM 22-Apr-2014 07:56 AM
BRS SSN Changes 22-Apr-2014 07:21 PM 22-Apr-2014 07:21 PM
Course Eval Staging 04-Apr-2012 04:39 PM 22-Apr-2014 08:05 AM
DTA/Instructor 19-Apr-2014 03:15 AM 19-Apr-2014 03:16 AM
DTA/Student Snapshot 17-Apr-2014 06:15 AM 17-Apr-2014 06:16 AM
Financial Aid Reporting Load 22-Apr-2014 12:34 AM 22-Apr-2014 01:14 AM
Financial Aid Staging Load 22-Apr-2014 08:10 PM *** In progress ***
GAR Update 22-Apr-2014 07:54 AM 22-Apr-2014 07:54 AM
Student 23-Apr-2014 12:28 AM *** In progress ***

Estimated completion:
23-Apr-2014 03:47 AM

Tables blocked:

APW Component
APW Worksheet
Address
Course Inventory
Course Section
Degree Pursual
Degree Term
Enrollment
Hiatus
Leave
Major Minor Term
Person
Photo ID
Student Term
Tuition Distribution 22-Apr-2014 08:33 AM 22-Apr-2014 08:33 AM

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