 |
 |
| Data Warehouse Update/Load Status |
- Admissions Data
- BBR Data
- Business Services Data
- Email Data
- Facilities Data
- Financial Data
- Grad Admissions Data
- LMS Data
- Payroll Data
- Planning Data
- Research Data
- Student Data
- Travel Data
Data Warehouse Home
Help 
Close
|
 |
 |
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 | 27-Jul-2024 05:55 AM | 27-Jul-2024 05:55 AM | |
| UGA Mod1 Application | 27-Jul-2024 04:45 AM | 27-Jul-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 | 26-Jul-2024 11:46 PM | 26-Jul-2024 11:46 PM | |
| Load of AR Applications | 26-Jul-2024 11:46 PM | 26-Jul-2024 11:48 PM | |
| Load of AR Collections - Delinquencies Data | 26-Jul-2024 11:46 PM | 26-Jul-2024 11:46 PM | |
| Load of AR Collections - Dunning Data | 26-Jul-2024 11:46 PM | 26-Jul-2024 11:46 PM | |
| Load of AR Collections - Notes Data | 26-Jul-2024 11:46 PM | 26-Jul-2024 11:46 PM | |
| Load of AR Collections - Promise Data | 26-Jul-2024 11:46 PM | 26-Jul-2024 11:46 PM | |
| Load of AR Customers | 26-Jul-2024 08:02 PM | 26-Jul-2024 08:04 PM | |
| Load of AR Transaction Lines | 27-Jul-2024 12:01 AM | 27-Jul-2024 12:02 AM | |
| Load of AR Transactions | 26-Jul-2024 11:46 PM | 26-Jul-2024 11:47 PM | |
| Load of GMS Award Report Log | 27-Jul-2024 12:10 AM | 27-Jul-2024 12:16 AM | |
| Load of GMS Awards and Projects | 26-Jul-2024 11:38 PM | 26-Jul-2024 11:46 PM | |
| Snapshot of AR Transactions | 29-Jun-2024 04:56 AM | 29-Jun-2024 06:33 AM | |
| Snapshot of GMS Award Report Log | 29-Jun-2024 04:47 AM | 29-Jun-2024 04:48 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 | 27-Jul-2024 05:30 AM | 27-Jul-2024 05:30 AM | |
| Facilities Data | Job | Start Time | End Time |
| Building Utilities | 27-Jul-2024 03:41 AM | 27-Jul-2024 03:42 AM | |
| Space@Penn | 27-Jul-2024 01:18 AM | 27-Jul-2024 01:26 AM | |
| Work Request Mid-Day | 26-Jul-2024 01:30 PM | 26-Jul-2024 01:37 PM | |
| Work Requests | 26-Jul-2024 11:05 PM | 26-Jul-2024 11:24 PM | |
| Financial Data | Job | Start Time | End Time |
| Assets | 27-Jul-2024 02:35 AM | 27-Jul-2024 02:51 AM | |
| Assets Snapshot | 29-Jun-2024 08:03 AM | 29-Jun-2024 08:06 AM | |
| BBR Balances | 27-Jul-2024 03:47 AM | 27-Jul-2024 04:18 AM | |
| Balances | 27-Jul-2024 03:02 AM | 27-Jul-2024 03:26 AM | |
| BenReports Security | 27-Jul-2024 02:33 AM | 27-Jul-2024 02:34 AM | |
| Budget Periods | 27-Jul-2024 06:01 AM | 27-Jul-2024 06:01 AM | |
| CREF/PI Update | 27-Jul-2024 01:18 AM | 27-Jul-2024 01:21 AM | |
| Fund Status Update | 27-Jul-2024 03:27 AM | 27-Jul-2024 03:45 AM | |
| GAAP Report Template | 27-Jul-2024 03:27 AM | 27-Jul-2024 03:41 AM | |
| GL Detail | 26-Jul-2024 11:46 PM | 26-Jul-2024 11:51 PM | |
| GL Parent Reference | 27-Jul-2024 02:30 AM | 27-Jul-2024 02:32 AM | |
| GL Reference | 26-Jul-2024 11:40 PM | 26-Jul-2024 11:46 PM | |
| GL Report Templates | 27-Jul-2024 03:27 AM | 27-Jul-2024 03:35 AM | |
| Overhead Rates | 21-Jul-2024 03:28 AM | 21-Jul-2024 04:52 AM | |
| Responsible Org | 27-Jul-2024 03:35 AM | 27-Jul-2024 03:39 AM | |
| Grad Admissions Data | Job | Start Time | End Time |
| Grad Admissions CN Apps Load | 27-Jul-2024 07:00 AM | 27-Jul-2024 07:01 AM | |
| Grad Admissions CN Enrollment Reports Load | 26-Jul-2024 04:10 PM | 26-Jul-2024 04:12 PM | |
| LMS Data | Job | Start Time | End Time |
| Finish LMS USER Tables Load | 27-Jul-2024 06:52 AM | 27-Jul-2024 06:59 AM | |
| LMS Collection Load | 27-Jul-2024 04:22 AM | 27-Jul-2024 06:59 AM | |
| Workday Learning | 27-Jul-2024 01:04 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-Jul-2024 01:03 AM | 27-Jul-2024 01:08 AM | |
| HCM Payments and Encumbrances | 27-Jul-2024 01:08 AM | 27-Jul-2024 01:13 AM | |
| HCM Person and Position | 27-Jul-2024 12:35 AM | 27-Jul-2024 01:03 AM | |
| HCM Position History | 27-Jul-2024 01:03 AM | 27-Jul-2024 01:06 AM | |
| HCM Snapshots | 01-Jul-2024 06:01 AM | 01-Jul-2024 06:24 AM | |
| Penn ID Update | 27-Jul-2024 01:13 AM | 27-Jul-2024 01:17 AM | |
| Planning Data | Job | Start Time | End Time |
| GAAPHist and PennHist Load (Cloud) | 27-Jul-2024 06:40 AM | 27-Jul-2024 06:40 AM | |
| Hyperion Revexp Load | 27-Jul-2024 02:33 AM | 27-Jul-2024 02:52 AM | |
| Hyperion Salary Load | 27-Jul-2024 01:09 AM | 27-Jul-2024 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 | 26-Jul-2024 10:00 PM | 26-Jul-2024 10:31 PM | |
| Lab Animal protocol data | 26-Jul-2024 10:31 PM | 26-Jul-2024 10:54 PM | |
| PennERA People | 27-Jul-2024 02:33 AM | 27-Jul-2024 02:34 AM | |
| Proposal Tracking | 27-Jul-2024 02:35 AM | 27-Jul-2024 04:54 AM | |
| Protocol Status | 26-Jul-2024 10:00 PM | 26-Jul-2024 10:40 PM | |
| RIS Community Data DW Load | 27-Jul-2024 04:54 AM | 27-Jul-2024 04:54 AM | |
| RIS Subaward and MTA/NMA DW Load | 27-Jul-2024 04:54 AM | 27-Jul-2024 04:57 AM | |
| Student Data | Job | Start Time | End Time |
| Course Eval Staging | 04-Apr-2012 04:39 PM | 26-Jul-2024 10:08 PM | |
| Curriculum Management Part1 | 27-Jul-2024 06:01 AM | 27-Jul-2024 06:11 AM | |
| Curriculum Management Part2 | 27-Jul-2024 06:12 AM | 27-Jul-2024 06:16 AM | |
| DGW/Degree Planning and Audit | 27-Jul-2024 01:58 AM | 27-Jul-2024 06:44 AM | |
| DGW/Degree Planning and Audit Snapshot | 27-Jul-2024 06:45 AM | 27-Jul-2024 06:45 AM | |
| DTA/Instructor | 27-Jul-2024 02:33 AM | 27-Jul-2024 02:33 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 | 26-Jul-2024 09:33 PM | 26-Jul-2024 09:55 PM | |
| Pennant Financial Aid | 27-Jul-2024 01:01 AM | 27-Jul-2024 01:42 AM | |
| Pennant Financial Aid Snapshot | 27-Jul-2024 01:41 AM | 27-Jul-2024 01:42 AM | |
| Pennant Graduate Funding Load | 27-Jul-2024 06:08 AM | 27-Jul-2024 06:10 AM | |
| Pennant Student Records | 26-Jul-2024 11:01 PM | 27-Jul-2024 02:00 AM | |
| Pennant Student Records Snapshot | 27-Jul-2024 02:01 AM | 27-Jul-2024 02:01 AM | |
| Student | 01-Oct-2023 09:03 PM | 01-Oct-2023 09:04 PM | |
| Tuition Distribution | 27-Jul-2024 01:18 AM | 27-Jul-2024 01:18 AM | |
| Travel Data | Job | Start Time | End Time |
| ISOS Travel Data | 27-Jul-2024 01:01 AM | 27-Jul-2024 01:06 AM | |
| TEM Concur Data Dump Load | 27-Jul-2024 01:18 AM | 27-Jul-2024 01:46 AM | |
| TEM Concur Standard Accounting Extract (SAE) Load | 26-Jul-2024 11:00 PM | 26-Jul-2024 11:03 PM | |
| World Travel Update | 27-Jul-2024 02:13 AM | 27-Jul-2024 02:37 AM |
Copyright © 2024, University of Pennsylvania. All rights reserved.
Statement on privacy