SELECT Patient_ID, Last_Name_M0040 AS Last_Name, First_Name_M0040 AS First_Name, Middle_Initial_M0040 AS Middle FROM #Request.prefix_db_agency#.patient WHERE Patient_ID = '#session.cs.patientid#' AND Agency_ID = #session.AgencyID# DELETE FROM #table_files# WHERE id = '#url.df#' AND AgencyId = '#session.AgencyId#' AND PatientId = '#GetP.Patient_Id#' INSERT INTO #table_files# ( AgencyId, PatientId, Title, FileName, FileType, File, CreatedBy ,DOC_ID ) VALUES ( '#session.AgencyId#' ,'#GetP.Patient_Id#' ,'#Form.ufTitle#' ,'#File.ServerFile#' ,'#File.ContentType#/#File.ContentSubType#' , ,'#session.EmployeeId#' ,#form.document_name# ) SELECT f.*, e.Last_Name, e.First_Name FROM #table_files# f,#Request.prefix_db_lookup#.Employee e WHERE f.AgencyId = '#session.AgencyId#' AND f.PatientId = '#GetP.Patient_Id#' AND e.Employee_Id = f.CreatedBy AND e.Employee_Id = '#Session.EmployeeID#' ORDER BY f.id SELECT Communication.Comm_ID, Communication.CommSub_ID, Communication.Comm_Date, Communication.Resolved ,CommunicationSubjects.CommSub_ID, CommunicationSubjects.Subject FROM #Request.prefix_db_agency#.Communication, #Request.prefix_db_agency#.CommunicationSubjects WHERE Communication.Patient_ID = #session.cs.patientid# AND CommunicationSubjects.CommSub_ID = Communication.CommSub_ID AND Communication.Agency_ID = #session.AgencyID# Order by Comm_Date Desc SELECT Event.Event_ID, Event.EventSub_ID, Event.Event_Date, patient.Last_Name_M0040, Employee.Employee_ID, Employee.Last_Name, EventSubjects.EventSub_ID, EventSubjects.Subject,Event.Resolved FROM #Request.prefix_db_agency#.Event,#Request.prefix_db_lookup#.Employee, #Request.prefix_db_agency#.patient, #Request.prefix_db_agency#.EventSubjects WHERE Event.Agency_ID = #session.AgencyID# And Event.Employee_ID = Employee.Employee_ID And Event.Patient_ID = patient.Patient_ID And Event.EventSub_ID = EventSubjects.EventSub_ID And Event.Patient_ID = '#session.cs.patientid#' AND ( patient.Employee_ID = ' #Session.EmployeeID#' OR '#session.EmployeeId#' IN ( select distinct employee_id from #Request.prefix_db_agency#.ScheduleItems where patient_id = patient.Patient_Id and deleted <> 1 ) ) ORDER BY Event_Date DESC
#getP.Last_Name#, #getP.First_Name# #getP.Middle# - Chart Review
pm = CreateObject("Component", "PatientMenu"); pm.getPatientMenu(#getP.Patient_Id#);
The file you uploaded exceeded the 500k (500,000 byte) file size limit.
Please reduce the size of the file and try uploading again.
SELECT MenuLevel3Id,MenuNames,DefaultPageUrl FROM #Request.prefix_db_lookup#.homecare_menulevel3 where parentid = 12 and Level1Access=1 and Level2Access=1 and Level3Access=1 and Level4Access=1 and Level5Access=1 and Level6Access=1 and Level7Access=1 and Level8Access=1 and Level9Access=1
+  Patient Files
+  Communication
+  Incidences
+  Patient Files
+  Communication
+  Incidences