function stripHTML(str) {
return REReplaceNoCase(str,"<[^>]*>","","ALL");
}
SELECT * FROM #Request.prefix_db_agency#.Communication
WHERE Schedule_ID = #form.Schedule_ID#
AND Schedule_ID != 0
>
INSERT INTO #Request.prefix_db_agency#.Communication (
CommSub_ID,
Patient_ID,
Employee_ID,
Schedule_ID,
Comm_Date,
Reason_for_discharge,
Discharge_Disposition,
Memo,
Memo_copy,
Resolved,
Agency_ID,
Followup_desc,
Followup_memo,
Record_Creation_Date,
Record_Created_By,
Record_Mod_Date,
Record_Mod_By
) VALUES (
'#Trim(form.CommSub_Id)#',
'#Trim(form.Patient_Id)#',
#url.docId##url.employee_id##Session.EmployeeID#,
#form.Schedule_ID#,
#CreateODBCDate(form.Comm_Date)#,
,
,
,
,
'#Trim(form.Resolved)#',
#session.AgencyID#,
,
,
'#myDateTime#',
#url.docId##url.employee_id##Session.EmployeeID#,
'#myDateTime#',
#url.docId##url.employee_id##Session.EmployeeID#
)
Select LAST_INSERT_ID() AS id
UPDATE #Request.prefix_db_agency#.pSchedules SET
Comm_ID = '#Trim(form.comm_id)#'
WHERE Schedule_ID = #form.Schedule_ID#
AND Status =0
UPDATE #Request.prefix_db_agency#.pProgress SET
Comm_ID = '#Trim(form.Comm_ID)#'
WHERE Progress_ID IN (#form.Progress_ID#)
AND Status =0
DELETE FROM #Request.prefix_db_agency#.pUnstable
WHERE Progress_ID IN (#form.Progress_ID#)
INSERT INTO #Request.prefix_db_agency#.Comm_Progress
(Comm_ID, Progress_ID, Status, Date_Created, Created_by, Date_Change, Change_by )
values
(
,
,
,
,
,
,
)
UPDATE #Request.prefix_db_agency#.Communication
SET Comm_record_deleted = 1,
Status = 1
WHERE Comm_ID =
INSERT INTO #Request.prefix_db_agency#.communication_to (
comm_id, employee_id
) VALUES (
'#id#', '#a[i]#'
)
SELECT e.Emp_Email AS email, e.Emp_Telephone AS cell_phone
FROM #Request.prefix_db_lookup#.pEmployee e
WHERE e.Emp_ID = '#a[i]#'
SELECT e.Emp_Email AS email , e.Emp_First, e.Emp_Last
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 *, 1 AS communication_email 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.
UPDATE #Request.prefix_db_agency#.Communication SET
CommSub_ID = '#Trim(form.CommSub_ID)#',
Patient_ID = '#Trim(form.Patient_ID)#',
Employee_ID = '#Trim(session.EmployeeId)#',
Comm_Date = #CreateODBCDate(form.Comm_Date)#,
Reason_for_discharge = ,
Discharge_Disposition = ,
Memo = ,
Resolved = '#form.Resolved#',
Followup_desc = ,
Followup_memo = ,
Record_Mod_Date = '#myDateTime#',
Record_Mod_By = #Session.EmployeeID#
WHERE Schedule_ID = #form.Schedule_ID#Comm_ID = #form.Comm_Id#
DELETE FROM #Request.prefix_db_agency#.communication_to
WHERE comm_id = '#form.Comm_Id#'
AND employee_id NOT IN (#form.employee_id#)
SELECT id FROM #Request.prefix_db_agency#.communication_to WHERE comm_id = '#form.Comm_Id#' AND employee_id = '#a[i]#'
INSERT INTO #Request.prefix_db_agency#.communication_to (
comm_id, employee_id
) VALUES (
'#form.Comm_ID#', '#a[i]#'
)
Unable to Create / Update Communication: Form Data is Missing