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 20-Feb-2017 01:00 AM 20-Feb-2017 01:02 AM
AWS Billing Reporting Load 20-Feb-2017 02:02 AM 20-Feb-2017 02:02 AM
AWS Billing Staging Load 20-Feb-2017 02:00 AM 20-Feb-2017 02:02 AM
Admissions Data Job Start Time End Time
SRS/Admissions 18-Feb-2017 12:43 AM 18-Feb-2017 12:44 AM
Sequence Static 20-Feb-2017 11:54 PM 21-Feb-2017 12:01 AM
UGA Mod1 Application 20-Feb-2017 04:44 AM 20-Feb-2017 04:45 AM
Undergrad Admissions 20-Feb-2017 08:00 PM 20-Feb-2017 08:19 PM
Undergrad Admissions Summary 20-Feb-2017 08:19 PM 20-Feb-2017 09:04 PM
BBR Data Job Start Time End Time
Load of AR Adjustments 19-Feb-2017 12:00 AM 19-Feb-2017 12:00 AM
Load of AR Applications 19-Feb-2017 12:00 AM 19-Feb-2017 12:01 AM
Load of AR Collections - Delinquencies Data 19-Feb-2017 12:00 AM 19-Feb-2017 12:00 AM
Load of AR Collections - Dunning Data 18-Feb-2017 11:59 PM 19-Feb-2017 12:00 AM
Load of AR Collections - Notes Data 18-Feb-2017 11:59 PM 19-Feb-2017 12:00 AM
Load of AR Collections - Promise Data 18-Feb-2017 11:59 PM 19-Feb-2017 12:00 AM
Load of AR Customers 20-Feb-2017 08:02 PM 20-Feb-2017 08:17 PM
Load of AR Transaction Lines 19-Feb-2017 12:00 AM 19-Feb-2017 12:01 AM
Load of AR Transactions 18-Feb-2017 11:59 PM 19-Feb-2017 12:00 AM
Load of GMS Award Report Log 19-Feb-2017 12:09 AM 19-Feb-2017 12:10 AM
Load of GMS Awards and Projects 19-Feb-2017 12:09 AM 19-Feb-2017 12:14 AM
Snapshot of AR Transactions 01-Feb-2017 04:35 AM 01-Feb-2017 04:46 AM
Snapshot of GMS Award Report Log 01-Feb-2017 04:24 AM 01-Feb-2017 04:24 AM
Business Services Data Job Start Time End Time
Bookstore Extract 19-Feb-2017 05:31 PM 19-Feb-2017 05:31 PM
Chargeback Data Job Start Time End Time
ISC Billing 18-Feb-2017 12:36 AM 18-Feb-2017 12:55 AM
Mainframe Chargeback 16-Feb-2017 05:48 PM 16-Feb-2017 05:48 PM
Telecommunications 15-Feb-2017 12:55 AM 15-Feb-2017 01:57 AM
Email Data Job Start Time End Time
Email Listserv 18-Feb-2017 05:29 AM 18-Feb-2017 05:31 AM
Facilities Data Job Start Time End Time
Building Utilities 18-Feb-2017 03:27 AM 18-Feb-2017 03:29 AM
Space@Penn 20-Feb-2017 09:39 PM 20-Feb-2017 09:53 PM
Work Request Mid-Day 20-Feb-2017 01:30 PM 20-Feb-2017 01:39 PM
Work Requests 20-Feb-2017 11:04 PM *** In progress ***

Estimated completion:
21-Feb-2017 12:16 AM
Financial Data Job Start Time End Time
Assets 19-Feb-2017 01:58 AM 19-Feb-2017 02:22 AM
Assets Snapshot 01-Feb-2017 06:54 AM 01-Feb-2017 07:00 AM
BBR Balances 19-Feb-2017 02:38 AM 19-Feb-2017 02:56 AM
Balances 19-Feb-2017 01:58 AM 19-Feb-2017 02:38 AM
BenReports Security 18-Feb-2017 02:34 AM 18-Feb-2017 02:38 AM
Budget Periods 20-Feb-2017 06:00 AM 20-Feb-2017 06:01 AM
CREF/PI Update 19-Feb-2017 12:00 AM 19-Feb-2017 12:05 AM
Fund Status Update 19-Feb-2017 02:38 AM 19-Feb-2017 03:08 AM
GAAP Report Template 20-Feb-2017 01:30 AM 20-Feb-2017 01:44 AM
GL Detail 18-Feb-2017 11:58 PM 19-Feb-2017 12:24 AM
GL Parent Reference 19-Feb-2017 01:54 AM 19-Feb-2017 01:58 AM
GL Reference 18-Feb-2017 11:50 PM 18-Feb-2017 11:58 PM
GL Report Templates 19-Feb-2017 02:38 AM 19-Feb-2017 02:57 AM
Overhead Rates 19-Feb-2017 02:38 AM 19-Feb-2017 03:42 AM
Responsible Org 18-Feb-2017 03:50 AM 18-Feb-2017 04:04 AM
Summary Balances 19-Feb-2017 02:38 AM 19-Feb-2017 02:49 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
Grad Admissions Data Job Start Time End Time
Grad Admissions CN Apps Load 20-Feb-2017 07:00 AM 20-Feb-2017 07:04 AM
Grad Admissions CN Enrollment Reports Load 20-Feb-2017 04:49 PM 20-Feb-2017 04:50 PM
Grad Admissions GA_PCOM - email for setup codes 20-Feb-2017 04:50 PM 20-Feb-2017 04:50 PM
Grad Admissions Get PennID Updates 20-Feb-2017 04:50 PM 20-Feb-2017 04:50 PM
Grad Admissions IPEDS data load for PennInTouch 20-Feb-2017 04:50 PM 20-Feb-2017 04:50 PM
Grad Admissions SRS Load 20-Feb-2017 05:00 PM 20-Feb-2017 05:00 PM
Grad Admissions SRS Load Errors Feedback 20-Feb-2017 05:01 PM 20-Feb-2017 05:01 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) 02-Sep-2016 02:46 AM 02-Sep-2016 03:46 AM
LMS Collection Load (Full) 20-Feb-2017 05:45 AM 20-Feb-2017 08:17 AM
LMS Delta Staging Load 02-Sep-2016 02:40 AM 02-Sep-2016 02:46 AM
LMS Full Staging Load 20-Feb-2017 04:41 AM 20-Feb-2017 05:45 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 18-Feb-2017 02:43 AM 18-Feb-2017 02:47 AM
Emp Comp Payment Load 18-Feb-2017 02:47 AM 18-Feb-2017 02:51 AM
Employee SSN Change 14-Feb-2017 08:44 PM 14-Feb-2017 08:45 PM
Employee/Position Snapshot 01-Feb-2017 06:48 AM 01-Feb-2017 05:33 PM
Encumbrances 14-Feb-2017 03:54 AM 14-Feb-2017 04:10 AM
PAR 14-Feb-2017 02:30 AM 14-Feb-2017 03:27 AM
Payments 14-Feb-2017 03:27 AM 14-Feb-2017 03:54 AM
Payroll Change Log 20-Feb-2017 08:45 PM 20-Feb-2017 09:14 PM
Payroll/HR 20-Feb-2017 09:14 PM 20-Feb-2017 09:36 PM
Payroll/HR Email 18-Feb-2017 02:34 AM 18-Feb-2017 02:43 AM
PennWorks 20-Feb-2017 09:47 PM 20-Feb-2017 10:03 PM
Position 20-Feb-2017 08:16 PM 20-Feb-2017 08:19 PM
Planning Data Job Start Time End Time
GAAPHist Load 24-Oct-2016 08:12 AM 24-Oct-2016 08:21 AM
GAAPHist and PennHist Load (Cloud) 20-Feb-2017 03:01 AM 20-Feb-2017 04:48 AM
Hyperion Revexp Load 20-Feb-2017 01:14 AM 20-Feb-2017 01:30 AM
Hyperion Salary Load 20-Feb-2017 01:10 AM 20-Feb-2017 01:13 AM
Research Data Job Start Time End Time
BRIM 01-May-2014 01:44 PM 01-May-2014 05:52 PM
GRAM Snapshot 02-Feb-2017 03:55 AM 02-Feb-2017 04:08 AM
Human Subject Protocols 20-Feb-2017 10:23 PM 20-Feb-2017 11:06 PM
PennERA People 18-Feb-2017 02:43 AM 18-Feb-2017 02:48 AM
Proposal Tracking 18-Feb-2017 02:50 AM 18-Feb-2017 04:24 AM
Protocol Status 20-Feb-2017 10:00 PM 20-Feb-2017 10:23 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 28-Sep-2016 07:00 PM 28-Sep-2016 07:00 PM
Course Eval Staging 04-Apr-2012 04:39 PM 18-Feb-2017 12:46 AM
DTA/Instructor 18-Feb-2017 02:43 AM 18-Feb-2017 02:43 AM
DTA/Student Snapshot 21-Jan-2017 06:18 AM 21-Jan-2017 07:37 AM
Financial Aid Reporting Load 20-Feb-2017 11:28 PM 20-Feb-2017 11:57 PM
Financial Aid Staging Load 20-Feb-2017 09:29 PM 20-Feb-2017 09:41 PM
Pennant Accounts Load 20-Feb-2017 09:25 PM 20-Feb-2017 09:41 PM
Pennant Graduate Funding Load 20-Feb-2017 07:09 PM 20-Feb-2017 07:12 PM
Student 20-Feb-2017 11:53 PM *** In progress ***

Estimated completion:
21-Feb-2017 02:43 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 19-Feb-2017 05:31 PM 19-Feb-2017 05:31 PM
Travel Data Job Start Time End Time
GAR Update 20-Feb-2017 01:59 AM 20-Feb-2017 02:01 AM
TEM Concur Data Dump Load 19-Feb-2017 11:26 PM 19-Feb-2017 11:44 PM
TEM Concur Standard Accounting Extract (SAE) Load 20-Feb-2017 11:00 PM 20-Feb-2017 11:05 PM
World Travel Update 18-Feb-2017 03:10 AM 18-Feb-2017 03:14 AM

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