Sage EasyPay Data Model

Entity LoanPayment

Description of Entity LoanPayment

This entity controls when the pay elements are inserted into the employee's pay record. The pay record ID needs to be an exact match of available pay records. If no match is found, the pay element is not inserted.
Example: If you want the loan payment to be places in a pay record named "Loan", you will need to initialise / create an Other Pay type of Pay record and rename it to "Loan".

List of all Dependencies of the Entity LoanPayment

Relation_1717854

Reference

List of Attributes of the Entity LoanPayment

Entity Attribute LoanPaymentSysId of the Entity LoanPayment

Card of Attribute LoanPaymentSysId of the Entity LoanPayment

Name	LoanPaymentSysId
Code	LoanPaymentSysId
Data Type	integer
Mandatory	Yes

Description of Attribute LoanPaymentSysId of the Entity LoanPayment

A system generated identity for the loan payment. It is blind to the user. It also holds the primary key for the LoanPayment table.

Entity Attribute Sub Period of the Entity LoanPayment

Card of Attribute Sub Period of the Entity LoanPayment

Name	Sub Period
Code	LoanPaySubPeriod
Data Type	smallint
Mandatory	No

Description of Attribute Sub Period of the Entity LoanPayment

Holds the sub period for the loan payment.

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)

Entity Attribute Pay Record ID of the Entity LoanPayment

Card of Attribute Pay Record ID of the Entity LoanPayment

Name	Pay Record ID
Code	LoanPayRecordId
Data Type	char(20)
Mandatory	No

Description of Attribute Pay Record ID of the Entity LoanPayment

Shows the identity for the pay record of the loan.

Home