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.
Property | Value |
---|---|
Header Record | Yes |
Field Delimiter | Comma |
Record Delimiter | CR/LF |
Character Encoding | UTF-8 |
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 | 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) |
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) |
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) |
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) |
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) |
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) |
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) |
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) |