The Patient_Data table contains information about a patient.


Field NameDescription
PIDUnique patient identification number. 
fNameFirst name of the patient.
lNameFamily name of the patient.
mNameMiddle name of the patient.
DOBDate of Birth of the patient.
streetAddress number and the street name where the patient reside.
postal_code

Zip code used at the patients region.

cityName of the city where the patient reside.
stateName of the state where the patient reside.
drivers_licensePatient's driving license number
ssPatient's social security number.
occupationActivity performed by the patient to earn income.
phone_home

A 10 digit residential phone number for the patient.

phone_cellA 10 digit mobile phone number for the patient.
statusRelationship status of the patient.
sexGender of the patient.
providerIDProvider identification number.
emailEmail address of the patient.
race

Race of the patient.

guardiansnameName of the patients guardian.
allow_patient_portal

Value indicates whether the patient is allowed to access the Patient Portal.

  • No labels