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

City Country Inst_Id Inst_Name Inst_Name_Upper Inst_Type_Id Last_Modified_By Last_Modified_On State

Data element	Definition
City Indexed - no Format - Varchar2(20) May be Null? Y	City (address).
Country Indexed - no Format - Varchar2(2) May be Null? Y	CT Country code.
Inst_Id Indexed - yes Format - Number May be Null? N	CT_Institution unique identifier.
Inst_Name Indexed - no Format - Varchar2(75) May be Null? N	Name of the institution.
Inst_Name_Upper Indexed - yes Format - Varchar2(75) May be Null? Y	Uppercase version of the institution name.
Inst_Type_Id Indexed - no Format - Number May be Null? Y	CT Institution type unique identifier.
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.
State Indexed - no Format - Varchar2(20) May be Null? Y	State (address).

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