Notification Dataset Specification

The Notification Dataset Specification is a comprehensive dataset designed to manage and track notifications within the system. It includes multiple tables that capture detailed information about notifications, their sources, targets, and associated tasks. The dataset is structured to support efficient notification management, ensuring that all relevant details are recorded and accessible for analysis and reporting.

Each notification contains metadata such as unique identifiers, timestamps, source and target details, urgency indicators, and related actions or tasks. The dataset helps in monitoring notifications generated from various sources, both internal and external, and it facilitates the management of associated tasks, user interactions, and follow-up actions.

This dataset also includes details about the origin of the notification (source), the intended recipient (target), and additional operational parameters like program IDs, request details, user responsibilities, and system partitions. Its structure supports auditing, filtering, and prioritization of notifications, ensuring efficient workflow management and timely responses to important events.

Key Features of the Dataset

Notification Details: Information about the notification itself, including unique identifiers, titles, text content, urgency, and timestamps for creation and modification.
Source Information: Details about the origin of the notification, including source type, description, and related assessment responses.
Target Information: Information about the intended recipients or targets of the notification, including target type, program codes, and request identifiers.
Ownership and Task Management: Data on the departments and users responsible for the notifications, as well as associated tasks and their statuses.
Metadata: Additional metadata such as schema version, source system details, and indicators for deletion and active versions.

This dataset is essential for maintaining a robust notification system, enabling efficient tracking, management, and analysis of notifications within the environment.

Notification Table

Columns

Column Name	Is Nullable	Data Type	Description
Notification_Processing_Key	YES	STRING	The key used for processing the notification.
Member_ID	YES	STRING	The unique identifier for the member associated with the notification.
Title	YES	STRING	The title of the notification.
Text	YES	STRING	The text content of the notification.
Source_Type_Key	YES	INT64	The key identifying the source type of the notification.
Source_Type	YES	STRING	The type of source from which the notification originated.
Source_Type_Description	YES	STRING	A detailed description of the source type.
Source_ID	YES	STRING	The unique identifier for the source of the notification.
Assessment_Response_Question_ID	YES	STRING	The ID of the assessment response question related to the notification.
Assessment_Response_Score_ID	YES	STRING	The ID of the assessment response score related to the notification.
Target_Type_Key	YES	INT64	The key identifying the target type of the notification.
Target_Type	YES	STRING	The type of target for the notification.
Target_Type_Description	YES	STRING	A detailed description of the target type.
Target_Code	YES	STRING	The code representing the target of the notification.
Target_ID	YES	STRING	The unique identifier for the target of the notification.
Target_Key	YES	STRING	The key associated with the target of the notification.
Owner_Department_ID	YES	STRING	The ID of the department owning the notification.
Owner_Department_Name	YES	STRING	The name of the department owning the notification.
Owner_User_ID	YES	STRING	The ID of the user owning the notification.
Owner_User_Name	YES	STRING	The name of the user owning the notification.
Urgent	YES	BOOL	Indicates whether the notification is urgent.
Hidden	YES	BOOL	Indicates whether the notification is hidden.
Created_Timestamp	YES	TIMESTAMP	The timestamp when the notification was created.
Last_Modified_Timestamp	YES	TIMESTAMP	The timestamp when the notification was last modified.
Task_Key	YES	STRING	The key associated with the task related to the notification.
Task_Created_Timestamp	YES	TIMESTAMP	The timestamp when the task related to the notification was created.

Notification Log Table

Columns

Column Name	Is Nullable	Data Type	Description
Notification_Processing_Key	YES	STRING	Key for the notification.
Member_ID	YES	STRING	Identifier for the member.
Title	YES	STRING	Title of the notification.
Text	YES	STRING	Text content of the notification.
Source	YES	STRUCT	Source of the notification.
Source.Source_Type_Key	YES	INT64	Key for the source type.
Source.Source_Type	YES	STRING	Type of the source.
Source.Source_Type_Description	YES	STRING	Description of the source type.
Source.Source_ID	YES	STRING	The unique identifier for the source of the notification.
Source.Assessment_Response_Question_ID	YES	STRING	The ID of the assessment response question related to the notification.
Source.Assessment_Response_Score_ID	YES	STRING	The ID of the assessment response score related to the notification.
Target	YES	STRUCT	The target entity for the notification.
Target.Target_Type_Key	YES	INT64	The key identifying the type of target for the notification.
Target.Target_Type	YES	STRING	The type of target for the notification.
Target.Target_Type_Description	YES	STRING	A detailed description of the target type.