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
activity Unknown 0 null

Activity status, 1=form is active, 0=inactive
ankle_able_to_bear_weight_steps Unknown 0 null

Ability to bear weight and steps information
ankle_additional_diagnosis Unknown 0 null

Additional diagnosis for the ankle injury
ankle_additional_x_ray_notes Unknown 0 null

Additional notes related to X-ray
ankle_date_of_injury Unknown 0 null

Date of the ankle injury
ankle_diagnosis1 Unknown 0 null

Diagnosis 1 for the ankle injury
ankle_diagnosis2 Unknown 0 null

Diagnosis 2 for the ankle injury
ankle_diagnosis3 Unknown 0 null

Diagnosis 3 for the ankle injury
ankle_diagnosis4 Unknown 0 null

Diagnosis 4 for the ankle injury
ankle_foot Unknown 0 null

Foot information related to the injury
ankle_how_did_injury_occur Unknown 0 null

Description of how the injury occurred
ankle_onset_of_swelling Unknown 0 null

Onset of swelling
ankle_ottawa_bone_tenderness Unknown 0 null

Information about Ottawa bone tenderness
ankle_plan Unknown 0 null

Recommended treatment plan for the ankle injury
ankle_severity_of_pain Unknown 0 null

Severity of pain associated with the injury 1-3
ankle_significant_swelling Unknown 0 null

Indication of significant swelling
ankle_work_related Unknown 0 null

Work-related information for the injury
ankle_x_ray_interpretation Unknown 0 null

Interpretation of X-ray results
authorized Unknown 0 null

Authorization status
date Unknown 0 null

Date of the evaluation
groupname Unknown 0 null
groups.name Defined in XML R

The groupname that created this record.
id Unknown 0 null

Surrogate id of the record used as the primary incrementing key
pid Unknown 0 null
patient_data.pid Defined in XML R

The internal patient identifier
user Unknown 0 null
users.username Defined in XML R

User responsible for creating the record.

Relationships

Close relationships within degrees of separation