Select * from #Request.prefix_db_agency#.pAssessments where Assmt_ID='#form.Assmt_ID#' SELECT pPatients.*,Agency.* ,pAdmit.Render_Phys_ID AS Primary_ReferringPhys_Id_M0072, pAdmit.* FROM #Request.prefix_db_agency#.pPatients JOIN #Request.prefix_db_agency#.pAdmit ON pAdmit.Patient_Id = pPatients.Patient_Id JOIN #Request.prefix_db_lookup#.Agency ON Agency.Agency_Id = pPatients.Loc_ID WHERE pPatients.Patient_Id = '#session.cs.patientid#' AND pPatients.status = 0 AND pAdmit.status = 0 GROUP BY pPatients.Patient_Id UPDATE #Request.prefix_db_agency#.pAssessments SET Record_Created_By = '#Session.EmployeeId#' where Assmt_ID = '#form.Assmt_ID#' Update #Request.prefix_db_lookup#.pPhysicians set Phys_Last='#form.txtphylastname#', Phys_First='#form.txtphyfirstname#', Phys_Street='#form.txtphyAddress#', Phys_City='#form.txtphyCity#', Phys_State='#form.txtphyState#', Phys_Zip='#form.txtphyMEZip#', Phys_Phone='#form.txtphyMEPhone#', Phys_Fax='#form.txtphyFax#', Phys_NPI='#form.txtphyNPI#', Record_Mod_Date=#now()#, Record_Mod_By='#Session.EmployeeId#' WHERE Phys_ID = '#form.Phys_ID#' select pPtmeds.Drug_Name, pPtmeds.Dose, pPtmeds.Dose_Units, pPtmeds.Route, pPtmeds.Freq, pPtmeds.Notes from #Request.prefix_db_agency#.pPtmeds where pPtmeds.Patient_ID=(Select pAssessments.Patient_ID from #Request.prefix_db_agency#.pAssessments where pAssessments.Assmt_ID='#form.Assmt_ID#') and pPtmeds.Status = '0' '&Temp> SELECT vetted_190924.ICD, vetted_190924.Diagnosis_Short AS Short_Diagnosis,vetted_190924.* FROM #Request.prefix_db_agency#.pProblem JOIN #Request.prefix_db_lookup#.vetted_190924 ON vetted_190924.Diagnosis = pProblem.Description WHERE pProblem.Assmt_ID = AND pProblem.M0_No like 'M1023%' AND pProblem.status = ORDER BY RIGHT(M0_No, 1) ASC SELECT vetted_190924.ICD, vetted_190924.Diagnosis_Short AS Short_Diagnosis,vetted_190924.* FROM #Request.prefix_db_agency#.pProblem JOIN #Request.prefix_db_lookup#.vetted_190924 ON vetted_190924.Diagnosis = pProblem.Description WHERE pProblem.Assmt_ID = AND pProblem.M0_No like 'M1021%' AND pProblem.status = ORDER BY RIGHT(M0_No, 1) ASC primaryTemp> '&ICDTemp> '&otherTemp> SELECT * FROM #Request.prefix_db_agency#.pCMS4857 WHERE Assmt_ID = AND status = 0 INSERT INTO #Request.prefix_db_agency#.pCMS4857 (Assmt_ID, Status,Form_Type, Insured_HIC, Date_Admit, Certification_From, Certification_To, Pt_Agy_ID, Agy_CCN, Pt_First, Pt_Last, Pt_Street, Pt_City, Pt_State, Pt_Zip, Pt_Phone, Agy_Name, Agy_Street, Agy_City, Agy_State, Agy_Zip, Agy_Phone, Agy_NPI, Pt_DOB, Pt_Gender, Medications, ICD10, Description, ICD_Date, DME, Safety, Diet, Allergies, Functional_Limitations, Functional_Limits_Extra, Activities_Permitted, Activities_Permitted_Extra, Mental_Status, Mental_Status_Extra, Prognosis, Careplan_SN, Careplan_PT, Careplan_OT, Careplan_ST, Careplan_MSW, Careplan_HHA, Careplan_other, Goals_SN, Goals_PT, Goals_OT, Goals_ST, Goals_MSW, Goals_HHA, Goals_other, Rehabilitation_Potential, Discharge_Plan, Clinician_Signature, Render_Phys_ID, MD_Homebound, MD_Clinical_Condition, Date_Create, Created_by, Date_Change, Change_by) VALUES ( , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , ) select LAST_INSERT_ID() as keyvalue