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, DATEDIFF(now(),pAssessments.F177) AS aging, 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#.pCMS4857 WHERE Assmt_ID = pAssessments.Assmt_ID AND Status = 0 AND (Form_Type="Form 485" OR Form_Type="Form 487") ) AS orders485, (SELECT pAss.F25 FROM #Request.prefix_db_agency#.pAssessments pAss WHERE pAss.Patient_ID = pAssessments.Patient_ID AND pAss.Admit_ID = pAssessments.Admit_ID AND pAss.F26 = ( CASE WHEN (pSchedules.Visit_Type = "1 - SOC - SN" ) THEN '1 - Start of care - further visits planned' WHEN (pSchedules.Visit_Type = "1 - SOC - PT" ) THEN '1 - Start of care - further visits planned - Physical Therapy' WHEN (pSchedules.Visit_Type = "1 - SOC - OT" ) THEN '1 - Start of care - further visits planned - Occupational Therapy' WHEN (pSchedules.Visit_Type = "3 - ROC - SN" || pSchedules.Visit_Type = "3 - ROC - PT") THEN '3 - Resumption of care (after inpatient stay)' WHEN (pSchedules.Visit_Type = "PT Eval" ) THEN 'PT Adult Evaluation' WHEN (pSchedules.Visit_Type = "OT Eval" ) THEN 'OT Adult Evaluation' WHEN (pSchedules.Visit_Type = "ST Eval" ) THEN 'ST Adult Evaluation' WHEN (pSchedules.Visit_Type = "SN Eval" ) THEN 'SN Adult Evaluation' WHEN (pSchedules.Visit_Type = "MSW Eval" ) THEN 'MSW Evaluation' WHEN (pSchedules.Visit_Type = "PT FU Eval" ) THEN 'PT Followup' WHEN (pSchedules.Visit_Type = "OT FU Eval" ) THEN 'OT Followup' WHEN (pSchedules.Visit_Type = "ST FU Eval" ) THEN 'ST Followup' WHEN (pSchedules.Visit_Type = "MSW FU Eval" ) THEN 'MSW Followup' WHEN (pSchedules.Visit_Type = "SN FU Eval" ) THEN 'SN Followup' WHEN (pSchedules.Visit_Type = "Hospice Comprehensive" ) THEN 'Hospice Comprehensive' WHEN (pSchedules.Visit_Type = "SN Hospice" ) THEN 'SN Hospice' WHEN (pSchedules.Visit_Type = "Chaplain Comprehensive Evaluation" ) THEN 'Chaplain Comprehensive Evaluation' WHEN (pSchedules.Visit_Type = "Hospice Discharge" ) THEN 'Hospice Discharge' WHEN (pSchedules.Visit_Type = "4 - Recertification" ) THEN '4 - Recertification (follow-up) reassessment' WHEN (pSchedules.Visit_Type = "4 - Recertification PT" ) THEN '4 - Recertification (follow-up) reassessment - PT' WHEN (pSchedules.Visit_Type = "4 - Recertification OT" ) THEN '4 - Recertification (follow-up) reassessment - OT' WHEN (pSchedules.Visit_Type = "5 - Other follow-up" ) THEN '5 - Other follow-up' WHEN (pSchedules.Visit_Type = "6 - Transfer no discharge" ) THEN '6 - Transferred to an inpatient facility - patient not discharged from agency' WHEN (pSchedules.Visit_Type = "7 - Transfer discharged" ) THEN '7 - Transferred to an inpatient facility - patient discharged from agency' WHEN (pSchedules.Visit_Type = "8 - Death" ) THEN '8 - Death at home' WHEN (pSchedules.Visit_Type = "9 - Discharge from agency" ) THEN '9 - Discharge from agency' ELSE 0 END ) AND pAss.Status = 0 AND pSchedules.Visit_Date = pAss.F176 ORDER BY F25 ASC LIMIT 0,1) AS assessments_completed, (SELECT count(*) FROM #Request.prefix_db_agency#.pSchedules WHERE pSchedules.Status = 0 AND pAssessments.Assmt_ID = pSchedules.Assmt_ID AND pSchedules.Invoice_ID != 0 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, pPayer.Pay_ID AS PPAYID, pPayer.Pay_Name, pPayer.Output AS POUT,pPayer.Submitter_ID,pPayer.Receiver_ID, pPayer.PayerSource,pPayer.Payer_No,"1" AS Provider_ID FROM #Request.prefix_db_agency#.pSchedules JOIN #Request.prefix_db_agency#.pPatients ON pPatients.Patient_ID = pSchedules.Patient_ID JOIN #Request.prefix_db_lookup#.pEmployee ON pSchedules.Emp_ID = pEmployee.Emp_ID JOIN #Request.prefix_db_agency#.pAssessments ON pAssessments.Assmt_ID = pSchedules.Assmt_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 pPayer.NOA_req = 1 AND pSchedules.Invoice_ID = 0 AND pSchedules.Nonbillable = 0 AND pPtPayer.status = 0 AND pSchedules.NOA = 0 AND pSchedules.Visit_Date <= Now() AND pSchedules.Visit_Type like '1%' AND pAssessments.F26 like '1%' GROUP BY pSchedules.Assmt_ID ORDER BY First_Name_M0040,pSchedules.Visit_Date ASC

NOAs Ready to Bill

Wage Index has not been set in the Agency Form. You will not be able to process RAPs.

SELECT * FROM #Request.prefix_db_agency#.pPtPayer JOIN #Request.prefix_db_agency#.pPayer on pPtPayer.Payer_ID = pPayer.Pay_ID WHERE pPayer.status = 0 GROUP BY pPayer.Pay_ID SELECT * FROM GetRAP WHERE Payer_ID = '#Pay_ID#' AND invoicecount = 0 AND aging >= 0

#Pay_Name#	#RAP_count#	No. Fix now. YES

UPDATE #Request.prefix_db_lookup#.Agency SET noa_count = WHERE Agency_ID = UPDATE #Request.prefix_db_lookup#.pEmployee SET Emp_noa_count = #Emp_noa_count# WHERE Emp_ID = #session.EmployeeID# UPDATE #Request.prefix_db_agency#.Dash_emp_count SET status = 1 WHERE status = 0 AND Header = AND Emp_ID = INSERT INTO #Request.prefix_db_agency#.Dash_emp_count (Daily_QA_Date, Emp_ID, Emp_Count, Header, Created_Date, status) VALUES ( , , , , , )