SELECT * FROM
#Request.prefix_db_agency#.Temporary_Table
WHERE
Agency_ID <> 0
AND Patient_ID=
AND Assessment_ID=
AND Report=
AND Agency_ID=
SELECT *
FROM
#Request.prefix_db_agency#.Coding_Scrub
WHERE
Patient_ID=
AND Assessment_ID=
AND Message_ID != 0
GROUP BY Message_ID
ORDER BY Message_ID
SELECT * FROM #Request.prefix_db_agency#.Coding_Scrub
WHERE
Patient_ID=
AND Assessment_ID=
AND Risk =
AND Message like '#risk_message[2]#%'
ORDER BY Message_ID
UPDATE
#Request.prefix_db_agency#.Coding_Scrub
SET
Answer_1=,
Answer_2=,
GG_1=,
GG_2=,
Created_by=
WHERE
Scrub_ID=
UPDATE
#Request.prefix_db_agency#.Temporary_Table
SET
Field_2=,
Field_3=,
Field_4=,
Field_5=
WHERE
ID=
SELECT
Dx_list_ICD10_PDGM.ID as Dx_id,Dx_list_ICD10_PDGM.Diagnosis as Dx_Diagnosis,Dx_list_ICD10_PDGM.ICD as Dx_ICD,Dx_list_ICD10_PDGM.Pathway_ID as Dx_Pathway_ID
FROM
#Request.prefix_db_lookup#.Dx_list_ICD10_PDGM
WHERE
Dx_list_ICD10_PDGM.ICD LIKE '%#arguments.Key_word#%'
OR Diagnosis like '%#arguments.Key_word#%'
Order by Dx_list_ICD10_PDGM.ID
Diagnosis:
Diagnosis
Action
#get_TeachingDiagnoses_list.Dx_Diagnosis#
No Result Found
SELECT * FROM
#Request.prefix_db_agency#.Coding_Results
WHERE
Patient_ID=
AND Assessment_ID=
AND ( M0_Item_Medication='(M1021)' or M0_Item_Medication='(M1023)' or M0_Item_Medication='OASIS' )
SELECT * FROM
#Request.prefix_db_agency#.Coding_Results
WHERE
Patient_ID=
AND Assessment_ID=
AND M0_Item_Medication like '%(M102%'
ORDER BY Dx_Order ASC
SELECT * FROM
#Request.prefix_db_agency#.Coding_Results
WHERE
Patient_ID=
AND Assessment_ID=
SELECT * FROM
#Request.prefix_db_agency#.Coding_Results as r
join #Request.prefix_db_agency#.Coding_Scrub as s on s.patient_ID=r.Patient_ID and s.Assessment_ID=r.Assessment_ID
WHERE
r.Patient_ID=
AND r.Assessment_ID=
SELECT
patient.Patient_ID, Assessment_New.Assessment_Reason_M0100,Assessment_New.Assessment_ID,Assessment_New.Assessment_Tracker_ID,
Assessment_New.cdate_cdarte, Assessment_New.Assessment_Completed_M0090,
patient.Last_Name_M0040 AS PatientLast, patient.First_Name_M0040 AS PatientFirst, Assessment_New.OASIS_2019_2020_PDGM
FROM
#Request.prefix_db_agency#.patient
JOIN
#Request.prefix_db_agency#.Assessment_New on patient.Patient_ID = Assessment_New.Patient_ID
WHERE
patient.Patient_ID=
AND Assessment_New.Assessment_ID=
SELECT * FROM #Request.prefix_db_agency#.Coding_Scrub
WHERE Patient_ID=
AND Assessment_ID=
SELECT * FROM #Request.prefix_db_agency#.Coding_Scrub
WHERE Patient_ID=
AND Assessment_ID=
GROUP BY Risk,Message
SELECT * FROM #Request.prefix_db_agency#.Coding_Scrub
WHERE
Patient_ID=
AND Assessment_ID=
AND Risk =
AND Message like '#arguments.Message_value#%'
AND (Answer_1 != "" OR Answer_2 != "" OR GG_1 !="" OR GG_2 !="" OR Created_by !="")
AND Message_ID !=76
ORDER BY Message_ID
SELECT * FROM
#Request.prefix_db_agency#.Coding_Results
WHERE
Patient_ID=
AND Assessment_ID=
SELECT * FROM
#Request.prefix_db_agency#.patient
WHERE
Patient_ID=
SELECT * FROM
#Request.prefix_db_agency#.Coding_Path
WHERE
Patient_ID=
AND Assessment_ID=
SELECT * FROM #Request.prefix_db_agency#.Coding_Scrub
WHERE
Patient_ID=
AND Assessment_ID=
AND Risk =
AND (Answer_1 != "" OR Answer_2 != "" OR GG_1 !="" OR GG_2 !="" OR Created_by !="")
AND Message_ID !=76
ORDER BY Message_ID
