lists_medication


If there is patient data for this table the file for this export will be found in the extracted zip folder location under the filename of lists_medication.csv

If there are non-patient data column elements that are not part of the designated record set they will be marked in the Comment's column for that data element

Description

Holds additional data about patient medications.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
created_by Unknown 0 null
users.id Defined in XML R

The user that created this record
id BIGINT 19 √ null
list_id BIGINT 19 √ NULL
lists.id Defined in XML R

The internal lists identifier
drug_dosage_instructions LONGTEXT 2147483647 √ NULL

Free text dosage instructions for taking the drug
usage_category VARCHAR 100 √ NULL
list_options.option_id Defined in XML R

Comes from the list_options.list_id=‘medication-usage-category’
usage_category_title VARCHAR 255 null

title in list_options.list_id=medication-usage-category
request_intent VARCHAR 100 √ NULL
list_options.option_id Defined in XML R

Comes from the list_options.list_id=‘medication-request-intent’
request_intent_title VARCHAR 255 null

title in list_options.list_id=medication-request-intent
medication_adherence_information_source VARCHAR 50 √ NULL
list_options.option_id Defined in XML R

fk to list_options.option_id where list_id=medication_adherence_information_source to indicate who provided the medication adherence information
medication_adherence VARCHAR 50 √ NULL
list_options.option_id Defined in XML R

fk to list_options.option_id where list_id=medication_adherence to indicate if patient is complying with medication regimen
medication_adherence_date_asserted DATETIME 19 √ NULL

Date when the medication adherence information was asserted
prescription_id BIGINT 19 √ NULL
prescriptions.id Defined in XML R

The internal prescription identifier that originated this medication issue
is_primary_record BOOLEAN 3 √ 1

Indicates if this medication is a primary record(1) or a reported record(0)
reporting_source_record_id BIGINT 19 √ NULL
users.id Defined in XML R

If this is a reported record, this is the fk to the users.id column for the address book user that the medication was reported by

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
lists_med_request_intent_idx Performance Asc request_intent
lists_med_usage_category_idx Performance Asc usage_category
lists_medication_list_idx Performance Asc list_id

Relationships

Close relationships within degrees of separation