pm = CreateObject("Component", "Menu"); myArgument = 'uploadlist'; pm.MenuFunction(myArgument,#getP.Patient_Id#,'','','',''); SELECT * FROM #Request.prefix_db_agency#.pAdmit WHERE Patient_ID = '#session.cs.patientid#' And status = 0 general = CreateObject("Component", "components.general.general").init(); GetEmpList = general.get_all_physicians(Loc_ID = #session.agencyid#,status = 0, physician_id = #physician_id#); UPDATE #table_files# SET Status = 1 WHERE id = '#url.df#' AND AgencyId = '#session.AgencyId#' AND PatientId = '#GetP.Patient_Id#' UPDATE #Request.prefix_db_agency#.pg_files SET Status = 1 WHERE id = '#url.dpgf#' AND Agency_Id = '#session.AgencyId#' AND Patient_Id = '#GetP.Patient_Id#' SELECT pt_ai_id FROM #Request.prefix_db_agency#.patients_ai WHERE Patient_ID = AND status = 0 LIMIT 1 INSERT IGNORE INTO #table_files# ( AgencyId, PatientId, Title, FileName, FileType,Dup_file_name, CreatedBy ,DOC_ID ,Assessment ) VALUES ( '#session.AgencyId#' ,'#GetP.Patient_Id#' ,'#Form.ufTitle#' ,'#File.ServerFile#' ,'#File.ContentType#/#File.ContentSubType#' ,'#Duplicate_file_name#' ,'#session.EmployeeId#' ,'#form.document_name#' ,'#form.Assessment#' ) SELECT id, Title, DocumentDesc.Description AS Docdescription,FileName,#table_files#.Dup_file_name,Created,PatientId,CreatedBy,#table_files#.placeholder, #table_files#.Notes,#table_files#.faxsend_to,#table_files#.faxsent_time, Assessment,#table_files#.DOC_ID,#table_files#.Expires,#table_files#.Cert_Start,#table_files#.Cert_End,#table_files#.Sort_Order FROM #table_files# LEFT OUTER JOIN #Request.prefix_db_agency#.DocumentDesc ON #table_files#.DOC_ID = DocumentDesc.DOC_ID WHERE AgencyId = '#session.AgencyId#' AND PatientId = '#GetP.Patient_Id#' AND Status = 0 AND ((DocumentType NOT like 'LOA%' AND DocumentType NOT like 'Auth%') OR DocumentType IS NULL) GROUP BY #table_files#.id ORDER BY IFNULL(#table_files#.Sort_Order, #table_files#.id) ASC, #table_files#.id ASC SELECT vj.patient_file_id, vj.task_id, vj.ID AS vertex_job_row_id, vj.job_status FROM #Request.prefix_db_agency#.vertex_jobs vj INNER JOIN ( SELECT patient_file_id, MAX(ID) AS max_id FROM #Request.prefix_db_agency#.vertex_jobs WHERE Status = 0 AND Patient_ID = GROUP BY patient_file_id ) latest ON latest.max_id = vj.ID SELECT pg_files.id,pg_files.DOC_ID, pg_files.Title,pg_files.FileName,pg_files.Created,pg_files.Patient_Id,pg_files.CreatedBy, pg_files.Notes,pg_files.faxsend_to,pg_files.faxsent_time, DocumentDesc.Description AS Docdescription, pEmployee.Emp_Last, pEmployee.Emp_First , pSchedules.* FROM #Request.prefix_db_agency#.pg_files LEFT OUTER JOIN #Request.prefix_db_agency#.pSchedules ON pg_files.Schedule_ID = pSchedules.Schedule_ID AND pSchedules.Status= 0 LEFT OUTER JOIN #Request.prefix_db_lookup#.pEmployee ON pg_files.CreatedBy = pEmployee.Emp_ID LEFT OUTER JOIN #Request.prefix_db_agency#.DocumentDesc ON pg_files.DOC_ID = DocumentDesc.DOC_ID WHERE pg_files.Agency_Id = '#session.AgencyId#' AND pg_files.Patient_Id = '#GetP.Patient_Id#' AND Title != 'Wounds_assessments' AND pg_files.Status = 0 GROUP BY pg_files.id ORDER BY pg_files.id SELECT pg_files.id,pg_files.DOC_ID, pg_files.Title,pg_files.FileName,pg_files.Created,pg_files.Patient_Id,pg_files.CreatedBy, pg_files.Notes,pg_files.faxsend_to,pg_files.faxsent_time, DocumentDesc.Description AS Docdescription, pEmployee.Emp_Last, pEmployee.Emp_First , pAssessments.* FROM #Request.prefix_db_agency#.pg_files LEFT OUTER JOIN #Request.prefix_db_agency#.pAssessments ON pg_files.Schedule_ID = pAssessments.Assmt_ID AND pAssessments.Status = 0 LEFT OUTER JOIN #Request.prefix_db_lookup#.pEmployee ON pg_files.CreatedBy = pEmployee.Emp_ID LEFT OUTER JOIN #Request.prefix_db_agency#.DocumentDesc ON pg_files.DOC_ID = DocumentDesc.DOC_ID WHERE pg_files.Agency_Id = '#session.AgencyId#' AND pg_files.Patient_Id = '#GetP.Patient_Id#' AND Title = 'Wounds_assessments' AND pg_files.Status = 0 GROUP BY pg_files.id ORDER BY pg_files.id SELECT * FROM #Request.prefix_db_agency#.DocumentDesc WHERE (DocumentType like '%Patient%' OR DocumentType like 'LOA%' OR DocumentType like 'Auth%' ) AND Required = 1 ORDER BY DOC_ID SELECT * FROM #Request.prefix_db_agency#.DocumentDesc WHERE DocumentType like '%Assessment%' AND Required = 1 ORDER BY DOC_ID SELECT * FROm #Request.prefix_db_agency#.pCMS4857 JOIN #Request.prefix_db_agency#.pAssessments ON pAssessments.Assmt_ID = pCMS4857.Assmt_ID AND pAssessments.status = 0 AND pCMS4857.status = 0 AND pAssessments.Patient_ID = #session.cs.patientid# GROUP BY Order_ID SELECT * FROm #Request.prefix_db_lookup#.Received_faxes WHERE Received_faxes.Agency_ID = #session.agencyid# AND Patient_ID = #session.cs.patientid# AND status = 0 ORDER BY Received_faxes.completed_timestamp DESC 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
The file you uploaded exceeded the 5MB file size limit.
Please reduce the size of the file and try uploading again.

Patient Created Successfully!

Patient: #summary.patient_name# (ID: #summary.patient_id#)

Summary of Finished Actions:
  • #msg#

Please check the Dashboard for updates on the processing status.

Upload Patient File
Patient Files
Upload a Patient File
SELECT e.Emp_Last, e.Emp_First FROM #Request.prefix_db_lookup#.pEmployee e WHERE e.Emp_ID = '#getFiles.CreatedBy#' data-cert-start="#DateFormat(getFiles.Cert_Start, 'mm/dd/yyyy')#" data-cert-end="#DateFormat(getFiles.Cert_End, 'mm/dd/yyyy')#" data-cert-key="custom_#DateFormat(getFiles.Cert_Start, 'mmddyyyy')#_#DateFormat(getFiles.Cert_End, 'mmddyyyy')#" >
Document Type Placeholder File Name Title For File Notes Expires Uploaded By Uploaded Date Fax Timestamp Action Send Fax
#getFiles.Docdescription#* required 		#getFiles.FileName#
#getFiles.Title#Click to edit (optional)
#getFiles.Notes#Click to edit (optional) 		SELECT * FROM #Request.prefix_db_agency#.pAssessments WHERE Patient_ID = '#session.cs.patientid#' AND Status = 0 SELECT * FROM get_assessment WHERE Assmt_ID = '#getFiles.Assessment#'
#getFiles.Expires#* required		 #getFilesDetails.Emp_Last#, #getFilesDetails.Emp_First# #DateFormat(getFiles.Created, 'mm/dd/yyyy')# fax sent to #faxsend_to# on #dateTimeFormat(faxsent_time, "short")# View Edit Disabled Processed data-vertex-task-id="#vertexJobTaskId#" data-vertex-job-row-id="#vertexJobRowId#" data-vertex-job-status="#vertexJobStatus#">#vertexActionText# title="Vertex job status: #htmlEditFormat(vertexJobStatus)#">#vertexJobStatusLabel# Task ID: #htmlEditFormat(vertexJobTaskId)# Processing... Delete Send Fax
No Files have been Uploaded
Photo Title Title For File Notes Visit Date Uploaded By Skill Upload Date Fax Timestamp Action
#getpgFiles.FileName#
#getpgFiles.Title#Click to edit (optional)
#getpgFiles.Notes#Click to edit (optional) 		#DateFormat(getpgFiles.Visit_Date, 'mm/dd/yyyy')# #getpgFiles.Emp_Last#, #getpgFiles.Emp_First# #getpgFiles.Skill# #DateFormat(getpgFiles.Created, 'mm/dd/yyyy')# fax sent to #faxsend_to# on #dateTimeFormat(faxsent_time, "short")# View Edit Delete Send Fax
Document Type Photo Title Title For File Notes Assessments Uploaded By Upload Date Fax Timestamp Action
#getpgFiles1.Docdescription#* required 		#getpgFiles1.FileName#
#getpgFiles1.Title#Click to edit (optional)
#getpgFiles1.Notes#Click to edit (optional) 		#F26#(#DateFormat(F177, 'mm/dd/yyyy')# - #DateFormat(F178, 'mm/dd/yyyy')#) #getpgFiles1.Emp_Last#, #getpgFiles1.Emp_First# #DateFormat(getpgFiles1.Created, 'mm/dd/yyyy')# fax sent to #faxsend_to# on #dateTimeFormat(faxsent_time, "short")# View Edit Delete Send Fax
Action Document Type Title For File Fax Timestamp From Fax Number To Fax Number Actions Source
Received Fax #file_name#— #completed_timestamp# #originating_fax_number# #originating_fax_tsid# Download View Re-fax

Processing Vertex API request…