SELECT Assessment_New.Assessment_ID, Assessment_New.Start_of_Care_M0030, Assessment_New.Assessment_Completed_M0090, Assessment_New.Assessment_Reason_M0100, Assessment_New.M0110 FROM #Request.prefix_db_agency#.Assessment_New WHERE Assessment_New.Assessment_ID='#session.cs.AssessmentId#' SELECT JulianAlpha FROM #Request.prefix_db_lookup#.visit_schedules where juliannumber=#Juliandays#; SELECT JulianAlpha FROM #Request.prefix_db_lookup#.visit_schedules where juliannumber=#Juliandays1#; SELECT Assessment_New.Assessment_ID, Assessment_New.M0110, Assessment_New.M0826_Ther_Need, Assessment_New.Therapies_Home_M0250, Assessment_New.Ostomy_for_Bowel_M0550, Assessment_New.M1840_Toilet, Assessment_New.Dress_Upper_M0650, Assessment_New.Dress_Lower_M0660, Assessment_New.Ambulation_M0700, Assessment_New.Bathing_M0670, Assessment_New.Toileting_M0680, Assessment_New.Transferring_M0690, Assessment_New.Ambulation_M0700, Assessment_New.Pressure_Ulcer_Stage_M0460, Assessment_New.Pressure_Ulcer_a_M0450, Assessment_New.Pressure_Ulcer_b_M0450, Assessment_New.Pressure_Ulcer_c_M0450, Assessment_New.Pressure_Ulcer_d_M0450, Assessment_New.Pressure_Ulcer_e_M0450, Assessment_New.M1308_d_2_Pressure, Assessment_New.M1308_d_3_Pressure, Assessment_New.Vision_M0390, Assessment_New.Stasis_Ulcer_Num_M0470, Assessment_New.Freq_of_Pain_M0420, Assessment_New.Stasis_Ulcer_Num_M0470, Assessment_New.Pressure_Ulcer_c_M0450, Assessment_New.Pressure_Ulcer_d_M0450, Assessment_New.Pressure_Ulcer_Stage_M0460, Assessment_New.Stasis_Ulcer_Hidden_M0474, Assessment_New.Stasis_Ulcer_Status_M0476, Assessment_New.Surgical_Wound_Status_M0488, Assessment_New.Surgical_Wound_M0482, Assessment_New.Breathing_M0490, Assessment_New.Bowel_Incont_M0540, Assessment_New.Inject_Meds_M0800, Assessment_New.Assessment_Completed_M0090, Assessment_New.Toileting_M0680, Assessment_New.Urinary_INcont_M0520, Assessment_New.Bowel_Incont_M0540, Assessment_New.Transferring_M0690, Assessment_New.Ambulation_M0700, Assessment_New.patient_ID, Assessment_New.Surgical_Wound_M0482 FROM #Request.prefix_db_agency#.Assessment_New WHERE Assessment_New.Assessment_ID='#session.cs.AssessmentId#' SELECT p.ICD, p.Code_Type, p.DG_Type FROM #Request.prefix_db_agency#.Diagnosis p where patient_ID=#Diagnosispatient_ID# AND assessment_ID=#DiagnosisAssessment_ID# and M0230_Link is not null order by p.Dx_Order
Treatment Auth No. : #M0030_Year_Short##M0030_Julian##M0090_Year_Short##M0090_Julian##M0100_Short##M0110_Short##Sum_Clinical_2008_1##Sum_Functional_2008_1##Sum_Clinical_2008_2##Sum_Functional_2008_2##Sum_Clinical_2008_3##Sum_Functional_2008_3##Sum_Clinical_2008_4##Sum_Functional_2008_4#