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, Assessment_New.HIPPS_Code 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 p.patient_ID='#Diagnosispatient_ID#' AND p.assessment_ID='#DiagnosisAssessment_ID#' and p.M0230_Link is not null order by p.Dx_Order UPDATE #Request.prefix_db_agency#.Assessment_New SET HIPPS_Code='#HIPPSCode#',HHRG_Classification='#HHRGCode#' WHERE Assessment_New.Assessment_ID='#session.cs.AssessmentId#' SELECT Assessment_New.HIPPS_Code ,case_mix.Weight ,case_mix.HIPPS ,Agency.Wage_Index ,Agency.Rural FROM #Request.prefix_db_agency#.Assessment_New, #Request.prefix_db_lookup#.Agency, #Request.prefix_db_lookup#.case_mix WHERE Assessment_New.Assessment_ID='#session.cs.AssessmentId#' and Assessment_New.Agency_ID = Agency.Agency_ID and Left(Assessment_New.HIPPS_Code,4) = case_mix.HIPPS UPDATE #Request.prefix_db_agency#.Assessment_New SET Homebound_Status='#NumberFormat(LaborNonLaborSupply,'_____.__')#' WHERE Assessment_New.Assessment_ID='#session.cs.AssessmentId#'

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
UPDATE #Request.prefix_db_agency#.Assessment_New SET Claim_Key='#TreatAuthNumber#' WHERE Assessment_New.Assessment_ID='#session.cs.AssessmentId#' SELECT count(*) as visitcount from #Request.prefix_db_agency#.PatientVisitDetails where Assessment_Id = '#session.cs.AssessmentId#' and ScheduleItems_ID != 0 and Type != 'vital sign' and Type != 'wound' SELECT count(*) as careplancount from #Request.prefix_db_agency#.Pathway_Details where Assessment_Id = '#session.cs.AssessmentId#' and Type != 'vital sign';