INSERT INTO #Request.prefix_db_agency#.Communication (
CommSub_ID,
Patient_ID,
Employee_ID,
Comm_Date,
Memo,
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#,
#CreateODBCDate(form.Comm_Date)#,
'#Trim(form.Memo)#',
'#Trim(form.Resolved)#',
#session.AgencyID#,
'#Trim(form.Followup_desc)#',
'#Trim(form.Followup_memo)#',
'#myDateTime#',
#url.docId##url.employee_id##Session.EmployeeID#,
'#myDateTime#',
#url.docId##url.employee_id##Session.EmployeeID#
)
Select LAST_INSERT_ID() AS id
INSERT INTO #Request.prefix_db_agency#.communication_to (
comm_id, employee_id
) VALUES (
'#id#', '#a[i]#'
)
SELECT e.email, e.cell_phone
,(select domain from #Request.prefix_db_lookup#.mobile_domains where id = e.mobiledomain) AS provider
FROM #Request.prefix_db_lookup#.Employee e
WHERE e.employee_id = '#a[i]#'
SELECT e.email, e.first_name, e.last_name
FROM #Request.prefix_db_agency#.Communication c, #Request.prefix_db_lookup#.Employee e
WHERE c.comm_id = '#id#'
AND e.employee_id = c.Record_Created_By
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)#,
Memo = '#Trim(form.Memo)#',
Resolved = '#form.Resolved#',
Followup_desc = '#Trim(form.Followup_desc)#',
Followup_memo = '#Trim(form.Followup_memo)#',
Record_Mod_Date = '#myDateTime#',
Record_Mod_By = #Session.EmployeeID#
WHERE 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