Description
Contains detailed information on escalation rules.
Dependencies
Columns
ApplyOrder : int, allows null: no
The order in which to apply the rule.
CreateUserId : int, allows null: yes
The ID of the user who created the item.
DateCreated : datetime, allows null: yes
The date and time when the item was created.
The stored date and time are based on the server’s time zone. For more information, see Date and Time Fields.
DateUpdated : datetime, allows null: yes
The date and time the item was last updated.
The stored date and time are based on the server’s time zone. For more information, see Date and Time Fields.
Description : varchar (max), allows null: yes
The description of the rule.
Duration : int, allows null: no
The duration to wait for the rule to fire.
DurationUnits : varchar (max 50 chars), allows null: no
The time measurement for the duration (minutes, hours, days, weeks, months, or years).
EmailSubject : varchar (max 255 chars), allows null: yes
The subject of the email that the rule generates.
EntityCode : varchar (max 100 chars), allows null: no
The module where the rule is used.
You can find correspondences between entity code values and related modules and features in Table of Entity Code Values.
FilterId : int, allows null: yes
The ID of the filter that is used as a criterion to activate the rule.
FromName : varchar (max 100 chars), allows null: yes
The email address from which the rule sends the generated message.
IsActive : varchar (max 1 char), allows null: no
Indicates whether the escalation rule is active.
NotifyEmails : varchar (max), allows null: yes
The email address for notifications generated by the rule. [OwnerName] and [AssignedToName] correspond to the email address of the item owner and of the user to whom the item is assigned.
OwnerName : varchar (max 78 chars), allows null: yes
The name of the user who created the rule, in the Last name, First name format.
ProjId : int, allows null: no
The ID of the project that contains the rule.
RuleId : int, allows null: no
The unique identifier of the escalation rule.
Status : varchar (max 100 chars), allows null: no
The status of the rule.
TemplateId : int, allows null: yes
The ID of the email template that is used in the rule.
TemplateName : varchar (max 100 chars), allows null: no
The name of the template.
Title : varchar (max 100 chars), allows null: no
The title of the escalation rule.
UpdateUserId : int, allows null: yes
The ID of the user who last updated the item.
UserName : varchar (max 78 chars), allows null: yes
The name of the user who last updated the rule, in the Last name, First name format.
This is a helper table that stores information on departments.