Sage EasyPay Data Model

Entity TMSAllowance

Description of Entity TMSAllowance

This entity shows the allowance for the Time Management System.

List of all Dependencies of the Entity TMSAllowance

Relation_1646390

Reference

Relation_1646393

Reference

List of Attributes of the Entity TMSAllowance

Entity Attribute Formula ID of the Entity TMSAllowance

Card of Attribute Formula ID of the Entity TMSAllowance

Name	Formula ID
Code	FormulaId
Data Type	char(20)
Mandatory	No

Description of Attribute Formula ID of the Entity TMSAllowance

Shows the formula on what leave / deduction / allowance etc, the employee has taken. This is the primary key for the Formula table.
Example: ANL (Annual leave) / Deduction of Sick leave / HOL (Paid Holiday)

Entity Attribute TMSAllowanceSysId of the Entity TMSAllowance

Card of Attribute TMSAllowanceSysId of the Entity TMSAllowance

Name	TMSAllowanceSysId
Code	TMSAllowanceSysId
Data Type	integer
Mandatory	Yes

Description of Attribute TMSAllowanceSysId of the Entity TMSAllowance

A system generated identity. It is blind to the user. It also acts as a primary key for the TMSAllowance table.

Entity Attribute Remarks of the Entity TMSAllowance

Card of Attribute Remarks of the Entity TMSAllowance

Name	Remarks
Code	AllowanceRemarks
Data Type	char(100)
Mandatory	No

Description of Attribute Remarks of the Entity TMSAllowance

Stores any remarks.

Entity Attribute Declared Date of the Entity TMSAllowance

Card of Attribute Declared Date of the Entity TMSAllowance

Name	Declared Date
Code	AllowanceDeclaredDate
Data Type	date
Mandatory	No

Description of Attribute Declared Date of the Entity TMSAllowance

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

Entity Attribute UserDef1Value of the Entity TMSAllowance

Card of Attribute UserDef1Value of the Entity TMSAllowance

Name	UserDef1Value
Code	UserDef1Value
Data Type	double
Mandatory	No

Description of Attribute UserDef1Value of the Entity TMSAllowance

Shows the first user defined parameter value. The values for these user-defined fields will not be extracted from the system but to be entered by the user during pay record processing when the code is selected.

Entity Attribute UserDef2Value of the Entity TMSAllowance

Card of Attribute UserDef2Value of the Entity TMSAllowance

Name	UserDef2Value
Code	UserDef2Value
Data Type	double
Mandatory	No

Description of Attribute UserDef2Value of the Entity TMSAllowance

Shows the second user defined parameter value. The values for these user-defined fields will not be extracted from the system but to be entered by the user during pay record processing when the code is selected.

Entity Attribute UserDef3Value of the Entity TMSAllowance

Card of Attribute UserDef3Value of the Entity TMSAllowance

Name	UserDef3Value
Code	UserDef3Value
Data Type	double
Mandatory	No

Description of Attribute UserDef3Value of the Entity TMSAllowance

Shows the third user defined parameter value. The values for these user-defined fields will not be extracted from the system but to be entered by the user during pay record processing when the code is selected.

Entity Attribute UserDef4Value of the Entity TMSAllowance

Card of Attribute UserDef4Value of the Entity TMSAllowance

Name	UserDef4Value
Code	UserDef4Value
Data Type	double
Mandatory	No

Description of Attribute UserDef4Value of the Entity TMSAllowance

Shows the forth user defined parameter value. The values for these user-defined fields will not be extracted from the system but to be entered by the user during pay record processing when the code is selected.

Entity Attribute UserDef5Value of the Entity TMSAllowance

Card of Attribute UserDef5Value of the Entity TMSAllowance

Name	UserDef5Value
Code	UserDef5Value
Data Type	double
Mandatory	No

Name	Costing Amount
Code	CostingAmount
Data Type	double
Mandatory	No

Description of Attribute Costing Amount of the Entity TMSAllowance

Shows the costing amount for the Time Management System.

Home