Penn Computing

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

CT_INSTITUTION Table - Data Element Index

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

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

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