SELECT p.Pay_Name, DATE_FORMAT(si.Visit_Date, '%m/%d/%Y') as Visit_Date, pPatients.Pt_Last, pPatients.Pt_First, COALESCE(pEmployee.Emp_Last, '') as Emp_Last, COALESCE(pEmployee.Emp_First, '') as Emp_First, CASE WHEN pRevenue_Code.Visit_Type = 'Medical Social Worker' THEN 'MSW' ELSE COALESCE(pRevenue_Code.Visit_Type, '') END as Visit_Type, COALESCE(si.Progress_Note, '0') as Progress_Note, si.Total_Units, (si.Total_Units/4) as Total_Hours, pRevenue_Code.EClaim_Price, pRevenue_Code.Measure, CASE WHEN pRevenue_Code.Measure = 'visit' THEN COALESCE(pRevenue_Code.EClaim_Price, 0) WHEN pRevenue_Code.Measure IN ('.25', '1') THEN COALESCE(pRevenue_Code.EClaim_Price, 0) * si.Total_Units ELSE COALESCE(si.Total_EClaim, 0) END as Calculated_Charge, COALESCE(si.Total_EPay, 0) as Total_EPay ,COALESCE(zc.County, '') as County ,pRevenue_Code.Visit_Type as Skill ,pPatients.Pt_Gender as Gender ,CASE WHEN pPatients.Pt_DOB IS NULL THEN '' WHEN DATEDIFF(CURDATE(), pPatients.Pt_DOB) < 365 THEN '< 1 year' WHEN DATEDIFF(CURDATE(), pPatients.Pt_DOB) BETWEEN 365 AND 1824 THEN '1-4' WHEN DATEDIFF(CURDATE(), pPatients.Pt_DOB) BETWEEN 1825 AND 5474 THEN '5-14' WHEN DATEDIFF(CURDATE(), pPatients.Pt_DOB) BETWEEN 5475 AND 8760 THEN '15-24' WHEN DATEDIFF(CURDATE(), pPatients.Pt_DOB) BETWEEN 9125 AND 16060 THEN '25-44' WHEN DATEDIFF(CURDATE(), pPatients.Pt_DOB) BETWEEN 16425 AND 23360 THEN '45-64' WHEN DATEDIFF(CURDATE(), pPatients.Pt_DOB) BETWEEN 23725 AND 27010 THEN '65-74' WHEN DATEDIFF(CURDATE(), pPatients.Pt_DOB) BETWEEN 27375 AND 30660 THEN '75-84' WHEN DATEDIFF(CURDATE(), pPatients.Pt_DOB) >= 31025 THEN '85+' ELSE '' END as AgeRange ,pPatients.Pt_Race as Race ,pa.Admit_Type ,COALESCE(pRevenue_Code_HCPCS.HCPCS, '') as HCPCSDescription ,COALESCE(pProblem.Description, '') as PrimaryDiagnosis FROM #Request.prefix_db_agency#.pSchedules si JOIN #Request.prefix_db_agency#.pPtPayer pt ON pt.PtPayer_ID= si.PtPayer_ID JOIN #Request.prefix_db_agency#.pPayer p ON pt.Payer_ID = p.Pay_ID JOIN #Request.prefix_db_agency#.pAssessments an ON an.Assmt_ID = si.Assmt_ID JOIN #Request.prefix_db_agency#.pPatients ON pPatients.Patient_ID = si.Patient_ID AND pPatients.status IN (#Request.patient_status#) JOIN #Request.prefix_db_agency#.pRevenue_Code ON pRevenue_Code.Rev_CodeID = si.Rev_ID AND pRevenue_Code.status = 0 LEFT OUTER JOIN #Request.prefix_db_lookup#.pEmployee ON pEmployee.Emp_ID = si.Emp_ID JOIN ( SELECT pa1.Patient_ID, pa1.Admit_ID, pa1.M0104_PHYSN_RFRL_DT AS Latest_Refer FROM #Request.prefix_db_agency#.pAdmit pa1 JOIN ( SELECT Patient_ID, MAX(M0104_PHYSN_RFRL_DT) AS Latest_Refer FROM #Request.prefix_db_agency#.pAdmit WHERE Status = 0 GROUP BY Patient_ID ) lx ON lx.Patient_ID = pa1.Patient_ID AND pa1.M0104_PHYSN_RFRL_DT = lx.Latest_Refer WHERE pa1.Status = 0 ) pa_latest ON pa_latest.Patient_ID = pPatients.Patient_ID JOIN #Request.prefix_db_agency#.pAdmit pa ON pa.Admit_ID = pa_latest.Admit_ID AND pa.Status =0 AND an.Admit_ID = pa.Admit_ID JOIN #Request.prefix_db_agency#.pAuths auth ON auth.Auth_ID = si.Auth_ID AND auth.Status =0 LEFT JOIN #Request.prefix_db_agency#.pProblem ON pProblem.Assmt_ID = an.Assmt_ID AND pProblem.dx_order = 1 AND pProblem.M0_No LIKE '%M1021%' AND pProblem.status = 0 LEFT JOIN #Request.prefix_db_lookup#.vetted_190924 v ON pProblem.Description = v.Diagnosis LEFT JOIN #Request.prefix_db_lookup#.zip_cbsa zc ON LEFT(pPatients.Pt_Zip,5) = zc.ZipCode LEFT JOIN #Request.prefix_db_agency#.pRevenue_Code pRevenue_Code_HCPCS ON pRevenue_Code_HCPCS.Rev_CodeID = si.HCPCS_ID AND pRevenue_Code_HCPCS.status = 0 WHERE p.Loc_ID = '#session.AgencyId#' AND si.Status = 0 AND pt.Status = 0 AND p.Status = 0 AND an.Status = 0 AND si.Missed = '0' AND si.Visit_Date BETWEEN #CreateODBCDate(Form.From_Date)# AND #CreateODBCDate(Form.To_Date)# AND p.GL_Account IN ( ) AND LEFT(pPatients.Pt_Zip,5) IN ( SELECT ZipCode FROM #Request.prefix_db_lookup#.zip_cbsa WHERE County IN ( ) ) AND p.Pay_ID IN ( ) AND pRevenue_Code.Visit_Type IN ( ) AND pPatients.Pt_Gender IN ( ) AND pPatients.Pt_Race IN ( ) AND ( (pPatients.Pt_DOB IS NOT NULL AND DATEDIFF(CURDATE(), pPatients.Pt_DOB) < 365) (pPatients.Pt_DOB IS NOT NULL AND DATEDIFF(CURDATE(), pPatients.Pt_DOB) BETWEEN 365 AND 1460) (pPatients.Pt_DOB IS NOT NULL AND DATEDIFF(CURDATE(), pPatients.Pt_DOB) BETWEEN 1825 AND 5110) (pPatients.Pt_DOB IS NOT NULL AND DATEDIFF(CURDATE(), pPatients.Pt_DOB) BETWEEN 5475 AND 8760) (pPatients.Pt_DOB IS NOT NULL AND DATEDIFF(CURDATE(), pPatients.Pt_DOB) BETWEEN 9125 AND 16060) (pPatients.Pt_DOB IS NOT NULL AND DATEDIFF(CURDATE(), pPatients.Pt_DOB) BETWEEN 16425 AND 23360) (pPatients.Pt_DOB IS NOT NULL AND DATEDIFF(CURDATE(), pPatients.Pt_DOB) BETWEEN 23725 AND 27010) (pPatients.Pt_DOB IS NOT NULL AND DATEDIFF(CURDATE(), pPatients.Pt_DOB) BETWEEN 27375 AND 30660) (pPatients.Pt_DOB IS NOT NULL AND DATEDIFF(CURDATE(), pPatients.Pt_DOB) >= 31025) (1=0) OR ) AND pa.Admit_Type IN ( ) AND pPatients.Pt_Race IN ( ) AND pRevenue_Code_HCPCS.HCPCS IN ( ) AND v.SUBCHAPTER IN ( 'A00-A09','A15-A19','A20-A28','A30-A49','A50-A64','A65-A69','A70-A74','A75-A79','A80-A89','A90-A99','B00-B09','B10-B10','B15-B19','B20-B20','B25-B34','B35-B49','B50-B64','B65-B83','B85-B89','B90-B94','B95-B97','B99-B99' 'C00-C14','C15-C26','C30-C39','C40-C41','C43-C44','C45-C49','C50-C50','C51-C58','C60-C63','C64-C68','C69-C72','C73-C75','C76-C80','C7A-C7A','C7B-C7B','C81-C96','D00-D09','D10-D36','D37-D48','D3A-D3A','D49-D49' 'E00-E07','E20-E35','E36-E36','E40-E46','E50-E64','E65-E68','E70-E88','E89-E89' 'D50-D53','D55-D59','D60-D64','D65-D69','D70-D77','D78-D78','D80-D89' 'F01-F09','F10-F19','F20-F29','F30-F39','F40-F48','F50-F59','F60-F69','F70-F79','F80-F89','F90-F98','F99-F99' 'G00-G09','G10-G14','G20-G26','G30-G32','G35-G37','G40-G47','G50-G59','G60-G65','G70-G73','G80-G83','G89-G99','H00-H05','H10-H11','H15-H22','H25-H28','H30-H36','H40-H42','H43-H44','H46-H47','H49-H52','H53-H54','H55-H57','H59-H59','H60-H62','H65-H75','H80-H83','H90-H94','H95-H95' 'I00-I02','I05-I09','I10-I16','I20-I25','I26-I28','I30-I52','I60-I69','I70-I79','I80-I89','I95-I99' 'J00-J06','J09-J18','J20-J22','J30-J39','J40-J47','J60-J70','J80-J84','J85-J86','J90-J94','J95-J95','J96-J99' 'K00-K14','K20-K31','K35-K38','K40-K46','K50-K52','K55-K64','K65-K68','K70-K77','K80-K87','K90-K95' 'N00-N08','N10-N16','N17-N19','N20-N23','N25-N29','N30-N39','N40-N53','N60-N65','N70-N77','N80-N98','N99-N99' 'L00-L08','L10-L14','L20-L30','L40-L45','L49-L54','L55-L59','L60-L75','L76-L76','L80-L99' 'M00-M02','M04-M04','M05-M14','M15-M19','M20-M25','M26-M27','M30-M36','M40-M43','M45-M49','M50-M54','M60-M63','M65-M67','M70-M79','M80-M85','M86-M90','M91-M94','M95-M95','M96-M96','M97-M97','M99-M99' 'Q00-Q07','Q10-Q18','Q20-Q28','Q30-Q34','Q35-Q37','Q38-Q45','Q50-Q56','Q60-Q64','Q65-Q79','Q80-Q89','Q90-Q99' 'R00-R09','R10-R19','R20-R23','R25-R29','R30-R39','R40-R46','R47-R49','R50-R69','R70-R79','R80-R82','R83-R89','R90-R94','R97-R97','R99-R99' 'S00-S09','S10-S19','S20-S29','S30-S39','S40-S49','S50-S59','S60-S69','S70-S79','S80-S89','S90-S99','T07-T07','T14-T14','T15-T19','T20-T25','T26-T28','T30-T32','T33-T34','T36-T50','T51-T65','T66-T78','T79-T79','T80-T88' 'B20' 'E08-E13','E15-E16' 'P00-P04','P05-P08','P09-P09','P10-P15','P19-P29','P35-P39','P50-P61','P70-P74','P76-P78','P80-P83','P84-P84','P90-P96' 'Z20-Z29','Z55-Z65','Z77-Z79' 'Z30-Z39' 'Z39-Z39.2' 'Z40-Z53','Z69-Z76','Z77-Z99' 'V00-V09','V10-V19','V20-V29','V30-V39','V40-V49','V50-V59','V60-V69','V70-V79','V80-V89','V90-V94','V95-V97','V98-V99','W00-W19','W20-W49','W50-W64','W65-W74','W85-W99','X00-X08','X10-X19','X30-X39','X50-X50','X52-X58','X71-X83','X92-Y09','Y21-Y33','Y35-Y38','Y62-Y69','Y70-Y82','Y83-Y84','Y90-Y99' \'\' , ) GROUP BY si.Schedule_ID ORDER BY p.Pay_Name, si.Visit_Date, pPatients.Pt_Last, pPatients.Pt_First

Export file

Please Right Click Here and choose "Save Target As..." to download the Exported data file and save it to your computer.

Click Here to start a new Visits by Payer Report search.

No data could be found based on your search criteria.

Please try again.