| 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). |
