SELECT Patient_ID, Last_Name_M0040 AS Last_Name, First_Name_M0040 AS First_Name, Middle_Initial_M0040 AS Middle ,Payer_ID FROM #Request.prefix_db_agency#.patient WHERE Patient_Id = '#session.cs.patientid#' AND Agency_Id = '#session.AgencyId#' select PatientMeds.Drug_Name, Meds_New.Contraindications, Meds_New.Side_Effects, Meds_New.Interactions from #Request.prefix_db_agency#.PatientMeds inner join #Request.prefix_db_lookup#.Meds_New on PatientMeds.Medication_ID= Meds_New.Trade_ID where PatientMeds.Patient_ID=(Select Assessment_New.Patient_ID from #Request.prefix_db_agency#.Assessment_New where Assessment_New.Assessment_ID='#session.cs.AssessmentId#') SELECT * FROM #Request.prefix_db_agency#.Assessment_New WHERE Assessment_New.Assessment_ID='#session.cs.AssessmentId#' select Last_Name,First_Name from #Request.prefix_db_lookup#.Employee where Employee_ID = '#AssForm.Record_Created_By#' select Pathway_Details.Description,Pathway_Details.Skill,Pathway_Details.Pathway_Details_ID from #Request.prefix_db_agency#.Pathway_Details where Pathway_Details.Assessment_ID='#session.cs.AssessmentId#' SELECT count(Wnd_Type) as CouNt from #Request.prefix_db_agency#.PatientVisitDetails where Patient_ID='#session.cs.patientid#' and Assessment_ID='#session.cs.AssessmentId#' and Wnd_Location<>'' and Wnd_Type<>'' and trim(Type)='Wound' date_diff_M0104 gt 2 OR date_diff_M0102 gt 2> pat = CreateObject("Component", "patientadmin_new.patient.assessment"); get_pain_que = pat.get_pain_ques('1 - Start of care - further visits planned','pain'); get_braden_que = pat.get_pain_ques('1 - Start of care - further visits planned','braden'); get_fallrisk = pat.get_pain_ques('1 - Start of care - further visits planned','fall_risk'); get_score = pat.get_live_score();
#GetP.First_Name# #GetP.Last_Name#, Start of Care

Diagnosis Select

0 - Asymptomatic, no treatment needed

1 - Symptoms well controlled

2 - Symptoms controlled with difficulty

3 - Symptoms poorly controlled

4 - history of rehospitalizations

Add vital