This entity contains the summary of the Pay Record.

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

Shows the generating identity of the detail record. This is the primary key for the DetailRecord table.
Example: A1 / A66 / A110

Shows the year for the pay record.
Example: 2012

Shows the period for the pay record.
Example: January = "1", February = "2", March = "3" etc.

Holds the sub period for the pay record.

Example:
Sub period 1 = 1 Payment Group (Hourly, Daily & Monthly rated)
Sub period 2 = 2 Payment Group (Hourly, Daily & Monthly rated)
Sub period 3 = 3 Payment Group (Hourly & Daily rated), divided by 3 and the balance is placed in the last sub-period
Sub Period 4 = 4 Payment Group (Hourly & Daily rated)

Stores the identity for the pay record.
Example: Normal / Normal Time Sheet

Shows the current rate of the employee's salary. Some of the employee's rate are daily rated, some are monthly rated.
Example: 2,000 a month / 100 a day

Shows the previous rate of the employee's salary. Some of the employee's rate are daily rated, some are monthly rated.
Example: 2,000 a month / 100 a day

Shows the sum of the allocated rate of the employee's salary for a month.

Shows the type of the current basic rate.
Example: Monthly rated / Daily rated

Shows the type of the previous basic rate.
Example: Monthly rated / Daily rated

Stores the sum of the previous number of working days.

Stores the sum of the current number of working days in a month.
Example: 20 / 23 days

Stores the rate of salary from the previous working days.

Stores the rate of salary from the current working days.

For daily pay allocation:
- Fixed days: Set a fixed number of days per sub period
- Work Calendar: Use the employee's work calendar to determine the number of days
- Balance Fixed Calendar: Applicable only for last pay period

For monthly pay allocation: applies to the first sub period only. Balance is placed in the second sub period
- Fixed amount: Type in a fixed wage amount
- Percentage: Wage percentage expressed as whole numbers, i.e. 50% as 50. "%" symbol is not required.

Shows the value of the pay allocation.

Shows the current rate of the back pay from the basic rate.

Shows the previous rate of the back pay from the basic rate.

Calculates the total sum of wage of each employee.

Calculates the total gross wage of each employee.

Calculates the sum of the amount for working overtime.

Calculates the sum of the amount of back pay for working overtime.

Calculates the sum of the amount for working on a shift.

Calculates the amount deducting leave pay.

Calculates the total sum of back payment of each employee.

Calculates the gross wage of each employee.

Calculates the net wage of each employee.

Shows the amount of the prorated back pay.

Shows the full back pay amount.

Shows the date of when the back pay was processed.

Shows the identity of the current basic rate's exchange rate.

Shows the current basic rate's exchange rate.

Shows the current foreign basic rate of the employee's salary. Some of the employee's rate are daily rated, some are monthly rated.

Shows the previous foreign basic rate of the employee's salary. Some of the employee's rate are daily rated, some are monthly rated.

Shows the allocated foreign basic rate of the employee's salary for a month.

Calculates the total foreign wage of each employee.

Calculates the foreign back pay of each employee.

Shows the current foreign back pay basic rate for the employee.

Shows the previous foreign back pay basic rate for the employee.

Enables the customer to customize the section. Numeric usually stands for numbers or digits. Numeric(5,2) means there are 5 digits with 2 decimal places, i.e. 123.45
Example: It can ask for the amount of pay earned in a day, i.e. 105.87

Enables the customer to customize the section. Numeric usually stands for numbers or digits. Numeric(5,2) means there are 5 digits with 2 decimal places, i.e. 123.45
Example: It can ask for the amount of pay earned in a day, i.e. 105.87

Enables the customer to customize the section. Numeric usually stands for numbers or digits. Numeric(5,2) means there are 5 digits with 2 decimal places, i.e. 123.45
Example: It can ask for the amount of pay earned in a day, i.e. 105.87

Enables the customer to customize the section. Numeric usually stands for numbers or digits. Numeric(5,2) means there are 5 digits with 2 decimal places, i.e. 123.45
Example: It can ask for the amount of pay earned in a day, i.e. 105.87

Enables the customer to customize the section. Numeric usually stands for numbers or digits. Numeric(5,2) means there are 5 digits with 2 decimal places, i.e. 123.45
Example: It can ask for the amount of pay earned in a day, i.e. 105.87

Enables the customer to customize the section. String is a data type which includes letters, digits and special characters. It is a sequence of characters. It can ask for the name of a previous employer.
Example: Sage Software Asia Pte. Ltd.

Enables the customer to customize the section. String is a data type which includes letters, digits and special characters. It is a sequence of characters. It can ask for the name of a previous employer.
Example: Sage Software Asia Pte. Ltd.

Enables the customer to customize the section. String is a data type which includes letters, digits and special characters. It is a sequence of characters. It can ask for the name of a previous employer.
Example: Sage Software Asia Pte. Ltd.

Enables the customer to customize the section. String is a data type which includes letters, digits and special characters. It is a sequence of characters. It can ask for the name of a previous employer.
Example: Sage Software Asia Pte. Ltd.

Enables the customer to customize the section. String is a data type which includes letters, digits and special characters. It is a sequence of characters. It can ask for the name of a previous employer.
Example: Sage Software Asia Pte. Ltd.

Shows the net wage of the employee.

Shows the identity of the rate of the net wage of the employee.

Shows the rate of the net wage of the employee.

Shows the identity for the bank allocation of the net wage for the employee.
Example: Local