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.

Admissions Data Job Start Time End Time
Sequence Static 16-Sep-2024 07:55 AM 16-Sep-2024 07:55 AM
UGA Mod1 Application 16-Sep-2024 04:45 AM 16-Sep-2024 04:45 AM
Undergrad Admissions 02-Oct-2023 08:00 PM *** Job failed ***
Undergrad Admissions Summary 02-Oct-2023 08:15 PM *** Job failed ***
BBR Data Job Start Time End Time
Load of AR Adjustments 01-Apr-2025 01:41 AM 01-Apr-2025 01:42 AM
Load of AR Applications 01-Apr-2025 01:41 AM 01-Apr-2025 01:43 AM
Load of AR Collections - Delinquencies Data 01-Apr-2025 01:41 AM 01-Apr-2025 01:42 AM
Load of AR Collections - Dunning Data 01-Apr-2025 01:41 AM 01-Apr-2025 01:42 AM
Load of AR Collections - Notes Data 01-Apr-2025 01:41 AM 01-Apr-2025 01:42 AM
Load of AR Collections - Promise Data 01-Apr-2025 01:41 AM 01-Apr-2025 01:42 AM
Load of AR Customers 01-Apr-2025 08:01 PM 01-Apr-2025 08:04 PM
Load of AR Transaction Lines 01-Apr-2025 01:41 AM 01-Apr-2025 01:46 AM
Load of AR Transactions 01-Apr-2025 01:41 AM 01-Apr-2025 01:42 AM
Load of GMS Award Report Log 01-Apr-2025 01:32 AM 01-Apr-2025 01:34 AM
Load of GMS Awards and Projects 01-Apr-2025 01:32 AM 01-Apr-2025 01:43 AM
Snapshot of AR Transactions 01-Apr-2025 01:43 AM 01-Apr-2025 01:56 AM
Snapshot of GMS Award Report Log 01-Apr-2025 01:34 AM 01-Apr-2025 01:34 AM
Business Services Data Job Start Time End Time
StarRez Housing Data Refresh (Talend) 10-Oct-2023 12:01 AM 10-Oct-2023 12:03 AM
StarRez Housing Data Snapshot Load (Talend) 06-Oct-2023 11:00 PM 06-Oct-2023 11:01 PM
Email Data Job Start Time End Time
Email Listserv 01-Apr-2025 05:30 AM 01-Apr-2025 05:30 AM
Facilities Data Job Start Time End Time
Building Utilities 01-Apr-2025 06:42 AM 01-Apr-2025 06:44 AM
Space@Penn 01-Apr-2025 02:53 AM 01-Apr-2025 02:58 AM
Work Request Mid-Day 01-Apr-2025 01:30 PM 01-Apr-2025 01:43 PM
Work Requests 31-Mar-2025 11:05 PM 31-Mar-2025 11:25 PM
Financial Data Job Start Time End Time
Assets 01-Apr-2025 05:51 AM 01-Apr-2025 06:26 AM
Assets Snapshot 01-Apr-2025 06:33 AM 01-Apr-2025 06:41 AM
BBR Balances 01-Apr-2025 06:42 AM 01-Apr-2025 07:34 AM
Balances 01-Apr-2025 04:53 AM 01-Apr-2025 06:41 AM
BenReports Security 01-Apr-2025 04:40 AM 01-Apr-2025 04:42 AM
Budget Periods 01-Apr-2025 06:01 AM 01-Apr-2025 06:01 AM
CREF/PI Update 01-Apr-2025 02:53 AM 01-Apr-2025 02:57 AM
Fund Status Update 01-Apr-2025 06:42 AM 01-Apr-2025 07:04 AM
GAAP Report Template 01-Apr-2025 06:42 AM 01-Apr-2025 06:57 AM
GL Detail 01-Apr-2025 01:41 AM 01-Apr-2025 01:48 AM
GL Parent Reference 01-Apr-2025 04:37 AM 01-Apr-2025 04:40 AM
GL Reference 01-Apr-2025 01:35 AM 01-Apr-2025 01:41 AM
GL Report Templates 01-Apr-2025 06:42 AM 01-Apr-2025 06:52 AM
Overhead Rates 30-Mar-2025 03:23 AM 30-Mar-2025 03:50 AM
Responsible Org 01-Apr-2025 07:05 AM 01-Apr-2025 07:08 AM
Grad Admissions Data Job Start Time End Time
Grad Admissions CN Apps Load 01-Apr-2025 07:00 AM 01-Apr-2025 07:01 AM
Grad Admissions CN Enrollment Reports Load 01-Apr-2025 04:03 PM 01-Apr-2025 04:04 PM
LMS Data Job Start Time End Time
Finish LMS USER Tables Load 01-Apr-2025 07:15 AM 01-Apr-2025 07:30 AM
LMS Collection Load 01-Apr-2025 04:19 AM 01-Apr-2025 07:31 AM
Workday Learning 02-Dec-2024 03:21 AM 01-Apr-2025 07:54 AM
Payroll Data Job Start Time End Time
HCM Legacy Table Update 01-Apr-2025 02:39 AM 01-Apr-2025 02:43 AM
HCM Payments and Encumbrances 01-Apr-2025 02:43 AM 01-Apr-2025 02:51 AM
HCM Person and Position 01-Apr-2025 02:15 AM 01-Apr-2025 02:38 AM
HCM Position History 01-Apr-2025 02:39 AM 01-Apr-2025 02:42 AM
HCM Snapshots 01-Apr-2025 07:08 AM 01-Apr-2025 07:40 AM
Penn ID Update 01-Apr-2025 02:51 AM 01-Apr-2025 02:53 AM
Planning Data Job Start Time End Time
GAAPHist and PennHist Load (Cloud) 01-Apr-2025 09:46 AM 01-Apr-2025 09:46 AM
Hyperion Revexp Load 01-Apr-2025 04:40 AM 01-Apr-2025 05:02 AM
Hyperion Salary Load 01-Apr-2025 01:09 AM 01-Apr-2025 01:12 AM
Research Data Job Start Time End Time
BRIM 01-May-2014 01:44 PM 01-May-2014 05:52 PM
Human Subject Protocols 31-Mar-2025 10:00 PM 31-Mar-2025 10:25 PM
Lab Animal protocol data 31-Mar-2025 10:26 PM 31-Mar-2025 10:55 PM
PennERA People 01-Apr-2025 04:40 AM 01-Apr-2025 04:42 AM
Proposal Tracking 01-Apr-2025 04:43 AM 01-Apr-2025 07:23 AM
Protocol Status 31-Mar-2025 10:00 PM 31-Mar-2025 10:44 PM
RIS Community Data DW Load 01-Apr-2025 07:23 AM 01-Apr-2025 07:23 AM
RIS Subaward and MTA/NMA DW Load 01-Apr-2025 07:23 AM 01-Apr-2025 07:26 AM
Student Data Job Start Time End Time
Course Eval Staging 04-Apr-2012 04:39 PM 31-Mar-2025 10:06 PM
Curriculum Management Part1 01-Apr-2025 06:00 AM 01-Apr-2025 06:12 AM
Curriculum Management Part2 01-Apr-2025 06:12 AM 01-Apr-2025 06:17 AM
DGW/Degree Planning and Audit 01-Apr-2025 02:06 AM 01-Apr-2025 10:33 AM
DGW/Degree Planning and Audit Snapshot 01-Apr-2025 10:33 AM 01-Apr-2025 10:33 AM
DTA/Instructor 29-Mar-2025 02:55 AM 29-Mar-2025 02:55 AM
DTA/Student Snapshot 21-May-2022 06:19 AM 21-May-2022 06:38 AM
Financial Aid Reporting Load 29-Sep-2023 08:06 PM 29-Sep-2023 08:07 PM
Financial Aid Staging Load 29-Sep-2023 08:05 PM 29-Sep-2023 08:05 PM
Pennant Accounts Load 01-Apr-2025 09:17 PM *** In progress ***
Pennant Financial Aid 01-Apr-2025 01:00 AM 01-Apr-2025 01:46 AM
Pennant Financial Aid Snapshot 01-Apr-2025 01:45 AM 01-Apr-2025 01:46 AM
Pennant Graduate Funding Load 17-Sep-2024 06:07 AM 17-Sep-2024 06:09 AM
Pennant Student Records 31-Mar-2025 11:01 PM 01-Apr-2025 02:21 AM
Pennant Student Records Snapshot 01-Apr-2025 02:21 AM 01-Apr-2025 02:21 AM
Student 01-Oct-2023 09:03 PM 01-Oct-2023 09:04 PM
Tuition Distribution 01-Apr-2025 02:53 AM 01-Apr-2025 02:53 AM
Travel Data Job Start Time End Time
ISOS Travel Data 01-Apr-2025 01:00 AM 01-Apr-2025 01:03 AM
TEM Concur Data Dump Load 01-Apr-2025 02:53 AM 01-Apr-2025 03:24 AM
TEM Concur Standard Accounting Extract (SAE) Load 31-Mar-2025 11:00 PM 31-Mar-2025 11:04 PM
World Travel Update 01-Apr-2025 03:25 AM 01-Apr-2025 03:51 AM

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