erx_ttl_touch


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 erx_ttl_touch.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

Store records last update per patient data process

Columns

Column Type Size Nulls Auto Default Children Parents Comments
patient_id BIGINT UNSIGNED 20 null

Patient record Id
process enum('allergies', 'medications') 11 null

NewCrop eRx SOAP process
updated DATETIME 19 null

Date and time of last process update for patient

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc/Asc patient_id + process

Relationships

Close relationships within degrees of separation