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
NameTypeConstraintsDescription
firm_notification_information_KEYtinyint (1)NOT NULLThe primary key. A child table for other recipients references this.
notification_type_KEYtinyint (1)NOT NULLThe notification type. Corresponds to a scenario that would cause a notification.
parent__notification_type_KEYtinyint (1)If this notification type is a child of another type, the parent type. Used as metadata rather than referencing a specific row.
sequence_numbertinyint (1)NOT NULLSpecifies the order in which the notification scenario is listed.
is_popup_alertbit (1)NOT NULLSpecifies if a pop-up alert should be shown when the scenario occurs.
is_primary_processor_notificationbit (1)NOT NULLSpecifies the primary processor should get a notification.
is_backup_processor_notificationbit (1)NOT NULLSpecifies the backup processor should get a notification.
is_client_notificationbit (1)NOT NULLSpecifies the client should get a notification.
is_other_notificationbit (1)NOT NULLSpecifies the other specified recipients should get a notification.
additional_contacts_notification__selection_scope_KEYint (4)NOT NULLKey of selection scope that specifies which additional contacts should get notifications.
Primary key
NameColumnsDescription
PK_Firm_Notification_Informationfirm_notification_information_KEY
Unique constraints
NameColumnsDescription
UK_Firm_Notification_Information$notification_type_KEYnotification_type_KEY
UK_Firm_Notification_Information$sequence_numbersequence_number
Foreign keys
NameColumnsReferenced tableDescription
FK_Firm_Notification_Information__Notification_Type__notification_type_KEYnotification_type_KEYNotification_Type (notification_type_KEY)
FK_Firm_Notification_Information__Notification_Type__parent__notification_type_KEYparent__notification_type_KEYNotification_Type (notification_type_KEY)
FK_Firm_Notification_Information__Selection_Scope__additional_contacts_notification__selection_scope_KEYadditional_contacts_notification__selection_scope_KEYSelection_Scope (selection_scope_KEY)
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Firm_Notification_Hourly_Pay_Rate__Firm_Notification_Information__firm_notification_information_KEYfirm_notification_information_KEYFirm_Notification_Hourly_Pay_Rate
FK_Firm_Notification_Additional_Contact_Role__Firm_Notification_Information__firm_notification_information_KEYfirm_notification_information_KEYFirm_Notification_Additional_Contact_Role
FK_Firm_Notification_Other_Address__Firm_Notification_Information__firm_notification_information_KEYfirm_notification_information_KEYFirm_Notification_Other_Address

Schema diagram