SELECT pPatients.Patient_ID,pPatients.Pt_Last, pPatients.Pt_First, pPatients.Pt_Middle,pPatients.Pt_Street, pPatients.Pt_City, pPatients.Pt_State,pPatients.Pt_Zip, pPatients.Pt_Phone, pAdmit.M0030_START_CARE_DT ,pAssessments.F26, pAssessments.Admit_ID, pAssessments.Assmt_ID, IFNULL(LEFT(pAssessments.F34,1),0) AS M1700, IFNULL(LEFT(pAssessments.F73,1),0) AS M2102d, IFNULL(LEFT(pAssessments.F82,1),0) AS GG0100A, IFNULL(LEFT(pAssessments.F83,1),0) AS GG0100B, IFNULL(LEFT(pAssessments.F34,1),0) AS M1700_PT, IFNULL(LEFT(pAssessments.F240,1),0) AS M2102d_PT, IFNULL(LEFT(pAssessments.F138,1),0) AS GG0100A_PT, IFNULL(LEFT(pAssessments.F139,1),0) AS GG0100B_PT, IFNULL(LEFT(pAssessments.F38,1),0) AS M1700_OT, IFNULL(LEFT(pAssessments.F240,1),0) AS M2102d_OT, IFNULL(LEFT(pAssessments.F138,1),0) AS GG0100A_OT, IFNULL(LEFT(pAssessments.F139,1),0) AS GG0100B_OT, (SELECT count(*) FROM #Request.prefix_db_agency#.pWoundsVitals WHERE pWoundsVitals.Assmt_ID = pAssessments.Assmt_ID AND VitalOrWound = 'wound' AND HealingStage like '3%'AND Status = 0) AS unhealed , pAssessments.Record_Mod_By FROM #Request.prefix_db_agency#.pAssessments JOIN #Request.prefix_db_agency#.pPatients ON pAssessments.Patient_ID = pPatients.Patient_ID JOIN #Request.prefix_db_agency#.pAdmit ON pAdmit.Admit_ID = pAssessments.Admit_ID WHERE pPatients.Status < 2 AND pAdmit.Status = 0 AND pAssessments.F26 IN ('1 - Start of care - further visits planned','PT Adult Evaluation','OT Adult Evaluation' ) AND pAssessments.Status = 0 Group by pAssessments.Assmt_ID ORDER BY pPatients.Pt_Last,pPatients.Patient_ID, FIELD(pAssessments.F26,'1 - Start of care - further visits planned','PT Adult Evaluation','OT Adult Evaluation') ASC SELECT * FROM #Request.prefix_db_lookup#.VBP_Analysis

Inconsistent admission data

SELECT VBP_Analysis.* FROM #Request.prefix_db_lookup#.VBP_Analysis WHERE LEFT(M1700,1) = AND LEFT(M2102d,1) = AND LEFT(GG0110a,1) = AND LEFT(GG0110b,1) = AND nursing = '#vbp_nursing#' SELECT pEmployee.* FROM #Request.prefix_db_lookup#.pEmployee WHERE pEmployee.Emp_ID = #Record_Mod_By# SELECT * FROM #Request.prefix_db_lookup#.VBP_Analysis WHERE LEFT(M1700,1) = AND LEFT(M2102d,1) = AND LEFT(GG0110a,1) = AND LEFT(GG0110b,1) = SELECT * FROM #Request.prefix_db_lookup#.VBP_Analysis WHERE LEFT(M1700,1) = AND LEFT(M2102d,1) = AND LEFT(GG0110a,1) = AND LEFT(GG0110b,1) =

Patient	Clinciains
#Pt_Last# #Pt_First# #DateFormat(M0030_START_CARE_DT,"mm/dd/yyyy")#	#getemp.Emp_First#