YOU MUST HAVE CURRENT WORKING KNOWLEDGE OF? GE CENTRICITY'S DATABASE, TABLES AND FIELDS TO DO THIS PROJECT. I DO NOT HAVE A COPY OF THE DATABASE OR TABLES OR SCHEMA ETC.
I need a custom report from GE Centicity's MS SQL database. You should be very familiar with its tables and fields to create this SQL. It should select the following:
• **Account Number** is the patient account number
• **Patient Last Name** is the patient last name
• **Patient First Name** is the patient first name
• **Patient Middle Initial** is the patient middle initial
• **Patient Date of Birth** is the patient date of birth
• **Appointment Doctor Number** is appointment doctor number
• **Appointment Doctor Last Name** is the appointment doctor last name.• **Appointment Doctor First Name** is the appointment doctor first name.• **Appointment Doctor Middle Initial** is the appointment doctor middle initial.• **Appointment Reason** is the appointment reason description• **Appointment Date** is the appointment date• **Appointment Time** is the appointment time• **Appointment Encounter#** is the appointment encounter number (if generated)• **Default Referring Doctor Number? .** **Default Referring Doctor Last Name**• **Default Referring Doctor First Name**• **Default Referring Doctor Middle Initial**
**Default Referring Doctor Address** .
• **Default Referring Doctor City** • **Default Referring Doctor State** • **Default Referring Doctor Zip** .• **Default? ? **Referring Doctor Fax Number****.**Referring Doctor? Phone Number**
?
## Deliverables
Working SQL