Sage EasyPay Data Model

Entity AlertGroupItem

Description of Entity AlertGroupItem

A setup for the alert group item. Have attributes such as 'Actual date', 'Start day', 'End month', parameters for customisation and many more.
Example: A person checking a list of birthdays and then writing well-wishes on a birthday card before posting it to employees. Alert Group Item is the list of birthday that would be the criteria.

List of all Dependencies of the Entity AlertGroupItem

Relation_593983

Relation_593983

Reference

Relation_608695

Relation_608695

Reference

Reference

List of Attributes of the Entity AlertGroupItem

Entity Attribute AlertGroupItemSysId of the Entity AlertGroupItem

Card of Attribute AlertGroupItemSysId of the Entity AlertGroupItem

Name	AlertGroupItemSysId
Code	AlertGroupItemSysId
Data Type	integer
Mandatory	Yes

Description of Attribute AlertGroupItemSysId of the Entity AlertGroupItem

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

Entity Attribute Alert Group ID of the Entity AlertGroupItem

Card of Attribute Alert Group ID of the Entity AlertGroupItem

Name	Alert Group ID
Code	AlertGroupAlertFieldId
Data Type	char(20)
Mandatory	No

Description of Attribute Alert Group ID of the Entity AlertGroupItem

Shows the identity of the alert.

Entity Attribute Filter By > All of the Entity AlertGroupItem

Card of Attribute Filter By > All of the Entity AlertGroupItem

Name	Filter By > All
Code	AlertFilterBy
Data Type	smallint
Mandatory	No

Description of Attribute Filter By > All of the Entity AlertGroupItem

Shows how the alert is filtered.

Entity Attribute Filter By > Query ID of the Entity AlertGroupItem

Card of Attribute Filter By > Query ID of the Entity AlertGroupItem

Name	Filter By > Query ID
Code	AlertFilterByQueryId
Data Type	char(20)
Mandatory	No

Description of Attribute Filter By > Query ID of the Entity AlertGroupItem

Shows the identity of the alert being filtered by a query.

Entity Attribute Alert Before of the Entity AlertGroupItem

Card of Attribute Alert Before of the Entity AlertGroupItem

Name	Alert Before
Code	AlertBefore
Data Type	integer
Mandatory	No

Description of Attribute Alert Before of the Entity AlertGroupItem

Shows when the alert should appear.
Example: Before accessing the module / a date / time etc

Entity Attribute Alert Before Unit of the Entity AlertGroupItem

Card of Attribute Alert Before Unit of the Entity AlertGroupItem

Name	Alert Before Unit
Code	AlertBeforeUnit
Data Type	char(20)
Mandatory	No

Description of Attribute Alert Before Unit of the Entity AlertGroupItem

Records the unit of the before alert.

Entity Attribute Alert After of the Entity AlertGroupItem

Card of Attribute Alert After of the Entity AlertGroupItem

Name	Alert After
Code	AlertAfter
Data Type	integer
Mandatory	No

Description of Attribute Alert After of the Entity AlertGroupItem

Shows when the alert should appear.
Example: After accessing the module / a date / time etc

Entity Attribute Alert After Unit of the Entity AlertGroupItem

Card of Attribute Alert After Unit of the Entity AlertGroupItem

Name	Alert After Unit
Code	AlertAfterUnit
Data Type	char(20)
Mandatory	No

Description of Attribute Alert After Unit of the Entity AlertGroupItem

Records the unit of the after alert.

Entity Attribute Alert Actual Date of the Entity AlertGroupItem

Card of Attribute Alert Actual Date of the Entity AlertGroupItem

Name	Alert Actual Date
Code	AlertActualDate
Data Type	smallint
Mandatory	No

Description of Attribute Alert Actual Date of the Entity AlertGroupItem

Stores the actual date of when the alert should appear.

Entity Attribute Day From of the Entity AlertGroupItem

Card of Attribute Day From of the Entity AlertGroupItem

Name	Day From
Code	AlertStartDay
Data Type	integer
Mandatory	No

Description of Attribute Day From of the Entity AlertGroupItem

Shows the start day of the alert.

Entity Attribute Month From of the Entity AlertGroupItem

Card of Attribute Month From of the Entity AlertGroupItem

Name	Month From
Code	AlertStartMth
Data Type	char(20)
Mandatory	No

Description of Attribute Month From of the Entity AlertGroupItem

Shows the start month of the alert.

Entity Attribute Day To of the Entity AlertGroupItem

Card of Attribute Day To of the Entity AlertGroupItem

Name	Day To
Code	AlertEndDay
Data Type	integer
Mandatory	No

Description of Attribute Day To of the Entity AlertGroupItem

Shows the last day of the alert.

Entity Attribute Month To of the Entity AlertGroupItem

Card of Attribute Month To of the Entity AlertGroupItem

Name	Month To
Code	AlertEndMth
Data Type	char(20)
Mandatory	No

Description of Attribute Month To of the Entity AlertGroupItem

Shows the last month of the alert.

Entity Attribute Has Attachment of the Entity AlertGroupItem

Card of Attribute Has Attachment of the Entity AlertGroupItem

Name	Has Attachment
Code	AlertHasAttachment
Data Type	smallint
Mandatory	No

Description of Attribute Has Attachment of the Entity AlertGroupItem

Indicates that the alert has an attachment, in a form of a checkbox.

Entity Attribute AlertParameter1 of the Entity AlertGroupItem

Card of Attribute AlertParameter1 of the Entity AlertGroupItem

Name	AlertParameter1
Code	AlertParameter1
Data Type	char(250)
Mandatory	No

Description of Attribute AlertParameter1 of the Entity AlertGroupItem

A parameter for the alert.

Entity Attribute AlertParameter2 of the Entity AlertGroupItem

Card of Attribute AlertParameter2 of the Entity AlertGroupItem

Name	AlertParameter2
Code	AlertParameter2
Data Type	char(250)
Mandatory	No

Description of Attribute AlertParameter2 of the Entity AlertGroupItem

A parameter for the alert.

Entity Attribute AlertParameter3 of the Entity AlertGroupItem

Card of Attribute AlertParameter3 of the Entity AlertGroupItem

Name	AlertParameter3
Code	AlertParameter3
Data Type	char(250)
Mandatory	No

Description of Attribute AlertParameter3 of the Entity AlertGroupItem

A parameter for the alert.

Entity Attribute AlertParameter4 of the Entity AlertGroupItem

Card of Attribute AlertParameter4 of the Entity AlertGroupItem

Name	AlertParameter4
Code	AlertParameter4
Data Type	char(250)
Mandatory	No

Description of Attribute AlertParameter4 of the Entity AlertGroupItem

A parameter for the alert.

Entity Attribute AlertParameter5 of the Entity AlertGroupItem

Card of Attribute AlertParameter5 of the Entity AlertGroupItem

Name	AlertParameter5
Code	AlertParameter5
Data Type	char(250)
Mandatory	No

Description of Attribute AlertParameter5 of the Entity AlertGroupItem

A parameter for the alert.