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 27-Jul-2020 01:00 AM 27-Jul-2020 01:03 AM
AWS Billing Reporting Load 03-Aug-2020 08:20 AM 03-Aug-2020 08:21 AM
AWS Billing Staging Load 27-Jul-2020 02:01 AM 27-Jul-2020 02:01 AM
Admissions Data Job Start Time End Time
SRS/Admissions 31-Aug-2021 03:21 AM 31-Aug-2021 03:22 AM
Sequence Static 01-Dec-2022 10:56 PM 01-Dec-2022 11:03 PM
UGA Mod1 Application 01-Dec-2022 04:45 AM 01-Dec-2022 04:45 AM
Undergrad Admissions 01-Dec-2022 08:10 PM 01-Dec-2022 08:20 PM
Undergrad Admissions Summary 01-Dec-2022 08:20 PM *** Job failed ***
BBR Data Job Start Time End Time
Load of AR Adjustments 01-Dec-2022 11:59 PM 01-Dec-2022 11:59 PM
Load of AR Applications 01-Dec-2022 11:59 PM 02-Dec-2022 12:01 AM
Load of AR Collections - Delinquencies Data 01-Dec-2022 11:59 PM 02-Dec-2022 12:00 AM
Load of AR Collections - Dunning Data 01-Dec-2022 11:59 PM 01-Dec-2022 11:59 PM
Load of AR Collections - Notes Data 01-Dec-2022 11:59 PM 02-Dec-2022 12:00 AM
Load of AR Collections - Promise Data 01-Dec-2022 11:59 PM 01-Dec-2022 11:59 PM
Load of AR Customers 01-Dec-2022 08:02 PM 01-Dec-2022 08:04 PM
Load of AR Transaction Lines 02-Dec-2022 12:01 AM 02-Dec-2022 12:04 AM
Load of AR Transactions 01-Dec-2022 11:59 PM 02-Dec-2022 12:01 AM
Load of GMS Award Report Log 02-Dec-2022 12:10 AM 02-Dec-2022 12:10 AM
Load of GMS Awards and Projects 01-Dec-2022 11:44 PM 01-Dec-2022 11:51 PM
Snapshot of AR Transactions 01-Dec-2022 03:03 AM 01-Dec-2022 03:14 AM
Snapshot of GMS Award Report Log 01-Dec-2022 02:55 AM 01-Dec-2022 02:55 AM
Business Services Data Job Start Time End Time
Bookstore Extract 22-Oct-2021 11:06 PM 22-Oct-2021 11:06 PM
StarRez Housing Data Refresh (Talend) 02-Dec-2022 12:01 AM 02-Dec-2022 12:04 AM
StarRez Housing Data Snapshot Load (Talend) 25-Nov-2022 11:00 PM 25-Nov-2022 11:01 PM
Chargeback Data Job Start Time End Time
ISC Billing 20-Nov-2018 11:14 PM 20-Nov-2018 11:43 PM
Mainframe Chargeback 03-Feb-2022 12:32 AM 03-Feb-2022 12:33 AM
Email Data Job Start Time End Time
Email Listserv 01-Dec-2022 09:17 AM 01-Dec-2022 09:17 AM
Facilities Data Job Start Time End Time
Building Utilities 01-Dec-2022 09:13 AM 01-Dec-2022 09:16 AM
Space@Penn 02-Dec-2022 01:07 AM 02-Dec-2022 01:11 AM
Work Request Mid-Day 01-Dec-2022 01:30 PM 01-Dec-2022 01:43 PM
Work Requests 01-Dec-2022 11:05 PM 01-Dec-2022 11:56 PM
Financial Data Job Start Time End Time
Assets 01-Dec-2022 09:27 AM 01-Dec-2022 09:48 AM
Assets Snapshot 01-Dec-2022 09:49 AM 01-Dec-2022 09:52 AM
BBR Balances 01-Dec-2022 10:37 AM 01-Dec-2022 12:38 PM
Balances 01-Dec-2022 05:44 AM 01-Dec-2022 07:11 AM
BenReports Security 01-Dec-2022 09:10 AM 01-Dec-2022 09:13 AM
Budget Periods 01-Dec-2022 06:01 AM 01-Dec-2022 06:01 AM
CREF/PI Update 02-Dec-2022 01:07 AM 02-Dec-2022 01:13 AM
Fund Status Update 01-Dec-2022 07:11 AM 01-Dec-2022 07:34 AM
GAAP Report Template 01-Dec-2022 07:11 AM 01-Dec-2022 07:26 AM
GL Detail 01-Dec-2022 11:59 PM 02-Dec-2022 12:07 AM
GL Parent Reference 01-Dec-2022 05:59 AM 01-Dec-2022 06:03 AM
GL Reference 01-Dec-2022 11:46 PM 01-Dec-2022 11:59 PM
GL Report Templates 01-Dec-2022 07:11 AM 01-Dec-2022 07:22 AM
Overhead Rates 27-Nov-2022 03:04 AM 27-Nov-2022 03:46 AM
Responsible Org 01-Dec-2022 09:10 AM 01-Dec-2022 09:16 AM
Summary Balances 24-Apr-2022 02:03 AM 24-Apr-2022 02:08 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 01-Dec-2022 10:11 AM 01-Dec-2022 10:11 AM
Grad Admissions CN Enrollment Reports Load 01-Dec-2022 04:00 PM 01-Dec-2022 04:01 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 16-May-2022 05:22 PM 16-May-2022 05:22 PM
Grad Admissions SRS Load Errors Feedback 16-May-2022 05:22 PM 16-May-2022 05:22 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 01-Dec-2022 05:59 AM 01-Dec-2022 06:12 AM
LMS Collection Load 01-Dec-2022 04:16 AM 01-Dec-2022 06:13 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 02-Jul-2019 04:55 AM 02-Jul-2019 04:57 AM
Emp Comp Payment Load 02-Jul-2019 05:58 AM 02-Jul-2019 05:58 AM
Employee SSN Change 18-Jun-2019 06:12 PM 18-Jun-2019 06:12 PM
Employee/Position Snapshot 29-Jun-2019 01:48 AM 29-Jun-2019 03:45 AM
Encumbrances 02-Jul-2019 05:58 AM 02-Jul-2019 06:03 AM
HCM Legacy Table Update 02-Dec-2022 12:54 AM 02-Dec-2022 12:58 AM
HCM Payments and Encumbrances 02-Dec-2022 12:58 AM 02-Dec-2022 01:03 AM
HCM Person and Position 02-Dec-2022 12:39 AM 02-Dec-2022 12:54 AM
HCM Position History 02-Dec-2022 12:54 AM 02-Dec-2022 12:58 AM
HCM Snapshots 01-Dec-2022 09:17 AM 01-Dec-2022 09:58 AM
PAR 02-Jul-2019 04:55 AM 02-Jul-2019 05:54 AM
Payments 02-Jul-2019 05:54 AM 02-Jul-2019 05:57 AM
Payroll Change Log 02-Jul-2019 02:47 PM 01-Jul-2019 09:34 PM
Payroll/HR 02-Jul-2019 02:50 PM 02-Jul-2019 12:01 AM
Payroll/HR Email 02-Jul-2019 04:44 AM 02-Jul-2019 04:55 AM
Penn ID Update 02-Dec-2022 01:03 AM 02-Dec-2022 01:07 AM
PennWorks 02-Jul-2019 12:06 AM 02-Jul-2019 12:15 AM
Position 02-Jul-2019 02:44 PM 01-Jul-2019 08:51 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) 01-Dec-2022 10:35 AM 01-Dec-2022 10:35 AM
Hyperion Revexp Load 01-Dec-2022 06:03 AM 01-Dec-2022 06:27 AM
Hyperion Salary Load 02-Dec-2022 01:10 AM 02-Dec-2022 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-Nov-2022 06:00 AM 02-Nov-2022 06:09 AM
Human Subject Protocols 01-Dec-2022 10:00 PM 01-Dec-2022 10:42 PM
Lab Animal protocol data 01-Dec-2022 10:42 PM 01-Dec-2022 11:08 PM
PennERA People 01-Dec-2022 09:17 AM 01-Dec-2022 09:18 AM
Proposal Tracking 01-Dec-2022 09:19 AM 01-Dec-2022 11:25 AM
Protocol Status 01-Dec-2022 10:00 PM 02-Dec-2022 12:26 AM
RIS Community Data DW Load 01-Dec-2022 11:26 AM 01-Dec-2022 11:26 AM
RIS Subaward and MTA/NMA DW Load 01-Dec-2022 11:26 AM 01-Dec-2022 11: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 02-Dec-2022 12:11 AM
Curriculum Management Part1 01-Dec-2022 06:00 AM 01-Dec-2022 06:23 AM
Curriculum Management Part2 01-Dec-2022 06:23 AM 01-Dec-2022 06:29 AM
DTA/Instructor 26-Nov-2022 02:09 AM 26-Nov-2022 02:09 AM
DTA/Student Snapshot 21-May-2022 06:19 AM 21-May-2022 06:38 AM
Financial Aid Reporting Load 04-Nov-2022 10:16 PM 04-Nov-2022 10:17 PM
Financial Aid Staging Load 04-Nov-2022 10:15 PM 04-Nov-2022 10:16 PM
Pennant Accounts Load 01-Dec-2022 09:31 PM 01-Dec-2022 10:16 PM
Pennant Graduate Funding Load 01-Dec-2022 06:03 AM 01-Dec-2022 06:06 AM
Pennant Student Records 02-Dec-2022 12:01 AM *** In progress ***
Pennant Student Records Snapshot - DGW 01-Dec-2022 03:21 AM 01-Dec-2022 03:21 AM
Pennant Student Records Snapshot - STUDENT 01-Dec-2022 03:18 AM 01-Dec-2022 03:18 AM
Student 01-Dec-2022 11:43 PM 02-Dec-2022 12:07 AM
Tuition Distribution 02-Dec-2022 01:07 AM 02-Dec-2022 01:07 AM
Travel Data Job Start Time End Time
GAR Update 23-Sep-2021 02:00 AM *** Job failed ***
ISOS Travel Data 02-Dec-2022 01:00 AM 02-Dec-2022 01:09 AM
TEM Concur Data Dump Load 02-Dec-2022 01:07 AM 02-Dec-2022 01:31 AM
TEM Concur Standard Accounting Extract (SAE) Load 01-Dec-2022 11:00 PM 01-Dec-2022 11:08 PM
World Travel Update 01-Dec-2022 09:44 AM 01-Dec-2022 10:03 AM

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