form_eye_mag_orders


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

This table is used to track eye-related orders, such as eyeglass or contact lens orders.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
form_id INT 10 null
pid BIGINT 19 null
patient_data.pid Defined in XML R

The internal patient identifier
ORDER_DETAILS VARCHAR 255 null
ORDER_STATUS VARCHAR 50 √ null
ORDER_PRIORITY VARCHAR 50 √ null
ORDER_DATE_PLACED DATE 10 null
ORDER_PLACED_BYWHOM VARCHAR 50 √ null
ORDER_DATE_COMPLETED DATE 10 √ null
ORDER_COMPLETED_BYWHOM VARCHAR 50 √ null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
VISIT_ID Must be unique Asc/Asc/Asc pid + ORDER_DETAILS + ORDER_DATE_PLACED

Relationships

Close relationships within degrees of separation