SELECT * FROM #Request.prefix_db_agency#.pPatients LEFT OUTER JOIN #Request.prefix_db_agency#.pAdmit ON pAdmit.Patient_ID = patients.Patient_ID WHERE patients.Loc_ID = AND status != SELECT * FROM #Request.prefix_db_agency#.pPatients WHERE Patient_ID = AND status IN (0,1,4) SELECT * FROM #Request.prefix_db_agency#.pPatients WHERE Pt_Agy_ID = AND status = 0 SELECT * FROM #Request.prefix_db_agency#.pAdmit WHERE Patient_ID = AND Admit_ID = AND Status = SELECT * FROM #Request.prefix_db_agency#.pAdmit WHERE Patient_ID = AND Status IN (, ) AND Admit_ID = ORDER BY M0030_START_CARE_DT DESC SELECT Admit_Type, M0030_START_CARE_DT, Agy_Admit FROM #Request.prefix_db_agency#.pAdmit WHERE Admit_ID = AND Patient_ID = AND Status = 0 LIMIT 1 UPDATE #Request.prefix_db_agency#.pAdmit SET Agy_Admit = , M0030_START_CARE_DT = , Date_Change = , Change_by = WHERE Admit_ID = AND Patient_ID = AND Status = 0 UPDATE #Request.prefix_db_agency#.pAssessments SET F176 = , F177 = , F178 = , Record_Mod_Date = , Record_Mod_By = WHERE Admit_ID = AND Patient_ID = AND Status = 0 AND IFNULL(F25, 0) <> 1 AND ( F26 IN ( , , ) OR F26 = ) UPDATE #Request.prefix_db_agency#.pAdmit_Svcs SET Start_Date = , Date_Change = , Change_by = WHERE Admit_ID = AND Patient_ID = AND Status = 0 AND ( Skill IN ( , , ) OR Skill LIKE ) UPDATE #Request.prefix_db_agency#.pAuths pa LEFT JOIN #Request.prefix_db_agency#.pPtPayer ppp ON ppp.PtPayer_ID = pa.PtPayer_ID AND ppp.Status = 0 LEFT JOIN #Request.prefix_db_agency#.pPayer pp ON pp.Pay_ID = ppp.Payer_ID AND pp.Status = 0 SET pa.Date_Start = , pa.Date_End = CASE WHEN LEFT(TRIM(IFNULL(pp.M0150, '')), 1) = '1' AND LEFT(TRIM(IFNULL(pp.M0150, '')), 2) <> '10' THEN ELSE pa.Date_End END, pa.Date_Change = , pa.Change_by = WHERE pa.Patient_ID = AND pa.Status = 0 AND pa.Assmt_ID IN ( SELECT Assmt_ID FROM #Request.prefix_db_agency#.pAssessments WHERE Admit_ID = AND Patient_ID = AND Status = 0 AND IFNULL(F25, 0) <> 1 AND ( F26 IN ( , , ) OR F26 = ) ) UPDATE #Request.prefix_db_agency#.pSchedules SET Visit_Date = , Date_Change = , Change_by = WHERE Patient_ID = AND Status = 0 AND Assmt_ID IN ( SELECT Assmt_ID FROM #Request.prefix_db_agency#.pAssessments WHERE Admit_ID = AND Patient_ID = AND Status = 0 AND IFNULL(F25, 0) <> 1 AND ( F26 IN ( , , ) OR F26 = ) ) AND IFNULL(Missed, 0) = 0 AND ( IFNULL(Initial_visit, 0) = 1 OR Visit_Type IN ( , , ) ) SELECT * FROM #Request.prefix_db_agency#.pReferral WHERE Loc_ID = AND Referral_Name IS NOT NULL AND Referral_Name != '' AND Status = '0' ORDER BY Referral_Name ASC SELECT * FROM #Request.prefix_db_agency#.employee WHERE Emp_Email = AND Emp_ID != SELECT * FROM #Request.prefix_db_agency#.employee WHERE Emp_Telephone = AND Emp_ID != SELECT * FROM #Request.prefix_db_agency#.employee WHERE Username = AND Emp_ID != SELECT * FROM #Request.prefix_db_agency#.pPtmeds left outer join #Request.prefix_db_lookup#.Meds_New ON pPtmeds.Drug_ID = Meds_New.Trade_Num WHERE pPtmeds.Patient_ID = AND pPtmeds.PtMeds_ID = AND pPtmeds.Status = 0 ORDER BY pPtmeds.status ASC SELECT *, IFNULL(GROUP_CONCAT(DISTINCT CASE WHEN Meds_New_Compare.Trade_Num IS NOT NULL THEN Med_Interactions.interaction_generic ELSE NULL END ORDER BY Med_Interactions.interaction_generic SEPARATOR ', '), '') AS Interaction_Medications, IFNULL(Meds_New.Med_ID,0) AS MedsNew_ID FROM #Request.prefix_db_agency#.pPtmeds left outer join #Request.prefix_db_lookup#.Meds_New ON pPtmeds.Drug_ID = Meds_New.Trade_Num LEFT OUTER JOIN hhapowerpath.Med_Interactions ON LCASE(TRIM(Med_Interactions.drug_generic)) = LCASE(TRIM(Meds_New.Generic_Name)) LEFT OUTER JOIN #Request.prefix_db_agency#.pPtmeds pPtmeds_Compare ON pPtmeds_Compare.Patient_ID = pPtmeds.Patient_ID AND pPtmeds_Compare.PtMeds_ID <> pPtmeds.PtMeds_ID AND pPtmeds_Compare.Status < 2 LEFT OUTER JOIN #Request.prefix_db_lookup#.Meds_New Meds_New_Compare ON pPtmeds_Compare.Drug_ID = Meds_New_Compare.Trade_Num AND TRIM(IFNULL(Meds_New_Compare.Generic_Name,'')) <> '' AND TRIM(IFNULL(Med_Interactions.interaction_generic,'')) <> '' AND ( LCASE(TRIM(Meds_New_Compare.Generic_Name)) LIKE CONCAT('%', LCASE(TRIM(Med_Interactions.interaction_generic)), '%') OR LCASE(TRIM(Med_Interactions.interaction_generic)) LIKE CONCAT('%', LCASE(TRIM(Meds_New_Compare.Generic_Name)), '%') ) LEFT OUTER JOIN #Request.prefix_db_lookup#.vetted_190924 ON vetted_190924.ICD = Meds_New.XICD WHERE pPtmeds.Patient_ID = AND pPtmeds.status = 0 AND pPtmeds.status = 1 AND pPtmeds.status = 2 AND pPtmeds.status < GROUP BY pPtmeds.PtMeds_ID ORDER BY pPtmeds.status ASC SELECT * FROM #Request.prefix_db_lookup#.Meds_New WHERE Name LIKE ORDER BY Name No Medication found #trade_name# * #replacenocase(generic_name," X ","
","ALL")# #replacenocase(classification," & ","
","ALL")# #replacenocase(grouping," & ","
","ALL")# SELECT * FROM #Request.prefix_db_lookup#.Meds_New WHERE Trade_ID = SELECT * FROM #Request.prefix_db_lookup#.Meds_New_Dose WHERE Trade_ID = Order by Dose ASC UPDATE #Request.prefix_db_agency#.files SET Title = , DOC_ID = , Expires = , Notes = , Created = WHERE id = UPDATE #Request.prefix_db_agency#.pg_files SET Title = , DOC_ID = , Expires = , Created = WHERE id = UPDATE #Request.prefix_db_agency#.pg_files SET Title = , Notes = , Created = WHERE id = UPDATE #Request.prefix_db_agency#.pg_files SET Title = , Notes = , Created = WHERE id = UPDATE #Request.prefix_db_agency#.files SET placeholder = WHERE id = UPDATE #Request.prefix_db_agency#.pPtmeds SET In_Home = , Record_Mod_Date = , Record_Mod_By = WHERE PtMeds_ID = UPDATE #Request.prefix_db_agency#.pSchedules SET pgnotesdraft = , Change_by = , Date_Change = WHERE Schedule_ID = AND Status = 0 SELECT * FROM #Request.prefix_db_lookup#.zip_cbsa WHERE ZIPCODE = UPDATE #Request.prefix_db_agency#.pAdmit_Svcs_Procs SET Status = 2 WHERE Admit_Svcs_ID = '#arguments.AutoAdmitSvcs_ID#' AND Status = 0 INSERT INTO #Request.prefix_db_agency#.pAdmit_Svcs_Procs ( Admit_ID, Admit_Svcs_ID, Status, Item_ID, Notes, Date_Create, Created_by, Date_Change, Change_by ) VALUES ( '#arguments.Admit_ID#' ,'#arguments.AutoAdmitSvcs_ID#', 0, '#item_id#',NULL, #now()# , #session.employeeid# , #now()#, #session.employeeid# ) SELECT * FROM #Request.prefix_db_agency#.pAdmit_Svcs_Procs WHERE Admit_Svcs_ID = '#arguments.AutoAdmitSvcs_ID#' And status = 0 SELECT * FROM #Request.prefix_db_lookup#.pPathway WHERE Type = 'procedure' AND Severity = GROUP BY Item_ID SELECT * FROM #Request.prefix_db_agency#.pAdmit_Svcs_Procs WHERE Admit_Svcs_ID ='#arguments.Admit_Svcs_ID#' AND status = 0 GROUP BY Item_ID
Add Custom
> #Description# No Procedures found
SELECT * FROM #Request.prefix_db_lookup#.answer_lookup WHERE answer_label = 'assvisit_type' AND deleted = 0 AND answer not like 'Hospice%' AND answer not like 'Chaplain%' AND answer not like '%FU Eval' AND answer not like '%Pediatric%' AND answer like '%Pediatric%' AND (answer like 'Hospice%' OR answer like 'SN Eval%' OR answer like 'PT Eval%' OR answer like 'OT Eval%' OR answer like 'ST Eval%' OR answer like 'MSW Eval%') AND (answer = 'Palliative' OR answer like 'Hospice%' OR answer like 'SN Eval%' OR answer like 'PT Eval%' OR answer like 'OT Eval%' OR answer like 'ST Eval%' OR answer like 'MSW Eval%') AND (answer like 'SN Eval%' OR answer like 'PT Eval%' OR answer like 'OT Eval%' OR answer like 'ST Eval%' OR answer like 'MSW Eval%') ORDER BY answer_order ASC SELECT * from #Request.prefix_db_agency#.pWoundsVitals WHERE Assmt_ID = '#arguments.Assmt_ID#' AND VitalOrWound ='vital' AND status = 0 ORDER BY Item_ID ASC SELECT * from getsvitals WHERE Item_ID < 6 SELECT * from getsvitals WHERE Item_ID < 6 AND Reading1 = 0 SELECT * from getsvitals WHERE Item_ID = #i# SELECT * from getsvitals WHERE Reading1 = 0 AND Item_ID = #i# SELECT * from #Request.prefix_db_lookup#.pValue_Lookup WHERE Item_ID = '#i#' " > SELECT pAssessments.* FROM #Request.prefix_db_agency#.pAssessments JOIN #Request.prefix_db_agency#.pAdmit ON pAssessments.Admit_ID = pAdmit.Admit_ID WHERE pAssessments.Status = 0 AND pAdmit.Status = 0 AND pAssessments.Patient_ID = AND pAssessments.F176 = '#DateFormat(arguments.Visit_Date,"yyyy-mm-dd")#' AND pAssessments.F26 = (CASE WHEN ('#arguments.Visit_Type#' = "1 - SOC - SN") THEN '1 - Start of care - further visits planned' WHEN ('#arguments.Visit_Type#' = "1 - SOC - PT" ) THEN '1 - Start of care - further visits planned - Physical Therapy' WHEN ('#arguments.Visit_Type#' = "1 - SOC - OT" ) THEN '1 - Start of care - further visits planned - Occupational Therapy' WHEN ('#arguments.Visit_Type#' = "3 - ROC - SN" || '#arguments.Visit_Type#' = "3 - ROC - PT") THEN '3 - Resumption of care (after inpatient stay)' WHEN ('#arguments.Visit_Type#' = "PT Eval" ) THEN 'PT Adult Evaluation' WHEN ('#arguments.Visit_Type#' = "OT Eval" ) THEN 'OT Adult Evaluation' WHEN ('#arguments.Visit_Type#' = "ST Eval" ) THEN 'ST Adult Evaluation' WHEN ('#arguments.Visit_Type#' = "SN Eval" ) THEN 'SN Adult Evaluation' WHEN ('#arguments.Visit_Type#' = "MSW Eval" ) THEN 'MSW Evaluation' WHEN ('#arguments.Visit_Type#' = "PT FU Eval" ) THEN 'PT Followup' WHEN ('#arguments.Visit_Type#' = "OT FU Eval" ) THEN 'OT Followup' WHEN ('#arguments.Visit_Type#' = "ST FU Eval" ) THEN 'ST Followup' WHEN ('#arguments.Visit_Type#' = "MSW FU Eval" ) THEN 'MSW Followup' WHEN ('#arguments.Visit_Type#' = "SN FU Eval" ) THEN 'SN Followup' WHEN ('#arguments.Visit_Type#' = "Hospice Comprehensive" ) THEN 'Hospice Comprehensive' WHEN ('#arguments.Visit_Type#' = "SN Hospice" ) THEN 'SN Hospice' WHEN ('#arguments.Visit_Type#' = "Chaplain Comprehensive Evaluation" ) THEN 'Chaplain Comprehensive Evaluation' WHEN ('#arguments.Visit_Type#' = "Hospice Discharge" ) THEN 'Hospice Discharge' WHEN ('#arguments.Visit_Type#' = "Hospice admission" ) THEN 'Hospice admission' WHEN ('#arguments.Visit_Type#' = "4 - Recertification" ) THEN '4 - Recertification (follow-up) reassessment' WHEN ('#arguments.Visit_Type#' = "4 - Recertification PT" ) THEN '4 - Recertification (follow-up) reassessment - PT' WHEN ('#arguments.Visit_Type#' = "4 - Recertification OT" ) THEN '4 - Recertification (follow-up) reassessment - OT' WHEN ('#arguments.Visit_Type#' = "5 - Other follow-up" ) THEN '5 - Other follow-up' WHEN ('#arguments.Visit_Type#' = "6 - Transfer no discharge" ) THEN '6 - Transferred to an inpatient facility - patient not discharged from agency' WHEN ('#arguments.Visit_Type#' = "7 - Transfer discharged" ) THEN '7 - Transferred to an inpatient facility - patient discharged from agency' WHEN ('#arguments.Visit_Type#' = "8 - Death" ) THEN '8 - Death at home' WHEN ('#arguments.Visit_Type#' = "9 - Discharge from agency" ) THEN '9 - Discharge from agency' ELSE '#arguments.Visit_Type#' END) SELECT * FROM #Request.prefix_db_agency#.pPayer WHERE Pay_ID = AND Status = 0 AND (LEFT(M0150,1) = '1' OR LEFT(M0150,1) = '2' OR Output ='Medicare') SELECT * FROM #Request.prefix_db_lookup#.answer_lookup WHERE answer_label = 'assvisit_type' AND deleted = 0 AND admit_type IN ('OASIS','all') AND admit_type = 'all' AND admit_type IN ('hospice','palliative','all') AND admit_type IN ('hospice','all') AND admit_type = 'Pediatric' ORDER BY answer_order ASC