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.