This table stores identifiers for the different types of specific scenarios that result in notifications. e.g Check SSN validation vs. Employee SSN validation. |
notification_type_KEY | tinyint (1) | NOT NULL | The primary key used for identifying specific scenarios. |
description | nvarchar (200) | NOT NULL | The description of the specific scenario. |
notification_category_type_KEY | tinyint (1) | NOT NULL | Reference to the category of the scenario. |
notification_generalized_type_KEY | tinyint (1) | NOT NULL | Reference to the generalized scenario. This could be SSN validation, but this alone does not uniquely identify the specific scenario as it may pertain to employee SSN or check SSN validation. |