SELECT Admit_Type FROM #Request.prefix_db_agency#.pAdmit WHERE Patient_ID = AND M0030_START_CARE_DT = AND Status = 0 ORDER BY Admit_ID DESC LIMIT 1 insert into #Request.prefix_db_agency#.assessment_Tracker (Agency_ID, Employee_ID, Patient_ID, Assessment_Type,Assessment_ID,Status) values ('#AgencyID#', '#EmployeeID#', '#PID#', '#M0100#',0,'active') select LAST_INSERT_ID() as keyvalue INSERT INTO #Request.prefix_db_agency#.Assessment_New ( Assessment_Tracker_ID, Patient_ID, Agency_Number, Agency_ID, M0102_Physician_SOC, M0104_Date_of_Referral, 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, patient_rights_signed, Assessment_Reason_M0100, Person_Complete_M0080, Admission_Description, Source_of_Admission, Certification_Start, Certification_End, Admission_Status, Transmission_Status, Information_Release, Payer_ID, Record_Creation_Date ) VALUES ( '#LastInsertAssTracker.keyvalue#', '#PID#', '#AgencyID#', '#AgencyID#', #CreateODBCDate(M0102)#, #CreateODBCDate(M0104)#, '#session.AgencyLogin#', '#tracker#', #CreateODBCDate(M0030)#, #CreateODBCDate(M0032)#, '#M0032NA#', #CreateODBCDate(M0090)#, #CreateODBCDate(M0906)#, '#Previous_Assessment_Number#', #CreateODBCDate(Physician_Last_Seen_Date)#null, #CreateODBCDate(patient_rights_signed)#null, '#M0100#', '#M0080#', '#Admission_Description#', '#Source_of_Admission#', #CreateODBCDate(Certification_Start)#, #CreateODBCDate(newdate)#, 'not applicable', 'In Progress', null, 'OASIS unlocked', '#Information_Release#', '#Payer_ID#', #CreateODBCDate(Now())# ) select LAST_INSERT_ID() as AssValue SELECT Assessment_ID from #Request.prefix_db_agency#.Assessment_New where Assessment_Tracker_ID = '#LastInsertAssTracker.keyvalue#' UPDATE #Request.prefix_db_agency#.assessment_Tracker set Assessment_ID = '#LastInsertAss.AssValue#' where Assessment_Tracker_ID= '#LastInsertAssTracker.keyvalue#' Select * from #Request.prefix_db_agency#.PatientContact where patient_id = '#cookie.patientId#' and contactstatus = 0 order by contactname