form_track_anything


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

Clinical note form that allows clinicians to provide point in time and longitudinal tracking of any data element they configure

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
form_track_anything_results.track_anything_id Defined in XML R
forms.form_id Defined in XML R

The primary key which is the same as the forms.form_id column
date TIMESTAMP 19 current_timestamp()
name Unknown 0 null

The name of the type of the data element being tracked
pid INT 10 √ null
patient_data.pid Defined in XML R

The internal patient identifier
procedure_type_id BIGINT 19 √ null
form_track_anything_type.track_anything_type_id Defined in XML R
comment VARCHAR 255 √ null

Indexes

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

Relationships

Close relationships within degrees of separation