Data Export - Outcomes

Outcomes Export

Generated by the Bulk Data Export system

This file contains a row for each episode of care, per scale, containing the intake value, the current value, and a variety of indicators of treatment progress including the delta from intake and trend in treatment.


Property Name Field Type Notes
id Id identifier
patient_id Patient Id identifier
patient_first_name Patient First Name string
patient_last_name Patient Last Name string
organization_id Organization Id identifer
organization_name Organization Name string
practitioner_id Practitioner Id identifier
practitioner_first_name Practitioner First Name string
practitioner_last_name Practitioner Last Name string
care_episode_id Episode of Care Id identifier
diagnostic_report_id Diagnostic Report Id identifier
user_id Respondent Id identifier User who took the assessment
user_first_name Respondent First Name string
user_last_name Respondent Last Name string
questionnaire_id Questionnaire Id identifier
questionnaire_mnemonic Questionnaire Unique Code string
questionnaire_name Questionnaire Name string
score_domain Score Type raw | normed | interpreted
population_id Population Id identifier Only used when score_domain is "normed", and represents which population the scale is normed on
population_name Population name string Only used when score_domain is "normed", and represents which population the scale is normed on
treatment_start_date Treatment Start Date datetime The start of the care episode. This may be earlier than the first measurement if the respondent did not complete a scale at the start of treatment
days_between_treatment_start_and_baseline Days Between Treatment Start and Baseline integer The number of calendar days between when treatment started and when a baseline measure was filled for this scale
baseline_date Baseline Date datetime The date the first baseline measure was completed for this scale
baseline_severity_category Baseline Severity Category not_specified | mild | moderate | severe | invalid | not_supported The clinical value of the baseline measurement
baseline_severity Baseline Severity string Depends on scale - e.g. 'Mild Depression'
baseline_value Baseline Value number The numerical raw value for the scale
encounter_target_date Encounter Date datetime The encounter date for this measurement
session_number Session Number integer The measurement number for this measurement
days_since_treatment_start Days Since Treatment Start integer Calendar days between treatment start and this measure administration
weeks_since_treatment_start Weeks Since Treatment Start integer Number of rounded-up weeks between treatment start and this measurement
last_measurement_of_week Is Last Measurement of Week? boolean true if this measurement is the last measurement of this particular week. This can be used to get a unique measurement per patient per week of care
months_since_treatment_start Months Since Treatment Start integer Number of elapsed calendar months between treatment start and this measurement
last_measurement_of_month Is Last Measurement of Month? boolean true if this measurement is the last measurement taken in that month of treatment
is_first_measurement Is First Measurement? boolean true if this is the first time this scale has been taken by this user
is_last_measurement Is Last Measurement boolean true if this is the last measurement on file for this user and episode of care
is_first_of_severity Is First Of Severity? boolean true if this is the first time this severity has been recorded. E.g. if a patient is severe and moves to 'moderate', the first time they register moderate this column will be 'true'
is_first_of_trend Is First of Trend? boolean true if this is the first measurement where a change of trend in treatment has been observed
value Value number the numerical score for this administration
severity_category Severity Category not_specified | mild | moderate | severe | invalid | not_supported the severity category for this administration
severity Severity string The severity for this value, e.g. 'Mild Depression'
trend Trend improving | stable | declining | not_supported Whether the scale is showing a trend according to the psychometrics of the instrument
delta Delta number The numerical change between baseline and this measurement
severity_better_than_intake Severity Better Than Intake? boolean Whether the severity at the current measurement is better than that of intake
severity_worse_than_intake Severity Worse Than Intake? boolean Whether the severity at the current measurement is worse than that of intake