insert into #Request.prefix_db_agency#.assessment_Tracker (Agency_ID, Employee_ID, Patient_ID, Assessment_Type,Assessment_ID,Status) values (#session.AgencyID#, #Session.EmployeeID#, #form.PID#, '#form.M0100#',0,'active'); SELECT MAX(Assessment_Tracker_ID) as maxtrackerid FROM #Request.prefix_db_agency#.assessment_Tracker WHERE Patient_ID = #form.PID# and Agency_ID = #session.AgencyID# and Employee_ID = #Session.EmployeeID# and Status='active' and Assessment_ID = 0 INSERT INTO #Request.prefix_db_agency#.Assessment_New ( Assessment_Tracker_ID, Patient_ID, Agency_Number, Agency_ID, HHAC_Agency_ID, Assessment_Number, Start_of_Care_M0030, Resump_of_Care_M0032, Resump_of_Care_NA_M0032, Assessment_Completed_M0090, Date_Discharge_M0906, Previous_Assessment_Number, Physician_Last_Seen_Date, Assessment_Reason_M0100, Source_of_Admission, Certification_Start, Certification_End, Admission_Status, Transmission_Status, SN_Visit_Orders, Therapy_Visit_Orders, HHA_Visit_Orders, Assessment_note, Information_Release, Claim_Key, UniqueAuth, NotAdmitted, Payer_ID, Record_Creation_Date ) VALUES ( #tracker.maxtrackerid#, #form.PID#, #session.AgencyID#, #session.AgencyID#, #session.AgencyLogin#, '#form.tracker#', #CreateODBCDate(form.M0030)#, #CreateODBCDate(form.M0032)#, '#var.M0032NA#', #CreateODBCDate(form.M0090)#, #CreateODBCDate(form.M0906)#, '#form.Previous_Assessment_Number#', #CreateODBCDate(form.Physician_Last_Seen_Date)#null, '#form.M0100#', '#form.Source_of_Admission#', #CreateODBCDate(form.Certification_Start)#, #CreateODBCDate(newdate)#, 'not applicable', 'In Progress', 'not applicable', 'OASIS In Progress', '#SN_Visit_Orders#', '#Therapy_Visit_Orders#', '#HHA_Visit_Orders#', '#Assessment_note#', '#var.Information_Release#', '#Claim_Key#', '#UniqueAuth#', #var.NotAdmitted#, #form.Payer_ID#, #CreateODBCDate(Now())# ) SELECT Assessment_ID from #Request.prefix_db_agency#.Assessment_New where Assessment_Tracker_ID = #tracker.maxtrackerid# UPDATE #Request.prefix_db_agency#.assessment_Tracker set Assessment_ID = #assessment.Assessment_ID# where Assessment_Tracker_ID= #tracker.maxtrackerid# INSERT INTO #Request.prefix_db_lookup#.Assessment_TimeAuthorizations (Agency_ID,Assessment_ID,RevCode_ID,Payer_ID,Assessment_Tracker_ID,ApprovedHours,Patient_ID) VALUES('#session.agencyid#','#form.AID#','#therevid#','#Session.Payer_ID#','#form.ATID#','#thevalue#','#Session.CS.PatientID#') UPDATE #Request.prefix_db_lookup#.Assessment_TimeAuthorizations set approvedhours=#thevalue# WHERE Assessment_TimeAuthorizations_ID = #theid# UPDATE #Request.prefix_db_agency#.Assessment_New set Start_of_Care_M0030 = #CreateODBCDate(form.M0030)#, Resump_of_Care_M0032 = #CreateODBCDate(form.M0032)#, Resump_of_Care_NA_M0032 = '#var.M0032NA#', Physician_Last_Seen_Date = #CreateODBCDate(form.Physician_Last_Seen_Date)#null, Assessment_Completed_M0090 = #CreateODBCDate(form.M0090)#, Date_Discharge_M0906 = #CreateODBCDate(form.M0906)#, Previous_Assessment_Number = '#form.Previous_Assessment_Number#', Assessment_Reason_M0100 = '#form.M0100#', Source_of_Admission = '#form.Source_of_Admission#', Certification_Start = #CreateODBCDate(form.Certification_Start)#, Certification_End = #CreateODBCDate(newdate)#, SN_Visit_Orders = '#form.SN_Visit_Orders#', Therapy_Visit_Orders = '#form.Therapy_Visit_Orders#', HHA_Visit_Orders = '#form.HHA_Visit_Orders#', Assessment_note = '#form.Assessment_note#', Information_Release = '#var.Information_Release#', Deleted = '#var.Deleted#', NotAdmitted = '#var.NotAdmitted#', Archive = '#var.Archive#', Payer_ID = #form.Payer_ID#, Claim_Key = '#Claim_Key#', UniqueAuth = '#UniqueAuth#', Record_Mod_Date = #CreateODBCDate(Now())# WHERE Assessment_ID = #form.AID#