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_Child_Factor | This table contains the risk assessment child 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) |
| factor_sequence | The sequence for the factor. | int |
| Field | Definition | Data Type |
|---|---|---|
| risk_assessment_id | The unique ID for the risk score. | varchar(200) |
| parent_factor_name | A name that represents the parent factor. | varchar(200) |
| parent_factor_sequence | The sequence for the parent factor. | varchar(200) |
| child_factor_name | A name that represents the child factor. | varchar(200) |
| child_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) |
| child_factor_sequnce | The sequence for the child factor. | int |
| 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) |