Documentation/EHI_Export/docs/tables/lists.html
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| id | BIGINT | 19 | √ | null |
| documents.list_id | Defined in XML | R | | form_history_sdoh_health_concerns.health_concern_id | Defined in XML | R | | forms.issue_id | Defined in XML | R | | issue_encounter.list_id | Defined in XML | R | | lists_medication.list_id | Defined in XML | R |
|
|
Primary identifier of the record
| | uuid | BINARY | 16 | √ | | NULL |
|
|
UUID of the record
| | date | DATETIME | 19 | √ | | NULL |
|
|
Date the issue was created
| | type | VARCHAR | 255 | √ | | NULL |
|
| issue_types.type | Defined in XML | R |
|
The type of the issue (allergy, medication, etc) where the issue_types.category=‘default’
| | subtype | VARCHAR | 31 | | | '' |
|
| list_options.option_id | Defined in XML | R |
|
The sub type of the issue where the list_options.list_id=‘issue_subtypes’
| | title | VARCHAR | 255 | √ | | NULL |
|
|
The human readable description of the issue
| | udi | VARCHAR | 255 | √ | | NULL |
|
|
The unique device identifier. Populated if the issue is of type medical_device
| | udi_data | TEXT | 65535 | √ | | NULL |
|
|
The JSON serialized medical device as returned from the https://accessgudid.nlm.nih.gov/api/v2/devices/lookup.json api. Populated if the issue is of type medical_device
| | begdate | DATETIME | 19 | √ | | NULL |
|
|
The beginning date for when this issue occurred as reported by the patient or the provider
| | enddate | DATETIME | 19 | √ | | NULL |
|
|
The end date for when this issue occurred as reported by the patient or the provider
| | returndate | DATE | 10 | √ | | NULL |
|
|
UNUSED - will be removed in the future
| | occurrence | INT | 10 | √ | | 0 |
|
| list_options.option_id | Defined in XML | R |
|
Comes from the list_options.list_id=‘occurrence’ and is the frequency that this issue occurs for the patient
| | classification | INT | 10 | √ | | 0 |
|
|
UNUSED - will be removed in the future
| | referredby | VARCHAR | 255 | √ | | NULL |
|
|
The human readable name of Referring physician and practice
| | extrainfo | VARCHAR | 255 | √ | | NULL |
|
|
UNUSED - will be removed in the future
| | diagnosis | VARCHAR | 255 | √ | | NULL |
|
|
The diagnosis of the issue. Format is a text string in the format of ‘system:code;system:code2;system:coden’
| | activity | TINYINT | 3 | √ | | NULL |
|
|
Value of 0 means the record has been deleted, 1 means the record is active in the system
| | comments | LONGTEXT | 2147483647 | √ | | NULL |
|
|
Human readable additional notes/comments of the issue
| | pid | BIGINT | 19 | √ | | NULL |
|
| patient_data.pid | Defined in XML | R |
|
The internal patient identifier
| | user | VARCHAR | 255 | √ | | NULL |
|
| users.username | Defined in XML | R |
|
The user that created or last updated this issue
| | groupname | VARCHAR | 255 | √ | | NULL |
|
| groups.name | Defined in XML | R |
|
The user group that created or last updated this issue
| | outcome | INT | 10 | | | 0 |
|
| list_options.option_id | Defined in XML | R |
|
Comes from the list_options.list_id=‘outcome’ and represents the outcome of the issue
| | destination | VARCHAR | 255 | √ | | NULL |
|
|
Human readable name of GP, Secondary care specialist, etc.
| | reinjury_id | BIGINT | 19 | | | 0 |
|
|
UNUSED - will be removed in the future
| | injury_part | VARCHAR | 31 | | | '' |
|
|
UNUSED - will be removed in the future
| | injury_type | VARCHAR | 31 | | | '' |
|
|
UNUSED - will be removed in the future
| | injury_grade | VARCHAR | 31 | | | '' |
|
|
UNUSED - will be removed in the future
| | reaction | VARCHAR | 255 | | | '' |
|
| list_options.option_id | Defined in XML | R |
|
Comes from the list_options.list_id=‘reaction’ and represents the reaction of the patient to the allergy
| | verification | VARCHAR | 36 | | | '' |
|
| list_options.option_id | Defined in XML | R |
|
Comes from the list_options.list_id=‘allergyintolerance-verification’ and represents the confirmation status of the allergy
| | external_allergyid | INT | 10 | √ | | NULL |
|
|
An identifier for an allergy from an external eRx system
| | erx_source | enum('0', '1') | 1 | | | '0' |
|
|
O if the allergy issue originated in OpenEMR, 1 if the allergy issue originated in an external system
| | erx_uploaded | enum('0', '1') | 1 | | | '0' |
|
|
O if allergy is still waiting to be uploaded to an external system (such as eRX), 1 if the allergy issue has been successfully received by the eRX system
| | modifydate | TIMESTAMP | 19 | | | current_timestamp() |
|
|
The date the issue record was last modified
| | severity_al | VARCHAR | 50 | √ | | NULL |
|
| list_options.option_id | Defined in XML | R |
|
Comes from the list_options.list_id=‘severity_ccda’ and represents the severity of the allergic reaction of the patient to the allergy
| | external_id | VARCHAR | 20 | √ | | NULL |
|
|
UNUSED - will be removed in the future
| | list_option_id | VARCHAR | 100 | √ | | NULL |
|
| list_options.option_id | Defined in XML | R |
|
Comes from the list_options.list_id=CONCAT(lists.type,‘_issue_list’) and represents the prefilled list option id that was chosen as a template to create this issue
|
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PRIMARY | Primary key | Asc | id |
| pid | Performance | Asc | pid |
| type | Performance | Asc | type |
| uuid | Must be unique | Asc | uuid |