SELECT pEmployee.Status, pPatients.Pt_Last, pPatients.Pt_First,pEmployee.Emp_Last, pEmployee.Emp_First, pSchedules.Schedule_ID, pSchedules.Skill as Visit_Type, pSchedules.patient_sign, pSchedules.Missed,pSchedules.pgnotesdraft, pSchedules.Followup_visit,IFNULL(asseval.F25,0) AS assessmentcompletion, CASE WHEN pSchedules.Visit_Type != '' THEN pSchedules.Visit_Type ELSE 'Routine Visit' END AS VisitType, pSchedules.Progress_Note,pSchedules.Rev_ID,pSchedules.Notes as Visit_Notes,IFNULL(pSchedules.Assmt_ID,0) AS Assmt_ID,pSchedules.Pay_ID, pSchedules.StartTime, pSchedules.EndTime,pSchedules.Total_Units, pSchedules.Visit_Date,pSchedules.Patient_ID, Date_format(pAssessments.F177, '%m/%d/%Y') as Certification_Start, Date_format(pAssessments.F178, '%m/%d/%Y') as Certification_END, pSchedules.Schedules_Dup,pSchedules.pgnotesdraft, pSchedules.prn_visit FROM #Request.prefix_db_agency#.pSchedules LEFT OUTER JOIN #Request.prefix_db_agency#.pAuths ON pAuths.Auth_ID = pSchedules.Auth_ID AND pAuths.Status = 0 JOIN #Request.prefix_db_agency#.pPatients on pSchedules.Patient_ID = pPatients.Patient_ID JOIN #Request.prefix_db_agency#.pAssessments on (pSchedules.Assmt_ID = pAssessments.Assmt_ID) LEFT OUTER JOIN #Request.prefix_db_agency#.pPtPayer pPtPayer on pPtPayer.PtPayer_ID = pSchedules.PtPayer_ID AND pPtPayer.status = 0 LEFT OUTER JOIN #Request.prefix_db_agency#.pPayer pp on pPtPayer.Payer_ID = pp.Pay_ID AND pp.status = 0 AND pp.Pay_id IN (#arguments.eventpayer#) AND pp.Pay_id IN (#Session.eventpayerview#) LEFT OUTER JOIN #Request.prefix_db_lookup#.pEmployee on pSchedules.Emp_ID = pEmployee.Emp_ID AND pSchedules.Emp_ID IN (#arguments.eventemployee#) LEFT OUTER JOIN #Request.prefix_db_agency#.assessment_assign ON assessment_assign.Assmt_ID = pSchedules.Schedule_ID LEFT OUTER JOIN #Request.prefix_db_agency#.pAssessments as asseval ON assessment_assign.Assmt_ID = asseval.Assmt_ID WHERE pSchedules.Visit_Date between '#DateFormat(arguments.from_date, "yyyy-mm-dd")#' and '#DateFormat(arguments.to_date, "yyyy-mm-dd")#' WHERE (pSchedules.Visit_Date >= #CreateODBCDate(arguments.start)# AND pSchedules.Visit_Date <= #CreateODBCDate(arguments.end)#) AND pPatients.Status < AND pSchedules.Status IN (0) AND pSchedules.patient_ID IN (#Session.eventpatientview#) AND pSchedules.Emp_ID IN (#Session.eventemployeeview#) AND (((pSchedules.Skill IN (#PreserveSingleQuotes(arguments.visittype)#) ) or (pSchedules.Skill like '1%' or pSchedules.Skill like '3%' or pSchedules.Skill like '4%' or pSchedules.Skill like '5%' or pSchedules.Skill like '6%' or pSchedules.Skill like '7%' or pSchedules.Skill like '7%' or pSchedules.Skill like '8%' or pSchedules.Skill like '9%' or pSchedules.Skill like 'Hospice%' ) or (pSchedules.Skill like '%Evaluation' ) ) OR pSchedules.Skill = '') AND pEmployee.Emp_ID = #Session.EmployeeID# AND pAssessments.Status = ORDER BY Emp_First ORDER BY Pt_First ORDER BY StartTime, Pt_Last, Pt_First, Emp_Last, Emp_First SELECT pEmployee.Status, pPatients.Pt_Last, pPatients.Pt_First,pPatients.Pt_Agy_ID, pPatients.Pt_Street,pPatients.Pt_City,pPatients.Pt_State,pPatients.Pt_Zip,pPatients.Pt_Phone, pPtContacts.Pt_Realtionship,CONCAT(pPtContacts.First_Name, " ", pPtContacts.Last_Name) AS Contact_Name,pPtContacts.Telephone1,pEmployee.Emp_Last, pEmployee.Emp_First, pSchedules.Skill as Visit_Type, pSchedules.patient_sign, pSchedules.Missed,pSchedules.pgnotesdraft, pSchedules.Followup_visit,IFNULL(asseval.F25,0) AS assessmentcompletion, CASE WHEN pSchedules.Visit_Type != '' THEN pSchedules.Visit_Type ELSE 'Routine Visit' END AS VisitType, pSchedules.Emp_ID, pSchedules.Schedule_ID, pSchedules.Progress_Note,pSchedules.Rev_ID,pSchedules.Notes as Visit_Notes,pSchedules.Notes, IFNULL(pSchedules.Assmt_ID,0) AS Assmt_ID,pSchedules.Pay_ID, pSchedules.StartTime, pSchedules.EndTime,pSchedules.Total_Units, pSchedules.Visit_Date,pSchedules.Patient_ID, Date_format(pAssessments.F177, '%m/%d/%Y') as Certification_Start, Date_format(pAssessments.F178, '%m/%d/%Y') as Certification_END,pSchedules.Schedules_Dup,pSchedules.pgnotesdraft, pSchedules.prn_visit FROM #Request.prefix_db_agency#.pSchedules JOIN #Request.prefix_db_agency#.pPatients on pSchedules.Patient_ID = pPatients.Patient_ID JOIN #Request.prefix_db_agency#.pAssessments on (pSchedules.Assmt_ID = pAssessments.Assmt_ID) LEFT OUTER JOIN #Request.prefix_db_agency#.pPtPayer pPtPayer on pPtPayer.PtPayer_ID = pSchedules.PtPayer_ID AND pPtPayer.status = 0 LEFT OUTER JOIN #Request.prefix_db_agency#.pPayer pp on pPtPayer.Payer_ID = pp.Pay_ID AND pp.status = 0 AND pp.Pay_id IN (#arguments.eventpayer#) AND pp.Pay_id IN (#Session.eventpayerview#) LEFT OUTER JOIN #Request.prefix_db_agency#.pAuths ON pAuths.Auth_ID = pSchedules.Auth_ID AND pAuths.Status = 0 LEFT OUTER JOIN #Request.prefix_db_lookup#.pEmployee on pSchedules.Emp_ID = pEmployee.Emp_ID AND pSchedules.Emp_ID IN (#arguments.eventemployee#) LEFT OUTER JOIN #Request.prefix_db_agency#.assessment_assign ON assessment_assign.Assmt_ID = pSchedules.Schedule_ID LEFT OUTER JOIN #Request.prefix_db_agency#.pAssessments as asseval ON pSchedules.Assmt_ID = asseval.Assmt_ID LEFT OUTER JOIN #Request.prefix_db_agency#.pPtContacts on pPtContacts.Patient_ID = pPatients.Patient_ID AND pPtContacts.status = 0 AND pPtContacts.Emergency = 1 WHERE pSchedules.Visit_Date between '#DateFormat(arguments.from_date, "yyyy-mm-dd")#' and '#DateFormat(arguments.to_date, "yyyy-mm-dd")#' WHERE (pSchedules.Visit_Date >= #CreateODBCDate(arguments.start)# AND pSchedules.Visit_Date <= #CreateODBCDate(arguments.end)#) AND pSchedules.Emp_ID = pEmployee.Emp_ID AND pEmployee.Status < 2 AND pSchedules.status = 0 AND pSchedules.patient_ID IN (#Session.eventpatientview#) AND pSchedules.Emp_ID IN (#Session.eventemployeeview#) AND ( ( ( pSchedules.Skill IN (#PreserveSingleQuotes(arguments.visittype)#)) or (pSchedules.Skill like '1%' or pSchedules.Skill like '3%' or pSchedules.Skill like '4%' or pSchedules.Skill like '5%' or pSchedules.Skill like '6%' or pSchedules.Skill like '7%' or pSchedules.Skill like '7%' or pSchedules.Skill like '8%' or pSchedules.Skill like '9%' or pSchedules.Skill like 'Hospice%' ) or (pSchedules.Skill like '%Evaluation' ) ) OR pSchedules.Skill = '') AND pEmployee.Emp_ID = AND pAssessments.Status = 0 AND pPatients.Status < Group by pSchedules.Schedule_ID ORDER BY Emp_First ORDER BY Pt_First ORDER BY StartTime, Pt_Last, Pt_First, Emp_Last, Emp_First pgcfc = CreateObject("Component", "components.general.progressnotes"); retiredschedules = pgcfc.retire_schedules('#arguments.Schedule_ID#'); UPDATE #Request.prefix_db_agency#.pSchedules SET patient_sign = , Date_Change = , Change_by = WHERE Schedule_ID = AND Status = 0 SELECT * FROM #Request.prefix_db_agency#.pSchedules WHERE Schedule_ID = AND Status = UPDATE #Request.prefix_db_agency#.pSchedules SET clin_fix = WHERE Schedule_ID = AND Status =