Sage EasyPay Data Model

Entity LoanEmployee

Description of Entity LoanEmployee

This entity keeps track of loans issued through the company. These loans maybe from the company or from a government body.

Once set up, the pay record creation process will check for any loan set ups and insert the loan payments accordingly. However, you might see a warning message about negative net wage for the employee.

Possible scenarios:
- The pay record containing the loan repayment does not contain any pay.
- The employee's wages is not enough to cover the loan repayment amount.
- Loan period is too short.
- The person is no longer employed, i.e. there is a cessation code and a cessation date on the employment record. The last pay-date is present on the pay details record as well.

List of all Dependencies of the Entity LoanEmployee

Reference

Reference

Reference

Reference

Reference

List of Attributes of the Entity LoanEmployee

Entity Attribute EmployeeSysId of the Entity LoanEmployee

Card of Attribute EmployeeSysId of the Entity LoanEmployee

Name	EmployeeSysId
Code	EmployeeSysId
Data Type	integer
Mandatory	Yes

Description of Attribute EmployeeSysId of the Entity LoanEmployee

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

Entity Attribute LoanSysId of the Entity LoanEmployee

Card of Attribute LoanSysId of the Entity LoanEmployee

Name	LoanSysId
Code	LoanSysId
Data Type	integer
Mandatory	Yes

Description of Attribute LoanSysId of the Entity LoanEmployee

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

Entity Attribute Ref No of the Entity LoanEmployee

Card of Attribute Ref No of the Entity LoanEmployee

Name	Ref No
Code	LoanRefNo
Data Type	char(20)
Mandatory	No

Description of Attribute Ref No of the Entity LoanEmployee

The reference number of the loan.

Entity Attribute Approval Date of the Entity LoanEmployee

Card of Attribute Approval Date of the Entity LoanEmployee

Name	Approval Date
Code	LoanApprovalDate
Data Type	date
Mandatory	No

Description of Attribute Approval Date of the Entity LoanEmployee

Shows the approval date of the loan.
It is in the format: DD-MM-YYYY.

Entity Attribute Effective Date of the Entity LoanEmployee

Card of Attribute Effective Date of the Entity LoanEmployee

Name	Effective Date
Code	LoanEffectiveDate
Data Type	date
Mandatory	No

Description of Attribute Effective Date of the Entity LoanEmployee

Shows the effective date of the loan.
It is in the format: DD-MM-YYYY.

Entity Attribute Expiry Date of the Entity LoanEmployee

Card of Attribute Expiry Date of the Entity LoanEmployee

Name	Expiry Date
Code	LoanExpiryDate
Data Type	date
Mandatory	No

Description of Attribute Expiry Date of the Entity LoanEmployee

Shows the expiry date of the loan.
It is in the format: DD-MM-YYYY.

Entity Attribute No of Months of the Entity LoanEmployee

Card of Attribute No of Months of the Entity LoanEmployee

Name	No of Months
Code	LoanMonths
Data Type	integer
Mandatory	No

Description of Attribute No of Months of the Entity LoanEmployee

Stores the number of months the loan continues.

Entity Attribute Total Loan Amount of the Entity LoanEmployee

Card of Attribute Total Loan Amount of the Entity LoanEmployee

Name	Total Loan Amount
Code	LoanTotalAmt
Data Type	double
Mandatory	No

Description of Attribute Total Loan Amount of the Entity LoanEmployee

Shows the total loan amount.

Entity Attribute Monthly Payment of the Entity LoanEmployee

Card of Attribute Monthly Payment of the Entity LoanEmployee

Name	Monthly Payment
Code	LoanMthPayment
Data Type	double
Mandatory	No

Description of Attribute Monthly Payment of the Entity LoanEmployee

Shows the monthly payment of the loan, only if the user has made an indication that the loan continues after 1 month.

Entity Attribute Pay Element ID of the Entity LoanEmployee

Card of Attribute Pay Element ID of the Entity LoanEmployee

Name	Pay Element ID
Code	LoanPayElementId
Data Type	char(20)
Mandatory	No

Description of Attribute Pay Element ID of the Entity LoanEmployee

Shows the identity of the pay element.
Example:
INCO = Income Tax Deduction / Withheld
NOIL = Notice in Lieu Deductions
NATI = National Service Pay
COMC = Community Chest
etc

Entity Attribute Description of the Entity LoanEmployee

Card of Attribute Description of the Entity LoanEmployee

Name	Description
Code	LoanDesc
Data Type	char(100)
Mandatory	No

Description of Attribute Description of the Entity LoanEmployee

Shows the description of the loan.

Entity Attribute LoanOtherBoolean1 of the Entity LoanEmployee

Card of Attribute LoanOtherBoolean1 of the Entity LoanEmployee

Name	LoanOtherBoolean1
Code	LoanOtherBoolean1
Data Type	smallint
Mandatory	No

Description of Attribute LoanOtherBoolean1 of the Entity LoanEmployee

Shows the loan that is available in a form of a checkbox.

Entity Attribute LoanOtherBoolean2 of the Entity LoanEmployee

Card of Attribute LoanOtherBoolean2 of the Entity LoanEmployee

Name	LoanOtherBoolean2
Code	LoanOtherBoolean2
Data Type	smallint
Mandatory	No

Description of Attribute LoanOtherBoolean2 of the Entity LoanEmployee

Shows the loan that is available in a form of a checkbox.

Entity Attribute LoanOtherBoolean3 of the Entity LoanEmployee

Card of Attribute LoanOtherBoolean3 of the Entity LoanEmployee

Name	LoanOtherBoolean3
Code	LoanOtherBoolean3
Data Type	smallint
Mandatory	No

Description of Attribute LoanOtherBoolean3 of the Entity LoanEmployee

Shows the loan that is available in a form of a checkbox.

Entity Attribute LoanOtherDate1 of the Entity LoanEmployee

Card of Attribute LoanOtherDate1 of the Entity LoanEmployee

Name	LoanOtherDate1
Code	LoanOtherDate1
Data Type	date
Mandatory	No

Description of Attribute LoanOtherDate1 of the Entity LoanEmployee

Shows the date of the loan.

Entity Attribute LoanOtherDate2 of the Entity LoanEmployee

Card of Attribute LoanOtherDate2 of the Entity LoanEmployee

Name	LoanOtherDate2
Code	LoanOtherDate2
Data Type	date
Mandatory	No

Description of Attribute LoanOtherDate2 of the Entity LoanEmployee

Shows the date of the loan.

Entity Attribute LoanOtherDate3 of the Entity LoanEmployee

Card of Attribute LoanOtherDate3 of the Entity LoanEmployee

Name	LoanOtherDate3
Code	LoanOtherDate3
Data Type	date
Mandatory	No

Description of Attribute LoanOtherDate3 of the Entity LoanEmployee

Shows the date of the loan.

Entity Attribute LoanOtherInteger1 of the Entity LoanEmployee

Card of Attribute LoanOtherInteger1 of the Entity LoanEmployee

Name	LoanOtherInteger1
Code	LoanOtherInteger1
Data Type	integer
Mandatory	No

Description of Attribute LoanOtherInteger1 of the Entity LoanEmployee

Shows the loan amount. Only whole numbers are to be entered.

Entity Attribute LoanOtherInteger2 of the Entity LoanEmployee

Card of Attribute LoanOtherInteger2 of the Entity LoanEmployee

Name	LoanOtherInteger2
Code	LoanOtherInteger2
Data Type	integer
Mandatory	No

Description of Attribute LoanOtherInteger2 of the Entity LoanEmployee

Shows the loan amount. Only whole numbers are to be entered.

Entity Attribute LoanOtherInteger3 of the Entity LoanEmployee

Card of Attribute LoanOtherInteger3 of the Entity LoanEmployee

Name	LoanOtherInteger3
Code	LoanOtherInteger3
Data Type	integer
Mandatory	No

Description of Attribute LoanOtherInteger3 of the Entity LoanEmployee

Shows the loan amount. Only whole numbers are to be entered.

Entity Attribute LoanOtherNumeric1 of the Entity LoanEmployee

Card of Attribute LoanOtherNumeric1 of the Entity LoanEmployee

Name	LoanOtherNumeric1
Code	LoanOtherNumeric1
Data Type	double
Mandatory	No

Description of Attribute LoanOtherNumeric1 of the Entity LoanEmployee

Shows the exact loan amount.

Entity Attribute LoanOtherNumeric2 of the Entity LoanEmployee

Card of Attribute LoanOtherNumeric2 of the Entity LoanEmployee

Name	LoanOtherNumeric2
Code	LoanOtherNumeric2
Data Type	double
Mandatory	No

Description of Attribute LoanOtherNumeric2 of the Entity LoanEmployee

Shows the exact loan amount.

Entity Attribute LoanOtherNumeric3 of the Entity LoanEmployee

Card of Attribute LoanOtherNumeric3 of the Entity LoanEmployee

Name	LoanOtherNumeric3
Code	LoanOtherNumeric3
Data Type	double
Mandatory	No

Description of Attribute LoanOtherNumeric3 of the Entity LoanEmployee

Shows the exact loan amount.

Entity Attribute LoanOtherString1 of the Entity LoanEmployee

Card of Attribute LoanOtherString1 of the Entity LoanEmployee

Name	LoanOtherString1
Code	LoanOtherString1
Data Type	char(50)
Mandatory	No

Description of Attribute LoanOtherString1 of the Entity LoanEmployee

Shows the loan amount. String is a data type which includes letters, digits and special characters. It is a sequence of characters.

Entity Attribute LoanOtherString2 of the Entity LoanEmployee

Card of Attribute LoanOtherString2 of the Entity LoanEmployee

Name	LoanOtherString2
Code	LoanOtherString2
Data Type	char(50)
Mandatory	No

Description of Attribute LoanOtherString2 of the Entity LoanEmployee

Shows the loan amount. String is a data type which includes letters, digits and special characters. It is a sequence of characters.

Entity Attribute LoanOtherString3 of the Entity LoanEmployee

Card of Attribute LoanOtherString3 of the Entity LoanEmployee

Name	LoanOtherString3
Code	LoanOtherString3
Data Type	char(50)
Mandatory	No

Description of Attribute LoanOtherString3 of the Entity LoanEmployee

Shows the loan amount. String is a data type which includes letters, digits and special characters. It is a sequence of characters.

Entity Attribute LoanOtherString4 of the Entity LoanEmployee

Card of Attribute LoanOtherString4 of the Entity LoanEmployee

Name	LoanOtherString4
Code	LoanOtherString4
Data Type	char(50)
Mandatory	No

Name	LoanOtherString5
Code	LoanOtherString5
Data Type	char(50)
Mandatory	No

Name	Principal Amount
Code	LoanPrincipalAmt
Data Type	double
Mandatory	No

Name	Interest Amount
Code	LoanInterestAmt
Data Type	double
Mandatory	No

Description of Attribute Interest Amount of the Entity LoanEmployee

Shows the interest amount of the loan.

Home