01Relates to the patient
ENCOUNTER_ID matches EMR_ENCOUNTERS.ENCOUNTER_ID on a row of EMR_ENCOUNTERS that relates to the patient
Single-patient export: the patient's rows.
02References
ENCOUNTER_ID→EMR_ENCOUNTERS.ENCOUNTER_ID
03Columns
| # | Column | Type | Source type | Null | Notes |
|---|---|---|---|---|---|
| 1 | ENCOUNTER_ID PK | integer | int | no | |
| 2 | SHD_LT_CONSTANT | string | varchar(max) | yes | |
| 3 | SHD_LT_INTERMITTENT | string | varchar(max) | yes | |
| 4 | SHD_LT_MILD | string | varchar(max) | yes | |
| 5 | SHD_LT_MODERATE | string | varchar(max) | yes | |
| 6 | SHD_LT_SEVERE | string | varchar(max) | yes | |
| 7 | SHD_LT_STIFF | string | varchar(max) | yes | |
| 8 | SHD_LT_INC_PAIN_RAISING_ARM_OVER_HEAD | string | varchar(max) | yes | |
| 9 | SHD_LT_INC_PAIN_REACHING_BEHIND_BACK | string | varchar(max) | yes | |
| 10 | SHD_LT_INC_PAIN_CARRYING_OR_LIFTING_THINGS | string | varchar(max) | yes | |
| 11 | SHD_LT_COUR_PAST_WEEKS | string | varchar(max) | yes | |
| 12 | SHD_LT_COUR_PAST_NO_CHANGE | string | varchar(max) | yes | |
| 13 | SHD_LT_COUR_PAST_GETTING_BETTER | string | varchar(max) | yes | |
| 14 | SHD_LT_COUR_PAST_GETTING_WORSE_SINCE_ACCIDENT | string | varchar(max) | yes | |
| 15 | SHD_LT_COUR_PAST_DAYS | string | varchar(max) | yes | |
| 16 | SHD_LT_CONSTANT_COMMENT | string | varchar(max) | yes | |
| 17 | SHD_LT_INTERMITTENT_COMMENT | string | varchar(max) | yes | |
| 18 | SHD_LT_MILD_COMMENT | string | varchar(max) | yes | |
| 19 | SHD_LT_MODERATE_COMMENT | string | varchar(max) | yes | |
| 20 | SHD_LT_SEVERE_COMMENT | string | varchar(max) | yes | |
| 21 | SHD_LT_STIFF_COMMENT | string | varchar(max) | yes | |
| 22 | SHD_LT_INC_PAIN_RAISING_ARM_OVER_HEAD_COMMENT | string | varchar(max) | yes | |
| 23 | SHD_LT_INC_PAIN_REACHING_BEHIND_BACK_COMMENT | string | varchar(max) | yes | |
| 24 | SHD_LT_INC_PAIN_CARRYING_OR_LIFTING_THINGS_COMMENT | string | varchar(max) | yes | |
| 25 | SHD_LT_COUR_PAST_WEEKS_COMMENT | string | varchar(max) | yes | |
| 26 | SHD_LT_COUR_PAST_DAYS_COMMENT | string | varchar(max) | yes | |
| 27 | SHD_LT_COUR_PAST_NO_CHANGE_COMMENT | string | varchar(max) | yes | |
| 28 | SHD_LT_COUR_PAST_GETTING_BETTER_COMMENT | string | varchar(max) | yes | |
| 29 | SHD_LT_COUR_PAST_GETTING_WORSE_SINCE_ACCIDENT_COMMENT | string | varchar(max) | yes | |
| 30 | SHD_RT_CONSTANT | string | varchar(max) | yes | |
| 31 | SHD_RT_INTERMITTENT | string | varchar(max) | yes | |
| 32 | SHD_RT_MILD | string | varchar(max) | yes | |
| 33 | SHD_RT_MODERATE | string | varchar(max) | yes | |
| 34 | SHD_RT_SEVERE | string | varchar(max) | yes | |
| 35 | SHD_RT_STIFF | string | varchar(max) | yes | |
| 36 | SHD_RT_INC_PAIN_RAISING_ARM_OVER_HEAD | string | varchar(max) | yes | |
| 37 | SHD_RT_INC_PAIN_REACHING_BEHIND_BACK | string | varchar(max) | yes | |
| 38 | SHD_RT_INC_PAIN_CARRYING_OR_LIFTING_THINGS | string | varchar(max) | yes | |
| 39 | SHD_RT_COUR_PAST_WEEKS | string | varchar(max) | yes | |
| 40 | SHD_RT_COUR_PAST_DAYS | string | varchar(max) | yes | |
| 41 | SHD_RT_COUR_PAST_NO_CHANGE | string | varchar(max) | yes | |
| 42 | SHD_RT_COUR_PAST_GETTING_BETTER | string | varchar(max) | yes | |
| 43 | SHD_RT_COUR_PAST_GETTING_WORSE_SINCE_ACCIDENT | string | varchar(max) | yes | |
| 44 | SHD_RT_CONSTANT_COMMENT | string | varchar(max) | yes | |
| 45 | SHD_RT_INTERMITTENT_COMMENT | string | varchar(max) | yes | |
| 46 | SHD_RT_MILD_COMMENT | string | varchar(max) | yes | |
| 47 | SHD_RT_MODERATE_COMMENT | string | varchar(max) | yes | |
| 48 | SHD_RT_SEVERE_COMMENT | string | varchar(max) | yes | |
| 49 | SHD_RT_STIFF_COMMENT | string | varchar(max) | yes | |
| 50 | SHD_RT_INC_PAIN_RAISING_ARM_OVER_HEAD_COMMENT | string | varchar(max) | yes | |
| 51 | SHD_RT_INC_PAIN_REACHING_BEHIND_BACK_COMMENT | string | varchar(max) | yes | |
| 52 | SHD_RT_INC_PAIN_CARRYING_OR_LIFTING_THINGS_COMMENT | string | varchar(max) | yes | |
| 53 | SHD_RT_COUR_PAST_WEEKS_COMMENT | string | varchar(max) | yes | |
| 54 | SHD_RT_COUR_PAST_DAYS_COMMENT | string | varchar(max) | yes | |
| 55 | SHD_RT_COUR_PAST_NO_CHANGE_COMMENT | string | varchar(max) | yes | |
| 56 | SHD_RT_COUR_PAST_GETTING_BETTER_COMMENT | string | varchar(max) | yes | |
| 57 | SHD_RT_COUR_PAST_GETTING_WORSE_SINCE_ACCIDENT_COMMENT | string | varchar(max) | yes |