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 *
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 = '#Recertform.Record_Created_By#'
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'
select Diagnosis_ID,Short_Diagnosis,Text_ICD,Severity,CONVERT(Diagnosis.Dx_Order, CHAR(10)) as Dx_Order,Primary_Diagnosis,
Secondary_Diagnosis,DG_Type from #Request.prefix_db_agency#.Diagnosis where Assessment_ID='#session.cs.AssessmentId#' and M0230_Link like '%M0230%' and M0230_Link is not null
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');
