SELECT * FROM #Request.prefix_db_agency#.CommunicationSubjects
WHERE Subject like '%no treatment%'
INSERT INTO #Request.prefix_db_agency#.CommunicationSubjects
( Agency_ID, Subject, Created_By, Created_Date, Mod_By, Mod_Date, active)
Values
(#session.agencyid#,'no treatment',#session.employeeid# , #now()#, #session.employeeid#,#now()#,'Y' )
SELECT LAST_INSERT_ID() as LastInsertID
SELECT pProgress.*,pSchedules.Skill FROM #Request.prefix_db_agency#.pProgress
JOIN #Request.prefix_db_agency#.pSchedules ON pSchedules.Schedule_ID = pProgress.Schedule_ID AND pSchedules.Status = 0
WHERE pProgress.Progress_ID IN ()
AND pProgress.Status = 0
SELECT pProgress.*,pSchedules.Skill FROM #Request.prefix_db_agency#.pProgress
JOIN #Request.prefix_db_agency#.pSchedules ON pSchedules.Schedule_ID = pProgress.Schedule_ID AND pSchedules.Status = 0
WHERE pProgress.Progress_ID =
AND pProgress.Status = 0
SELECT * FROM #Request.prefix_db_agency#.CommunicationSubjects
WHERE Subject like '%no treatment%'
INSERT INTO #Request.prefix_db_agency#.CommunicationSubjects
( Agency_ID, Subject, Created_By, Created_Date, Mod_By, Mod_Date, active)
Values
(#session.agencyid#,'no treatment',#session.employeeid# , #now()#, #session.employeeid#,#now()#,'Y' )
SELECT LAST_INSERT_ID() as LastInsertID
INSERT INTO #Request.prefix_db_agency#.Communication (
CommSub_ID,
Patient_ID,
Employee_ID,
Schedule_ID,
Comm_Date,
Memo,
Resolved,
Agency_ID,
Followup_desc,
Followup_memo,
Record_Creation_Date,
Record_Created_By,
Record_Mod_Date,
Record_Mod_By
) VALUES (
'#CommSub_Id#',
'#Trim(Getprogress.Patient_Id)#',
#session.employeeid#,
#Getprogress.Schedule_ID#,
#CreateODBCDate(now())#,
,
'No',
#session.AgencyID#,
,
,
#now()#, #session.employeeid#, #now()#, #session.employeeid#
)
Select LAST_INSERT_ID() AS id
INSERT INTO #Request.prefix_db_agency#.Comm_Progress
(Comm_ID, Progress_ID, Status, Date_Created, Created_by, Date_Change, Change_by )
values
(
,
,
,
,
,
,
)
INSERT INTO #Request.prefix_db_agency#.communication_to (
comm_id, employee_id
) VALUES (
'#id#', '#a[i]#'
)
SELECT e.Emp_Email AS email, e.Emp_First AS first_name, e.Emp_Last AS last_name
FROM #Request.prefix_db_agency#.Communication c, #Request.prefix_db_lookup#.pEmployee e
WHERE c.comm_id = '#id#'
AND e.Emp_ID = c.Record_Created_By
SELECT * FROM #Request.prefix_db_lookup#.pEmployee WHERE Emp_ID = '#Session.EmployeeID#'
A New Communication has been Assigned to You at MyHomeCareBiz.com by #postedBy#.
Please click here to View the New Communication.
This is an automated system notification from MyHomeCareBiz.com. Therefore, there is no Unsubscribe option.
A New Communication has been Assigned to You at MyHomeCareBiz.com by #postedBy#. Please click here to View the New Communication.
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, CMSOrder_ID, Status,
Skill, Type,Description, Date_Resolve, Date_Create, Created_by, Date_Change, Change_by )
VALUES
(
,
,
,
,
,
,
,
,
,
,
,
,
,
)
UPDATE #Request.prefix_db_agency#.pProgress SET
Careplan_ID = ,
Date_Change = ,
Change_by =
WHERE Progress_ID =
AND Status = 0