UPDATE #Request.prefix_db_agency#.Assessment_New SET Date_Most_Recent_M0903 ='#DateFormat(EvaluationDate,'yyyy-mm-dd')#', Braden_1_Sensory = '#txtFacility#', Braden_2_Moisture = '#txtMDbox#', Braden_3_Activity = '#txtCurrentDiet#', Braden_4_Mobility = '#txtLiquids#', Assessment_note = '#txtComment#' WHERE Assessment_ID = '#session.cs.AssessmentId#' UPDATE #Request.prefix_db_agency#.Assessment_New SET Psy_Nursing_M0630 = '#painlevel#', Grooming_M0640 = '#txtpainchare1#', Grooming_M0640p = '#painthers#', Dress_Upper_M0650 = '#ratecurrent#', Dress_Upper_M0650p = '#howlong#', Dress_Lower_M0660 = '#chkwhatis1#', Assessment_note = '#txtComment#' WHERE Assessment_ID = '#session.cs.AssessmentId#' UPDATE #Request.prefix_db_agency#.Assessment_New SET Braden_5_Nutrition = '#Shortterm#', Braden_6_Friction = '#longterm#', M1730a = '#Orientation#', M1730b = '#Attention#', Assessment_note = '#txtComment#' WHERE Assessment_ID = '#session.cs.AssessmentId#' UPDATE #Request.prefix_db_agency#.Assessment_New SET Pain1 = '#ReadingLetter#', Pain2 = '#ReadingWords#', Pain3 = '#ReadingSimple#', Pain4 = '#ReadingComplex#', Pain5 = '#ReadingParagraph#', Assessment_note = '#txtComment#' WHERE Assessment_ID = '#session.cs.AssessmentId#' UPDATE #Request.prefix_db_agency#.Assessment_New SET Fall_A = '#WritingLetter#', Fall_B = '#WritingWords#', Fall_C = '#WritingSimple#', Fall_D = '#WritingComplex#', Fall_E = '#WritingParagraph#', Assessment_note = '#txtComment#' WHERE Assessment_ID = '#session.cs.AssessmentId#' UPDATE #Request.prefix_db_agency#.Assessment_New SET Fall_F = '#Articulation#', Fall_G = '#Prosody#', Fall_H = '#Respiration#', Fall_I = '#SpeechIntelligibility#', M1000_Other = '#Oralfacialexam#', Assessment_note = '#txtComment#' WHERE Assessment_ID = '#session.cs.AssessmentId#' UPDATE #Request.prefix_db_agency#.Assessment_New SET M2100a_Equip = '#Chewingability#', M2100b_Equip = '#Oralstagemanagement#', M2100c_Equip = '#Pharyngealstagemanagement#', M2100d_Equip = '#Reflextime#', Assessment_note = '#txtComment#' WHERE Assessment_ID = '#session.cs.AssessmentId#' UPDATE #Request.prefix_db_agency#.Assessment_New SET M2100e_Equip = '#Augmentativemethods#', M2100f_Equip = '#Naming#', M2100g_Equip = '#AppropriateYesNo#', M1040_Influ = '#VerbalComplexsentences#', M1045_Influ = '#Conversation#', Assessment_note = '#txtComment#' WHERE Assessment_ID = '#session.cs.AssessmentId#' UPDATE #Request.prefix_db_agency#.Assessment_New SET M2400a_Diabetic = '#WordDiscrimination#', M2400b_FallsPrev = '#OneStepDirections#', M2400c_Depress = '#TwoStepDirections#', M2400d_Pain = '#AuditoryComplexDirections#', M2400e_PressUlc = '#AuditoryConversation#', M2400f_PressUlcMoist = '#AuditorySpeechreading#', AssessmentType_New = 1, Admission_Status='Complete', Assessment_note = '#txtComment#' WHERE Assessment_ID = '#session.cs.AssessmentId#' Select a.Time_Frame, a.Units, s.Total_Units, a.StartDate, a.EndDate From #Request.prefix_db_agency#.authorizations a, #Request.prefix_db_agency#.ScheduleItems s Where a.Payer_ID = s.Payer_ID AND a.Rev_CodeID = s.Rev_CodeID AND a.Patient_ID='#patid#' AND a.Payer_ID='#payid#' AND a.Rev_CodeID = '#revcode_id#' AND a.Auth_ID='#Authid#' AND a.Deleted <> '1' Select a.Units , a.StartDate, a.EndDate, ABS(floor(DateDiff(a.StartDate , a.EndDate)/7)) as countweeks From #Request.prefix_db_agency#.authorizations a Where a.Assessment_ID = '#Assid#' AND a.Patient_ID='#patid#' AND a.Payer_ID='#payid#' AND a.Rev_CodeID = '#revcode_id#' AND a.Deleted <> '1' Select Sum(s.Total_Units) as weekunits From #Request.prefix_db_agency#.ScheduleItems s Where s.Assessment_ID = '#session.CS.AssessmentId#' AND s.Patient_ID='#patid#' AND s.Payer_ID='#payid#' AND s.Rev_CodeID = '#revcode_id#' AND s.Visit_Date BETWEEN '#Startdate#' AND '#Enddate#' SELECT * FROM #Request.prefix_db_agency#.visit_orders where Assessment_ID='#assid#' and Revenue_Code = '#revcode#' SELECT Assessment_New.Certification_Start, Assessment_New.Certification_End FROM #Request.prefix_db_agency#.patient, #Request.prefix_db_agency#.Assessment_New WHERE patient.Patient_ID = Assessment_New.Patient_ID AND ( Assessment_New.Assessment_Reason_M0100 LIKE '1%' OR Assessment_New.Assessment_Reason_M0100 LIKE '4%' OR Assessment_New.Assessment_Reason_M0100 LIKE '%Evaluation%' OR Assessment_New.Assessment_Reason_M0100 LIKE '%Hospice%' OR Assessment_New.Assessment_Reason_M0100 LIKE '%NO ASSESSMENT%' )AND Assessment_ID = > SELECT ScheduleItems.Visit_Date FROM #Request.prefix_db_agency#.ScheduleItems left outer join #Request.prefix_db_lookup#.Employee on ScheduleItems.Employee_ID = Employee.Employee_ID left outer join #Request.prefix_db_agency#.patient on ScheduleItems.Patient_ID = patient.Patient_ID left outer join #Request.prefix_db_agency#.Assessment_New on (ScheduleItems.Assessment_Tracker_ID = Assessment_New.Assessment_Tracker_ID) left outer join #Request.prefix_db_agency#.Payer pp on Assessment_New.payer_id = pp.Payer_id left outer join #Request.prefix_db_lookup#.Assessment_TimeAuthorizations at on (ScheduleItems.Assessment_Tracker_ID = at.Assessment_Tracker_ID and ScheduleItems.Assessment_ID = at.Assessment_ID and ScheduleItems.rev_codeid = at.revcode_id) WHERE (ScheduleItems.Visit_Date >= #CreateODBCDate(GetAssess.Certification_Start)# AND ScheduleItems.Visit_Date <= #CreateODBCDate(GetAssess.Certification_End)#) AND ScheduleItems.Agency_ID = #Session.AgencyID# AND ScheduleItems.Deleted <> 1 AND Assessment_New.Assessment_id= '#assid#' AND ScheduleItems.patient_ID IN (#Session.Patient.PatientIDValue#) AND Employee.Employee_ID = #Session.EmployeeID# AND (Assessment_New.Deleted IS NULL OR Assessment_New.Deleted != 1) AND (Assessment_New.Archive IS NULL OR Assessment_New.Archive != 1 ) AND trim(ScheduleItems.Rev_Code) = '#revcode#' ORDER BY StartTime, Last_Name_M0040, First_Name_M0040, Last_Name, First_Name SELECT StartDate,EndDate,Units FROM #Request.prefix_db_agency#.authorizations where Revenue_Code = '#revcode#' AND Deleted <> '1' SELECT PriorAuthorization FROM #Request.prefix_db_agency#.Payer where Payer_ID = '#payerid#' SELECT Rev_Code, HCPCS, Visit_Type FROM #Request.prefix_db_agency#.Revenue_Code WHERE Agency_ID = '#session.AgencyID#' And EClaim_Price IS NOT NULL And RevenueCodeStatus = 'active' And Quick_Books_Price IS NOT NULL And Payer_ID = '#payerid#'