select agency_id from #Request.prefix_db_lookup#.Agency where status='active' ORDER BY agency_id SELECT p.Agency_ID, a.Agent_FEIN, a.Agency_Name, a.Natl_Provider_ID as ANPI, p.Patient_ID, p.Last_Name_M0040, p.First_Name_M0040, p.Medicare_Number_M0063, p.SSN_M0064, p.DOB_M0066, p.Gender_M0069, p.Record_Creation_Date, DATE_ADD(p.Record_Creation_Date,INTERVAL 60 DAY) FROM #Request.prefix_db_agency#.patient p, #Request.prefix_db_lookup#.Agency a, #Request.prefix_db_agency#.Payer y WHERE p.Patient_ID = '#url.PID#' and p.Agency_ID = a.Agency_ID and p.Payer_ID = y.Payer_ID and y.Output_Type = 'Medicare' AND p.Status = 'active' ~ GS*HS*0000000000*CMS*#DateFormat(Now(), "YYYYMMDD")#*#DateFormat(Now(),"HHMMSS")#*1111*X*005010X279A1~ ST*270*0001*005010X279A1~ BHT*0022*13*1111*#DateFormat(Now(), "YYYYMMDD")#*#DateFormat(Now(), "HHMM")#~ HL*1**20*1~ NM1*PR*2*CMS*****PI*MEDX~ HL*2*1*21*1~ NM1*1P*2*#UCase(Agency_Name)#*****XX*#ANPI#~ HL*3*2*22*0~ TRN*1*#Patient_ID#*000~ NM1*IL*1*#UCase(Last_Name_M0040)#*#UCase(First_Name_M0040)#****MI*#UCase(Medicare_Number_M0063)#~ DMG*D8*#DateFormat(DOB_M0066,"yyyymmdd")#*#Gender#~ DTP*291*RD8*#DateFormat(DATEFROM,"yyyymmdd")#-#DateFormat(DATETO,"yyyymmdd")#~ EQ*30^42~ III*ZZ*12~ SE*14*0001~ GE*1*1111~ IEA*1*000001111~"> #session.AgencyLogin#, #session.AgencyName# - #Trim(GetData.First_Name_M0040)# #Trim(GetData.Last_Name_M0040)#, Medicare No. #Trim(GetData.Medicare_Number_M0063)#, DOB #DateFormat(GetData.DOB_M0066, "mm/dd/yyyy")#

#finaldata#

Melissa Cott
vox 888-710-6888 x2
fax 207-221-9995
melissa@myhomecarebiz.com
Eligibility Report

#Trim(GetData.First_Name_M0040)# #Trim(GetData.Last_Name_M0040)# patient Eligibility have uploaded sucessfully


if you need to go back Report..So Please Click here

select * from #Request.prefix_db_agency#.Eligibility_Report JOIN #Request.prefix_db_agency#.patient on patient.Patient_ID = Eligibility_Report.Patient_ID JOIN #Request.prefix_db_agency#.Payer on Payer.Payer_ID = patient.Payer_ID
Eligibility Report
Patient Name Period Checked(12 months) Status Last Checked Date HHA Episodes PAYERS EVENT Check?
#Last_Name_M0040#,#First_Name_M0040# #dateformat(checked_month_start,"yyyy-mm-dd")# - #dateformat(checked_month_End,"yyyy-mm-dd")# #Eligibility_Status# #Eligibility_Status# #dateformat(Last_Checked_Date,"yyyy-mm-dd")# DOLBA: #dateformat(DOLBA,"yyyy-mm-dd")# DOEBA:  #dateformat(DOEBA,"yyyy-mm-dd")# #dateformat(HHA_Episodes_Start,"yyyy-mm-dd")# - #dateformat(HHA_Episodes_End,"yyyy-mm-dd")# #Payer##PayName#