Medicare Episode Reimbursement for #Form.From_Date# to #Form.To_Date#

SELECT pPatients.Loc_ID AS Agency, pAssessments.Patient_ID, pAssessments.Assmt_ID, pAssessments.F26 AS Assessment_Reason_M0100, "" AS Claim_Key,pAssessments.F299 AS Reimburse, pAdmit.M0030_START_CARE_DT AS Start_of_Care_M0030, pAssessments.F25 AS Admission_Status, pAssessments.F176 AS Assessment_Completed_M0090, pAssessments.F177 AS Certification_End, pPatients.Patient_ID, pPatients.WageIndex, pPatients.UrbanRural as Rural, pPatients.Pt_Last AS PatientLast, pPatients.Pt_First AS PatientFirst, pPatients.Pt_Gender, pPatients.Pt_DOB, pPatients.Pt_Zip, pAssessments.F300 AS HIPPS_Code, "" AS Weight, pPayer.Pay_Name FROM #Request.prefix_db_agency#.pPatients INNER JOIN #Request.prefix_db_agency#.pAssessments ON pPatients.Patient_ID = pAssessments.Patient_ID JOIN #Request.prefix_db_agency#.pAdmit ON pAdmit.Admit_ID = pAssessments.Admit_ID AND pAdmit.Status = 0 LEFT JOIN #Request.prefix_db_agency#.pPtPayer ON pPtPayer.Patient_ID = pPatients.Patient_ID AND pPtPayer.Status = 0 LEFT JOIN #Request.prefix_db_agency#.pPayer ON pPtPayer.Payer_ID = pPayer.Pay_ID AND pPayer.Status = 0 AND pPayer.Output = 'Medicare' INNER JOIN #Request.prefix_db_lookup#.Agency ON pPatients.Loc_ID = Agency.Agency_ID WHERE pAssessments.F300 IS NOT NULL AND pAssessments.Status = 0 AND pAssessments.F25 = 1 AND pPatients.Status < 2 AND (pAssessments.F26 LIKE '1%' OR pAssessments.F26 LIKE '4%') AND pAssessments.F176 BETWEEN #CreateODBCDate(Form.From_Date)# AND #CreateODBCDate(Form.To_Date)# ORDER BY pPatients.Pt_Last, pAssessments.F176 DESC

PATIENT	DATE COMPLETED	ASSESSMENT	PAYER	HIPPS CODE	AMOUNT
#PatientLast#, #PatientFirst# #WageIndex#, #Rural#, #CaseMixWeight#	#DateFormat(Assessment_Completed_M0090, "mm/dd/yyyy")#	#Assessment_Reason_M0100#	#Pay_Name#	#HIPPS_Code#	#LSCurrencyFormat(Reimburse, "local",'en_US')#