vr_Notification

Updated November 26, 2025 17:28

Field Name	Field Description	Data Type	FK Join
Active	Indicates if the Record is Active or Not	bit
CC	Carbon Copy email address	nvarchar
Comment	Comments	nvarchar
CreatedDate	Record Creation Date	datetime
CreatorId	User Id (Record Creator)	int	vr_users
EmailNote	Email Note	nvarchar
EmailShop	Indicates if this notification will be emailed to the shop	bit
EmailTechnician	Indicates if this notification will be emailed to the technician	bit
EmailTrade	Indicates if this notification will be emailed to the trade	bit
EndAction	End Action	int
EscalateWorkNotDone	Indicates if this notification will escalate work not done	bit
EscalationPriorityCode	Escalation Priority Code	nvarchar
EscalationPriorityDescription	Escalation Priority Description	nvarchar
EscalationPriorityId	Escalation Priority Id	int	vr_Priority
ExpirationTime	Expiration Time	int
GroupingAdditionalInfo	Grouping Additional Information	bit
GroupingLocationCode	Grouping Location Code	nvarchar
GroupingLocationId	Grouping Location Id	int
GroupingLocationName	Grouping Location Name	nvarchar
GroupingLocationType	Grouping Location Type	smallint
GroupingNumber	Grouping Number	int
GroupingOperator	Grouping Operator	nvarchar
GroupingPercentage	Grouping Percentage	decimal
Id	Notification Id	int
IntervalId	Interval Id	int
IsGroup	Indicates if this notification is tied to a group	bit
ItemTypeId	Item Type Id	int
ItemTypeName	Item Type Name	nvarchar
ModifiedDate	Last Modified Date	datetime
ModifierId	User Id (Record Modifier)	int	vr_users
NotificationType	Notification Type	varchar
PriorityCode	Priority Code	nvarchar
PriorityDescription	Priority Description	nvarchar
PriorityId	Priority Id	int	vr_Priority
RepairCenterCode	Repair Center Code	nvarchar
RepairCenterId	Repair Center Id	int	vr_RepairCenter
RepairCenterName	Repair Center Name	nvarchar
RequireAcknowledgement	Indicates if this notification requires acknowledgement	bit
Source	Source	nvarchar
StartRange	Start Range	int
TaskCode	Task Code	nvarchar
TaskId	Task Id	int	vrpt_Task
TaskSelection	Task Selection	int
TaskTypeCode	Task Type Code	nvarchar
TaskTypeId	Task Type Id	int	vr_TaskType
TimeSensitive	Indicates if this notification is time sensitive	bit
WorkOrderTypeCode	Work Order Type Code	nvarchar
WorkOrderTypeDescription	Work Order Type Description	nvarchar
WorkOrderTypeId	Work Order Type Id	int	vr_WorkOrderType

Articles in this section