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 | NCK_CONSTANT | string | varchar(max) | yes | |
| 3 | NCK_INTERMITTENT | string | varchar(max) | yes | |
| 4 | NCK_MILD | string | varchar(max) | yes | |
| 5 | NCK_MODERATE | string | varchar(max) | yes | |
| 6 | NCK_SEVERE | string | varchar(max) | yes | |
| 7 | NCK_STIFF | string | varchar(max) | yes | |
| 8 | NCK_NO_RADIATION | string | varchar(max) | yes | |
| 9 | NCK_RADIATES_INTO_L_R | string | varchar(max) | yes | |
| 10 | NCK_SHOULDERS | string | varchar(max) | yes | |
| 11 | NCK_ARMS | string | varchar(max) | yes | |
| 12 | NCK_FOREARMS | string | varchar(max) | yes | |
| 13 | NCK_HANDS | string | varchar(max) | yes | |
| 14 | NCK_WEAKNESS | string | varchar(max) | yes | |
| 15 | NCK_NUMBNESS | string | varchar(max) | yes | |
| 16 | NCK_PARESTHESIA | string | varchar(max) | yes | |
| 17 | NCK_DISTRIBUTION | string | varchar(max) | yes | |
| 18 | NCK_AGG_FACT_SITTING | string | varchar(max) | yes | |
| 19 | NCK_AGG_FACT_STANDING | string | varchar(max) | yes | |
| 20 | NCK_AGG_FACT_WALKING | string | varchar(max) | yes | |
| 21 | NCK_AGG_FACT_BENDING | string | varchar(max) | yes | |
| 22 | NCK_AGG_FACT_LIFTING | string | varchar(max) | yes | |
| 23 | NCK_AGG_FACT_MAINTAINING_ONE_POSITION_TOO_LONG | string | varchar(max) | yes | |
| 24 | NCK_AGG_FACT_TRANSITIONAL_MOVEMENTS | string | varchar(max) | yes | |
| 25 | NCK_ALV_FACT_LOCAL_HEAT | string | varchar(max) | yes | |
| 26 | NCK_ALV_FACT_ICE | string | varchar(max) | yes | |
| 27 | NCK_ALV_FACT_MASSAGE | string | varchar(max) | yes | |
| 28 | NCK_ALV_FACT_STRETCHING | string | varchar(max) | yes | |
| 29 | NCK_ALV_FACT_PAIN_MEDS | string | varchar(max) | yes | |
| 30 | NCK_ALV_FACT_MANIPULATION | string | varchar(max) | yes | |
| 31 | NCK_ALV_FACT_LAYING_DOWN | string | varchar(max) | yes | |
| 32 | NCK_ALV_FACT_TXT_OTHER | string | varchar(max) | yes | |
| 33 | NCK_COUR_PAST_TXT_WEEKS | string | varchar(max) | yes | |
| 34 | NCK_COUR_PAST_TXT_DAYS | string | varchar(max) | yes | |
| 35 | NCK_COUR_PAST_NO_CHANGE | string | varchar(max) | yes | |
| 36 | NCK_COUR_PAST_SLIGHTLY_IMPROVEMENT | string | varchar(max) | yes | |
| 37 | NCK_COUR_PAST_GETTING_WORSE_SINCE_ACCIDENT | string | varchar(max) | yes | |
| 38 | NCK_CONSTANT_COMMENT | string | varchar(max) | yes | |
| 39 | NCK_INTERMITTENT_COMMENT | string | varchar(max) | yes | |
| 40 | NCK_MILD_COMMENT | string | varchar(max) | yes | |
| 41 | NCK_MODERATE_COMMENT | string | varchar(max) | yes | |
| 42 | NCK_SEVERE_COMMENT | string | varchar(max) | yes | |
| 43 | NCK_STIFF_COMMENT | string | varchar(max) | yes | |
| 44 | NCK_NO_RADIATION_COMMENT | string | varchar(max) | yes | |
| 45 | NCK_RADIATES_INTO_L_R_COMMENT | string | varchar(max) | yes | |
| 46 | NCK_SHOULDERS_COMMENT | string | varchar(max) | yes | |
| 47 | NCK_ARMS_COMMENT | string | varchar(max) | yes | |
| 48 | NCK_FOREARMS_COMMENT | string | varchar(max) | yes | |
| 49 | NCK_HANDS_COMMENT | string | varchar(max) | yes | |
| 50 | NCK_WEAKNESS_COMMENT | string | varchar(max) | yes | |
| 51 | NCK_NUMBNESS_COMMENT | string | varchar(max) | yes | |
| 52 | NCK_PARESTHESIA_COMMENT | string | varchar(max) | yes | |
| 53 | NCK_DISTRIBUTION_COMMENT | string | varchar(max) | yes | |
| 54 | NCK_AGG_FACT_SITTING_COMMENT | string | varchar(max) | yes | |
| 55 | NCK_AGG_FACT_STANDING_COMMENT | string | varchar(max) | yes | |
| 56 | NCK_AGG_FACT_WALKING_COMMENT | string | varchar(max) | yes | |
| 57 | NCK_AGG_FACT_BENDING_COMMENT | string | varchar(max) | yes | |
| 58 | NCK_AGG_FACT_LIFTING_COMMENT | string | varchar(max) | yes | |
| 59 | NCK_AGG_FACT_MAINTAINING_ONE_POSITION_TOO_LONG_COMMENT | string | varchar(max) | yes | |
| 60 | NCK_AGG_FACT_TRANSITIONAL_MOVEMENTS_COMMENT | string | varchar(max) | yes | |
| 61 | NCK_ALV_FACT_LOCAL_HEAT_COMMENT | string | varchar(max) | yes | |
| 62 | NCK_ALV_FACT_ICE_COMMENT | string | varchar(max) | yes | |
| 63 | NCK_ALV_FACT_MASSAGE_COMMENT | string | varchar(max) | yes | |
| 64 | NCK_ALV_FACT_STRETCHING_COMMENT | string | varchar(max) | yes | |
| 65 | NCK_ALV_FACT_PAIN_MEDS_COMMENT | string | varchar(max) | yes | |
| 66 | NCK_ALV_FACT_MANIPULATION_COMMENT | string | varchar(max) | yes | |
| 67 | NCK_ALV_FACT_LAYING_DOWN_COMMENT | string | varchar(max) | yes | |
| 68 | NCK_COUR_PAST_NO_CHANGE_COMMENT | string | varchar(max) | yes | |
| 69 | NCK_COUR_PAST_SLIGHTLY_IMPROVEMENT_COMMENT | string | varchar(max) | yes | |
| 70 | NCK_COUR_PAST_GETTING_WORSE_SINCE_ACCIDENT_COMMENT | string | varchar(max) | yes |