// 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,
(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,
"" 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.Visit_Date <= Now()
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)