Sage EasyPay Data Model

Shows the identity of the reminder function. It also acts as primary key for the RemFunction table.
Example: HRInterview / LvHoliday / PayEPExpiry etc

Entity Attribute IsCustomised of the Entity RemFunction

Card of Attribute IsCustomised of the Entity RemFunction

Name	IsCustomised
Code	IsCustomised
Data Type	smallint
Mandatory	No

Description of Attribute IsCustomised of the Entity RemFunction

Shows if the reminder is customised or chosen from the default options.

Entity Attribute DllName of the Entity RemFunction

Card of Attribute DllName of the Entity RemFunction

Name	DllName
Code	DllName
Data Type	char(100)
Mandatory	No

Description of Attribute DllName of the Entity RemFunction

The Dynamic Link Library (dll) name, also the file extension name.
Example: SingaporeLaserPayslip.dll

Entity Attribute Function Message of the Entity RemFunction

Card of Attribute Function Message of the Entity RemFunction

Name	Function Message
Code	FuncMessage
Data Type	char(255)
Mandatory	No

Description of Attribute Function Message of the Entity RemFunction

Shows the function message of the reminder.
Example:
HR - Recruitment - Interview Date
Leave - Calendar - Holiday Date
Pay - EP Progression - Expiry Date
etc

Entity Attribute Sys Date Table ID of the Entity RemFunction

Card of Attribute Sys Date Table ID of the Entity RemFunction

Name	Sys Date Table ID
Code	SysDateTableID
Data Type	char(100)
Mandatory	No

Description of Attribute Sys Date Table ID of the Entity RemFunction

The identity of the table in the system.
Example: InterviewSchedule / Holidays / EmployPassProgression etc

Entity Attribute Sys Date Attribute ID of the Entity RemFunction

Card of Attribute Sys Date Attribute ID of the Entity RemFunction

Name	Sys Date Attribute ID
Code	SysDateAttributeID
Data Type	char(100)
Mandatory	No

Name	SysDateSqlJoin
Code	SysDateSqlJoin
Data Type	char(255)
Mandatory	No

Name	SysDateSqlCond
Code	SysDateSqlCond
Data Type	char(255)
Mandatory	No

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Description of Attribute FuncKeyword5 of the Entity RemFunction

Shows the fifth function keyword.

Home