pm = CreateObject("Component", "Menu"); myArgument = 'uploadlist'; pm.MenuFunction(myArgument,#getP.Patient_Id#,'','','',''); DELETE FROM #table_files# WHERE id = '#url.df#' AND AgencyId = '#session.AgencyId#' AND PatientId = '#GetP.Patient_Id#' INSERT IGNORE INTO #table_files# ( AgencyId, PatientId, Title, FileName, FileType,Dup_file_name, CreatedBy ,DOC_ID ,Assessment ,Cert_Start,Cert_End ,placeholder ) VALUES ( '#session.AgencyId#' ,'#GetP.Patient_Id#' ,'#Form.ufTitle#' ,'#filename#' ,'#File.UPLOADALLRESULTS[i].ContentType#/#File.UPLOADALLRESULTS[i].ContentSubType#' ,'#Duplicate_file_name#' ,'#session.EmployeeId#' ,'#form.document_name#' ,'#form.Assessment#' ,, ,'#form.placeholder#' ) INSERT INTO #Request.prefix_db_lookup#.Coding_Request (Agency_ID,Request_Date,Last_Name,First_Name,Assessment_Type, Assigned_to,Coding_status,Assigned_by,Request_Time,MHCB_Entered,time_requested,Updated_by) VALUES ('#session.agencyid#','#DateFormat(now(),"yyyy-mm-dd")#', '#GetP.Pt_Last#','#Getp.Pt_First#','','Melissa','meds_dataentry','#session.employeeid#', '#TimeFormat(now(), "short")#',#now()#,#now()#,'#Session.employeeid#') INSERT IGNORE INTO #table_files# ( AgencyId, PatientId, CreatedBy ,placeholder ,Assessment ,Cert_Start,Cert_End ) VALUES ( '#session.AgencyId#' ,'#GetP.Patient_Id#' ,'#session.EmployeeId#' ,'#form.placeholder#' ,'#form.Assessment#' ,, ) SELECT id,Title,FileName,Created,PatientId,CreatedBy FROM #table_files# WHERE AgencyId = '#session.AgencyId#' AND PatientId = '#GetP.Patient_Id#' AND CreatedBy = '#Session.EmployeeID#' ORDER BY id SELECT Admit_ID FROM #Request.prefix_db_agency#.pAdmit WHERE Patient_ID = AND Status = 0 ORDER BY M0030_START_CARE_DT DESC LIMIT 1 SELECT MAX(Assmt_ID) AS Assmt_ID, MAX(F26) AS F26, MAX(F27) AS F27, F177, F178 FROM #Request.prefix_db_agency#.pAssessments WHERE Patient_ID = AND status = 0 AND F177 IS NOT NULL AND F178 IS NOT NULL GROUP BY F177, F178 ORDER BY F177 DESC SELECT Cert_Start, Cert_End, MIN(id) AS file_id FROM #table_files# WHERE PatientId = AND AgencyId = AND Status = 0 AND Cert_Start IS NOT NULL AND Cert_End IS NOT NULL GROUP BY Cert_Start, Cert_End ORDER BY Cert_Start DESC SELECT Assmt_ID, F177, F178 FROM #Request.prefix_db_agency#.pAssessments WHERE Patient_ID = AND status = 0 AND Admit_ID = AND F177 IS NOT NULL AND F178 IS NOT NULL ORDER BY F177 DESC LIMIT 1
#GetP.Pt_First# #GetP.Pt_Last# PATIENT FILES
Back
Your Agency is not currently using the Patient Document Management feature.
This feature allows you to Upload documents related to the Patient's care including any .doc, .pdf, .xls, etc... files you would like to associate with this Patient's record.
If you would like to begin using this feature, please Contact Us to have this feature Enabled for your Agency.
SELECT * FROM #Request.prefix_db_agency#.DocumentDesc WHERE DocumentType like '%Patient%' ORDER BY DOC_ID SELECT * FROM #Request.prefix_db_agency#.files WHERE ID =
value="#url.file_title#" />

For iOS devices: If the camera doesn't open, try tapping the file input again or use the iOS-specific upload button below.