SELECT p.Patient_Id, p.Pt_Last, p.Pt_First, p.Pt_Middle, pAdmit.Admit_ID, pAdmit.M0030_START_CARE_DT FROM #Request.prefix_db_agency#.pAdmit JOIN #Request.prefix_db_agency#. pPatients p ON pAdmit.Patient_ID = p.Patient_ID WHERE p.Status < 2 AND pAdmit.Status = 0 AND pAdmit.M0030_START_CARE_DT >= #CreateODBCDate(Form.From_Date)# AND pAdmit.M0030_START_CARE_DT < #CreateODBCDate(Form.To_Date)# AND pAdmit.Admit_ID NOT IN (SELECT pAssessments.Admit_ID FROM #Request.prefix_db_agency#.pAssessments WHERE (pAssessments.F26 like '9%' OR pAssessments.F26 like '7%' OR pAssessments.F26 like '8%') AND pAssessments.Status =0) ORDER BY Pt_Last, Pt_First, M0030_START_CARE_DT DESC
Census by Date Range
Census Report by Date Range
Payer Type:
#Replace(Form.PayerType, ",", ", ", "ALL")#

No Patient records were found based on your search criteria

SELECT pAuths.* FROM #Request.prefix_db_agency#.pAuths JOIN #Request.prefix_db_agency#.pAssessments ON pAssessments.Assmt_ID = pAuths.Assmt_ID AND pAssessments.Status = 0 WHERE pAuths.Status = 0 AND pAssessments.Admit_ID IN (#GetPatients.Admit_ID#) GROUP BY Skill
Patient Name Admit Date Authorizations
#REREPLACE(LCASE(Pt_Last), "((^| )[a-z]{1})", "\U\1", 'ALL')#, #REREPLACE(LCASE(Pt_first), "((^| )[a-z]{1})", "\U\1", 'ALL')# #Pt_Middle# #DateFormat(M0030_START_CARE_DT,'mm/dd/yyyy')# #getauths.Skill# - #getauths.Total_Visits#

Total Census: #Patient_Ctr# - for the period of #Form.From_Date# to #Form.To_Date#