SELECT Patient_ID, Agency_Assigned_ID, First_Name_M0040, Last_Name_M0040, Middle_Initial_M0040, Suffix_M0040, Street_Address, Mailing_Address, City, State_M0050, Zip_M0060, Telephone, MSA_Code, DOB_M0066, Gender_M0069, SSN_M0064, SSN_M0064_NA, HI_Claim_Number, Current_Payment_Sources_M0150, Race_M0140, Primary_ReferringPhys_ID_M0072, Home_Directions, Specific_Concerns, AD_on_File, AD_Content, AD_Eff_Date, Code_Status, Code_Status_Eff_Date, Status, Payer_ID, Employee_ID, Medicare_Number_M0063, Medicare_Number_NA_M0063, Medicaid_Number_M0065, Medicaid_Number_NA_M0065, Allergies, Admission_Status, Referral_ID, Priority, M1100_Living_Situation, Latitude,Longitude FROM #Request.prefix_db_agency#.patient WHERE Patient_ID =#session.cs.patientid##URL.pid# AND patient.Agency_ID = #session.AgencyID# select e.employee_id,first_name,last_name,e.Address1,e.Address2,e.City,e.State,e.Zip,e.Cell_Phone,Email,Status,p.Natl_Provider_ID,p.Fax,pp.Physician_ID from #Request.prefix_db_lookup#.Employee e inner join patientphysician pp on pp.patient_Id=#session.cs.patientid##URL.pid# inner join Physician p on p.employee_id=e.employee_id and p.Physician_ID=pp.Physician_ID where e.EmployeeType='Physician' SELECT Patient_ID,ContactName,ContactType,NPI,Referral_ID,Telephone1,ContactStreet,ContactCity,ContactState,ContactZip FROM #Request.prefix_db_agency#.PatientContact WHERE Patient_ID = #session.cs.patientid##URL.pid# SELECT Patient_ID,Referral_ID FROM #Request.prefix_db_agency#.patient WHERE Patient_ID = #session.cs.patientid##URL.pid# SELECT Referral_ID,R_Contact_Name,R_Address_1,R_City,R_State,R_Zip,R_Phone,R_NPI FROM #Request.prefix_db_agency#.Referral WHERE Referral_ID = #GetRefSource.Referral_ID# select pr.Payer_ID,pr.PayName,Address1,pr.Address2,pr.City,pr.State,pr.Zip,pr.Contact,pr.Contact_Phone,pp.InsuredName, pp.RelationShip_to_Insured,pp.Insured_PolicyNumber,pp.InsuredIDNumber FROM #Request.prefix_db_agency#.patientpayer pp left outer join #Request.prefix_db_agency#.patient p on p.Patient_ID=pp.Patient_ID left outer join #Request.prefix_db_agency#.Payer pr on pr.Payer_ID=pp.Payer_ID where p.Patient_ID=#session.cs.patientid##URL.pid#

Patient Information	#getP.Last_Name_M0040#, #getP.First_Name_M0040#

#getP.Last_Name_M0040#, #getP.First_Name_M0040# #getP.Middle_Initial_M0040# #GetP.Street_Address# #GetP.Mailing_Address# #GetP.City#,#GetP.State_M0050# #GetP.Zip_M0060# Telephone #GetP.Telephone# Advance directive Home Direction #GetP.Home_Directions#	DOB #DateFormat(GetP.DOB_M0066,"yyyy-mm-dd")# #GetP.Gender_M0069# SSN #GetP.SSN_M0064# #GetP.Race_M0140# Allergies #GetP.Allergies# Code status #GetP.Code_Status# Emergency
Contacts
#count#. #GetR.ContactName# #GetR.ContactStreet# #GetR.ContactCity# #GetR.ContactState# #GetR.ContactZip# #GetR.Telephone1#	Fax NPI#GetR.NPI#
Referral Sources
#counting#. #GetRefcontact.R_Contact_Name# #GetRefcontact.R_Address_1# #GetRefcontact.R_City# #GetRefcontact.R_State# #GetRefcontact.R_Zip# #GetRefcontact.R_Phone#	Fax NPI#GetRefcontact.R_NPI#
Physicians
#phycounting#. #GetPhy.first_name# #GetPhy.last_name# #GetPhy.Address1# #GetPhy.City# #GetPhy.State# #GetPhy.Zip# #GetPhy.Cell_Phone#	#GetPhy.Fax# #GetPhy.Natl_Provider_ID#
Payers
#paycounting#. #GetPay.PayName# #GetPay.Address1# #GetPay.Address2# #GetPay.City# #GetPay.State# #GetPay.Zip# #GetPay.Contact# #GetPay.Contact_Phone#	Insured's Name #GetPay.InsuredName# Patient Relationship to Insured #GetPay.RelationShip_to_Insured# Insured's Policy Number #GetPay.Insured_PolicyNumber# Insured's ID Number #GetPay.InsuredIDNumber#