Risk Score Dataset Specification

The Risk Score Dataset Specification contains information on risk scores for each configured model based on claim data. It has no unique key and references members by Member_ID. This dataset encompasses several critical components:

Dataset Components

Risk Scores Table

Stores data related to individual risk scores.
Quantifies the likelihood of adverse events or outcomes based on various health indicators and patient history.

Risk Drivers Table

Contains information about the factors that influence risk scores.
Includes patient behaviors, environmental conditions, or genetic predispositions.
Aids in identifying and managing risk contributors.

Risk Log Table

Tracks changes or events related to risk scores.
Provides a detailed audit trail documenting how risk assessments evolve over time in response to treatment or changes in patient condition.

Raw Data Table

Provides unprocessed, detailed risk-related information.
Crucial for conducting in-depth analyses to refine risk assessment models and develop more effective risk management strategies.

This dataset plays a pivotal role in the proactive monitoring and management of risks within healthcare settings, enabling providers to better predict and prevent adverse outcomes, thereby enhancing patient care and safety.

Risk Scores Table Schema

Column Name	Is Nullable	Data Type	Description
`Risk_Model_ID`	YES	INT64	Unique identifier for the risk model used.
`Primary_Model`	YES	BOOL	Indicates whether the risk model is the primary model.
`Risk_Score_Type_Code`	YES	STRING	Code representing the type of risk score.
`Risk_Score_Type_Description`	YES	STRING	Description of the risk score type.
`Population_Type`	YES	STRING	Type of population for which the risk score is calculated.
`Member_ID`	YES	STRING	Unique identifier for the member or patient.
`Medical_Expenditure`	YES	FLOAT64	Total medical expenditure for the member.
`Risk_Score`	YES	FLOAT64	Calculated risk score based on the risk model and parameters.
`Visibility_Level`	YES	INT64	Level of visibility or access associated with the risk score.

Risk Drivers Table Schema

Column Name	Is Nullable	Data Type	Description
`Risk_Model_ID`	YES	INT64	Unique identifier for the risk model used.
`Member_ID`	YES	STRING	Unique identifier for the member or patient.
`Risk_Score`	YES	FLOAT64	Calculated risk score based on the risk model and parameters.
`Risk_Drivers_Category`	YES	STRING	Category or type of risk driver contributing to the risk score.
`Risk_Drivers_Contribution`	YES	FLOAT64	Contribution of the risk driver to the overall risk score.

Risk Log Table Schema

Column Name	Is Nullable	Data Type	Description
`Risk_Model_ID`	YES	INT64	Unique identifier for the risk model used.
`Primary_Model`	YES	BOOL	Flag indicating if the risk model is the primary one.
`Risk_Score_Type_Code`	YES	STRING	Code identifying the type of risk score.
`Risk_Score_Type_Description`	YES	STRING	Description of the risk score type.
`Population_Type`	YES	STRING	Type of population the risk score is calculated for.
`Member_ID`	YES	STRING	Unique identifier for the member or patient.
`Medical_Expenditure`	YES	FLOAT64	Amount of medical expenses associated with the member.
`Risk_Score`	YES	FLOAT64	Calculated risk score based on the risk model.
`Risk_Drivers`	NO	ARRAY	Factors or drivers contributing to the risk score.
`Risk_Drivers_Category`	YES	STRING	Category or type of risk driver contributing to the risk score.
`Risk_Drivers_Contribution`	YES	FLOAT64	Contribution of the risk driver to the overall risk score.
`Type`	YES	STRING	Type of action or event related to the risk score log.
`Tenant`	YES	STRING	Identifier for the tenant or organization.
`Active_Version`	YES	BOOL	Active version or status of the risk score log entry.
`Date`	YES	DATE	Date of the risk score log entry.
`Sequence`	YES	INT64	Sequence number or order of the log entry.
`Source_System_Name`	YES	STRING	Name of the source system generating the log entry.
`Source_File_Name`	YES	STRING	Name of the source file associated with the log entry.
`Source_Timestamp`	YES	TIMESTAMP	Timestamp indicating when the log entry was created.
`Schema_Version`	YES	FLOAT64	Version of the schema or data model used.
`Member_Partition`	YES	INT64	Partition or segment of the member data.
`_updated`	YES	STRING	Flag indicating if the log entry has been updated.
`Action`	YES	STRING	Type of action performed or recorded in the log entry.
`Visibility_Level`	YES	INT64	Level of visibility or access associated with the risk score.

Raw Data Table Schema

Column Name	Is Nullable	Data Type	Description
`Risk_Model_ID`	YES	INT64	Unique identifier for the risk model used.
`Primary_Model`	YES	BOOL	Flag indicating if the risk model is the primary one.
`Risk_Score_Type_Code`	YES	STRING	Code identifying the type of risk score.
`Risk_Score_Type_Description`	YES	STRING	Description of the risk score type.
`Population_Type`	YES	STRING	Type of population the risk score is calculated for.
`Member_ID`	YES	STRING	Unique identifier for the member or patient.
`Medical_Expenditure`	YES	FLOAT64	Amount of medical expenses associated with the member.
`Risk_Score`	YES	FLOAT64	Calculated risk score based on the risk model.
`Risk_Drivers`	NO	ARRAY	Factors or drivers contributing to the risk score.
`Risk_Drivers_Category`	YES	STRING	Category or type of risk driver contributing to the risk score.
`Risk_Drivers_Contribution`	YES	FLOAT64	Contribution of the risk driver to the overall risk score.

Risk Score Dataset Specification

Overview

The Risk Score Dataset Specification outlines the structure and details of various tables used in the Care Intelligence system to quantify, track, and analyze risk scores. These tables include information about individual risk scores, contributing factors, and audit logs to support effective risk management strategies.

Tables Overview

Risk Scores Table

Purpose: Stores data related to individual risk scores, which quantify the likelihood of adverse events or outcomes based on various health indicators and patient history.

Risk Drivers Table

Purpose: Contains information about the factors that influence risk scores, such as patient behaviors, environmental conditions, or genetic predispositions, aiding in the identification and management of risk contributors.

Risk Log Table

Purpose: Tracks changes or events related to risk scores, offering a detailed audit trail that documents how risk assessments evolve over time in response to treatment or changes in patient condition.

Raw Data Table

Purpose: Provides unprocessed, detailed risk-related information. This data is crucial for conducting in-depth analyses to refine risk assessment models and develop more effective risk management strategies.

Table Specifications

Risk_Score Table

Column Name	Is Nullable	Data Type	Description
Risk_Model_ID	YES	INT64	Unique identifier for the risk model used.
Primary_Model	YES	BOOL	Indicates whether the risk model is the primary model.
Risk_Score_Type_Code	YES	STRING	Code representing the type of risk score.
Risk_Score_Type_Description	YES	STRING	Description of the risk score type.
Population_Type	YES	STRING	Type of population for which the risk score is calculated.
Member_ID	YES	STRING	Unique identifier for the member or patient.
Medical_Expenditure	YES	FLOAT64	Total medical expenditure for the member.
Risk_Score	YES	FLOAT64	Calculated risk score based on the risk model and parameters.
Visibility_Level	YES	INT64	Level of visibility or access associated with the risk score.

Risk_Score_Risk_Drivers Table

Column Name	Is Nullable	Data Type	Description
Risk_Model_ID	YES	INT64	Unique identifier for the risk model used.
Member_ID	YES	STRING	Unique identifier for the member or patient.
Risk_Score	YES	FLOAT64	Calculated risk score based on the risk model and parameters.
Risk_Drivers_Category	YES	STRING	Category or type of risk driver contributing to the risk score.
Risk_Drivers_Contribution	YES	FLOAT64	Contribution of the risk driver to the overall risk score.

Risk_Score_Log Table

Column Name	Is Nullable	Data Type	Description
Risk_Model_ID	YES	INT64	Unique identifier for the risk model used.
Primary_Model	YES	BOOL	Flag indicating if the risk model is the primary one.
Risk_Score_Type_Code	YES	STRING	Code identifying the type of risk score.
Risk_Score_Type_Description	YES	STRING	Description of the risk score type.
Population_Type	YES	STRING	Type of population the risk score is calculated for.
Member_ID	YES	STRING	Unique identifier for the member or patient.
Medical_Expenditure	YES	FLOAT64	Amount of medical expenses associated with the member.
Risk_Score	YES	FLOAT64	Calculated risk score based on the risk model.
Risk_Drivers	NO	ARRAY	Factors or drivers contributing to the risk score. See below for detailed information on each parameter in the Array.
Type	YES	STRING	Type of action or event related to the risk score log.
Tenant	YES	STRING	Identifier for the tenant or organization.
Active_Version	YES	BOOL	Active version or status of the risk score log entry.
Date	YES	DATE	Date of the risk score log entry.
Sequence	YES	INT64	Sequence number or order of the log entry.
Source_System_Name	YES	STRING	Name of the source system generating the log entry.
Source_File_Name	YES	STRING	Name of the source file associated with the log entry.
Source_Timestamp	YES	TIMESTAMP	Timestamp indicating when the log entry was created.

Risk Drivers Array Parameters

Column Name	Is Nullable	Data Type	Description
Risk_Drivers_Category	YES	STRING	Category or type of risk driver contributing to the risk score.
Risk_Drivers_Contribution	YES	FLOAT64	Contribution of the risk driver to the overall risk score.

Raw Data Table

Column Name	Is Nullable	Data Type	Description
Type	YES	STRING	Type of action or event related to the raw risk score entry.
Tenant	YES	STRING	Identifier for the tenant or organization.
Active_Version	YES	BOOL	Active version or status of the raw risk score entry.
Date	YES	DATE	Date of the raw risk score entry.
Sequence	YES	INT64	Sequence number or order of the raw risk score entry.
Source_System_Name	YES	STRING	Name of the source system generating the raw risk score entry.
Source_File_Name	YES	STRING	Name of the source file associated with the raw risk score entry.
Source_Timestamp	YES	TIMESTAMP	Timestamp indicating when the raw risk score entry was created.
Schema_Version	YES	FLOAT64	Version of the schema or data model used for the raw risk score entry.
Member_Partition	YES	INT64	Partition or segment of the member data.
_updated	YES	STRING	Flag indicating if the raw risk score entry has been updated.
Visibility_Level	YES	INT64	Level of visibility or access associated with the risk score.

Risk Score Dataset Specification

Overview

This document provides the specifications for the Risk Score dataset used in Care Intelligence. It includes details about the schema, data model, and individual fields within the dataset. The dataset is divided into two main tables: Risk_Score_log and Risk_Score_raw.

Table: Risk_Score_log

Columns

ma_Version
Is Nullable: YES
Data Type: FLOAT64
Description: Version of the schema or data model used.
Member_Partition
Is Nullable: YES
Data Type: INT64
Description: Partition or segment of the member data.
_updated
Is Nullable: YES
Data Type: STRING
Description: Flag indicating if the log entry has been updated.
Action
Is Nullable: YES
Data Type: STRING
Description: Type of action performed or recorded in the log entry.
Visibility_Level
Is Nullable: YES
Data Type: INT64
Description: Level of visibility or access associated with the risk score.

Table: Risk_Score_raw

Columns

Risk_Model_ID
Is Nullable: YES
Data Type: INT64
Description: Unique identifier for the risk model used.
Primary_Model
Is Nullable: YES
Data Type: BOOL
Description: Flag indicating if the risk model is the primary one.
Risk_Score_Type_Code
Is Nullable: YES
Data Type: STRING
Description: Code identifying the type of risk score.
Risk_Score_Type_Description
Is Nullable: YES
Data Type: STRING
Description: Description of the risk score type.
Population_Type
Is Nullable: YES
Data Type: STRING
Description: Type of population the risk score is calculated for.
Member_ID
Is Nullable: YES
Data Type: STRING
Description: Unique identifier for the member or patient.
Medical_Expenditure
Is Nullable: YES
Data Type: FLOAT64
Description: Amount of medical expenses associated with the member.
Risk_Score
Is Nullable: YES
Data Type: FLOAT64
Description: Calculated risk score based on the risk model.
Risk_Drivers
Is Nullable: NO
Data Type: ARRAY
Description: Factors or drivers contributing to the risk score. See below for detailed information on each parameter in the array.

Risk_Drivers Array Parameters

Risk_Drivers_Category
Is Nullable: YES
Data Type: STRING
Description: Category or type of risk driver contributing to the risk score.
Risk_Drivers_Contribution
Is Nullable: YES
Data Type: FLOAT64
Description: Contribution of the risk driver to the overall risk score.

Type
Is Nullable: YES
Data Type: STRING
Description: Type of action or event related to the raw risk score entry.
Tenant
Is Nullable: YES
Data Type: STRING
Description: Identifier for the tenant or organization.
Active_Version
Is Nullable: YES
Data Type: BOOL
Description: Active version or status of the raw risk score entry.
Date
Is Nullable: YES
Data Type: DATE
Description: Date of the raw risk score entry.
Sequence
Is Nullable: YES
Data Type: INT64
Description: Sequence number or order of the raw risk score entry.
Source_System_Name
Is Nullable: YES
Data Type: STRING
Description: Name of the source system generating the raw risk score entry.
Source_File_Name
Is Nullable: YES
Data Type: STRING
Description: Name of the source file associated with the raw risk score entry.
Source_Timestamp
Is Nullable: YES
Data Type: TIMESTAMP
Description: Timestamp indicating when the raw risk score entry was created.
Schema_Version
Is Nullable: YES
Data Type: FLOAT64
Description: Version of the schema or data model used for the raw risk score entry.
Member_Partition
Is Nullable: YES
Data Type: INT64
Description: Partition or segment of the member data.
_updated
Is Nullable: YES
Data Type: STRING
Description: Flag indicating if the raw risk score entry has been updated.
Visibility_Level
Is Nullable: YES
Data Type: INT64
Description: Level of visibility or access associated with the risk score.

Condition Dataset Specification

Opportunity Score Dataset Specification

Health Status Measure Dataset Specification

Episode Dataset Specification

Calendar Dataset Specification