Entity AlertField

Description of Entity AlertField

A field alert for the statements.


List of all Dependencies of the Entity AlertField

Name

Code

Class Name

Relation_616149

Relation_616149

Reference


List of Attributes of the Entity AlertField

Name

Code

SysTableId

SysTableId

SysAttributeId

SysAttributeId

Alert Field ID

AlertFieldId

Alert Join

AlertJoin

Alert Join Condition

AlertJoinCondition

Alert Condition

AlertCondition

Alert Ordering

AlertOrdering

Alert Key Field

AlertKeyField

Alert Adhoc Field

AlertAdhocField

Alert Full Date

AlertFullDate


Entity Attribute SysTableId of the Entity AlertField

Card of Attribute SysTableId of the Entity AlertField

Name

SysTableId

Code

SysTableId

Data Type

char(100)

Mandatory

Yes


Description of Attribute SysTableId of the Entity AlertField

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 SysAttributeId of the Entity AlertField

Card of Attribute SysAttributeId of the Entity AlertField

Name

SysAttributeId

Code

SysAttributeId

Data Type

char(100)

Mandatory

Yes


Description of Attribute SysAttributeId of the Entity AlertField

Shows the identity of the system attribute. It is the primary key for the SystemAttribute table.
Example: AdjType / AlertIsSummarized / AllowanceSGSPGenId etc


Entity Attribute Alert Field ID of the Entity AlertField

Card of Attribute Alert Field ID of the Entity AlertField

Name

Alert Field ID

Code

AlertFieldId

Data Type

char(20)

Mandatory

Yes


Description of Attribute Alert Field ID of the Entity AlertField

Shows the identity of the alert field. This is also the primary key for the AlertField table.
Example: AlertBirthday / AlertInterviewDate / AlertCessationDate etc


Entity Attribute Alert Join of the Entity AlertField

Card of Attribute Alert Join of the Entity AlertField

Name

Alert Join

Code

AlertJoin

Data Type

char(250)

Mandatory

No


Description of Attribute Alert Join of the Entity AlertField

Shows the Join statement for the alert.
Example:
Join (Applicant Join Personal On Applicant.PersonalSysId = Personal.PersonalSysId)
Join Personal
etc


Entity Attribute Alert Join Condition of the Entity AlertField

Card of Attribute Alert Join Condition of the Entity AlertField

Name

Alert Join Condition

Code

AlertJoinCondition

Data Type

char(250)

Mandatory

No


Description of Attribute Alert Join Condition of the Entity AlertField

Shows the join condition for the alert.


Entity Attribute Alert Condition of the Entity AlertField

Card of Attribute Alert Condition of the Entity AlertField

Name

Alert Condition

Code

AlertCondition

Data Type

char(250)

Mandatory

No


Description of Attribute Alert Condition of the Entity AlertField

Shows the condition for the alert.


Entity Attribute Alert Ordering of the Entity AlertField

Card of Attribute Alert Ordering of the Entity AlertField

Name

Alert Ordering

Code

AlertOrdering

Data Type

char(250)

Mandatory

No


Description of Attribute Alert Ordering of the Entity AlertField

Shows the order of the alert.
Example: Order By Personal.IdentityNo etc


Entity Attribute Alert Key Field of the Entity AlertField

Card of Attribute Alert Key Field of the Entity AlertField

Name

Alert Key Field

Code

AlertKeyField

Data Type

char(50)

Mandatory

No


Description of Attribute Alert Key Field of the Entity AlertField

Shows the key field for the alert.
Example: PersonalSysId / Applicant.PersonalSysId / EmployeeSysId etc


Entity Attribute Alert Adhoc Field of the Entity AlertField

Card of Attribute Alert Adhoc Field of the Entity AlertField

Name

Alert Adhoc Field

Code

AlertAdhocField

Data Type

char(50)

Mandatory

No


Description of Attribute Alert Adhoc Field of the Entity AlertField

Shows the adhoc field for the alert.
Example: Personal.PersonalSysId / Employee.EmployeeSysId etc


Entity Attribute Alert Full Date of the Entity AlertField

Card of Attribute Alert Full Date of the Entity AlertField

Name

Alert Full Date

Code

AlertFullDate

Data Type

smallint

Mandatory

No


Description of Attribute Alert Full Date of the Entity AlertField

Indicates the full date for the alert, in a form of a checkbox.