-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathintro.qmd
More file actions
163 lines (82 loc) · 5.32 KB
/
intro.qmd
File metadata and controls
163 lines (82 loc) · 5.32 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
# Introduction {.unnumbered}
This is a book created from markdown and executable code.
This project contains the works for TSA shoulder datasets. Here are the details for each dataset. Interested varaibles are labeled in italic and bold.
## Base data
This tab contains a list of all TSA/Reverse TSA surgeries as described above. One line for each surgery. Other variables at the time of surgery are also included.
- EMPI_DEIDENTIFIED
- **cross the tables unique id probably for shoulder not for person**, is it true?)
- Unique patient identifier that can be linked between data tables
- Categorical variable (sequence of letters and numbers)
- PATIENT_AGE
- The age of the patient at the time of surgery
- Integer variable (years)
- PATIENT_GENDER
- Indicator of patient-reported sex
- Categorical variable (male or female)
- PRIMARY_PAYER
- Patient's insurance provider
- Categorical variable (name of insurance)
- SURGERY_TYPE
- Type of shoulder arthroplasty performed
- Categorical variable (Reverse TSA or TSA)
- SURGERY_DT
- Timestamp of surgical date
- Time variable (YYYY-mm-dd hh:mm:ss)
- BMI
- Body mass index
- Continuous variable (kg/m2)
- ADI_VALUE
- Utah Area Deprivation Index standardized value. The ADI is a proxy of socioeconomic status with values ranging from -40.0 to 139.4. Higher values indicate greater levels of deprivation. More details available here: https://www.ncbi.nlm.nih.gov/pmc/articles/PMC5019337/.
- Continuous variable (standardized value)
- ADI_QUINTILE
- Utah Area Deprivation Index score divided into categories from 1-5. Higher categories indicate greater levels of deprivation
- Ordinal variable (1-5), 20% per level
## Outcomes
This tab contains a list of all DASH or QDASH outcomes collected for the patient population contained in the "base" population. Outcomes are collected for all patients from 1/1/2016 to allow for any pre-surgical values to be pulled if needed. Outcomes are pulled from iCentra (Cerner), ROMS 1, and ROMS 2.
- EMPI_DEIDENTIFIED
- Unique patient identifier that can be linked between data tables
- Categorical variable (sequence of letters and numbers)
- OUTCOME_TYPE
- Indicates whether the full DASH or QuickDASH was collected
- Categorical variable (**DASH or QDASH**)
- **seems the similar to each other**
Potentially be a variable to adjust
- OUTCOME_DT
- Timestamp indicating when outcome was assessed
- Time variable (YYYY-mm-dd hh:mm:ss)
- OUTCOME_SCORE
- Raw value of either DASH or QuickDASH where higher scores indicate greater disability
- Integer variable (0-100)
## Pain
This tab contains a list of all pain scores collected for the patient population contained in the "base" population. Only pain scores collected at the time of the DASH/QDASH are included. Pain scores are collected for all patients from 1/1/2016 to allow for any pre-surgical values to be pulled if needed. Pain Values are pulled from iCentra (Cerner), ROMS 1, and ROMS 2
- EMPI_DEIDENTIFIED
- Unique patient identifier that can be linked between data tables
- Categorical variable (sequence of letters and numbers)
- PAIN_DT
- Timestamp indicating when patient's pain was assessed
- Time variable (YYYY-mm-dd hh:mm:ss)
- PAIN_SCORE
- Patient-reported pain via the Numeric Pain Rating Scale where 0 = no pain and 10 = worst pain imaginable
- Integer variable (1-10)
## Range of Motion
This tab contains all data points for the range of motion documented in iCentra (Cerner) for the "base" population of patients. This data is a really messy, but I'm just providing it in its raw state as requested. The data points are collected for all patients from 1/1/2016 to allow for any pre-surgical values to be pulled if needed.
- EMPI_DEIDENTIFIED
- Unique patient identifier that can be linked between data tables
- Categorical variable (sequence of letters and numbers)
- RANGE_OF_MOTION_TYPE
- Therapist description of how range of motion was assessed. This can include the plane of motion, patient positioning, or other pertinent factors
- Character variable that needs to be transformed to categorical
- RANGE_OF_MOTION_TIMESTAMP
- Timestamp indicating when range of motion was assessed
- Time variable (YYYY-mm-dd hh:mm:ss)
- RANGE_OF_MOTION_VALUE
- Therapist indicated value of the assessed range of motion. Primarily, this variable continues integers that indicate the degrees of motion assessed, but it may also contain characters that describe the type or amount of motion.
- Character variable that needs to be transformed to integer
## Authors for Biometric Practice paper
Elizabeth: [elizabeth.juarez-colunga\@cuanschutz.edu](mailto:elizabeth.juarez-colunga@cuanschutz.edu)
Stef van Buuren: [S.vanBuuren\@uu.nl](mailto:S.vanBuuren@uu.nl)
Katie Colborn: [KATHRYN.COLBORN\@CUANSCHUTZ.EDU](KATHRYN.COLBORN@CUANSCHUTZ.EDU)
Margaret Rosenfeld: [margaret.rosenfeld\@seattlechildrens.org](mailto:margaret.rosenfeld@seattlechildrens.org)
Jeremy Graber: [jeremy.graber\@cuanschutz.edu](jeremy.graber@cuanschutz.edu)
Michael John Bade: [MICHAEL.BADE\@CUANSCHUTZ.EDU](mailto:MICHAEL.BADE@CUANSCHUTZ.EDU)
Jennifer Stevens-Lapsley: