Skip to main content

Activity Stream Entry Dataset Specification

Updated over a month ago

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.

Did this answer your question?