INSERT INTO #Request.prefix_db_agency#.pProblem ( Assmt_ID, Status, M0_No, Description, Severity, Date_Create, Created_by, Date_Change, Change_by ) VALUES ( , , , , , , , , ) SELECT pProblem.Problem_ID as Dg_id, pProblem.Assmt_ID as Dg_Assessment_ID, pProblem.Assmt_ID as Dg_Assessment_Tracker_ID, pPatients.Patient_ID as Dg_Patient_ID, pPatients.Pt_Agy_ID as Dg_Agency_ID, pProblem.Answer as Dg_Diagnosis, pProblem.Description as Dg_ICD, "" as Dig_Pathway_Type, pProblem.M0_No as Dig_Primary_Diagnosis, pProblem.M0_No as Dg_PDGM_Primary,'' as Dx_Order, pProblem.Severity as Dx_Severity, pProblem.Date_Create as Dg_Record_Creation_Date, pProblem.Created_by as Dg_Record_Created_By, pProblem.Date_Change as Dg_Record_Mod_Date, pProblem.Change_by as Dg_Record_Mod_By, pPatients.Pt_First, pPatients.Pt_Last, pPatients.Pt_Middle, pAssessments.F26 as Assessment_Reason_M0100, pAssessments.F176 as Assessment_Completed_M0090,SuperUsers.Full_Name as super_user_name FROM #Request.prefix_db_agency#.pProblem LEFT JOIN #Request.prefix_db_agency#.pAssessments on pAssessments.Assmt_ID = pProblem.Assmt_ID LEFT JOIN #Request.prefix_db_agency#.pPatients on pPatients.Patient_ID = pAssessments.Patient_ID LEFT JOIN #Request.prefix_db_lookup#.SuperUsers on SuperUsers.User_ID = pProblem.Date_Create WHERE pPatients.Patient_ID= AND pPatients.Pt_Agy_ID= AND pProblem.Assmt_ID= AND pProblem.Status= GROUP BY pProblem.Problem_ID ORDER BY pProblem.Date_Create DESC SELECT * FROM #Request.prefix_db_lookup#.SuperUsers WHERE User_ID=0 SELECT * FROM #Request.prefix_db_lookup#.pathway_list WHERE Type = 'goal' OR Type = 'intervention' WHERE Type = GROUP BY Pathway_ID,M0_Answer SELECT IFNULL(Total_Visits,0) as Total_Visits,Auth_ID FROM #Request.prefix_db_agency#.pAuths WHERE status = AND Assmt_ID = AND Skill = SELECT 0 as Total_Visits SELECT Employee_ID, Last_Name,First_Name FROM #Request.prefix_db_lookup#.Employee WHERE Status = '0' AND Agency_ID = #arguments.AgencyID# ORDER BY Last_Name,First_Name SELECT pPatients.Patient_ID, pAssessments.*, 0 as OASIS_2019_2020_PDGM, pPatients.Pt_Last AS PatientLast, pPatients.Pt_First AS PatientFirst, (select COUNT(*) from #Request.prefix_db_agency#.Coding_Results where Coding_Results.Patient_ID = pPatients.Patient_ID and Coding_Results.Assessment_ID = pAssessments.Assmt_ID and M0_Item_Medication like '%(M102%' ) as Recommended_Diagnosis_Report, (select COUNT(*) from #Request.prefix_db_agency#.Coding_Results where Coding_Results.Patient_ID = pPatients.Patient_ID and Coding_Results.Assessment_ID = pAssessments.Assmt_ID ) as Recom_Visit_Schdule_Report , (select COUNT(*) from #Request.prefix_db_agency#.Coding_Scrub where Coding_Scrub.Patient_ID = pPatients.Patient_ID and Coding_Scrub.Assessment_ID = pAssessments.Assmt_ID ) as OASIS_D_PDGM_Report FROM #Request.prefix_db_agency#.pPatients JOIN #Request.prefix_db_agency#.pAssessments on pPatients.Patient_ID = pAssessments.Patient_ID LEFT OUTER JOIN #Request.prefix_db_agency#.Assessment_New_CW on pAssessments.Assmt_ID = Assessment_New_CW.Assessment_ID LEFT JOIN #Request.prefix_db_agency#.Coding_Results on Coding_Results.Patient_ID = pPatients.Patient_ID and Coding_Results.Assessment_ID = pAssessments.Assmt_ID WHERE -- pPatients.Pt_Agy_ID = AND pPatients.Status = '0' AND pAssessments.status = 0 AND (pAssessments.F26 like '%Start of Care%' OR pAssessments.F26 like '%Resumption of Care%' OR pAssessments.F26 like '%Recertification%' OR pAssessments.F26 like '%Adult%' OR pAssessments.F26 like '%Other%') GROUP BY pAssessments.Assmt_ID Order by pAssessments.record_timestamp DESC,pAssessments.F176 DESC , PatientLast ASC } /> SELECT pPatients.Patient_ID, pAssessments.*, pPatients.Pt_Last AS PatientLast, pPatients.Pt_First AS PatientFirst, (SELECT Total_Visits FROM #Request.prefix_db_agency#.pAuths WHERE pAuths.Assmt_ID = pAssessments.Assmt_ID AND status= 0 AND Skill = 'SN') AS SN, (SELECT Total_Visits FROM #Request.prefix_db_agency#.pAuths WHERE pAuths.Assmt_ID = pAssessments.Assmt_ID AND status= 0 AND Skill = 'HHA') AS HHA, (SELECT Total_Visits FROM #Request.prefix_db_agency#.pAuths WHERE pAuths.Assmt_ID = pAssessments.Assmt_ID AND status= 0 AND Skill = 'PT') AS PT, (SELECT Total_Visits FROM #Request.prefix_db_agency#.pAuths WHERE pAuths.Assmt_ID = pAssessments.Assmt_ID AND status= 0 AND Skill = 'OT') AS OT, (SELECT Total_Visits FROM #Request.prefix_db_agency#.pAuths WHERE pAuths.Assmt_ID = pAssessments.Assmt_ID AND status= 0 AND Skill = 'ST') AS ST, (SELECT Total_Visits FROM #Request.prefix_db_agency#.pAuths WHERE pAuths.Assmt_ID = pAssessments.Assmt_ID AND status= 0 AND Skill = 'MSW') AS MSW, (SELECT Date_Change FROM #Request.prefix_db_agency#.pCareplan WHERE pCareplan.Assmt_ID = pAssessments.Assmt_ID AND status= 0 ORDER BY Date_Change DESC LIMIT 1) as careplan_date_Change, (SELECT Date_Change FROM #Request.prefix_db_agency#.pAuths WHERE pAuths.Assmt_ID = pAssessments.Assmt_ID AND status= 0 ORDER BY Date_Change DESC LIMIT 1) as auth_date_Change FROM #Request.prefix_db_agency#.pPatients JOIN #Request.prefix_db_agency#.pAssessments ON pPatients.Patient_ID = pAssessments.Patient_ID LEFT OUTER JOIN #Request.prefix_db_agency#.pAuths ON pAuths.Assmt_ID = pAssessments.Assmt_ID WHERE pPatients.Status = '0' AND pAssessments.status = 0 AND (pAssessments.F26 like '%Start of Care%' OR pAssessments.F26 like '%Resumption of Care%' OR pAssessments.F26 like '%Recertification%' OR pAssessments.F26 like '%Adult%' OR pAssessments.F26 like '%Other%') GROUP BY pAssessments.Assmt_ID Order by careplan_date_Change DESC , auth_date_Change DESC, pAssessments.record_timestamp DESC } /> SELECT * FROM #Request.prefix_db_agency#.pPatients WHERE Patient_ID= AND Agency_ID= SELECT * from #Request.prefix_db_agency#.pAssessments WHERE Assmt_ID = AND Patient_ID= SELECT Diagnosis.Diagnosis_ID as Dg_id, Diagnosis.Assessment_ID as Dg_Assessment_ID, Diagnosis.Assessment_Tracker_ID as Dg_Assessment_Tracker_ID, Diagnosis.Patient_ID as Dg_Patient_ID, Diagnosis.Agency_ID as Dg_Agency_ID, Diagnosis.Diagnosis as Dg_Diagnosis, Diagnosis.ICD as Dg_ICD, Diagnosis.Pathway_Type as Dig_Pathway_Type, Diagnosis.Primary_Diagnosis as Dig_Primary_Diagnosis, Diagnosis.PDGM_Primary as Dg_PDGM_Primary, Diagnosis.PDGM_Subchapter as Dg_PDGM_Subchapter, Diagnosis.PDGM_Comorbidity as Dg_PDGM_Comorbidity, Diagnosis.Record_Creation_Date as Dg_Record_Creation_Date, Diagnosis.Record_Created_By as Dg_Record_Created_By, Diagnosis.Record_Mod_Date as Dg_Record_Mod_Date, Diagnosis.Record_Mod_By as Dg_Record_Mod_By, pPatients.Pt_First, pPatients.Pt_Last, pPatients.Pt_Middle, pAssessments.F26 as Assessment_Reason_M0100, pAssessments.F176 as Assessment_Completed_M0090,SuperUsers.Full_Name as super_user_name FROM #Request.prefix_db_agency#.Diagnosis LEFT JOIN #Request.prefix_db_agency#.pPatients on pPatients.Patient_ID = Diagnosis.Patient_ID LEFT JOIN #Request.prefix_db_agency#.pAssessments on pAssessments.Assmt_ID = Diagnosis.Assessment_ID LEFT JOIN #Request.prefix_db_lookup#.SuperUsers on SuperUsers.User_ID = Diagnosis.Record_Created_By WHERE Diagnosis.Patient_ID= AND Diagnosis.Agency_ID= AND Diagnosis.Assessment_ID= ORDER BY Diagnosis.Diagnosis_ID ASC SELECT * FROM #Request.prefix_db_lookup#.Dx_list_Procedures_Diet WHERE Type= SELECT * FROM #Request.prefix_db_agency#.Teaching_Library WHERE title IS NOT NULL AND Deleted=0 GROUP BY title SELECT pPatients.Patient_ID, pPatients.Pt_Last AS PatientLast, pPatients.Pt_First AS PatientFirst,pAssessments.* FROM #Request.prefix_db_agency#.pPatients JOIN #Request.prefix_db_agency#.pAssessments on pPatients.Patient_ID = pAssessments.Patient_ID WHERE pPatients.Pt_Agy_ID = AND pPatients.Status = '0' AND pAssessments.status = 0 AND (pAssessments.F26 like '%Start of Care%' OR pAssessments.F26 like '%Resumption of Care%' OR pAssessments.F26 like '%Recertification%' OR pAssessments.F26 like '%Adult%' OR pAssessments.F26 like '%Other%') GROUP BY pAssessments.Assmt_ID Order by pAssessments.record_timestamp DESC,pAssessments.F176 DESC , PatientLast ASC SELECT pPathway.*,pProblem.*, GROUP_CONCAT(RIGHT(dx_order, 2)) as order_ids FROM #Request.prefix_db_lookup#.pPathway INNER JOIN #Request.prefix_db_agency#.pProblem ON pProblem.Path_ID = pPathway.Pathway_ID WHERE pPathway.Type = AND pPathway.Pathway_ID IN () AND pProblem.Assmt_ID = AND status = AND pProblem.M0_No like 'M102%' AND pProblem.Skill = AND (pPathway.Approved IS NULL OR pPathway.Approved = 'Yes' OR ( pPathway.Patient_ID = #session.cs.patientid# AND pPathway.Agency_ID = "#session.agencyid#")) GROUP BY pPathway.Item_ID ORDER BY Type_Order,pPathway.Pathway_ID, pPathway.Order_ID ASC