SELECT 0 AS Primary_ReferringPhys_ID_M0072,'' AS Medicare_Number_M0063, pPatients.* FROM #Request.prefix_db_agency#.pPatients WHERE Patient_ID = AND Status NOT IN (2,3) SELECT pPatients.Patient_ID, pPatients.Pt_Last AS PatientLast, pPatients.Pt_First AS PatientFirst, pSchedules.Visit_Type AS F26, pSchedules.Assmt_ID, pSchedules.Schedule_ID,pSchedules.Visit_Date,pSchedules.Visit_Type,pSchedules.Skill, pEmployee.Emp_Last,pEmployee.Emp_First,pSchedules.pgnotesdraft, (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) AS assessments_completed FROM #Request.prefix_db_agency#.pSchedules JOIN #Request.prefix_db_agency#.pPatients ON pPatients.Patient_ID = pSchedules.Patient_ID LEFT OUTER JOIN #Request.prefix_db_lookup#.pEmployee ON pEmployee.Emp_ID = pSchedules.Emp_ID WHERE pPatients.Status = 0 AND pSchedules.status = 0 AND pSchedules.Missed = 0 AND pSchedules.pgnotesdraft != 2 AND pSchedules.Visit_Date < '#DateFormat(now(),"yyyy-mm-dd")#' AND pSchedules.Emp_ID = #session.EmployeeID# ORDER BY pPatients.Pt_Last ASC, pPatients.Pt_First ASC SELECT pPatients.Patient_ID, pPatients.Pt_Last AS PatientLast, pPatients.Pt_First AS PatientFirst, pEmployee.Emp_ID, pEmployee.Emp_Last, pEmployee.Emp_First, pAssessments.Assmt_ID,pAssessments.* FROM #Request.prefix_db_agency#.pAssessments JOIN #Request.prefix_db_agency#.pAdmit ON pAdmit.Admit_ID = pAssessments.Admit_ID AND pAdmit.status = 0 JOIN #Request.prefix_db_agency#.pPatients ON pPatients.Patient_ID = pAssessments.Patient_ID AND pAdmit.Patient_ID = pPatients.Patient_ID LEFT OUTER JOIN #Request.prefix_db_agency#.assessment_assign ON assessment_assign.Assmt_ID = pAssessments.Assmt_ID LEFT OUTER JOIN hhapowerpath.pEmployee ON assessment_assign.Emp_ID = pEmployee.Emp_ID WHERE pAssessments.status = 0 AND pPatients.Status = 0 AND (pAssessments.F25 IS NULL OR pAssessments.F25 = '0') AND pAssessments.F176 < '#DateFormat(now(),"yyyy-mm-dd")#' AND pPatients.Patient_ID IN (SELECT pSchedules.Patient_ID FROM #Request.prefix_db_agency#.pSchedules JOIN #Request.prefix_db_agency#.pAssessments ON pAssessments.Assmt_ID = pSchedules.Assmt_ID WHERE pSchedules.Emp_ID = AND pSchedules.Status = 0 AND pAssessments.Status =0 ) AND assessment_assign.Emp_ID = ORDER BY pPatients.Pt_Last ASC, pPatients.Pt_Last ASC, pPatients.Pt_First ASC, pEmployee.Emp_Last ASC, pEmployee.Emp_First ASC SELECT parent_oasis.F26 AS parent_assessment, parent_oasis.F176 AS parent_Assessment_Completed_M0090, pAssessments.Assmt_ID,DATEDIFF (now(),pAssessments.F176) AS daydiff, pAssessments.Record_creation_Date, pAssessments.Assmt_ID, pAssessments.F27,pAssessments.Admit_ID, pAssessments.Patient_ID, pAssessments.F25 AS admission_status, pAssessments.F26 AS Assessment_Reason_M0100, pAssessments.F177 AS Certification_Start, pAssessments.F178 AS Certification_End, pAssessments.F176 AS Assessment_Completed_M0090, pAssessments.F197 AS Transmission_status, pPatients.Pt_First, pPatients.Pt_Last, Pt_Middle, (SELECT count(*) FROM #Request.prefix_db_agency#.pCareplan WHERE pCareplan.Assmt_ID = pAssessments.Assmt_ID AND pCareplan.Status = 0 AND pCareplan.Skill = pAssessments.F27) AS careplancount, (SELECT count(*) FROM #Request.prefix_db_agency#.pCareplan WHERE pCareplan.Assmt_ID = assessment_assign.Parent_Assmt_ID AND pCareplan.Status = 0 AND pCareplan.Skill = pAssessments.F27) AS notcreatedcareplan, (SELECT count(*) FROM #Request.prefix_db_agency#.pCareplan WHERE pCareplan.Assmt_ID = assessment_assign.Parent_Assmt_ID AND pCareplan.Status = 0 AND pCareplan.Skill = pAssessments.F27 AND pCareplan.Type IN ('discharge_plan','patient_goal') AND pCareplan.Description IN ( 'add patient-stated goal','add discharge plan')) AS ptgoalsnotadded, (SELECT count(*) FROM #Request.prefix_db_agency#.pWoundsVitals WHERE Assmt_ID = pAssessments.Assmt_ID AND Status = 0 AND (Description != 'weight' OR Description != 'Weight') AND VitalOrWound = 'vital' AND (Param_Lo IS NULL OR Param_Hi IS NULL OR Param_Lo= '' OR Param_Hi = '')) AS required_vital, (SELECT count(*) FROM #Request.prefix_db_agency#.pCareplan WHERE pCareplan.Assmt_ID = assessment_assign.Parent_Assmt_ID AND pCareplan.Status = 0 AND pCareplan.Skill = pAssessments.F27 AND pCareplan.Type IN ('standing_order')) AS standingorders_count, (SELECT count(*) FROM #Request.prefix_db_agency#.pCareplan WHERE pCareplan.Assmt_ID = pAssessments.Assmt_ID AND pCareplan.Status = 0 AND pCareplan.Skill = pAssessments.F27 AND pCareplan.Type IN ('discharge_plan','patient_goal') ) AS patientgoalscount, (SELECT count(*) FROM #Request.prefix_db_agency#.pCareplan WHERE pCareplan.Assmt_ID IN ( SELECT Assmt_ID FROM #Request.prefix_db_agency#.pAssessments ass WHERE ass.Admit_ID = pAdmit.Admit_ID AND ass.Status =0) AND pCareplan.Status = 0 AND pCareplan.Skill = pAssessments.F27) AS adultcareplancount , (SELECT count(*) FROM #Request.prefix_db_agency#.pPtmeds WHERE pPtmeds.In_Home = 2 AND pPtmeds.Status = 0 AND pPatients.Patient_ID = pPtmeds.Patient_ID) AS incomplete_meds, (SELECT count(Communication.Comm_ID) FROM #Request.prefix_db_agency#.Communication JOIN #Request.prefix_db_agency#.CommunicationSubjects ON CommunicationSubjects.CommSub_ID = Communication.CommSub_ID WHERE Communication.Status = 0 AND Communication.Patient_ID = pPatients.Patient_ID AND pAdmit.M0030_START_CARE_DT < Communication.Comm_Date AND CommunicationSubjects.Subject like "Discharge Summary - PT%") AS PTdischargecount, (SELECT count(Communication.Comm_ID) FROM #Request.prefix_db_agency#.Communication JOIN #Request.prefix_db_agency#.CommunicationSubjects ON CommunicationSubjects.CommSub_ID = Communication.CommSub_ID WHERE Communication.Status = 0 AND Communication.Patient_ID = pPatients.Patient_ID AND pAdmit.M0030_START_CARE_DT < Communication.Comm_Date AND CommunicationSubjects.Subject like "Discharge Summary - OT%") AS OTdischargecount, (SELECT count(Communication.Comm_ID) FROM #Request.prefix_db_agency#.Communication JOIN #Request.prefix_db_agency#.CommunicationSubjects ON CommunicationSubjects.CommSub_ID = Communication.CommSub_ID WHERE Communication.Status = 0 AND Communication.Patient_ID = pPatients.Patient_ID AND pAdmit.M0030_START_CARE_DT < Communication.Comm_Date AND CommunicationSubjects.Subject like "Discharge Summary - ST%") AS STdischargecount, (SELECT count(Communication.Comm_ID) FROM #Request.prefix_db_agency#.Communication JOIN #Request.prefix_db_agency#.CommunicationSubjects ON CommunicationSubjects.CommSub_ID = Communication.CommSub_ID WHERE Communication.Status = 0 AND Communication.Patient_ID = pPatients.Patient_ID AND pAdmit.M0030_START_CARE_DT < Communication.Comm_Date AND CommunicationSubjects.Subject like "Discharge Summary - SN%") AS SNdischargecount, pEmployee.Emp_First,pEmployee.Emp_Last, pEmployee.Emp_ID AS Employee_ID FROM #Request.prefix_db_agency#.pAssessments JOIN #Request.prefix_db_agency#.pPatients ON pAssessments.Patient_ID = pPatients.Patient_ID JOIN #Request.prefix_db_agency#.pAdmit ON pAssessments.Admit_ID = pAdmit.Admit_ID AND pAdmit.Status = 0 LEFT OUTER JOIN #Request.prefix_db_agency#.assessment_assign ON assessment_assign.Assmt_ID = pAssessments.Assmt_ID AND assessment_assign.F26 = pAssessments.F26 JOIN #Request.prefix_db_lookup#.pEmployee ON pEmployee.Emp_ID = assessment_assign.Emp_ID LEFT OUTER JOIN #Request.prefix_db_agency#.pAssessments parent_oasis ON parent_oasis.Assmt_ID = assessment_assign.Parent_Assmt_ID Where pPatients.Loc_ID = '#session.agencyid#' AND pPatients.Status = 0 AND pAssessments.Status = 0 AND pAssessments.F25 = 1 AND (pAssessments.F26 LIKE '1%' OR pAssessments.F26 LIKE '4%' OR pAssessments.F26 LIKE 'PT Adult%' OR pAssessments.F26 LIKE 'OT Adult%' OR pAssessments.F26 LIKE 'ST Adult%' OR pAssessments.F26 LIKE 'SN Adult%' ) AND (pAssessments.F178 >= '#DateFormat(now(),"yyyy-mm-dd")#' AND parent_oasis.F176 <= '#DateFormat(now(),"yyyy-mm-dd")#') AND pPatients.Patient_ID IN (SELECT pSchedules.Patient_ID FROM #Request.prefix_db_agency#.pSchedules JOIN #Request.prefix_db_agency#.pAssessments ON pAssessments.Assmt_ID = pSchedules.Assmt_ID WHERE pSchedules.Emp_ID = AND pSchedules.Status = 0 AND pAssessments.Status =0 ) AND pAssessments.Admit_ID NOT IN (SELECT pAssessments.Admit_ID FROM agency_1150.pAssessments WHERE (pAssessments.F26 like '9%' OR pAssessments.F26 like '7%' OR pAssessments.F26 like '8%') AND pAssessments.Status =0 AND pAssessments.F25 = 1) GROUP BY pAssessments.Assmt_ID OR (LEFT(Assessment_Reason_M0100,2) EQ 'PT' AND PTdischargecount EQ 0 AND (ptgoalsnotadded GT 0 OR notcreatedcareplan EQ 0)) OR (LEFT(Assessment_Reason_M0100,2) EQ 'OT' AND OTdischargecount EQ 0 AND (ptgoalsnotadded GT 0 OR notcreatedcareplan EQ 0)) OR (LEFT(Assessment_Reason_M0100,2) EQ 'ST' AND STdischargecount EQ 0 AND (ptgoalsnotadded GT 0 OR notcreatedcareplan EQ 0)) OR (LEFT(Assessment_Reason_M0100,2) EQ 'SN' AND SNdischargecount EQ 0 AND (ptgoalsnotadded GT 0 OR notcreatedcareplan EQ 0)) > AND p.M0_No like 'M102%' GROUP BY p.Problem_ID,p.Assmt_ID ORDER BY a.F177 DESC, p.dx_order ASC SELECT pMed_Recon.*,Meds_New.Classification FROM #Request.prefix_db_agency#.pMed_Recon JOIN #Request.prefix_db_agency#.pPtmeds ON pPtmeds.PtMeds_ID = pMed_Recon.PtMeds_ID AND pPtmeds.status = 0 LEFT OUTER JOIN #Request.prefix_db_lookup#.Meds_New ON pPtmeds.Drug_ID = Meds_New.Trade_Num WHERE pMed_Recon.status = 0 AND pMed_Recon.Assmt_ID IN (#allassmt_ids#) AND (pPtmeds.DateDCed > '#DateFormat(now(),"yyyy-mm-dd")#' OR pPtmeds.DateDCed IS NULL) GROUP BY PtMeds_ID SELECT c.* , REPLACE(c.Memo, '&', '') AS comm_memo FROM #Request.prefix_db_agency#.Communication c JOIN #Request.prefix_db_agency#.CommunicationSubjects cs on cs.CommSub_Id = c.CommSub_Id WHERE c.Patient_ID = #session.cs.patientid# AND cs.Subject like 'Med Reconciliation' ORDER BY Subject SELECT pMed_Recon.* from #Request.prefix_db_agency#.pMed_Recon where pMed_Recon.status = 0 AND pMed_Recon.Assmt_ID IN (#allassmt_ids#) AND pMed_Recon.PtMeds_ID = '#PtMeds_ID#' AND Paired ='Y' SELECT * FROM getallmeds WHERE PtMeds_ID = '#PtMeds_ID#' AND Drug_Name = '#Drug_Name#' AND Assmt_ID IN (#allassmt_ids#) AND Paired ='N' SELECT * FROM GetComms WHERE comm_memo like '%#tempdrugname#%' ---> SELECT F26 FROM #Request.prefix_db_agency#.pAssessments WHERE Assmt_ID = AND Status = LIMIT 1 Invalid Patient Option #url.cat# Invalid Page Type #url.page#