SELECT TABLE_SCHEMA FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_SCHEMA like '%agency%' group by TABLE_SCHEMA
SELECT pPatients.*,pAdmit.Refer_Phys_ID,pAdmit.Render_Phys_ID FROM #Request.prefix_db_agency#.pPatients
JOIN #Request.prefix_db_agency#.pAdmit ON pPatients.Patient_ID = pAdmit.Patient_ID
WHERE pAdmit.Status =
AND pPatients.Status =
GROUP BY Patient_ID DESC
SELECT * FROM #Request.prefix_db_lookup#.pPhysicians
WHERE Phys_ID =
AND Status =
SELECT pCareplan.* FROM #Request.prefix_db_agency#.pCareplan
JOIN #Request.prefix_db_agency#.pAssessments ON pAssessments.Assmt_ID = pCareplan.Assmt_ID
WHERE pAssessments.Patient_ID =
AND pAssessments.Status =
AND pCareplan.Status =
AND DATE(pCareplan.Date_Change) = DATE (now())
GROUP BY pCareplan.Careplan_ID
ORDER BY Order_ID ASC
SELECT * FROM #Request.prefix_db_agency#.pPtmeds
WHERE Patient_ID =
AND Status =
AND DATE(Record_Mod_Date) = DATE (now())
GROUP BY PtMeds_ID
ORDER BY Drug_Name ASC
")# />
")# />
all medication changes and careplan changes made on " & #DateFormat(now(),"mm/dd/yyy")# & " compiled on one communication and sent to physician for signature" />
all careplan changes made on " & #DateFormat(now(),"mm/dd/yyy")# & " compiled on one communication and sent to physician for signature" />
all medication changes made on " & #DateFormat(now(),"mm/dd/yyy")# & " compiled on one communication and sent to physician for signature" />
INSERT INTO #Request.prefix_db_agency#.Communication (
CommSub_ID,
Agency_ID,
Patient_ID,
Employee_ID,
Comm_Date,
Memo,
Followup_desc,
Followup_memo,
Resolved,
Record_Creation_Date,
Record_Created_By,
Record_Mod_Date,
Record_Mod_By
) VALUES (
'1',
'#Loc_ID#',
'#Patient_ID#',
'#Employee_ID#',
#CreateODBCDate(now())#,
'#Trim(memo)#',
'#message#',
'',
'No',
#CreateODBCDate(now())#,
'2',
#CreateODBCDate(now())#,
'2'
)
Select LAST_INSERT_ID() AS id
INSERT INTO #Request.prefix_db_agency#.communication_to
(comm_id, employee_id)
VALUES
('#Comm_ID#', '#Employee_ID#')
A New Communication has been Assigned to You at MyHomeCareBiz.com by Automatically.
Please click here to View the New Communication.
This is an automated system notification from MyHomeCareBiz.com. Therefore, there is no Unsubscribe option.