vr_Notification

Field NameField DescriptionData TypeFK Join
ActiveIndicates if the Record is Active or Notbit 
CCCarbon Copy email addressnvarchar 
CommentCommentsnvarchar 
CreatedDateRecord Creation Datedatetime 
CreatorIdUser Id (Record Creator)intvr_users
EmailNoteEmail Notenvarchar 
EmailShopIndicates if this notification will be emailed to the shopbit 
EmailTechnicianIndicates if this notification will be emailed to the technicianbit 
EmailTradeIndicates if this notification will be emailed to the tradebit 
EndActionEnd Actionint 
EscalateWorkNotDoneIndicates if this notification will escalate work not donebit 
EscalationPriorityCodeEscalation Priority Codenvarchar 
EscalationPriorityDescriptionEscalation Priority Descriptionnvarchar 
EscalationPriorityIdEscalation Priority Idintvr_Priority
ExpirationTimeExpiration Timeint 
GroupingAdditionalInfoGrouping Additional Informationbit 
GroupingLocationCodeGrouping Location Codenvarchar 
GroupingLocationIdGrouping Location Idint 
GroupingLocationNameGrouping Location Namenvarchar 
GroupingLocationTypeGrouping Location Typesmallint 
GroupingNumberGrouping Numberint 
GroupingOperatorGrouping Operatornvarchar 
GroupingPercentageGrouping Percentagedecimal 
IdNotification Idint 
IntervalIdInterval Idint 
IsGroupIndicates if this notification is tied to a groupbit 
ItemTypeIdItem Type Idint 
ItemTypeNameItem Type Namenvarchar 
ModifiedDateLast Modified Datedatetime 
ModifierIdUser Id (Record Modifier)intvr_users
NotificationTypeNotification Typevarchar 
PriorityCodePriority Codenvarchar 
PriorityDescriptionPriority Descriptionnvarchar 
PriorityIdPriority Idintvr_Priority
RepairCenterCodeRepair Center Codenvarchar 
RepairCenterIdRepair Center Idintvr_RepairCenter
RepairCenterNameRepair Center Namenvarchar 
RequireAcknowledgementIndicates if this notification requires acknowledgementbit 
SourceSourcenvarchar 
StartRangeStart Rangeint 
TaskCodeTask Codenvarchar 
TaskIdTask Idintvrpt_Task
TaskSelectionTask Selectionint 
TaskTypeCodeTask Type Codenvarchar 
TaskTypeIdTask Type Idintvr_TaskType
TimeSensitiveIndicates if this notification is time sensitivebit 
WorkOrderTypeCodeWork Order Type Codenvarchar 
WorkOrderTypeDescriptionWork Order Type Descriptionnvarchar 
WorkOrderTypeIdWork Order Type Idintvr_WorkOrderType
Was this article helpful?
0 out of 0 found this helpful

Articles in this section

See more
Announcing WebTMA + Workday Integration
To Learn More, Click Here!
2026 Webinar Training Schedule - Register now!
See the full list of web training events.
TMA Systems - TMA Connect 2026 Registration
Register Now by clicking here!