This entity stores the information about the allowance record. Shows the allowance amount, when it was used etc

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 allowance record. It is also the primary key for the AllowanceRecord 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 type of allowance.
Example: Phone / Transport

Stores the amount of allowance.

System generated identifier. Shows the recurring allowance.
Example: A1 / A2 / A3

Shows the record of the pre-processed record.

Shows who has created the pay record.

Shows the date of when the employee claims the allowance.
Example: 2012-03-01

Stores any remarks.

System generated identifier of the allowance.

Stores the Foreign Allowance Amount based on the Exchange Rate, i.e. Foreign Currency.

Stores the identity of the exchange rate of the Allowance Formula.
Example: SGD / AUD / USD

Stores the exchange rate of the Allowance Formula.
Example: 1.0