This dictionary documents the expected restricted inputs and derived variables used by VR_ICU.do and VR Consort Diagram.qmd. Participant-level data are not included in this public repository.
Review status values:
verified: documented directly from the analysis code.needs_review: inferred from code context and should be checked against the restricted source workbook before reuse.
| File | Expected location | Role | Public status |
|---|---|---|---|
ICU_patient_database.xlsx |
data/ICU_patient_database.xlsx |
Patient-level study database imported by Stata from sheet data |
Restricted, not committed |
ICU_selection_database.xlsx |
data/ICU_selection_database.xlsx |
Screening, consent, participation, and VR encounter database imported by Stata from sheet data |
Restricted, not committed |
hr_data.xlsx |
data/hr_data.xlsx |
Heart rate and heart rate variability summaries imported by Stata from sheet Sheet1 |
Restricted, not committed |
db_for_consort.dta |
outputs/stata/db_for_consort.dta |
Derived Stata file created by VR_ICU.do and consumed by Quarto |
Generated, not committed |
| Variable | Source file | Role | Review status |
|---|---|---|---|
patient_id |
Patient and selection workbooks | Merge key and study identifier used by analysis | verified |
gender |
Patient workbook | Source for derived female indicator |
verified |
consented |
Selection workbook | Source for derived consent indicator |
verified |
date |
Selection workbook | Study encounter date; used by Quarto to mark one incomplete survey reason | verified |
race, ethnicity |
Patient workbook | Encoded as analysis race and ethnicity variables | verified |
vr_history |
Patient workbook | Source for prior VR use indicator | verified |
medical_history |
Patient workbook | Free text searched for comorbidity indicators | needs_review |
icu_admission |
Patient workbook | Recoded into admission reason categories | verified |
resp_support |
Patient workbook | Encoded as respiratory support | verified |
vr_selection |
Selection workbook | Recoded into VR content category and original selection factor | verified |
pre_vas_q1, post_vas_q1 |
Selection workbook | Overall well-being before and after VR | verified |
pre_vas_q2, post_vas_q2 |
Selection workbook | Anxiety before and after VR | verified |
pre_vas_q3, post_vas_q3 |
Selection workbook | Pain before and after VR | verified |
pre_eda_av, post_eda_av |
Selection workbook | EDA data quality before and after VR | verified |
pre_ecg_av, post_ecg_av |
Selection workbook | ECG data quality before and after VR | verified |
pre_ppg_av, post_ppg_av |
Selection workbook | PPG data quality before and after VR | verified |
reason_to_refuse |
Selection workbook | Source for decline reason categories | verified |
pre_hrv, end_hrv |
HR workbook | HRV stress index before and at end of VR | verified |
pre_hr, end_hr |
HR workbook | Mean heart rate before and at end of VR | verified |
| Variable | Definition / derivation | Review status |
|---|---|---|
id |
Row-order identifier generated after each workbook import | verified |
female |
1 for source gender == "f", 0 for gender == "m" |
verified |
consent |
1 for consented == "yes", 0 for consented == "no" |
verified |
race |
Encoded from cleaned source race string | verified |
ethnicity |
Encoded from source ethnicity string | verified |
prior_vr |
Binary prior virtual-reality use indicator from vr_history |
verified |
dm, afib, copd, chf, osa, ckd, dvt, cirrhosis, malig |
Comorbidity indicators generated by string searches of medical_history |
needs_review |
reason_admit |
Encoded admission-reason category after recoding icu_admission |
verified |
respiratory_supp |
Encoded respiratory support category from resp_support |
verified |
eyeglasses |
Binary eyeglasses indicator from source glasses field | verified |
hearing |
Encoded hearing impairment field | verified |
vr_category |
Recoded VR content category: nature scene, travel, or synthetic environment | verified |
vr_sel |
Encoded original VR selection | verified |
vas_q1_1, vas_q1_2 |
Renamed pre/post overall well-being scores | verified |
vas_q2_1, vas_q2_2 |
Renamed pre/post anxiety scores | verified |
vas_q3_1, vas_q3_2 |
Renamed pre/post pain scores | verified |
eda_av_1, eda_av_2, ecg_av_1, ecg_av_2, ppg_av_1, ppg_av_2 |
Encoded pre/post physiologic data-quality indicators | verified |
decline_reason, reason_declined |
Encoded and text forms of reason for declining participation | verified |
participate, didnt_participate, didnt_finish |
Participation and flow-diagram status variables | verified |
change_vas_q1, change_vas_q2, change_vas_q3 |
Pre-post score changes for well-being, anxiety, and pain | verified |
time, pre, post |
Temporary graphing variables for pre/post visualization | verified |
vas_q1_, vas_q2_, vas_q3_ |
Reshaped long-form visual analog scale fields | verified |
change_hrv, change_hr |
Pre-post HRV and heart-rate changes | verified |
hrv_1, hrv_2, hr_1, hr_2 |
Renamed pre/end HRV and HR fields for paired visualization | verified |
no_survey |
Quarto-derived flow-diagram reason for one incomplete survey assessment | verified |
- Do not commit participant-level data, derived
.dtafiles, generated tables, logs, or figures. - The expected local data files are ignored by
.gitignore. - Before sharing any output, confirm it is aggregate, deidentified, and consistent with the IRB-approved data-use context.