Note Dataset Specification

Overview

The Note dataset captures detailed records of notes associated with members, documenting various interactions, observations, or administrative information. This dataset logs critical information related to the creation, modification, and voiding of notes, along with detailed tracking of changes and related metadata. It includes fields for timestamps, user identifiers, note content, related entities, and system sources, ensuring a complete audit trail for each note entry. The dataset supports healthcare workflows by enabling accurate and detailed tracking of communications or documentation associated with patient care and administrative actions.

Note Log

Table Structure

Column Name	Is Nullable	Data Type	Description
Member_ID	YES	STRING	Unique identifier of the member to whom the note is related.
Note_Key	YES	STRING	Unique key that identifies the specific note entry in the log.
Text	YES	STRING	The content or text of the note.
Note_Type	YES	STRING	Type of the note.
Note_Type_Description	YES	STRING	Description for the type of the note.
Timestamp	YES	TIMESTAMP	The exact time when the note was created or recorded.
Author_User_ID	YES	STRING	Unique identifier of the user who authored the note.
Void_Indicator	YES	BOOL	Flag indicating whether the note has been voided (true/false).
Void_Timestamp	YES	TIMESTAMP	Timestamp indicating when the note was voided, if applicable.
Void_Reason	YES	STRING	The reason why the note was voided.
Void_Reason_Description	YES	STRING	Detailed description of the reason for voiding the note.
Void_User_ID	YES	STRING	Unique identifier of the user who voided the note.
Related_Entity_Type	YES	STRING	The type of entity (e.g., a related record or entity) associated with the note.
Related_Entity_Type_Description	YES	STRING	A description of the type of entity (e.g., member, provider, claim) to which this note is related.
Related_Entity_ID	YES	STRING	The unique identifier of the specific entity (as described in Related_Entity_Type_Description) to which this note is linked.
Created_Timestamp	YES	TIMESTAMP	The timestamp indicating when the note log entry was originally created.
Last_Modified_Timestamp	YES	TIMESTAMP	The timestamp showing the last time the note log entry was modified.
Record_Last_Modified_Timestamp	YES	TIMESTAMP	The timestamp indicating the most recent modification to the log record.
Transaction_User_ID	YES	STRING	Identifier of the user responsible for the last transaction affecting this log entry.
Tenant	YES	STRING	Identifier representing the specific tenant or organizational unit responsible for the note.
Active_Version	YES	BOOL	Version of the note log entry that is currently active.
Date	YES	DATE	Date associated with the entry or activity in the note log.
Sequence	YES	INT64	Sequence number to track the order of activities or changes to the note log.
Source_System_Name	YES	STRING	Name of the system from which the note or log entry originated.
Source_Timestamp	YES	TIMESTAMP	Timestamp showing when the note was created in the source system.
Source_File_Name	YES	STRING	Name of the source file, if applicable, from which the note log was extracted or generated.
Deleted_Indicator	YES	BOOL	Flag indicating whether the note entry has been marked for deletion (true/false).
Schema_Version	YES	FLOAT64	Version of the schema or structure being used to store the note log information.
Member_Partition	YES	INT64	Partition key used to segment or partition the member data for scalability in large datasets.
Action	YES	STRING	The type of action performed on the note (e.g., created, modified, voided).

Note Raw

Table Structure

Column Name	Is Nullable	Data Type	Description
Member_ID	YES	STRING	Unique identifier of the member to whom the note is related.
Note_Key	YES	STRING	Unique key that identifies the specific note entry in the log.
Text	YES	STRING	The content or text of the note.
Note_Type	YES	STRING	Type of the note.
Note_Type_Description	YES	STRING	Description for the type of the note.
Timestamp	YES	TIMESTAMP	The exact time when the note was created or recorded.
Author_User_ID	YES	STRING	Unique identifier of the user who authored the note.
Void_Indicator	YES	BOOL	Flag indicating whether the note has been voided (true/false).
Void_Timestamp	YES	TIMESTAMP	Timestamp indicating when the note was voided, if applicable.
Void_Reason	YES	STRING	The reason why the note was voided.
Void_Reason_Description	YES	STRING	Detailed description of the reason for voiding the note.
Void_User_ID	YES	STRING	Unique identifier of the user who voided the note.
Related_Entity_Type	YES	STRING	The type of entity (e.g., a related record or entity) associated with the note.
Related_Entity_Type_Description	YES	STRING	A description of the type of entity (e.g., member, provider, claim) to which this note is related.
Related_Entity_ID	YES	STRING	The unique identifier of the specific entity (as described in Related_Entity_Type_Description) to which this note is linked.
Created_Timestamp	YES	TIMESTAMP	The timestamp indicating when the note log entry was originally created.
Last_Modified_Timestamp	YES	TIMESTAMP	The timestamp showing the last time the note log entry was modified.
Record_Last_Modified_Timestamp	YES	TIMESTAMP	The timestamp indicating the most recent modification to the log record.
Transaction_User_ID	YES	STRING	Identifier of the user responsible for the last transaction affecting this log entry.
Tenant	YES	STRING	Identifier representing the specific tenant or organizational unit responsible for the note.
Active_Version	YES	BOOL	Version of the note log entry that is currently active.