This entity is used to track changes in the basic wages and would record all the pay increment records for the employee. This record is for amending: Basic wage adjustments, wage rate adjustments (monthly, weekly, daily) and if applicable, exchange rates.

When a new employee is created, it would create a record here and the increment code would be 'NJ' for new join. It would take the basic rate in the employee entity and place it into the attribute for pay increment, new wage and the increment amount. The hired date would also be transferred from the employee entity to this entity into the attributes - pay increment, effective date and pay increment progression date.

Multiple Basic Rate Progression records can be created and the Progression Date uniquely identifies each record. This means for any particular day, there can only be one Basic Progression Record. In addition, only one Basic Progression Record can be active at any time.

In the case of a pay increment for an employee, the pay increment's new wage is a calculated value: Adding the sum of the current wage to the pay increment amount.

An employee's salary cannot be changed on the Employment Details record. It is actually stored in a separate record, the Basic Rate Progression record. Each time you need to make an adjustment, the correct procedure is to create a new basic progression record.

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

Stores the progression date for the basic rate. This acts as a primary key for the BasicRateProgression table.
It is usually in the format: DD-MM-YYYY.

Stores the progression code for the basic rate.
Example: Increment / Decrement

Stores the effective date for the basic rate progression.
It is usually in the format: DD-MM-YYYY.

Stores the next increment date for the basic rate progression.
It is in the format: DD-MM-YYYY.

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

Shows the previous basic rate.

Shows the increment amount for the progression.

Shows the percentage of the basic rate for the progression.

Shows the new rate of he basic rate for the progression.

Shows the type for the basic rate.
Example: MonthlyRated / DailyRated

Shows the pay group for the progression.
Example:
1 Payment Group
2 Payment Group
3 Payment Group
4 Payment Group
Project

Shows if the employee is a current staff or not. The database will show "1" if the employee is current and "0" if the employee no longer works there.

Shows the remarks for the basic rate progression.

Stores the identity of the exchange rate.