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 | ADMISSION_DATE | datetime | datetime | yes | |
| 3 | AFTERCARE_AND_RESOURCE_OPTIONS | string | varchar(4000) | yes | |
| 4 | AGENCY_1 | string | varchar(50) | yes | |
| 5 | AGENCY_2 | string | varchar(50) | yes | |
| 6 | AGENCY_3 | string | varchar(50) | yes | |
| 7 | AGENCY_4 | string | varchar(50) | yes | |
| 8 | AGENCY_NONE_INVOLVED | boolean | bit | yes | |
| 9 | AT_CLIENTS_REQUEST | boolean | bit | yes | |
| 10 | FINANCIAL_BENEFIT_STATUS | string | varchar(4000) | yes | |
| 11 | FINANCIAL_BENEFIT_STATUS_NA | boolean | bit | yes | |
| 12 | FOR_1 | string | varchar(4000) | yes | |
| 13 | FOR_2 | string | varchar(4000) | yes | |
| 14 | INDIVIDUALS_RESPONSE | string | varchar(4000) | yes | |
| 15 | LEGAL_STATUS | string | varchar(25) | yes | |
| 16 | LEGAL_STATUS_DETAILS | string | varchar(4000) | yes | |
| 17 | LEGAL_STATUS_OTHER_DESC | string | varchar(50) | yes | |
| 18 | OUTCOMES | string | varchar(4000) | yes | |
| 19 | PARTICIPATED_IN_DEVELOPMENT | string | varchar(3) | yes | |
| 20 | PROVIDED_A_COPY_PROVIDE_REASON | string | varchar(4000) | yes | |
| 21 | RD_ADDITIONAL_COMMENTS | string | varchar(4000) | yes | |
| 22 | RD_ADDITIONAL_TREATMENT | boolean | bit | yes | |
| 23 | RD_DISCHARGED_NON_COMPLIANCE | boolean | bit | yes | |
| 24 | RD_DISCHARGED_REGULATORY_REQUIREMENTS | boolean | bit | yes | |
| 25 | RD_FURTHER_TREATMENT | boolean | bit | yes | |
| 26 | RD_INDIVIDUAL_ARRESTED | boolean | bit | yes | |
| 27 | RD_INDIVIDUAL_DEATH | boolean | bit | yes | |
| 28 | RD_INDIVIDUAL_NO_LONGER_PARTICIPATE_MEDICAL | boolean | bit | yes | |
| 29 | RD_INDIVIDUAL_RELOCATED | boolean | bit | yes | |
| 30 | RD_LEFT_AGAINST_CA_FORMAL_REFERRA | boolean | bit | yes | |
| 31 | RD_LEFT_AGAINST_CA_LOST_CONTACT | boolean | bit | yes | |
| 32 | RD_LEFT_AGAINST_CA_TERMINATION_THIRD_PARTY | boolean | bit | yes | |
| 33 | RD_OTHER | boolean | bit | yes | |
| 34 | RD_OTHER_DESC | string | varchar(100) | yes | |
| 35 | RD_PROGRAM_CLOSED | boolean | bit | yes | |
| 36 | REFERRAL_DATES_1 | string | varchar(100) | yes | |
| 37 | REFERRAL_DATES_2 | string | varchar(100) | yes | |
| 38 | REFERRALS | string | varchar(4000) | yes | |
| 39 | REFERRED_TO_1 | string | varchar(4000) | yes | |
| 40 | REFERRED_TO_2 | string | varchar(4000) | yes | |
| 41 | RELAPSE_PREVENTION_PLAN | string | varchar(4000) | yes | |
| 42 | RELATIONSHIP_1 | string | varchar(50) | yes | |
| 43 | RELATIONSHIP_2 | string | varchar(50) | yes | |
| 44 | RELATIONSHIP_3 | string | varchar(50) | yes | |
| 45 | RELATIONSHIP_4 | string | varchar(50) | yes | |
| 46 | STRENGTHS_ABILITIES_PREFERENCES | string | varchar(4000) | yes | |
| 47 | SUMMARY_OF_SERVICES | string | varchar(4000) | yes | |
| 48 | WAS_PROVIDED_A_COPY | string | varchar(3) | yes |