Snowflake Data Warehouse


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.

BBR Data Job Start Time End Time
Load of AR Adjustments 19-Sep-2026 11:30 PM 19-Sep-2026 11:31 PM
Load of AR Applications 19-Sep-2026 11:30 PM 19-Sep-2026 11:31 PM
Load of AR Collections - Delinquency Data 19-Sep-2026 11:30 PM 19-Sep-2026 11:31 PM
Load of AR Collections - Dunning Data 19-Sep-2026 11:30 PM 19-Sep-2026 11:30 PM
Load of AR Collections - Notes Data 19-Sep-2026 11:30 PM 19-Sep-2026 11:31 PM
Load of AR Collections - Promise Data 19-Sep-2026 11:30 PM 19-Sep-2026 11:30 PM
Load of AR Customers 20-Sep-2026 08:01 PM 20-Sep-2026 08:02 PM
Load of AR Transaction Lines 20-Sep-2026 12:01 AM 20-Sep-2026 12:03 AM
Load of AR Transactions 19-Sep-2026 11:30 PM 19-Sep-2026 11:31 PM
Load of GMS Award Report Log 19-Sep-2026 11:07 PM 19-Sep-2026 11:08 PM
Load of GMS Awards and Projects 19-Sep-2026 11:07 PM 20-Sep-2026 12:01 AM
Snapshot of AR Transactions 01-Sep-2026 02:29 AM 01-Sep-2026 02:31 AM
Snapshot of GMS Award Report Log 01-Sep-2026 02:12 AM 01-Sep-2026 02:13 AM
Business Services Data Job Start Time End Time
Express Mail 14-Sep-2026 06:19 PM 14-Sep-2026 06:21 PM
StarRez Housing 10-Oct-2023 12:04 AM 10-Oct-2023 12:11 AM
StarRez Housing Snapshot 06-Oct-2023 11:01 PM 06-Oct-2023 11:04 PM
Facilities Data Job Start Time End Time
Building Utilities 19-Sep-2026 02:01 AM 19-Sep-2026 11:27 PM
Space@Penn 20-Sep-2026 01:09 AM 20-Sep-2026 01:16 AM
Work Requests 18-Sep-2026 11:01 PM 18-Sep-2026 11:06 PM
Financial Data Job Start Time End Time
Assets 20-Sep-2026 12:49 AM 20-Sep-2026 12:54 AM
Assets Snapshot 01-Sep-2026 03:33 AM 01-Sep-2026 03:33 AM
BBR Balances 19-Sep-2026 11:24 PM 19-Sep-2026 11:42 PM
Balances 20-Sep-2026 12:01 AM 20-Sep-2026 12:17 AM
Budget Periods 20-Sep-2026 07:20 AM 20-Sep-2026 07:21 AM
CREF/PI Update 20-Sep-2026 01:10 AM 20-Sep-2026 01:10 AM
Fund Status Update 20-Sep-2026 12:49 AM 20-Sep-2026 12:51 AM
GAAP Report Template 20-Sep-2026 01:37 AM 20-Sep-2026 01:42 AM
GL Detail 19-Sep-2026 11:25 PM 19-Sep-2026 11:27 PM
GL Parent Reference 20-Sep-2026 12:01 AM 20-Sep-2026 12:48 AM
GL Reference 19-Sep-2026 11:07 PM 19-Sep-2026 11:23 PM
GL Report Templates 20-Sep-2026 12:49 AM 20-Sep-2026 12:49 AM
Overhead Rates 20-Sep-2026 04:06 AM 20-Sep-2026 04:21 AM
Responsible Org 20-Sep-2026 04:22 AM 20-Sep-2026 04:35 AM
User Security 20-Sep-2026 01:02 AM 20-Sep-2026 01:06 AM
LMS Data Job Start Time End Time
Finish LMS USER Tables Load 20-Sep-2026 04:20 AM 20-Sep-2026 04:46 AM
Research Load 20-Sep-2026 12:14 PM 20-Sep-2026 12:15 PM
Workday Learning 20-Sep-2026 12:55 AM 20-Sep-2026 11:30 PM
Workday Learning -Sunday Run 20-Sep-2026 12:01 PM 20-Sep-2026 12:02 PM
Other Data Job Start Time End Time
Present Period 20-Sep-2026 02:00 AM 20-Sep-2026 02:01 AM
Payroll Data Job Start Time End Time
HCM Legacy Table Update 20-Sep-2026 12:55 AM 20-Sep-2026 12:57 AM
HCM Payments and Encumbrances 20-Sep-2026 12:58 AM 20-Sep-2026 01:01 AM
HCM Person and Position 20-Sep-2026 12:22 AM 21-Sep-2026 12:11 AM
HCM Position History 20-Sep-2026 12:55 AM 20-Sep-2026 12:57 AM
HCM Snapshots 01-Sep-2026 04:23 AM 01-Sep-2026 04:27 AM
Penn ID Update 20-Sep-2026 01:02 AM 20-Sep-2026 01:09 AM
Planning Data Job Start Time End Time
GAAPHist and PennHist Load (Cloud) 20-Sep-2026 04:48 AM 20-Sep-2026 04:49 AM
Hyperion Revexp Load 20-Sep-2026 01:11 AM 20-Sep-2026 01:37 AM
Hyperion Salary Load 20-Sep-2026 01:11 AM 20-Sep-2026 01:26 AM
Research Data Job Start Time End Time
Human Subject Protocols - HSERA 10-Feb-2026 11:25 PM 10-Feb-2026 11:25 PM
Human Subject Protocols - eIRB 18-Sep-2026 11:01 PM 18-Sep-2026 11:01 PM
Lab Animal Protocols 18-Sep-2026 10:00 PM 18-Sep-2026 10:28 PM
PennERA People 19-Sep-2026 01:04 AM 19-Sep-2026 01:08 AM
Proposal Tracking 19-Sep-2026 03:13 AM 19-Sep-2026 03:17 AM
Protocol Status 18-Sep-2026 10:00 PM 18-Sep-2026 10:17 PM
RIS Community Data 19-Sep-2026 03:35 AM 19-Sep-2026 03:36 AM
RIS Subaward and MTA/NMA Data 19-Sep-2026 03:17 AM 19-Sep-2026 03:36 AM
Research All People 19-Sep-2026 02:37 AM 19-Sep-2026 02:39 AM
Student Data Job Start Time End Time
Career Tracker 20-Sep-2026 06:00 PM 20-Sep-2026 06:03 PM
CourseEval 20-Sep-2026 08:07 PM 20-Sep-2026 08:07 PM
CourseEval 18-Sep-2026 10:01 PM 20-Sep-2026 08:07 PM
CourseEval 20-Sep-2026 08:08 PM 20-Sep-2026 08:08 PM
CourseEval 20-Sep-2026 08:01 PM 20-Sep-2026 08:02 PM
CourseEval 20-Sep-2026 08:02 PM 20-Sep-2026 08:03 PM
Curriculum Management 20-Sep-2026 07:20 AM 20-Sep-2026 07:28 AM
Curriculum Management 20-Sep-2026 07:29 AM 20-Sep-2026 07:45 AM
DGW/Degree Planning and Audit 20-Sep-2026 02:30 AM 20-Sep-2026 05:38 AM
DGW/Degree Planning and Audit Snapshot 20-Sep-2026 05:39 AM 20-Sep-2026 05:39 AM
Pennant Accounts 18-Sep-2026 07:29 PM 18-Sep-2026 08:05 PM
Pennant Financial Aid 20-Sep-2026 01:00 AM 20-Sep-2026 01:58 AM
Pennant Financial Aid Snapshot 20-Sep-2026 01:58 AM 20-Sep-2026 01:58 AM
Pennant Grad Funding 18-Sep-2026 07:01 PM 19-Sep-2026 06:22 AM
Pennant Student Records 02-Dec-2025 12:41 AM *** In progress ***
Pennant Student Records Snapshot 20-Sep-2026 01:51 AM 20-Sep-2026 01:51 AM
Travel Data Job Start Time End Time
ISOS Travel Data 20-Sep-2026 01:02 AM 20-Sep-2026 02:05 AM
TEM Concur Data Dump 20-Sep-2026 01:09 AM 20-Sep-2026 01:40 AM
TEM Concur Standard Accounting Extract (SAE) 18-Sep-2026 11:30 PM 18-Sep-2026 11:31 PM
World Travel Update 19-Sep-2026 02:01 AM 19-Sep-2026 02:07 AM
Tuition Distribution Job Start Time End Time
TD Dimension Data 20-Sep-2026 01:28 AM 20-Sep-2026 01:32 AM
TD Dimension data 20-Sep-2026 01:23 AM 20-Sep-2026 01:24 AM
TD Dimension data 20-Sep-2026 01:29 AM 20-Sep-2026 01:29 AM
TD Dimension data 20-Sep-2026 01:23 AM 20-Sep-2026 01:36 AM
TD Fact data 20-Sep-2026 01:30 AM 20-Sep-2026 01:35 AM

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