form_ankleinjury


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_ankleinjury.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 a provider’s evaluation of an ankle injury including x-ray information, diagnosis, and recommended treatments

Columns

Column Type Size Nulls Auto Default Children Parents Comments
ankle_additional_diagnosis Unknown 0 null

Additional diagnosis for the ankle injury
ankle_date_of_injury Unknown 0 null

Date of the ankle injury
id BIGINT 19 √ null

Surrogate id of the record used as the primary incrementing key
date DATETIME 19 √ null

Date of the evaluation
pid BIGINT 19 √ null
patient_data.pid Defined in XML R

The internal patient identifier
user VARCHAR 255 √ null
users.username Defined in XML R

User responsible for creating the record.
groupname VARCHAR 255 √ null
groups.name Defined in XML R

The groupname that created this record.
authorized TINYINT 3 √ null

Authorization status
activity TINYINT 3 √ null

Activity status, 1=form is active, 0=inactive
ankle_date_of_injuary DATETIME 19 √ null
ankle_work_related VARCHAR 255 √ null

Work-related information for the injury
ankle_foot VARCHAR 255 √ null

Foot information related to the injury
ankle_severity_of_pain VARCHAR 255 √ null

Severity of pain associated with the injury 1-3
ankle_significant_swelling VARCHAR 255 √ null

Indication of significant swelling
ankle_onset_of_swelling VARCHAR 255 √ null

Onset of swelling
ankle_how_did_injury_occur LONGTEXT 2147483647 √ null

Description of how the injury occurred
ankle_ottawa_bone_tenderness VARCHAR 255 √ null

Information about Ottawa bone tenderness
ankle_able_to_bear_weight_steps VARCHAR 255 √ null

Ability to bear weight and steps information
ankle_x_ray_interpretation VARCHAR 255 √ null

Interpretation of X-ray results
ankle_additional_x_ray_notes LONGTEXT 2147483647 √ null

Additional notes related to X-ray
ankle_diagnosis1 VARCHAR 255 √ null

Diagnosis 1 for the ankle injury
ankle_diagnosis2 VARCHAR 255 √ null

Diagnosis 2 for the ankle injury
ankle_diagnosis3 VARCHAR 255 √ null

Diagnosis 3 for the ankle injury
ankle_diagnosis4 VARCHAR 255 √ null

Diagnosis 4 for the ankle injury
ankle_plan LONGTEXT 2147483647 √ null

Recommended treatment plan for the ankle injury
ankle_additional_diagnisis LONGTEXT 2147483647 √ null

Indexes

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

Relationships

Close relationships within degrees of separation