This entity stores all the information about the bank record. Attributes such as PaymentAmt, PaymentType, BankAccType etc are all stored in this table.

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 bank record. This is the primary key for the BankRecord 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 branch code of the bank where payment is made.

Shows the code of the bank where payment is made.

Shows the total amount that is being paid.

Shows how the payment is made.
Example: By bank / Cheque

Shows the value of how much is being paid in percentage.
Example: "100" = Full amount / "50" = Half amount

Shows the type of payment made.
Example: Percentage / Balance / Fixed Amount

Shows the bank account number for payment to be made.

Shows the type of bank account.
Example: Savings / Cheque

Shows the mode of payment.
Example: Direct Debit / Cheque / Cash

The name of the person who will receive the money.