SELECT Emp_ID, Loc_ID FROM hhapowerpath.pEmployee WHERE Emp_ID = AND Emp_Type = 'Employee' AND Status = 0 LIMIT 1 SELECT SCHEMA_NAME FROM information_schema.schemata WHERE SCHEMA_NAME = SELECT Schedule_ID, Patient_ID, Assmt_ID, Emp_ID, Visit_Type, Visit_Date, Skill, Status FROM #arguments.agencySchema#.pSchedules WHERE Schedule_ID = AND Status = 0 LIMIT 1 SELECT Progress_ID, Schedule_ID, Assmt_ID, Type, Status FROM #arguments.agencySchema#.pProgress WHERE Progress_ID = AND Schedule_ID = AND Status = LIMIT 1 UPDATE #arguments.agencySchema#.pProgress SET Notes = ,Description = ,YesOrNo = ,Severity = ,Physician_alert = ,Value_1 = ,Value_2 = ,Value_3 = ,Value_Sum = ,healing_stage = ,Discharge = ,Discharge_Reason = ,pain_location = ,pain_duration = ,pain_relief = ,pain_exacerbate = ,pain_med_effectiveness = ,activate = ,activate = ,activate = ,#woundKey# = , Date_Change = , Change_by = WHERE Progress_ID = AND Schedule_ID = AND Status = UPDATE #arguments.agencySchema#.pProgress SET Description = , Date_Change = , Change_by = WHERE Progress_ID = AND Schedule_ID = AND Type = AND Status = INSERT INTO #arguments.agencySchema#.pProgress ( Assmt_ID, Schedule_ID, Description, Status, Type, Date_Create, Created_by, Date_Change, Change_by ) VALUES ( , , , , , , , , ) UPDATE #arguments.agencySchema#.pProgress SET activate = , Date_Change = , Change_by = WHERE Schedule_ID = AND Type = AND YesOrNo = AND Status = SELECT Question, system_description, `System` AS unstable_system FROM #arguments.lookupSchema#.pProgress_Unstable SELECT Item_ID, Description FROM #arguments.lookupSchema#.pPathway WHERE Pathway_ID = AND type = AND Header IS NOT NULL AND Description LIKE SELECT * FROM careplanGoals WHERE Item_ID IN () SELECT Item_ID, Description FROM #arguments.lookupSchema#.pPathway WHERE Pathway_ID = AND type = AND Header IS NOT NULL AND Description LIKE SELECT * FROM careplanGoals WHERE Item_ID IN () SELECT Admit_ID FROM #arguments.agencySchema#.pAssessments WHERE Assmt_ID = AND Status = 0 LIMIT 1 SELECT SUBSTRING_INDEX(pProgress.Description, '(', 1) AS Description1, pProgress.*, pProblem.Oasis_Deficits, pProblem.Answer, pProblem.ques_id, pProblem.M0_No, pPathway.Value_Prog, pPathway.Header AS old_header, pPathway.Header AS path_header, pProblem.Path_ID, CASE WHEN pProgress_Unstable.system_description != '' THEN pProgress_Unstable.system_description WHEN Careplan_ID > 0 THEN ( SELECT prob2.Description FROM #arguments.agencySchema#.pProblem AS prob2 WHERE prob2.Path_ID = pProblem.Path_ID AND prob2.M0_No LIKE 'M102%' AND pProgress.Assmt_ID = prob2.Assmt_ID AND prob2.status = 0 LIMIT 0, 1 ) ELSE NULL END AS Header, CASE WHEN (pProblem.M0_No LIKE 'SK%' OR pProblem.M0_No = 'wound') AND LEFT(pProgress.Description, 1) = '##' THEN 'Wounds' ELSE '' END AS woundstitle, pProblem.Description AS problemdescription, pProblem.Problem_ID AS prob_id, CASE WHEN LEFT(pProgress.Description, 3) = 'GG0' THEN 20 WHEN pProgress_Unstable.system_description != '' THEN pProgress_Unstable.ID WHEN Careplan_ID > 0 THEN 1000 ELSE pProgress_Unstable.ID END AS header_title, pPathway.Header_No FROM #arguments.agencySchema#.pProgress LEFT OUTER JOIN #arguments.agencySchema#.pProblem ON pProblem.Problem_ID = pProgress.Careplan_ID AND pProblem.status = 0 INNER JOIN #arguments.agencySchema#.pAssessments ON pAssessments.Assmt_ID = pProgress.Assmt_ID AND pAssessments.status = 0 INNER JOIN #arguments.agencySchema#.pAdmit ON pAdmit.Admit_ID = pAssessments.Admit_ID AND pAdmit.status = 0 AND pAssessments.Admit_ID = LEFT OUTER JOIN #arguments.lookupSchema#.pPathway ON pPathway.Item_ID = pProgress.Item_ID AND pPathway.Header_No IS NOT NULL LEFT OUTER JOIN #arguments.lookupSchema#.pProgress_Unstable ON pProgress_Unstable.`System` = pProblem.M0_No WHERE pProgress.Schedule_ID = AND pProgress.Status = AND pProgress.type IN () AND pProgress.Item_ID NOT IN ( SELECT Item_ID FROM #arguments.lookupSchema#.pPathway WHERE pPathway.Header = 'Vital Signs' ) GROUP BY pProgress.Progress_ID ORDER BY woundstitle ASC, header_title ASC, pProgress.Item_ID ASC SELECT * FROM pgproblemsall WHERE M0_No IS NOT NULL ORDER BY M0_No ASC SELECT * FROM pgproblemsall WHERE Description NOT LIKE 'GG%' AND (prob_id > 0 OR woundstitle != '' OR Careplan_ID = 0) ORDER BY woundstitle ASC, header_title ASC, Path_ID ASC, Description ASC, Item_ID ASC SELECT * FROM pgproblemsall WHERE Description LIKE 'GG%' ORDER BY woundstitle ASC, header_title ASC, Item_ID ASC