| A | B | C | D | E | F | G | H | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | Field Name | Type (Length) | Req | Description | Example | Data File Column Header | Displays in EH? | Client Using | MIE Notes | MIE Wiki Link | MIE Legacy Field # | |||||||||||||
2 | Chart Identifier | varchar(50) | R | Employee Identifier | 12345 | documents.pat_id | Yes | 1 | ||||||||||||||||
3 | Chart ID Type | Special | R | Employee Identifier Type Indicates the type of the Employee id. (username, patient_id, ssn, etc.) | part:GUID | documents.pat_id_type | No | "Possible values: * id:email - email address * id:pat_ext_id - external ID in patients table * id:pat_id - internal MIE chart ID * id:ssn - social security number * id:user_id - internal MIE user ID * id:username - login username * part:<partition name> - specify an MR number in a partition" | 2 | |||||||||||||||
4 | External ID | varchar(128) | R | External ID from the legacy system. IE, the autoincrementing column from the legacy DB. | 42 | documents.ext_doc_id | No | This field records the unique ID from the legacy system. Must be unique per Interface. If data is provided with an external ID and interface that is already in the system, then the existing record will be revisioned and the new data will be added in its place. | 3 | |||||||||||||||
5 | Test Date/Time | datetime | R | When the test was conducted (datetime). | 2015-09-28 15:42:24 | documents.service_date | Yes | This field also sets the documents.service_date and other fields on the documents table if not specified. | 5 | |||||||||||||||
6 | Performing User ID | varchar(255) | O | ID of physician, clinician, or provider performing the exam. | cwg2837 | documents.origin_id | Yes | Default leaves this value unspecified. | 7 | |||||||||||||||
7 | Performing User ID Type | Special | CR | Indicates what sort of ID was provided. | id:username | documents.origin_id_type | Yes | Conditionally required if Performing User ID is provided. Possible values: * id:email - email address * id:pat_ext_id - external ID in patients table * id:pat_id - internal MIE chart ID * id:ssn - social security number * id:user_id - internal MIE user ID * id:username - login username * part:<partition name> - specify an MR number in a partition | 8 | |||||||||||||||
8 | ID of Provider Reading Results | int(10) unsigned | O | ID of the provider reading the results. Typically this is used with Tuberculosis or skin tests. | injections.resulting_user_id | Yes | 69 | |||||||||||||||||
9 | Type of ID of Provider Reading Results | Special | CR | Identifies the type of ID specified by the ID of Provider Reading Results. | injections.resulting_user_id_type | No | "Possible values: * id:email - email address * id:pat_ext_id - external ID in patients table * id:pat_id - internal MIE chart ID * id:ssn - social security number * id:user_id - internal MIE user ID * id:username - login username * part:<partition name> - specify an MR number in a partition" | 70 | ||||||||||||||||
10 | Date/Time when Results were Read | datetime | O | Datetime the result was recorded. Typically this is used with Tuberculosis or skin tests. | injections.resulting_datetime | Yes | 71 | |||||||||||||||||
11 | Service Location | varchar(10) | O | Code or short name of the service location. | OFFICE | documents.service_location | Yes | Service location maps to Enterprise Health Locations, which is managed under the Control Panel. If the Service Location matches an existing location in Enterprise Health, it will be used. If there is no match, a new Location will be created using the Service Location Description (if available). | 11 | |||||||||||||||
12 | Service Location description | varchar(60) | O | Description or long name of the service location. | documents.service_location_desc | Yes | See notes on Service Location. If description is provided and the existing location's description as specified in the service_location field is different, the description will be updated to this value. If the service_location does not exist, a new one will be created and its description set to this value. | 12 | ||||||||||||||||
13 | Injection Description | mediumtext | R | A text description of an immunization or injection. | Influenza, split (incl. purified surface antigen) | injections.description | Yes | 54 | ||||||||||||||||
14 | CDC Injection Code | varchar(20) | BP | The CDC Immunization Information Systems CVX Codes | 15 | injections.inject_code | Yes | http://www2a.cdc.gov/vaccines/iis/iisstandards/vaccines.asp?rpt=cvx | 55 | |||||||||||||||
15 | vial | varchar(255) | O | Records the vial number for inventory tracking. | UT2797FA | injections.vial | Yes | 56 | ||||||||||||||||
16 | series | varchar(255) | O | Identifies the injection number in a series of injections. | 2 | injections.series | Yes | 58 | ||||||||||||||||
17 | dose | varchar(255) | O | Dose of injection or immunization. | 0.25 | injections.dose | Yes | 59 | ||||||||||||||||
18 | unit_measure | varchar(10) | O | Unit of dose (cc, mm, etc) used for injection/immunization. | mL | injections.unit_measure | Yes | 60 | ||||||||||||||||
19 | strength | varchar(255) | O | Concentration of formula of injection/immunization. | 1.0 mg/0.5mL | injections.strength | Yes | 61 | ||||||||||||||||
20 | Injections Route | varchar(10) | O | Indicates the way the injection/immunization was dispensed to the patient. Foreign key to the rxdb table injection_routes. | IM | injections.route | Yes | 62 | ||||||||||||||||
21 | Injections Site | varchar(60) | O | Identifies the injection site. | LD | injections.site | Yes | 63 | ||||||||||||||||
22 | manufacturer | varchar(255) | O | Text name of the injection/immunization manufacturer. | Sanofi Pasteur | injections.manufacturer | Yes | 64 | ||||||||||||||||
23 | expiration_date | date | O | Expiration date of medication. | 6/30/2009 | injections.expiration_date | Yes | 65 | ||||||||||||||||
24 | reaction | mediumtext | O | Free text comments section to record the reaction to an injection/immunization. Anything that doesn't fit into a discrete field may be concatenated in this field. | injections.reaction | Yes | 66 | |||||||||||||||||
25 | deleted | tinyint(3) unsigned | O | Indicates that an injection was removed from the system. * 1 - injection is deleted * 0 - injection is active (default if not specified) | injections.deleted | Yes | 75 | |||||||||||||||||
26 | in_house | tinyint(3) unsigned | O | Flags injection as: * 1 - completed in-house * 0 - completed elsewhere or unspecified (default if not specified) | injections.in_house | Yes | 76 | |||||||||||||||||
27 | next_due | date | O | Date that the next immunization/injection of this type should be due | 10/20/2018 | injections.next_due | Yes | 77 | ||||||||||||||||
28 | rxid | int(10) unsigned | O | injections.rxid | ||||||||||||||||||||
29 | vfc_code | varchar(10) | O | Vaccines for Children (VFC) elligibility code which applies to this injection administration. | injections.vfc_code | |||||||||||||||||||
30 | handout_date | datetime | O | Date the immunization/injection handout was given to a patient. | 9/28/2015 | injections.handout_date | Yes | 79 | ||||||||||||||||
31 | Encounter External Identifier | varchar(100) | O | External identifier for the encounter that this injection document was attached to | 10025 | encounters.ext_id | Both the encounter external identifer and the encounter interface in this specification need to match an existing encounter in the Enterprise Heath System for this Injection to be linked properly | |||||||||||||||||
32 | Encounter Interface | varchar(100) | O | Interface value used when that encounter was imported | WC_DATA_IMPORT | encounters.interface | Both the encounter external identifer and the encounter interface in this specification need to match an existing encounter in the Enterprise Heath System for this Injection to be linked properly | |||||||||||||||||
33 | Encounter Order ID | INT(10) unsigned | O | Webchart Order ID to create an order associated with a document/encounter. | 2593 | encounters.order_id | The ID needs to match the appropriate order_id from the order_list table. |