hr_all


Columns

Column Type Size Nulls Auto Default Children Parents Comments
Functional Group VARCHAR 61 √ null
Employee ID INT 10 null
NTID VARCHAR 50 √ null
Full Name VARCHAR 53 √ null
Last Name VARCHAR 50 √ null
First Name VARCHAR 50 √ null
Middle Initial VARCHAR 50 √ null
Preferred Last Name VARCHAR 50 √ null
Preferred First Name VARCHAR 50 √ null
FLSA VARCHAR 50 √ null
Time Type VARCHAR 50 √ null
Job Code INT 10 √ null
Job Title VARCHAR 72 √ null
Executive Indicator VARCHAR 52 √ null
VP/Director Flag INT 10 √ null
Direct Reports INT 10 √ null
Indirect Reports INT 10 √ null
Total Reports INT 10 √ null
Work Email VARCHAR 67 √ null
Supervisor Employee ID VARCHAR 50 √ null
Supervisor Name VARCHAR 62 √ null
Supervisor Email VARCHAR 66 √ null
Leader 1 Name VARCHAR 50 √ null
Leader 2 Name VARCHAR 50 √ null
Leader 3 Name VARCHAR 50 √ null
Leader 4 Name VARCHAR 53 √ null
Leader 5 Name VARCHAR 63 √ null
Leader 6 Name VARCHAR 62 √ null
Leader 7 Name VARCHAR 53 √ null
Leader 8 Name VARCHAR 56 √ null
Leader 9 Name VARCHAR 51 √ null
Leader 10 Name VARCHAR 20 √ null
Top Director VARCHAR 63 √ null
Director VARCHAR 62 √ null
Top VP VARCHAR 50 √ null
VP VARCHAR 53 √ null
Work Location Code VARCHAR 50 √ null
Work Location Description VARCHAR 71 √ null
Work Location Type VARCHAR 59 √ null
Work Address 1 VARCHAR 67 √ null
Work Address 2 VARCHAR 20 √ null
Work City VARCHAR 50 √ null
Work State VARCHAR 50 √ null
Work Zip INT 10 √ null
Work Country VARCHAR 50 √ null
Home State VARCHAR 50 √ null
Home Zip VARCHAR 8 √ null
Business Phone VARCHAR 50 √ null
Org Unit ID INT 10 √ null
Org Unit Description VARCHAR 81 √ null
Cost Center INT 10 √ null
Cost Center Name VARCHAR 70 √ null
Acquisition Indicator VARCHAR 50 √ null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc Employee ID

Relationships

Close relationships within degrees of separation