SELECT F27, F178 FROM #Request.prefix_db_agency#.pAssessments WHERE Assmt_ID = AND status = 0 SELECT * FROM #Request.prefix_db_agency#.pAssessments a WHERE a.Patient_ID = AND a.status = 0 AND a.Admit_ID = AND a.Assmt_ID != AND (a.F26 LIKE '1%' OR a.F26 LIKE '4%') ORDER BY a.F176 DESC LIMIT 1 SELECT p.* FROM #Request.prefix_db_agency#.pProblem p WHERE p.status = 0 AND p.Assmt_ID = AND (p.M0_No LIKE 'M1021%' OR p.M0_No LIKE 'M1023%') ORDER BY p.dx_order ASC, p.Problem_ID ASC SELECT * FROM #Request.prefix_db_agency#.pProblem WHERE status < 2 AND Assmt_ID = AND (Description = OR Answer = OR (Item_ID = AND ques_id = )) LIMIT 1 SELECT IFNULL(MAX(Problem_ID),0)+1 As pProblem_ID FROM #Request.prefix_db_agency#.pProblem INSERT INTO #Request.prefix_db_agency#.pProblem ( Problem_ID, Assmt_ID, Status, Careplan, Path_ID, Item_ID, CMSOrder_ID, Skill, ques_id, M0_No, Description, Answer, Severity, dx_order, Oasis_Deficits, `manual`, Order_ID, WoundVital_ID, Coding_Status, Specific_Orders, Resolved_Date, Assign, Notes, Date_Create, Created_by, Date_Change, Change_by ) VALUES ( , , 0, , , , , , , , , , , , , , , , , , , , , , , , ) SELECT p.*, pp.Description AS progress_description, pp.Severity AS progress_severity, ps.Visit_Date FROM #Request.prefix_db_agency#.pProblem p JOIN #Request.prefix_db_agency#.pAssessments a ON a.Assmt_ID = p.Assmt_ID JOIN #Request.prefix_db_agency#.pProgress pp ON pp.Careplan_ID = p.Problem_ID AND pp.Assmt_ID = p.Assmt_ID AND pp.Type = 'Problem' AND pp.Severity > 1 AND pp.status = 0 JOIN #Request.prefix_db_agency#.pSchedules ps ON ps.Schedule_ID = pp.Schedule_ID AND ps.status = 0 WHERE p.status = 0 AND (p.M0_No NOT LIKE 'M1021%' AND p.M0_No NOT LIKE 'M1023%') AND a.status = 0 AND a.Assmt_ID = AND a.Admit_ID = AND ps.Visit_Date = ( SELECT MAX(ps2.Visit_Date) FROM #Request.prefix_db_agency#.pProgress pp2 JOIN #Request.prefix_db_agency#.pSchedules ps2 ON ps2.Schedule_ID = pp2.Schedule_ID WHERE pp2.Careplan_ID = p.Problem_ID AND pp2.Assmt_ID = p.Assmt_ID AND pp2.Type = 'Problem' AND LEFT(ps2.Visit_Type,1) = '4' AND pp2.Severity > 1 AND pp2.status = 0 AND ps2.status = 0 ) ORDER BY a.F176 DESC, p.Problem_ID ASC SELECT * FROM #Request.prefix_db_agency#.pProblem WHERE status < 2 AND Assmt_ID = AND (Description = OR Answer = OR (Item_ID = AND ques_id = )) LIMIT 1 SELECT IFNULL(MAX(Problem_ID),0)+1 As pProblem_ID FROM #Request.prefix_db_agency#.pProblem INSERT INTO #Request.prefix_db_agency#.pProblem ( Problem_ID, Assmt_ID, Status, Careplan, Path_ID, Item_ID, CMSOrder_ID, Skill, ques_id, M0_No, Description, Answer, Severity, dx_order, Oasis_Deficits, `manual`, Order_ID, WoundVital_ID, Coding_Status, Specific_Orders, Resolved_Date, Assign, Notes, Date_Create, Created_by, Date_Change, Change_by ) VALUES ( , , 0, , , , , , , , , , , , , , , , , , , , , , , , ) SELECT a.Assmt_ID FROM #Request.prefix_db_agency#.pAssessments a JOIN #Request.prefix_db_agency#.pCareplan c ON c.Assmt_ID = a.Assmt_ID AND c.Status < 2 AND c.Skill = WHERE a.Patient_ID = AND a.status = 0 AND a.Admit_ID = AND a.Assmt_ID != AND (a.F26 LIKE '1%' OR a.F26 LIKE '4%') GROUP BY a.Assmt_ID ORDER BY a.F176 DESC LIMIT 1 SELECT * FROM #Request.prefix_db_agency#.pCareplan WHERE Status < 2 AND Assmt_ID = AND Skill = ORDER BY Careplan_ID ASC SELECT Careplan_ID FROM #Request.prefix_db_agency#.pCareplan WHERE Status < 2 AND Assmt_ID = AND Item_ID = AND Type = AND Skill = AND Description = LIMIT 1 SELECT IFNULL(MAX(Careplan_ID),0)+1 As pCareplan_ID FROM #Request.prefix_db_agency#.pCareplan INSERT INTO #Request.prefix_db_agency#.pCareplan ( Careplan_ID, Assmt_ID, Item_ID, Order_ID, Incrmt1, CMSOrder_ID, Status, Skill, Type, Description, Other, Notes, Param_Lo, Param_Hi, Param_Other, Specifics, Date_Target, Date_Resolve, Order_Date, Date_Create, Created_by, Date_Change, Change_by, Proc_QA ) VALUES ( , , , , , , , , , , , , , , , , , , , , , , , )