Data element |
Definition |
Cv_Date Indexed - no Format - Date May be Null? Y | Date the CV was entered/effective. |
Deceased Indexed - no Format - Char May be Null? Y | Student is deceased (Y/N/Null)? |
Degree_Received Indexed - no Format - Varchar2(3) May be Null? Y | Degree Received (as recorded in CT).
Examples: EDD, PHD |
Entry_Term Indexed - no Format - Varchar2(5) May be Null? Y | Entry term (as recorded in CT). |
Exit_Action Indexed - no Format - Varchar2(2) May be Null? Y | Exit Action (as recorded in CT). |
Exit_Term Indexed - no Format - Varchar2(5) May be Null? Y | Exit term (as recorded in CT). |
First_Name Indexed - yes Format - Varchar2(35) May be Null? Y | First name of student. |
Grad_Group Indexed - yes Format - Varchar2(4) May be Null? Y | Grad group of the student (as recorded in CT). |
Group_Id Indexed - yes Format - Varchar2(6) May be Null? Y | CT Group ID.
Value is either "ALL", SRS School[MD], or SRS School concatenated with SRS Major [WHSTAT].
|
Last_Name Indexed - yes Format - Varchar2(35) May be Null? Y | Last name of student. |
Penn_Id Indexed - yes Format - Varchar2(8) May be Null? Y | Penn_ID of student in career tracker. |
Phd_Awarded Indexed - no Format - Varchar2(1) May be Null? Y | Value is "Y" for all records in CareerTracker application - even when degree awarded is EDD. |
Student_Id Indexed - yes Format - Number May be Null? N | Career Tracker student identifier. |
Time_To_Degree Indexed - no Format - Number May be Null? Y | Time taken to be awarded the degree (as recorded in CT). |