Penn Computing

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

CT_ADDRESS Table - Data Element Index

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

Data element Definition
Address_Type

Indexed - yes
Format - Number
May be Null? N

Career Tracker address type id. Decode using ct_address_types table.

City

Indexed - no
Format - Varchar2(30)
May be Null? Y

City

Country

Indexed - no
Format - Char
May be Null? Y

Career Tracker country code

State

Indexed - no
Format - Char
May be Null? Y

State

Street1

Indexed - no
Format - Varchar2(60)
May be Null? Y

Street1

Street2

Indexed - no
Format - Varchar2(60)
May be Null? Y

Street2

Student_Id

Indexed - yes
Format - Number
May be Null? N

Career Tracker student identifier

Zip

Indexed - no
Format - Varchar2(10)
May be Null? Y

Zipcode (5+4)

CT_ADDRESS 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