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

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