The Career Tracker data collection is a subset of the Data Warehouse containing the job history of PhD students post-graduation. It also includes dissertation titles, categorizations of employers(institutions) by sector/rank/custom tags, and identification of Fontaine Fellowship recipients.
The collection comes from the School of Arts & Science's web-based database/application of the same name.
ATTENTION: All users of Student Data, whether they write their own queries, or use data or reports extracted by someone else, agree to abide by University policy regarding confidentiality of student records, and by the Family Educational and Right to Privacy Act. Failure to abide by the policies and laws governing student data can result in disciplinary action, including termination.
Tables are listed in alphabetical order. Select Table to obtain the explantion, common uses, primary keys, indexed data elements, and related tables for a table. Select Elements to obtain the definition, list of values, formats, and not null values for each data element in the table. A description of table and data element terminology is in the document What the Warehouse Contains.
Looking for a specific element or caution? Try the searching the collection documentation for particular keywords (search page will open in a new tab).
| Career Tracker Data Tables: | |||
| CT_ADDRESS Table Elements |
CT_JOB_HISTORY Table Elements |
||
| CT_AFFILIATION Table Elements |
CT_PHD_RECORD Table Elements |
||
| CT_EMAIL Table Elements |
CT_PHONE Table Elements |
||
| CT_INSTITUTION Table Elements |
CT_STUDENT Table Elements |
||
| CT_INSTITUTION_TAG Table Elements |
CT_STUDENT_SUPERVISOR Table Elements |
||
| Lookup Tables: | |||
| CT_ADDRESS_TYPES Table Elements |
CT_FACULTY Table Elements |
||
| CT_AFFILIATION_CODE Table Elements |
CT_INST_RANK Table Elements |
||
| CT_CLASS_NAME Table Elements |
CT_INST_TYPE Table Elements |
||
| CT_CLASS_TYPE Table Elements |
CT_PHONE_TYPES Table Elements |
||
| CT_COUNTRY_CODE Table Elements |
CT_POSITION_TYPE Table Elements |
||
| CT_DEPT Table Elements |
CT_SCHOOL Table Elements |
||
| CT_EMAIL_TYPES Table Elements |
CT_STUDY Table Elements |
||
| CT_EMPLOYMENT_SECTOR Table Elements |
CT_TIME_STATUS Table Elements |
||
| Tables not included: | |||
| CT_DEPT_STAFF CT_FACULTY_MANUAL CT_INST_POSITION_TYPE CT_MAJOR_CONVERT CT_SECURITY_APPLID CT_STAFF CT_TERM_DECODE CT_TITLE_CHANGES |
|||
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.
The diagram illustrates the architecture of the Career Tracker BusinessObjects Universe, and identifies joins. While viewing the diagram, you can also display its table documentation by clicking anywhere in the box. If you need to print the diagram, print it in landscape orientation.
The BusinessObjects Corporate Documents area provides access to pre-defined, prompt-driven reports that you can run to retrieve a standardized perspective on your data
All reports can be found in Public Folders -> Career Tracker and use the "Career Tracker" universe.
They were initially designed to be identical to the reports available in the Career Tracker application.
All Job Records
This report lists all job records for all graduates by graduate group.
Current Fontaine Records
This report lists current job record for Fontaine Fellows by graduate group and institution type.
Current Records
This report lists current job record for all graduates by graduate group, instititution class, or academic type.
Current Records by Cluster
This report lists current job record for all graduates in a specified graduate group cluster.
Dissertation Supervisors
This report lists all dissertation supervisors, students, and titles. (subset?)
Fontaine Fellows No Job History
This report lists Fontaine-Fellow graduates with no job history records.
Graduates at an Institution
This report lists all graduates with job placement at a specified institution, by graduate group.
Graduates with No Job History
This report lists all graduates with no job history records.
Last Update of Institution
This report lists last update of all institution records. (subset?)
Last Update of Job History
This report lists last update of job history for all student records in a specified graduate group.
Mentees by Faculty Member
This report lists all students mentored by a specified faculty member.
Student Addresses
This report lists all mailing and email addresses for students by graduate group.
Data training for this collection is offered on an ad hoc basis -- please contact Enterprise Information & Analytics for assistance with specific training questions. You can also refer to the table and element documentation for information and cautions about specific data.
If you want access to the Career Tracker data collection you must submit the Career Tracker Data Warehouse Access Request eForm, and have the request approved.
Releasing Data Outside the University
The only two offices that may disclose employee, job, or salary data outside the University are the Division of Human Resources and Institutional Research & Analysis. If you do not work for those offices and you receive a request for data to be sent outside the University, refer the requester to the Division of Human Resources.
Releasing Data Within the University
Within the University, employee, job, or salary data may be disclosed only if it is needed to do the business of the University, and only to those who need to know the information in order to do their jobs. If you are not sure whether to fulfill a request for employee, job, or salary data, call the Division of Human Resources.
Query Results
If you save your query results in Excel, pdf, or any other local file type, you must see to it that any sensitive data stored on your peronal computer is safeguarded through physical security, access control software, or encryption. When a computer is left signed to an account, it is easy for someone to gain unauthorized access. Either sign off from your account before you leave your computer or restrict access by some other means (physical security or access control software).
For more information on security and privacy, contact the Office of Information Security.
If you have a question or comment about the Career Tracker data or data documentation, or have a suggestion for revising the documentation, please contact Enterprise Information & Analytics. For documentation published on the Web, please specify the URL for the documentation that needs to be updated.