Activity Stream Entry Dataset Specification
Activity Stream Entry Dataset Specification
The "Activity Stream Entry Dataset Specification" is designed to track and monitor real-time activities and events within healthcare systems. This dataset is crucial for maintaining transparency, ensuring data integrity, and adhering to healthcare-specific standards such as HIPAA and other regulations governing the handling of patient information. It facilitates the monitoring of clinical, administrative, and operational activities, providing a comprehensive audit trail that supports efficient healthcare management and compliance.
Overview
This dataset includes the following key tables:
Activity Stream Entry
Stores detailed records of all activities within the healthcare system, including interactions with patient records, updates to clinical data, and administrative events.
Each entry includes relevant metadata such as timestamps, user IDs, and event descriptions, providing a clear view of system activities for auditing and performance monitoring.
Activity Stream Entry Log
Tracks changes and updates made to activity stream entries, providing a historical record of modifications.
This log is essential for maintaining an audit trail that supports compliance with healthcare regulations and ensures the integrity of the recorded activities.
Activity Stream Entry Raw
Contains unprocessed, detailed data related to the activity stream entries.
This raw data serves as a foundational dataset for in-depth analysis, supporting research, audits, and data verification tasks.
ADT Messages Raw
Stores raw data from ADT (Admission, Discharge, Transfer) messages, a key component of patient flow in healthcare settings.
Captures unprocessed information related to patient admissions, transfers, and discharges, which is critical for maintaining up-to-date patient records and ensuring smooth transitions in care.
This dataset plays an integral role in healthcare organizations by providing a robust framework for tracking and analyzing system activities. It ensures transparency and accountability, helps maintain compliance with healthcare standards, and supports data-driven decision-making processes that enhance both clinical and operational efficiency.
Table Specifications
Activity Stream Entry
Column Name | Is Nullable | Data Type | Description |
Member_ID | NO | STRING | Unique identifier for the member associated with the activity stream entry. |
Activity_Stream_Entry_Key | NO | INT64 | Unique identifier for the activity stream entry. |
Activity_Stream_Entry_Record_Type | YES | STRING | The type of record for the activity stream entry. |
Activity_Stream_Entry_Type | YES | STRING | The specific type of the activity stream entry. |
Activity_Stream_Entry_Type_Description | YES | STRING | Description of the activity stream entry type. |
Outreach_Type | YES | STRING | The type of outreach conducted. |
Outreach_Type_Description | YES | STRING | Description of the outreach type. |
Outreach_Channel_Type | YES | STRING | The channel type used for outreach. |
Outreach_Channel_Type_Description | YES | STRING | Description of the outreach channel type. |
Content_Template_Key | YES | INT64 | Unique identifier for the content template used. |
Content_Template_Name | YES | STRING | Name of the content template used. |
Status_Reason | YES | STRING | The reason for the status. |
Status_Reason_Description | YES | STRING | Description of the reason for the status. |
Phone_Number | YES | STRING | Phone number associated with the activity. |
Email_Address | YES | STRING | Email address associated with the activity. |
Custom_Fields_Text | YES | STRING | Text containing custom fields related to the activity. |
Content | YES | STRING | Content of the activity stream entry. |
Created_Timestamp | YES | TIMESTAMP | Timestamp when the activity stream entry was created. |
Last_Modified_Timestamp | YES | TIMESTAMP | Timestamp when the activity stream entry was last modified. |
Activity Stream Entry Log
Column Name | Is Nullable | Data Type | Description |
Member_ID | YES | STRING | Unique identifier for the member associated with the activity stream entry log. |
Activity_Stream_Entry_Key | YES | INT64 | Unique identifier for the activity stream entry. |
Activity_Stream_Entry_Record_Type | YES | STRING | The type of record for the activity stream entry log. |
Activity_Stream_Entry_Type | YES | STRING | The specific type of the activity stream entry log. |
Activity_Stream_Entry_Type_Description | YES | STRING | Description of the activity stream entry log type. |
Outreach_Type | YES | STRING | The type of outreach conducted. |
Outreach_Type_Description | YES | STRING | Description of the outreach type. |
Outreach_Channel_Type | YES | STRING | The channel type used for outreach. |
Outreach_Channel_Type_Description | YES | STRING | Description of the outreach channel type. |
Content_Template_Key | YES | INT64 | Unique identifier for the content template used. |
Content_Template_Name | YES | STRING | Name of the content template used. |
Status_Reason_Code | YES | STRING | Code representing the reason for the status. |
Status_Reason_Description | YES | STRING | Description of the reason for the status. |
Phone_Number | YES | STRING | Phone number associated with the activity. |
Email_Address | YES | STRING | Email address associated with the activity. |
Custom_Fields_Text | YES | STRING | Text containing custom fields related to the activity. |
Activity Stream Entry Dataset Specification
Activity Stream Entry Log
Fields and Descriptions
Created_Timestamp
Is Nullable: YES
Data Type: TIMESTAMP
Description: Timestamp when the activity stream entry log was created.
Last_Modified_Timestamp
Is Nullable: YES
Data Type: TIMESTAMP
Description: Timestamp when the activity stream entry log was last modified.
Record_Last_Modified_Timestamp
Is Nullable: YES
Data Type: TIMESTAMP
Description: Timestamp when the record was last modified.
Transaction_User_ID
Is Nullable: YES
Data Type: STRING
Description: User ID of the person who last modified the record.
Type
Is Nullable: YES
Data Type: STRING
Description: Type of the activity stream entry log.
Tenant
Is Nullable: YES
Data Type: STRING
Description: Tenant identifier associated with the activity stream entry log.
Active_Version
Is Nullable: YES
Data Type: BOOL
Description: Indicates whether the version is active.
Date
Is Nullable: YES
Data Type: DATE
Description: Date associated with the activity stream entry log.
Sequence
Is Nullable: YES
Data Type: INT64
Description: Sequence number for the activity stream entry log.
Source_System_Name
Is Nullable: YES
Data Type: STRING
Description: Name of the source system.
Source_Timestamp
Is Nullable: YES
Data Type: TIMESTAMP
Description: Timestamp from the source system.
Source_File_Name
Is Nullable: YES
Data Type: STRING
Description: Name of the source file.
Deleted_Indicator
Is Nullable: YES
Data Type: BOOL
Description: Indicator of whether the entry has been deleted.
Schema_Version
Is Nullable: YES
Data Type: FLOAT64
Description: Version of the schema used for the activity stream entry log.
Action
Is Nullable: YES
Data Type: STRING
Description: Action associated with the activity stream entry log.
Member_Partition
Is Nullable: YES
Data Type: INT64
Description: Partition information for the member.
_updated
Is Nullable: YES
Data Type: STRING
Description: Update information for the activity stream entry log.
Content
Is Nullable: YES
Data Type: STRING
Description: Content of the activity stream entry log.
Transaction_Actor_Type
Is Nullable: YES
Data Type: STRING
Description: Type of the actor performing the transaction.
Activity Stream Entry Raw
Fields and Descriptions
Member_ID
Is Nullable: YES
Data Type: STRING
Description: Unique identifier for the member associated with the activity stream entry.
Activity_Stream_Entry_Key
Is Nullable: YES
Data Type: INT64
Description: Unique identifier for the activity stream entry.
Activity_Stream_Entry_Record_Type
Is Nullable: YES
Data Type: STRING
Description: The type of record for the activity stream entry.
Activity_Stream_Entry_Type
Is Nullable: YES
Data Type: STRING
Description: The specific type of the activity stream entry.
Activity_Stream_Entry_Type_Description
Is Nullable: YES
Data Type: STRING
Description: Description of the activity stream entry type.
Outreach_Type
Is Nullable: YES
Data Type: STRING
Description: The type of outreach conducted.
Outreach_Type_Description
Is Nullable: YES
Data Type: STRING
Description: Description of the outreach type.
Outreach_Channel_Type
Is Nullable: YES
Data Type: STRING
Description: The channel type used for outreach.
Outreach_Channel_Type_Description
Is Nullable: YES
Data Type: STRING
Description: Description of the outreach channel type.
Content_Template_Key
Is Nullable: YES
Data Type: INT64
Description: Unique identifier for the content template used.
Content_Template_Name
Is Nullable: YES
Data Type: STRING
Description: Name of the content template used.
Status_Reason_Code
Is Nullable: YES
Data Type: STRING
Description: Code representing the reason for the status.
Status_Reason_Description
Is Nullable: YES
Data Type: STRING
Description: Description of the reason for the status.
Phone_Number
Is Nullable: YES
Data Type: STRING
Description: Phone number associated with the activity.
Email_Address
Is Nullable: YES
Data Type: STRING
Description: Email address associated with the activity.
Custom_Fields_Text
Is Nullable: YES
Data Type: STRING
Description: Text containing custom fields related to the activity.
Created_Timestamp
Is Nullable: YES
Data Type: TIMESTAMP
Description: Timestamp when the activity stream entry was created.
Last_Modified_Timestamp
Is Nullable: YES
Data Type: TIMESTAMP
Description: Timestamp when the activity stream entry was last modified.
Record_Last_Modified_Timestamp
Is Nullable: YES
Data Type: TIMESTAMP
Description: Timestamp when the record was last modified.
Transaction_User_ID
Is Nullable: YES
Data Type: STRING
Description: User ID of the person who last modified the record.
Type
Is Nullable: YES
Data Type: STRING
Description: Type of the activity stream entry.
Tenant
Is Nullable: YES
Data Type: STRING
Description: Tenant identifier associated with the activity stream entry.
Active_Version
Is Nullable: YES
Data Type: BOOL
Description: Indicates whether the version is active.
Date
Is Nullable: YES
Data Type: DATE
Description: Date associated with the activity stream entry.
Sequence
Is Nullable: YES
Data Type: INT64
Description: Sequence number for the activity stream entry.
Source_System_Name
Is Nullable: YES
Data Type: STRING
Description: Name of the source system.
Source_Timestamp
Is Nullable: YES
Data Type: TIMESTAMP
Description: Timestamp from the source system.
Source_File_Name
Is Nullable: YES
Data Type: STRING
Description: Name of the source file.
Deleted_Indicator
Is Nullable: YES
Data Type: BOOL
Description: Indicator of whether the entry has been deleted.
Schema_Version
Is Nullable: YES
Data Type: FLOAT64
Description: Version of the schema used for the activity stream entry.
Member_Partition
Is Nullable: YES
Data Type: INT64
Description: Partition information for the member.
_updated
Is Nullable: YES
Data Type: STRING
Description: Update information for the activity stream entry.
Content
Is Nullable: YES
Data Type: STRING
Description: Content of the activity stream entry.
ADT Messages Raw
Fields and Descriptions
data
Is Nullable: YES
Data Type: STRING
Description: Contains the raw ADT (Admission, Discharge, and Transfer) message data.
subscription_name
Is Nullable: YES
Data Type: STRING
Description: The name of the subscription from which the ADT message was received.
message_id
Is Nullable: YES
Data Type: STRING
Description: The unique identifier of the ADT message.
publish_time
Is Nullable: YES
Data Type: TIMESTAMP
Description: The timestamp indicating when the ADT message was published.
attributes
Is Nullable: YES
Data Type: STRING
Description: Contains additional attributes associated with the ADT message in a serialized format.
Activity Stream Entry Dataset Specification
Overview
The Activity Stream Entry Dataset provides detailed records of all activities within the healthcare system, including interactions with patient records, updates to clinical data, and administrative events. Each entry includes relevant metadata such as timestamps, user IDs, and event descriptions, offering a clear view of system activities for auditing and performance monitoring.
Key Components
Activity Stream Entry Log: Tracks changes and updates made to activity stream entries, providing a historical record of modifications. This log is essential for maintaining an audit trail that supports compliance with healthcare regulations and ensures the integrity of the recorded activities.
Activity Stream Entry Raw: Contains unprocessed, detailed data related to the activity stream entries. This raw data serves as a foundational dataset for in-depth analysis, supporting research, audits, and data verification tasks.
ADT Messages Raw: Stores raw data from ADT (Admission, Discharge, Transfer) messages, a key component of patient flow in healthcare settings. This table captures unprocessed information related to patient admissions, transfers, and discharges, which is critical for maintaining up-to-date patient records and ensuring smooth transitions in care.
Table Specifications
Activity Stream Entry Table
Table Name | Column Name | Is Nullable | Data Type | Description |
Activity_Stream_Entry | Member_ID | NO | STRING | Unique identifier for the member associated with the activity stream entry. |
Activity_Stream_Entry | Activity_Stream_Entry_Key | NO | INT64 | Unique identifier for the activity stream entry. |
Activity_Stream_Entry | Activity_Stream_Entry_Record_Type | YES | STRING | The type of record for the activity stream entry. |
Activity_Stream_Entry | Activity_Stream_Entry_Type | YES | STRING | The specific type of the activity stream entry. |
Activity_Stream_Entry | Activity_Stream_Entry_Type_Description | YES | STRING | Description of the activity stream entry type. |
Activity_Stream_Entry | Outreach_Type | YES | STRING | The type of outreach conducted. |
Activity_Stream_Entry | Outreach_Type_Description | YES | STRING | Description of the outreach type. |
Activity_Stream_Entry | Outreach_Channel_Type | YES | STRING | The channel type used for outreach. |
Activity_Stream_Entry | Outreach_Channel_Type_Description | YES | STRING | Description of the outreach channel type. |
Activity_Stream_Entry | Content_Template_Key | YES | INT64 | Unique identifier for the content template used. |
Activity_Stream_Entry | Content_Template_Name | YES | STRING | Name of the content template used. |
Activity_Stream_Entry | Status_Reason | YES | STRING | The reason for the status. |
Activity_Stream_Entry | Status_Reason_Description | YES | STRING | Description of the reason for the status. |
Activity_Stream_Entry | Phone_Number | YES | STRING | Phone number associated with the activity. |
Activity_Stream_Entry | Email_Address | YES | STRING | Email address associated with the activity. |
Activity_Stream_Entry | Custom_Fields_Text | YES | STRING | Text containing custom fields related to the activity. |
Activity_Stream_Entry | Content | YES | STRING | Content of the activity stream entry. |
Activity_Stream_Entry | Created_Timestamp | YES | TIMESTAMP | Timestamp when the activity stream entry was created. |
Activity_Stream_Entry | Last_Modified_Timestamp | YES | TIMESTAMP | Timestamp when the activity stream entry was last modified. |
Activity Stream Entry Log Table
Table Name | Column Name | Is Nullable | Data Type | Description |
Activity_Stream_Entry_Log | Member_ID | YES | STRING | Unique identifier for the member associated with the activity stream entry log. |
Activity_Stream_Entry_Log | Activity_Stream_Entry_Key | YES | INT64 | Unique identifier for the activity stream entry. |
Activity_Stream_Entry_Log | Activity_Stream_Entry_Record_Type | YES | STRING | The type of record for the activity stream entry log. |
Activity_Stream_Entry_Log | Activity_Stream_Entry_Type | YES | STRING | The specific type of the activity stream entry log. |
Activity_Stream_Entry_Log | Activity_Stream_Entry_Type_Description | YES | STRING | Description of the activity stream entry log type. |
Activity_Stream_Entry_Log | Outreach_Type | YES | STRING | The type of outreach conducted. |
Activity_Stream_Entry_Log | Outreach_Type_Description | YES | STRING | Description of the outreach type. |
Activity_Stream_Entry_Log | Outreach_Channel_Type | YES | STRING | The channel type used for outreach. |
Activity_Stream_Entry_Log | Outreach_Channel_Type_Description | YES | STRING | Description of the outreach channel type. |
Activity_Stream_Entry_Log | Content_Template_Key | YES | INT64 | Unique identifier for the content template used. |
Activity_Stream_Entry_Log | Content_Template_Name | YES | STRING | Name of the content template used. |
Activity_Stream_Entry_Log | Status_Reason_Code | YES | STRING | Code representing the reason for the status. |
Activity_Stream_Entry_Log | Status_Reason_Description | YES | STRING | Description of the reason for the status. |
Activity_Stream_Entry_Log | Phone_Number | YES | STRING | Phone number associated with the activity. |
Activity_Stream_Entry_Log | Email_Address | YES | STRING | Email address associated with the activity. |
Activity_Stream_Entry_Log | Custom_Fields_Text | YES | STRING | Text containing custom fields related to the activity. |
Activity_Stream_Entry_Log | Created_Timestamp | YES | TIMESTAMP | Timestamp when the activity stream entry log was created. |
Activity_Stream_Entry_Log | Last_Modified_Timestamp | YES | TIMESTAMP | Timestamp when the activity stream entry log was last modified. |
Activity_Stream_Entry_Log | Record_Last_Modified_Timestamp | YES | TIMESTAMP | Timestamp when the record was last modified. |
Activity_Stream_Entry_Log | Transaction_User_ID | YES | STRING | User ID of the person who last modified the record. |
Activity_Stream_Entry_Log | Type | YES | STRING | Type of the activity stream entry log. |
Activity Stream Entry Dataset Specification
Activity Stream Entry Log
Columns
Tenant
Is Nullable: YES
Data Type: STRING
Description: Tenant identifier associated with the activity stream entry log.
Active_Version
Is Nullable: YES
Data Type: BOOL
Description: Indicates whether the version is active.
Date
Is Nullable: YES
Data Type: DATE
Description: Date associated with the activity stream entry log.
Sequence
Is Nullable: YES
Data Type: INT64
Description: Sequence number for the activity stream entry log.
Source_System_Name
Is Nullable: YES
Data Type: STRING
Description: Name of the source system.
Source_Timestamp
Is Nullable: YES
Data Type: TIMESTAMP
Description: Timestamp from the source system.
Source_File_Name
Is Nullable: YES
Data Type: STRING
Description: Name of the source file.
Deleted_Indicator
Is Nullable: YES
Data Type: BOOL
Description: Indicator of whether the entry has been deleted.
Schema_Version
Is Nullable: YES
Data Type: FLOAT64
Description: Version of the schema used for the activity stream entry log.
Action
Is Nullable: YES
Data Type: STRING
Description: Action associated with the activity stream entry log.
Member_Partition
Is Nullable: YES
Data Type: INT64
Description: Partition information for the member.
_updated
Is Nullable: YES
Data Type: STRING
Description: Update information for the activity stream entry log.
Content
Is Nullable: YES
Data Type: STRING
Description: Content of the activity stream entry log.
Transaction_Actor_Type
Is Nullable: YES
Data Type: STRING
Description: Type of the actor performing the transaction.
Activity Stream Entry Raw
Columns
Member_ID
Is Nullable: YES
Data Type: STRING
Description: Unique identifier for the member associated with the activity stream entry.
Activity_Stream_Entry_Key
Is Nullable: YES
Data Type: INT64
Description: Unique identifier for the activity stream entry.
Activity_Stream_Entry_Record_Type
Is Nullable: YES
Data Type: STRING
Description: The type of record for the activity stream entry.
Activity_Stream_Entry_Type
Is Nullable: YES
Data Type: STRING
Description: The specific type of the activity stream entry.
Activity_Stream_Entry_Type_Description
Is Nullable: YES
Data Type: STRING
Description: Description of the activity stream entry type.
Outreach_Type
Is Nullable: YES
Data Type: STRING
Description: The type of outreach conducted.
Outreach_Type_Description
Is Nullable: YES
Data Type: STRING
Description: Description of the outreach type.
Outreach_Channel_Type
Is Nullable: YES
Data Type: STRING
Description: The channel type used for outreach.
Outreach_Channel_Type_Description
Is Nullable: YES
Data Type: STRING
Description: Description of the outreach channel type.
Content_Template_Key
Is Nullable: YES
Data Type: INT64
Description: Unique identifier for the content template used.
Content_Template_Name
Is Nullable: YES
Data Type: STRING
Description: Name of the content template used.
Status_Reason_Code
Is Nullable: YES
Data Type: STRING
Description: Code representing the reason for the status.
Status_Reason_Description
Is Nullable: YES
Data Type: STRING
Description: Description of the reason for the status.
Phone_Number
Is Nullable: YES
Data Type: STRING
Description: Phone number associated with the activity.
Email_Address
Is Nullable: YES
Data Type: STRING
Description: Email address associated with the activity.
Custom_Fields_Text
Is Nullable: YES
Data Type: STRING
Description: Text containing custom fields related to the activity.
Created_Timestamp
Is Nullable: YES
Data Type: TIMESTAMP
Description: Timestamp when the activity stream entry was created.
Last_Modified_Timestamp
Is Nullable: YES
Data Type: TIMESTAMP
Description: Timestamp when the activity stream entry was last modified.
Record_Last_Modified_Timestamp
Is Nullable: YES
Data Type: TIMESTAMP
Description: Timestamp when the record was last modified.
Transaction_User_ID
Is Nullable: YES
Data Type: STRING
Description: User ID of the person who last modified the record.
Type
Is Nullable: YES
Data Type: STRING
Description: Type of the activity stream entry.
Tenant
Is Nullable: YES
Data Type: STRING
Description: Tenant identifier associated with the activity stream entry.
Active_Version
Is Nullable: YES
Data Type: BOOL
Description: Indicates whether the version is active.
Date
Is Nullable: YES
Data Type: DATE
Description: Date associated with the activity stream entry.
Sequence
Is Nullable: YES
Data Type: INT64
Description: Sequence number for the activity stream entry.
Source_System_Name
Is Nullable: YES
Data Type: STRING
Description: Name of the source system.
Source_Timestamp
Is Nullable: YES
Data Type: TIMESTAMP
Description: Timestamp from the source system.
Source_File_Name
Is Nullable: YES
Data Type: STRING
Description: Name of the source file.
Deleted_Indicator
Is Nullable: YES
Data Type: BOOL
Description: Indicator of whether the entry has been deleted.
Schema_Version
Is Nullable: YES
Data Type: FLOAT64
Description: Version of the schema used for the activity stream entry.
Member_Partition
Is Nullable: YES
Data Type: INT64
Description: Partition information for the member.
_updated
Is Nullable: YES
Data Type: STRING
Description: Update information for the activity stream entry.
Content
Is Nullable: YES
Data Type: STRING
Description: Content of the activity stream entry.
Transaction_Actor_Type
Is Nullable: YES
Data Type: STRING
Description: Type of the actor performing the transaction.
ADT Messages Raw
Columns
data
Is Nullable: YES
Data Type: STRING
Description: Contains the raw ADT (Admission, Discharge, and Transfer) message data.
subscription_name
Is Nullable: YES
Data Type: STRING
Description: The name of the subscription from which the ADT message was received.
message_id
Is Nullable: YES
Data Type: STRING
Description: The unique identifier of the ADT message.
publish_time
Is Nullable: YES
Data Type: TIMESTAMP
Description: The timestamp indicating when the ADT message was published.
Activity Stream Entry Dataset Specification
Messages_raw
Attributes
Type: YES
Data Type: STRING
Description: Contains additional attributes associated with the ADT message in a serialized format.
