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 Eligibility_ID = #url.ID# and e.Patient_ID = p.Patient_ID and a.Agency_ID = p.Agency_ID MyHomecareBiz.com

Update Elgibility

Agency
#GetElig.Agency_Name#
NPI
#GetElig.ANPI#
Last Name
#GetElig.Last_Name_M0040#
First Name
#GetElig.First_Name_M0040#
Medicare No.
#GetElig.Medicare_Number_M0063#
DOB
#DateFormat(GetElig.DOB_M0066, 'mm/dd/yyyy')#
Gender
#GetElig.Gender_M0069#
Verification Date
Start Date
End Date
Notes