// bill = CreateObject("Component", "components.billings"); // Get_RAP = bill.get_RAP(); SELECT pPatients.Patient_ID, pPatients.Pt_Last AS Last_Name_M0040, pPatients.Pt_First AS First_Name_M0040, pPatients.Status AS PatStat, "" AS DOC, pEmployee.Emp_Last AS Last_Name, pEmployee.Emp_First AS First_Name, pSchedules.Schedule_ID, pSchedules.PtPayer_ID, "" AS ApproveBill, pSchedules.Nonbillable, pSchedules.Visit_Date, CASE WHEN DATEDIFF(pSchedules.Visit_Date,pAssessments.F177) <= 30 THEN pAssessments.F177 WHEN DATEDIFF(pSchedules.Visit_Date,pAssessments.F177) > 30 THEN DATE_ADD(pAssessments.F177, INTERVAL 31 DAY) ELSE pAssessments.F177 END as start_date, CASE WHEN DATEDIFF(pSchedules.Visit_Date,pAssessments.F177) <= 30 THEN DATE_ADD(pAssessments.F177, INTERVAL 30 DAY) WHEN DATEDIFF(pSchedules.Visit_Date,pAssessments.F177) > 30 THEN pAssessments.F178 ELSE pAssessments.F178 END as end_date, pSchedules.Total_Units, (SELECT count(*) FROM #Request.prefix_db_agency#.pSchedules WHERE pSchedules.Status = 0 AND pAssessments.Assmt_ID = pSchedules.Assmt_ID AND pSchedules.NOA != 0 ) AS invoicecount, "" AS Output_Type, "" AS EClaimed, pSchedules.Skill AS Type,pSchedules.Emp_ID, pAssessments.F26 AS Assessment_Reason_M0100, pAssessments.F177, '' AS TRANSTATUS, pAssessments.F26 AS Reason, "complete" AS Status, 0 AS Assessment_Number, pAssessments.Assmt_ID, pAssessments.F177 AS Certification_Start,pAssessments.F178 AS Certification_End, DATE_ADD(pAssessments.F177, INTERVAL 30 DAY) AS interval_30_day, pAssessments.F178, pAssessments.F300 AS HIPPS_Code, '' AS Homebound_Status, pSchedules.Invoice_ID, 0 AS Invoice_ID2, pPayer.Pay_ID AS Payer_ID, pPayer.Pay_ID AS PAYID, pPayer.Output as PAYOUT, pPayer.Pay_Name, "" AS notes FROM #Request.prefix_db_agency#.pSchedules JOIN #Request.prefix_db_agency#.pAssessments ON pAssessments.Assmt_ID = pSchedules.Assmt_ID JOIN #Request.prefix_db_agency#.pPatients ON pPatients.Patient_ID = pAssessments.Patient_ID JOIN #Request.prefix_db_lookup#.pEmployee ON pSchedules.Emp_ID = pEmployee.Emp_ID JOIN #Request.prefix_db_agency#.pPtPayer on pSchedules.PtPayer_ID = pPtPayer.PtPayer_ID JOIN #Request.prefix_db_agency#.pPayer on pPtPayer.Payer_ID = pPayer.Pay_ID WHERE pPatients.Status < 2 AND pSchedules.Status = 0 AND pAssessments.Status = 0 AND pSchedules.Missed = '0' AND pSchedules.Invoice_ID = 0 AND pSchedules.NOA = 0 AND pSchedules.Nonbillable = 0 AND pAssessments.status = 0 AND pPtPayer.status = 0 AND pSchedules.pgnotesdraft = 2 AND pPatients.Patient_ID = '#FORM.pid#' AND pAssessments.Assmt_ID NOT IN ( SELECT Assmt_ID FROM #Request.prefix_db_agency#.pSchedules WHERE Status = 0 AND Invoice_ID != 0 GROUP BY Assmt_ID ) AND pSchedules.Visit_Date >= #CreateODBCDate(FORM.df)# AND pSchedules.Visit_Date <= #CreateODBCDate(FORM.dt)# AND pAssessments.F26 like '1%' AND pSchedules.Visit_Type like '1%' AND pPayer.Pay_ID = GROUP BY pSchedules.Assmt_ID ORDER BY First_Name_M0040, pSchedules.Visit_Date ASC SELECT DISTINCT Patient_ID, Last_Name_M0040,First_Name_M0040 FROM GetRAP ORDER BY Last_Name_M0040, First_Name_M0040
Search
" /> to " />
Date Format: mm/dd/yyyy
NOAs Ready to Bill
There are no records
SELECT * FROM ( SELECT MIN(Visit_Date) AS FirstVisitDate ,'#GetRAP.Certification_Start#' as start_date, DATE_ADD('#GetRAP.Certification_Start#', INTERVAL 30 DAY) as end_date, '1' RAP, pSchedules.*, (SELECT '1' FROM #Request.prefix_db_agency#.pSchedules WHERE pSchedules.Assmt_ID = AND pSchedules.Visit_Date >= '#GetRAP.Certification_Start#' AND pSchedules.Invoice_ID !=0 AND pSchedules.status = 0 LIMIT 1 ) AS bill FROM #Request.prefix_db_agency#.pSchedules WHERE pSchedules.Assmt_ID = AND pSchedules.Visit_Date >= '#GetRAP.F177#' AND pSchedules.status = 0 AND pSchedules.Missed = 'No' AND pSchedules.Invoice_ID = 0 AND pSchedules.NOA = 0 AND pSchedules.PtPayer_ID = AND pSchedules.Nonbillable = 0 AND pSchedules.Visit_Type like '1%' AND pSchedules.Visit_Date >= #CreateODBCDate(FORM.df)# AND pSchedules.Visit_Date <= #CreateODBCDate(FORM.dt)# UNION ALL SELECT MIN(Visit_Date) AS FirstVisitDate, DATE_ADD('#GetRAP.Certification_Start#', INTERVAL 30 DAY) as start_date, '#GetRAP.Certification_End#' as end_date,'2' AS RAP , pSchedules.* ,(SELECT '1' FROM #Request.prefix_db_agency#.pSchedules WHERE pSchedules.Assmt_ID = AND pSchedules.Visit_Date >= DATE_ADD('#GetRAP.F177#', INTERVAL 30 DAY) AND pSchedules.Invoice_ID !=0 AND pSchedules.status = 0 LIMIT 1 ) AS bill FROM #Request.prefix_db_agency#.pSchedules WHERE pSchedules.Assmt_ID = AND pSchedules.Visit_Date >= DATE_ADD('#GetRAP.F177#', INTERVAL 30 DAY) AND pSchedules.status = 0 AND pSchedules.Missed = 'No' AND pSchedules.Invoice_ID = 0 AND pSchedules.NOA = 0 AND pSchedules.PtPayer_ID = AND pSchedules.Visit_Date >= #CreateODBCDate(FORM.df)# AND pSchedules.Visit_Date <= #CreateODBCDate(FORM.dt)# AND pSchedules.Nonbillable = 0 AND pSchedules.Visit_Type like '1%' GROUP BY pSchedules.Schedule_ID ) a ORDER BY Visit_Date ASC SELECT * FROM #Request.prefix_db_agency#.pSchedules JOIN #Request.prefix_db_lookup#.pEmployee ON pSchedules.Emp_ID = pEmployee.Emp_ID WHERE pSchedules.Schedule_ID = AND pSchedules.status = 0
Last, First Assessment Visit Date Employee Units HIPPS
#GetRAP.Last_Name_M0040#, #GetRAP.First_Name_M0040#
SOC SOC PT SOC OT RECERT -#DateFormat(GETRAPdates.start_date, "mm/dd/yy")#-#DateFormat(GETRAPdates.end_date, "mm/dd/yy")#
#DateFormat(GetRAP.Visit_Date,"mm/dd/yyyy")# #DateFormat(GETRAPdates.Visit_Date,"mm/dd/yyyy")#
#getsch.Emp_Last#
#getsch.Total_Units# 0
#GETRAP.HIPPS_Code#
checked>
checked>