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 02-Apr-2025 11:42 PM 02-Apr-2025 11:42 PM
Load of AR Applications 02-Apr-2025 11:42 PM 02-Apr-2025 11:43 PM
Load of AR Collections - Delinquencies Data 02-Apr-2025 11:42 PM 02-Apr-2025 11:42 PM
Load of AR Collections - Dunning Data 02-Apr-2025 11:42 PM 02-Apr-2025 11:42 PM
Load of AR Collections - Notes Data 02-Apr-2025 11:42 PM 02-Apr-2025 11:42 PM
Load of AR Collections - Promise Data 02-Apr-2025 11:42 PM 02-Apr-2025 11:42 PM
Load of AR Customers 02-Apr-2025 08:02 PM 02-Apr-2025 08:05 PM
Load of AR Transaction Lines 03-Apr-2025 12:01 AM 03-Apr-2025 12:03 AM
Load of AR Transactions 02-Apr-2025 11:42 PM 02-Apr-2025 11:42 PM
Load of GMS Award Report Log 03-Apr-2025 12:10 AM 03-Apr-2025 12:11 AM
Load of GMS Awards and Projects 02-Apr-2025 11:33 PM 02-Apr-2025 11:42 PM
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 02-Apr-2025 05:30 AM 02-Apr-2025 05:30 AM
Facilities Data Job Start Time End Time
Building Utilities 03-Apr-2025 03:35 AM 03-Apr-2025 03:37 AM
Space@Penn 03-Apr-2025 01:14 AM 03-Apr-2025 01:19 AM
Work Request Mid-Day 02-Apr-2025 01:30 PM 02-Apr-2025 01:38 PM
Work Requests 01-Apr-2025 11:05 PM 01-Apr-2025 11:25 PM
Financial Data Job Start Time End Time
Assets 03-Apr-2025 03:40 AM *** In progress ***

Estimated completion:
03-Apr-2025 04:07 AM
Assets Snapshot 01-Apr-2025 06:33 AM 01-Apr-2025 06:41 AM
BBR Balances 03-Apr-2025 03:35 AM *** In progress ***

Estimated completion:
03-Apr-2025 04:09 AM
Balances 03-Apr-2025 03:05 AM 03-Apr-2025 03:34 AM
BenReports Security 03-Apr-2025 02:29 AM 03-Apr-2025 02:31 AM
Budget Periods 02-Apr-2025 06:01 AM 02-Apr-2025 06:01 AM
CREF/PI Update 03-Apr-2025 01:15 AM 03-Apr-2025 01:18 AM
Fund Status Update 03-Apr-2025 03:35 AM *** In progress ***

Estimated completion:
03-Apr-2025 04:15 AM
GAAP Report Template 03-Apr-2025 03:35 AM *** In progress ***

Estimated completion:
03-Apr-2025 04:16 AM
GL Detail 02-Apr-2025 11:42 PM 02-Apr-2025 11:48 PM
GL Parent Reference 03-Apr-2025 02:27 AM 03-Apr-2025 02:29 AM
GL Reference 02-Apr-2025 11:35 PM 02-Apr-2025 11:41 PM
GL Report Templates 03-Apr-2025 03:35 AM 03-Apr-2025 03:43 AM
Overhead Rates 30-Mar-2025 03:23 AM 30-Mar-2025 03:50 AM
Responsible Org 03-Apr-2025 03:44 AM *** In progress ***

Estimated completion:
03-Apr-2025 03:53 AM
Grad Admissions Data Job Start Time End Time
Grad Admissions CN Apps Load 02-Apr-2025 07:00 AM 02-Apr-2025 07:01 AM
Grad Admissions CN Enrollment Reports Load 02-Apr-2025 04:03 PM 02-Apr-2025 04:04 PM
LMS Data Job Start Time End Time
Finish LMS USER Tables Load 02-Apr-2025 07:17 AM 02-Apr-2025 07:26 AM
LMS Collection Load 02-Apr-2025 04:25 AM 02-Apr-2025 07:26 AM
Workday Learning 02-Dec-2024 03:21 AM 02-Apr-2025 07:52 AM
Payroll Data Job Start Time End Time
HCM Legacy Table Update 03-Apr-2025 12:59 AM 03-Apr-2025 01:04 AM
HCM Payments and Encumbrances 03-Apr-2025 01:04 AM 03-Apr-2025 01:12 AM
HCM Person and Position 03-Apr-2025 12:33 AM 03-Apr-2025 12:58 AM
HCM Position History 03-Apr-2025 12:59 AM 03-Apr-2025 01:02 AM
HCM Snapshots 01-Apr-2025 07:08 AM 01-Apr-2025 07:40 AM
Penn ID Update 03-Apr-2025 01:12 AM 03-Apr-2025 01:14 AM
Planning Data Job Start Time End Time
GAAPHist and PennHist Load (Cloud) 02-Apr-2025 06:39 AM 02-Apr-2025 06:39 AM
Hyperion Revexp Load 03-Apr-2025 02:29 AM 03-Apr-2025 02:51 AM
Hyperion Salary Load 03-Apr-2025 01:08 AM 03-Apr-2025 01:11 AM
Research Data Job Start Time End Time
BRIM 01-May-2014 01:44 PM 01-May-2014 05:52 PM
Human Subject Protocols 02-Apr-2025 10:00 PM 02-Apr-2025 10:29 PM
Lab Animal protocol data 02-Apr-2025 10:29 PM 02-Apr-2025 10:58 PM
PennERA People 03-Apr-2025 02:29 AM 03-Apr-2025 02:32 AM
Proposal Tracking 03-Apr-2025 02:32 AM *** In progress ***

Estimated completion:
03-Apr-2025 04:44 AM

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 02-Apr-2025 10:00 PM 02-Apr-2025 10:43 PM
RIS Community Data DW Load 02-Apr-2025 05:25 AM 02-Apr-2025 05:25 AM
RIS Subaward and MTA/NMA DW Load 02-Apr-2025 05:25 AM 02-Apr-2025 05:28 AM
Student Data Job Start Time End Time
Course Eval Staging 04-Apr-2012 04:39 PM 02-Apr-2025 10:06 PM
Curriculum Management Part1 02-Apr-2025 06:00 AM 02-Apr-2025 06:12 AM
Curriculum Management Part2 02-Apr-2025 06:12 AM 02-Apr-2025 06:17 AM
DGW/Degree Planning and Audit 03-Apr-2025 02:11 AM *** In progress ***
DGW/Degree Planning and Audit Snapshot 02-Apr-2025 09:58 AM 02-Apr-2025 09:58 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 02-Apr-2025 09:17 PM 02-Apr-2025 09:38 PM
Pennant Financial Aid 03-Apr-2025 01:00 AM 03-Apr-2025 01:53 AM
Pennant Financial Aid Snapshot 03-Apr-2025 01:53 AM 03-Apr-2025 01:53 AM
Pennant Graduate Funding Load 17-Sep-2024 06:07 AM 17-Sep-2024 06:09 AM
Pennant Student Records 02-Apr-2025 11:01 PM 03-Apr-2025 02:24 AM
Pennant Student Records Snapshot 03-Apr-2025 02:24 AM 03-Apr-2025 02:24 AM
Student 01-Oct-2023 09:03 PM 01-Oct-2023 09:04 PM
Tuition Distribution 03-Apr-2025 01:15 AM 03-Apr-2025 01:15 AM
Travel Data Job Start Time End Time
ISOS Travel Data 03-Apr-2025 01:00 AM 03-Apr-2025 01:07 AM
TEM Concur Data Dump Load 03-Apr-2025 01:14 AM 03-Apr-2025 01:44 AM
TEM Concur Standard Accounting Extract (SAE) Load 02-Apr-2025 11:00 PM 02-Apr-2025 11:05 PM
World Travel Update 03-Apr-2025 02:09 AM 03-Apr-2025 02:35 AM

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