This is used to track the staff movement from within the company. Each employee can have multiple Career Progression records of which only one is active at any time. You may have employees who have a change in their employment details, e.g. a transfer in department or a promotion.

System generated identifier. It is blind to the user. It also holds the primary key for the Employee table.

Shows the effective date of the career progression. It also acts as a primary key for the CareerProgression table.
It is usually in the format: DD-MM-YYYY.

Stores and remarks concerning the career.

Shows the identity of the career attachment.

Shows the career attachment.

Shows the identity of the career for the employee.
Example: FirstRecord / Transfer / Promotion / SalaryAdjust etc

Indicates if the employee is currently employed in the company.