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 21-Apr-2015 01:00 AM 21-Apr-2015 01:00 AM
AWS Billing Reporting Load 21-Apr-2015 02:06 AM 21-Apr-2015 02:06 AM
AWS Billing Staging Load 21-Apr-2015 02:00 AM 21-Apr-2015 02:06 AM
Admissions Data Job Start Time End Time
Grad Admissions 20-Apr-2015 08:30 AM 20-Apr-2015 12:28 PM
SRS/Admissions 18-Apr-2015 03:55 AM 18-Apr-2015 03:59 AM
Sequence Static 20-Apr-2015 11:55 PM 21-Apr-2015 12:19 AM
UGA Mod1 Application 21-Apr-2015 04:45 AM 21-Apr-2015 05:22 AM
Undergrad Admissions 20-Apr-2015 08:00 PM 20-Apr-2015 11:14 PM
Undergrad Admissions Summary 20-Apr-2015 11:15 PM 21-Apr-2015 12:47 AM
Business Services Data Job Start Time End Time
Bookstore Extract 19-Apr-2015 06:20 PM 19-Apr-2015 06:20 PM
Chargeback Data Job Start Time End Time
ISC Billing 21-Apr-2015 01:34 AM 21-Apr-2015 02:05 AM
Mainframe Chargeback 03-Apr-2015 01:28 AM 03-Apr-2015 01:29 AM
Telecommunications 15-Apr-2015 01:38 AM 15-Apr-2015 03:26 AM
Email Data Job Start Time End Time
Email Listserv 18-Apr-2015 05:30 AM 18-Apr-2015 05:30 AM
Facilities Data Job Start Time End Time
Building Utilities 18-Apr-2015 05:19 AM 18-Apr-2015 05:20 AM
Space@Penn 21-Apr-2015 02:06 AM 21-Apr-2015 02:27 AM
Work Request Mid-Day 20-Apr-2015 01:30 PM 20-Apr-2015 01:49 PM
Work Requests 20-Apr-2015 11:17 PM 21-Apr-2015 12:58 AM
Financial Data Job Start Time End Time
Assets 21-Apr-2015 03:21 AM 21-Apr-2015 03:51 AM
Assets Snapshot 01-Apr-2015 07:55 AM 01-Apr-2015 08:12 AM
Balances 21-Apr-2015 04:24 AM *** In progress ***
Tables blocked:

Balances
Balances CapProj
Fund Status
BenReports Security 21-Apr-2015 03:47 AM 21-Apr-2015 04:12 AM
Budget Periods 20-Apr-2015 06:01 AM 20-Apr-2015 06:01 AM
CREF/PI Update 21-Apr-2015 01:34 AM 21-Apr-2015 01:35 AM
Fund Status Update 19-Apr-2015 04:20 AM 19-Apr-2015 04:55 AM
GAAP Report Template 20-Apr-2015 12:00 AM 20-Apr-2015 01:44 AM
GL Detail 21-Apr-2015 02:09 AM 21-Apr-2015 02:53 AM
GL Parent Reference 21-Apr-2015 02:38 AM 21-Apr-2015 03:20 AM
GL Reference 21-Apr-2015 01:23 AM 21-Apr-2015 01:34 AM
GL Report Templates 19-Apr-2015 04:20 AM 19-Apr-2015 04:25 AM
Overhead Rates 19-Apr-2015 04:20 AM 19-Apr-2015 04:33 AM
Responsible Org 18-Apr-2015 05:24 AM 18-Apr-2015 05:47 AM
Summary Balances 19-Apr-2015 04:20 AM 19-Apr-2015 06:06 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) 21-Apr-2015 02:47 AM 21-Apr-2015 04:11 AM
LMS Collection Load (Full) 19-Apr-2015 05:41 AM 19-Apr-2015 08:19 AM
LMS Delta Staging Load 21-Apr-2015 02:40 AM 21-Apr-2015 02:47 AM
LMS Full Staging Load 19-Apr-2015 04:45 AM 19-Apr-2015 05:41 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 21-Apr-2015 04:38 AM 21-Apr-2015 04:51 AM
Emp Comp Payment Load 18-Apr-2015 03:27 AM 18-Apr-2015 03:34 AM
Employee SSN Change 14-Apr-2015 08:37 PM 14-Apr-2015 08:38 PM
Employee/Position Snapshot 01-Apr-2015 07:58 AM 01-Apr-2015 03:45 PM
Encumbrances 14-Apr-2015 05:12 AM 14-Apr-2015 05:35 AM
PAR 21-Apr-2015 04:38 AM *** In progress ***

Estimated completion:
21-Apr-2015 06:58 AM

Tables blocked:

PAR Dollar GTN Adjustments
PAR Earnings
PAR Gross to Net
PAR Hour Adjustments
PAR Main
PAR Tax ACH Benefits
Payments 14-Apr-2015 04:57 AM 14-Apr-2015 05:11 AM
Payroll Change Log 20-Apr-2015 08:47 PM 20-Apr-2015 09:03 PM
Payroll/HR 20-Apr-2015 09:11 PM 21-Apr-2015 01:22 AM
Payroll/HR Email 21-Apr-2015 03:47 AM 21-Apr-2015 04:38 AM
PennWorks 21-Apr-2015 01:40 AM 21-Apr-2015 02:35 AM
Position 20-Apr-2015 08:16 PM 20-Apr-2015 08:27 PM
Planning Data Job Start Time End Time
GAAPHist Load 20-Apr-2015 08:10 AM 20-Apr-2015 08:24 AM
Hyperion Revexp Load 21-Apr-2015 03:21 AM 21-Apr-2015 04:13 AM
Hyperion Salary Load 20-Apr-2015 10:11 PM 20-Apr-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 02-Apr-2015 07:23 AM 02-Apr-2015 07:33 AM
Human Subject Protocols 20-Apr-2015 10:43 PM 20-Apr-2015 11:08 PM
PennERA People 21-Apr-2015 04:38 AM 21-Apr-2015 04:53 AM
Proposal Tracking 21-Apr-2015 04:54 AM *** In progress ***

Estimated completion:
21-Apr-2015 07:12 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 20-Apr-2015 10:00 PM 20-Apr-2015 10:43 PM
Student Data Job Start Time End Time
BRS Detail 18-Apr-2015 06:31 AM 18-Apr-2015 06:52 AM
BRS GL Detail 18-Apr-2015 03:54 AM 18-Apr-2015 03:54 AM
BRS SSN Changes 20-Apr-2015 07:10 PM 20-Apr-2015 07:10 PM
Course Eval Staging 04-Apr-2012 04:39 PM 18-Apr-2015 04:04 AM
DTA/Instructor 18-Apr-2015 03:07 AM 18-Apr-2015 03:07 AM
DTA/Student Snapshot 16-Apr-2015 06:20 AM 16-Apr-2015 08:40 AM
Financial Aid Reporting Load 21-Apr-2015 03:47 AM 21-Apr-2015 03:53 AM
Financial Aid Staging Load 20-Apr-2015 08:53 PM 20-Apr-2015 09:48 PM
GAR Update 20-Apr-2015 02:00 AM 20-Apr-2015 02:03 AM
Student 21-Apr-2015 03:47 AM *** In progress ***

Estimated completion:
21-Apr-2015 06:59 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 18-Apr-2015 06:52 AM 18-Apr-2015 06:52 AM

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