Table: dbo.Firm_Notification_Information | |||
This table stores firm level settings related to what types of alerts and notifications should be provided for various scenarios. | |||
Columns | |||
Name | Type | Constraints | Description |
firm_notification_information_KEY | tinyint (1) | NOT NULL | The primary key. A child table for other recipients references this. |
notification_type_KEY | tinyint (1) | NOT NULL | The notification type. Corresponds to a scenario that would cause a notification. |
parent__notification_type_KEY | tinyint (1) | If this notification type is a child of another type, the parent type. Used as metadata rather than referencing a specific row. | |
sequence_number | tinyint (1) | NOT NULL | Specifies the order in which the notification scenario is listed. |
is_popup_alert | bit (1) | NOT NULL | Specifies if a pop-up alert should be shown when the scenario occurs. |
is_primary_processor_notification | bit (1) | NOT NULL | Specifies the primary processor should get a notification. |
is_backup_processor_notification | bit (1) | NOT NULL | Specifies the backup processor should get a notification. |
is_client_notification | bit (1) | NOT NULL | Specifies the client should get a notification. |
is_other_notification | bit (1) | NOT NULL | Specifies the other specified recipients should get a notification. |
additional_contacts_notification__selection_scope_KEY | int (4) | NOT NULL | Key of selection scope that specifies which additional contacts should get notifications. |
Primary key | |||
Name | Columns | Description | |
PK_Firm_Notification_Information | firm_notification_information_KEY | ||
Unique constraints | |||
Name | Columns | Description | |
UK_Firm_Notification_Information$notification_type_KEY | notification_type_KEY | ||
UK_Firm_Notification_Information$sequence_number | sequence_number |