careplandash = CreateObject("Component", "pathway.careplan"); pgnotes = CreateObject("Component", "pathway.progressnotes"); getpatientgoal = pgnotes.getpatientpgnotes(#URL.AID#,'patient_goal',#skilltype#,#URL.SID#); getgoal = careplandash.getscareplan(#URL.AID#,'goal',#skilltype#,0); getstandingorder = pgnotes.getpatientpgnotes(#URL.AID#,'standing_order',#skilltype#,#URL.SID#); getproblem = careplandash.getproblems(#URL.AID#,#skilltype#,0,0,'0',1); problemcount = getproblem.recordcount; pathwaydash = CreateObject("Component", "pathway.pathway"); pwproc = pathwaydash.getspathway(0,'procedure',#URL.AID#,'M102',#skilltype#); pwteach = pathwaydash.getspathway(0,'teach',#URL.AID#,'M102',#skilltype#); pwgoal = pathwaydash.getspathway(0,'goal',#URL.AID#,'M102',#skilltype#); request.pat = CreateObject("component","components.general.patients").init(); GetMd = request.pat.medslist(#URL.ID#); SELECT * FROM #Request.prefix_db_agency#.pCareplan WHERE Assmt_ID IN (#URL.AID#) and Type IN ('symptom','goal','problem') AND Skill = '#skilltype#' AND status = 0 GROUP BY Careplan_ID SELECT pSched_Procedure.* FROM #Request.prefix_db_agency#.pSched_Procedure WHERE pSched_Procedure.Schedule_ID = AND pSched_Procedure.status = 0 SELECT * FROM #Request.prefix_db_agency#.pCareplan WHERE Assmt_ID = AND Skill = AND type = AND status = 0 AND Date_Resolve IS NULL AND Description NOT like '%01.%' AND Description NOT like '%02.%' AND Description NOT like '%03.%' AND Description NOT like '%04.%' AND Description NOT like '%05.%' AND Description NOT like '%06.%' AND Description NOT like '%07.%' AND Description NOT like '%88.%' AND Description NOT like '%09.%' AND Careplan_ID NOT IN ( SELECT Careplan_ID FROM #Request.prefix_db_agency#.pProgress WHERE Status = 0 AND Schedule_ID = AND Type = 'goal' AND YesOrNo = '4') ORDER BY Goal_ID ASC SELECT * 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 pProgress.*,pWoundsVitals.Param_Lo,pWoundsVitals.Param_Hi,pWoundsVitals.Pathway_ID,pWoundsVitals.ID AS woundsid FROM #Request.prefix_db_agency#.pProgress LEFT OUTER JOIN #Request.prefix_db_agency#.pWoundsVitals ON pWoundsVitals.ID = pProgress.Careplan_ID WHERE pProgress.Assmt_ID = AND pProgress.Schedule_ID = AND pProgress.Status = 0 AND pWoundsVitals.Status = 0 ORDER BY pProgress.Item_ID ASC SELECT pWoundsVitals.*,pWoundsVitals.ID AS woundsid FROM #Request.prefix_db_agency#.pWoundsVitals WHERE pWoundsVitals.Assmt_ID = AND pWoundsVitals.Status = 0 ORDER BY pWoundsVitals.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 = 'vital' SELECT * FROM getpgnotes WHERE ptype = AND Skill = ORDER BY Item_ID, Header_No ,Order_ID ASC SELECT * FROM getpgnotes WHERE ptype = ORDER BY Item_ID,Header_No ,Order_ID ASC SELECT * FROM getpgnotes WHERE ptype = ORDER BY Item_ID,Header_No ,Order_ID ASC SELECT * FROM getpgnotes WHERE ptype = AND YesOrNo = 4 ORDER BY Item_ID,Header_No ,Goal_ID ASC SELECT * FROM getpgnotes WHERE ptype = AND YesOrNo < 4 ORDER BY Goal_ID ASC SELECT * FROM getpgnotes WHERE ptype = AND Progress_ID IN (#goals_pgids#) ORDER BY YesOrNo ASC, Goal_ID ASC SELECT * FROM getpgnotes WHERE ptype = ORDER BY Item_ID,Header_No ,Order_ID ASC SELECT * FROM getpgnotes WHERE ptype = AND careplan_assmt_ID ='#URL.AID#' AND YesOrNo < 4 ORDER BY Goal_ID ASC SELECT * FROM getpgnotes WHERE ptype = AND careplan_assmt_ID ='#URL.AID#' ORDER BY YesOrNo ASC, Item_ID,Header_No ,Order_ID ASC SELECT * FROM getpgnotes WHERE ptype = ORDER BY Item_ID,Header_No ,Order_ID ASC SELECT * FROM getpgnotes WHERE ptype = ORDER BY Item_ID,Header_No ,Order_ID ASC SELECT pPathway.*,pProblem.*, GROUP_CONCAT(RIGHT(dx_order, 2)) as order_ids FROM #Request.prefix_db_lookup#.pPathway INNER JOIN #Request.prefix_db_agency#.pProblem ON pProblem.Path_ID = pPathway.Pathway_ID WHERE pProblem.Assmt_ID = AND status = AND pProblem.M0_No like 'M102%' AND pProblem.Skill = GROUP BY pPathway.Item_ID ORDER BY pProblem.Item_ID,M0_No,Type_Order,pPathway.Order_ID ASC SELECT RIGHT(SUBSTRING_INDEX(SUBSTRING_INDEX((SELECT pCareplan.Description FROM #Request.prefix_db_lookup#.pPathway pw JOIN #Request.prefix_db_agency#.pCareplan ON pCareplan.Item_ID = pw.item_ID WHERE pw.Pathway_ID = pProblem.Path_ID AND pw.type = 'goal' AND pCareplan.type = pw.type AND pw.Header IS NOT NULL AND pw.Description like '% - 0%' AND pCareplan.Assmt_ID = pProblem.Assmt_ID AND pCareplan.Status = 0 LIMIT 1), ' - ', -1), '.', 1),1) AS GG_goals_severitys, SUBSTRING_INDEX(pProgress.Description, '(', 1) AS Description1, pProgress.*, pProblem.Oasis_Deficits,pProblem.Answer,pProblem.ques_id,pProblem.M0_No, pPathway.Value_Prog,pPathway.Header,pProblem.Path_ID, 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 ELSE pPathway.Header_No END as header_title, pPathway.Header_No FROM #Request.prefix_db_agency#.pProgress LEFT OUTER JOIN #Request.prefix_db_agency#.pProblem ON pProblem.Problem_ID = pProgress.Careplan_ID AND pProblem.status = 0 JOIN #Request.prefix_db_agency#.pAssessments ON pAssessments.Assmt_ID = pProgress.Assmt_ID AND pAssessments.status = 0 JOIN #Request.prefix_db_agency#.pAdmit ON pAdmit.Admit_ID = pAssessments.Admit_ID AND pAdmit.status = 0 AND pAssessments.Admit_ID = #Getpat.Admit_ID# LEFT OUTER JOIN #Request.prefix_db_lookup#.pPathway ON pPathway.Item_ID = pProgress.Item_ID AND Header_No IS NOT NULL WHERE pProgress.Assmt_ID = AND pProgress.Schedule_ID = AND pProgress.Status = AND pProgress.type IN () AND pProgress.Item_ID NOT IN (SELECT Item_ID FROM #Request.prefix_db_lookup#.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 Type IN ('symptom','problem') AND Description NOT LIKE 'GG%' ORDER BY woundstitle ASC, header_title ASC, 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,Description ASC, Item_ID ASC SELECT * FROM pgproblemsall WHERE M0_No IS NOT NULL ORDER BY M0_No ASC SELECT * FROM pgproblemsall WHERE Description like 'GG%' ORDER BY woundstitle ASC, header_title ASC, Item_ID ASC SELECT * FROM #Request.prefix_db_agency#.pCMS4857 WHERE Assmt_ID = AND Status = 0 AND Form_Type like '%Form 485%'

Patient Complaints

Patient Goal on Admission

Notes

0-0% 1-25% 2-50% 3-75% 4-100% met

#Ucase(REReplace(Header,"]*>", chr(10), "all"))#

SELECT * FROM getpathway WHERE getpathway.Item_ID = AND getpathway.Type =
class="row oddclass" class="row">
#Description#

No patient-stated goals found
#cookie.VitalCount# vital signs entered
Add

Vitals

Values

Severity

Notes

onClick="redirecturl('index.cfm?#CGI.QUERY_STRING#&vitalsign=1')" onClick="redirecturl('index.cfm?#CGI.QUERY_STRING#')" >Add Vital
SELECT * FROM #Request.prefix_db_lookup#.pPhraseBank WHERE Item_ID = ORDER BY Order_ID DESC
class="row oddclass" class="row" >
SELECT Lookup_1,Lookup_2,Measure FROM #Request.prefix_db_lookup#.pValue_Lookup WHERE Description = '#Description#' SELECT * FROM GetVitalslookup WHERE Lookup_2 IS NOT NULL OR Lookup_2 > 0
#ListFirst(ValueList(GetVitalslookup.Measure))#

#trim(Notes)#


Edit Select Phrase
 


No Vitals found

 SELECT * FROM #Request.prefix_db_lookup#.pPathway WHERE Item_ID IN () AND Type = ORDER BY Header_No ASC

SYMPTOMS

SEVERITY: 06. Independent 05. Setup or cleanup assistance 04. Supervision or touching assistance 03. Partial/moderate assistance 02. Substantial/maximal assistance 01. Dependent SEVERITY: 0 - asymptomatic 1 - well-controlled 2 - controlled with difficulty 3 - poorly controlled 4 - hx hospitalizations

Notes

Add More Symptoms
SELECT Lookup_1,Lookup_2,Measure FROM #Request.prefix_db_lookup#.pValue_Lookup WHERE Item_ID = 201

SEVERITY: 06. Independent 05. Setup or cleanup assistance 04. Supervision or touching assistance 03. Partial/moderate assistance 02. Substantial/maximal assistance 01. Dependent

SELECT * FROM #Request.prefix_db_lookup#.pProgress_Unstable WHERE LEFT(Question,29) = AND pProgress_Unstable.System NOT IN ()
SELECT * FROM getpaths WHERE Item_ID = SELECT * FROM #Request.prefix_db_lookup#.pPhraseBank WHERE Item_ID = ORDER BY Order_ID DESC
class="row oddclass" class="row" style="background-color:#tblrowscolor#;#problem_description#">
onClick="redirecturl('index.cfm?page=patient&cat=addnewsymptoms&frompage=pgnotes&restrict=1&formonly=1&AID=#encassid#&SID=#encsid#&Skill=#skilltype#&showdatabase=1')"onclick="Showdiagnosis(#pgproblems.Item_ID#,#Assmt_ID#,'problem');" > #Description# #pgproblems.Value_Sum#
#Answer# SELECT * FROM #Request.prefix_db_lookup#.pPathway WHERE Pathway_ID = '#pgproblems.Path_ID#' AND type = 'goal' AND Header IS NOT NULL SELECT * FROM getgoal WHERE Item_ID IN (#GGpathways#)
Goal: #getGGpathway.Description#
SELECT * FROM getwoundsonly WHERE VitalOrWound = 'wound' AND woundsid = '#pgproblems.ques_id#' ORDER BY Item_ID ASC
W L D
#ListFirst(ValueList(GetWound.Measure))#



> 0 > 5

#trim(Notes)#


View Select Phrase style="background-color: ##FF8F8F" name="Notes#Progress_ID#" id="Notes#Progress_ID#" class="form-control" value="#Trim(Notes)#" onkeyup="Notesbackground(#Progress_ID#,0);"> --->
 

No symptoms found

MEDICATIONS

SELECT * FROM GetMd WHERE status = 0

New Medication

#Ucase(REReplace(Header,"]*>", chr(10), "all"))#

SELECT * FROM getpathway WHERE getpathway.Item_ID = AND getpathway.Type = SELECT * FROM #Request.prefix_db_lookup#.pPhraseBank WHERE Item_ID = ORDER BY Order_ID DESC SELECT * from getscheduleprocedure WHERE Careplan_ID =
class="row oddclass" class="row" >
#Description# required today #Visit_Date#
#getscheduleprocNotes.Notes#
#pnotes#

#trim(Notes)#


View Select Phrase
  View history

No Procedures found

#trim(Notes)#


View Select Phrase

No Standing Orders found

END STANDING ORDERS --->

GOALS


#Getp.Pt_First# should meet #request.goals_pervisits# #skilltype# goals this visit to stay on track

Target Date

Notes

0-0% 1-25% 2-50% 3-75%
4-100% met

Add Goals
SELECT * FROM #Request.prefix_db_lookup#.pPhraseBank WHERE Item_ID = ORDER BY Order_ID DESC SELECT * FROM getpathway WHERE getpathway.Item_ID = AND getpathway.Type =
class="row oddclass" class="row" style="background-color:##80808052;" >
#Description#
#DateFormat(Date_Target,"mm/dd/yyyy")#

#trim(Notes)#


View Select Phrase
SELECT * FROM #Request.prefix_db_lookup#.pPathway WHERE Item_ID IN () AND Type = ORDER BY Header_No ASC

SEVERITY: 06. Independent 05. Setup or cleanup assistance 04. Supervision or touching assistance 03. Partial/moderate assistance 02. Substantial/maximal assistance 01. Dependent

SELECT * FROM #Request.prefix_db_lookup#.pPathway WHERE Pathway_ID = '#GGproblems.Path_ID#' AND type = 'goal' AND Header IS NOT NULL AND Description like '% - 0%' SELECT * FROM getgoal WHERE Item_ID IN (#GGpathways#) SELECT * FROM #Request.prefix_db_lookup#.pProgress_Unstable WHERE LEFT(Question,29) = AND pProgress_Unstable.System NOT IN ()
SELECT * FROM getpaths WHERE Item_ID = SELECT * FROM #Request.prefix_db_lookup#.pPhraseBank WHERE Item_ID = ORDER BY Order_ID DESC
class="row oddclass" class="row" style="background-color:##80808052;#problem_description#" style="background-color:#tblrowscolor#;#problem_description#" >
onClick="redirecturl('index.cfm?page=patient&cat=addnewsymptoms&frompage=pgnotes&restrict=1&formonly=1&AID=#encassid#&SID=#encsid#&Skill=#skilltype#&showdatabase=1')"onclick="Showdiagnosis(#GGproblems.Item_ID#,#Assmt_ID#,'problem');" > #Description# #GGproblems.Value_Sum#
#Answer# SELECT * FROM #Request.prefix_db_lookup#.pPathway WHERE Pathway_ID = '#GGproblems.Path_ID#' AND type = 'goal' AND Header IS NOT NULL AND Description like '% - 0%' SELECT * FROM getgoal WHERE Item_ID IN (#GGpathways#)
Goal: #getGGpathway.Description#
> 0 type="radio" value="5" id="Severity5#Progress_ID#" name="Severity#Progress_ID#" onclick="Physicianalert_updateseveritynew(this.value,#Progress_ID#)" checked> 5

#trim(Notes)#


View Select Phrase style="background-color: ##FF8F8F" name="Notes#Progress_ID#" id="Notes#Progress_ID#" class="form-control" value="#Trim(Notes)#" onkeyup="Notesbackground(#Progress_ID#,0);"> --->
 

No Goals Found

Discharge Plan

Target date

Notes

0-0% 1-25% 2-50% 3-75% 4-100% ready for discharge

#Ucase(REReplace(Header,"]*>", chr(10), "all"))#

SELECT * FROM getpathway WHERE getpathway.Item_ID = AND getpathway.Type =
class="row oddclass" class="row" >
#DateFormat(Date_Target,"mm/dd/yyyy")#
class="form-group"class="form-group hide" id="divDischarge_Reason">

No discharge plan found
#cookie.WoundCount# wounds entered
Add