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 | KNEE_LT_CONSTANT | string | varchar(5) | yes | |
| 3 | KNEE_LT_INTERMITTENT | string | varchar(5) | yes | |
| 4 | KNEE_LT_MILD | string | varchar(5) | yes | |
| 5 | KNEE_LT_MODERATE | string | varchar(5) | yes | |
| 6 | KNEE_LT_SEVERE | string | varchar(5) | yes | |
| 7 | KNEE_LT_STIFF | string | varchar(5) | yes | |
| 8 | KNEE_LT_INC_PAIN_STANDING | string | varchar(5) | yes | |
| 9 | KNEE_LT_INC_PAIN_WALKING | string | varchar(5) | yes | |
| 10 | KNEE_LT_INC_PAIN_STAIR_CLIMBING | string | varchar(5) | yes | |
| 11 | KNEE_LT_INC_PAIN_SQUATTING | string | varchar(5) | yes | |
| 12 | KNEE_LT_INC_PAIN_RUNNING | string | varchar(5) | yes | |
| 13 | KNEE_LT_INC_PAIN_KEEPING_KNEE_FLEXED_WHILE_SITTING | string | varchar(5) | yes | |
| 14 | KNEE_LT_BUCKLES | string | varchar(5) | yes | |
| 15 | KNEE_LT_LOCKS | string | varchar(5) | yes | |
| 16 | KNEE_LT_COUR_PAST_WEEKS | string | varchar(5) | yes | |
| 17 | KNEE_LT_COUR_PAST_DAYS | string | varchar(5) | yes | |
| 18 | KNEE_LT_COUR_PAST_NO_CHANGE | string | varchar(5) | yes | |
| 19 | KNEE_LT_COUR_PAST_SLIGHT_IMPROVEMENT | string | varchar(5) | yes | |
| 20 | KNEE_LT_COUR_PAST_GETTING_WORSE_SINCE_ACCIDENT | string | varchar(5) | yes | |
| 21 | KNEE_LT_CONSTANT_COMMENT | string | varchar(5) | yes | |
| 22 | KNEE_LT_INTERMITTENT_COMMENT | string | varchar(5) | yes | |
| 23 | KNEE_LT_MILD_COMMENT | string | varchar(5) | yes | |
| 24 | KNEE_LT_MODERATE_COMMENT | string | varchar(5) | yes | |
| 25 | KNEE_LT_SEVERE_COMMENT | string | varchar(5) | yes | |
| 26 | KNEE_LT_STIFF_COMMENT | string | varchar(5) | yes | |
| 27 | KNEE_LT_INC_PAIN_STANDING_COMMENT | string | varchar(5) | yes | |
| 28 | KNEE_LT_INC_PAIN_WALKING_COMMENT | string | varchar(5) | yes | |
| 29 | KNEE_LT_INC_PAIN_STAIR_CLIMBING_COMMENT | string | varchar(5) | yes | |
| 30 | KNEE_LT_INC_PAIN_SQUATTING_COMMENT | string | varchar(5) | yes | |
| 31 | KNEE_LT_INC_PAIN_RUNNING_COMMENT | string | varchar(5) | yes | |
| 32 | KNEE_LT_INC_PAIN_KEEPING_KNEE_FLEXED_WHILE_SITTING_COMMENT | string | varchar(5) | yes | |
| 33 | KNEE_LT_BUCKLES_COMMENT | string | varchar(5) | yes | |
| 34 | KNEE_LT_LOCKS_COMMENT | string | varchar(5) | yes | |
| 35 | KNEE_LT_COUR_PAST_WEEKS_COMMENT | string | varchar(5) | yes | |
| 36 | KNEE_LT_COUR_PAST_DAYS_COMMENT | string | varchar(5) | yes | |
| 37 | KNEE_LT_COUR_PAST_NO_CHANGE_COMMENT | string | varchar(5) | yes | |
| 38 | KNEE_LT_COUR_PAST_SLIGHT_IMPROVEMENT_COMMENT | string | varchar(5) | yes | |
| 39 | KNEE_LT_COUR_PAST_GETTING_WORSE_SINCE_ACCIDENT_COMMENT | string | varchar(5) | yes | |
| 40 | KNEE_RT_BUCKLES | string | varchar(5) | yes |