SELECT *, Order_ID, Assmt_ID, Form_Type, Date_Create, Date_sent, Insured_HIC, "" SOC_Item_2, Certification_From, Certification_To, Agy_CCN, Pt_First, Pt_Last, Pt_Street, Pt_City, Pt_State, Pt_Zip, Pt_Phone, Pt_Agy_ID, Agy_Name, Agy_Street, Agy_City, Agy_State, Agy_Zip, Agy_Phone, Agy_NPI, "" Name_Item_6, "" Provider_name_Item_7, Pt_DOB, Pt_Gender, Medications, ICD10, Description, ICD_Date, DME, Safety, Diet, Form_Status, Allergies, Functional_Limits_Extra, Functional_Limitations, Activities_Permitted, Activities_Permitted_Extra, Mental_Status, Mental_Status_Extra, Prognosis, "" AS Order_item_21, "" AS Goals_Item_22, Date_Received, Render_Phys_ID, "" AS Addendum_Details_10, "" AS Addendum_Details_21, "" AS Addendum_Details_22, Change_by, Discharge_Plan, "" AS Digital_Signature, Created_by, Rehabilitation_Potential, Clinician_Signature, MD_Homebound, MD_Clinical_Condition, "" AS CMS_485, record_timestamp, Date_Sent AS Physician_Last_Seen_Date, 0 AS Location FROM #Request.prefix_db_agency#.pCMS4857 WHERE Order_ID = '#url.afId#' ", false, true) /> ", false, true) /> ", false, true) /> ", false, true) /> SELECT pPhysicians.* FROM #Request.prefix_db_lookup#.pPhysicians WHERE Phys_ID = '#Form.Render_Phys_ID#' SELECT Assmt_ID, F179 AS Start_of_Care_M0030, F26 AS Assessment_Reason_M0100, F176 AS Assessment_Completed_M0090, F177 AS Certification_Start, F178 AS Certification_End, "" AS Rehab_Prognosis_M0270, pAdmit.M0030_START_CARE_DT, pAdmit.Date_F2F, pAdmit.clinical_authorization, pAdmit.Clinical_Manager, pAdmit.Case_Manager, pAdmit.case_authorization, pAdmit.Advance_Directive, pAssessments.F73, pAssessments.F72, pAssessments.Patient_ID FROM #Request.prefix_db_agency#.pAssessments JOIN #Request.prefix_db_agency#.pAdmit ON pAdmit.Admit_ID = pAssessments.Admit_ID WHERE Assmt_ID = '#Form.Assmt_ID#' AND pAssessments.status = 0 AND pAdmit.status = 0 ORDER BY F176 DESC SELECT * FROM #Request.prefix_db_lookup#.pEmployee WHERE Emp_ID = '#GetAssessDet.Clinical_Manager#' Emp_ID = '#GetAssessDet.Case_Manager#' Emp_ID = '#Form.Created_by#' SELECT Agency_Name, Agency_Address1, Agency_City, Agency_State, Agency_Zip, Natl_Provider_ID, Agency_Contact_Phone, Agency_Fax FROM #Request.prefix_db_lookup#.Agency WHERE Agency_ID = '#session.AgencyID#' SELECT * FROM #Request.prefix_db_agency#.Locations WHERE Location_ID = '#Form.Location#' SELECT Email, Pt_language FROM #Request.prefix_db_agency#.pPatients WHERE Patient_ID = '#GetAssessDet.Patient_ID#' SELECT pAuths.Skill, pVisit_Frequency.Frequency FROM #Request.prefix_db_agency#.pAuths JOIN #Request.prefix_db_lookup#.pVisit_Frequency ON pAuths.visit_freq = pVisit_Frequency.Visit_No WHERE pAuths.Status = 0 AND pAuths.Assmt_ID = '#Form.Assmt_ID#' ORDER BY pAuths.Skill UPDATE #Request.prefix_db_agency#.pCMS4857 SET Form_Status = 'Printed Only' WHERE Order_ID = telephone ' & Get_location.Agency_Contact_Phone & ' fax ' & Get_location.Agency_Fax /> telephone ' & Form.Agy_State /> ' & Form.Agy_Street & '
' & Form.Agy_City & ', ' & Form.Agy_State & ' ' & Form.Agy_Zip & '
' & Form.Agy_Phone & '
NPI ' & Form.Agy_NPI /> SELECT F27 AS Skill, IFNULL(TRIM(F175),'') AS Narrative FROM #Request.prefix_db_agency#.pAssessments WHERE Admit_ID = ( SELECT Admit_ID FROM #Request.prefix_db_agency#.pAssessments WHERE Assmt_ID = AND Status = 0 LIMIT 1 ) AND (pAssessments.F26 NOT LIKE '9%' AND pAssessments.F26 NOT LIKE '7%' AND pAssessments.F26 NOT LIKE '8%' AND pAssessments.F26 NOT LIKE '6%') AND status = 0 AND TRIM(IFNULL(F175,'')) <> '' ORDER BY F27 ", "ALL"), Chr(10), "
", "ALL")) />