SELECT pProblem.Problem_ID as Dg_id, pProblem.Assmt_ID as Dg_Assmt_ID, pProblem.Assmt_ID as Dg_Assessment_Tracker_ID, pProblem.Careplan, pPatients.Patient_ID as Dg_Patient_ID, pPatients.Loc_ID as Dg_Agency_ID, pProblem.Description as Dg_Diagnosis, vetted_190924.ICD as Dg_ICD, vetted_190924.Assessment as Dig_Pathway_Type, pProblem.Description as Dig_Primary_Diagnosis, vetted_190924.PDGM as Dg_PDGM_Primary, vetted_190924.SUBCHAPTER as Dg_PDGM_Subchapter, vetted_190924.Comorbid as Dg_PDGM_Comorbidity, 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, pEmployee.Emp_First as super_user_name , '' as Employee_username, pEmployee.Emp_Last, pEmployee.Emp_First FROM #Request.prefix_db_agency#.pProblem JOIN #Request.prefix_db_lookup#.vetted_190924 ON vetted_190924.Diagnosis = pProblem.Description 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#.pEmployee ON pEmployee.Emp_ID = pProblem.Created_by WHERE pPatients.Patient_ID= AND pProblem.Assmt_ID= AND pProblem.Status = 0 AND pPatients.Status = 0 AND pAssessments.Status = 0 ORDER BY pProblem.Problem_ID ASC SELECT * FROM #Request.prefix_db_agency#.pProblem LEFT OUTER JOIN #Request.prefix_db_lookup#.vetted_190924 ON vetted_190924.Diagnosis = pProblem.Description WHERE Assmt_ID = AND ICD = AND pProblem.status = 0 AND (pProblem.M0_No like 'M1023%' OR pProblem.M0_No like 'M1021%') GROUP BY pProblem.Problem_ID SELECT ts.ID, ts.ICD,ts.Explanation,ts.Step_ID,ts.Line_ID,ts.Diagnosis_ID,ts.Pathway_Type,ts.Order_ID,ts.Pathway_ID,(SELECT type FROM #Request.prefix_db_lookup#.#teach_prev# as tp WHERE tp.Pathway_ID = ts.Pathway_ID AND tp.Type = 'Title' ) as title_type FROM #Request.prefix_db_agency#.#teach_sk# as ts WHERE ts.Diagnosis_ID= AND ts.Patient_ID= AND ts.Assmt_ID= AND ts.ICD= AND ts.Deleted=0 AND ts.Pathway_Type NOT LIKE 'goal%' AND ts.Pathway_Type NOT LIKE 'intervention%' AND ts.Pathway_Type NOT LIKE 'Source%' AND ts.Title_Order_ID IS NOT NULL AND ts.Pathway_Type <> 'Title' AND ts.Pathway_ID <> 0 GROUP BY ts.Pathway_Type ORDER BY ts.Pathway_Type ASC SELECT pProblem.Problem_ID as Dg_id, pProblem.Assmt_ID as Dg_Assmt_ID, pProblem.Assmt_ID as Dg_Assessment_Tracker_ID, pPatients.Patient_ID as Dg_Patient_ID, pPatients.Loc_ID as Dg_Agency_ID, pProblem.Description as Dg_Diagnosis,pProblem.Careplan, vetted_190924.ICD as Dg_ICD, vetted_190924.Assessment as Dig_Pathway_Type, pProblem.Description as Dig_Primary_Diagnosis, vetted_190924.PDGM as Dg_PDGM_Primary, vetted_190924.SUBCHAPTER as Dg_PDGM_Subchapter, vetted_190924.Comorbid as Dg_PDGM_Comorbidity, 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, pEmployee.Emp_First as super_user_name , '' as Employee_username, pEmployee.Emp_Last, pEmployee.Emp_First FROM #Request.prefix_db_agency#.pProblem JOIN #Request.prefix_db_lookup#.vetted_190924 ON vetted_190924.Diagnosis = pProblem.Description LEFT JOIN #Request.prefix_db_agency#.pAssessments on pAssessments.Assmt_ID = pProblem.Assmt_ID LEFT JOIN #Request.prefix_db_agency#.pPatients on pAssessments.Patient_ID = pPatients.Patient_ID LEFT JOIN #Request.prefix_db_lookup#.pEmployee ON pEmployee.Emp_ID = pProblem.Created_by WHERE pPatients.Patient_ID= AND pProblem.Assmt_ID= AND pProblem.Status = 0 AND pPatients.Status = 0 AND pAssessments.Status = 0 GROUP BY vetted_190924.Assessment ORDER BY pProblem.dx_order ASC SELECT pProblem.Problem_ID as Dg_id, pProblem.Assmt_ID as Dg_Assmt_ID, pProblem.Assmt_ID as Dg_Assessment_Tracker_ID, pPatients.Patient_ID as Dg_Patient_ID, pProblem.Careplan, pPatients.Loc_ID as Dg_Agency_ID, pProblem.Description as Dg_Diagnosis, vetted_190924.ICD as Dg_ICD, vetted_190924.Assessment as Dig_Pathway_Type, pProblem.Description as Dig_Primary_Diagnosis, vetted_190924.PDGM as Dg_PDGM_Primary, vetted_190924.SUBCHAPTER as Dg_PDGM_Subchapter, vetted_190924.Comorbid as Dg_PDGM_Comorbidity, 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, pEmployee.Emp_First as super_user_name , '' as Employee_username, pEmployee.Emp_Last, pEmployee.Emp_First, pProblem.dx_order FROM #Request.prefix_db_agency#.pProblem JOIN #Request.prefix_db_lookup#.vetted_190924 ON vetted_190924.Diagnosis = pProblem.Description LEFT JOIN #Request.prefix_db_agency#.pAssessments on pAssessments.Assmt_ID = pProblem.Assmt_ID LEFT JOIN #Request.prefix_db_agency#.pPatients on pAssessments.Patient_ID = pAssessments.Patient_ID LEFT JOIN #Request.prefix_db_lookup#.pEmployee ON pEmployee.Emp_ID = pProblem.Created_by WHERE pPatients.Patient_ID= AND pProblem.Assmt_ID= AND pProblem.Status = 0 AND pPatients.Status = 0 AND pAssessments.Status = 0 AND (pProblem.M0_No like 'M1023%' OR pProblem.M0_No like 'M1021%') AND (pProblem.M0_No like 'M1023%' OR pProblem.M0_No like 'M1021%') GROUP BY pProblem.Problem_ID ORDER BY pProblem.dx_order ASC