EMP_ID

Employee ID

JOB_ID

Job ID associated with this employee

START_DATE

Date employee began this job

FINISH_DATE

Date employee ended this job (null if current)

HOURLY_RATE

Hourly rate earned while in this job (if hourly position)

SALARY_AMOUNT

Yearly salary earned while in this job (if salaried position)

BONUS_PERCENT

Bonus percent amount for this position (if sales position)

COMM_PERCENT

Commission percent for this position (if sales position)

OVERTIME_RATE

Overtime rate for this position (if hourly position)