form_track_anything_type


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

Represents the category grouping / track of the data element being tracked via the track_anything form

Columns

Column Type Size Nulls Auto Default Children Parents Comments
track_anything_type_id BIGINT 19 √ null
form_track_anything.procedure_type_id Defined in XML R
form_track_anything_results.itemid Defined in XML R
name VARCHAR 255 √ NULL

The name of the type of the data element being tracked
description VARCHAR 255 √ NULL

Description of the data element type being tracked
parent BIGINT 19 √ NULL

This is a reference to a parent form_track_anything_type element. 0=There is no parent, if !0 then it is the track_anything_type_id for the parent element
position INT 10 √ NULL

The order this element should be filled out in the track anything population mechanism
active INT 10 √ NULL

1=The element is active and allows for data entry, 0=data entry is disabled and the element is not displayed to the user

Indexes

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

Relationships

Close relationships within degrees of separation