form_reviewofs


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

Review of Systems observations of the patient. Providers can use this form or the form_ros.

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
fever VARCHAR 5 √ null
chills VARCHAR 5 √ null
night_sweats VARCHAR 5 √ null
weight_loss VARCHAR 5 √ null
poor_appetite VARCHAR 5 √ null
insomnia VARCHAR 5 √ null
fatigued VARCHAR 5 √ null
depressed VARCHAR 5 √ null
hyperactive VARCHAR 5 √ null
exposure_to_foreign_countries VARCHAR 5 √ null
cataracts VARCHAR 5 √ null
cataract_surgery VARCHAR 5 √ null
glaucoma VARCHAR 5 √ null
double_vision VARCHAR 5 √ null
blurred_vision VARCHAR 5 √ null
poor_hearing VARCHAR 5 √ null
headaches VARCHAR 5 √ null
ringing_in_ears VARCHAR 5 √ null
bloody_nose VARCHAR 5 √ null
sinusitis VARCHAR 5 √ null
sinus_surgery VARCHAR 5 √ null
dry_mouth VARCHAR 5 √ null
strep_throat VARCHAR 5 √ null
tonsillectomy VARCHAR 5 √ null
swollen_lymph_nodes VARCHAR 5 √ null
throat_cancer VARCHAR 5 √ null
throat_cancer_surgery VARCHAR 5 √ null
heart_attack VARCHAR 5 √ null
irregular_heart_beat VARCHAR 5 √ null
chest_pains VARCHAR 5 √ null
shortness_of_breath VARCHAR 5 √ null
high_blood_pressure VARCHAR 5 √ null
heart_failure VARCHAR 5 √ null
poor_circulation VARCHAR 5 √ null
vascular_surgery VARCHAR 5 √ null
cardiac_catheterization VARCHAR 5 √ null
coronary_artery_bypass VARCHAR 5 √ null
heart_transplant VARCHAR 5 √ null
stress_test VARCHAR 5 √ null
emphysema VARCHAR 5 √ null
chronic_bronchitis VARCHAR 5 √ null
interstitial_lung_disease VARCHAR 5 √ null
shortness_of_breath_2 VARCHAR 5 √ null
lung_cancer VARCHAR 5 √ null
lung_cancer_surgery VARCHAR 5 √ null
pheumothorax VARCHAR 5 √ null
stomach_pains VARCHAR 5 √ null
peptic_ulcer_disease VARCHAR 5 √ null
gastritis VARCHAR 5 √ null
endoscopy VARCHAR 5 √ null
polyps VARCHAR 5 √ null
colonoscopy VARCHAR 5 √ null
colon_cancer VARCHAR 5 √ null
colon_cancer_surgery VARCHAR 5 √ null
ulcerative_colitis VARCHAR 5 √ null
crohns_disease VARCHAR 5 √ null
appendectomy VARCHAR 5 √ null
divirticulitis VARCHAR 5 √ null
divirticulitis_surgery VARCHAR 5 √ null
gall_stones VARCHAR 5 √ null
cholecystectomy VARCHAR 5 √ null
hepatitis VARCHAR 5 √ null
cirrhosis_of_the_liver VARCHAR 5 √ null
splenectomy VARCHAR 5 √ null
kidney_failure VARCHAR 5 √ null
kidney_stones VARCHAR 5 √ null
kidney_cancer VARCHAR 5 √ null
kidney_infections VARCHAR 5 √ null
bladder_infections VARCHAR 5 √ null
bladder_cancer VARCHAR 5 √ null
prostate_problems VARCHAR 5 √ null
prostate_cancer VARCHAR 5 √ null
kidney_transplant VARCHAR 5 √ null
sexually_transmitted_disease VARCHAR 5 √ null
burning_with_urination VARCHAR 5 √ null
discharge_from_urethra VARCHAR 5 √ null
rashes VARCHAR 5 √ null
infections VARCHAR 5 √ null
ulcerations VARCHAR 5 √ null
pemphigus VARCHAR 5 √ null
herpes VARCHAR 5 √ null
osetoarthritis VARCHAR 5 √ null
rheumotoid_arthritis VARCHAR 5 √ null
lupus VARCHAR 5 √ null
ankylosing_sondlilitis VARCHAR 5 √ null
swollen_joints VARCHAR 5 √ null
stiff_joints VARCHAR 5 √ null
broken_bones VARCHAR 5 √ null
neck_problems VARCHAR 5 √ null
back_problems VARCHAR 5 √ null
back_surgery VARCHAR 5 √ null
scoliosis VARCHAR 5 √ null
herniated_disc VARCHAR 5 √ null
shoulder_problems VARCHAR 5 √ null
elbow_problems VARCHAR 5 √ null
wrist_problems VARCHAR 5 √ null
hand_problems VARCHAR 5 √ null
hip_problems VARCHAR 5 √ null
knee_problems VARCHAR 5 √ null
ankle_problems VARCHAR 5 √ null
foot_problems VARCHAR 5 √ null
insulin_dependent_diabetes VARCHAR 5 √ null
noninsulin_dependent_diabetes VARCHAR 5 √ null
hypothyroidism VARCHAR 5 √ null
hyperthyroidism VARCHAR 5 √ null
cushing_syndrom VARCHAR 5 √ null
addison_syndrom VARCHAR 5 √ null
additional_notes LONGTEXT 2147483647 √ null

Indexes

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

Relationships

Close relationships within degrees of separation