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 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.Type = pProgress.Type 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 Description NOT LIKE 'GG%' AND (prob_id > 0 OR woundstitle != '' OR Careplan_ID = 0) ORDER BY woundstitle ASC, header_title ASC, Item_ID ASC SELECT * FROM pgproblemsall WHERE Description LIKE 'GG%' ORDER BY woundstitle ASC, header_title ASC, Item_ID ASC