 |
 |
| 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 | 08-Aug-2022 12:09 PM | 08-Aug-2022 12:15 PM | |
| UGA Mod1 Application | 08-Aug-2022 04:45 AM | 08-Aug-2022 04:45 AM | |
| Undergrad Admissions | 06-Aug-2022 08:09 PM | 06-Aug-2022 08:16 PM | |
| Undergrad Admissions Summary | 06-Aug-2022 08:16 PM | 06-Aug-2022 08:35 PM | |
| BBR Data | Job | Start Time | End Time |
| Load of AR Adjustments | 06-Aug-2022 11:48 PM | 06-Aug-2022 11:48 PM | |
| Load of AR Applications | 06-Aug-2022 11:48 PM | 06-Aug-2022 11:49 PM | |
| Load of AR Collections - Delinquencies Data | 06-Aug-2022 11:48 PM | 06-Aug-2022 11:48 PM | |
| Load of AR Collections - Dunning Data | 06-Aug-2022 11:48 PM | 06-Aug-2022 11:48 PM | |
| Load of AR Collections - Notes Data | 06-Aug-2022 11:48 PM | 06-Aug-2022 11:48 PM | |
| Load of AR Collections - Promise Data | 06-Aug-2022 11:48 PM | 06-Aug-2022 11:48 PM | |
| Load of AR Customers | 07-Aug-2022 08:01 PM | 07-Aug-2022 08:04 PM | |
| Load of AR Transaction Lines | 07-Aug-2022 12:01 AM | 07-Aug-2022 12:02 AM | |
| Load of AR Transactions | 06-Aug-2022 11:48 PM | 06-Aug-2022 11:49 PM | |
| Load of GMS Award Report Log | 07-Aug-2022 12:10 AM | 07-Aug-2022 12:11 AM | |
| Load of GMS Awards and Projects | 06-Aug-2022 11:41 PM | 06-Aug-2022 11:56 PM | |
| Snapshot of AR Transactions | 30-Jul-2022 02:33 AM | 30-Jul-2022 02:42 AM | |
| Snapshot of GMS Award Report Log | 30-Jul-2022 02:25 AM | 30-Jul-2022 02:26 AM | |
| Business Services Data | Job | Start Time | End Time |
| Bookstore Extract | 22-Oct-2021 11:06 PM | 22-Oct-2021 11:06 PM | |
| StarRez Housing Data Refresh (Talend) | 08-Aug-2022 12:01 AM | 08-Aug-2022 12:04 AM | |
| StarRez Housing Data Snapshot Load (Talend) | 05-Aug-2022 11:00 PM | 05-Aug-2022 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 | 03-Feb-2022 12:32 AM | 03-Feb-2022 12:33 AM | |
| Email Data | Job | Start Time | End Time |
| Email Listserv | 08-Aug-2022 05:30 AM | 08-Aug-2022 05:30 AM | |
| Facilities Data | Job | Start Time | End Time |
| Building Utilities | 06-Aug-2022 05:07 AM | 06-Aug-2022 05:08 AM | |
| Space@Penn | 08-Aug-2022 12:55 AM | 08-Aug-2022 12:59 AM | |
| Work Request Mid-Day | 05-Aug-2022 01:30 PM | 05-Aug-2022 01:37 PM | |
| Work Requests | 05-Aug-2022 11:05 PM | 05-Aug-2022 11:31 PM | |
| Financial Data | Job | Start Time | End Time |
| Assets | 07-Aug-2022 02:48 AM | 07-Aug-2022 03:10 AM | |
| Assets Snapshot | 30-Jul-2022 05:55 AM | 30-Jul-2022 05:58 AM | |
| BBR Balances | 07-Aug-2022 12:31 PM | 07-Aug-2022 01:02 PM | |
| Balances | 07-Aug-2022 02:36 AM | 07-Aug-2022 07:15 AM | |
| BenReports Security | 08-Aug-2022 12:53 AM | 08-Aug-2022 12:54 AM | |
| Budget Periods | 08-Aug-2022 06:01 AM | 08-Aug-2022 06:01 AM | |
| CREF/PI Update | 07-Aug-2022 01:02 AM | 07-Aug-2022 01:05 AM | |
| Fund Status Update | 07-Aug-2022 12:31 PM | 07-Aug-2022 12:51 PM | |
| GAAP Report Template | 08-Aug-2022 01:30 AM | 08-Aug-2022 01:42 AM | |
| GL Detail | 06-Aug-2022 11:48 PM | 06-Aug-2022 11:53 PM | |
| GL Parent Reference | 07-Aug-2022 02:45 AM | 07-Aug-2022 02:48 AM | |
| GL Reference | 06-Aug-2022 11:43 PM | 06-Aug-2022 11:48 PM | |
| GL Report Templates | 07-Aug-2022 12:31 PM | 07-Aug-2022 12:40 PM | |
| Overhead Rates | 07-Aug-2022 12:31 PM | 07-Aug-2022 01:28 PM | |
| Responsible Org | 08-Aug-2022 12:53 AM | 08-Aug-2022 12:53 AM | |
| Summary Balances | 24-Apr-2022 02:03 AM | 24-Apr-2022 02:08 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 | 08-Aug-2022 07:00 AM | 08-Aug-2022 07:00 AM | |
| Grad Admissions CN Enrollment Reports Load | 06-Aug-2022 04:02 PM | 06-Aug-2022 04:04 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 | 16-May-2022 05:22 PM | 16-May-2022 05:22 PM | |
| Grad Admissions SRS Load Errors Feedback | 16-May-2022 05:22 PM | 16-May-2022 05:22 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 | 08-Aug-2022 05:51 AM | 08-Aug-2022 05:59 AM | |
| LMS Collection Load | 08-Aug-2022 04:18 AM | 08-Aug-2022 06:01 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 | 08-Aug-2022 12:47 AM | 08-Aug-2022 12:50 AM | |
| HCM Payments and Encumbrances | 08-Aug-2022 12:50 AM | 08-Aug-2022 12:53 AM | |
| HCM Person and Position | 08-Aug-2022 12:32 AM | 08-Aug-2022 12:47 AM | |
| HCM Position History | 08-Aug-2022 12:47 AM | 08-Aug-2022 12:48 AM | |
| HCM Snapshots | 01-Aug-2022 06:01 AM | 01-Aug-2022 06:26 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 | 08-Aug-2022 12:53 AM | 08-Aug-2022 12:55 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) | 08-Aug-2022 04:34 AM | 08-Aug-2022 04:34 AM | |
| Hyperion Revexp Load | 08-Aug-2022 01:12 AM | 08-Aug-2022 01:30 AM | |
| Hyperion Salary Load | 08-Aug-2022 01:09 AM | 08-Aug-2022 01:12 AM | |
| Research Data | Job | Start Time | End Time |
| BRIM | 01-May-2014 01:44 PM | 01-May-2014 05:52 PM | |
| GRAM Snapshot | 02-Aug-2022 04:48 AM | 02-Aug-2022 04:56 AM | |
| Human Subject Protocols | 05-Aug-2022 10:00 PM | 05-Aug-2022 10:44 PM | |
| Lab Animal protocol data | 05-Aug-2022 10:45 PM | 05-Aug-2022 11:10 PM | |
| PennERA People | 06-Aug-2022 02:31 AM | 06-Aug-2022 02:32 AM | |
| Proposal Tracking | 06-Aug-2022 02:33 AM |
*** In progress ***
Tables blocked: PennERA Fund Adjustment PennERA Increment PennERA Increment Status History PennERA Period PennERA Proposal PennERA Proposal Activity PennERA Proposal Investigator PennERA Proposal Parent PennERA Proposal Regulatory Approval PennERA Proposal Status History PennERA Request PennERA Request Status History PennERA Sponsor PennERA Subcontract PennERA Subcontractor PennERA Subcontractor Increment PennERA Subcontractor Request |
|
| Protocol Status | 05-Aug-2022 10:00 PM | 05-Aug-2022 10:49 PM | |
| RIS Community Data DW Load | 06-Aug-2022 07:43 PM | 06-Aug-2022 07:43 PM | |
| RIS Subaward and MTA/NMA DW Load | 06-Aug-2022 07:43 PM | 06-Aug-2022 07:45 PM | |
| 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 | 05-Aug-2022 11:09 PM | |
| Curriculum Management Part1 | 08-Aug-2022 06:00 AM | *** In progress *** | |
| Curriculum Management Part2 | 05-Aug-2022 06:13 AM | 05-Aug-2022 06:17 AM | |
| DTA/Instructor | 06-Aug-2022 02:31 AM | 06-Aug-2022 02:31 AM | |
| DTA/Student Snapshot | 21-May-2022 06:19 AM | 21-May-2022 06:38 AM | |
| Financial Aid Reporting Load | 05-Aug-2022 11:28 PM | 06-Aug-2022 01:22 AM | |
| Financial Aid Staging Load | 05-Aug-2022 10:13 PM | 05-Aug-2022 11:28 PM | |
| Pennant Accounts Load | 05-Aug-2022 09:01 PM | 05-Aug-2022 09:20 PM | |
| Pennant Graduate Funding Load | 06-Aug-2022 06:00 AM | 06-Aug-2022 06:03 AM | |
| Pennant Student Records | 08-Aug-2022 12:01 AM | 08-Aug-2022 02:23 AM | |
| Student | 07-Aug-2022 05:05 PM | 07-Aug-2022 05:18 PM | |
| Tuition Distribution | 08-Aug-2022 12:55 AM | 08-Aug-2022 12:55 AM | |
| Travel Data | Job | Start Time | End Time |
| GAR Update | 23-Sep-2021 02:00 AM | *** Job failed *** | |
| ISOS Travel Data | 08-Aug-2022 01:00 AM | 08-Aug-2022 01:05 AM | |
| TEM Concur Data Dump Load | 08-Aug-2022 12:55 AM | 08-Aug-2022 01:16 AM | |
| TEM Concur Standard Accounting Extract (SAE) Load | 05-Aug-2022 11:00 PM | 05-Aug-2022 11:04 PM | |
| World Travel Update | 06-Aug-2022 02:05 AM | 06-Aug-2022 02:22 AM |
Copyright © 2022, University of Pennsylvania. All rights reserved.
Statement on privacy