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 29-Jul-2016 01:00 AM 29-Jul-2016 01:00 AM
AWS Billing Reporting Load 29-Jul-2016 02:04 AM 29-Jul-2016 02:04 AM
AWS Billing Staging Load 29-Jul-2016 02:00 AM 29-Jul-2016 02:04 AM
Admissions Data Job Start Time End Time
SRS/Admissions 30-Jul-2016 12:24 AM 30-Jul-2016 12:25 AM
Sequence Static 30-Jul-2016 07:54 PM 30-Jul-2016 07:59 PM
UGA Mod1 Application 30-Jul-2016 04:44 AM 30-Jul-2016 04:45 AM
Undergrad Admissions 30-Jul-2016 08:00 PM *** In progress ***

Estimated completion:
30-Jul-2016 08:52 PM
Undergrad Admissions Summary 29-Jul-2016 08:59 PM 29-Jul-2016 09:34 PM
BBR Data Job Start Time End Time
Load of AR Adjustments 30-Jul-2016 06:08 AM 30-Jul-2016 06:08 AM
Load of AR Applications 30-Jul-2016 06:08 AM 30-Jul-2016 06:10 AM
Load of AR Collections - Delinquencies Data 30-Jul-2016 06:08 AM 30-Jul-2016 06:08 AM
Load of AR Collections - Dunning Data 30-Jul-2016 06:08 AM 30-Jul-2016 06:08 AM
Load of AR Collections - Notes Data 30-Jul-2016 06:08 AM 30-Jul-2016 06:08 AM
Load of AR Collections - Promise Data 30-Jul-2016 06:08 AM 30-Jul-2016 06:08 AM
Load of AR Customers 29-Jul-2016 09:35 PM 29-Jul-2016 10:32 PM
Load of AR Transaction Lines 30-Jul-2016 06:08 AM 30-Jul-2016 06:11 AM
Load of AR Transactions 30-Jul-2016 06:08 AM 30-Jul-2016 06:09 AM
Load of GMS Award Report Log 30-Jul-2016 05:56 AM 30-Jul-2016 05:56 AM
Load of GMS Awards and Projects 30-Jul-2016 05:56 AM 30-Jul-2016 06:10 AM
Snapshot of AR Transactions 30-Jul-2016 06:09 AM 30-Jul-2016 06:13 AM
Snapshot of GMS Award Report Log 30-Jul-2016 05:57 AM 30-Jul-2016 05:57 AM
Business Services Data Job Start Time End Time
Bookstore Extract 30-Jul-2016 05:29 PM 30-Jul-2016 05:29 PM
Chargeback Data Job Start Time End Time
ISC Billing 30-Jul-2016 06:08 AM 30-Jul-2016 06:39 AM
Mainframe Chargeback 06-Jul-2016 02:39 AM 06-Jul-2016 10:34 AM
Telecommunications 27-Jul-2016 01:36 AM 27-Jul-2016 02:33 AM
Email Data Job Start Time End Time
Email Listserv 30-Jul-2016 08:02 AM 30-Jul-2016 08:02 AM
Facilities Data Job Start Time End Time
Building Utilities 30-Jul-2016 09:51 AM 30-Jul-2016 09:52 AM
Space@Penn 29-Jul-2016 11:08 PM 29-Jul-2016 11:20 PM
Work Request Mid-Day 29-Jul-2016 01:30 PM 29-Jul-2016 04:23 PM
Work Requests 29-Jul-2016 11:04 PM 29-Jul-2016 11:37 PM
Financial Data Job Start Time End Time
Assets 30-Jul-2016 07:54 AM 30-Jul-2016 08:19 AM
Assets Snapshot 30-Jul-2016 08:19 AM 30-Jul-2016 08:23 AM
BBR Balances 24-Jul-2016 09:46 AM 24-Jul-2016 10:02 AM
Balances 30-Jul-2016 07:54 AM 30-Jul-2016 09:51 AM
BenReports Security 30-Jul-2016 07:54 AM 30-Jul-2016 07:57 AM
Budget Periods 30-Jul-2016 06:08 AM 30-Jul-2016 06:08 AM
CREF/PI Update 30-Jul-2016 06:08 AM 30-Jul-2016 06:14 AM
Fund Status Update 30-Jul-2016 09:51 AM 30-Jul-2016 10:10 AM
GAAP Report Template 30-Jul-2016 09:51 AM 30-Jul-2016 10:16 AM
GL Detail 30-Jul-2016 06:08 AM 30-Jul-2016 06:30 AM
GL Parent Reference 30-Jul-2016 07:49 AM 30-Jul-2016 07:54 AM
GL Reference 30-Jul-2016 05:57 AM 30-Jul-2016 06:08 AM
GL Report Templates 30-Jul-2016 09:51 AM 30-Jul-2016 10:08 AM
Overhead Rates 24-Jul-2016 09:48 AM 24-Jul-2016 10:18 AM
Responsible Org 30-Jul-2016 10:11 AM 30-Jul-2016 10:31 AM
Summary Balances 24-Jul-2016 03:15 AM 24-Jul-2016 04:35 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 30-Jul-2016 07:00 AM 30-Jul-2016 07:02 AM
Grad Admissions CN Enrollment Reports Load 30-Jul-2016 04:47 PM 30-Jul-2016 04:49 PM
Grad Admissions GA_PCOM - email for setup codes 30-Jul-2016 04:49 PM 30-Jul-2016 04:49 PM
Grad Admissions Get PennID Updates 30-Jul-2016 04:49 PM 30-Jul-2016 04:49 PM
Grad Admissions IPEDS data load for PennInTouch 30-Jul-2016 04:49 PM 30-Jul-2016 04:49 PM
Grad Admissions SRS Load 29-Jul-2016 05:00 PM 29-Jul-2016 05:00 PM
Grad Admissions SRS Load Errors Feedback 29-Jul-2016 05:01 PM 29-Jul-2016 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) 30-Jul-2016 02:44 AM 30-Jul-2016 03:18 AM
LMS Collection Load (Full) 24-Jul-2016 03:00 PM 24-Jul-2016 04:06 PM
LMS Delta Staging Load 30-Jul-2016 02:40 AM 30-Jul-2016 02:44 AM
LMS Full Staging Load 24-Jul-2016 04:41 AM 24-Jul-2016 03:00 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 30-Jul-2016 08:02 AM 30-Jul-2016 08:31 AM
Emp Comp Payment Load 30-Jul-2016 08:31 AM 30-Jul-2016 08:34 AM
Employee SSN Change 26-Jul-2016 09:14 PM 26-Jul-2016 09:15 PM
Employee/Position Snapshot 30-Jul-2016 08:02 AM 30-Jul-2016 10:11 AM
Encumbrances 26-Jul-2016 06:28 AM 26-Jul-2016 06:39 AM
PAR 26-Jul-2016 03:14 AM 26-Jul-2016 04:06 AM
Payments 26-Jul-2016 05:56 AM 26-Jul-2016 06:28 AM
Payroll Change Log 29-Jul-2016 09:52 PM 29-Jul-2016 10:19 PM
Payroll/HR 29-Jul-2016 10:26 PM 29-Jul-2016 10:47 PM
Payroll/HR Email 30-Jul-2016 07:54 AM 30-Jul-2016 08:02 AM
PennWorks 29-Jul-2016 10:56 PM 29-Jul-2016 11:08 PM
Position 29-Jul-2016 09:28 PM 29-Jul-2016 09:31 PM
Planning Data Job Start Time End Time
GAAPHist Load 30-Jul-2016 11:10 AM 30-Jul-2016 11:24 AM
Hyperion Revexp Load 30-Jul-2016 07:54 AM 30-Jul-2016 08:20 AM
Hyperion Salary Load 29-Jul-2016 10:12 PM 29-Jul-2016 10:51 PM
Research Data Job Start Time End Time
BRIM 01-May-2014 01:44 PM 01-May-2014 05:52 PM
GRAM Snapshot 02-Jul-2016 07:55 AM 02-Jul-2016 08:15 AM
Human Subject Protocols 29-Jul-2016 10:29 PM 29-Jul-2016 10:57 PM
PennERA People 30-Jul-2016 08:02 AM 30-Jul-2016 08:07 AM
Proposal Tracking 30-Jul-2016 08:08 AM 30-Jul-2016 09:36 AM
Protocol Status 29-Jul-2016 10:00 PM 29-Jul-2016 10:29 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 29-Jul-2016 07:01 PM 29-Jul-2016 07:01 PM
Course Eval Staging 04-Apr-2012 04:39 PM 30-Jul-2016 12:25 AM
DTA/Instructor 30-Jul-2016 08:02 AM 30-Jul-2016 08:02 AM
DTA/Student Snapshot 29-Jul-2016 06:30 AM 29-Jul-2016 06:30 AM
Financial Aid Reporting Load 29-Jul-2016 11:56 PM 30-Jul-2016 12:01 AM
Financial Aid Staging Load 29-Jul-2016 09:30 PM 29-Jul-2016 09:38 PM
Pennant Accounts Load 29-Jul-2016 08:22 PM 29-Jul-2016 08:33 PM
Pennant Graduate Funding Load 29-Jul-2016 07:14 PM 29-Jul-2016 07:19 PM
Student 30-Jul-2016 05:08 PM 30-Jul-2016 05:28 PM
Tuition Distribution 30-Jul-2016 05:29 PM 30-Jul-2016 05:29 PM
Travel Data Job Start Time End Time
GAR Update 30-Jul-2016 08:02 AM 30-Jul-2016 08:03 AM
TEM Concur Data Dump Load 30-Jul-2016 08:02 AM 30-Jul-2016 08:22 AM
TEM Concur Standard Accounting Extract (SAE) Load 29-Jul-2016 11:00 PM 29-Jul-2016 11:05 PM
World Travel Update 30-Jul-2016 08:22 AM 30-Jul-2016 08:26 AM

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