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 |

Foreign keys
Name | Columns | Referenced table | Description
FK_Firm_Notification_Information__Notification_Type__notification_type_KEY | notification_type_KEY | Notification_Type (notification_type_KEY) |
FK_Firm_Notification_Information__Notification_Type__parent__notification_type_KEY | parent__notification_type_KEY | Notification_Type (notification_type_KEY) |
FK_Firm_Notification_Information__Selection_Scope__additional_contacts_notification__selection_scope_KEY | additional_contacts_notification__selection_scope_KEY | Selection_Scope (selection_scope_KEY) |

Incoming foreign keys
Name | Columns | Referencing table | Description
FK_Firm_Notification_Hourly_Pay_Rate__Firm_Notification_Information__firm_notification_information_KEY | firm_notification_information_KEY | Firm_Notification_Hourly_Pay_Rate |
FK_Firm_Notification_Additional_Contact_Role__Firm_Notification_Information__firm_notification_information_KEY | firm_notification_information_KEY | Firm_Notification_Additional_Contact_Role |
FK_Firm_Notification_Other_Address__Firm_Notification_Information__firm_notification_information_KEY | firm_notification_information_KEY | Firm_Notification_Other_Address |