Sage EasyPay Data Model

Entity AlertGroup

Description of Entity AlertGroup

This entity is for setting up alert notifications. The system date will be compared with this date to trigger an event. Some types of information are derived values.
Example: A person checking a list of birthdays and then writing well-wishes on a birthday card before posting it to employees. Alert Group is the checking part which is equivalent to the scheduled run.

List of all Dependencies of the Entity AlertGroup

Reference

List of Attributes of the Entity AlertGroup

Summary Listing

AlertIsSummarized

Entity Attribute Alert Group ID of the Entity AlertGroup

Card of Attribute Alert Group ID of the Entity AlertGroup

Name	Alert Group ID
Code	AlertGroupId
Data Type	char(20)
Mandatory	Yes

Description of Attribute Alert Group ID of the Entity AlertGroup

Shows the identity of the alert group. This is the primary key for the AlertGroup table.

Entity Attribute Runs of the Entity AlertGroup

Card of Attribute Runs of the Entity AlertGroup

Name	Runs
Code	AlertRuns
Data Type	char(20)
Mandatory	No

Description of Attribute Runs of the Entity AlertGroup

Shows when the alert will run.
Example: Daily / Tuesday / Monthly etc

Entity Attribute Alert Month of the Entity AlertGroup

Card of Attribute Alert Month of the Entity AlertGroup

Name	Alert Month
Code	AlertRunMonth
Data Type	integer
Mandatory	No

Description of Attribute Alert Month of the Entity AlertGroup

Shows the alert month for the alert group.

Entity Attribute Alert Day of the Entity AlertGroup

Card of Attribute Alert Day of the Entity AlertGroup

Name	Alert Day
Code	AlertRunDay
Data Type	integer
Mandatory	No

Description of Attribute Alert Day of the Entity AlertGroup

Shows the alert day for the alert group.

Entity Attribute Summary Listing of the Entity AlertGroup

Card of Attribute Summary Listing of the Entity AlertGroup

Name	Summary Listing
Code	AlertIsSummarized
Data Type	smallint
Mandatory	No

Description of Attribute Summary Listing of the Entity AlertGroup

A summary listing for the alert, in a form of a checkbox.

Entity Attribute Active of the Entity AlertGroup

Card of Attribute Active of the Entity AlertGroup

Name	Active
Code	AlertIsActive
Data Type	smallint
Mandatory	No

Description of Attribute Active of the Entity AlertGroup

Shows if the alert is active, in a form of a checkbox.

Entity Attribute Description of the Entity AlertGroup

Card of Attribute Description of the Entity AlertGroup

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

Description of Attribute Description of the Entity AlertGroup

Stores the description for the alert.