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

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