SELECT pOrphan.*,pProblem.Description from #Request.prefix_db_agency#.pOrphan
JOIN #Request.prefix_db_agency#.pProblem ON pProblem.Problem_ID = pOrphan.Problem_ID
AND pOrphan.Assmt_ID = pProblem.Assmt_ID
AND pProblem.status = 0
where pOrphan.status = 0
AND pOrphan.Problem_Dx_ID = '#Problem_ID#'
AND pProblem.M0_No NOT IN ('CM')
AND pProblem.Description NOT like 'M18%'
AND pProblem.Description NOT LIKE 'GG0%' AND Trim(pProblem.Description) NOT LIKE '(%'
ORDER BY pProblem.Problem_ID ASC
SELECT * FROM #Request.prefix_db_agency#.pProblem
WHERE Problem_ID =
AND Status =
AND pProblem.Assmt_ID = '#getSymp.Assmt_ID#'
AND M0_No like 'M102%'
UPDATE #Request.prefix_db_agency#.pProblem
SET Answer = ,
Severity = ,
Careplan = '#Careplan#'
WHERE AutoProblem_ID =
AND Status =
UPDATE #Request.prefix_db_agency#.pOrphan
SET Paired =
WHERE Orphan_ID IN ()
AND Status =
UPDATE #Request.prefix_db_agency#.pOrphan
SET Paired =
WHERE Orphan_ID IN ()
AND Status =
SELECT DISTINCT Assmt_ID FROM #Request.prefix_db_agency#.pOrphan
WHERE Orphan_ID IN ()
AND status = 0
UPDATE #Request.prefix_db_agency#.pAssessments
SET F320 = 0
WHERE Status = 0
AND Assmt_ID IN ()
SELECT * FROM #Request.prefix_db_agency#.pProblem
WHERE Problem_ID =
AND Status =
SELECT Patient_ID
FROM #Request.prefix_db_agency#.pAssessments
WHERE Assmt_ID =
AND Status =
SELECT pPtmeds.PtMeds_ID, pPtmeds.Drug_Name
FROM #Request.prefix_db_agency#.pPtmeds
LEFT JOIN #Request.prefix_db_agency#.pMed_Recon ON pMed_Recon.PtMeds_ID = pPtmeds.PtMeds_ID
AND pMed_Recon.Assmt_ID =
AND pMed_Recon.Med_Dx_ID =
AND pMed_Recon.Status =
WHERE pPtmeds.Patient_ID =
AND pPtmeds.Status =
AND pMed_Recon.PtMeds_ID IS NULL
AND pPtmeds.PtMeds_ID NOT IN ()
GROUP BY pPtmeds.PtMeds_ID
SELECT IFNULL(MAX(Orphan_ID),0) AS Max_Orphan_ID
FROM #Request.prefix_db_agency#.pMed_Recon
INSERT INTO #Request.prefix_db_agency#.pMed_Recon
(Orphan_ID, Assmt_ID, PtMeds_ID, Drug_Name, Med_Dx_ID, Diagnosis, Paired, automatic_paired, Date_Created, Created_By)
VALUES (
,
,
,
,
,
,
,
,
,
)
SELECT pMed_Recon.* from #Request.prefix_db_agency#.pMed_Recon
JOIN #Request.prefix_db_agency#.pPtmeds ON pPtmeds.PtMeds_ID = pMed_Recon.PtMeds_ID
AND pPtmeds.status = 0
where pMed_Recon.status = 0
AND pMed_Recon.Med_Dx_ID =
AND pMed_Recon.Assmt_ID =
AND pMed_Recon.PtMeds_ID NOT IN ()
ORDER BY pMed_Recon.Drug_Name ASC
UPDATE #Request.prefix_db_agency#.pProblem
SET Answer = ,
Severity =
WHERE AutoProblem_ID =
AND Status =
UPDATE #Request.prefix_db_agency#.pMed_Recon
SET Paired =
WHERE Orphan_ID IN ()
AND Status =
UPDATE #Request.prefix_db_agency#.pMed_Recon
SET Paired =
WHERE Orphan_ID IN ()
AND Status =
SELECT DISTINCT Patient_ID, Assmt_ID FROM #Request.prefix_db_agency#.pMed_Recon
JOIN #Request.prefix_db_agency#.pPtmeds ON pPtmeds.PtMeds_ID = pMed_Recon.PtMeds_ID
WHERE Orphan_ID IN ()
AND pMed_Recon.status = 0
UPDATE #Request.prefix_db_agency#.pPatients
SET Med_Approve = 2,
Med_Recon_Field = 2
WHERE Status < 2
AND Patient_ID IN ()