select assessment_id from #Request.prefix_db_agency#.Assessment_New an inner join #Request.prefix_db_agency#.Assessment_Forms af on an.assessment_tracker_id = af.assessment_tracker_id where assessment_forms_id = #url.afId# select Assessment_Reason_M0100 from #Request.prefix_db_agency#.Assessment_New where assessment_id = #getAss.assessment_id# SELECT af.Assessment_Forms_Id, af.Assessment_Tracker_ID, af.Assessment_Number, af.Patient_ID, af.Agency_ID, af.Form_Type, af.Record_Num, af.Record_Creation_Date, af.Record_Mod_date, af.Date_sent, af.HI_Claim_Item_1, af.SOC_Item_2, af.Cert_start_Item_3a, af.Cert_End_Item_3b, af.Medical_Num_Item_4, af.Provider_Num_Item_5, af.Name_Item_6, af.Provider_name_Item_7, af.DOB_Item_8, af.Gender_Item_9, af.Active_meds_Item_10, af.M0230_ICD_Item_11, af.M0230_Diagnosis_Item_11, af.M0230_Date_Item_11, af.Surgical_ICD_Item_12, af.Surgical_Procedure_Item_12, af.Surgical_Procedure_Date_Item_12, af.M0240_ICD_Item_13, af.M0240_Diagnosis_Item_13, af.M0240_Date_item_13, af.DME_Supplies_Item_14, af.Safety_Measures_Item_15, af.Nutritional_Item_16, af.Allergies_Item_17, af.Func_Limits_Item_18a_other, af.Func_Limits_item_18a, af.Activities_Permitted_Item_18b, af.Activities_Permitted_Item_18b_Other, af.Mental_Status_Item_19, af.Mental_Status_Item_19_Other, af.Prognosis_Item_20, af.Order_item_21, af.Goals_Item_22, af.Physician_Item_24, af.Date_Received_Item_25, af.Form_Status, af.Physician_ID, af.Physician_Email_Sent, af.Physician_Comments, af.Addendum_Num_10, af.Addendum_Num_21, af.Addendum_Num_22, af.Addendum_Details_10, af.Addendum_Details_21, af.Addendum_Details_22, af.Record_Modified_By, af.Discharge, af.SN_Schedule_21, af.Therapy_Schedule_21, af.HHA_Schedule_21, af.Digital_Signature, af.Record_Created_By, af.Nurse_Digital_Signature, af.unarchive, af.contact_id, af.Phys_Descr_Homebound, af.Phys_Descr_Clinical_Cond, p.Patient_Id, p.Last_Name_M0040, p.First_Name_M0040 FROM #Request.prefix_db_agency#.Assessment_Forms af, #Request.prefix_db_agency#.patient p WHERE af.Assessment_Forms_Id = '#url.afId#' AND p.Patient_ID = af.Patient_Id SELECT Assessment_ID, Assessment_Number, Start_of_Care_M0030, Admission_Status, Assessment_Reason_M0100 ,Assessment_Completed_M0090, Assessment_Tracker_ID, Certification_Start, Certification_End,Surgical_ICD_485, Surgical_ICD_485_Description, Surgical_ICD_Date_485, SN_Schedule, SN_Visit_Orders, Therapy_Schedule, Therapy_Visit_Orders, HHA_Schedule, HHA_Visit_Orders, Rehab_Prognosis_M0270, DME_485, Safety_measures_485, Func_limitations_485, Func_Limitations_485_Other, Activities_permitted_485, Activities_permitted_485_other, Mental_Status_485, Mental_Status_485_other, Prognosis_485, Nutrition_485, Discharge_485, Goals_485, Form_485_SOC_Date, Form_485_Cert_Start_Date, Form_485_Cert_End_Date, Treatment_Orders FROM #Request.prefix_db_agency#.Assessment_New WHERE Assessment_ID = #GetV.Assessment_Number# ORDER BY Assessment_Completed_M0090 Desc

Update #getV.First_Name_M0040# #getV.Last_Name_M0040# CMS485

pm = CreateObject("Component", "Menu"); pm.MenuFunction('physician',#GetV.Patient_Id#,#Session.CS.AssessmentID#,'','','');

Sent to Physician Click Here to Pick the date
Received from Physician Click Here to Pick the date
Order Status
Order Information
Patient #getV.First_Name_M0040# #getV.Last_Name_M0040#
Date Sent #DateFormat(GetV.Date_Sent, "mm/dd/yyyy")#
Physican #Replace(getv.Physician_Item_24, CrLf, "
", "ALL")#
HI Claim Number #GetV.HI_Claim_Item_1#
Start of Care #DateFormat(GetV.SOC_Item_2,"mm/dd/yyyy")#
Certification Dates #DateFormat(GetV.Cert_start_Item_3a,"mm/dd/yyyy")# to #DateFormat(GetV.Cert_End_Item_3b,"mm/dd/yyyy")#
Date of Birth #DateFormat(GetV.DOB_Item_8,"mm/dd/yyyy")# Gender #GetV.Gender_Item_9#
Medications #ListElement#
Primary Diagnosis
#ListElement#
#ListElement#
#DateFormat(GetV.M0230_Date_Item_11,"mm/dd/yyyy")#
Surgical Procedure #GetV.Surgical_ICD_Item_12# #GetV.Surgical_Procedure_Item_12# #DateFormat(GetV.Surgical_Procedure_Date_Item_12,"mm/dd/yyyy")#
Diagnosis
#ListElement#
#ListElement#
Supplies/DME #getV.DME_Supplies_Item_14#
Safety Measures #Replace(getV.Safety_Measures_Item_15, CrLf, "
", "ALL")#
Nutrition #getV.Nutritional_Item_16#
Allergies #getV.Allergies_Item_17#
Functional Limitations #getV.Func_Limits_Item_18a#
Other Functional Limits #GetV.Func_Limits_Item_18a_other#
Activities Permitted #getV.Activities_Permitted_Item_18b#
Other OK Activities #GetV.Activities_Permitted_Item_18b_other#
Mental Status #getV.Mental_Status_Item_19#
Other Mental #GetV.Mental_Status_Item_19_other#
Prognosis #getV.Prognosis_Item_20#
Orders for Care SN_Schedule:#GetV.SN_Schedule_21##GetAssessDet.SN_Visit_Orders#
Therapy_Schedule:#GetV.Therapy_Schedule_21##GetAssessDet.Therapy_Visit_Orders#
HHA_Schedule:#GetV.HHA_Schedule_21##GetAssessDet.HHA_Visit_Orders#

#getV.Order_item_21#
Addendum Details #Replace(getV.Addendum_Details_21, CrLf, "
", "ALL")#
Goals Rehab Discharge #getV.Goals_Item_22#

Rehabilition Potential:#GetAssessDet.Rehab_Prognosis_M0270#
Discharge Plans:#getV.Discharge#
Physician-described Homebound Status #Replace(getV.Phys_Descr_Homebound, CrLf, "
", "ALL")#
Physician-described Skilled Needs #Replace(getV.Phys_Descr_Clinical_Cond, CrLf, "
", "ALL")#