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 08-Aug-2022 12:09 PM 08-Aug-2022 12:15 PM
UGA Mod1 Application 08-Aug-2022 04:45 AM 08-Aug-2022 04:45 AM
Undergrad Admissions 06-Aug-2022 08:09 PM 06-Aug-2022 08:16 PM
Undergrad Admissions Summary 06-Aug-2022 08:16 PM 06-Aug-2022 08:35 PM
BBR Data Job Start Time End Time
Load of AR Adjustments 06-Aug-2022 11:48 PM 06-Aug-2022 11:48 PM
Load of AR Applications 06-Aug-2022 11:48 PM 06-Aug-2022 11:49 PM
Load of AR Collections - Delinquencies Data 06-Aug-2022 11:48 PM 06-Aug-2022 11:48 PM
Load of AR Collections - Dunning Data 06-Aug-2022 11:48 PM 06-Aug-2022 11:48 PM
Load of AR Collections - Notes Data 06-Aug-2022 11:48 PM 06-Aug-2022 11:48 PM
Load of AR Collections - Promise Data 06-Aug-2022 11:48 PM 06-Aug-2022 11:48 PM
Load of AR Customers 07-Aug-2022 08:01 PM 07-Aug-2022 08:04 PM
Load of AR Transaction Lines 07-Aug-2022 12:01 AM 07-Aug-2022 12:02 AM
Load of AR Transactions 06-Aug-2022 11:48 PM 06-Aug-2022 11:49 PM
Load of GMS Award Report Log 07-Aug-2022 12:10 AM 07-Aug-2022 12:11 AM
Load of GMS Awards and Projects 06-Aug-2022 11:41 PM 06-Aug-2022 11:56 PM
Snapshot of AR Transactions 30-Jul-2022 02:33 AM 30-Jul-2022 02:42 AM
Snapshot of GMS Award Report Log 30-Jul-2022 02:25 AM 30-Jul-2022 02:26 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) 08-Aug-2022 12:01 AM 08-Aug-2022 12:04 AM
StarRez Housing Data Snapshot Load (Talend) 05-Aug-2022 11:00 PM 05-Aug-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 08-Aug-2022 05:30 AM 08-Aug-2022 05:30 AM
Facilities Data Job Start Time End Time
Building Utilities 06-Aug-2022 05:07 AM 06-Aug-2022 05:08 AM
Space@Penn 08-Aug-2022 12:55 AM 08-Aug-2022 12:59 AM
Work Request Mid-Day 05-Aug-2022 01:30 PM 05-Aug-2022 01:37 PM
Work Requests 05-Aug-2022 11:05 PM 05-Aug-2022 11:31 PM
Financial Data Job Start Time End Time
Assets 07-Aug-2022 02:48 AM 07-Aug-2022 03:10 AM
Assets Snapshot 30-Jul-2022 05:55 AM 30-Jul-2022 05:58 AM
BBR Balances 07-Aug-2022 12:31 PM 07-Aug-2022 01:02 PM
Balances 07-Aug-2022 02:36 AM 07-Aug-2022 07:15 AM
BenReports Security 08-Aug-2022 12:53 AM 08-Aug-2022 12:54 AM
Budget Periods 08-Aug-2022 06:01 AM 08-Aug-2022 06:01 AM
CREF/PI Update 07-Aug-2022 01:02 AM 07-Aug-2022 01:05 AM
Fund Status Update 07-Aug-2022 12:31 PM 07-Aug-2022 12:51 PM
GAAP Report Template 08-Aug-2022 01:30 AM 08-Aug-2022 01:42 AM
GL Detail 06-Aug-2022 11:48 PM 06-Aug-2022 11:53 PM
GL Parent Reference 07-Aug-2022 02:45 AM 07-Aug-2022 02:48 AM
GL Reference 06-Aug-2022 11:43 PM 06-Aug-2022 11:48 PM
GL Report Templates 07-Aug-2022 12:31 PM 07-Aug-2022 12:40 PM
Overhead Rates 07-Aug-2022 12:31 PM 07-Aug-2022 01:28 PM
Responsible Org 08-Aug-2022 12:53 AM 08-Aug-2022 12:53 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 08-Aug-2022 07:00 AM 08-Aug-2022 07:00 AM
Grad Admissions CN Enrollment Reports Load 06-Aug-2022 04:02 PM 06-Aug-2022 04:04 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 08-Aug-2022 05:51 AM 08-Aug-2022 05:59 AM
LMS Collection Load 08-Aug-2022 04:18 AM 08-Aug-2022 06:01 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 08-Aug-2022 12:47 AM 08-Aug-2022 12:50 AM
HCM Payments and Encumbrances 08-Aug-2022 12:50 AM 08-Aug-2022 12:53 AM
HCM Person and Position 08-Aug-2022 12:32 AM 08-Aug-2022 12:47 AM
HCM Position History 08-Aug-2022 12:47 AM 08-Aug-2022 12:48 AM
HCM Snapshots 01-Aug-2022 06:01 AM 01-Aug-2022 06:26 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 08-Aug-2022 12:53 AM 08-Aug-2022 12:55 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) 08-Aug-2022 04:34 AM 08-Aug-2022 04:34 AM
Hyperion Revexp Load 08-Aug-2022 01:12 AM 08-Aug-2022 01:30 AM
Hyperion Salary Load 08-Aug-2022 01:09 AM 08-Aug-2022 01:12 AM
Research Data Job Start Time End Time
BRIM 01-May-2014 01:44 PM 01-May-2014 05:52 PM
GRAM Snapshot 02-Aug-2022 04:48 AM 02-Aug-2022 04:56 AM
Human Subject Protocols 05-Aug-2022 10:00 PM 05-Aug-2022 10:44 PM
Lab Animal protocol data 05-Aug-2022 10:45 PM 05-Aug-2022 11:10 PM
PennERA People 06-Aug-2022 02:31 AM 06-Aug-2022 02:32 AM
Proposal Tracking 06-Aug-2022 02:33 AM *** In progress ***
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 05-Aug-2022 10:00 PM 05-Aug-2022 10:49 PM
RIS Community Data DW Load 06-Aug-2022 07:43 PM 06-Aug-2022 07:43 PM
RIS Subaward and MTA/NMA DW Load 06-Aug-2022 07:43 PM 06-Aug-2022 07:45 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 05-Aug-2022 11:09 PM
Curriculum Management Part1 08-Aug-2022 06:00 AM *** In progress ***
Curriculum Management Part2 05-Aug-2022 06:13 AM 05-Aug-2022 06:17 AM
DTA/Instructor 06-Aug-2022 02:31 AM 06-Aug-2022 02:31 AM
DTA/Student Snapshot 21-May-2022 06:19 AM 21-May-2022 06:38 AM
Financial Aid Reporting Load 05-Aug-2022 11:28 PM 06-Aug-2022 01:22 AM
Financial Aid Staging Load 05-Aug-2022 10:13 PM 05-Aug-2022 11:28 PM
Pennant Accounts Load 05-Aug-2022 09:01 PM 05-Aug-2022 09:20 PM
Pennant Graduate Funding Load 06-Aug-2022 06:00 AM 06-Aug-2022 06:03 AM
Pennant Student Records 08-Aug-2022 12:01 AM 08-Aug-2022 02:23 AM
Student 07-Aug-2022 05:05 PM 07-Aug-2022 05:18 PM
Tuition Distribution 08-Aug-2022 12:55 AM 08-Aug-2022 12:55 AM
Travel Data Job Start Time End Time
GAR Update 23-Sep-2021 02:00 AM *** Job failed ***
ISOS Travel Data 08-Aug-2022 01:00 AM 08-Aug-2022 01:05 AM
TEM Concur Data Dump Load 08-Aug-2022 12:55 AM 08-Aug-2022 01:16 AM
TEM Concur Standard Accounting Extract (SAE) Load 05-Aug-2022 11:00 PM 05-Aug-2022 11:04 PM
World Travel Update 06-Aug-2022 02:05 AM 06-Aug-2022 02:22 AM

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