SELECT PCR_Status, Verifed FROM #Request.prefix_db_agency#.PCR WHERE Assmt_ID = AND PCR_ID = AND Status = 0 UPDATE #Request.prefix_db_agency#.PCR SET Face_to_Face = , Plan_Care = , OASIS = , PT_Assessment = , OT_Assessment = , ST_Assessment = , Visit_completion = , Verifed = , PCR_Status = , submitted_date = , submitted_date = , record_timestamp = WHERE Assmt_ID = AND PCR_ID = AND Status = 0 UPDATE #Request.prefix_db_agency#.PCR set Status = 2 WHERE Status = 0 SELECT * FROM #Request.prefix_db_agency#.PCR WHERE Assmt_ID = AND Patient_ID = AND Episode = AND Status = 0 ORDER BY PCR_ID DESC UPDATE #Request.prefix_db_agency#.PCR SET Status = 2, record_timestamp = WHERE Assmt_ID = AND Patient_ID = AND Episode = AND Status = 0 AND PCR_ID <> SELECT * FROM #Request.prefix_db_agency#.PCR WHERE Assmt_ID = AND Patient_ID = AND Episode = AND Status = 0 ORDER BY PCR_ID DESC INSERT INTO #Request.prefix_db_agency#.PCR( Patient_ID,Assmt_ID,Status,Cert_Start,Cert_End,Face_to_Face,Plan_Care,OASIS,PT_Assessment,OT_Assessment,ST_Assessment,Episode,Visit_completion,Verifed,PCR_Status,Created_by,Date_Create,record_timestamp ) VALUES( , , , , , , , , , , , , , , , , , ) UPDATE #Request.prefix_db_agency#.PCR SET Face_to_Face = , Plan_Care = , OASIS = , PT_Assessment = , OT_Assessment = , ST_Assessment = , Visit_completion = , Episode = , record_timestamp = WHERE Assmt_ID = AND PCR_ID = AND Patient_ID = AND Status = 0 SELECT id, Title, DocumentDesc.Description AS Docdescription,FileName,Created,PatientId,CreatedBy,files.placeholder, files.Notes,files.faxsend_to,files.faxsent_time, Assessment,files.DOC_ID,files.Expires FROM #Request.prefix_db_agency#.files LEFT OUTER JOIN #Request.prefix_db_agency#.DocumentDesc ON files.DOC_ID = DocumentDesc.DOC_ID WHERE AgencyId = '#session.AgencyId#' AND PatientId = '#arguments.Patient_ID#' AND Status = 0 AND CreatedBy = '#Session.EmployeeID#' GROUP BY files.id ORDER BY id SELECT * FROM #Request.prefix_db_agency#.DocumentDesc WHERE DocumentType like '%Patient%' AND Required = 1 ORDER BY DOC_ID SELECT pCMS4857.Order_ID, pAssessments.Patient_ID, pAssessments.F26, pCMS4857.Certification_From AS Cert_Start , pCMS4857.Certification_To AS Cert_End, pCMS4857.Form_Type,pCMS4857.Form_Status,pAssessments.F176 AS Assesment_completed , pCMS4857.Date_Create, pCMS4857.Clinician_Signature, ".." AS Addendum_Details_21, "" AS pcp_notification, pAssessments.F26 AS Assessment_Reason_M0100,pCMS4857.* FROM #Request.prefix_db_agency#.pCMS4857, #Request.prefix_db_agency#.pAssessments, #Request.prefix_db_agency#.pPatients WHERE pCMS4857.Status = 0 And (pCMS4857.Form_Type like '%Form%' or pCMS4857.Form_Type like '%60-day%' or pCMS4857.Form_Type like '%14-day%' or pCMS4857.Form_Type like '%Discharge-Summary%') AND pAssessments.Assmt_ID = pCMS4857.Assmt_ID AND pPatients.Patient_ID = pAssessments.Patient_ID AND pPatients.Patient_ID = '#arguments.Patient_ID#' And pAssessments.status = 0 And pPatients.status < 2 And pAssessments.Patient_ID = #arguments.Patient_ID# AND pAssessments.Admit_ID = #arguments.Admit_ID# AND ( '#session.EmployeeId#' IN ( select distinct Emp_ID from #Request.prefix_db_agency#.pSchedules where patient_id = pAssessments.Patient_ID and Status = 0 ) ) GROUP BY pCMS4857.Order_ID Order By Cert_Start Desc 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 = '#arguments.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 = '#arguments.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 '%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 = #arguments.Patient_ID# GROUP BY Order_ID SELECT * FROM #Request.prefix_db_agency#.pAssessments WHERE Admit_ID = '#arguments.Admit_ID#' AND status = 0 AND F25 = 1 SELECT pSchedules.Schedule_ID, pSchedules.Assmt_ID, pSchedules.Visit_Date, pSchedules.Visit_Type, pSchedules.Skill FROM #Request.prefix_db_agency#.pSchedules JOIN #Request.prefix_db_agency#.pAssessments ON pAssessments.Assmt_ID = pSchedules.Assmt_ID AND pAssessments.Status = 0 WHERE pSchedules.Patient_ID = AND pAssessments.Admit_ID = AND pSchedules.Status = 0 AND pSchedules.Progress_Note = 'Yes' AND (pSchedules.Missed = 0 OR pSchedules.Missed = 'No' OR pSchedules.Missed = '') ORDER BY pSchedules.Visit_Date DESC, pSchedules.Schedule_ID DESC SELECT * FROm #Request.prefix_db_lookup#.Received_faxes WHERE Received_faxes.Agency_ID = #session.agencyid# AND Patient_ID = #arguments.Patient_ID# AND status = 0 ORDER BY Received_faxes.completed_timestamp DESC

Face to Face

SELECT e.Emp_Last, e.Emp_First FROM #Request.prefix_db_lookup#.pEmployee e WHERE e.Emp_ID = '#getfiles.CreatedBy#'

Document Type	File Name	Uploaded By	Upload Date	Action
#getfiles.Title#	#getfiles.FileName#	#getfilesDetails.Emp_Last#, #getfilesDetails.Emp_First#	#DateFormat(getfiles.Created, 'mm/dd/yyyy')#	Print
#getfiles.Docdescription#* required	#getfiles.FileName# Download	#getfilesDetails.Emp_Last#, #getfilesDetails.Emp_First#	#DateFormat(getfiles.Created, 'mm/dd/yyyy')#	Print

Orders

Certification	Type	Order	Action
#DateFormat(Assesment_completed,"mm/dd/yyyy")# #DateFormat(Cert_Start,"mm/dd/yyyy")#-#DateFormat(Cert_End,"mm/dd/yyyy")#	#Form_Type#	#Form_Type#	#Form_Type#	#pcp_notification# Notification #Form_Type# #Form_Type# #Form_Type# #Form_Type# #Form_Type#	#LEFT(Order_description, 60)#... #LEFT(Order_description, 60)#... #LEFT(Careplan_SN, 60)#... #LEFT(Order_description, 60)#... #LEFT(Careplan_SN, 60)#...	Print	Print	Print	SELECT * FROM #Request.prefix_db_lookup#.Received_faxes WHERE Order_ID = AND Agency_ID = Print Print Print Print

Progress Notes

Visit Date	Visit Type	Action
#DateFormat(getProgressNotes.Visit_Date, 'mm/dd/yyyy')#	#visitTypeLabel#	Print

Assessment

Document Type	Photo Title	Assessments	Employee	Upload Date	Fax Sent Date/Time	Action
#getpgfiles1.Docdescription#* required	#getpgfiles1.FileName#	#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")#	Download

OASIS

Certification	Assessment Type	Action
#DateFormat(F176, 'mm/dd/yyyy')# - #DateFormat(F177, 'mm/dd/yyyy')#	#F26#	Print Print Print Print Print Print Print Print Print Print Print

SELECT * FROM #Request.prefix_db_agency#.PCR WHERE PCR_ID = AND Assmt_ID = AND Status = 0 UPDATE #Request.prefix_db_agency#.PCR SET UTN = WHERE Status = 0 AND Assmt_ID = AND PCR_ID = UPDATE #Request.prefix_db_agency#.pAssessments SET F290 = F291 = WHERE Status = 0 AND Assmt_ID = UPDATE #Request.prefix_db_agency#.PCR SET PCR_Status = WHERE Status = 0 AND Assmt_ID = AND PCR_ID =