Previous Topic: BENEFITSNext Topic: COVERAGE


CONSULTANT

CON_ID

Unique consultant ID

CON_FNAME

Consultant's first name

CON_LNAME

Consultant's last name

MANAGER_ID

Employee ID of consultant's manager

DEPT_ID

ID of department to which consultant is assigned

PROJ_ID

ID of project to which consultant is assigned

STREET

Consultant's street address

CITY

Consultant's city

STATE

Consultant's state

ZIP_CODE

Consultant's zip code

PHONE

Consultant's phone

BIRTH_DATE

Birth date

START_DATE

Consultant's date of hire

SS_NUMBER

Social security number

RATE

Hourly rate of pay