SELECT * FROM #Request.prefix_db_agency#.pAssessments
LEFT OUTER JOIN #Request.prefix_db_agency#.pPatients ON pAssessments.Patient_ID = pPatients.Patient_ID
WHERE pPatients.Loc_ID =
AND pAssessments.Patient_ID =
AND pAssessments.Assmt_ID =
AND pAssessments.status = 0
AND pPatients.status = 0
SELECT * FROM #Request.prefix_db_lookup#.assessment_questions_lookup as ques
JOIN #Request.prefix_db_lookup#.assessment_answers_lookup as answ ON answ.question_id = ques.ques_id
WHERE ques.Deleted <> 1
AND answ.Deleted <> 1
AND ques.assessment_reason =
AND ques.assessment_reason = answ.assessment_reason
AND (ques.wizard = OR ques.wizard = )
ORDER BY ques.order_id,ques.wizard,answ.srt_id,ques.answer_label ASC
SELECT * FROM #Request.prefix_db_agency#.pAssessments
WHERE Assmt_ID =
AND Patient_ID =
SELECT * FROM #Request.prefix_db_lookup#.assessment_questions_lookup as ques
JOIN #Request.prefix_db_lookup#.assessment_answers_lookup as answ ON answ.question_id = ques.ques_id
WHERE ques.Deleted <> 1
AND answ.Deleted <> 1
AND (ques.wizard = OR ques.wizard = 0)
AND ques.assessment_reason =
AND ques.assessment_reason = answ.assessment_reason
ORDER BY ques.order_id ASC
SELECT * FROM #Request.prefix_db_agency#.pAssessments
WHERE Assmt_ID =
AND Patient_ID =
AND Status =
UPDATE #Request.prefix_db_agency#.pAssessments SET
#datalist[i]# =
#datalist[i]# = NULL
#datalist[i]# =
,Record_Mod_Date =
,Record_Mod_By =
WHERE Assmt_ID =
AND Patient_ID =
SELECT IFNULL(Max(Assmt_ID)+1,0) as Assmt_ID FROM #Request.prefix_db_agency#.pAssessments
SELECT * FROM #Request.prefix_db_agency#.pAdmit
WHERE Patient_ID =
AND status =
INSERT INTO #Request.prefix_db_agency#.pAssessments(
Assmt_ID,parent_id, #datalist[i]#,
Patient_ID,Loc_ID,Record_Creation_Date,Record_Created_By, Record_Mod_Date, Record_Mod_By
)
VALUES
(
,
,
,
,
,
,
,
,
,
)
SELECT MAX(Assmt_ID) as LastInsertID FROM #Request.prefix_db_agency#.pAssessments
SELECT * FROM #Request.prefix_db_agency#.pPatients
JOIN #Request.prefix_db_agency#.pAssessments ON pAssessments.Patient_ID = pPatients.Patient_ID
WHERE pPatients.Patient_ID =
AND pAssessments.Assmt_ID =
AND pPatients.Status =
INSERT INTO #Request.prefix_db_lookup#.Coding_Request (Agency_ID,Request_Date,Last_Name,First_Name,Assessment_Type,
Assessment_Date,Assigned_to,Coding_status,Assigned_by,Request_Time,MHCB_Entered,
time_requested,Updated_by)
VALUES ('#session.agencyid#','#DateFormat(now(),"yyyy-mm-dd")#',
'#GetP.Pt_Last#','#Getp.Pt_First#','#Getp.F26#',
'#DateFormat(Getp.F176,"yyyy-mm-dd")#','Melissa','H_P_Review',
'#session.employeeid#',
'#TimeFormat(now(), "short")#',#now()#,#now()#,'#Session.employeeid#')
INSERT INTO #Request.prefix_db_lookup#.Coding_Request (Agency_ID,Request_Date,Last_Name,First_Name,Assessment_Type,
Assessment_Date,Assigned_to,Coding_status,Assigned_by,Request_Time,MHCB_Entered,
time_requested,Updated_by)
VALUES ('#session.agencyid#','#DateFormat(now(),"yyyy-mm-dd")#',
'#GetP.Pt_Last#','#Getp.Pt_First#','#Getp.F26#',
'#DateFormat(Getp.F176,"yyyy-mm-dd")#','Melissa','Coding',
'#session.employeeid#',
'#TimeFormat(now(), "short")#',#now()#,#now()#,'#Session.employeeid#')
UPDATE #Request.prefix_db_agency#.pAssessments SET
#datalist[i]# = ,
#datalist[i]# = NULL,
#datalist[i]# = ,
#datalist[i]# = NULL,
F25 = ,
F263 = ,
Record_Mod_Date =
,Record_Mod_By =
WHERE Assmt_ID =
AND Patient_ID =
SELECT * FROM #Request.prefix_db_agency#.pAssessments
WHERE Assmt_ID =
AND status =
SELECT * FROM #Request.prefix_db_agency#.pAssessments
WHERE Admit_ID =
AND (F26 = )
AND status =
SELECT * FROM #Request.prefix_db_agency#.pAssessments
WHERE Assmt_ID =
AND Patient_ID =
AND status = 0
SELECT * FROM assessment_questions_lookup WHERE assessment_reason like '#getassess.F26#'
AND Deleted = 0
SELECT * FROM #Request.prefix_db_agency#.pAssessments
WHERE Assmt_ID =
AND status =
SELECT * FROM #Request.prefix_db_agency#.pAssessments
WHERE Assmt_ID =
AND Patient_ID =
SELECT * FROM #Request.prefix_db_agency#.pAssessments
WHERE Assmt_ID =
AND status =
SELECT pProblem.*,IFNULL(MAX(pProblem.dx_order),0)+1 AS dxordernumber FROM #Request.prefix_db_agency#.pProblem
WHERE pProblem.Assmt_ID =
AND pProblem.status =
AND (M0_No like 'M1021%' OR M0_No like 'M1023%')
ORDER BY RIGHT(M0_No, 1) ASC
SELECT * FROM getprobs WHERE M0_No like
SELECT vt.id as id,vt.Diagnosis,vt.ICD as ICD,'ICD' as Code_Type,cw.Default as Pathway_Type,IFNULL(vt.Pathway,0) AS Pathwaysid,vt.Diagnosis_Short as Short_Diagnosis, vt.Comorbid as Other_DG,vt.PDGM,vt.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.ID =
SELECT pProblem.* FROM #Request.prefix_db_agency#.pProblem
WHERE pProblem.Assmt_ID =
AND pProblem.Description =
UPDATE #Request.prefix_db_agency#.pProblem
SET status = ,
Change_by = ,
Date_Change =
WHERE Assmt_ID =
AND M0_No =
AND Path_ID =
AND Status != 2
SELECT * FROM getprob WHERE Status =
INSERT INTO #Request.prefix_db_agency#.pProblem
(
Problem_ID, Assmt_ID, Status, Path_ID,Skill, M0_No, Description, Answer, Severity, dx_order,Coding_Status,Careplan,Notes, Date_Create, Created_by, Date_Change, Change_by
)
VALUES
(
,
,
,
,
,
,
,
,
,
,
,
,
,
,
,
,
)
SELECT IFNULL(MAX(Problem_ID),0)+1 As pProblem_ID FROM #Request.prefix_db_agency#.pProblem
INSERT INTO #Request.prefix_db_agency#.pProblem
(
Problem_ID, Assmt_ID, Status, Path_ID,Skill, M0_No, Description, Answer, Severity,dx_order,Coding_Status, Careplan, Notes, Date_Create, Created_by, Date_Change, Change_by
)
VALUES
(
,
,
,
,
,
,
,
,
,
,
,
,
,
,
,
,
)
SELECT pProblem.* FROM #Request.prefix_db_agency#.pProblem
WHERE pProblem.Assmt_ID =
AND Skill =
AND Status =
ORDER BY RIGHT(M0_No, 1) ASC
UPDATE #Request.prefix_db_agency#.pProblem
SET status = ,
Date_Change = ,
Change_by =
WHERE Assmt_ID =
AND AutoProblem_ID IN ()
SELECT pProblem.* FROM #Request.prefix_db_agency#.pProblem
WHERE pProblem.Assmt_ID =
AND Skill =
AND Status =
ORDER BY RIGHT(M0_No, 1) ASC
SELECT pProblem.* FROM #Request.prefix_db_agency#.pProblem
WHERE pProblem.AutoProblem_ID =
UPDATE #Request.prefix_db_agency#.pProblem
SET status = ,
Date_Change = ,
Change_by =
WHERE Problem_ID =
SELECT * FROM #Request.prefix_db_lookup#.vetted_190924
WHERE Diagnosis =
INSERT INTO #Request.prefix_db_agency#.pProblem
(
Problem_ID, Assmt_ID, Status, Careplan, Path_ID, Skill, ques_id, M0_No, Description, Answer, Severity, dx_order, Coding_Status, Specific_Orders, Resolved_Date,Assign, Notes, Date_Create, Created_by, Date_Change, Change_by
)
SELECT Problem_ID, Assmt_ID, 0 , '#arguments.Careplan#', Path_ID, '#arguments.Skill#', ques_id, '#M0_No#', Description, '#arguments.Answer#', '#Left(arguments.Answer,1)#', '#arguments.Dx_Order#', "#arguments.Coding_Status#"
Coding_Status , Specific_Orders, Resolved_Date, Assign , Notes,#now()# , #session.employeeid# , #now()#, #session.employeeid#
FROM #Request.prefix_db_agency#.pProblem
WHERE AutoProblem_ID =
SELECT MAX(AutoProblem_ID) as LastInsertID FROM #Request.prefix_db_agency#.pProblem
SELECT pProblem.* FROM #Request.prefix_db_agency#.pProblem
WHERE pProblem.AutoProblem_ID =
UPDATE #Request.prefix_db_agency#.pProblem
SET status = ,
Date_Change = ,
Change_by =
WHERE AutoProblem_ID =
INSERT INTO #Request.prefix_db_agency#.pProblem
(
Problem_ID, Assmt_ID, Status, Careplan, Path_ID, Skill, ques_id, M0_No, Description, Answer, Severity, dx_order, Coding_Status, Specific_Orders, Resolved_Date, Assign, Notes, Date_Create, Created_by, Date_Change, Change_by
)
SELECT Problem_ID, Assmt_ID, 0 , Careplan, Path_ID, Skill, ques_id, M0_No, Description, Answer, Severity, dx_order, Coding_Status, Specific_Orders, Resolved_Date, '#arguments.Assign#' , '#arguments.Notes# ',#now()# , #session.employeeid# , #now()#, #session.employeeid#
FROM #Request.prefix_db_agency#.pProblem
WHERE AutoProblem_ID =
SELECT * FROM #Request.prefix_db_agency#.pProblem
WHERE AutoProblem_ID =
AND Assmt_ID =
SELECT * FROM #Request.prefix_db_agency#.pCareplan
WHERE AutoCareplan_ID =
SELECT pPathway.* FROM #Request.prefix_db_lookup#.pPathway
JOIN #Request.prefix_db_agency#.pCareplan ON pPathway.Item_ID = pCareplan.Item_ID
WHERE AutoCareplan_ID =
AND pPathway.Type =
GROUP BY Pathway_ID
SELECT pProblem.* FROM #Request.prefix_db_lookup#.pPathway
JOIN #Request.prefix_db_agency#.pProgress ON pPathway.Item_ID = pProgress.Item_ID
JOIN #Request.prefix_db_agency#.pProblem ON pProblem.Path_ID = pPathway.Pathway_ID
WHERE pProgress.Item_ID =
AND pPathway.Type =
AND pProgress.Status =
AND pProblem.Status =
AND pProblem.Path_ID != 0
AND pProblem.Assmt_ID =
GROUP BY pProblem.Problem_ID
ORDER BY pProblem.dx_order ASC
SELECT pProblem.* FROM #Request.prefix_db_lookup#.pPathway
JOIN #Request.prefix_db_agency#.pCareplan ON pPathway.Item_ID = pCareplan.Item_ID
JOIN #Request.prefix_db_agency#.pProblem ON pProblem.Path_ID = pPathway.Pathway_ID
WHERE AutoCareplan_ID =
AND pPathway.Type =
AND pCareplan.Status =
AND pProblem.Status =
AND pProblem.Path_ID != 0
AND pProblem.Assmt_ID = pCareplan.Assmt_ID
GROUP BY pProblem.Problem_ID
ORDER BY pProblem.dx_order ASC
#Description#
SELECT * FROM #Request.prefix_db_agency#.pCareplan
WHERE Assmt_ID =
AND Skill =
AND type =
AND status = 0
AND Date_Resolve IS NULL
SELECT * FROM #Request.prefix_db_agency#.pSched_Procedure
WHERE Assmt_ID =
AND Schedule_ID =
AND status = 0
UPDATE #Request.prefix_db_agency#.pSched_Procedure
SET status = ,
Date_Change = ,
Change_by =
WHERE Schedule_ID IN ()
INSERT INTO #Request.prefix_db_agency#.pSched_Procedure
(
Status, Assmt_ID, Schedule_ID, Careplan_ID, Notes, Date_Create, Created_by, Date_Change, Change_by
)
SELECT 0 , Assmt_ID, #Schedule_ID#, Careplan_ID, Notes ,#now()# , #session.employeeid# , #now()#, #session.employeeid#
FROM #Request.prefix_db_agency#.pCareplan
WHERE Careplan_ID IN ()
AND status = 0
UPDATE #Request.prefix_db_agency#.pSched_Procedure
SET Notes =
WHERE Careplan_ID =
UPDATE #Request.prefix_db_agency#.pCareplan
SET Specifics = ,
Status = ,
Notes = ,
Date_Resolve = ,
Date_Change = ,
Change_by =
WHERE AutoCareplan_ID =
SELECT * FROM #Request.prefix_db_agency#.pCareplan
WHERE AutoCareplan_ID =
INSERT INTO #Request.prefix_db_agency#.pCareplan
(
Careplan_ID, Assmt_ID, Item_ID, Order_ID, Incrmt1,CMSOrder_ID, Status, Skill, Type, Description, Other, Notes, Param_Lo, Param_Hi, Param_Other, Specifics, Date_Target, Date_Resolve, Order_Date, Date_Create, Created_by, Date_Change, Change_by
)
VALUES
(
,
,
,
,
,,
,
,
,
,
,
,
,
,
,
,
,
,
,
,
,
,
)
UPDATE #Request.prefix_db_agency#.pCMS4857
SET status = ,
Date_Change = ,
Change_by =
WHERE Order_ID =
UPDATE #Request.prefix_db_agency#.pProblem SET CMSOrder_ID = 0
WHERE CMSOrder_ID =
UPDATE #Request.prefix_db_agency#.pCareplan SET CMSOrder_ID = 0
WHERE CMSOrder_ID =
UPDATE #Request.prefix_db_agency#.pPtmeds SET CMSOrder_ID = 0
WHERE CMSOrder_ID =
UPDATE #Request.prefix_db_agency#.pWoundsVitals SET CMSOrder_ID = 0
WHERE CMSOrder_ID =
UPDATE #Request.prefix_db_agency#.pSchedules
SET status = ,
Date_Change = ,
Change_by =
WHERE Schedule_ID =
UPDATE #Request.prefix_db_agency#.pAssessments
SET status = ,
Record_Mod_Date = ,
Record_Mod_By =
WHERE Assmt_ID =
AND status =
INSERT INTO #Request.prefix_db_agency#.pProblem
(
Problem_ID, Assmt_ID, Status, Careplan, Path_ID, Skill, ques_id, M0_No, Description, Answer, Severity, dx_order, Coding_Status, Specific_Orders, Resolved_Date, Assign, Notes, Date_Create, Created_by, Date_Change, Change_by
)
SELECT Problem_ID, Assmt_ID, 0 , Careplan, Path_ID, Skill, ques_id, M0_No, Description, Answer, Severity, dx_order, Coding_Status, Specific_Orders, Resolved_Date, Assign, Notes,#now()# , #session.employeeid# , #now()#, #session.employeeid#
FROM #Request.prefix_db_agency#.pProblem
WHERE pProblem.Problem_ID IN ()
AND Status = 0
SELECT * FROM #Request.prefix_db_agency#.pProblem
WHERE Assmt_ID =
AND status =
AND Skill =
SELECT * FROM #Request.prefix_db_agency#.pAssessments
WHERE Assmt_ID =
AND status = 0
SELECT * FROM #Request.prefix_db_agency#.pOASIS_QA
WHERE Assmt_ID =
AND QA_Type =
AND Resolved = 2
UPDATE #Request.prefix_db_agency#.pOASIS_QA
SET Resolved =
WHERE Assmt_ID =
AND QA_Type =
AND Resolved = 2
UPDATE #Request.prefix_db_agency#.pOASIS_QA
SET Resolved =
WHERE QA_ID =
SELECT * FROM #Request.prefix_db_agency#.pOASIS_QA
WHERE QA_ID =
SELECT * FROM #Request.prefix_db_agency#.pAssessments
WHERE Admit_ID =
AND F26 IN (SELECT assessment_reason FROM Assmt_Update
WHERE question_label = '#getpOASIS.Questions_label#')
UPDATE #Request.prefix_db_agency#.pAssessments
SET #getpOASIS.QA_answerlabel# =
WHERE Assmt_ID =
AND status = 0
UPDATE #Request.prefix_db_agency#.pProblem
SET Answer = ,
Skill = ,
Date_Change = ,
Change_by =
WHERE ques_id IN
(SELECT ques_id FROM #Request.prefix_db_lookup#.assessment_questions_lookup
WHERE assessment_reason =
AND answer_label =
AND deleted = 0
)
AND Assmt_ID =
AND status = 0
SELECT * FROM #Request.prefix_db_agency#.pOASIS_QA
WHERE Assmt_ID =
AND QA_Type =
AND Resolved = 2
UPDATE #Request.prefix_db_agency#.pAssessments
SET QA_count =
WHERE Assmt_ID =
AND status = 0
SELECT * FROM #Request.prefix_db_agency#.pAssessments
WHERE Assmt_ID =
AND status = 0
UPDATE #Request.prefix_db_agency#.pOASIS_QA
SET Resolved =
WHERE Assmt_ID =
AND QA_Type =
AND QA_ID =
SELECT * FROM #Request.prefix_db_agency#.pOASIS_QA
WHERE QA_ID IN ()
SELECT * FROM #Request.prefix_db_agency#.pAssessments
WHERE Admit_ID =
AND F26 IN (SELECT assessment_reason FROM Assmt_Update
WHERE question_label = '#getpOASIS.Questions_label#')
UPDATE #Request.prefix_db_agency#.pAssessments
SET #getpOASIS.QA_answerlabel# =
WHERE Assmt_ID =
AND status = 0
UPDATE #Request.prefix_db_agency#.pProblem
SET Answer = ,
Skill = ,
Date_Change = ,
Change_by =
WHERE ques_id IN
(SELECT ques_id FROM #Request.prefix_db_lookup#.assessment_questions_lookup
WHERE assessment_reason =
AND answer_label =
AND deleted = 0
)
AND Assmt_ID =
AND status = 0
SELECT * FROM #Request.prefix_db_agency#.pOASIS_QA
WHERE Assmt_ID =
AND QA_Type =
AND Resolved = 2
UPDATE #Request.prefix_db_agency#.pAssessments SET
Submitter_ID = ,
F292 = ,
F290 = ,
F291 = ,
F293 = ,
F200 = ,
F199 = ,
Record_Mod_Date = ,
Record_Mod_By =
WHERE Assmt_ID =
UPDATE #Request.prefix_db_agency#.pAssessments SET
F24 = ,
Record_Mod_Date = ,
Record_Mod_By =
WHERE Assmt_ID =
INSERT INTO #Request.prefix_db_agency#.pWoundsVitals (Assmt_ID, Status,
VitalOrWound, Description, Location, Length, Width, Depth,Date_Create,Created_by,
Date_Change,Change_by)
VALUES
(,
,
,
,
,
,
,
,
,
,
,
)
UPDATE #Request.prefix_db_agency#.pWoundsVitals SET
Status = ,
Date_Change = ,
Change_by =
WHERE ID =
UPDATE #Request.prefix_db_agency#.pCMS4857 SET
Form_Status = ,
Date_Change = ,
Change_by =
WHERE Order_ID =