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 =