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 09-Oct-2015 01:00 AM 09-Oct-2015 01:00 AM
AWS Billing Reporting Load 09-Oct-2015 02:10 AM 09-Oct-2015 02:10 AM
AWS Billing Staging Load 09-Oct-2015 02:00 AM 09-Oct-2015 02:10 AM
Admissions Data Job Start Time End Time
Grad Admissions 09-Oct-2015 08:30 AM 09-Oct-2015 08:38 AM
SRS/Admissions 09-Oct-2015 04:02 AM 09-Oct-2015 04:04 AM
Sequence Static 09-Oct-2015 09:54 PM 09-Oct-2015 09:56 PM
UGA Mod1 Application 09-Oct-2015 04:44 AM 09-Oct-2015 04:46 AM
Undergrad Admissions 09-Oct-2015 08:00 PM 09-Oct-2015 09:15 PM
Undergrad Admissions Summary 09-Oct-2015 09:15 PM 09-Oct-2015 09:49 PM
BBR Data Job Start Time End Time
Load of AR Adjustments 09-Oct-2015 12:00 AM 09-Oct-2015 12:00 AM
Load of AR Applications 09-Oct-2015 12:00 AM 09-Oct-2015 12:05 AM
Load of AR Customers 09-Oct-2015 08:02 PM 09-Oct-2015 08:15 PM
Load of AR Transaction Lines 09-Oct-2015 12:00 AM 09-Oct-2015 12:02 AM
Load of AR Transactions 09-Oct-2015 12:00 AM 09-Oct-2015 12:01 AM
Load of GMS Award Report Log 09-Oct-2015 12:09 AM 09-Oct-2015 12:13 AM
Load of GMS Awards and Projects 09-Oct-2015 12:09 AM 09-Oct-2015 01:37 AM
Snapshot of AR Transactions 01-Oct-2015 03:22 AM 01-Oct-2015 03:31 AM
Snapshot of GMS Award Report Log 01-Oct-2015 03:07 AM 01-Oct-2015 03:08 AM
Business Services Data Job Start Time End Time
Bookstore Extract 09-Oct-2015 03:59 AM 09-Oct-2015 03:59 AM
Chargeback Data Job Start Time End Time
ISC Billing 08-Oct-2015 11:57 PM 09-Oct-2015 12:44 AM
Mainframe Chargeback 02-Oct-2015 11:35 PM 02-Oct-2015 11:36 PM
Telecommunications 07-Oct-2015 12:07 AM 07-Oct-2015 02:25 AM
Email Data Job Start Time End Time
Email Listserv 09-Oct-2015 05:30 AM 09-Oct-2015 05:30 AM
Facilities Data Job Start Time End Time
Building Utilities 09-Oct-2015 02:53 AM 09-Oct-2015 02:54 AM
Space@Penn 08-Oct-2015 10:45 PM 08-Oct-2015 11:00 PM
Work Request Mid-Day 09-Oct-2015 01:30 PM 09-Oct-2015 01:45 PM
Work Requests 08-Oct-2015 11:15 PM 09-Oct-2015 12:54 AM
Financial Data Job Start Time End Time
Assets 09-Oct-2015 01:16 AM 09-Oct-2015 01:42 AM
Assets Snapshot 01-Oct-2015 05:09 AM 01-Oct-2015 05:20 AM
BBR Balances 09-Oct-2015 07:45 AM 09-Oct-2015 08:20 AM
Balances 09-Oct-2015 01:16 AM 09-Oct-2015 02:52 AM
BenReports Security 09-Oct-2015 01:41 AM 09-Oct-2015 01:56 AM
Budget Periods 09-Oct-2015 06:00 AM 09-Oct-2015 06:01 AM
CREF/PI Update 09-Oct-2015 12:00 AM 09-Oct-2015 12:01 AM
Fund Status Update 09-Oct-2015 02:53 AM 09-Oct-2015 03:27 AM
GAAP Report Template 09-Oct-2015 02:53 AM 09-Oct-2015 05:07 AM
GL Detail 09-Oct-2015 12:19 AM 09-Oct-2015 01:15 AM
GL Parent Reference 09-Oct-2015 01:01 AM 09-Oct-2015 01:16 AM
GL Reference 09-Oct-2015 11:34 PM *** In progress ***

Estimated completion:
09-Oct-2015 11:52 PM
GL Report Templates 09-Oct-2015 02:53 AM 09-Oct-2015 02:57 AM
Overhead Rates 04-Oct-2015 08:22 AM 04-Oct-2015 08:52 AM
Responsible Org 09-Oct-2015 02:57 AM 09-Oct-2015 03:22 AM
Summary Balances 04-Oct-2015 03:26 AM 04-Oct-2015 06:12 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) 09-Oct-2015 02:51 AM 09-Oct-2015 04:33 AM
LMS Collection Load (Full) 04-Oct-2015 05:40 AM 04-Oct-2015 08:44 AM
LMS Delta Staging Load 09-Oct-2015 02:40 AM 09-Oct-2015 02:50 AM
LMS Full Staging Load 04-Oct-2015 04:45 AM 04-Oct-2015 05:40 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 09-Oct-2015 02:11 AM 09-Oct-2015 02:19 AM
Emp Comp Payment Load 09-Oct-2015 02:19 AM 09-Oct-2015 02:22 AM
Employee SSN Change 06-Oct-2015 09:26 PM 06-Oct-2015 09:26 PM
Employee/Position Snapshot 01-Oct-2015 07:22 AM 01-Oct-2015 11:44 AM
Encumbrances 06-Oct-2015 04:16 AM 06-Oct-2015 04:50 AM
PAR 06-Oct-2015 02:28 AM 06-Oct-2015 04:15 AM
Payments 06-Oct-2015 09:32 AM 06-Oct-2015 09:35 AM
Payroll Change Log 09-Oct-2015 11:10 PM 09-Oct-2015 11:28 PM
Payroll/HR 09-Oct-2015 11:29 PM *** In progress ***

Estimated completion:
10-Oct-2015 12:18 AM
Payroll/HR Email 09-Oct-2015 01:42 AM 09-Oct-2015 02:11 AM
PennWorks 08-Oct-2015 10:50 PM 08-Oct-2015 11:17 PM
Position 09-Oct-2015 09:14 PM 09-Oct-2015 09:22 PM
Planning Data Job Start Time End Time
GAAPHist Load 09-Oct-2015 08:10 AM 09-Oct-2015 08:23 AM
Hyperion Revexp Load 09-Oct-2015 01:16 AM 09-Oct-2015 01:46 AM
Hyperion Salary Load 09-Oct-2015 10:10 PM 09-Oct-2015 11:23 PM
Research Data Job Start Time End Time
BRIM 01-May-2014 01:44 PM 01-May-2014 05:52 PM
GRAM Snapshot 02-Oct-2015 05:21 PM 02-Oct-2015 05:26 PM
Human Subject Protocols 09-Oct-2015 10:39 PM 09-Oct-2015 11:14 PM
PennERA People 09-Oct-2015 02:11 AM 09-Oct-2015 02:25 AM
Proposal Tracking 09-Oct-2015 02:27 AM 09-Oct-2015 08:05 AM
Protocol Status 09-Oct-2015 10:00 PM 09-Oct-2015 10:39 PM
Student Data Job Start Time End Time
BRS Detail 09-Oct-2015 06:31 AM 09-Oct-2015 06:45 AM
BRS GL Detail 09-Oct-2015 04:21 PM 09-Oct-2015 04:23 PM
BRS SSN Changes 08-Oct-2015 06:15 PM 08-Oct-2015 06:15 PM
Course Eval Staging 04-Apr-2012 04:39 PM 09-Oct-2015 04:09 AM
DTA/Instructor 03-Oct-2015 01:58 AM 03-Oct-2015 05:38 AM
DTA/Student Snapshot 16-Sep-2015 06:23 AM 16-Sep-2015 07:49 AM
Financial Aid Reporting Load 09-Oct-2015 01:41 AM 09-Oct-2015 02:22 AM
Financial Aid Staging Load 09-Oct-2015 08:14 PM 09-Oct-2015 08:31 PM
Pennant Graduate Funding Load 09-Oct-2015 07:01 PM 09-Oct-2015 07:05 PM
Student 09-Oct-2015 01:42 AM 09-Oct-2015 03:58 AM
Tuition Distribution 09-Oct-2015 06:45 AM 09-Oct-2015 06:45 AM
Travel Data Job Start Time End Time
GAR Update 09-Oct-2015 03:58 AM 09-Oct-2015 03:59 AM
TEM Concur Data Dump Load 08-Oct-2015 04:18 PM 08-Oct-2015 08:14 PM
TEM Concur Standard Accounting Extract (SAE) Load 09-Oct-2015 11:00 PM 09-Oct-2015 11:16 PM
World Travel Update 09-Oct-2015 02:14 AM 09-Oct-2015 02:16 AM

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