HHA System Administration

SELECT e.*, a.Agency_Name, p.Last_Name_M0040, p.First_Name_M0040, p.DOB_M0066, p.Gender_M0069, p.Medicare_Number_M0063, a.Natl_Provider_ID as ANPI FROM #Request.prefix_db_agency#.Eligibility e, #Request.prefix_db_agency#.patient p, #Request.prefix_db_lookup#.Agency a Where e.Verification_Date = '#today#' and e.Patient_ID = p.Patient_ID and a.Agency_ID = p.Agency_ID and e.Start_Date = '2013-01-01' and e.Expiration_Date = '2013-01-01' order by a.Agency_Name HHA System Administration Superadmin Home

Eligibilities to Verify Today

#today#

Agency Name	NPI	Last Name	First Name	Medicare#	DOB	Gender	Update
#Agency_Name#	#ANPI#	#Last_Name_M0040#	#First_Name_M0040#	#Medicare_Number_M0063#	#DateFormat(DOB_M0066, 'mm/dd/yyyy')#	#Gender_M0069#	Update