Select * from #Request.prefix_db_agency#.Assessment_New where Assessment_ID='#form.AssessmentID#' SELECT Patient_ID, Last_Name_M0040 AS Last_Name, First_Name_M0040 AS First_Name, Middle_Initial_M0040 AS Middle ,Payer_ID ,DOB_M0066, Gender_M0069 FROM #Request.prefix_db_agency#.patient WHERE Patient_Id = '#session.cs.patientid#' AND Agency_Id = '#session.AgencyId#' select Last_Name, First_Name,Address1,City,Zip,Home_phone from #Request.prefix_db_lookup#.Employee where Employee_ID = '#GetAss.Record_Created_By#' '&#GetE.Address1#&' '&#GetE.City#&' '&#GetE.Zip# /> SELECT distinct trim(pd.Description) as Description,pd.Skill,pd.Type,pvd.Severity,pvd.Reading1,pvd.Reading2 from #Request.prefix_db_agency#.Pathway_Details pd LEFT OUTER JOIN #Request.prefix_db_agency#.PatientVisitDetails pvd on pd.Pathway_Details_ID = pvd.Pathway_Details_ID where pd.Assessment_ID='#form.AssessmentID#' AND pd.Record_Creation_Date BETWEEN #CreateODBCDate(fd)# AND #CreateODBCDate(td)# AND pd.Type IN ('Vital Sign', 'Laboratory') and (pd.Deleted is null and pd.Resolved_Date is null) ' /> select distinct * from #Request.prefix_db_agency#.Diagnosis WHERE Assessment_ID = '#form.AssessmentID#' AND (M0190_Link is not null or M0210_Link is not null or M0230_Link is not null or M1012_Link is not null) '&ICDTemp> '&otherTemp> '&'Therapy Visit Schedule ' & '#GetAss.Therapy_Visit_Orders#'&'
'&'HHA Visit Schedule '&'#GetAss.HHA_Visit_Orders#'&'
'> select distinct trim(Description) as Description,Skill,Type from #Request.prefix_db_agency#.Pathway_Details pd where Assessment_ID='#form.AssessmentID#' and Type IN ('Goal') and (Deleted is null and Resolved_Date is null) select distinct trim(Description) as Description,Skill,Type from #Request.prefix_db_agency#.Pathway_Details pd where Assessment_ID='#form.AssessmentID#' and Type IN ('Intervention') and (Deleted is null and Resolved_Date is null)
'/>
' />
' />
' />
' />
' />
' />
' />
' />
' />
'&SNValue&PTValue&OTValue&STValue&MSWValue&BRVValue&SPRValue&HHAValue&HSNValue&HMSValue> INSERT INTO #Request.prefix_db_agency#.Assessment_Forms ( Patient_Id ,M0230_ICD_Item_11 ,M0230_Diagnosis_Item_11 , Agency_Id , Form_Type , Form_Status , Name_Item_6 , Record_Creation_Date , Record_Mod_Date , Cert_Start_Item_3a , Cert_End_Item_3b , Assessment_Tracker_Id , Assessment_Number , Record_Modified_By ,DOB_Item_8 ,Gender_Item_9 ,Physician_Item_24 , Record_Created_By ,Order_item_21 ,Goals_Item_22 ,Addendum_Details_10 ,Addendum_Details_22 ) VALUES ( '#session.cs.patientid#' ,'#otherICD#' ,'#otherdiagnosis#' ,'#Session.AgencyLogin#' ,'60-day' ,'Not Signed' ,'#name_item#' , #now()# , #now()# ,#CreateODBCDate(GetAss.Certification_Start)# ,#CreateODBCDate(GetAss.Certification_End)# ,'#GetAss.Assessment_Tracker_ID#' ,'#form.AssessmentID#' ,'#Session.EmployeeId#' ,#GetP.DOB_M0066# ,'#GetP.Gender_M0069#' ,'#Physician#' ,#Session.EmployeeId# ,'#form.hdnTreatment#' ,'#form.hdnGoals#' ,'#vitals#' ,'#GetAss.Assessment_Note#' ) select LAST_INSERT_ID() as keyvalue