SELECT * FROM
#Request.prefix_db_agency#.Assessment_New
WHERE
Assessment_ID=
SELECT * FROM #Request.prefix_db_agency#.Teaching_Skills
WHERE Patient_ID=
AND Assessment_ID=
AND Deleted=0
AND ICD=
SELECT MAX(Dx_Order) as diagnosis_order FROM
#Request.prefix_db_agency#.Diagnosis
WHERE
Patient_ID=
AND Assessment_ID=
AND Disabled=0
AND Assessment_Tracker_ID=
SELECT *
FROM #Request.prefix_db_lookup#.vetted_190924 as vt
JOIN #Request.prefix_db_lookup#.CW_Coding_Class_PDGM as cw ON vt.Priority = cw.Priority
WHERE
vt.ID =
DELETE FROM #Request.prefix_db_agency#.Teaching_Skills
WHERE Patient_ID=
AND Assessment_ID=
AND Deleted=0
AND ICD=
DELETE FROM #Request.prefix_db_agency#.Teaching_Skills_span
WHERE Patient_ID=
AND Assessment_ID=
AND Deleted=0
AND ICD=
UPDATE #Request.prefix_db_agency#.Diagnosis
SET Disabled = 1
WHERE Patient_ID=
AND Assessment_ID=
AND ICD=
INSERT INTO #Request.prefix_db_agency#.Diagnosis
(
M0230_Link, Assessment_ID, Assessment_Tracker_ID, Patient_ID, Agency_ID, Diagnosis, ICD, Text_ICD, Short_Diagnosis, Record_Creation_Date, Record_Created_By, Record_Mod_Date, Record_Mod_By, Dx_Order, Primary_Diagnosis , PDGM_Comorbidity PDGM_Primary, PDGM_Subchapter , symptoms,Symptoms_S
)
VALUES
(
,
,
,
,
,
,
,
,
,
,
,
,
,
,
,
,
,
,
)
select LAST_INSERT_ID() as diagnoses_id_agency
SELECT *
FROM #Request.prefix_db_lookup#.vetted_190924 as vt
JOIN #Request.prefix_db_lookup#.CW_Coding_Class_PDGM as cw ON vt.Priority = cw.Priority
WHERE
vt.ID =
SELECT * FROM #Request.prefix_db_agency#.Diagnosis WHERE Patient_ID= AND Assessment_ID= AND Disabled=0 AND ICD=
SELECT * FROM #Request.prefix_db_agency#.Diagnosis WHERE Primary_Diagnosis=1 AND Patient_ID= AND Assessment_ID= AND Assessment_Tracker_ID= AND Disabled <> 1 AND Pathway_Type=""
UPDATE #Request.prefix_db_agency#.Diagnosis SET
Primary_Diagnosis = ,
Record_Mod_Date = ,
Record_Mod_By =
WHERE Diagnosis_ID=
UPDATE
#Request.prefix_db_agency#.Diagnosis
SET
Primary_Diagnosis = ,
PDGM_Comorbidity = , PDGM_Primary = , PDGM_Subchapter = ,
Record_Creation_Date = ,
Record_Created_By = ,
Record_Mod_Date = ,
Record_Mod_By =
WHERE
Patient_ID= AND Assessment_ID= AND Disabled=0 AND ICD=
UPDATE #Request.prefix_db_agency#.Diagnosis SET
severity = ,
Dx_Order = ,
Record_Mod_Date = ,
Record_Mod_By =
WHERE Diagnosis_ID=
select Assessment_New.Assessment_ID, Assessment_New.Assessment_Tracker_ID, Assessment_New.Assessment_Completed_M0090, Assessment_New.Assessment_Reason_M0100, Assessment_New.Record_Creation_Date
from #Request.prefix_db_agency#.Assessment_New
WHERE Patient_ID= and Agency_ID=
SELECT
Teaching_Skills.ID, Teaching_Skills.ICD, Teaching_Skills.Explanation, Teaching_Skills.Step_ID, Teaching_Skills.Diagnosis_ID, Teaching_Skills.Pathway_Type
FROM
(SELECT Teaching_Skills.ID, Teaching_Skills.ICD, Teaching_Skills.Explanation, Teaching_Skills.Step_ID, Teaching_Skills.Diagnosis_ID, Teaching_Skills.Pathway_Type FROM #Request.prefix_db_agency#.Teaching_Skills WHERE Diagnosis_ID= AND Deleted=0 AND Pathway_Type NOT IN('goal','intervention') ORDER BY Step_ID ASC) as Teaching_Skills
ORDER BY Pathway_Type
SELECT
Teaching_Skills.ID, Teaching_Skills.ICD, Teaching_Skills.Explanation, Teaching_Skills.Step_ID, Teaching_Skills.Diagnosis_ID, Teaching_Skills.Pathway_Type, Teaching_Skills.Order_ID
FROM
#Request.prefix_db_agency#.Teaching_Skills
WHERE
Diagnosis_ID= AND Deleted=0 AND Pathway_Type NOT LIKE 'goal%'
AND Pathway_Type NOT LIKE 'intervention%' AND Pathway_Type NOT LIKE 'Source%' ORDER BY Order_ID ASC
SELECT * FROM #Request.prefix_db_agency#.Diagnosis
WHERE Diagnosis_ID=
AND Disabled = 0
SELECT *
FROM #Request.prefix_db_lookup#.vetted_190924 as vt
JOIN #Request.prefix_db_lookup#.CW_Coding_Class_PDGM as cw ON vt.Priority = cw.Priority
WHERE
vt.ICD =
SELECT ID, Patient_ID, Assessment_ID, ICD, 3Digit, Pathway_Type, Pathway_ID, Diagnosis_ID, Deleted, max(Order_ID) as max_order, max(Title_Order_ID) as max_title_order FROM #Request.prefix_db_agency#.Teaching_Skills
WHERE
Diagnosis_ID=
AND Patient_ID=
AND Assessment_ID=
AND ICD=
AND Pathway_Type='Teaching'
AND Pathway_ID <> 0
AND Deleted=0
SELECT Teaching_Skills.ID, Teaching_Skills.ICD, Teaching_Skills.Explanation, Teaching_Skills.Step_ID, Teaching_Skills.Line_ID, Teaching_Skills.Diagnosis_ID, Teaching_Skills.Pathway_Type, Teaching_Skills.Order_ID,Teaching_Skills.Pathway_ID,(SELECT type FROM #Request.prefix_db_lookup#.Teaching_Prevention WHERE Teaching_Prevention.Pathway_ID = Teaching_Skills.Pathway_ID AND Type = 'Title' ) as title_type
FROM
#Request.prefix_db_agency#.Teaching_Skills
WHERE
Diagnosis_ID =
AND Deleted=0
AND Pathway_Type NOT LIKE 'goal%'
AND Pathway_Type NOT LIKE 'intervention%'
AND Pathway_Type NOT LIKE 'Source%'
AND Title_Order_ID IS NOT NULL
AND Pathway_Type <> 'Title'
AND Pathway_ID <> 0
GROUP BY Pathway_Type
ORDER BY Title_Order_ID ASC
SELECT Teaching_Skills.ID, Teaching_Skills.ICD, Teaching_Skills.Explanation, Teaching_Skills.Step_ID, Teaching_Skills.Diagnosis_ID, Teaching_Skills.Line_ID, Teaching_Skills.Pathway_Type, Teaching_Skills.Order_ID,Teaching_Skills.Pathway_ID, 'Title' as title_type (SELECT type FROM #Request.prefix_db_lookup#.Teaching_Prevention WHERE Teaching_Prevention.Pathway_ID = Teaching_Skills.Pathway_ID AND Type = 'Title' ) as title_type
FROM
#Request.prefix_db_agency#.Teaching_Skills
WHERE
Diagnosis_ID =
AND Deleted=0
AND Pathway_Type NOT LIKE 'goal%'
AND Pathway_Type NOT LIKE 'intervention%'
AND Pathway_Type NOT LIKE 'Source%'
AND Pathway_ID <> 0
AND Pathway_Type = '#get_TeachSkills_all_groupby.Pathway_Type#'
OR ( Pathway_Type = 'Title' AND Step_ID=129 AND Line_ID=0 AND Diagnosis_ID = AND Pathway_ID <> 0 )
OR ( Pathway_Type = 'Title' AND Step_ID=0 AND Line_ID=0 AND Diagnosis_ID = AND Pathway_ID <> 0 )
ORDER BY Order_ID ASC
--->
SELECT * FROM #Request.prefix_db_agency#.Diagnosis
JOIN #Request.prefix_db_lookup#.vetted_190924 ON vetted_190924.ICD = Diagnosis.ICD
WHERE Diagnosis.Diagnosis_ID =
AND Diagnosis.Disabled = 0
SELECT * FROM #Request.prefix_db_lookup#.Teaching_Prevention ORDER BY Step_ID ASC
#arguments.diagnosis_table_id#
SELECT
Teaching_Skills.ID, Teaching_Skills.ICD, Teaching_Skills.Explanation, Teaching_Skills.Step_ID, Teaching_Skills.Diagnosis_ID, Teaching_Skills.Pathway_Type, Teaching_Skills.Order_ID
FROM
#Request.prefix_db_agency#.Teaching_Skills
WHERE
Diagnosis_ID= AND Deleted=0 AND Pathway_Type NOT LIKE 'goal%'
AND Pathway_Type NOT LIKE 'intervention%' AND Pathway_Type NOT LIKE 'Source%' AND Pathway_Type="Title" GROUP BY Pathway_ID
SELECT
Diagnosis.Diagnosis_ID as Dg_id, Diagnosis.Assessment_ID as Dg_Assessment_ID, Diagnosis.Assessment_Tracker_ID as Dg_Assessment_Tracker_ID, Diagnosis.Patient_ID as Dg_Patient_ID, Diagnosis.Agency_ID as Dg_Agency_ID, Diagnosis.Diagnosis as Dg_Diagnosis, Diagnosis.ICD as Dg_ICD, Diagnosis.Pathway_Type as Dig_Pathway_Type, Diagnosis.Primary_Diagnosis as Dig_Primary_Diagnosis, Diagnosis.PDGM_Primary as Dg_PDGM_Primary, Diagnosis.PDGM_Subchapter as Dg_PDGM_Subchapter, Diagnosis.PDGM_Comorbidity as Dg_PDGM_Comorbidity, Diagnosis.Record_Creation_Date as Dg_Record_Creation_Date, Diagnosis.Record_Created_By as Dg_Record_Created_By, Diagnosis.Record_Mod_Date as Dg_Record_Mod_Date, Diagnosis.Record_Mod_By as Dg_Record_Mod_By, patient.First_Name_M0040, patient.Last_Name_M0040, patient.Middle_Initial_M0040, Assessment_New.Assessment_Reason_M0100, Assessment_New.Assessment_Completed_M0090,SuperUsers.Full_Name as super_user_name
FROM
#Request.prefix_db_agency#.Diagnosis
LEFT JOIN #Request.prefix_db_agency#.patient on patient.Patient_ID = Diagnosis.Patient_ID
LEFT JOIN #Request.prefix_db_agency#.Assessment_New on Assessment_New.Assessment_ID = Diagnosis.Assessment_ID
LEFT JOIN #Request.prefix_db_lookup#.SuperUsers on SuperUsers.User_ID = Diagnosis.Record_Created_By
WHERE
Diagnosis.Patient_ID= AND Diagnosis.Agency_ID= AND Diagnosis.Assessment_ID=
ORDER BY Diagnosis.Diagnosis_ID ASC
SELECT
Diagnosis.Diagnosis_ID as Dg_id, Diagnosis.Assessment_ID as Dg_Assessment_ID, Diagnosis.Assessment_Tracker_ID as Dg_Assessment_Tracker_ID, Diagnosis.Patient_ID as Dg_Patient_ID, Diagnosis.Agency_ID as Dg_Agency_ID, Diagnosis.Diagnosis as Dg_Diagnosis, Diagnosis.ICD as Dg_ICD, Diagnosis.Pathway_Type as Dig_Pathway_Type, Diagnosis.Primary_Diagnosis as Dig_Primary_Diagnosis, Diagnosis.PDGM_Primary as Dg_PDGM_Primary, Diagnosis.PDGM_Subchapter as Dg_PDGM_Subchapter, Diagnosis.PDGM_Comorbidity as Dg_PDGM_Comorbidity, Diagnosis.Record_Creation_Date as Dg_Record_Creation_Date, Diagnosis.Record_Created_By as Dg_Record_Created_By, Diagnosis.Record_Mod_Date as Dg_Record_Mod_Date, Diagnosis.Record_Mod_By as Dg_Record_Mod_By, patient.First_Name_M0040, patient.Last_Name_M0040, patient.Middle_Initial_M0040, Assessment_New.Assessment_Reason_M0100, Assessment_New.Assessment_Completed_M0090,SuperUsers.Full_Name as super_user_name , Employee.Username as Employee_username, Employee.Last_Name as Employee_Last_Name, Employee.First_Name as Employee_First_Name
FROM
#Request.prefix_db_agency#.Diagnosis
LEFT JOIN #Request.prefix_db_agency#.patient on patient.Patient_ID = Diagnosis.Patient_ID
LEFT JOIN #Request.prefix_db_agency#.Assessment_New on Assessment_New.Assessment_ID = Diagnosis.Assessment_ID
LEFT JOIN #Request.prefix_db_lookup#.SuperUsers on SuperUsers.User_ID = Diagnosis.Record_Created_By
LEFT JOIN #Request.prefix_db_lookup#.Employee on Employee.Employee_ID = patient.Employee_ID
WHERE
Diagnosis.Patient_ID= AND Diagnosis.Agency_ID= AND Diagnosis.Assessment_ID=
ORDER BY Diagnosis.Diagnosis_ID ASC
SELECT
Diagnosis.Diagnosis_ID as Dg_id, Diagnosis.Assessment_ID as Dg_Assessment_ID, Diagnosis.Assessment_Tracker_ID as Dg_Assessment_Tracker_ID, Diagnosis.Patient_ID as Dg_Patient_ID, Diagnosis.Agency_ID as Dg_Agency_ID, Diagnosis.Diagnosis as Dg_Diagnosis, Diagnosis.ICD as Dg_ICD, Diagnosis.Pathway_Type as Dig_Pathway_Type, Diagnosis.Clinical_Type as Dg_Pathway_ID,Diagnosis.Primary_Diagnosis as Dig_Primary_Diagnosis, Diagnosis.PDGM_Primary as Dg_PDGM_Primary, Diagnosis.PDGM_Subchapter as Dg_PDGM_Subchapter, Diagnosis.PDGM_Comorbidity as Dg_PDGM_Comorbidity, Diagnosis.Record_Creation_Date as Dg_Record_Creation_Date, Diagnosis.Record_Created_By as Dg_Record_Created_By, Diagnosis.Record_Mod_Date as Dg_Record_Mod_Date, Diagnosis.Record_Mod_By as Dg_Record_Mod_By, patient.First_Name_M0040, patient.Last_Name_M0040, patient.Middle_Initial_M0040, Assessment_New.Assessment_Reason_M0100, Assessment_New.Assessment_Completed_M0090,SuperUsers.Full_Name as super_user_name
FROM
#Request.prefix_db_agency#.Diagnosis
LEFT JOIN #Request.prefix_db_agency#.patient on patient.Patient_ID = Diagnosis.Patient_ID
LEFT JOIN #Request.prefix_db_agency#.Assessment_New on Assessment_New.Assessment_ID = Diagnosis.Assessment_ID
LEFT JOIN #Request.prefix_db_lookup#.SuperUsers on SuperUsers.User_ID = Diagnosis.Record_Created_By
WHERE
Diagnosis.Patient_ID=
AND Diagnosis.Agency_ID=
AND Diagnosis.Assessment_ID=
AND Diagnosis.Disabled=0
GROUP BY Diagnosis.Pathway_Type ORDER BY Diagnosis.Dx_Order ASC
SELECT
Diagnosis.Diagnosis_ID as Dg_id, Diagnosis.Assessment_ID as Dg_Assessment_ID, Diagnosis.Assessment_Tracker_ID as Dg_Assessment_Tracker_ID, Diagnosis.Patient_ID as Dg_Patient_ID, Diagnosis.Agency_ID as Dg_Agency_ID, Diagnosis.Diagnosis as Dg_Diagnosis, Diagnosis.ICD as Dg_ICD, Diagnosis.Pathway_Type as Dig_Pathway_Type,Diagnosis.Clinical_Type as Dg_Clinical_Type, Diagnosis.Dx_Order as Dig_Dx_Order, Diagnosis.Primary_Diagnosis as Dig_Primary_Diagnosis, Diagnosis.PDGM_Primary as Dg_PDGM_Primary, Diagnosis.PDGM_Subchapter as Dg_PDGM_Subchapter, Diagnosis.PDGM_Comorbidity as Dg_PDGM_Comorbidity, Diagnosis.Record_Creation_Date as Dg_Record_Creation_Date, Diagnosis.Record_Created_By as Dg_Record_Created_By, Diagnosis.Record_Mod_Date as Dg_Record_Mod_Date, Diagnosis.Record_Mod_By as Dg_Record_Mod_By, patient.First_Name_M0040, patient.Last_Name_M0040, patient.Middle_Initial_M0040, Assessment_New.Assessment_Reason_M0100, Assessment_New.Assessment_Completed_M0090,SuperUsers.Full_Name as super_user_name
FROM
#Request.prefix_db_agency#.Diagnosis
LEFT JOIN #Request.prefix_db_agency#.patient on patient.Patient_ID = Diagnosis.Patient_ID
LEFT JOIN #Request.prefix_db_agency#.Assessment_New on Assessment_New.Assessment_ID = Diagnosis.Assessment_ID
LEFT JOIN #Request.prefix_db_lookup#.SuperUsers on SuperUsers.User_ID = Diagnosis.Record_Created_By
WHERE
Diagnosis.Patient_ID=
AND Diagnosis.Agency_ID=
AND Diagnosis.Assessment_ID=
AND Diagnosis.Disabled=0
AND Diagnosis.Pathway_Type='#arguments.Pathway_type#'
AND((Diagnosis.Pathway_Type <> 'DME/supplies' AND Diagnosis.Pathway_Type <> 'diet') OR Diagnosis.Pathway_Type is NULL OR Diagnosis.Pathway_Type = 'diagnosis')
ORDER BY Dig_Dx_Order ASC
SELECT
Diagnosis.Diagnosis_ID as Dg_id, Diagnosis.Assessment_ID as Dg_Assessment_ID, Diagnosis.Assessment_Tracker_ID as Dg_Assessment_Tracker_ID, Diagnosis.Patient_ID as Dg_Patient_ID, Diagnosis.Agency_ID as Dg_Agency_ID, Diagnosis.Diagnosis as Dg_Diagnosis, Diagnosis.ICD as Dg_ICD, Diagnosis.Pathway_Type as Dig_Pathway_Type, Diagnosis.Primary_Diagnosis as Dig_Primary_Diagnosis, Diagnosis.PDGM_Primary as Dg_PDGM_Primary, Diagnosis.Dx_Order as Dx_Order,Diagnosis.Severity as Dx_Severity,Diagnosis.PDGM_Subchapter as Dg_PDGM_Subchapter, Diagnosis.PDGM_Comorbidity as Dg_PDGM_Comorbidity, Diagnosis.Record_Creation_Date as Dg_Record_Creation_Date, Diagnosis.Record_Created_By as Dg_Record_Created_By, Diagnosis.Record_Mod_Date as Dg_Record_Mod_Date, Diagnosis.Record_Mod_By as Dg_Record_Mod_By, patient.First_Name_M0040, patient.Last_Name_M0040, patient.Middle_Initial_M0040, Assessment_New.Assessment_Reason_M0100, Assessment_New.Assessment_Completed_M0090,SuperUsers.Full_Name as super_user_name
FROM
#Request.prefix_db_agency#.Diagnosis
LEFT JOIN #Request.prefix_db_agency#.patient on patient.Patient_ID = Diagnosis.Patient_ID
LEFT JOIN #Request.prefix_db_agency#.Assessment_New on Assessment_New.Assessment_ID = Diagnosis.Assessment_ID
LEFT JOIN #Request.prefix_db_lookup#.SuperUsers on SuperUsers.User_ID = Diagnosis.Record_Created_By
WHERE
Diagnosis.Patient_ID= AND Diagnosis.Agency_ID= AND Diagnosis.Assessment_ID= AND Diagnosis.Disabled=0
AND Diagnosis.Pathway_Type='#arguments.Pathway_type#'
AND((Diagnosis.Pathway_Type <> 'DME/supplies' AND Diagnosis.Pathway_Type <> 'diet') OR Diagnosis.Pathway_Type is NULL OR Diagnosis.Pathway_Type = 'diagnosis')
ORDER BY Diagnosis.Dx_Order ASC
SELECT * FROM #Request.prefix_db_agency#.patient WHERE Patient_ID= AND Agency_ID=
SELECT * FROM #Request.prefix_db_lookup#.SuperUsers
WHERE User_ID=0
SELECT * FROM #Request.prefix_db_lookup#.Employee WHERE Employee_ID=0
SELECT * FROM #Request.prefix_db_agency#.Diagnosis WHERE Diagnosis_ID=
select * from #Request.prefix_db_agency#.Assessment_New where Assessment_ID= and Agency_ID= and Patient_ID=
SELECT vt.id as Dx_id,vt.Diagnosis,vt.ICD as Dx_ICD,vt.Diagnosis as Dx_Diagnosis, vt.Pathway as Dx_Pathway_ID,
vt.PDGM as PDGM, vt.Comorbid as Comorbid
FROM #Request.prefix_db_lookup#.vetted_190924 as vt
JOIN #Request.prefix_db_lookup#.CW_Coding_Class_PDGM as cw ON vt.Priority = cw.Priority
WHERE (vt.Diagnosis LIKE '%#arguments.text#%' OR vt.ICD LIKE '%#arguments.text#%')
Order by vt.ICD
SELECT * FROM #Request.prefix_db_lookup#.Dx_list_Procedures_Diet WHERE Type=
SELECT * FROM #Request.prefix_db_agency#.Teaching_Library WHERE title IS NOT NULL AND Deleted=0 GROUP BY title
SELECT * FROM #Request.prefix_db_agency#.Diagnosis WHERE Diagnosis_ID=
SELECT * FROM #Request.prefix_db_agency#.Diagnosis
WHERE
Primary_Diagnosis=1 AND Patient_ID= AND Assessment_ID= AND Assessment_Tracker_ID= AND Disabled <> 1 AND Diagnosis_ID <> AND Pathway_Type=""
UPDATE #Request.prefix_db_agency#.Diagnosis SET
Primary_Diagnosis = ,
Record_Mod_Date = ,
Record_Mod_By =
WHERE Diagnosis_ID=
UPDATE #Request.prefix_db_agency#.Diagnosis SET
Diagnosis = ,
Primary_Diagnosis = ,
Record_Mod_Date = ,
Record_Mod_By =
WHERE Diagnosis_ID=
UPDATE #Request.prefix_db_agency#.Diagnosis set Diagnosis.Disabled = '#1#'
WHERE Diagnosis_ID=
DELETE FROM #Request.prefix_db_agency#.Teaching_Skills
WHERE Diagnosis_ID=
DELETE FROM #Request.prefix_db_agency#.Teaching_Skills_span
WHERE Diagnosis_ID=
SELECT * FROM #Request.prefix_db_agency#.Teaching_Skills WHERE Teaching_Skills.ID=
SELECT * FROM #Request.prefix_db_agency#.Teaching_Skills WHERE ID=
SELECT * FROM #Request.prefix_db_agency#.Teaching_Skills
WHERE Diagnosis_ID= AND ID <> AND Pathway_Type= LIMIT 1
UPDATE #Request.prefix_db_agency#.Teaching_Skills SET
Explanation = ,
Created_Date = ,
Created_by = ,
Updated_Date = ,
Updated_by =
WHERE ID=
UPDATE #Request.prefix_db_agency#.Teaching_Skills SET
Created_Date = ,
Created_by = ,
Updated_Date = ,
Updated_by =
WHERE ID=
UPDATE #Request.prefix_db_agency#.Teaching_Skills SET
Explanation = ,
Created_Date = ,
Created_by = ,
Updated_Date = ,
Updated_by =
WHERE ID=
SELECT * FROM #Request.prefix_db_agency#.Teaching_Skills WHERE ID=
UPDATE
#Request.prefix_db_agency#.Teaching_Skills
SET
Teaching_Skills.Deleted = '#1#'
WHERE
Diagnosis_ID=
AND Patient_ID=
AND Assessment_ID=
AND Pathway_ID=
UPDATE #Request.prefix_db_agency#.Teaching_Skills set Teaching_Skills.Deleted = '#1#'
WHERE ID=
SELECT * FROM #Request.prefix_db_lookup#.Dx_list_Procedures_Diet WHERE ID=
SELECT * FROM #Request.prefix_db_agency#.Assessment_New WHERE Assessment_ID=
SELECT * FROM #Request.prefix_db_agency#.Diagnosis WHERE Patient_ID= AND Assessment_ID= AND Assessment_Tracker_ID= AND ICD= AND Disabled=0
SELECT MAX(Dx_Order) as diagnosis_order FROM #Request.prefix_db_agency#.Diagnosis WHERE Patient_ID= AND Assessment_ID= AND Disabled=0 AND Assessment_Tracker_ID=
INSERT INTO #Request.prefix_db_agency#.Diagnosis
(
Assessment_ID, Assessment_Tracker_ID, Patient_ID, Agency_ID, Diagnosis, ICD, Pathway_Type, Record_Creation_Date, Record_Created_By, Record_Mod_Date, Record_Mod_By, Dx_Order
)
VALUES
(
,
,
,
,
,
,
,
,
,
,
,
)
SELECT LAST_INSERT_ID() as diagnoses_id_agency
SELECT * FROM #Request.prefix_db_lookup#.vetted_190924 WHERE ICD=
AND Pathway IS NOT NULL GROUP BY Pathway
SELECT * FROM #Request.prefix_db_lookup#.Teaching_Prevention WHERE Pathway_ID=
INSERT INTO #Request.prefix_db_agency#.Teaching_Skills
(
Patient_ID, Assessment_ID, ICD, 3Digit, Pathway_Type, Pathway_ID, Step_ID, Line_ID, Explanation, Created_Date, Created_by, Updated_Date, Updated_by, Diagnosis_ID, Order_ID, Title_Order_ID
)
VALUES
(
,
,
,
,
,
,
,
,
,
,
,
,
,
,
,
)
UPDATE #Request.prefix_db_agency#.Teaching_Skills set Teaching_Skills.Order_ID = '#teachskills_order_count#'
WHERE ID=
SELECT * FROM #Request.prefix_db_agency#.Teaching_Skills WHERE ID=
UPDATE
#Request.prefix_db_agency#.Teaching_Skills
SET
Teaching_Skills.Title_Order_ID = '#teachskills_Title_order_count#'
WHERE
ID=
UPDATE
#Request.prefix_db_agency#.Teaching_Skills
SET
Teaching_Skills.Title_Order_ID = '#teachskills_Title_order_count#'
WHERE
Pathway_ID=
AND Patient_ID=
AND Assessment_ID=
AND ICD=
AND Deleted=0
AND Pathway_Type='Teaching'
AND Pathway_Type='symptom'
UPDATE #Request.prefix_db_agency#.Teaching_Skills
SET
Teaching_Skills.Order_ID = '#teachskills_order_count#'
WHERE
ID=
UPDATE #Request.prefix_db_agency#.Diagnosis set Diagnosis.Dx_Order = '#teach_Diagnosis_order_count#'
WHERE Diagnosis_ID=
SELECT * FROM #Request.prefix_db_agency#.Diagnosis WHERE Diagnosis_ID=
AND Diagnosis.Disabled = 0
SELECT max(Order_ID) as maximun_order FROM #Request.prefix_db_agency#.Teaching_Skills WHERE Diagnosis_ID= AND Patient_ID= AND Assessment_ID= AND ICD= AND Deleted=0
INSERT INTO #Request.prefix_db_agency#.Teaching_Skills
(
Patient_ID, Assessment_ID, ICD, 3Digit, Pathway_Type, Explanation, Created_Date, Created_by, Updated_Date, Updated_by, Diagnosis_ID, Order_ID
)
VALUES
(
,
,
,
,
,
,
,
,
,
,
,
)
SELECT * FROM #Request.prefix_db_agency#.Diagnosis WHERE Diagnosis_ID=
AND Diagnosis.Disabled = 0
SELECT max(Order_ID) as maximun_order FROM #Request.prefix_db_agency#.Teaching_Skills
WHERE
Diagnosis_ID=
AND Patient_ID=
AND Assessment_ID=
AND ICD=
AND Deleted=0
SELECT * FROM #Request.prefix_db_agency#.Teaching_Skills
WHERE
Diagnosis_ID=
AND Patient_ID=
AND Assessment_ID=
AND ICD=
AND Deleted=0
AND Pathway_ID= Pathway_ID IS NULL
AND Pathway_Type NOT LIKE 'goal%'
AND Pathway_Type NOT LIKE 'intervention%'
AND Pathway_Type NOT LIKE 'Source%'
ORDER BY Step_ID DESC LIMIT 1
INSERT INTO #Request.prefix_db_agency#.Teaching_Skills
(
Patient_ID, Assessment_ID, ICD, 3Digit, Pathway_Type, Pathway_ID, Step_ID, Line_ID, Explanation, Created_Date, Created_by, Updated_Date, Updated_by, Diagnosis_ID, Order_ID
)
VALUES
(
,
,
,
,
,
,
,
,
,
,
,
,
,
,
)
SELECT * FROM #Request.prefix_db_agency#.Diagnosis WHERE Diagnosis_ID=
AND Diagnosis.Disabled = 0
SELECT * FROM #Request.prefix_db_agency#.Teaching_Skills
WHERE Diagnosis_ID=
AND Patient_ID=
AND Assessment_ID=
AND ICD=
AND Deleted=0
SELECT * FROM #Request.prefix_db_agency#.Teaching_Library WHERE ICD= AND Deleted=0
UPDATE #Request.prefix_db_agency#.Teaching_Library set Explanation = '#Skill_diagnisis_name#'
WHERE ID=
ArrayDelete(Skill_data_ids,#Get_Library_ICD.Teaching_Skills_ID#);
SELECT * FROM #Request.prefix_db_agency#.Teaching_Skills WHERE ID=
INSERT INTO #Request.prefix_db_agency#.Teaching_Library
(
ICD, Three_Digit, Pathway_Type, Pathway_ID, Step_ID, Line_ID, Explanation, Created_Date, Created_by, Updated_Date, Updated_by, Teaching_Skills_ID, Diagnosis_ID ,title, Title_Order_ID , Order_ID
)
VALUES
(
,
,
,
,
,
,
,
,
,
,
,
,
,
,
,
)
SELECT * FROM #Request.prefix_db_lookup#.pathway_list
WHERE Pathway_ID =
INSERT INTO #Request.prefix_db_agency#.Teaching_Library
(
ICD, Three_Digit, Pathway_Type, Pathway_ID, Step_ID, Line_ID, Explanation, Created_Date, Created_by, Updated_Date, Updated_by, Teaching_Skills_ID, Diagnosis_ID ,title , Title_Order_ID , Order_ID
)
VALUES
(
,
,
,
,
,
,
,
,
,
,
,
,
,
,
,
)
SELECT * FROM #Request.prefix_db_agency#.Teaching_Library WHERE title=
SELECT * FROM #Request.prefix_db_agency#.Assessment_New WHERE Assessment_ID=
SELECT * FROM #Request.prefix_db_agency#.Diagnosis WHERE Diagnosis_ID=
AND Diagnosis.Disabled = 0
SELECT MAX(Dx_Order) as diagnosis_order FROM #Request.prefix_db_agency#.Diagnosis WHERE Patient_ID= AND Assessment_ID= AND Disabled=0 AND Assessment_Tracker_ID=
AND Diagnosis.Disabled = 0
SELECT * FROM #Request.prefix_db_agency#.Teaching_Skills WHERE Patient_ID= AND Assessment_ID= AND ICD= AND Deleted=0
INSERT INTO #Request.prefix_db_agency#.Diagnosis
(
Assessment_ID, Assessment_Tracker_ID, Patient_ID, Agency_ID, Diagnosis, ICD, Short_Diagnosis, Pathway_Type, Record_Creation_Date, Record_Created_By, Record_Mod_Date, Record_Mod_By, Dx_Order, Primary_Diagnosis , PDGM_Comorbidity PDGM_Primary, PDGM_Subchapter
)
VALUES
(
,
,
,
,
,
,
,
,
,
,
,
,
,
,
,
)
select LAST_INSERT_ID() as diagnoses_id_agency
INSERT INTO #Request.prefix_db_agency#.Teaching_Skills
(
Patient_ID, Assessment_ID, ICD, 3Digit, Pathway_Type, Pathway_ID, Step_ID, Line_ID, Explanation, Created_Date, Created_by, Updated_Date, Updated_by, Diagnosis_ID, Order_ID , Title_Order_ID
)
VALUES
(
,
,
,
,
,
,
,
,
,
,
,
,
,
,
,
)
SELECT * FROM #Request.prefix_db_lookup#.pathway_list WHERE Deleted=0 GROUP BY Pathway_ID
SELECT * FROM #Request.prefix_db_lookup#.pathway_list
WHERE Pathway_ID= AND Deleted=0
SELECT * FROM #Request.prefix_db_lookup#.SuperUsers WHERE User_ID=
SELECT * FROM #Request.prefix_db_lookup#.SuperUsers WHERE User_ID=
SELECT * FROM #Request.prefix_db_lookup#.pathway_list WHERE id=
SELECT * FROM #Request.prefix_db_lookup#.pathway_list WHERE id=
SELECT * FROM #Request.prefix_db_lookup#.pathway_list WHERE Pathway_ID= AND Deleted=0 LIMIT 1
SELECT MAX(Order_Calc) as Max_Order_Calc FROM #Request.prefix_db_lookup#.pathway_list
UPDATE
#Request.prefix_db_lookup#.pathway_list
SET
Pathway_ID = ,
Type = ,
Description = ,
Mobile_Desc = ,
M0_Answer = ,
Skill = ,
CopyIntoProgressNote = ,
Order_Calc = ,
Created_Date = ,
Created_by = ,
Updated_Date = ,
Updated_by =
WHERE
id =
UPDATE
#Request.prefix_db_lookup#.pathway_list
SET
Deleted = '#1#'
WHERE
id=
UPDATE
#Request.prefix_db_lookup#.pathway_list
SET
Deleted = '#1#'
WHERE
Pathway_ID=
SELECT * FROM #Request.prefix_db_lookup#.pathway_list WHERE Pathway_ID= AND Deleted=0 GROUP BY Pathway_ID
SELECT * FROM #Request.prefix_db_lookup#.pathway_list WHERE Pathway_ID= AND Deleted=0
UPDATE
#Request.prefix_db_lookup#.pathway_list
SET
M0_Answer = ,
Created_Date = ,
Created_by = ,
Updated_Date = ,
Updated_by =
WHERE
id =
SELECT * FROM #Request.prefix_db_lookup#.pathway_list WHERE Pathway_ID= AND Deleted=0 LIMIT 1
SELECT MAX(Item_ID) as Max_Item_ID FROM #Request.prefix_db_lookup#.pathway_list
SELECT MAX(Order_Calc) as Max_Order_Calc FROM #Request.prefix_db_lookup#.pathway_list
INSERT INTO #Request.prefix_db_lookup#.pathway_list
(
CopyIntoProgressNote, Description, M0_Answer, Item_ID, Order_Calc, Pathway_ID, Skill, Type, Mobile_Desc, Created_Date, Created_by, Updated_Date, Updated_by
)
VALUES
(
,
,
,
,
,
,
,
,
,
,
,
,
)
SELECT * FROM #Request.prefix_db_lookup#.pathway_list WHERE Pathway_ID= AND Deleted=0 GROUP BY Pathway_ID
SELECT * FROM #Request.prefix_db_agency#.Teaching_Library WHERE Deleted=0 GROUP BY ICD ORDER BY Library_List_Order ASC
SELECT * FROM #Request.prefix_db_agency#.Teaching_Library
WHERE
Three_Digit=
AND Deleted=0
AND Pathway_Type NOT LIKE 'goal%'
AND Pathway_Type NOT LIKE 'intervention%'
AND Pathway_Type NOT LIKE 'Source%'
GROUP BY Pathway_ID ORDER BY Title_Order_ID ASC
SELECT * FROM #Request.prefix_db_agency#.Teaching_Library
WHERE
Three_Digit=
AND Deleted=0
AND Pathway_Type NOT LIKE 'goal%'
AND Pathway_Type NOT LIKE 'intervention%'
AND Pathway_Type NOT LIKE 'Source%'
AND Pathway_ID = '#get_Pathwaylist_data.Pathway_ID#' Pathway_ID IS NULL
ORDER BY Order_ID ASC
SELECT * FROM #Request.prefix_db_agency#.Teaching_Library WHERE Three_Digit= AND Deleted=0 GROUP BY title
SELECT * FROM #Request.prefix_db_agency#.Teaching_Library WHERE Three_Digit= AND Deleted=0
UPDATE
#Request.prefix_db_agency#.Teaching_Library
SET
title = ,
Created_Date = ,
Created_by = ,
Updated_Date = ,
Updated_by =
WHERE
ID =
UPDATE
#Request.prefix_db_agency#.Teaching_Library
SET
Deleted = '#1#'
WHERE
Three_Digit=
SELECT * FROM #Request.prefix_db_agency#.Teaching_Library WHERE ID=
SELECT * FROM #Request.prefix_db_agency#.Teaching_Library WHERE ID=
UPDATE
#Request.prefix_db_agency#.Teaching_Library
SET
Explanation = ,
Created_Date = ,
Created_by = ,
Updated_Date = ,
Updated_by =
WHERE ID= .
SELECT * FROM #Request.prefix_db_agency#.Teaching_Library WHERE ID=
UPDATE
#Request.prefix_db_agency#.Teaching_Library
SET
Deleted = '#1#'
WHERE
Three_Digit=
AND Pathway_ID=
UPDATE
#Request.prefix_db_agency#.Teaching_Library
SET
Deleted = '#1#'
WHERE
ID=
SELECT * FROM #Request.prefix_db_agency#.Teaching_Library WHERE ID=
SELECT
max(Order_ID) as maximun_order
FROM
#Request.prefix_db_agency#.Teaching_Library
WHERE
Three_Digit=
AND Pathway_ID=
AND Deleted=0
SELECT *
FROM
#Request.prefix_db_agency#.Teaching_Library
WHERE
Three_Digit=
AND Deleted=0
AND Pathway_ID= Pathway_ID IS NULL
AND Pathway_Type NOT LIKE 'Title%'
AND Pathway_Type NOT LIKE 'goal%'
AND Pathway_Type NOT LIKE 'intervention%'
AND Pathway_Type NOT LIKE 'Source%' ORDER BY Step_ID DESC LIMIT 1
INSERT INTO #Request.prefix_db_agency#.Teaching_Library
(
ICD, Three_Digit, Pathway_Type, Pathway_ID, Step_ID, Line_ID, Explanation, Created_Date, Created_by, Updated_Date, Updated_by, Diagnosis_ID, Order_ID, title
)
VALUES
(
,
,
,
,
,
,
,
,
,
,
,
,
,
)
UPDATE
#Request.prefix_db_agency#.Teaching_Library
SET
Library_List_Order = '#teach_Library_order_count#'
WHERE
Three_Digit=
SELECT * FROM #Request.prefix_db_agency#.Teaching_Library WHERE ID=
UPDATE
#Request.prefix_db_agency#.Teaching_Library
SET
Title_Order_ID = '#teachskills_Title_order_count#'
WHERE
Pathway_ID=
AND ICD=
AND Deleted=0
UPDATE
#Request.prefix_db_agency#.Teaching_Library
SET
Order_ID = '#teachskills_order_count#'
WHERE
ID=
SELECT * FROM #Request.prefix_db_agency#.Teaching_Library WHERE Three_Digit= AND Deleted=0 GROUP BY Three_Digit
SELECT * FROM #Request.prefix_db_agency#.Diagnosis
WHERE Patient_ID =
AND Assessment_ID =
AND ICD =
AND Disabled = 0
SELECT ts.ID, ts.ICD,ts.Explanation,ts.Step_ID,ts.Line_ID,ts.Diagnosis_ID,ts.Pathway_Type,ts.Order_ID,ts.Pathway_ID,(SELECT type FROM #Request.prefix_db_lookup#.#teach_prev# as tp WHERE tp.Pathway_ID = ts.Pathway_ID AND tp.Type = 'Title' ) as title_type
FROM
#Request.prefix_db_agency#.#teach_sk# as ts
WHERE ts.Diagnosis_ID=
AND ts.Patient_ID=
AND ts.Assessment_ID=
AND ts.ICD=
AND ts.Deleted=0
AND ts.Pathway_Type NOT LIKE 'goal%'
AND ts.Pathway_Type NOT LIKE 'intervention%'
AND ts.Pathway_Type NOT LIKE 'Source%'
AND ts.Title_Order_ID IS NOT NULL
AND ts.Pathway_Type <> 'Title'
AND ts.Pathway_ID <> 0
GROUP BY ts.Pathway_Type
ORDER BY ts.Pathway_Type ASC
SELECT * FROM #Request.prefix_db_agency#.Teaching_Library
WHERE
Three_Digit=
AND Deleted=0
AND Pathway_Type NOT LIKE 'goal%'
AND Pathway_Type NOT LIKE 'intervention%'
AND Pathway_Type NOT LIKE 'Source%'
GROUP BY Pathway_ID ORDER BY Title_Order_ID ASC
SELECT * FROM #Request.prefix_db_agency#.Coding_Scrub
WHERE Patient_ID =
AND Assessment_ID = AND Coding_Scrub.Risk = 'SN'
AND Coding_Scrub.Risk = 'OT'
AND Coding_Scrub.Risk = 'PT'
-- AND Message_ID = 76
ORDER BY Message_ID ASC
SELECT * FROM #Request.prefix_db_agency#.Coding_Results
WHERE Patient_ID =
AND Message_ID =