Count by Referral
Count by Referral
SELECT pPayer.Pay_Name, pReferral.Referral_ID, pReferral.R_Contact_Name, pReferral.Referral_Name, pReferral.R_Address_1, pReferral.R_City, pReferral.R_State, pReferral.R_Zip, pReferral.R_Phone, pPatients.Patient_ID, pPatients.Pt_Last, pPatients.Pt_First, pAdmit.drafts as Admission_Status,pAdmit.Admit_ID, pAdmit.Admission_Source as SRC, pPatients.Pt_Middle, pAdmit.M0030_START_CARE_DT,pAdmit.M0104_PHYSN_RFRL_DT,pAdmit.Admit_Type FROM #Request.prefix_db_agency#.pAssessments an LEFT OUTER JOIN #Request.prefix_db_agency#.pPatients on an.Patient_Id = pPatients.Patient_Id LEFT OUTER JOIN #Request.prefix_db_agency#.pAdmit on an.Admit_ID = pAdmit.Admit_ID AND pAdmit.Status = 0 JOIN #Request.prefix_db_agency#.pReferral ON pReferral.Referral_ID = pAdmit.Referral_ID AND pReferral.Status= 0 LEFT OUTER JOIN #Request.prefix_db_agency#.pPtPayer on pPatients.Patient_Id = pPtPayer.Patient_ID AND pPtPayer.Status = 0 AND pPtPayer.Payer_Responsibility = 'P - Primary' LEFT OUTER JOIN #Request.prefix_db_agency#.pPayer on pPayer.Pay_ID = pPtPayer.Payer_ID AND pPayer.Status = 0 WHERE pReferral.Loc_id = #session.AgencyID# AND pPatients.Status IN (0,1) AND an.F25 = 1 AND pAdmit.Status = 0 AND an.Status = 0 AND an.F176 >= #CreateODBCDate(Form.From_Date)# AND an.F176 <= #CreateODBCDate(Form.To_Date)# AND pAdmit.Admit_Type = '#Form.Admit_Type#' AND an.F26 like '1%' AND an.F26 like '%Adult%' AND an.F26 like '%Hospice%' AND an.F26 like '%Pediatric%' AND an.F26 like '%Non-Medical%' AND an.F26 NOT IN ('H&P Review') Group by an.Assmt_ID ORDER BY pReferral.Referral_Name ASC
Payer Type:
#Replace(Form.PayerType, ",", ", ", "ALL")#

#admit_status# - #Trim(Referral_Name)#, #Trim(R_City)#, #Trim(R_Phone)#

Referral Source List
Referral Name Source Patient Name Payer Referral Date Admission SOC Date
#R_Contact_Name# #Referral_Name# #R_Address_1# #R_City# #R_State# #R_Zip# #R_Phone# #SRC# #Trim(Pt_Last)#, #Trim(Pt_First)# #Pt_Middle# #Pay_Name# #DateFormat(M0104_PHYSN_RFRL_DT, "mm/dd/yyyy")# admittedpending #DateFormat(M0030_START_CARE_DT, "mm/dd/yyyy")#