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

Phone Phone_City_Code Phone_Country_Code Phone_Type Student_Id

Data element	Definition
Phone Indexed - no Format - Varchar2(10) May be Null? Y	Phone number
Phone_City_Code Indexed - no Format - Char May be Null? Y	Phone number city code (4 digits)
Phone_Country_Code Indexed - no Format - Char May be Null? Y	Phone number country code (3 digits)
Phone_Type Indexed - yes Format - Number May be Null? N	CT Phone type. Decode using ct_phone_types.
Student_Id Indexed - yes Format - Number May be Null? N	Career Tracker student identifier

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