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 | Q1 | string | varchar(3) | yes | |
| 3 | Q2 | string | varchar(3) | yes | |
| 4 | Q3 | string | varchar(3) | yes | |
| 5 | Q4 | string | varchar(3) | yes | |
| 6 | Q5 | string | varchar(3) | yes | |
| 7 | Q6 | string | varchar(3) | yes | |
| 8 | TOTAL | integer | int | yes | |
| 9 | Q7A | string | varchar(3) | yes | |
| 10 | Q7B | string | varchar(3) | yes | |
| 11 | Q7 | string | varchar(3) | yes | |
| 12 | Q8 | string | varchar(3) | yes | |
| 13 | BEING_IN_A_CROWD | boolean | bit | yes | |
| 14 | STANDING_IN_A_LINE | boolean | bit | yes | |
| 15 | BEING_ALONE_AWAY | boolean | bit | yes | |
| 16 | CROSSING_A_BRIDGE | boolean | bit | yes | |
| 17 | TRAVELING | boolean | bit | yes | |
| 18 | Q9 | string | varchar(3) | yes | |
| 19 | Q10 | string | varchar(3) | yes | |
| 20 | Q11 | string | varchar(3) | yes | |
| 21 | SPEAKING_IN_PUBLIC | boolean | bit | yes | |
| 22 | EATING_IN_PUBLIC | boolean | bit | yes | |
| 23 | WRITING_WHILE | boolean | bit | yes | |
| 24 | BEING_IN | boolean | bit | yes | |
| 25 | Q12 | string | varchar(3) | yes | |
| 26 | WERE_YOU_AFRAID | boolean | bit | yes | |
| 27 | DIRTY | boolean | bit | yes | |
| 28 | CONTAMINATING_OTHERS | boolean | bit | yes | |
| 29 | FEARS | boolean | bit | yes | |
| 30 | SEXUAL | boolean | bit | yes | |
| 31 | HOARD | boolean | bit | yes | |
| 32 | RELIGIOUS | boolean | bit | yes | |
| 33 | Q13 | string | varchar(3) | yes | |
| 34 | WASHING | boolean | bit | yes | |
| 35 | COUNTING | boolean | bit | yes | |
| 36 | REPEATING | boolean | bit | yes | |
| 37 | SUPERSTITIOUS | boolean | bit | yes | |
| 38 | Q14 | string | varchar(3) | yes | |
| 39 | SERIOUS | boolean | bit | yes | |
| 40 | ASSAULT | boolean | bit | yes | |
| 41 | TERRORIST_ATTACK | boolean | bit | yes | |
| 42 | HOSTAGE | boolean | bit | yes | |
| 43 | KIDNAPPING | boolean | bit | yes | |
| 44 | FIRE | boolean | bit | yes | |
| 45 | DISCOVERING_A_BODY | boolean | bit | yes | |
| 46 | SUDDEN_DEATH | boolean | bit | yes | |
| 47 | WAR | boolean | bit | yes | |
| 48 | NATURAL_DISASTER | boolean | bit | yes | |
| 49 | Q15 | string | varchar(3) | yes | |
| 50 | DREAMS | boolean | bit | yes | |
| 51 | INTENSE_RECOLLECTIONS | boolean | bit | yes | |
| 52 | FLASHBACKS | boolean | bit | yes | |
| 53 | PHYSICAL_REACTIONS | boolean | bit | yes | |
| 54 | TOTAL_SECTION_B | integer | int | yes |