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 26-Sep-2023 09:57 PM 26-Sep-2023 09:57 PM
UGA Mod1 Application 26-Sep-2023 04:45 AM 26-Sep-2023 04:45 AM
Undergrad Admissions 26-Sep-2023 08:09 PM 26-Sep-2023 08:17 PM
Undergrad Admissions Summary 26-Sep-2023 08:17 PM *** Job failed ***
BBR Data Job Start Time End Time
Load of AR Adjustments 27-Sep-2023 12:05 AM 27-Sep-2023 12:05 AM
Load of AR Applications 27-Sep-2023 12:05 AM 27-Sep-2023 12:08 AM
Load of AR Collections - Delinquencies Data 27-Sep-2023 12:05 AM 27-Sep-2023 12:05 AM
Load of AR Collections - Dunning Data 27-Sep-2023 12:05 AM 27-Sep-2023 12:05 AM
Load of AR Collections - Notes Data 27-Sep-2023 12:05 AM 27-Sep-2023 12:05 AM
Load of AR Collections - Promise Data 27-Sep-2023 12:05 AM 27-Sep-2023 12:05 AM
Load of AR Customers 26-Sep-2023 08:02 PM 26-Sep-2023 08:05 PM
Load of AR Transaction Lines 27-Sep-2023 12:05 AM 27-Sep-2023 12:09 AM
Load of AR Transactions 27-Sep-2023 12:05 AM 27-Sep-2023 12:06 AM
Load of GMS Award Report Log 27-Sep-2023 12:10 AM 27-Sep-2023 12:17 AM
Load of GMS Awards and Projects 26-Sep-2023 11:56 PM 27-Sep-2023 12:04 AM
Snapshot of AR Transactions 01-Sep-2023 03:30 AM 01-Sep-2023 03:45 AM
Snapshot of GMS Award Report Log 01-Sep-2023 03:21 AM 01-Sep-2023 03:21 AM
Business Services Data Job Start Time End Time
StarRez Housing Data Refresh (Talend) 27-Sep-2023 12:01 AM 27-Sep-2023 12:03 AM
StarRez Housing Data Snapshot Load (Talend) 22-Sep-2023 11:00 PM 22-Sep-2023 11:01 PM
Email Data Job Start Time End Time
Email Listserv 26-Sep-2023 05:30 AM 26-Sep-2023 05:30 AM
Facilities Data Job Start Time End Time
Building Utilities 26-Sep-2023 04:44 AM 26-Sep-2023 04:49 AM
Space@Penn 27-Sep-2023 01:19 AM 27-Sep-2023 01:25 AM
Work Request Mid-Day 26-Sep-2023 01:30 PM 26-Sep-2023 01:39 PM
Work Requests 26-Sep-2023 11:05 PM 26-Sep-2023 11:27 PM
Financial Data Job Start Time End Time
Assets 26-Sep-2023 04:55 AM 26-Sep-2023 05:16 AM
Assets Snapshot 01-Sep-2023 04:01 PM 01-Sep-2023 04:04 PM
BBR Balances 26-Sep-2023 03:46 AM 26-Sep-2023 04:48 AM
Balances 26-Sep-2023 03:07 AM 26-Sep-2023 03:45 AM
BenReports Security 26-Sep-2023 04:42 AM 26-Sep-2023 04:45 AM
Budget Periods 26-Sep-2023 06:01 AM 26-Sep-2023 06:01 AM
CREF/PI Update 27-Sep-2023 01:20 AM 27-Sep-2023 01:23 AM
Fund Status Update 26-Sep-2023 03:46 AM 26-Sep-2023 04:15 AM
GAAP Report Template 26-Sep-2023 03:46 AM 26-Sep-2023 04:01 AM
GL Detail 27-Sep-2023 12:05 AM 27-Sep-2023 12:12 AM
GL Parent Reference 26-Sep-2023 02:47 AM 26-Sep-2023 02:49 AM
GL Reference 26-Sep-2023 11:58 PM 27-Sep-2023 12:04 AM
GL Report Templates 26-Sep-2023 03:46 AM 26-Sep-2023 03:58 AM
Overhead Rates 24-Sep-2023 02:51 AM 24-Sep-2023 03:53 AM
Responsible Org 26-Sep-2023 04:42 AM 26-Sep-2023 04:48 AM
Grad Admissions Data Job Start Time End Time
Grad Admissions CN Apps Load 26-Sep-2023 07:00 AM 26-Sep-2023 07:01 AM
Grad Admissions CN Enrollment Reports Load 26-Sep-2023 04:02 PM 26-Sep-2023 04:03 PM
LMS Data Job Start Time End Time
Finish LMS USER Tables Load 26-Sep-2023 06:31 AM 26-Sep-2023 06:41 AM
LMS Collection Load 26-Sep-2023 04:25 AM 26-Sep-2023 06:42 AM
Workday Learning 27-Sep-2023 01:08 AM *** In progress ***
Tables blocked:

Workday Learning Assignment Data
Workday Learning Course Data
Workday Learning Current Status View Data
Workday Learning Data
Workday Learning KL_WDL View Data
Workday Learning User Data
Payroll Data Job Start Time End Time
HCM Legacy Table Update 27-Sep-2023 01:07 AM 27-Sep-2023 01:12 AM
HCM Payments and Encumbrances 27-Sep-2023 01:12 AM 27-Sep-2023 01:17 AM
HCM Person and Position 27-Sep-2023 12:42 AM 27-Sep-2023 01:07 AM
HCM Position History 27-Sep-2023 01:07 AM 27-Sep-2023 01:10 AM
HCM Snapshots 01-Sep-2023 03:35 PM 01-Sep-2023 03:59 PM
Penn ID Update 27-Sep-2023 01:17 AM 27-Sep-2023 01:19 AM
Planning Data Job Start Time End Time
GAAPHist and PennHist Load (Cloud) 26-Sep-2023 08:04 AM 26-Sep-2023 08:04 AM
Hyperion Revexp Load 26-Sep-2023 02:49 AM 26-Sep-2023 03:08 AM
Hyperion Salary Load 27-Sep-2023 01:12 AM 27-Sep-2023 01:15 AM
Research Data Job Start Time End Time
BRIM 01-May-2014 01:44 PM 01-May-2014 05:52 PM
Human Subject Protocols 26-Sep-2023 10:00 PM 26-Sep-2023 10:32 PM
Lab Animal protocol data 26-Sep-2023 10:32 PM 26-Sep-2023 10:53 PM
PennERA People 26-Sep-2023 04:47 AM 26-Sep-2023 04:49 AM
Proposal Tracking 26-Sep-2023 04:50 AM 26-Sep-2023 06:58 AM
Protocol Status 26-Sep-2023 10:00 PM 26-Sep-2023 10:52 PM
RIS Community Data DW Load 26-Sep-2023 06:59 AM 26-Sep-2023 06:59 AM
RIS Subaward and MTA/NMA DW Load 26-Sep-2023 06:59 AM 26-Sep-2023 07:02 AM
Student Data Job Start Time End Time
Course Eval Staging 04-Apr-2012 04:39 PM 26-Sep-2023 11:13 PM
Curriculum Management Part1 26-Sep-2023 06:00 AM 26-Sep-2023 06:39 AM
Curriculum Management Part2 26-Sep-2023 06:39 AM 26-Sep-2023 06:49 AM
DGW/Degree Planning and Audit 26-Sep-2023 02:37 AM 26-Sep-2023 08:46 AM
DGW/Degree Planning and Audit Snapshot 26-Sep-2023 08:46 AM 26-Sep-2023 08:46 AM
DTA/Instructor 23-Sep-2023 02:27 AM 23-Sep-2023 02:27 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 26-Sep-2023 09:34 PM 26-Sep-2023 09:56 PM
Pennant Financial Aid 27-Sep-2023 01:00 AM *** In progress ***
Pennant Financial Aid Snapshot 27-Sep-2023 02:00 AM *** In progress ***
Pennant Graduate Funding Load 26-Sep-2023 06:17 AM 26-Sep-2023 06:19 AM
Pennant Student Records 27-Sep-2023 12:01 AM *** In progress ***
Pennant Student Records Snapshot 26-Sep-2023 07:52 AM 26-Sep-2023 07:52 AM
Student 26-Sep-2023 10:53 PM 26-Sep-2023 11:07 PM
Tuition Distribution 27-Sep-2023 01:20 AM 27-Sep-2023 01:20 AM
Travel Data Job Start Time End Time
ISOS Travel Data 27-Sep-2023 01:00 AM 27-Sep-2023 01:13 AM
TEM Concur Data Dump Load 27-Sep-2023 01:19 AM 27-Sep-2023 01:46 AM
TEM Concur Standard Accounting Extract (SAE) Load 26-Sep-2023 11:00 PM 26-Sep-2023 11:02 PM
World Travel Update 26-Sep-2023 05:17 AM 26-Sep-2023 05:36 AM

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