 |
 |
| Data Warehouse Update/Load Status |
- AWS Billing Data
- Admissions Data
- BBR Data
- Business Services Data
- Chargeback Data
- Email Data
- Facilities Data
- Financial Data
- Gifts/Advancement Data
- Grad Admissions Data
- Intellectual Property
- 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. |
| AWS Billing Data | Job | Start Time | End Time |
|---|---|---|---|
| AWS Billing Extract | 27-Jul-2020 01:00 AM | 27-Jul-2020 01:03 AM | |
| AWS Billing Reporting Load | 03-Aug-2020 08:20 AM | 03-Aug-2020 08:21 AM | |
| AWS Billing Staging Load | 27-Jul-2020 02:01 AM | 27-Jul-2020 02:01 AM | |
| Admissions Data | Job | Start Time | End Time |
| SRS/Admissions | 31-Aug-2021 03:21 AM | 31-Aug-2021 03:22 AM | |
| Sequence Static | 15-Oct-2021 07:57 PM | 15-Oct-2021 07:58 PM | |
| UGA Mod1 Application | 15-Oct-2021 04:45 AM | 15-Oct-2021 04:45 AM | |
| Undergrad Admissions | 15-Oct-2021 08:06 PM | 15-Oct-2021 08:08 PM | |
| Undergrad Admissions Summary | 15-Oct-2021 08:08 PM |
*** In progress ***
Estimated completion: 15-Oct-2021 08:51 PM |
|
| BBR Data | Job | Start Time | End Time |
| Load of AR Adjustments | 15-Oct-2021 12:41 AM | 15-Oct-2021 12:41 AM | |
| Load of AR Applications | 15-Oct-2021 12:41 AM | 15-Oct-2021 12:42 AM | |
| Load of AR Collections - Delinquencies Data | 15-Oct-2021 12:41 AM | 15-Oct-2021 12:41 AM | |
| Load of AR Collections - Dunning Data | 15-Oct-2021 12:41 AM | 15-Oct-2021 12:41 AM | |
| Load of AR Collections - Notes Data | 15-Oct-2021 12:41 AM | 15-Oct-2021 12:41 AM | |
| Load of AR Collections - Promise Data | 15-Oct-2021 12:41 AM | 15-Oct-2021 12:41 AM | |
| Load of AR Customers | 15-Oct-2021 08:02 PM | 15-Oct-2021 08:04 PM | |
| Load of AR Transaction Lines | 15-Oct-2021 12:41 AM | 15-Oct-2021 12:42 AM | |
| Load of AR Transactions | 15-Oct-2021 12:41 AM | 15-Oct-2021 12:41 AM | |
| Load of GMS Award Report Log | 15-Oct-2021 12:33 AM | 15-Oct-2021 12:34 AM | |
| Load of GMS Awards and Projects | 15-Oct-2021 12:33 AM | 15-Oct-2021 12:39 AM | |
| Snapshot of AR Transactions | 01-Oct-2021 04:44 AM | 01-Oct-2021 04:57 AM | |
| Snapshot of GMS Award Report Log | 01-Oct-2021 04:35 AM | 01-Oct-2021 04:36 AM | |
| Business Services Data | Job | Start Time | End Time |
| Bookstore Extract | 14-Oct-2021 11:28 PM | 14-Oct-2021 11:29 PM | |
| StarRez Housing Data Refresh (Talend) | 15-Oct-2021 12:01 AM | 15-Oct-2021 12:03 AM | |
| StarRez Housing Data Snapshot Load (Talend) | 08-Oct-2021 11:00 PM | 08-Oct-2021 11:01 PM | |
| Chargeback Data | Job | Start Time | End Time |
| ISC Billing | 20-Nov-2018 11:14 PM | 20-Nov-2018 11:43 PM | |
| Mainframe Chargeback | 05-Oct-2021 12:19 AM | 05-Oct-2021 12:19 AM | |
| Email Data | Job | Start Time | End Time |
| Email Listserv | 15-Oct-2021 05:30 AM | 15-Oct-2021 05:30 AM | |
| Facilities Data | Job | Start Time | End Time |
| Building Utilities | 15-Oct-2021 02:41 AM | 15-Oct-2021 02:42 AM | |
| Space@Penn | 15-Oct-2021 01:12 AM | 15-Oct-2021 01:16 AM | |
| Work Request Mid-Day | 15-Oct-2021 01:30 PM | 15-Oct-2021 01:36 PM | |
| Work Requests | 14-Oct-2021 11:05 PM | 14-Oct-2021 11:26 PM | |
| Financial Data | Job | Start Time | End Time |
| Assets | 15-Oct-2021 02:58 AM | 15-Oct-2021 03:13 AM | |
| Assets Snapshot | 01-Oct-2021 07:48 AM | 01-Oct-2021 07:51 AM | |
| BBR Balances | 15-Oct-2021 03:55 AM | 15-Oct-2021 04:18 AM | |
| Balances | 15-Oct-2021 02:21 AM | 15-Oct-2021 02:41 AM | |
| BenReports Security | 15-Oct-2021 02:56 AM | 15-Oct-2021 02:58 AM | |
| Budget Periods | 15-Oct-2021 06:01 AM | 15-Oct-2021 06:01 AM | |
| CREF/PI Update | 15-Oct-2021 01:12 AM | 15-Oct-2021 01:15 AM | |
| Fund Status Update | 15-Oct-2021 02:56 AM | 15-Oct-2021 03:20 AM | |
| GAAP Report Template | 15-Oct-2021 03:12 AM | 15-Oct-2021 03:25 AM | |
| GL Detail | 15-Oct-2021 12:46 AM | 15-Oct-2021 12:52 AM | |
| GL Parent Reference | 15-Oct-2021 02:54 AM | 15-Oct-2021 02:56 AM | |
| GL Reference | 15-Oct-2021 12:34 AM | 15-Oct-2021 12:40 AM | |
| GL Report Templates | 15-Oct-2021 02:56 AM | 15-Oct-2021 03:07 AM | |
| Overhead Rates | 10-Oct-2021 02:51 AM | 10-Oct-2021 03:29 AM | |
| Responsible Org | 15-Oct-2021 03:07 AM | 15-Oct-2021 03:14 AM | |
| Summary Balances | 10-Oct-2021 01:57 AM | 10-Oct-2021 02:02 AM | |
| Gifts/Advancement Data | Job | Start Time | End Time |
| Atlas Ability Rating | 26-Apr-2013 11:50 PM | 27-Apr-2013 12:05 AM | |
| Atlas Ack Table Import | 27-Apr-2013 03:06 AM | 27-Apr-2013 03:35 AM | |
| Atlas Audit | 27-Apr-2013 01:42 AM | 27-Apr-2013 01:44 AM | |
| Atlas BFS | 26-Apr-2013 07:27 PM | 26-Apr-2013 07:27 PM | |
| Atlas Base Gifts Tables | 26-Apr-2013 07:08 PM | 26-Apr-2013 08:53 PM | |
| Atlas Constituents | 26-Apr-2013 07:39 PM | 26-Apr-2013 11:50 PM | |
| Atlas Contact Exclusions | 26-Apr-2013 07:27 PM | 26-Apr-2013 07:32 PM | |
| Atlas Core Table Copy | 26-Apr-2013 07:08 PM | 26-Apr-2013 07:08 PM | |
| Atlas Core Table Copy (Dblink) | 26-Apr-2013 05:28 PM | 26-Apr-2013 07:26 PM | |
| Atlas Couples | 26-Apr-2013 11:50 PM | 26-Apr-2013 11:53 PM | |
| Atlas Designations | 26-Apr-2013 09:48 PM | 26-Apr-2013 09:57 PM | |
| Atlas Gift Detail | 26-Apr-2013 08:58 PM | 26-Apr-2013 09:48 PM | |
| Atlas Gift MVs | 26-Apr-2013 10:34 PM | 27-Apr-2013 02:03 AM | |
| Atlas Gift Summary | 26-Apr-2013 09:57 PM | 26-Apr-2013 10:33 PM | |
| Atlas Giving Frequency | 27-Apr-2013 02:03 AM | 27-Apr-2013 04:53 AM | |
| Atlas Hard Credit | 26-Apr-2013 11:50 PM | 26-Apr-2013 11:51 PM | |
| Atlas Materialized Views | 27-Apr-2013 12:06 AM | 27-Apr-2013 01:33 AM | |
| Atlas Open Pledges | 26-Apr-2013 08:53 PM | 26-Apr-2013 08:56 PM | |
| Atlas Prospect Management | 27-Apr-2013 01:33 AM | 27-Apr-2013 01:41 AM | |
| Atlas Region Codes | 26-Apr-2013 07:27 PM | 26-Apr-2013 07:38 PM | |
| Atlas Reports Etl Import Olga Donation Tables | 27-Apr-2013 05:28 AM | 27-Apr-2013 05:29 AM | |
| Atlas Reports Etl Import Olga Giving Tables | 27-Apr-2013 05:28 AM | 27-Apr-2013 05:35 AM | |
| Atlas Soft Credit | 26-Apr-2013 11:50 PM | 26-Apr-2013 11:51 PM | |
| Atlas Transaction Detail | 26-Apr-2013 08:53 PM | 26-Apr-2013 08:58 PM | |
| Atlas Tribute All | 27-Apr-2013 02:03 AM | 27-Apr-2013 02:49 AM | |
| Atlas Whse_Cnst_Ac_Asgn_All Process | 27-Apr-2013 01:33 AM | 27-Apr-2013 02:07 AM | |
| Atlas Whse_Prospect_Status Table Polulation | 26-Apr-2013 07:27 PM | 26-Apr-2013 07:27 PM | |
| Atlas XLAT | 26-Apr-2013 07:27 PM | 26-Apr-2013 07:27 PM | |
| Atlas Year By School | 26-Apr-2013 07:27 PM | 26-Apr-2013 07:28 PM | |
| Grad Admissions Data | Job | Start Time | End Time |
| Grad Admissions CN Apps Load | 15-Oct-2021 07:00 AM | 15-Oct-2021 07:01 AM | |
| Grad Admissions CN Enrollment Reports Load | 15-Oct-2021 04:01 PM | 15-Oct-2021 04:03 PM | |
| Grad Admissions GA_PCOM - email for setup codes | 04-Dec-2017 10:43 PM | 04-Dec-2017 10:43 PM | |
| Grad Admissions Get PennID Updates | 04-Dec-2017 10:43 PM | 04-Dec-2017 10:43 PM | |
| Grad Admissions IPEDS data load for PennInTouch | 04-Dec-2017 10:43 PM | 04-Dec-2017 10:43 PM | |
| Grad Admissions SRS Load | 15-Oct-2021 04:07 PM | 15-Oct-2021 04:07 PM | |
| Grad Admissions SRS Load Errors Feedback | 15-Oct-2021 04:08 PM | 15-Oct-2021 04:08 PM | |
| Intellectual Property | Job | Start Time | End Time |
| Intellectual Property Load | 16-Feb-2015 07:00 AM | 16-Feb-2015 07:47 AM | |
| LMS Data | Job | Start Time | End Time |
| Finish LMS USER Tables Load | 15-Oct-2021 05:35 AM | 15-Oct-2021 05:42 AM | |
| LMS Collection Load | 15-Oct-2021 04:17 AM | 15-Oct-2021 05:44 AM | |
| Legacy Learning Management System | 16-Oct-2012 10:10 AM | 16-Oct-2012 03:02 PM | |
| Payroll Data | Job | Start Time | End Time |
| Emp Comp Dist Load | 02-Jul-2019 04:55 AM | 02-Jul-2019 04:57 AM | |
| Emp Comp Payment Load | 02-Jul-2019 05:58 AM | 02-Jul-2019 05:58 AM | |
| Employee SSN Change | 18-Jun-2019 06:12 PM | 18-Jun-2019 06:12 PM | |
| Employee/Position Snapshot | 29-Jun-2019 01:48 AM | 29-Jun-2019 03:45 AM | |
| Encumbrances | 02-Jul-2019 05:58 AM | 02-Jul-2019 06:03 AM | |
| HCM Legacy Table Update | 15-Oct-2021 12:56 AM | 15-Oct-2021 12:59 AM | |
| HCM Payments and Encumbrances | 15-Oct-2021 12:59 AM | 15-Oct-2021 01:08 AM | |
| HCM Person and Position | 15-Oct-2021 12:41 AM | 15-Oct-2021 12:56 AM | |
| HCM Position History | 15-Oct-2021 12:56 AM | 15-Oct-2021 12:58 AM | |
| HCM Snapshots | 01-Oct-2021 08:31 AM | 01-Oct-2021 08:51 AM | |
| PAR | 02-Jul-2019 04:55 AM | 02-Jul-2019 05:54 AM | |
| Payments | 02-Jul-2019 05:54 AM | 02-Jul-2019 05:57 AM | |
| Payroll Change Log | 02-Jul-2019 02:47 PM | 01-Jul-2019 09:34 PM | |
| Payroll/HR | 02-Jul-2019 02:50 PM | 02-Jul-2019 12:01 AM | |
| Payroll/HR Email | 02-Jul-2019 04:44 AM | 02-Jul-2019 04:55 AM | |
| Penn ID Update | 15-Oct-2021 01:08 AM | 15-Oct-2021 01:12 AM | |
| PennWorks | 02-Jul-2019 12:06 AM | 02-Jul-2019 12:15 AM | |
| Position | 02-Jul-2019 02:44 PM | 01-Jul-2019 08:51 PM | |
| Planning Data | Job | Start Time | End Time |
| GAAPHist Load | 24-Oct-2016 08:12 AM | 24-Oct-2016 08:21 AM | |
| GAAPHist and PennHist Load (Cloud) | 15-Oct-2021 06:20 AM | 15-Oct-2021 06:20 AM | |
| Hyperion Revexp Load | 15-Oct-2021 02:56 AM | 15-Oct-2021 03:12 AM | |
| Hyperion Salary Load | 15-Oct-2021 01:08 AM | 15-Oct-2021 01:10 AM | |
| Research Data | Job | Start Time | End Time |
| BRIM | 01-May-2014 01:44 PM | 01-May-2014 05:52 PM | |
| GRAM Snapshot | 02-Oct-2021 06:26 AM | 02-Oct-2021 06:36 AM | |
| Human Subject Protocols | 14-Oct-2021 10:00 PM | 14-Oct-2021 10:25 PM | |
| Lab Animal protocol data | 14-Oct-2021 10:26 PM | 14-Oct-2021 10:41 PM | |
| PennERA People | 15-Oct-2021 02:56 AM | 15-Oct-2021 02:58 AM | |
| Proposal Tracking | 15-Oct-2021 02:59 AM | 15-Oct-2021 05:28 AM | |
| Protocol Status | 14-Oct-2021 10:00 PM | 14-Oct-2021 11:33 PM | |
| RIS Community Data DW Load | 15-Oct-2021 05:28 AM | 15-Oct-2021 05:28 AM | |
| RIS Subaward and MTA/NMA DW Load | 15-Oct-2021 05:28 AM | 15-Oct-2021 05:31 AM | |
| Student Data | Job | Start Time | End Time |
| BRS Detail | 09-Oct-2015 06:31 AM | 09-Oct-2015 06:45 AM | |
| BRS GL Detail | 09-Oct-2015 04:21 PM | 09-Oct-2015 04:23 PM | |
| BRS SSN Changes | 28-Sep-2016 07:00 PM | 28-Sep-2016 07:00 PM | |
| Course Eval Staging | 04-Apr-2012 04:39 PM | 14-Oct-2021 11:32 PM | |
| Curriculum Management Part1 | 15-Oct-2021 06:01 AM | *** In progress *** | |
| Curriculum Management Part2 | 15-Oct-2021 06:04 AM | 15-Oct-2021 06:05 AM | |
| DTA/Instructor | 09-Oct-2021 01:56 AM | 09-Oct-2021 01:56 AM | |
| DTA/Student Snapshot | 16-Sep-2021 06:28 AM | 16-Sep-2021 06:43 AM | |
| Financial Aid Reporting Load | 14-Oct-2021 10:08 PM | 14-Oct-2021 10:16 PM | |
| Financial Aid Staging Load | 14-Oct-2021 10:03 PM | 14-Oct-2021 10:08 PM | |
| Pennant Accounts Load | 14-Oct-2021 09:42 PM | 14-Oct-2021 10:07 PM | |
| Pennant Graduate Funding Load | 15-Oct-2021 06:07 AM | 15-Oct-2021 06:09 AM | |
| Student | 14-Oct-2021 11:12 PM | 14-Oct-2021 11:28 PM | |
| Tuition Distribution | 15-Oct-2021 01:12 AM | 15-Oct-2021 01:13 AM | |
| Travel Data | Job | Start Time | End Time |
| GAR Update | 23-Sep-2021 02:00 AM | *** Job failed *** | |
| ISOS Travel Data | 15-Oct-2021 01:00 AM | 15-Oct-2021 01:01 AM | |
| TEM Concur Data Dump Load | 15-Oct-2021 01:12 AM | 15-Oct-2021 01:35 AM | |
| TEM Concur Standard Accounting Extract (SAE) Load | 14-Oct-2021 11:00 PM | 14-Oct-2021 11:02 PM | |
| World Travel Update | 15-Oct-2021 02:08 AM | 15-Oct-2021 02:23 AM |
Copyright © 2021, University of Pennsylvania. All rights reserved.
Statement on privacy