Previous Topic: DIVISIONNext Topic: EXPERTISE


EMPLOYEE

EMP_ID

Unique employee ID

MANAGER_ID

Employee ID of employee's manager

EMP_FNAME

Employee's first name

EMP_LNAME

Employee's last name

DEPT_ID

ID of department to which employee is assigned

STREET

Employee's street address

CITY

Employee's city

STATE

Employee's state

ZIP_CODE

Employee's zip code

PHONE

Employee's phone

STATUS

Status of employee: (A) Active; (S) Short-term disability; (L) Long term disability

SS_NUMBER

Social security number

START_DATE

Employee's date of hire

TERMINATION_DATE

Date of termination

BIRTH_DATE

Birth date