// bill = CreateObject("Component", "components.billings");
// GetRAP = 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, pPayer.NOA_req, pAssessments.F197,
pSchedules.Schedule_ID, pSchedules.PtPayer_ID, "" AS ApproveBill, pSchedules.Visit_Date,
DATEDIFF(now(),pAssessments.F177) AS aging_old,
pSchedules.Nonbillable, pSchedules.Visit_Date,pAssessments.F300 AS HIPPS_Code,
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.Invoice_ID != 0 AND pSchedules.NOA != 0 ) AS invoicecount,
(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,
"" 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#.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 pSchedules.Invoice_ID = 0
AND pSchedules.Nonbillable = 0
AND pPtPayer.status = 0
AND pSchedules.NOA = 0
AND pSchedules.pgnotesdraft = 2
AND pSchedules.Visit_Type like '1%'
AND pAssessments.F26 like '1%'
AND pPayer.Pay_ID =
GROUP BY pSchedules.Assmt_ID
ORDER BY First_Name_M0040, pSchedules.Visit_Date ASC
Update #Request.prefix_db_agency#.pSchedules
SET status = 1,
Date_Change = ,
Change_by =
WHERE Schedule_ID = #URL.sid#
AND Status = 0
The Visit has been Deleted
Visit Compliance for #GetRAP.Pay_Name# (NOA)