SELECT Max(Careplan_ID)+1 AS pCareplan_ID FROM #Request.prefix_db_agency#.pCareplan
SELECT IFNULL(MAX(Problem_ID),0)+1 As pProblem_ID FROM #Request.prefix_db_agency#.pProblem
SELECT * FROM #Request.prefix_db_agency#.pAssessments
WHERE Assmt_ID =
AND status = 0
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,
Approved,
Date_Created
)
VALUES
(
,
,
,
,
,
,
,
,
,
,
)
INSERT INTO #Request.prefix_db_agency#.pProblem
(
Problem_ID, Assmt_ID, Status, Path_ID,Item_ID, Skill, ques_id,pProblem.manual, M0_No, Description, Notes, Date_Create, Created_by, Date_Change,
Change_by
)
VALUES
(
,
,
,
,
,
,
,
,
,
,
,
,
,
,
)
SELECT IFNULL(MAX(Goal_ID),0)+1 As pGoal_ID
FROM #Request.prefix_db_agency#.pCareplan
WHERE Skill = "#form.Skill#"
AND Assmt_ID = '#form.AID#'
INSERT INTO #Request.prefix_db_agency#.pCareplan
(
Careplan_ID, Assmt_ID, Item_ID, Order_ID, Goal_ID, Status,Incrmt1, Skill, Type, Description, other, Notes,Date_Target , Date_Create, Created_by, Date_Change, Change_by
)
VALUES
(
,
,
,
,
,
,
,,
,
,
,
,
,
,
,
,
)
SELECT * FROM #Request.prefix_db_agency#.pSchedules
WHERE Schedule_ID =
AND Status =
INSERT IGNORE INTO #Request.prefix_db_agency#.pProgress
(
Careplan_ID,Assmt_ID, Item_ID, Schedule_ID, Type, Description,Status,Visit_no,severity,YesOrNo, Notes,
Value_1,Value_2,Value_3,
Date_Create, Created_by, Date_Change, Change_by
)
VALUES
(
,
,
,
,
,
,
,
,
,
,
,
,
,,,,
,
,
)
SELECT pPathway.* FROM #Request.prefix_db_lookup#.pPathway
WHERE ID IN ( )
AND Type =
ORDER BY Type_Order,Order_ID ASC
SELECT Max(Careplan_ID)+1 AS pCareplan_ID FROM #Request.prefix_db_agency#.pCareplan
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, Item_ID, Skill, ques_id, M0_No, Description, Notes, Date_Create,
Created_by, Date_Change, Change_by
)
VALUES
(
,
,
,
,
,
,
,
,
,
,
,
,
,
)
SELECT IFNULL(MAX(Goal_ID),0)+1 As pGoal_ID
FROM #Request.prefix_db_agency#.pCareplan
WHERE Skill = "#form.Skill#"
AND Assmt_ID = '#form.AID#'
INSERT INTO #Request.prefix_db_agency#.pCareplan
(
Careplan_ID, Assmt_ID, Item_ID, Order_ID, Goal_ID, Status, Skill, Type, Description, other, Notes,Date_Target, Date_Create, Created_by, Date_Change, Change_by
)
VALUES
(
,
,
,
,
,
,
,
,
,
,
,
,
,
,
,
)
SELECT * FROM #Request.prefix_db_agency#.pSchedules
WHERE Schedule_ID =
AND Status =
INSERT IGNORE INTO #Request.prefix_db_agency#.pProgress
(
Careplan_ID,Assmt_ID, Item_ID, Schedule_ID, Type, Description,Status,Visit_no,severity,YesOrNo, Notes,
Value_1,Value_2,Value_3,
Date_Create, Created_by, Date_Change, Change_by
)
VALUES
(
,
,
,
,
,
,
,
,
,
,
,
,
,,,,
,
,
)
UPDATE #Request.prefix_db_agency#.pProgress
SET
Procedure_ID = #Careplan_ID#,
Teaching_ID = #Careplan_ID# ,
Date_Change = ,
Change_by =
WHERE Progress_ID IN ()
AND Status =
DELETE FROM #Request.prefix_db_agency#.pUnstable
WHERE Progress_ID IN (#COOKIE.Progress_IDs#)
request.ass = CreateObject("component","components.general.assessments").init();
getgoalsuccess = request.ass.updategoals_visit(#form.AID#);
SELECT * FROM #Request.prefix_db_agency#.pAssessments
WHERE Assmt_ID =
AND status = 0
SELECT pPathway.*, IFNULL(pPathway.Value,0) AS measurevalue FROM #Request.prefix_db_lookup#.pPathway
WHERE pPathway.Type =
AND pPathway.Description NOT IN (
SELECT substring_index ( pProblem.Description,'(',1) FROM #Request.prefix_db_agency#.pProblem
WHERE pProblem.Assmt_ID =
AND pProblem.Status =
)
AND (Approved IS NULL OR Approved = 'Yes')
AND (Param IS NULL OR Param != 1)
AND pPathway.Description NOT IN (
SELECT Description FROM #Request.prefix_db_agency#.pCareplan
WHERE pCareplan.Assmt_ID =
AND pCareplan.Status =
)
AND pPathway.Description NOT IN (
SELECT Description FROM #Request.prefix_db_agency#.pProblem
WHERE pProblem.Assmt_ID =
AND pProblem.Status =
)
AND pPathway.Description NOT IN (
SELECT Description FROM #Request.prefix_db_agency#.pProgress
WHERE Schedule_ID =
AND Status =
)
GROUP BY Description
ORDER BY Header_No,Type_Order,Order_ID ASC
SELECT * FROM getpathways WHERE Agency_ID IS NULL
SELECT * FROM getpathways WHERE Agency_ID = #session.agencyid#
SELECT pProblem.* FROM #Request.prefix_db_agency#.pProblem
WHERE pProblem.Assmt_ID =
AND pProblem.status =
AND ( pProblem.M0_No like 'M1021%'
OR pProblem.M0_No like 'M1023%')
ORDER BY dx_order,RIGHT(M0_No, 1) ASC