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

Dept_Code Dept_Name Group_Id Phd_Dept School Study_Type

Data element	Definition
Dept_Code Indexed - yes Format - Varchar2(4) May be Null? Y	Career Tracker 4-char department code. Examples: ACCT, ALL, ALL, ..., SSYS, STAT
Dept_Name Indexed - no Format - Varchar2(60) May be Null? Y	CT department name. Examples: Accounting, All Grad Groups, All Medicine Groups, ..., Social Systems Sciences, Statistics
Group_Id Indexed - yes Format - Varchar2(6) May be Null? N	CT Group identifier. Examples: WHACCT, ALL, MD, ..., WHSSYS, WHSTAT
Phd_Dept Indexed - no Format - Varchar2(1) May be Null? Y	PHD department (Y/N) ?
School Indexed - yes Format - Varchar2(2) May be Null? Y	CT School identifier. Examples: "--", AN, AS, ... VM, WH
Study_Type Indexed - no Format - Varchar2(1) May be Null? Y	CT Study type identiifer. Examples: B, H, N, S, W

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