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 04-Aug-2015 02:09 AM 04-Aug-2015 02:09 AM
AWS Billing Staging Load 04-Aug-2015 02:00 AM 04-Aug-2015 02:08 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 04-Aug-2015 01:37 AM 04-Aug-2015 01:38 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 04-Aug-2015 01:36 AM
BenReports Security 04-Aug-2015 01:49 AM 04-Aug-2015 02:00 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 04-Aug-2015 01:37 AM 04-Aug-2015 02:08 AM
GAAP Report Template 04-Aug-2015 01:37 AM *** In progress ***
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 04-Aug-2015 01:37 AM 04-Aug-2015 01:40 AM
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) 04-Aug-2015 02:50 AM *** In progress ***

Estimated completion:
04-Aug-2015 04:45 AM
LMS Collection Load (Full) 02-Aug-2015 02:30 PM 02-Aug-2015 04:40 PM
LMS Delta Staging Load 04-Aug-2015 02:40 AM 04-Aug-2015 02:49 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 04-Aug-2015 02:21 AM 04-Aug-2015 02:28 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 04-Aug-2015 02:21 AM *** In progress ***

Estimated completion:
04-Aug-2015 04:40 AM

Tables blocked:

PAR Dollar GTN Adjustments
PAR Earnings
PAR Gross to Net
PAR Hour Adjustments
PAR Main
PAR Tax ACH Benefits
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 04-Aug-2015 01:49 AM 04-Aug-2015 02:21 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 04-Aug-2015 02:21 AM 04-Aug-2015 02:36 AM
Proposal Tracking 04-Aug-2015 02:38 AM *** In progress ***

Estimated completion:
04-Aug-2015 04:55 AM

Tables blocked:

PennERA Fund Adjustment
PennERA Increment
PennERA Increment Status History
PennERA Period
PennERA Proposal
PennERA Proposal Activity
PennERA Proposal Investigator
PennERA Proposal Parent
PennERA Proposal Regulatory Approval
PennERA Proposal Status History
PennERA Request
PennERA Request Status History
PennERA Sponsor
PennERA Subcontract
PennERA Subcontractor
PennERA Subcontractor Increment
PennERA Subcontractor Request
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 04-Aug-2015 01:49 AM 04-Aug-2015 02:09 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 04-Aug-2015 01:49 AM *** In progress ***

Estimated completion:
04-Aug-2015 05:00 AM

Tables blocked:

APW Component
APW Worksheet
Address
Approved Academic Programs
Course Inventory
Course Section
Course Section Reg Control
Course Section Tuition School
Degree Pursual
Degree Term
Enrollment
Graduate Language
Graduate Teaching Term
Hiatus
Language Certificate
Language Certificate Term
Leave
Major
Major Minor Term
Masters Thesis
Med Classification Table
PHD Committee
PHD Dissertation
Person
Registration Control
Special Program
Student APS
Student Term
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