Sage EasyPay Data Model

Entity SystemTable

Description of Entity SystemTable

Details about the modules and sub modules.

List of all Dependencies of the Entity SystemTable

Relation_616130

Relation_616130

Reference

Relation_616140

Relation_616140

Reference

List of Attributes of the Entity SystemTable

Entity Attribute SysTableId of the Entity SystemTable

Card of Attribute SysTableId of the Entity SystemTable

Name	SysTableId
Code	SysTableId
Data Type	char(100)
Mandatory	Yes

Description of Attribute SysTableId of the Entity SystemTable

Shows the identity of the system table. It is also the primary key for the SystemTable entity.
Example: Country / Leave Policy / TMSShift etc

Entity Attribute SysTableDesc of the Entity SystemTable

Card of Attribute SysTableDesc of the Entity SystemTable

Name	SysTableDesc
Code	SysTableDesc
Data Type	char(200)
Mandatory	No

Description of Attribute SysTableDesc of the Entity SystemTable

Stores a description about the system table.
Example: Country / Leave Policy / TS Shift etc

Entity Attribute WageSensitive of the Entity SystemTable

Card of Attribute WageSensitive of the Entity SystemTable

Name	WageSensitive
Code	WageSensitive
Data Type	smallint
Mandatory	No

Description of Attribute WageSensitive of the Entity SystemTable

Indicates if it is wage sensitive, in a form of a checkbox.

Entity Attribute SysModule of the Entity SystemTable

Card of Attribute SysModule of the Entity SystemTable

Name	SysModule
Code	SysModule
Data Type	char(30)
Mandatory	No

Description of Attribute SysModule of the Entity SystemTable

Shows which module it belongs to.
Example: Core / CoreLeave / CorePay etc

Entity Attribute SysSubModule of the Entity SystemTable

Card of Attribute SysSubModule of the Entity SystemTable

Name	SysSubModule
Code	SysSubModule
Data Type	char(30)
Mandatory	No

Description of Attribute SysSubModule of the Entity SystemTable

Shows the sub module for the system table.
Example: Course / Leave Setup / Time Sheet etc