<!---
This file is Copyright © 1998-2009 by Home Care Business Services. This work may not be reproduced, in whole or in part, 
using any medium, including, but not limited to, electronic transmission, CD-ROM or published in print, without the express 
permission of Home Care Business Services.

$Revision: 1.2 $
$Id: inactive_patients.cfm,v 1.2 2009/02/16 20:14:42 arlen Exp $
$Date: 2009/02/16 20:14:42 $
--->


<!--- Page specific code, such as queries and variable settings should go here --->
<cfquery  datasource="#Application.DataSrc#" name="GetPatients">
	SELECT 	patient.Last_Name_M0040, patient.First_Name_M0040, patient.Street_Address, patient.City, patient.State_M0050, patient.Zip_M0060, patient.Telephone
	FROM #Request.prefix_db_agency#.patient
	WHERE patient.Agency_ID = #session.AgencyID#
	AND patient.Status = 'inactive'
	ORDER BY patient.Last_Name_M0040 ASC
</cfquery>

<!--- End page specific code --->

					<cfset Patient_Ctr = 0>
					<h1>Inactive Patients</h1>
					<cfoutput query="GetPatients">
						<b>#Last_Name_M0040#, #First_Name_M0040# - #Street_Address#, #City#, #State_M0050# #Zip_M0060#<cfif Telephone IS NOT ""> - Phone: #Telephone#</cfif></b><br>
						<cfset Patient_Ctr = Patient_Ctr + 1>
					</cfoutput>
					<cfoutput><p><b>Total inactive patients: #Patient_Ctr#</b></cfoutput>

