UPDATE #Request.prefix_db_lookup#.XML_Text SET Answer = null UPDATE #Request.prefix_db_agency#.patient SET Safety_Hazards_M0320 = , Assisting_Persons_M0350 = , Financial_Factors_M0150 = , Structural_Barriers_M0310 = , Employee_ID = WHERE Patient_ID = UPDATE #Request.prefix_db_agency#.Assessment_New SET SN_Visit_Count = , HHA_Visit_Count = , HHRG_700_Score = , HHRG_825_Score = , Therapy_Visit_Count = , total_st_visit = , total_msw_visit = , Record_Created_By = WHERE Assessment_ID = SELECT Assessment_Tracker_ID FROM #Request.prefix_db_agency#.Assessment_New WHERE Assessment_ID = UPDATE #Request.prefix_db_agency#.assessment_Tracker SET Employee_ID = WHERE Assessment_Tracker_ID = INSERT IGNORE INTO #Request.prefix_db_agency#.patient ( Agency_ID, Employee_ID,Status, Last_Name_M0040, First_Name_M0040, Assisting_Persons_M0350,Safety_Hazards_M0320,Structural_Barriers_M0310,Record_Creation_Date,Record_Created_By,Record_Mod_Date, Record_Mod_By,cdate_cdarte, Financial_Factors_M0150 ) VALUES ( , , , , , , , , , , , , , ) select LAST_INSERT_ID() as keyvalue INSERT IGNORE INTO #Request.prefix_db_agency#.assessment_Tracker ( Agency_ID, Employee_ID, Patient_ID, Assessment_Type,Assessment_ID,Status ) VALUES ( , , , , , ) select LAST_INSERT_ID() as track_value INSERT IGNORE INTO #Request.prefix_db_agency#.Assessment_New ( Assessment_Tracker_ID,Patient_ID,Agency_Number,Agency_ID,Assessment_Reason_M0100,Assessment_Completed_M0090,CodingNotified,HIPPS_Code, Record_Creation_Date,Record_Created_By,Record_Mod_Date, Record_Mod_By,cdate_cdarte , OASIS_2019_2020_PDGM , SN_Visit_Count, Therapy_Visit_Count, HHA_Visit_Count, HHRG_700_Score, HHRG_825_Score, ) VALUES ( , , , , , , , , , , , , , ,, , , , ) select LAST_INSERT_ID() as AssValue UPDATE #Request.prefix_db_agency#.assessment_Tracker set Assessment_ID = '#Last_Insert_Ass.AssValue#' WHERE Assessment_Tracker_ID= '#last_insert_assement_tracker_id.track_value#' INSERT IGNORE INTO #Request.prefix_db_agency#.Assessment_New_CW ( Assessment_ID,Patient_ID,M0090_INFO_COMPLETED_DT,M0100_ASSMT_REASON,Record_created_date,Record_updated_date ) VALUES ( , , , , , ) UPDATE #Request.prefix_db_agency#.patient SET Agency_ID = , Employee_ID = , Status = , Last_Name_M0040 = , First_Name_M0040 = , Assisting_Persons_M0350 = , Safety_Hazards_M0320 = , Structural_Barriers_M0310 = , Record_Creation_Date = , Record_Created_By = , Record_Mod_Date = , Record_Mod_By = , cdate_cdarte = , Financial_Factors_M0150 = WHERE Patient_ID = UPDATE #Request.prefix_db_agency#.assessment_Tracker SET Agency_ID = , Employee_ID = , Patient_ID = , Assessment_Type = , Assessment_ID = , Status = WHERE Assessment_Tracker_ID = UPDATE #Request.prefix_db_agency#.Assessment_New SET Assessment_Tracker_ID = , Patient_ID = , Agency_Number = , Agency_ID = , Assessment_Reason_M0100 = , Assessment_Completed_M0090 = , CodingNotified = , HIPPS_Code = , Record_Creation_Date = , Record_Created_By = , Record_Mod_Date = , Record_Mod_By = , cdate_cdarte = , OASIS_2019_2020_PDGM = ,SN_Visit_Count = , Therapy_Visit_Count = , HHA_Visit_Count = , total_st_visit = , total_msw_visit = , HHRG_700_Score = , HHRG_825_Score = WHERE Assessment_ID = UPDATE #Request.prefix_db_agency#.Assessment_New_CW SET Assessment_ID = , Patient_ID = , M0090_INFO_COMPLETED_DT = , M0100_ASSMT_REASON = , Record_created_date = , Record_updated_date = WHERE CW_ID = Assisting_Persons_M0350,Safety_Hazards_M0320,Structural_Barriers_M0310,Financial_Factors_M0150,Record_Creation_Date,Record_Created_By,Record_Mod_Date, Record_Mod_By,cdate_cdarte ) VALUES ( , , , , , , , , , , , , , ) select LAST_INSERT_ID() as keyvalue INSERT IGNORE INTO #Request.prefix_db_agency#.assessment_Tracker ( Agency_ID, Employee_ID, Patient_ID, Assessment_Type,Assessment_ID,Status ) VALUES ( , , , , , ) select LAST_INSERT_ID() as track_value INSERT IGNORE INTO #Request.prefix_db_agency#.Assessment_New ( Assessment_Tracker_ID,Patient_ID,Agency_Number,Agency_ID,Assessment_Reason_M0100,Assessment_Completed_M0090,CodingNotified, Record_Creation_Date,Record_Created_By,Record_Mod_Date, Record_Mod_By,cdate_cdarte ) VALUES ( , , , , , , , , , , , ) select LAST_INSERT_ID() as AssValue UPDATE #Request.prefix_db_agency#.assessment_Tracker set Assessment_ID = '#Last_Insert_Ass.AssValue#' WHERE Assessment_Tracker_ID= '#last_insert_assement_tracker_id.track_value#' INSERT IGNORE INTO #Request.prefix_db_agency#.Assessment_New_CW ( Assessment_ID,Patient_ID,M0090_INFO_COMPLETED_DT,M0100_ASSMT_REASON,Record_created_date,Record_updated_date ) VALUES ( , , , , , ) UPDATE #Request.prefix_db_agency#.patient SET Agency_ID = , Employee_ID = , Status = , Last_Name_M0040 = , First_Name_M0040 = , Assisting_Persons_M0350 = , Safety_Hazards_M0320 = , Structural_Barriers_M0310 = , Financial_Factors_M0150 = , Record_Creation_Date = , Record_Created_By = , Record_Mod_Date = , Record_Mod_By = , cdate_cdarte = WHERE Patient_ID = UPDATE #Request.prefix_db_agency#.assessment_Tracker SET Agency_ID = , Employee_ID = , Patient_ID = , Assessment_Type = , Assessment_ID = , Status = WHERE Assessment_Tracker_ID = UPDATE #Request.prefix_db_agency#.Assessment_New SET Assessment_Tracker_ID = , Patient_ID = , Agency_Number = , Agency_ID = , Assessment_Reason_M0100 = , Assessment_Completed_M0090 = , CodingNotified = , Record_Creation_Date = , Record_Created_By = , Record_Mod_Date = , Record_Mod_By = , cdate_cdarte = WHERE Assessment_ID = UPDATE #Request.prefix_db_agency#.Assessment_New_CW SET Assessment_ID = , Patient_ID = , M0090_INFO_COMPLETED_DT = , M0100_ASSMT_REASON = , Record_created_date = , Record_updated_date = WHERE CW_ID = --->