SELECT p.Patient_Id, p.Pt_Last AS Last_Name_M0040, p.Pt_First AS First_Name_M0040, p.Status ,an.Assmt_ID, an.F177 AS Certification_Start, an.F178 AS Certification_End ,si.Visit_Date ,s.Supply, s.Price ,ss.Total_Units, ss.Total_Price , ss.Supply_Id FROM #Request.prefix_db_agency#.pPatients p, #Request.prefix_db_agency#.pAssessments an, #Request.prefix_db_agency#.pSchedules si, #Request.prefix_db_agency#.Supply_Sched ss, #Request.prefix_db_agency#.Supply s WHERE p.Loc_ID = '#session.AgencyId#' AND p.Status < 2 AND an.Patient_Id = p.Patient_Id AND si.Assmt_ID = an.Assmt_ID AND an.Status = 0 AND si.status = 0 AND ss.Patient_Id = si.Patient_Id AND ss.Schedule_ID = si.Schedule_ID AND ss.Assmt_ID = si.Assmt_ID AND ss.Deleted <> 1 AND s.Supply_Id = ss.Supply_Id AND s.Supply != '' AND p.Patient_ID = '#FORM.pid#' AND si.Visit_Date >= #CreateODBCDate(FORM.df)# AND si.Visit_Date <= #CreateODBCDate(FORM.dt)# ORDER BY p.Pt_Last, p.Pt_First, an.F177 DESC, si.Visit_Date DESC, s.Supply Select distinct(Patient_ID) as Patient_ID, Last_Name_M0040, First_Name_M0040 from q order by Last_Name_M0040,First_Name_M0040 ASC
Supplies by Patient with Pricing
to
Date Format: mm/dd/yyyy
Supplies by Patient with Pricing
Patient Cert Period Visit Date Units Price Total Supply

No Patient Supplies information was found.

Data will start to show here once you add Supplies to Patient Visit records.
#Last_Name_M0040#, #First_Name_M0040# #DateFormat(Certification_Start, "mm/dd/yy")# - #DateFormat(Certification_End, "mm/dd/yy")# #DateFormat(Visit_Date, 'mm/dd/yy')# #Total_Units# $#DecimalFormat(Price)# $#DecimalFormat(Total_Price)# #Supply#
Total #DollarFormat(PTot)# #DollarFormat(TTot)#