Condition Dataset Specification

Overview

The "Condition Dataset Specification" contains member conditions identified based on Episodes. It does not have a unique key. It references Members by Member_ID and Episode(s) from which it was generated.

Key Components

Condition Records:\ These contain detailed entries of each patient's health condition, capturing critical aspects such as diagnosis, current status, severity, and other relevant clinical details. This ensures comprehensive documentation that supports effective patient care and medical review.
Customizable Clinical Data Points:\ The system allows for the addition of specific, tailored details for each health condition, enhancing the depth and utility of the records for healthcare providers.
Condition Tracking Logs:\ The "Condition Log" maintains a chronological record of all updates and changes to the condition data. This log offers valuable insights into the progression, treatment, and management of each condition, facilitating a better understanding of patient health dynamics over time.

This dataset is essential for continuously monitoring patient health, understanding the evolution of conditions, and ensuring that healthcare management decisions are informed and effective.

Condition Table Specification

Columns

Column Name	Is Nullable	Data Type	Description
`Member_ID`	YES	STRING	Member ID for the condition.
`Group_Code`	YES	INT64	Condition group ID.
`Condition_Code`	YES	STRING	Condition code.
`Condition_Name`	YES	STRING	Condition human-readable name.
`Condition_Chronic`	YES	BOOL	Chronic Condition Indicator.
`Parent_Condition_Code`	YES	STRING	Parent condition code.
`Parent_Condition_Name`	YES	STRING	Parent condition human-readable name.
`Condition_Confirmed`	YES	BOOL	Confirmed Condition Indicator.
`Disease_Stage`	YES	FLOAT64	The four-character numeric code identifying the stage of illness.
`Severity_Code`	YES	STRING	Condition severity code.
`Severity_Description`	YES	STRING	Condition severity description.
`From_Date`	YES	DATE	The `From_Date` of the oldest episode in the set.
`Latest_From_Date`	YES	DATE	The `From_Date` of the most recent episode in the set.
`To_Date`	YES	DATE	The `To_Date` of the most recent episode in the set.
`Episode_ID`	YES	STRING	List of `Episode_IDs` related to the condition.
`Visibility_Level`	YES	INT64	Level of visibility or access permissions for the condition log entry.

Condition Log Table Specification

Columns

Column Name	Is Nullable	Data Type	Description
`Member_ID`	YES	STRING	Identifier for the member or patient associated with the condition log entry.
`Group_Code`	YES	INT64	Code representing the group or category to which the condition belongs.
`Condition_Code`	YES	STRING	Code identifying the specific condition recorded in the log.
`Condition_Name`	YES	STRING	Name or description of the condition recorded in the log.
`Condition_Chronic`	YES	BOOL	Indicator specifying whether the condition is chronic or long-lasting.
`Parent_Condition_Code`	YES	STRING	Code identifying the parent condition, if applicable.
`Parent_Condition_Name`	YES	STRING	Name or description of the parent condition, if applicable.
`Condition_Confirmed`	YES	BOOL	Indicator confirming the existence or diagnosis of the condition.
`Disease_Stage`	YES	FLOAT64	Stage or severity level of the disease or condition, if applicable.
`Severity_Code`	YES	STRING	Code representing the severity level of the condition.
`Severity_Description`	YES	STRING	Description or details about the severity level of the condition.
`From_Date`	YES	DATE	Start date or timestamp when the condition was recorded or began.
`Latest_From_Date`	YES	DATE	Latest start date or timestamp for the condition, if applicable.
`To_Date`	YES	DATE	End date or timestamp when the condition was resolved or ended, if applicable.
`Episode_ID`	YES	STRING	Identifier for the episode or instance associated with the condition log entry.
`Type`	YES	STRING	Type or category of the condition log entry, such as diagnosis or treatment.
`Tenant`	YES	STRING	Tenant or organization to which the condition log entry belongs.
`Active_Version`	YES	BOOL	Version or status indicating the active state of the condition log entry.
`Date`	YES	DATE	Date when the condition log entry was created or recorded.
`Sequence`	YES	INT64	Sequence number or order of the condition log entry within a series or dataset.
`Source_System_Name`	YES	STRING	Name of the source system or application that generated the condition log entry.
`Source_Timestamp`	YES	TIMESTAMP	Timestamp indicating when the condition log entry was sourced or recorded.
`Source_File_Name`	YES	STRING	Name of the source file associated with the condition log entry, if applicable.
`Schema_Version`	YES	FLOAT64	Version of the schema or data structure used for the condition log entry.
`Visibility_Level`	YES	INT64	Level of visibility or access permissions for the condition log entry.
`Member_Partition`	YES	INT64	Partition or segment of the member or patient data to which the condition log entry belongs.
`_updated`	YES	STRING	Indicator or timestamp showing when the condition log entry was last updated or modified.
`Action`	YES	STRING	Action or operation performed on the condition log entry, such as create, update, or delete.

Condition Raw Table Specification

Columns

Column Name	Is Nullable	Data Type	Description
`Member_ID`	YES	STRING	Identifier for the member or patient associated with the condition log entry.
`Group_Code`	YES	INT64	Code representing the group or category to which the condition belongs.
`Condition_Code`	YES	STRING	Code identifying the specific condition recorded in the raw dataset.

Condition Dataset Specification

Overview

The condition dataset captures detailed entries of each patient's health condition, including diagnosis, current status, severity, and other relevant clinical details. This ensures comprehensive documentation that supports effective patient care and medical review.

Features

Condition Records: Detailed entries of each patient's health condition, capturing critical aspects such as diagnosis, current status, severity, and other relevant clinical details. This ensures comprehensive documentation that supports effective patient care and medical review.
Customizable Clinical Data Points: The system allows for the addition of specific, tailored details for each health condition, enhancing the depth and utility of the records for healthcare providers.
Condition Tracking Logs: The "Condition Log" maintains a chronological record of all updates and changes to the condition data. This log offers valuable insights into the progression, treatment, and management of each condition, facilitating a better understanding of patient health dynamics over time.

Condition Dataset Structure

Condition Table

Table Name	Column Name	Is Nullable	Data Type	Description
Condition	Member_ID	YES	STRING	Member ID for the condition.
Condition	Group_Code	YES	INT64	Condition group ID.
Condition	Condition_Code	YES	STRING	Condition code.
Condition	Condition_Name	YES	STRING	Condition human-readable name.
Condition	Condition_Chronic	YES	BOOL	Chronic Condition Indicator.
Condition	Parent_Condition_Code	YES	STRING	Parent condition code.
Condition	Parent_Condition_Name	YES	STRING	Parent condition human-readable name.
Condition	Condition_Confirmed	YES	BOOL	Confirmed Condition Indicator.
Condition	Disease_Stage	YES	FLOAT64	The four-character numeric code identifying the stage of illness for the condition.
Condition	Severity_Code	YES	STRING	Condition security code.
Condition	Severity_Description	YES	STRING	Condition severity description.
Condition	From_Date	YES	DATE	The From_Date of the oldest episode in the set.
Condition	Latest_From_Date	YES	DATE	The From_Date of the most recent episode in the set.
Condition	To_Date	YES	DATE	The To_Date of the most recent episode in the set.
Condition	Episode_ID	YES	STRING	List of Episode_IDs related to condition.
Condition	Visibility_Level	YES	INT64	Level of visibility or access permissions for the condition log entry.

Condition Log Table

Table Name	Column Name	Is Nullable	Data Type	Description
Condition_log	Member_ID	YES	STRING	Identifier for the member or patient associated with the condition log entry.
Condition_log	Group_Code	YES	INT64	Code representing the group or category to which the condition belongs.
Condition_log	Condition_Code	YES	STRING	Code identifying the specific condition recorded in the log.
Condition_log	Condition_Name	YES	STRING	Name or description of the condition recorded in the log.
Condition_log	Condition_Chronic	YES	BOOL	Indicator specifying whether the condition is chronic or long-lasting.
Condition_log	Parent_Condition_Code	YES	STRING	Code identifying the parent condition, if applicable.
Condition_log	Parent_Condition_Name	YES	STRING	Name or description of the parent condition, if applicable.
Condition_log	Condition_Confirmed	YES	BOOL	Indicator confirming the existence or diagnosis of the condition.
Condition_log	Disease_Stage	YES	FLOAT64	Stage or severity level of the disease or condition, if applicable.
Condition_log	Severity_Code	YES	STRING	Code representing the severity level of the condition.
Condition_log	Severity_Description	YES	STRING	Description or details about the severity level of the condition.
Condition_log	From_Date	YES	DATE	Start date or timestamp when the condition was recorded or began.
Condition_log	Latest_From_Date	YES	DATE	Latest start date or timestamp for the condition, if applicable.
Condition_log	To_Date	YES	DATE	End date or timestamp when the condition was resolved or ended, if applicable.
Condition_log	Episode_ID	YES	STRING	Identifier for the episode or instance associated with the condition log entry.
Condition_log	Type	YES	STRING	Type or category of the condition log entry, such as diagnosis or treatment.
Condition_log	Tenant	YES	STRING	Tenant or organization to which the condition log entry belongs.
Condition_log	Active_Version	YES	BOOL	Version or status indicating the active state of the condition log entry.
Condition_log	Date	YES	DATE	Date when the condition log entry was created or recorded.
Condition_log	Sequence	YES	INT64	Sequence number or order of the condition log entry within a series or dataset.
Condition_log	Source_System_Name	YES	STRING	Name of the source system or application that generated the condition log entry.
Condition_log	Source_Timestamp	YES	TIMESTAMP	Timestamp indicating when the condition log entry was sourced or recorded.
Condition_log	Source_File_Name	YES	STRING	Name of the source file associated with the condition log entry, if applicable.
Condition_log	Schema_Version	YES	FLOAT64	Version of the schema or data structure used for the condition log entry.
Condition_log	Visibility_Level	YES	INT64	Level of visibility or access permissions for the condition log entry.
Condition_log	Member_Partition	YES	INT64	Partition or segment of the member or patient data to which the condition log entry belongs.
Condition_log	_updated	YES	STRING	Indicator or timestamp showing when the condition log entry was last updated or modified.

Detailed Field Descriptions

Condition_raw Fields

Condition_Code: Code identifying the specific condition recorded in the log.
Condition_Name: Name or description of the condition recorded in the log.
Condition_Chronic: Indicator specifying whether the condition is chronic or long-lasting.
Parent_Condition_Code: Code identifying the parent condition, if applicable.
Parent_Condition_Name: Name or description of the parent condition, if applicable.
Condition_Confirmed: Indicator confirming the existence or diagnosis of the condition.
Disease_Stage: Stage or severity level of the disease or condition, if applicable.
Severity_Code: Code representing the severity level of the condition.
Severity_Description: Description or details about the severity level of the condition.
From_Date: Start date or timestamp when the condition was recorded or began.
Latest_From_Date: Latest start date or timestamp for the condition, if applicable.
To_Date: End date or timestamp when the condition was resolved or ended, if applicable.
Episode_ID: Identifier for the episode or instance associated with the condition log entry.
Type: Type or category of the condition log entry, such as diagnosis or treatment.
Tenant: Tenant or organization to which the condition log entry belongs.
Active_Version: Version or status indicating the active state of the condition log entry.
Date: Date when the condition log entry was created or recorded.
Sequence: Sequence number or order of the condition log entry within a series or dataset.
Source_System_Name: Name of the source system or application that generated the condition log entry.
Source_Timestamp: Timestamp indicating when the condition log entry was sourced or recorded.
Source_File_Name: Name of the source file associated with the condition log entry, if applicable.
Schema_Version: Version of the schema or data structure used for the condition log entry.
Visibility_Level: Level of visibility or access permissions for the condition log entry.
Member_Partition: Partition or segment of the member or patient data to which the condition log entry belongs.
_updated: Indicator or timestamp showing when the condition log entry was last updated or modified.

Condition Dataset Specification

Condition Log

Columns

Stage
Is Nullable: YES
Data Type: FLOAT64
Description: Stage or severity level of the disease or condition, if applicable.
Severity_Code
Is Nullable: YES
Data Type: STRING
Description: Code representing the severity level of the condition.
Severity_Description
Is Nullable: YES
Data Type: STRING
Description: Description or details about the severity level of the condition.
From_Date
Is Nullable: YES
Data Type: DATE
Description: Start date or timestamp when the condition was recorded or began.
Latest_From_Date
Is Nullable: YES
Data Type: DATE
Description: Latest start date or timestamp for the condition, if applicable.
To_Date
Is Nullable: YES
Data Type: DATE
Description: End date or timestamp when the condition was resolved or ended, if applicable.
Episode_ID
Is Nullable: YES
Data Type: STRING
Description: Identifier for the episode or instance associated with the condition log entry.
Type
Is Nullable: YES
Data Type: STRING
Description: Type or category of the condition log entry, such as diagnosis or treatment.
Tenant
Is Nullable: YES
Data Type: STRING
Description: Tenant or organization to which the condition log entry belongs.
Active_Version
Is Nullable: YES
Data Type: BOOL
Description: Version or status indicating the active state of the condition log entry.
Date
Is Nullable: YES
Data Type: DATE
Description: Date when the condition log entry was created or recorded.
Sequence
Is Nullable: YES
Data Type: INT64
Description: Sequence number or order of the condition log entry within a series or dataset.
Source_System_Name
Is Nullable: YES
Data Type: STRING
Description: Name of the source system or application that generated the condition log entry.
Source_Timestamp
Is Nullable: YES
Data Type: TIMESTAMP
Description: Timestamp indicating when the condition log entry was sourced or recorded.
Source_File_Name
Is Nullable: YES
Data Type: STRING
Description: Name of the source file associated with the condition log entry, if applicable.
Schema_Version
Is Nullable: YES
Data Type: FLOAT64
Description: Version of the schema or data structure used for the condition log entry.
Visibility_Level
Is Nullable: YES
Data Type: INT64
Description: Level of visibility or access permissions for the condition log entry.
Member_Partition
Is Nullable: YES
Data Type: INT64
Description: Partition or segment of the member or patient data to which the condition log entry belongs.
_updated
Is Nullable: YES
Data Type: STRING
Description: Indicator or timestamp showing when the condition log entry was last updated or modified.
Action
Is Nullable: YES
Data Type: STRING
Description: Action or operation performed on the condition log entry, such as create, update, or delete.

Condition Raw

Columns

Member_ID
Is Nullable: YES
Data Type: STRING
Description: Identifier for the member or patient associated with the condition log entry.
Group_Code
Is Nullable: YES
Data Type: INT64
Description: Code representing the group or category to which the condition belongs.
Condition_Code
Is Nullable: YES
Data Type: STRING
Description: Code identifying the specific condition recorded in the log.
Condition_Name
Is Nullable: YES
Data Type: STRING
Description: Name or description of the condition recorded in the log.
Condition_Chronic
Is Nullable: YES
Data Type: BOOL
Description: Indicator specifying whether the condition is chronic or long-lasting.
Parent_Condition_Code
Is Nullable: YES
Data Type: STRING
Description: Code identifying the parent condition, if applicable.
Parent_Condition_Name
Is Nullable: YES
Data Type: STRING
Description: Name or description of the parent condition, if applicable.
Condition_Confirmed
Is Nullable: YES
Data Type: BOOL
Description: Indicator confirming the existence or diagnosis of the condition.
Disease_Stage
Is Nullable: YES
Data Type: FLOAT64
Description: Stage or severity level of the disease or condition, if applicable.
Severity_Code
Is Nullable: YES
Data Type: STRING
Description: Code representing the severity level of the condition.
Severity_Description
Is Nullable: YES
Data Type: STRING
Description: Description or details about the severity level of the condition.
From_Date
Is Nullable: YES
Data Type: DATE
Description: Start date or timestamp when the condition was recorded or began.
Latest_From_Date
Is Nullable: YES
Data Type: DATE
Description: Latest start date or timestamp for the condition, if applicable.
To_Date
Is Nullable: YES
Data Type: DATE
Description: End date or timestamp when the condition was resolved or ended, if applicable.
Episode_ID
Is Nullable: YES
Data Type: STRING
Description: Identifier for the episode or instance associated with the condition log entry.
Type
Is Nullable: YES
Data Type: STRING
Description: Type or category of the condition log entry, such as diagnosis or treatment.
Tenant
Is Nullable: YES
Data Type: STRING
Description: Tenant or organization to which the condition log entry belongs.
Active_Version
Is Nullable: YES
Data Type: BOOL
Description: Version or status indicating the active state of the condition log entry.
Date
Is Nullable: YES
Data Type: DATE
Description: Date when the condition log entry was created or recorded.
Sequence
Is Nullable: YES
Data Type: INT64
Description: Sequence number or order of the condition log entry within a series or dataset.
Source_System_Name
Is Nullable: YES
Data Type: STRING
Description: Name of the source system or application that generated the condition log entry.
Source_Timestamp
Is Nullable: YES
Data Type: TIMESTAMP
Description: Timestamp indicating when the condition log entry was sourced or recorded.
Source_File_Name
Is Nullable: YES
Data Type: STRING
Description: Name of the source file associated with the condition log entry, if applicable.
Schema_Version
Is Nullable: YES
Data Type: FLOAT64
Description: Version of the schema or data structure used for the condition log entry.
Visibility_Level
Is Nullable: YES
Data Type: INT64
Description: Level of visibility or access permissions for the condition log entry.
Member_Partition
Is Nullable: YES
Data Type: INT64
Description: Partition or segment of the member or patient data to which the condition log entry belongs.
_updated
Is Nullable: YES
Data Type: STRING
Description: Indicator or timestamp showing when the condition log entry was last updated or modified.

Letter Dataset Specification

Risk Score Dataset Specification

Member App Dataset Specification

Questionnaire Dataset Specification

Calendar Dataset Specification