SELECT COLUMN_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_SCHEMA = AND TABLE_NAME = ORDER BY ORDINAL_POSITION SELECT #arguments.progressColumnList#, pProgress.Assmt_ID AS pn_assmt_id, MIN(pPathway.Header) AS path_header, MIN(pPathway.Header_No) AS path_header_no, MIN(pPathway.Order_ID) AS path_order_id, MIN(pCareplan.Date_Resolve) AS cp_date_resolve, MIN(pCareplan.Date_Target) AS cp_date_target, MIN(pCareplan.Notes) AS pnotes FROM #arguments.agencySchema#.pProgress INNER JOIN #arguments.agencySchema#.pSchedules ON pProgress.Schedule_ID = pSchedules.Schedule_ID AND pSchedules.status = 0 AND pSchedules.Skill = LEFT OUTER JOIN #arguments.lookupSchema#.pPathway ON pPathway.Item_ID = pProgress.Item_ID AND pPathway.Type = pProgress.Type LEFT OUTER JOIN #arguments.agencySchema#.pCareplan ON pCareplan.Careplan_ID = pProgress.Careplan_ID AND pCareplan.Assmt_ID = pProgress.Assmt_ID AND (pCareplan.Skill = OR ( = 'PTA' AND pCareplan.Skill = 'PT')) AND pCareplan.Status = 0 WHERE pProgress.Assmt_ID = AND pProgress.Schedule_ID = AND pProgress.Status = AND trim(pProgress.Description) != '' AND pProgress.Type IN () GROUP BY pProgress.Progress_ID ORDER BY #arguments.orderByClause# SELECT pSchedules.Schedule_ID, pSchedules.Assmt_ID AS sched_assmt_id, pSchedules.Patient_ID, pSchedules.Emp_ID, pSchedules.Skill, pSchedules.Visit_Date, pSchedules.Status, pPatients.Pt_First, pPatients.Pt_Last, pPatients.Pt_Middle, ( SELECT pAssessments.F310 FROM #Request.prefix_db_agency#.pAssessments pAssessments WHERE pAssessments.Assmt_ID = pSchedules.Assmt_ID AND pAssessments.Patient_ID = pSchedules.Patient_ID AND pAssessments.Status = LIMIT 1 ) AS vital_omit FROM #Request.prefix_db_agency#.pSchedules pSchedules INNER JOIN #Request.prefix_db_agency#.pPatients pPatients ON pPatients.Patient_ID = pSchedules.Patient_ID AND pPatients.Status IN (0, 1, 4) WHERE pSchedules.Schedule_ID = AND pSchedules.Status = 0 LIMIT 1 SELECT pPtmeds.Drug_Name, pPtmeds.Dose, pPtmeds.Route, pPtmeds.Freq AS Frequency, pPtmeds.status FROM #Request.prefix_db_agency#.pPtmeds WHERE pPtmeds.Patient_ID = AND pPtmeds.status = ORDER BY pPtmeds.Drug_Name ASC SELECT MIN(pCareplan.Date_Resolve) AS cp_date_resolve, #pnPgNoAssmt#, MIN(pPathway.Pathway_ID) AS pathway_pathway_id, MIN(pPathway.Header) AS path_header, MIN(pPathway.Header_No) AS path_header_no, MIN(pPathway.Order_ID) AS path_order_id, MIN(pPathway.Type_Order) AS path_type_order, MIN(pPathway.Param) AS path_param, MIN(pPathway.Approved) AS pathway_approved, MIN(pPathway.Agency_ID) AS pathway_agency_id, MIN(pPathway.Patient_ID) AS pathway_patient_id, MIN(pPathway.Description) AS pathway_description, MIN(pPathway.Type) AS pathway_type, MIN(pPathway.Item_ID) AS pathway_item_id, MIN(pPathway.Value) AS pathway_value, MIN(IFNULL(pPathway.Value, 0)) AS measurevalue, MIN(pCareplan.Param_Lo) AS cp_param_lo, MIN(pCareplan.Param_Hi) AS cp_param_hi, MIN(pCareplan.Param_other) AS cp_param_other, MIN(pCareplan.Date_Target) AS cp_date_target, MIN(pCareplan.AutoCareplan_ID) AS cp_autocareplan_id, MIN(pCareplan.Skill) AS cp_skill, MIN(pCareplan.Notes) AS pnotes, MIN(pCareplan.Goal_ID) AS cp_goal_id, MAX(pg.schedule_visit_date) AS schedule_visit_date, MAX(pg.pn_assmt_id) AS pn_assmt_id FROM ( SELECT #pnProgressNoAssmt#, pProgress.Assmt_ID AS pn_assmt_id, pSchedules.Visit_Date AS schedule_visit_date FROM #Request.prefix_db_agency#.pProgress INNER JOIN #Request.prefix_db_agency#.pSchedules ON pProgress.Schedule_ID = pSchedules.Schedule_ID AND pSchedules.status = 0 AND pSchedules.Skill = WHERE pProgress.Assmt_ID = AND pProgress.Schedule_ID = AND pProgress.Status = AND trim(pProgress.Description) != '' AND pProgress.Type NOT IN (, ) ) pg LEFT OUTER JOIN #Request.prefix_db_lookup#.pPathway ON pPathway.Item_ID = pg.Item_ID AND pPathway.Type = pg.Type LEFT OUTER JOIN #Request.prefix_db_agency#.pCareplan ON pCareplan.Careplan_ID = pg.Careplan_ID AND pCareplan.Assmt_ID = pg.pn_assmt_id AND (pCareplan.Skill = OR ( = 'PTA' AND pCareplan.Skill = 'PT')) AND pCareplan.Status = 0 GROUP BY pg.Progress_ID ORDER BY MIN(pPathway.Header_No), MIN(pPathway.Order_ID), pg.Progress_ID ASC SELECT #pnProgressNoAssmt#, pProgress.Assmt_ID AS pn_assmt_id FROM #Request.prefix_db_agency#.pProgress WHERE pProgress.Assmt_ID = AND pProgress.Schedule_ID = AND pProgress.Status = AND pProgress.Type = GROUP BY pProgress.Progress_ID SELECT #pnPgNoAssmt#, MAX(pg.pn_assmt_id) AS pn_assmt_id, MIN(pWoundsVitals.Param_Lo) AS wound_param_lo, MIN(pWoundsVitals.Param_Hi) AS wound_param_hi, MIN(pWoundsVitals.Pathway_ID) AS wound_pathway_id, MIN(pWoundsVitals.ID) AS woundsid FROM ( SELECT #pnProgressNoAssmt#, pProgress.Assmt_ID AS pn_assmt_id FROM #Request.prefix_db_agency#.pProgress WHERE pProgress.Assmt_ID = AND pProgress.Schedule_ID = AND pProgress.Status = 0 ) pg INNER JOIN #Request.prefix_db_agency#.pWoundsVitals ON pWoundsVitals.ID = pg.Careplan_ID AND pWoundsVitals.Status = 0 GROUP BY pg.Progress_ID ORDER BY MIN(pg.Item_ID) ASC SELECT * FROM getwoundsvitals WHERE Type = 'vital' ORDER BY Item_ID ASC SELECT * FROM #Request.prefix_db_agency#.pWoundsVitals WHERE Assmt_ID = AND Status = 0 ORDER BY Item_ID ASC SELECT * FROM getwunds WHERE VitalOrWound = 'wound' ORDER BY Item_ID ASC SELECT #pnProgressNoAssmt#, pProgress.Assmt_ID AS pn_assmt_id, MIN(pPathway.Header) AS path_header, MIN(pPathway.Header_No) AS path_header_no, MIN(pPathway.Order_ID) AS path_order_id FROM #Request.prefix_db_agency#.pProgress LEFT OUTER JOIN #_pnLookup#.pPathway pPathway ON pPathway.Item_ID = pProgress.Item_ID AND pPathway.Type = pProgress.Type WHERE pProgress.Assmt_ID = AND pProgress.Schedule_ID = AND pProgress.Status = AND pProgress.Type = GROUP BY pProgress.Progress_ID ORDER BY MIN(pPathway.Header_No), MIN(pPathway.Order_ID), MIN(pProgress.Item_ID) ASC SELECT Drug_Name, Dose, Route, Frequency, status FROM GetMd ORDER BY Drug_Name ASC SELECT COUNT(*) AS CouNt FROM #Request.prefix_db_agency#.pWoundsVitals WHERE Assmt_ID = AND VitalOrWound = 'wound' AND Status = 0