INSERT INTO #Request.prefix_db_agency#.PatientVisitDetails(ScheduleItems_ID,Description,Agency_ID,Patient_ID,Assessment_ID,Assessment_Tracker_ID,Record_Creation_Date,Type,Notes,Reading1,Severity) VALUES ('#session.cs.ScheduleId#','#Type#','#Session.AgencyLogin#','#patientid#','#AssessmentID#','#AssessmentTrackerID#','#DateFormat(now(),"yyyy-mm-dd")#','vital sign','#Notes#','#Reading#','#Severity#') select LAST_INSERT_ID() as keyvalue 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 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 * FROM #Request.prefix_db_agency#.visit_orders where Assessment_ID='#assid#' and Revenue_Code = '#revcode#' SELECT StartDate,EndDate,Units FROM #Request.prefix_db_agency#.authorizations where Revenue_Code = '#revcode#' and Assessment_ID='#session.cs.AssessmentId#' 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#'