SELECT * FROM #Request.prefix_db_agency#.pAssessments
LEFT OUTER JOIN #Request.prefix_db_agency#.pPatients ON pAssessments.Patient_ID = pPatients.Patient_ID
LEFT OUTER JOIN #Request.prefix_db_agency#.pAdmit ON pAssessments.Admit_ID = pAdmit.Admit_ID AND pAdmit.status = 0
WHERE pPatients.Loc_ID =
AND pAssessments.Patient_ID =
AND pAssessments.Assmt_ID =
AND pAssessments.status = 0
AND pPatients.status IN (0,1,4)
GROUP BY pAssessments.Assmt_ID
ORDER BY pAdmit.M0030_START_CARE_DT DESC
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 = 0
AND answ.Deleted = 0
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 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 = 0
AND answ.Deleted = 0
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 =
,F181 =
,Record_Mod_By =
WHERE Assmt_ID =
AND Patient_ID =
AND status = 0
SELECT * FROM #Request.prefix_db_agency#.pAssessments
WHERE Assmt_ID =
AND Patient_ID =
AND Status =
SELECT * FROM #Request.prefix_db_agency#.pAssessments
WHERE Assmt_ID =
AND Patient_ID =
AND Status =
UPDATE #Request.prefix_db_agency#.pAdmit_Svcs
SET
Start_Date = ,
Date_Change = ,
Change_by =
WHERE Assmt_ID =
SELECT IFNULL(Max(Assmt_ID),0)+1 as Assmt_ID FROM #Request.prefix_db_agency#.pAssessments
WHERE Status = 0
SELECT 1 as Assmt_ID
SELECT * FROM #Request.prefix_db_agency#.pAdmit
WHERE Patient_ID =
AND status =
SELECT * FROM #Request.prefix_db_agency#.pAssessments
WHERE Patient_ID =
AND status =
AND Admit_ID =
AND LEFT(F26,1) IN ('1','4')
AND status = 0
ORDER BY F178 DESC
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
(
,
,
,
NULL,
,
,
,
,
,
,
)
SELECT MAX(Assmt_ID) as LastInsertID FROM #Request.prefix_db_agency#.pAssessments
SELECT F251, F252, F253, F254, F256, F259
FROM #Request.prefix_db_agency#.pAssessments
WHERE Patient_ID =
AND Admit_ID =
AND status =
AND F26 =
ORDER BY F177 DESC
LIMIT 1
UPDATE #Request.prefix_db_agency#.pAssessments SET
F251 = ,
F252 = ,
F253 = ,
F254 = ,
F256 = ,
F259 = ,
Record_Mod_Date = ,
Record_Mod_By =
WHERE Assmt_ID =
AND status = 0
SELECT COUNT(*) AS pathwayMatchCount
FROM #Request.prefix_db_agency#.pWoundsVitals
WHERE Status =
AND VitalOrWound =
AND Pathway_ID IN ()
AND Assmt_ID IN (
SELECT Assmt_ID FROM #Request.prefix_db_agency#.pAssessments
WHERE Admit_ID =
AND status =
)
UPDATE #Request.prefix_db_agency#.pAssessments SET
F58 = ,
Record_Mod_Date = ,
Record_Mod_By =
WHERE Assmt_ID =
AND status = 0
UPDATE #Request.prefix_db_agency#.pAssessments
SET status = ,
Record_Mod_Date = ,
Record_Mod_By =
WHERE Assmt_ID =
SELECT * FROM #Request.prefix_db_agency#.pCareplan
WHERE Status <
AND Assmt_ID =
ORDER BY Careplan_ID ASC
UPDATE #Request.prefix_db_agency#.pAssessments
SET
F34 = '#getoldassessment.F34#',
F72 = '#getoldassessment.F72#',
F322 = '#getoldassessment.F322#'
WHERE Status = 0
AND Assmt_ID =
SELECT * FROM #Request.prefix_db_agency#.pAssessments
WHERE Status =
AND Assmt_ID =
SELECT IFNULL(MAX(Careplan_ID),0)+1 As pCareplan_ID FROM #Request.prefix_db_agency#.pCareplan
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, Proc_QA
)
VALUES
(
,
,
,
,
,,
,
,
,
,
,
,
,
,
,
,
,
,
,
,
,
,
,
)
SELECT DISTINCT
pp.Description AS progress_description,
pp.Item_ID,
pp.Assmt_ID AS source_assmt_id,
aql.Item_ID AS lookup_item_id,
aql.assessment_reason,
aql.question_id,
aql.answer_label,
aq.ques_id,
aq.answer_label AS field_name
FROM #Request.prefix_db_agency#.pProgress pp
INNER JOIN #Request.prefix_db_agency#.pAssessments pa ON pa.Assmt_ID = pp.Assmt_ID
AND pa.Patient_ID =
AND pa.Admit_ID =
AND pa.status = 0
INNER JOIN #Request.prefix_db_lookup#.assessment_answers_lookup aql ON aql.Item_ID = pp.Item_ID
AND aql.assessment_reason LIKE
INNER JOIN #Request.prefix_db_lookup#.assessment_questions_lookup aq ON aq.ques_id = aql.question_id
AND aq.answer_label IS NOT NULL
AND aq.answer_label != ''
WHERE pp.status = 0
AND pp.severity > 1
ORDER BY pa.F176 DESC
UPDATE #Request.prefix_db_agency#.pAssessments
SET #field_name# = ,
Record_Mod_Date = ,
Record_Mod_By =
WHERE Assmt_ID =
AND status = 0
SELECT pPatients.*,pAssessments.*,
CASE WHEN F26 = '1 - Start of care - further visits planned' AND F27 = 'SN' THEN '1 - SOC - SN'
WHEN F26 = '1 - Start of care - further visits planned - Physical Therapy' AND F27 = 'PT' THEN '1 - SOC - PT'
WHEN F26 = '1 - Start of care - further visits planned - Occupational Therapy' AND F27 = 'OT' THEN '1 - SOC - OT'
WHEN F26 = '3 - Resumption of care (after inpatient stay)' AND F27 = 'SN' THEN '3 - ROC - SN'
WHEN F26 = '3 - Resumption of care (after inpatient stay)' AND F27 = 'PT' THEN '3 - ROC - PT'
WHEN F26 = '4 - Recertification (follow-up) reassessment' AND F27 = 'SN' THEN '4 - Recertification SN'
WHEN F26 = '4 - Recertification (follow-up) reassessment - PT' AND F27 = 'PT' THEN '4 - Recertification PT'
WHEN F26 = '4 - Recertification (follow-up) reassessment - OT' AND F27 = 'OT' THEN '4 - Recertification OT'
WHEN F26 = 'PT Adult Evaluation' AND F27 = 'PT' THEN 'PT Eval'
WHEN F26 = 'OT Adult Evaluation' AND F27 = 'OT' THEN 'OT Eval'
WHEN F26 = 'ST Adult Evaluation' AND F27 = 'ST' THEN 'ST Eval'
WHEN F26 = 'SN Adult Evaluation' AND F27 = 'SN' THEN 'SN Eval'
WHEN F26 = 'MSW Evaluation' AND F27 = 'MSW' THEN 'MSW Eval'
WHEN F26 = 'Hospice Comprehensive' AND F27 = 'SN' THEN 'Hospice Comprehensive'
ELSE '0'
END AS Admit_skill
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 NOT IN (2,3)
AND pAssessments.status = 0
INSERT INTO #Request.prefix_db_agency#.pAdmit_Svcs
(
Admit_ID,Patient_ID,Assmt_ID, Status, Skill,
Start_Date,
Physician_order, Notes, Admitted,
Date_Create, Created_by, Date_Change, Change_by
)
VALUES
(
'#Getpats.Admit_ID#' ,'#Getpats.Patient_ID#','#Getpats.Assmt_ID#',0, '#Getpats.Admit_skill#',
'#DateFormat(svcStartDate,"yyyy-mm-dd")#',
'yes','','yes',
#now()# , #session.employeeid# , #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")#',
'#Getpats.Pt_Last#','#Getpats.Pt_First#','#Getpats.F26#',
'#DateFormat(Getpats.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")#',
'#Getpats.Pt_Last#','#Getpats.Pt_First#','#Getpats.F26#',
'#DateFormat(Getpats.F176,"yyyy-mm-dd")#','Melissa','#Coding_status#',
'#session.employeeid#',
'#TimeFormat(now(), "short")#',#now()#,#now()#,'#Session.employeeid#')
SELECT * FROM #Request.prefix_db_lookup#.Agency WHERE Agency_ID = '#session.agencyid#'
Hello Team,
We got a new coding request with below information
Agency Name : #gets_agency.Agency_Name# (#gets_agency.Agency_Login#)
Patient Name : #Getpats.Pt_First#,#Getpats.Pt_Last#
Requested Date: #DateFormat(now(),"yyyy-mm-dd")# - #TimeFormat(now(), "short")#
Assessment Type: #Getpats.F26# - #DateFormat(Getpats.F176,"yyyy-mm-dd")#
This is an automated system notification from MyHomeCareBiz.com. Therefore, there is no Unsubscribe option.
request.general = CreateObject("component","components.general.general").init();
getresult = request.general.SendMail(To="billing@myhomecarebiz.com,coding@myhomecarebiz.com",Subject="Notification for New Coding Request",Body="'#body_informations#'");
SELECT F26 FROM #Request.prefix_db_agency#.pAssessments
WHERE Assmt_ID =
AND Patient_ID =
AND status = 0
LIMIT 1
SELECT F25 FROM #Request.prefix_db_agency#.pAssessments
WHERE Assmt_ID =
AND Patient_ID =
AND status = 0
LIMIT 1
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 =
AND status = 0
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 =
UPDATE #Request.prefix_db_agency#.pAssessments SET
F101 = '09. Not applicable',
F102 = '09. Not applicable',
F103 = '09. Not applicable',
F104 = '09. Not applicable',
F105 = '09. Not applicable',
F106 = '09. Not applicable',
F131 = '0. No Skip to M1600',
F131 = '1. Yes Continue to GG0170R, Wheel 50 feet with two turns',
Record_Mod_Date =
WHERE Assmt_ID = '#getSOCS.Assmt_ID#' AND status = 0
SELECT * FROM #Request.prefix_db_agency#.pAssessments
WHERE Assmt_ID =
AND Patient_ID =
AND status = 0
UPDATE #Request.prefix_db_agency#.pAssessments SET
#PreserveSingleQuotes(update_clause)#
WHERE Assmt_ID =
AND F26 =
AND status =
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 =
INSERT INTO #Request.prefix_db_agency#.pAssessments
( Assmt_ID, Admit_ID, Patient_ID, Loc_ID, parent_id, Submitter_ID, Submitter_ID2, status, F1, F2, F3, F4, F5, F6, F7, F8, F9, F10, F11, F12, F13, F14, F15, F16, F17, F18, F19, F20, F21, F22, F23, F24, F25, F26, F27, F28, F29, F30, F31, F32, F33, F34, F35, F36, F37, F38, F39, F40, F41, F42, F43, F44, F45, F46, F47, F48, F49, F50, F51, F52, F53, F54, F55, F56, F57, F58, F59, F60, F61, F62, F63, F64, F65, F66, F67, F68, F69, F70, F71, F72, F73, F74, F75, F76, F77, F78, F79, F80, F81, F82, F83, F84, F85, F86, F87, F88, F89, F90, F91, F92, F93, F94, F95, F96, F97, F98, F99, F100, F101, F102, F103, F104, F105, F106, F107, F108, F109, F110, F111, F112, F113, F114, F115, F116, F117, F118, F119, F120, F121, F122, F123, F124, F125, F126, F127, F128, F129, F130, F131, F132, F133, F134, F135, F136, F137, F138, F139, F140, F141, F142, F143, F144, F145, F146, F147, F148, F149, F150, F151, F152, F153, F154, F155, F156, F157, F158, F159, F160, F161, F162, F163, F164, F165, F166, F167, F168, F169, F170, F171, F172, F173, F174, F175, F176, F177, F178, F179, F180, F181, F182, F183, F184, F185, F186, F187, F188, F189, F190, F191, F192, F193, F194, F195, F196, F197, F198, F199, F200, F201, F202, F203, F204, F205, F206, F207, F208, F209, F210, F211, F212, F213, F214, F215, F216, F217, F218, F219, F220, F221, F222, F223, F224, F225, F226, F227, F228, F229, F230, F231, F232, F233, F234, F235, F236, F237, F238, F239, F240, F241, F242, F243, F244, F245, F246, F247, F248, F249, F250, F251, F252, F253, F254, F255, F256, F257, F258, F259, F260, F261, F262, F263, F264, F265, F266, F267, F268, F269, F270, F271, F272, F273, F274, F275, F276, F277, F278, F279, F280, F281, F282, F283, F284, F285, F286, F287, F288, F289, F290, F291, F292, F293, F294, F295, F296, F297, F298, F299, F300, F301, F302, F303, F304, F305, F306, F307, F308, F309, F310, QA_count, Record_Creation_Date, Record_Created_By, Record_Mod_Date, Record_Mod_By)
SELECT Assmt_ID, Admit_ID, Patient_ID, Loc_ID, parent_id, Submitter_ID, Submitter_ID2, 0 AS status, F1, F2, F3, F4, F5, F6, F7, F8, F9, F10, F11, F12, F13, F14, F15, F16, F17, F18, F19, F20, F21, F22, F23, F24, F25, F26, F27, F28, F29, F30, F31, F32, F33, F34, F35, F36, F37, F38, F39, F40, F41, F42, F43, F44, F45, F46, F47, F48, F49, F50, F51, F52, F53, F54, F55, F56, F57, F58, F59, F60, F61, F62, F63, F64, F65, F66, F67, F68, F69, F70, F71, F72, F73, F74, F75, F76, F77, F78, F79, F80, F81, F82, F83, F84, F85, F86, F87, F88, F89, F90, F91, F92, F93, F94, F95, F96, F97, F98, F99, F100, F101, F102, F103, F104, F105, F106, F107, F108, F109, F110, F111, F112, F113, F114, F115, F116, F117, F118, F119, F120, F121, F122, F123, F124, F125, F126, F127, F128, F129, F130, F131, F132, F133, F134, F135, F136, F137, F138, F139, F140, F141, F142, F143, F144, F145, F146, F147, F148, F149, F150, F151, F152, F153, F154, F155, F156, F157, F158, F159, F160, F161, F162, F163, F164, F165, F166, F167, F168, F169, F170, F171, F172, F173, F174, F175, F176, F177, F178, F179, F180, F181, F182, F183, F184, F185, F186, F187, F188, F189, F190, F191, F192, F193, F194, F195, F196, F197, F198, F199, F200, F201, F202, F203, F204, F205, F206, F207, F208, F209, F210, F211, F212, F213, F214, F215, F216, F217, F218, F219, F220, F221, F222, F223, F224, F225, F226, F227, F228, F229, F230, F231, F232, F233, F234, F235, F236, F237, F238, F239, F240, F241, F242, F243, F244, F245, F246, F247, F248, F249, F250, F251, F252, F253, F254, F255, F256, F257, F258, F259, F260, F261, F262, F263, F264, F265, F266, F267, F268, F269, F270, F271, F272, F273, F274, F275, F276, F277, F278, F279, F280, F281, F282, F283, F284, F285, F286, F287, F288, F289, F290, F291, F292, F293, F294, F295, F296, F297, F298, F299, F300, F301, F302, F303, F304, F305, F306, F307, F308, F309, F310, QA_count, now() , #session.employeeid#, Now() , #session.employeeid# FROM #Request.prefix_db_agency#.pAssessments
WHERE Assmt_ID =
AND status =
UPDATE #Request.prefix_db_agency#.pAssessments SET
Status = ,
Record_Mod_Date = ,
Record_Mod_By =
WHERE Assmt_ID =
AND AutoAssmt_ID =
SELECT * FROM #Request.prefix_db_agency#.pAssessments
WHERE Assmt_ID =
AND status =
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 =
AND status = 0
SELECT * FROM #Request.prefix_db_agency#.pAssessments
WHERE Admit_ID =
AND status =
AND (F26 = 'OT Adult Evaluation' OR F26 = 'PT Adult Evaluation')
AND F25 = '1'
AND status = 0
UPDATE #Request.prefix_db_agency#.pAssessments SET
F101 = '09. Not applicable',
F102 = '09. Not applicable',
F103 = '09. Not applicable',
F104 = '09. Not applicable',
F105 = '09. Not applicable',
F106 = '09. Not applicable',
F131 = '0. No Skip to M1600',
F131 = '1. Yes Continue to GG0170R, Wheel 50 feet with two turns',
Record_Mod_Date =
WHERE Assmt_ID = '#arguments.assid#' AND status = 0
SELECT pProblem.* FROM #Request.prefix_db_agency#.pProblem
WHERE Assmt_ID =
AND status =
AND M0_No like 'M1021%'
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
LEFT OUTER 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 * FROM #Request.prefix_db_agency#.pAssessments
WHERE Admit_ID =
AND Status =
AND (LEFT(F26,1) IN ('1','4') OR F26 like 'Hospice admission')
AND F177 <= #now()#
ORDER BY F177 DESC
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 #Request.prefix_db_agency#.pProblem
WHERE pProblem.Assmt_ID =
AND pProblem.Description =
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
(
,
,
,
,
,
,
,
,
,
,
,
,
,
,
,
,
)
UPDATE #Request.prefix_db_agency#.pAssessments SET
F320 = 0,
Record_Mod_Date = ,
Record_Mod_By =
WHERE Assmt_ID =
ANd Status = 0
UPDATE #Request.prefix_db_agency#.pAssessments SET
F320 = 0,
Record_Mod_Date = ,
Record_Mod_By =
WHERE Assmt_ID =
ANd Status = 0
SELECT Assmt_ID
FROM #Request.prefix_db_agency#.pAssessments
WHERE Patient_ID =
AND Status =
ORDER BY Assmt_ID DESC
LIMIT 1
SELECT COUNT(*) AS careplan_count
FROM #Request.prefix_db_agency#.pCareplan
WHERE Assmt_ID =
AND Status =
UPDATE #Request.prefix_db_agency#.pPatients
SET Med_Approve = 0,
Med_Recon_Field = 0
WHERE Status IN (0,1,4)
AND Patient_ID = '#getAssessment.Patient_ID#'
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, Item_ID,CMSOrder_ID, Skill, ques_id, M0_No, Description, Answer, Severity, dx_order, Coding_Status, Specific_Orders, Resolved_Date,Assign, hospice, Notes, Date_Create, Created_by, Date_Change, Change_by
)
SELECT Problem_ID, Assmt_ID, 0 , '#arguments.Careplan#', Path_ID, Item_ID, CMSOrder_ID,'#arguments.Skill#', ques_id, '#M0_No#', Description, '#arguments.Answer#', '#Left(arguments.Answer,1)#', , Coding_Status , Specific_Orders, Resolved_Date, Assign , '#arguments.hospice#', 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, Item_ID,CMSOrder_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, Item_ID,CMSOrder_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 pProblem.* FROM #Request.prefix_db_agency#.pProblem
WHERE pProblem.AutoProblem_ID =
AND pProblem.Assmt_ID =
SELECT IFNULL(Pathway, 0) AS Pathway_ID
FROM #Request.prefix_db_lookup#.vetted_190924
WHERE Diagnosis =
LIMIT 1
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, Item_ID, CMSOrder_ID, Skill, ques_id, M0_No, Description, Answer, Severity, dx_order, Coding_Status, Specific_Orders, Resolved_Date, Assign, hospice, Notes, Date_Create, Created_by, Date_Change, Change_by
)
SELECT Problem_ID, Assmt_ID, 0, Careplan, , Item_ID, CMSOrder_ID, Skill, ques_id, M0_No, , Answer, Severity, dx_order, Coding_Status, Specific_Orders, Resolved_Date, Assign, hospice, 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#.pAdmit_Svcs
WHERE AutoAdmitSvcs_ID =
AND Status =
SELECT pPathwayReview.*, ID AS Next_ItemID,Order_ID AS Next_orderID,Pathway_ID AS Next_pathwayID
FROM #Request.prefix_db_lookup#.pPathwayReview
WHERE Type =
AND Description =
ORDER BY Type_Order,Next_orderID ASC
SELECT pPathwayReview.*, Max(ID) AS Next_ItemID,Max(Order_ID ) AS Next_orderID,Max(Pathway_ID ) AS Next_pathwayID
FROM #Request.prefix_db_lookup#.pPathwayReview
INSERT INTO #Request.prefix_db_lookup#.pPathwayReview
(
Pathway_ID, Type_Order, Item_ID, Order_ID, Type, Description, Agency_ID, Patient_ID, Emp_ID, Date_Created
)
VALUES
(
,
,
,
,
,
,
,
,
,
)
INSERT INTO #Request.prefix_db_agency#.pAdmit_Svcs
(
Admit_ID,Patient_ID, Status, Skill,
Start_Date,
Physician_order, Notes, Admitted, Date_Create, Created_by, Date_Change, Change_by
)
VALUES
(
'#arguments.Admit_ID#' ,'#session.cs.patientid#',0, '#arguments.Skill#',
'#DateFormat(arguments.Start_Date,"yyyy-mm-dd")#',
'#arguments.Physician_order#','#arguments.Notes#','#arguments.Admitted#', #now()# , #session.employeeid# , #now()#, #session.employeeid#
)
SELECT LAST_INSERT_ID() as LastInsertID
UPDATE #Request.prefix_db_agency#.pAdmit_Svcs
SET
Skill = ,
Start_Date = ,
Physician_order = ,
Notes = ,
Admitted = ,
Date_Change = ,
Change_by =
WHERE AutoAdmitSvcs_ID =
SELECT pAdmit_Svcs.*,pAssessments.F26 FROM #Request.prefix_db_agency#.pAdmit_Svcs
JOIN #Request.prefix_db_agency#.pAssessments ON pAssessments.Admit_ID = pAdmit_Svcs.Admit_ID
AND pAssessments.status =0 AND pAssessments.F176 =
WHERE AutoAdmitSvcs_ID =
SELECT * FROM #Request.prefix_db_agency#.pAssessments
WHERE F176 =
AND Admit_ID =
AND F26 =
AND status = 0
UPDATE #Request.prefix_db_agency#.pAdmit_Svcs_Procs
SET
Status = 2
WHERE Admit_Svcs_ID = '#Admit_Svcs_ID#'
AND Status = 0
INSERT INTO #Request.prefix_db_agency#.pAdmit_Svcs_Procs
(
Admit_ID, Admit_Svcs_ID, Status, Item_ID, Notes, Date_Create, Created_by, Date_Change, Change_by
)
VALUES
(
'#arguments.Admit_ID#' ,'#Admit_Svcs_ID#', 0, '#item_id#',NULL, #now()# , #session.employeeid# , #now()#, #session.employeeid#
)
UPDATE #Request.prefix_db_agency#.pAdmit_Svcs
SET
status = ,
Date_Change = ,
Change_by =
WHERE AutoAdmitSvcs_ID IN ()
SELECT *,0 AS No_Days_Progress, "" AS Note_QA FROM #Request.prefix_db_agency#.pUnstable
WHERE Patient_ID =
SELECT * FROM #Request.prefix_db_agency#.Communication
WHERE Status = 0
AND Record_Creation_Date <= '#Diagnosis_list.Date_Create#'
AND Patient_ID = '#Patient_ID#'
GROUP BY Comm_ID
SELECT * FROM #Request.prefix_db_agency#.pCMS4857
WHERE Status = 0
AND DATE_FORMAT(Date_Create, '%Y-%m-%d') >= '#DateFormat(Diagnosis_list.Date_Create,"yyyy-mm-dd")#'
AND Assmt_ID = '#Assmt_ID#'
AND Form_Type = 'Form 487'
GROUP BY Order_ID
ORDER BY Date_Create DESC
SELECT Item_ID FROM #Request.prefix_db_lookup#.pPathway
WHERE Pathway_ID NOT IN
(SELECT Path_ID FROM #Request.prefix_db_agency#.pProblem
WHERE Assmt_ID = '#Assmt_ID#' AND status = 0)
AND Type= 'symptom' AND Agency_ID IS NULL
(severity GTE probSeverity OR Physician_alert EQ 1) AND (Getorphansitemslist CONTAINS Item_ID OR pgtype EQ 'vital') AND (orderDate_Create GTE ListDate_Create OR len(orderDate_Create) EQ 0)>
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.Severity >= 2
AND pProblem.Assmt_ID = pCareplan.Assmt_ID
GROUP BY pProblem.Problem_ID
ORDER BY pProblem.dx_order, pProblem.Path_ID ASC
SELECT Teaching_Prevention.* FROM #Request.prefix_db_lookup#.Teaching_Prevention
WHERE Pathway_ID IN (#pathway_ids#)
ORDER BY Step_ID, Line_ID ASC
SELECT * FROM #Request.prefix_db_lookup#.Teaching_Symptoms_1
WHERE Path_ID IN (#pathway_ids#)
ORDER BY Step_ID ASC
#Description#
#Description#
SELECT * FROM getall_teachsymp
ORDER BY Step_ID ASC
#UCase(getteach_symp.Explanation)#
#getteach_symp.Explanation#
SELECT * FROM getall_teachpreven
ORDER BY Step_ID DESC , Line_ID ASC
#UCase(getteachings_prev.Explanation)#
#getteachings_prev.Explanation#
SELECT * FROM #Request.prefix_db_agency#.pAssessments
WHERE Admit_ID =
AND status = 0
SELECT * FROM #Request.prefix_db_agency#.pCareplan
WHERE Assmt_ID IN ()
AND Skill =
AND type =
AND status = 0
AND Date_Resolve IS NULL
SELECT * FROM #Request.prefix_db_agency#.pSchedules
WHERE Assmt_ID IN ()
AND Skill =
AND status = 0
ORDER BY Visit_Date ASC
SELECT * FROM #Request.prefix_db_agency#.pSched_Procedure
WHERE Assmt_ID IN ()
AND Schedule_ID =
AND status = 0
Description
#DateFormat(Visit_Date,"mm/dd/yyyy")#
#Description#
SELECT * FROM getschprocedures
WHERE Careplan_ID =
AND Schedule_ID =
checked >
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
SELECT * FROM #Request.prefix_db_agency#.pSchedules
WHERE Schedule_ID = #arguments.Schedule_ID#
AND status = 0
INSERT INTO #Request.prefix_db_agency#.pSched_Procedure
(
Status, Assmt_ID, Schedule_ID, Careplan_ID, Date_Create, Created_by, Date_Change, Change_by
)
VALUES
( 0 , #getschedules.Assmt_ID#, #Schedule_ID#, 0, #now()# , #session.employeeid# , #now()#, #session.employeeid# )
SELECT * FROM #Request.prefix_db_agency#.pProgress
WHERE Schedule_ID = #arguments.Schedule_ID#
AND status = 0
SELECT * FROM #Request.prefix_db_agency#.pProgress
WHERE Careplan_ID IN ()
AND Schedule_ID = #arguments.Schedule_ID#
AND status = 0
SELECT * FROM #Request.prefix_db_agency#.pSchedules
WHERE Schedule_ID =
INSERT INTO #Request.prefix_db_agency#.pSched_Procedure
(
Status, Assmt_ID, Schedule_ID, Careplan_ID, Notes, Date_Create, Created_by, Date_Change, Change_by
)
VALUES( 0 , #getsch.Assmt_ID#, #arguments.Schedule_ID#, 0, Notes ,#now()# , #session.employeeid# , #now()#, #session.employeeid# )
INSERT INTO #Request.prefix_db_agency#.pProgress
(
Assmt_ID, Careplan_ID, Item_ID, Schedule_ID, Comm_ID, PtMeds_ID, Procedure_ID, Teaching_ID, Description, Status, Type, Notes, Date_Create, Created_by, Date_Change, Change_by
)
SELECT Assmt_ID, Careplan_ID, Item_ID,#arguments.Schedule_ID#,0,0,0,0,Description,0,Type, NULL ,#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 =
AND Schedule_ID =
SELECT pSched_Procedure.*, pProgress.Description FROM #Request.prefix_db_agency#.pSched_Procedure
JOIN #Request.prefix_db_agency#.pProgress ON pSched_Procedure.Schedule_ID = pProgress.Schedule_ID
WHERE pSched_Procedure.Schedule_ID = #arguments.Schedule_ID#
AND pProgress.Careplan_ID = pSched_Procedure.Careplan_ID
AND pSched_Procedure.status = 0
UPDATE #Request.prefix_db_agency#.pProgress
SET Description = ,
Date_Change = ,
Change_by =
WHERE Careplan_ID =
AND Schedule_ID =
AND Status = 0
UPDATE #Request.prefix_db_agency#.pSched_Procedure
SET status = ,
Date_Change = ,
Change_by =
WHERE Schedule_ID IN ()
AND Status = 0
SELECT * FROM #Request.prefix_db_agency#.pProgress
WHERE Schedule_ID IN ()
AND status = 0
SELECT * FROM #Request.prefix_db_agency#.pSchedules
WHERE Schedule_ID = #currentschedule_id#
AND status = 0
INSERT INTO #Request.prefix_db_agency#.pSched_Procedure
(
Status, Assmt_ID, Schedule_ID, Careplan_ID, Date_Create, Created_by, Date_Change, Change_by
)
VALUES
( 0 , #getschedules.Assmt_ID#, #currentschedule_id#, #currentcareplan_id#, #now()# , #session.employeeid# , #now()#, #session.employeeid# )
SELECT * FROM getallprogress
WHERE Schedule_ID = '#currentschedule_id#'
AND status = 0
SELECT * FROM getallprogress
WHERE Careplan_ID IN (#currentcareplan_id#)
AND Schedule_ID = #currentschedule_id#
AND status = 0
INSERT INTO #Request.prefix_db_agency#.pProgress
(
Assmt_ID, Careplan_ID, Item_ID, Schedule_ID, Comm_ID, PtMeds_ID, Procedure_ID, Teaching_ID, Description, Status, Type, Notes, Date_Create, Created_by, Date_Change, Change_by
)
SELECT Assmt_ID, Careplan_ID, Item_ID,#currentschedule_id#,0,0,0,0,Description,0,Type, NULL ,#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 =
AND Schedule_ID =
SELECT pSched_Procedure.*, pProgress.Description FROM #Request.prefix_db_agency#.pSched_Procedure
JOIN #Request.prefix_db_agency#.pProgress ON pSched_Procedure.Schedule_ID = pProgress.Schedule_ID
WHERE pSched_Procedure.Schedule_ID IN (
)
AND pProgress.Careplan_ID = pSched_Procedure.Careplan_ID
AND pSched_Procedure.status = 0
UPDATE #Request.prefix_db_agency#.pProgress
SET Description = ,
Date_Change = ,
Change_by =
WHERE Careplan_ID =
AND Schedule_ID =
AND Status = 0
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, Proc_QA
)
VALUES
(
,
,
,
,
,,
,
,
,
,
,
,
,
,
,
,
,
,
,
,
,
,
,
)
SELECT * FROM #Request.prefix_db_agency#.pAssessments
WHERE Assmt_ID =
AND status = 0
SELECT * FROM #Request.prefix_db_agency#.pCareplan
WHERE Assmt_ID =
AND Skill =
AND type =
AND status = 0
AND Date_Resolve IS NULL
>
AND Description NOT like '%01.%' AND Description NOT like '%02.%' AND Description NOT like '%03.%'
AND Description NOT like '%04.%' AND Description NOT like '%05.%' AND Description NOT like '%06.%'
AND Description NOT like '%07.%' AND Description NOT like '%88.%' AND Description NOT like '%09.%'
AND Careplan_ID NOT IN
( SELECT Careplan_ID FROM #Request.prefix_db_agency#.pProgress
WHERE Status = 0
AND Schedule_ID =
AND Type = 'goal' AND YesOrNo = '4')
ORDER BY Goal_ID ASC
SELECT * FROM #Request.prefix_db_agency#.pProgress
WHERE Status = 0
AND Schedule_ID =
AND Type = 'goal'
SELECT * FROM #Request.prefix_db_agency#.pProgress
WHERE Careplan_ID IN ()
AND Schedule_ID = #arguments.Schedule_ID#
AND status = 0
INSERT INTO #Request.prefix_db_agency#.pProgress
(
Assmt_ID, Careplan_ID, Item_ID, Schedule_ID, Comm_ID, PtMeds_ID, Procedure_ID, Teaching_ID, Description, Status, Type, Notes, Date_Create, Created_by, Date_Change, Change_by
)
SELECT Assmt_ID, Careplan_ID, Item_ID,#arguments.Schedule_ID#,0,0,0,0,Description,0,Type, NULL ,#now()#, #session.employeeid# , #now()#, #session.employeeid#
FROM #Request.prefix_db_agency#.pCareplan
WHERE Careplan_ID IN ()
AND status = 0
UPDATE #Request.prefix_db_agency#.pCMS4857
SET Date_Sent = #CreateODBCDate(arguments.Date_Sent)# ,
Date_Change = ,
Change_by =
WHERE Order_ID =
UPDATE #Request.prefix_db_agency#.Communication
SET Comm_Date = #CreateODBCDate(arguments.Date_Sent)# ,
Record_Mod_Date = ,
Record_Mod_By =
WHERE Comm_ID =
UPDATE #Request.prefix_db_agency#.pCMS4857
SET Date_Sent = #CreateODBCDate(arguments.Date_Sent)# ,
Date_Change = ,
Change_by =
WHERE Order_ID =
UPDATE #Request.prefix_db_agency#.pCMS4857
SET QA_Order = ,
Date_Change = ,
Change_by =
WHERE Order_ID =
UPDATE #Request.prefix_db_agency#.pCMS4857
SET status = ,
Date_Change = ,
Change_by =
WHERE Order_ID =
SELECT * FROM #Request.prefix_db_agency#.pCMS4857
WHERE Order_ID =
SELECT * FROM #Request.prefix_db_agency#.pCMS4857
WHERE Assmt_ID =
AND Status != 0
UPDATE #Request.prefix_db_agency#.pProblem SET CMSOrder_ID = 0
WHERE CMSOrder_ID IN ()
UPDATE #Request.prefix_db_agency#.pCareplan SET CMSOrder_ID = 0
WHERE CMSOrder_ID IN ()
UPDATE #Request.prefix_db_agency#.pPtmeds SET CMSOrder_ID = 0
WHERE CMSOrder_ID IN ()
UPDATE #Request.prefix_db_agency#.pWoundsVitals SET CMSOrder_ID = 0
WHERE CMSOrder_ID IN ()
UPDATE #Request.prefix_db_agency#.pSchedules
SET status = ,
Date_Change = ,
Change_by =
WHERE Schedule_ID =
AND Status = 0
SELECT * FROM #Request.prefix_db_agency#.pSchedules
WHERE Schedule_ID =
AND status = 1
SELECT * FROM #Request.prefix_db_agency#.pAuths
WHERE Assmt_ID =
AND status =
UPDATE #Request.prefix_db_agency#.pAdmit_Svcs
SET status = ,
Date_Change = ,
Change_by =
WHERE Assmt_ID =
AND status =
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, Item_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, Item_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#')
AND status = 0
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#')
AND status = 0
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 = ,
F293 = ,
F290 = ,
F291 = ,
F293 = ,
F200 = ,
F199 = ,
Record_Mod_Date = ,
Record_Mod_By =
WHERE Assmt_ID =
AND status = 0
UPDATE #Request.prefix_db_agency#.pAssessments SET
F24 = ,
Record_Mod_Date = ,
Record_Mod_By =
WHERE Assmt_ID =
AND status = 0
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 =
UPDATE #Request.prefix_db_agency#.pSchedules
SET status = ,
Date_Change = ,
Change_by =
WHERE Schedule_ID =
AND status = 0
UPDATE #Request.prefix_db_agency#.pProgress SET
Comm_ID = ,
Date_Change = ,
Change_by =
WHERE Progress_ID =
AND Status = 0
UPDATE #Request.prefix_db_agency#.pPatients SET
Specific_Concerns = ,
Allergies = ,
Pt_Race = ,
M0140_ETHNIC = ,
Record_Mod_Date = ,
Record_Mod_By =
WHERE Patient_ID =
AND Status < 2
UPDATE #Request.prefix_db_agency#.pAdmit SET
M1100_PTNT_LVG_STUTN = ,
Advance_Directive = ,
Code_Status = ,
Emerg_Priority = ,
Date_Change = ,
Change_by =
WHERE Admit_ID =
AND Status = 0
UPDATE #Request.prefix_db_agency#.pAssessments SET
F25 = ,
Record_Mod_Date = ,
Record_Mod_By =
WHERE Assmt_ID =
AND Status = 0
SELECT * FROM #Request.prefix_db_agency#.pCareplan
WHERE Assmt_ID =
AND Type = 'goal'
AND status = 0
SELECT * FROM getallcareplans
WHERE Skill = '#item#'
AND status = 0
UPDATE #Request.prefix_db_agency#.pAssessments
SET
F301 =
F302 =
F303 = ,
Record_Mod_Date = ,
Record_Mod_By =
WHERE Assmt_ID =
AND status = 0
UPDATE #Request.prefix_db_agency#.pAssessments SET
F304 = ,
F305 = ,
F306 = ,
Record_Mod_Date = ,
Record_Mod_By =
WHERE Assmt_ID =
AND Status = 0
SELECT *,LEFT(pAssessments.F26,1) AS assmtreason FROM #Request.prefix_db_agency#.pAssessments
JOIN #Request.prefix_db_agency#.pPatients ON pAssessments.Patient_ID = pPatients.Patient_ID
WHERE pPatients.Loc_ID =
AND pAssessments.status = 0
AND pAssessments.Admit_ID =
AND pPatients.status < 2
Order By F176 ASC
SELECT * FROM GetA
WHERE Status =
AND assmtreason IN ('1','4')
ORDER BY F177 DESC
SELECT * FROM GetA
WHERE Status =
AND F26 IN ('SN Adult Evaluation')
AND Admit_ID =
ORDER BY F177 DESC
SELECT * FROM GetA
WHERE Status =
AND F26 IN ('PT Adult Evaluation')
ORDER BY F177 DESC
SELECT * FROM GetA
WHERE Status =
AND F26 IN ('ST Adult Evaluation')
AND Admit_ID =
ORDER BY F177 DESC
SELECT * FROM GetA
WHERE Status =
AND F26 IN ('OT Adult Evaluation')
ORDER BY F177 DESC
SELECT *,LEFT(pAssessments.F26,1) AS assmtreason FROM #Request.prefix_db_agency#.pAssessments
JOIN #Request.prefix_db_agency#.pAdmit ON pAdmit.Admit_ID = pAssessments.Admit_ID AND pAdmit.status =0
AND pAdmit.Patient_ID = pAssessments.Patient_ID
JOIN #Request.prefix_db_agency#.pPatients ON pAssessments.Patient_ID = pPatients.Patient_ID
WHERE
pAssessments.status = 0
AND pAssessments.Admit_ID =
AND pPatients.status IN (0,1,4)
Order By F176 ASC, F177 ASC
SELECT * FROM GetA
WHERE Status =
AND (assmtreason IN ('1','4') OR F26 like 'Hospice admission')
AND F177 <= #now()#
ORDER BY F177 DESC
SELECT * FROM GetA
WHERE Status =
AND F26 IN ('SN Adult Evaluation')
AND Admit_ID =
ORDER BY F177 DESC
SELECT * FROM GetA
WHERE Status =
AND F26 IN ('PT Adult Evaluation')
ORDER BY F177 DESC
SELECT * FROM GetA
WHERE Status =
AND F26 IN ('ST Adult Evaluation')
AND Admit_ID =
ORDER BY F177 DESC
SELECT * FROM GetA
WHERE Status =
AND F26 IN ('OT Adult Evaluation')
ORDER BY F177 DESC
SELECT * FROM GetA
WHERE Status =
AND (F26 like '%Adult%' OR F26 like '%Pediatric%')
AND Admit_ID =
ORDER BY F177 DESC
SELECT * FROM #Request.prefix_db_agency#.pAssessments
WHERE Assmt_ID IN ()
ORDER BY Record_Creation_Date ASC
SELECT * FROM GetA
WHERE Status =
AND (F26 like '%Adult%'OR F26 like '%Pediatric%')
AND Assmt_ID = #getParentEvaluation.Assmt_ID#
AND Admit_ID =
ORDER BY F177 DESC