database.conf

patient:"Patient";
patient_loop:"PatientSerNum";
patients:"Patient";
patients_loop:"PatientSerNum";
population:"Patient";
populationSQL:"PatientSerNum";
population_loop:"PatientSerNum";
patientSQL:"PatientSerNum";
patientsSQL:"PatientSerNum";
patients_loop:"PatientSerNum";
patientsernum:"PatientSerNum";
id:"PatientSerNum";
idSQL:"PatientSerNum";
dateofbirth:"DateOfBirth";
dateofbirthSQL:"DateOfBirth";
birthyear:"DateOfBirth";
birthyearSQL:"DateOfBirth";
diagnosis:"Diagnosis";
diagnosis_field:"INCLUDE";
diagnosisSQL:"Description";
diagnosis_loop:"DiagnosisId";
sex:"Sex";
sexSQL:"Sex";
months:"Month(EventTimeStamp)";
days:"DATE_FORMAT(EventTimeStamp, \"%W\")";                                                
date:"Date(EventTimeStamp)";
dates:"Date(EventTimeStamp)";
years:"Year(EventTimeStamp)";
hours:"Hour(EventTimeStamp)";
postalcode:"PostalCode";
postalcodeSQL:"PostalCode";
lastupdated:"LastUpdated";
doctors:"Doctor";
period:"";
end:"end_of_treatment_note_finished";
lastupdatedSQL:"LastUpdated";
doctors:"PatientDoctor";
doctor_loop:"DoctorSerNum";
doctorsSQL:"PatientDoctor";
doctors_loop:"DoctorSerNum";
doctorSQL:"DoctorSerNum";
doctor:"PatientDoctor";
oncologist:"OncologistFlag";
oncologistSQL:"OncologistFlag";
oncologist_table:"OncologistFlag";
diagsernum:"DiagnosisSerNum";
diagnosisid:"DiagnosisId";
diagnosiscreationdate:"DiagnosisCreationDate";
diagnosiscode:"DiagnosisCode";
description:"Description";
name:"Description";
breast:"C50";
prostate:"C61";
brain:"C71";
stomach:"C16";
lung:"C34";
events:"";
doctorid:"DoctorSerNum";
doctoridSQL:"DoctorSerNum";