| Data element |
Definition |
| End_Date Indexed - no
Format - Date
May be Null? Y | Employment end/termination date |
| In_Discipline Indexed - no
Format - Char
May be Null? Y | Is this job in the same discipline as the PhD topic? |
| Info_Source Indexed - no
Format - Varchar2(40)
May be Null? Y | Source of information for the job history record |
| Inst_Id Indexed - yes
Format - Number
May be Null? Y | CT Insititution identifier. |
| Inst_Section Indexed - no
Format - Varchar2(80)
May be Null? Y | Institution section. The department or organizational sub-unit within the institution. |
| Job_Id Indexed - yes
Format - Number
May be Null? N | CT Job (Employment) History unique identifier, |
| Job_Time_Status Indexed - no
Format - Number
May be Null? Y | "Part-time" or "full-time" employment? |
| Last_Modified_By Indexed - no
Format - Varchar2(9)
May be Null? Y | Penn_ID of last person to modify the record. |
| Last_Modified_On Indexed - no
Format - Date
May be Null? Y | Date the record was last modified. |
| Override_Rank Indexed - no
Format - Number
May be Null? Y | Not used as of Feb 2013. |
| Position_Type_Id Indexed - no
Format - Number
May be Null? Y | CT position type identifier. |
| Secondary Indexed - no
Format - Number
May be Null? N | Indicator that this position is not the primary full-time position, ie. Secondary
Valid values are 0,1 |
| Start_Date Indexed - no
Format - Date
May be Null? Y | employment start date |
| Student_Id Indexed - yes
Format - Number
May be Null? Y | CT Student unique identifier. |
| Title Indexed - no
Format - Varchar2(60)
May be Null? Y | Job title |
| Title_Changes Indexed - no
Format - Varchar2(60)
May be Null? Y | Previous values of "Title" for this employment record. |
