200], FORM.recordPerPage) > SELECT *, EVV AS PayerEVV FROM #Request.prefix_db_agency#.pPayer WHERE Pay_ID = '#url.ID#' select 0 AS TurboClaim from #Request.prefix_db_agency#.pPayer where Pay_ID = '#url.ID#' SELECT pPatients.Patient_ID, pPatients.Pt_Agy_ID, pPatients.Pt_Last, pPatients.Pt_First, pEmployee.Emp_Last, pEmployee.Skill_1, pEmployee.Skill_2, pEmployee.Skill_3, ( SELECT count(*) FROM #Request.prefix_db_agency#.Eligibility WHERE Patient_ID = pAssessments.Patient_ID AND PtPayer_ID = pPtPayer.PtPayer_ID AND Status = 0 ) AS Eligi, (SELECT count(*) FROM #Request.prefix_db_agency#.pCMS4857 WHERE pCMS4857.Status = 0 AND (pCMS4857.Form_Type="Form 485" OR pCMS4857.Form_Type="Form 487") AND ( pCMS4857.Form_Status IS NULL OR TRIM(IFNULL(pCMS4857.Form_Status,'')) = '' OR pCMS4857.Form_Status NOT IN ( 'Signed & Received via Fax', 'E-Signed and Received', 'Signed & Received', 'Signed and Received' ) ) AND ( (IFNULL(pSchedules.Assmt_ID,0) > 0 AND pCMS4857.Assmt_ID = pSchedules.Assmt_ID) OR ( IFNULL(pSchedules.Assmt_ID,0) = 0 AND pCMS4857.Assmt_ID = 0 AND pCMS4857.Pt_Agy_ID = pPatients.Pt_Agy_ID AND pCMS4857.Pt_First = pPatients.Pt_First AND pCMS4857.Pt_Last = pPatients.Pt_Last ) )) AS unsigned_orders, CASE WHEN pAssessments.F177 < '2020-01-01' THEN "FIRST FINAL" WHEN DATEDIFF(pSchedules.Visit_Date,pAssessments.F177) < 30 THEN "FIRST FINAL" WHEN DATEDIFF(pSchedules.Visit_Date,pAssessments.F177) >= 30 THEN "SECOND FINAL" ELSE "" END as claim_type, 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 30 DAY) ELSE pAssessments.F177 END as start_date, CASE WHEN DATEDIFF(pSchedules.Visit_Date,pAssessments.F177) < 30 THEN DATE_ADD(pAssessments.F177, INTERVAL 29 DAY) WHEN DATEDIFF(pSchedules.Visit_Date,pAssessments.F177) >= 30 THEN pAssessments.F178 ELSE pAssessments.F178 END as end_date, CASE WHEN DATEDIFF(pSchedules.Visit_Date,pAssessments.F177) <= 30 THEN true WHEN DATEDIFF(pSchedules.Visit_Date,pAssessments.F177) > 30 AND DATEDIFF(now(),pAssessments.F177) >= 30 THEN true WHEN pAssessments.F178 <= NOW() THEN TRUE ELSE false END as bill,pAssessments.F197,pAssessments.F197 AS TranStatus, pPayer.Pay_Name, CASE WHEN (pSchedules.Followup_visit = "1" ) THEN (SELECT pAss.F25 FROM #Request.prefix_db_agency#.pAssessments pAss WHERE pAss.Patient_ID = pSchedules.Patient_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) ELSE 1 END AS assessmentscompleted, pSchedules.Schedule_ID,pSchedules.PtPayer_ID, pSchedules.Nonbillable,pSchedules.Assmt_ID, pSchedules.Visit_Date, pSchedules.StartTime, pSchedules.EndTime, pSchedules.Total_Units, pSchedules.Rev_ID,pSchedules.pgnotesdraft, pSchedules.Followup_visit, pAssessments.Admit_ID, pSchedules.Total_EClaim AS Total_EClaim_old, CASE WHEN pRevenue_Code.Measure = '1' THEN ((pSchedules.Total_Units / 4) * pRevenue_Code.EClaim_Price) WHEN pRevenue_Code.Measure = '.25' THEN (pSchedules.Total_Units * pRevenue_Code.EClaim_Price) ELSE pRevenue_Code.EClaim_Price END AS Total_EClaim , pPayer.Output AS Output_Type, '' AS EClaimed, pAssessments.F26 AS Assessment_Reason_M0100, pAssessments.F177, pAssessments.F178, pSchedules.Invoice_ID, pPayer.Pay_ID ,pPtPayer.Payer_ID,pRevenue_Code.Rev_Code, pRevenue_Code.Measure,pRevenue_Code.Set_Units, pRevenue_Code.HCPCS, pPayer.auth_measure, pRevenue_Code.EClaim_Price FROM #Request.prefix_db_agency#.pSchedules JOIN #Request.prefix_db_agency#.pPatients ON pPatients.Patient_ID = pSchedules.Patient_ID AND pPatients.Status IN (#Request.patient_status#) 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 AND pPtPayer.Status = 0 JOIN #Request.prefix_db_agency#.pPayer ON pPayer.Pay_Id = pPtPayer.Payer_ID AND pPayer.Status = 0 LEFT OUTER JOIN #Request.prefix_db_agency#.pAuths ON pAuths.Auth_ID = pSchedules.Auth_ID AND pAuths.Status = 0 LEFT OUTER JOIN #Request.prefix_db_agency#.pAssessments ON ((pAssessments.Assmt_ID = pSchedules.Assmt_ID AND pAssessments.F25 = 1 AND pAssessments.Status = 0) OR (pAssessments.Assmt_ID = 0 AND pSchedules.Assmt_ID = 0 )) LEFT OUTER JOIN #Request.prefix_db_agency#.pRevenue_Code ON pSchedules.Rev_ID = pRevenue_Code.Rev_CodeID LEFT OUTER JOIN ( SELECT e1.Schedule_ID, e1.San_status FROM #Request.prefix_db_lookup#.EVV e1 INNER JOIN ( SELECT Schedule_ID, MAX(EVV_ID) as MaxEVV_ID FROM #Request.prefix_db_lookup#.EVV WHERE API_Type = 'visits' AND Agency_ID = AND status = 0 GROUP BY Schedule_ID ) e2 ON e1.Schedule_ID = e2.Schedule_ID AND e1.EVV_ID = e2.MaxEVV_ID WHERE e1.API_Type = 'visits' AND e1.Agency_ID = AND e1.status = 0 ) evv_latest ON evv_latest.Schedule_ID = pSchedules.Schedule_ID WHERE pPayer.Pay_ID = '#url.ID#' -- AND pAssessments.F26 = 1 -- AND pSchedules.Progress_Note = 1 AND pSchedules.Visit_Date < NOW() AND pSchedules.status = 0 AND pSchedules.pgnotesdraft = 2 AND pPatients.Patient_Id IS NOT NULL AND pSchedules.Missed = 0 AND pSchedules.Invoice_ID = 0 AND pSchedules.Nonbillable = 0 AND IFNULL(pSchedules.Total_Units, 0) > 0 AND TRIM(IFNULL(pRevenue_Code.HCPCS, '')) <> '' AND ( NOT ( pPayer.Auth_Req = 1 OR pPayer.Auth_Req = '1' OR UPPER(TRIM(IFNULL(pPayer.Auth_Req, ''))) IN ('ON', 'YES', 'Y', 'TRUE') ) OR TRIM(IFNULL(pAuths.Auth_No, '')) <> '' ) AND ( SELECT count(*) FROM #Request.prefix_db_agency#.pCMS4857 uo WHERE uo.Status = 0 AND (uo.Form_Type = 'Form 485' OR uo.Form_Type = 'Form 487') AND ( uo.Form_Status IS NULL OR TRIM(IFNULL(uo.Form_Status,'')) = '' OR uo.Form_Status NOT IN ( 'Signed & Received via Fax', 'E-Signed and Received', 'Signed & Received', 'Signed and Received' ) ) AND ( (IFNULL(pSchedules.Assmt_ID,0) > 0 AND uo.Assmt_ID = pSchedules.Assmt_ID) OR ( IFNULL(pSchedules.Assmt_ID,0) = 0 AND uo.Assmt_ID = 0 AND uo.Pt_Agy_ID = pPatients.Pt_Agy_ID AND uo.Pt_First = pPatients.Pt_First AND uo.Pt_Last = pPatients.Pt_Last ) ) ) = 0 AND pPatients.Patient_ID = '#FORM.pid#' AND pSchedules.Visit_Date >= #CreateODBCDate(FORM.df)# AND pSchedules.Visit_Date <= #CreateODBCDate(FORM.dt)# AND (evv_latest.San_status IS NOT NULL AND ( UPPER(evv_latest.San_status) LIKE '%TRANSACTION RECEIVED%' OR UPPER(TRIM(evv_latest.San_status)) IN ('SUCCESS', 'SUCCESSFUL') )) GROUP BY Schedule_ID ORDER BY Pt_Last, Pt_First, pAssessments.Assmt_ID, Visit_Date startRow = (FORM.tablePageNumber - 1) * FORM.recordPerPage + 1; SELECT DISTINCT Patient_ID, Pt_Last, Pt_First FROM Get_Bills ORDER BY Pt_Last, Pt_First SELECT Pay_ID AS Payer_ID FROM #Request.prefix_db_agency#.pPayer
Search
" /> to " />
Date Format: mm/dd/yyyy
Result set
   
There are no records
SELECT F25 FROM #Request.prefix_db_agency#.pAssessments WHERE Admit_ID = '#Admit_ID#' AND F176 = '#Visit_Date#' AND status = 0
Last, First Assessment Final Type Visit Date Employee Skill Units Rev Code HCPCS Total
#Pt_Last#, #Pt_First#
SOC RECERT - #DateFormat(start_date, "mm/dd/yy")# - #DateFormat(end_date, "mm/dd/yy")#
* #claim_type#
#DateFormat(Visit_Date, "mm/dd/yy")#
#Emp_Last#
#empSkillParts#
#TotalUnits# 1 0 0
#Rev_Code# #HIPPS_Code#
RAP not billed
#HCPCS# 0
#LSCurrencyFormat(DisplayTotal, "local")# #LSCurrencyFormat(DisplayTotal, "local")#
checked>
checked>