Penn Computing

University of Pennsylvania
Penn Computing << go backback
CT_JOB_HISTORY Table . Tables and Data Elements . Career Tracker Home . Data Warehouse Home

CT_JOB_HISTORY Table - Data Element Index

Select a data element to view its definition and its indexed, format, and null values.

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.

CT_JOB_HISTORY Table . Tables and Data Elements . Career Tracker Home . Data Warehouse Home

Questions about this page? Email us at da-staff@isc.upenn.edu

Information Systems and Computing
University of Pennsylvania
Information Systems and Computing, University of Pennsylvania