Select * from #Request.prefix_db_agency#.pAssessments where Assmt_ID='#url.assid#' AND status = 0 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 IN (0,1,4) AND pAdmit.status = 0 ORDER BY pAdmit.M0030_START_CARE_DT DESC SELECT CASE WHEN LEFT(F26,1) = '1' THEN F251 ELSE F251 END AS DME, CASE WHEN LEFT(F26,1) = '1' THEN F252 ELSE F252 END AS Safety, CASE WHEN LEFT(F26,1) = '1' THEN F253 ELSE F253 END AS Diet, CASE WHEN LEFT(F26,1) = '1' THEN F254 ELSE F254 END AS Functional_Limitations, CASE WHEN LEFT(F26,1) = '1' THEN F255 ELSE F254 END AS Functional_Limits_Extra, CASE WHEN LEFT(F26,1) = '1' THEN F256 ELSE F256 END AS Activities_Permitted, CASE WHEN LEFT(F26,1) = '1' THEN F257 ELSE F257 END AS Activities_Permitted_Extra, CASE WHEN LEFT(F26,1) = '1' THEN F258 ELSE F258 END AS Mental_Status_Extra, CASE WHEN LEFT(F26,1) = '1' THEN F259 ELSE F259 END AS Prognosis, CASE WHEN LEFT(F26,1) = '1' THEN F54 ELSE F262 END AS Hospital, CASE WHEN LEFT(F26,1) = '1' THEN F34 ELSE F40 END AS COGNITION, CASE WHEN LEFT(F26,1) = '1' THEN F35 ELSE F261 END AS ANXIETY, CASE WHEN LEFT(F26,1) = '1' THEN F69 ELSE F69 END AS SOCIAL_ISOLATION, CASE WHEN LEFT(F26,1) = '1' THEN F70 ELSE F70 END AS BEHAVIORAL_ISSUES, CASE WHEN LEFT(F26,1) = '1' THEN F154 ELSE F154 END AS HISTORY_OF_DEPRESSION, CASE WHEN LEFT(F26,1) = '1' THEN F82 ELSE F82 END AS Self_Care, CASE WHEN LEFT(F26,1) = '1' THEN F83 ELSE F83 END AS Mobility from #Request.prefix_db_agency#.pAssessments WHERE Admit_ID='#Getass.Admit_ID#' AND Assmt_ID='#url.assid#' AND status = 0 ORDER BY F176 DESC LIMIT 0,1 SELECT pCareplan.* FROM #Request.prefix_db_agency#.pCareplan WHERE Assmt_ID = AND status = AND Type IN ('discharge_plan') ", "ALL")# /> SELECT * FROM #Request.prefix_db_agency#.pPtPayer WHERE Patient_ID = '#session.cs.patientid#' AND Status = 0 select pPtmeds.Drug_Name, pPtmeds.Dose, pPtmeds.Dose_Units, pPtmeds.Route, pPtmeds.Freq, pPtmeds.Notes,pPtmeds.PtMeds_ID from #Request.prefix_db_agency#.pPtmeds where pPtmeds.Patient_ID IN (Select pAssessments.Patient_ID from #Request.prefix_db_agency#.pAssessments where pAssessments.Assmt_ID='#url.assid#' AND pAssessments.status= 0 GROUP BY Patient_ID) and pPtmeds.Status = '0' AND pPtmeds.In_Home = 1 '&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 = GROUP BY pProblem.Description ORDER BY pProblem.dx_order 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 = GROUP BY pProblem.Description ORDER BY pProblem.dx_order 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_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

Issues when you created 485 form