Emergency Priority Report

SELECT * FROM getpatients ORDER BY Payer_ID ASC SELECT * FROM #Request.prefix_db_agency#.pProblem WHERE M0_No like 'M1021%' AND Status = 0 AND Assmt_ID = (SELECT Assmt_ID FROM #Request.prefix_db_agency#.pAssessments WHERE pAssessments.Patient_ID = #get_data.Patient_ID# AND pAssessments.Status = 0 AND (pAssessments.F26 like '%1 -%' OR pAssessments.F26 like '%3 -%' OR pAssessments.F26 like '%4 -%' ) ORDER BY pAssessments.F179 DESC LIMIT 1 )

Payer	Patients	Emergency Contacts	Comments
#Pay_Name#	(#Priority#) #Pt_Last#, #Pt_First# #Pt_Middle# #Pt_Street#, #Pt_City# #Pt_Phone# Physician : #Phys_Last#, #Phys_First# - #Phys_Phone# Primary Diagnosis : #Description#	* #Last_Name# #First_Name# (#Pt_Realtionship#) #Telephone1#	#Comment#
No Report Found

SELECT * FROM #Request.prefix_db_agency#.pProblem WHERE M0_No like 'M1021%' AND Status = 0 AND Assmt_ID = (SELECT Assmt_ID FROM #Request.prefix_db_agency#.pAssessments WHERE pAssessments.Patient_ID = #getpatients.Patient_ID# AND pAssessments.Status = 0 AND (pAssessments.F26 like '%1 -%' OR pAssessments.F26 like '%3 -%' OR pAssessments.F26 like '%4 -%' ) ORDER BY pAssessments.F179 DESC LIMIT 1 )

Priority Level	Patients	Emergency Contacts	Comments
#Priority#	#Pt_Last#, #Pt_First# #Pt_Middle# #Pt_Street#, #Pt_City# #Pt_Phone# Physician : #Phys_Last#, #Phys_First# - #Phys_Phone# Primary Diagnosis : #Description#	* #Last_Name# #First_Name# (#Pt_Realtionship#) #Telephone1#	#Comment#
No Report Found