NAV

Risk Assessment EDW Schema v1

Overview

The Risk Assessment enterprise data warehouse (EDW) bundle contains files that make up a patient’s risk assessments in HealtheEDW.

See the Risk Assessment EDW Feed Type page for more information about how to process the feed type and how the feed type is designed.

Character Separated Values (CSV) Properties

Property Value
Header Record Yes
Field Delimiter Comma
Record Delimiter CR/LF
Character Encoding UTF-8

Files

File Name Description
RiskAssessment_F_Risk_Assessment This table contains calculated risk assessment information that was generated by the platform for a given population and contributed risk assessment information. The table includes the first code, coding display, and coding system ID in the list of codeable concepts. A list of all codeable concepts is available in the separate coding concept tables below.
RiskAssessment_F_Risk_Assessment_Factor This table contains the risk assessment factor names and values.
RiskAssessment_F_Risk_Assessment_Basis This table contains the risk assessment basis IDs and kinds.
RiskAssessment_F_Risk_Assessment_Type This table contains the risk assessment risk score type codes, coding displays, and system IDs.
RiskAssessment_F_Risk_Assessment_Condition This table contains the risk assessment risk score condition codes, coding displays, and system IDs.
RiskAssessment_F_Risk_Assessment_Method This table contains the risk assessment risk score method codes, coding displays, and system IDs.
RiskAssessment_F_Risk_Assessment_Interpretation This table contains the risk assessment risk score interpretation codes, coding displays, and system IDs.
RiskAssessment_F_Risk_Assessment_Interpretation_Source_Coding This table contains the risk assessment risk score interpretation source codes, source coding displays, and source coding system IDs.

Field Definitions

RiskAssessment_F_Risk_Assessment

Field Definition Data Type
risk_assessment_id The unique ID for the risk score. varchar(200)
consumer_id The ID of the consumer associated with the risk assessment. varchar(200)
patient_population_id The unique ID of the populations for a client (for example, the registries population and EDW population). varchar(200)
patient_id The ID of the patient associated with the risk assessment. varchar(200)
value_numeric The risk score value. float
assessed_at_dt_tm The date and time when the risk assessment was first acknowledged and recorded. timestampTz
type_text The textual description that describes the entire type codeable concept. varchar(200)
type_code The specific code for the risk score type. varchar(200)
type_coding_display The type of risk score. varchar(200)
type_coding_system_id The risk score type code system (for example, SNOMED CT), usually expressed using an OID. varchar(200)
condition_text The textual description that describes the entire condition codeable concept. varchar(200)
condition_code The specific code for the risk score condition. varchar(200)
condition_coding_display Identifies the condition assessed by the risk score. varchar(200)
condition_coding_system_id The risk score condition code system (for example, SNOMED CT), usually expressed using an OID. varchar(200)
method_text The textual description that describes the entire method codeable concept. varchar(200)
method_code The specific code for the risk score method. varchar(200)
method_coding_display The algorithm, process, or mechanism used to evaluate the risk. varchar(200)
method_coding_system_id The risk score method code system (for example, SNOMED CT), usually expressed using an OID. varchar(200)
interpretation_text The textual description that describes the entire interpretation codeable concept. varchar(200)
interpretation_code The specific code for the risk score interpretation. varchar(200)
interpretation_coding_display The categorization of the measurement value that indicates its normalcy, for example, abnormal, normal, high, low, or critical. varchar(200)
interpretation_coding_system_id The risk score interpretation code system (for example, SNOMED CT), usually expressed using an OID. varchar(200)
interpretation_source_code The specific source code for the risk score interpretation. varchar(200)
interpretation_source_coding_display The categorization of the measurement value that indicates normalcy, for example, abnormal, normal, high, low, or critical. varchar(200)
interpretation_source_coding_system_id The risk score interpretation source code system (for example, SNOMED CT), usually expressed using an OID. varchar(200)

RiskAssessment_F_Risk_Assessment_Factor

Field Definition Data Type
risk_assessment_id The unique ID for the risk score. varchar(200)
factor_name A name that represents the factor. varchar(200)
factor_value The value of the factor, which may be a representation of a number, Boolean, string, or any other simple data type. varchar(200)

RiskAssessment_F_Risk_Assessment_Basis

Field Definition Data Type
risk_assessment_id The unique ID for the risk score. varchar(200)
basis_id The ID of the referenced resource. varchar(200)
basis_kind The type of the basis considered for the assessment. varchar(200)

RiskAssessment_F_Risk_Assessment_Type

Field Definition Data Type
risk_assessment_id The unique ID for the risk score. varchar(200)
type_code The specific code for the risk score type. varchar(200)
type_coding_display The type of risk score. varchar(200)
type_coding_system_id The risk score type code system (for example, SNOMED CT), usually expressed using an OID. varchar(200)

RiskAssessment_F_Risk_Assessment_Condition

Field Definition Data Type
risk_assessment_id The unique ID for the risk score. varchar(200)
condition_code The specific code for the risk score condition. varchar(200)
condition_coding_display Identifies the condition assessed by the risk score. varchar(200)
condition_coding_system_id The risk score condition code system (for example, SNOMED CT), usually expressed using an OID. varchar(200)

RiskAssessment_F_Risk_Assessment_Method

Field Definition Data Type
risk_assessment_id The unique ID for the risk score. varchar(200)
method_code The specific code for the risk score method. varchar(200)
method_coding_display The algorithm, process, or mechanism used to evaluate the risk. varchar(200)
method_coding_system_id The risk score method code system (for example, SNOMED CT), usually expressed using an OID. varchar(200)

RiskAssessment_F_Risk_Assessment_Interpretation

Field Definition Data Type
risk_assessment_id The unique ID for the risk score. varchar(200)
interpretation_code The specific code for the risk score interpretation. varchar(200)
interpretation_coding_display The categorization of the measurement value that indicates its normalcy, for example, abnormal, normal, high, low, or critical. varchar(200)
interpretation_coding_system_id The risk score interpretation code system (for example, SNOMED CT), usually expressed using an OID. varchar(200)

RiskAssessment_F_Risk_Assessment_Interpretation_Source_Coding

Field Definition Data Type
risk_assessment_id The unique ID for the risk score. varchar(200)
interpretation_source_code The specific source code for the risk score interpretation. varchar(200)
interpretation_source_coding_display The categorization of the measurement value that indicates normalcy, for example, abnormal, normal, high, low, or critical. varchar(200)
interpretation_source_coding_system_id The risk score interpretation source code system (for example, SNOMED CT), usually expressed using an OID. varchar(200)