Penn Computing

Penn Computing

Computing Menu Computing A-Z
Computing Home Information Systems & Computing Penn

 
  UPDATES
Current Load Status
Regular Availability
 
  INFORMATION
FAQs & Tips
Password Changer
Support services
Security
About the Data Warehouse
Data Administration
 
  DATA COLLECTIONS
Advancement
Assets
BBR
BRIM
Express Mail
Facilities
Faculty
GAR
General Ledger
Infrastructure
ISSS-iOffice
Learning Management
Position Inventory
Research-PennERA Proposals
Research Inventory
Salary Management
Student
Travel Expense Management
Tuition Distribution
World Travel
Cross-Collection

Career Tracker Collection Refresh Schedule

The Career Tracker collection in the data warehouse (all tables named GRADADM.CT_ ) is refreshed daily at 6:00pm, from the tables in SAS's Career Tracker application. However, the source data itself is not "typically" updated except on these occasions:

  • Semester-based inserts of new PhD or EdD graduates.
  • Fontaine affiliation designation from the Provost Office.
  • Reference data and user access data maintenance by School of Arts & Science.


  • In which case, the Career Tracker data in the warehouse would only be changed 1-3 times per semester.

CAUTIONARY NOTE: GRADADM.CT_ tables in this collection are not being kept in-synch with the DWADMIN tables loaded nightly from SRS. This is due to SAS's practice of loading the Career Tracker application from SRS only one time after a student graduates. If a PhD graduate's SRS data is updated after that point in time, the change would be seen in the Student collection (for example dwadmin.address), but not in the Career Tracker collection. (gradadm.ct_address).

Technically speaking, this collection is refreshed using a FAST daemon with FAST merge approach.

  Collection Information:
top

Information Systems and Computing
University of Pennsylvania
Comments & Questions


Penn Computing University of Pennsylvania
Information Systems and Computing, University of Pennsylvania