Update #Request.prefix_db_agency#.ScheduleItems set Visit_Type = 'Evaluation' where ScheduleItems_ID in (#form.VisitID#) Select aid.Assessment_Type,si.ScheduleItems_ID,si.Assessment_Tracker_ID,si.Patient_ID,si.Visit_Date,si.Visit_Type,si.Bill_Type,si.HCPCS,si.Output_Type ,pa.Last_Name_M0040,pa.First_Name_M0040 from #Request.prefix_db_agency#.ScheduleItems si join #Request.prefix_db_agency#.patient pa on si.Patient_ID = pa.Patient_ID join #Request.prefix_db_agency#.assessment_Tracker aid on aid.Assessment_Tracker_ID = si.Assessment_Tracker_ID where si.Agency_ID = '#session.AgencyID#' and pa.Status = 'active' and si.deleted <> 1 and aid.Assessment_Type in ('1 - Start of care - further visits planned', '4 - Recertification (follow-up) reassessment') and si.Assessment_Tracker_ID <> 0 and (Visit_Type like '%Therapy%' OR Visit_Type = 'Evaluation') order by Patient_ID asc

Update Medicare Therapy Schedules

select Assessment_Type,ScheduleItems_ID,Assessment_Tracker_ID,Patient_ID,Visit_Date,Visit_Type,Bill_Type,HCPCS,Output_Type from Get_Info where Patient_ID = #PatientID# order by Visit_Date,Assessment_Tracker_ID asc select Assessment_Tracker_ID from Get_Info where Patient_ID = #PatientID# group by Assessment_Tracker_ID

PATIENT NAME	NO OF VISITS	Action
#Last_Name_M0040#, #First_Name_M0040#	#PatientFilter.RecordCount#

Any one Assessment(s) doesn't match the constraint. Back

Update Medicare Therapy Schedules (#Form.patient_name#)

Visit Date	Visit Type	Bill Type	Assessment Type
#year##day##month#	#Visit_Type#	#Bill_Type#	#Assessment_Type#