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 | BCK_CONSTANT | string | varchar(5) | yes | |
| 3 | BCK_INTERMITTENT | string | varchar(5) | yes | |
| 4 | BCK_MILD | string | varchar(5) | yes | |
| 5 | BCK_MODERATE | string | varchar(5) | yes | |
| 6 | BCK_SEVERE | string | varchar(5) | yes | |
| 7 | BCK_STIFF | string | varchar(5) | yes | |
| 8 | BCK_NO_RADIATION | string | varchar(5) | yes | |
| 9 | BCK_RADIATES_INTO_L_R | string | varchar(5) | yes | |
| 10 | BCK_SHOULDERS | string | varchar(5) | yes | |
| 11 | BCK_ARMS | string | varchar(5) | yes | |
| 12 | BCK_FOREARMS | string | varchar(5) | yes | |
| 13 | BCK_HANDS | string | varchar(5) | yes | |
| 14 | BCK_WEAKNESS | string | varchar(5) | yes | |
| 15 | BCK_NUMBNESS | string | varchar(5) | yes | |
| 16 | BCK_PARESTHESIA | string | varchar(5) | yes | |
| 17 | BCK_DISTRIBUTION | string | varchar(5) | yes | |
| 18 | BCK_AGG_FACT_SITTING | string | varchar(5) | yes | |
| 19 | BCK_AGG_FACT_STANDING | string | varchar(5) | yes | |
| 20 | BCK_AGG_FACT_WALKING | string | varchar(5) | yes | |
| 21 | BCK_AGG_FACT_BENDING | string | varchar(5) | yes | |
| 22 | BCK_AGG_FACT_LIFTING | string | varchar(5) | yes | |
| 23 | BCK_AGG_FACT_MAINTAINING_ONE_POSITION_TOO_LONG | string | varchar(5) | yes | |
| 24 | BCK_AGG_FACT_TRANSITIONAL_MOVEMENTS | string | varchar(5) | yes | |
| 25 | BCK_ALV_FACT_LOCAL_HEAT | string | varchar(5) | yes | |
| 26 | BCK_ALV_FACT_ICE | string | varchar(5) | yes | |
| 27 | BCK_ALV_FACT_MASSAGE | string | varchar(5) | yes | |
| 28 | BCK_ALV_FACT_STRETCHING | string | varchar(5) | yes | |
| 29 | BCK_ALV_FACT_PAIN_MEDS | string | varchar(5) | yes | |
| 30 | BCK_ALV_FACT_MANIPULATION | string | varchar(5) | yes | |
| 31 | BCK_ALV_FACT_LAYING_DOWN | string | varchar(5) | yes | |
| 32 | BCK_ALV_FACT_TXT_OTHER | string | varchar(5) | yes | |
| 33 | BCK_COUR_PAST_TXT_WEEKS | string | varchar(5) | yes | |
| 34 | BCK_COUR_PAST_TXT_DAYS | string | varchar(5) | yes | |
| 35 | BCK_COUR_PAST_NO_CHANGE | string | varchar(5) | yes | |
| 36 | BCK_COUR_PAST_SLIGHTLY_IMPROVEMENT | string | varchar(5) | yes | |
| 37 | BCK_COUR_PAST_GETTING_WORSE_SINCE_ACCIDENT | string | varchar(5) | yes | |
| 38 | BCK_CONSTANT_COMMENT | string | varchar(5) | yes | |
| 39 | BCK_INTERMITTENT_COMMENT | string | varchar(5) | yes | |
| 40 | BCK_MILD_COMMENT | string | varchar(5) | yes | |
| 41 | BCK_MODERATE_COMMENT | string | varchar(5) | yes | |
| 42 | BCK_SEVERE_COMMENT | string | varchar(5) | yes | |
| 43 | BCK_STIFF_COMMENT | string | varchar(5) | yes | |
| 44 | BCK_NO_RADIATION_COMMENT | string | varchar(5) | yes | |
| 45 | BCK_RADIATES_INTO_L_R_COMMENT | string | varchar(5) | yes | |
| 46 | BCK_SHOULDERS_COMMENT | string | varchar(5) | yes | |
| 47 | BCK_ARMS_COMMENT | string | varchar(5) | yes | |
| 48 | BCK_FOREARMS_COMMENT | string | varchar(5) | yes | |
| 49 | BCK_HANDS_COMMENT | string | varchar(5) | yes | |
| 50 | BCK_WEAKNESS_COMMENT | string | varchar(5) | yes | |
| 51 | BCK_NUMBNESS_COMMENT | string | varchar(5) | yes | |
| 52 | BCK_PARESTHESIA_COMMENT | string | varchar(5) | yes | |
| 53 | BCK_DISTRIBUTION_COMMENT | string | varchar(5) | yes | |
| 54 | BCK_AGG_FACT_SITTING_COMMENT | string | varchar(5) | yes | |
| 55 | BCK_AGG_FACT_STANDING_COMMENT | string | varchar(5) | yes | |
| 56 | BCK_AGG_FACT_WALKING_COMMENT | string | varchar(5) | yes | |
| 57 | BCK_AGG_FACT_BENDING_COMMENT | string | varchar(5) | yes | |
| 58 | BCK_AGG_FACT_LIFTING_COMMENT | string | varchar(5) | yes | |
| 59 | BCK_AGG_FACT_MAINTAINING_ONE_POSITION_TOO_LONG_COMMENT | string | varchar(5) | yes | |
| 60 | BCK_AGG_FACT_TRANSITIONAL_MOVEMENTS_COMMENT | string | varchar(5) | yes | |
| 61 | BCK_ALV_FACT_LOCAL_HEAT_COMMENT | string | varchar(5) | yes | |
| 62 | BCK_ALV_FACT_ICE_COMMENT | string | varchar(5) | yes | |
| 63 | BCK_ALV_FACT_MASSAGE_COMMENT | string | varchar(5) | yes | |
| 64 | BCK_ALV_FACT_STRETCHING_COMMENT | string | varchar(5) | yes | |
| 65 | BCK_ALV_FACT_PAIN_MEDS_COMMENT | string | varchar(5) | yes | |
| 66 | BCK_ALV_FACT_MANIPULATION_COMMENT | string | varchar(5) | yes | |
| 67 | BCK_ALV_FACT_LAYING_DOWN_COMMENT | string | varchar(5) | yes | |
| 68 | BCK_COUR_PAST_NO_CHANGE_COMMENT | string | varchar(5) | yes | |
| 69 | BCK_COUR_PAST_SLIGHTLY_IMPROVEMENT_COMMENT | string | varchar(5) | yes | |
| 70 | BCK_COUR_PAST_GETTING_WORSE_SINCE_ACCIDENT_COMMENT | string | varchar(5) | yes |