form_CAMOS


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

Computer Aided Medical Ordering System notes that are part of a patient’s chart

Columns

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

The internal patient identifier
user VARCHAR 255 √ null
groupname VARCHAR 255 √ null
authorized TINYINT 3 √ null
activity TINYINT 3 √ null
category TEXT 65535 √ null
form_CAMOS_category.category Defined in XML R

The category that this note is based upon
subcategory TEXT 65535 √ null
form_CAMOS_item.item Defined in XML R

The CAMOS subcategory template that this note is based on
item TEXT 65535 √ null
form_CAMOS_item.item Defined in XML R

The CAMOS item template that this note is based on
content TEXT 65535 √ null

The actual chart note text that was entered in for the patient

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id

Relationships

Close relationships within degrees of separation