Notifications
Stores notification events that inform users of system changes, assignments, or activity updates. This table supports engagement awareness and timely workflow participation.
Columns
| Name | Type | ReadOnly | Description |
| Assigned_User_Id | String | False |
The identifier (Id) of the user who is assigned to the notification record. This assignment determines who receives or is responsible for the notification. |
| Assigned_User_Name | String | True |
The display name of the user who is assigned to the notification. |
| Created_By | String | True |
The Id of the user who created the notification record. This information is used for auditing and historical tracking. |
| Created_By_Name | String | True |
The display name of the user who created the notification record. |
| Date_Entered | Datetime | True |
The date and time when the notification record was created. |
| Date_Modified | Datetime | True |
The date and time when the notification record was last modified. |
| Deleted | Bool | False |
A Boolean field that returns a value of 'true' when the notification record is flagged as deleted. It returns a value of 'false' when the record remains active. This field supports soft-delete behavior. |
| Description | String | True |
A detailed text description that provides additional context about the notification or the event that triggered it. |
| Following | Bool | False |
A Boolean field that returns a value of 'true' when the current user is following the notification record. It returns a value of 'false' when the user is not following it. Following enables activity tracking and feed updates. |
| Id [KEY] | String | True |
The unique Id of the notification record. |
| Is_Read | Bool | False |
A Boolean field that returns a value of 'true' when the notification has been marked as read. It returns a value of 'false' when the notification remains unread. This field allows users to manage attention and workflow priorities. |
| Locked_Fields | String | True |
A system-managed list of fields that are restricted from modification to preserve data integrity. |
| Modified_By_Name | String | True |
The display name of the user who last modified the notification record. |
| Modified_User_Id | String | True |
The Id of the user who last modified the notification record. This information is used for audit trails and historical change tracking. |
| My_Favorite | Bool | False |
A Boolean field that returns a value of 'true' when the notification is marked as a favorite by the current user. It returns a value of 'false' when it is not marked as a favorite. |
| Name | String | False |
The display name or label that identifies the notification in list and record views. |
| Parent_Id | String | False |
The Id of the parent record that the notification references. This linkage associates the notification with a specific record in another SugarCRM module. |
| Parent_Name | String | True |
The display name of the parent record that the notification references. |
| Parent_Type | String | True |
The name of the SugarCRM module that the notification is associated with (for example, 'Accounts', 'Contacts', or 'Cases'). This value indicates the context of the event that triggered the notification. |
| Severity | String | False |
The severity level of the notification (for example, 'information', 'warning', or 'alert'). This value indicates the urgency or type of response required. |
| Sync_Key | String | True |
An internal synchronization key that is used to reconcile notification records across systems and integrations. |