SELECT Agency_Name, CAHPS, Agency_Medicare_ID, Natl_Provider_ID, Agency_Branch_ID
,DATE_FORMAT('#FORM.monthYear#', "%m") AS trueMonth
FROM #Request.prefix_db_lookup#.Agency
WHERE Agency_ID = '#session.AgencyId#'
SELECT ifnull(count(Schedule_ID),0) as LookBack FROM
#Request.prefix_db_agency#.pSchedules
INNER JOIN #Request.prefix_db_agency#.pPatients ON pSchedules.Patient_ID = pPatients.Patient_ID
AND pPatients.Status In (0,1,4)
INNER JOIN #Request.prefix_db_agency#.pAssessments ON pSchedules.Assmt_ID = pAssessments.Assmt_ID
AND pAssessments.status = 0
INNER JOIN #Request.prefix_db_lookup#.Agency ON pPatients.Loc_ID = Agency.Agency_ID
LEFT OUTER JOIN #Request.prefix_db_lookup#.pEmployee ON pSchedules.Emp_ID = pEmployee.Emp_ID
WHERE pPatients.Patient_ID = #ListItem#
AND pSchedules.Visit_Date < DATE_ADD('#FORM.monthYear#', INTERVAL 1 MONTH)
AND pSchedules.Status = 0
AND pSchedules.Visit_Type <> 'Assessment'
GROUP BY pPatients.Patient_ID
SELECT ifnull(count(Schedule_ID),0) as SkilledVisitsTotalCount FROM
#Request.prefix_db_agency#.pSchedules
INNER JOIN #Request.prefix_db_agency#.pPatients ON pSchedules.Patient_ID = pPatients.Patient_ID
AND pPatients.Status In (0,1,4)
INNER JOIN #Request.prefix_db_agency#.pAssessments ON pSchedules.Assmt_ID = pAssessments.Assmt_ID
AND pAssessments.status = 0
INNER JOIN #Request.prefix_db_lookup#.Agency ON pPatients.Loc_ID = Agency.Agency_ID
LEFT OUTER JOIN #Request.prefix_db_lookup#.pEmployee ON pSchedules.Emp_ID = pEmployee.Emp_ID
WHERE pPatients.Patient_ID = #ListItem#
AND pSchedules.Visit_Date < DATE_ADD('#FORM.monthYear#', INTERVAL 1 MONTH)
AND pSchedules.Status = 0
AND pSchedules.Skill IN ('SN','PT','OT','ST')
GROUP BY pPatients.Patient_ID
SELECT pPatients.Pt_Last, pPatients.Pt_First, pEmployee.Emp_Last, pPatients.Patient_ID,
pSchedules.Visit_Date, pSchedules.StartTime, pSchedules.EndTime, pSchedules.Total_Units, pSchedules.Schedule_ID,
pAssessments.F26, "" AS Current_Payment_Sources_M0150,pAssessments.Assmt_ID,
pPatients.Pt_Middle, pPatients.Pt_Suffix, pPatients.Pt_Street, pPatients.Email,
pPatients.Pt_City, pPatients.Pt_State, pPatients.Pt_Zip, pPatients.Pt_Gender, pPatients.Pt_DOB,
pPatients.Pt_Phone, pPatients.Pt_Agy_ID, "" AS Financial_Factors_M0150, pSchedules.Skill AS Visit_Type,
pAdmit.Admission_Source AS Source_of_Admission, pAssessments.F26 AS Assessment_Reason_M0100,
pAdmit.M0030_START_CARE_DT AS Start_of_Care_M0030, pAssessments.F181 AS Date_Discharge_M0906,
pAssessments.F33 AS Discharged_From_M0175, pAssessments.F78 AS Dress_Upper_M0650,
pAssessments.F79 AS Dress_Lower_M0660, pAssessments.F80 AS Bathing_M0670,
pAssessments.F81 AS M1840_Toilet, pAssessments.F83 AS Transferring_M0690,
pAssessments.F163 AS Eating_M0710, "" AS M1016_DX_NA, pAssessments.F77 AS Grooming_M0640,
pAssessments.F82 AS Toileting_M0680, pAssessments.F84 AS Ambulation_M0700,
"" AS Meal_Prep_M0720, pAssessments.F29 AS Transport_M0730, "" AS Laundry_M0740,
"" AS Shopping_M0760, "" AS Housekeeping_M0750, "" AS Use_Phone_M0770,
pAssessments.F82 AS M1845_Toilet, COUNT(pSchedules.Schedule_ID) as LookBack
FROM #Request.prefix_db_agency#.pSchedules
INNER JOIN #Request.prefix_db_agency#.pPatients ON pSchedules.Patient_ID = pPatients.Patient_ID
INNER JOIN #Request.prefix_db_lookup#.pEmployee ON pSchedules.Emp_ID = pEmployee.Emp_ID
INNER JOIN #Request.prefix_db_agency#.pAssessments ON pSchedules.Assmt_ID = pAssessments.Assmt_ID
INNER JOIN #Request.prefix_db_agency#.pAdmit ON pAdmit.Admit_ID = pAssessments.Admit_ID
INNER JOIN #Request.prefix_db_lookup#.Agency ON pPatients.Loc_ID = Agency.Agency_ID
WHERE pPatients.Patient_ID = #ListItem#
AND pSchedules.Status = 0
AND LEFT(pAssessments.F26,1) IN ( '1','4','9')
AND pAssessments.Status = 0
AND pAssessments.F177 <> '0000-00-00'
AND pAssessments.F178 <> '0000-00-00'
AND pSchedules.Visit_Date > DATE_SUB('#FORM.monthYear#', INTERVAL 1 MONTH)
AND pSchedules.Visit_Date < DATE_ADD('#FORM.monthYear#', INTERVAL 1 MONTH)
AND pSchedules.Emp_ID <> 0
AND pPatients.Status IN (0,1,4)
AND pAdmit.Status = 0
AND pPatients.Patient_ID IN (
SELECT ps2.Patient_ID
FROM #Request.prefix_db_agency#.pSchedules ps2
INNER JOIN #Request.prefix_db_agency#.pAssessments pa2 ON ps2.Assmt_ID = pa2.Assmt_ID
WHERE ps2.Status = 0
AND pa2.Status = 0
AND ps2.Skill IN ('SN', 'PT', 'OT', 'SLP')
AND ps2.Visit_Date > DATE_SUB('#FORM.monthYear#', INTERVAL 1 MONTH)
AND ps2.Visit_Date < DATE_ADD('#FORM.monthYear#', INTERVAL 1 MONTH)
GROUP BY ps2.Patient_ID
HAVING COUNT(DISTINCT ps2.Schedule_ID) >= 2
)
AND pPatients.Patient_ID IN (
SELECT pp.Patient_ID
FROM #Request.prefix_db_agency#.pPtPayer pp
INNER JOIN #Request.prefix_db_agency#.pPayer p ON pp.Payer_ID = p.Pay_ID
WHERE pp.Payer_Responsibility = 'P - Primary'
AND (LEFT(p.M0150, 1) IN (1,3))
AND pp.Status < 2
AND p.Status = 0
)
GROUP BY pPatients.Patient_ID
SELECT *,pPayer.Output AS payoutput FROM #Request.prefix_db_agency#.pPtPayer
JOIN #Request.prefix_db_agency#.pPayer ON pPtPayer.Payer_ID = pPayer.Pay_ID
WHERE Patient_ID = #Patient_ID#
SELECT * FROM GetPayer WHERE payoutput = 'Medicare'
SELECT * FROM #Request.prefix_db_agency#.pProblem
JOIN #Request.prefix_db_agency#.pAssessments ON pProblem.Assmt_ID = pAssessments.Assmt_ID
WHERE
pProblem.status =
AND pAssessments.status =
AND pAssessments.Patient_ID =
AND LEFT(pAssessments.F26,1) IN ( '1','4' )
AND (M0_No like 'M1021%' OR M0_No like 'M1023%')
GROUP BY Problem_ID
SELECT * FROM problems
WHERE M0_No like 'M1021%'
and Status = 0
SELECT * FROM problems
WHERE M0_No like 'M1023%'
and Status = 0
0>
#cfcatch.Message# :: #cfcatch.Detail#
CAHPS
You reached this page by error. Plesae submit the CAHPS Form located Here