SELECT pPatients.Patient_ID, pPatients.Pt_First, pPatients.Pt_Last, pPatients.Pt_Middle,pAssessments.Admit_ID,pAssessments.AutoAssmt_ID,pAssessments.F26, pAssessments.Assmt_ID, pAssessments.F177 AS Cert_Start, pAssessments.F178 AS Cert_End ,pAssessments.F180, pAssessments.F25 as Admission_Status, pAdmit.M0030_START_CARE_DT FROM #Request.prefix_db_agency#.pPatients JOIN #Request.prefix_db_agency#.pAdmit ON pAdmit.Patient_ID = pPatients.Patient_ID AND pAdmit.status = 0 LEFT OUTER JOIN #Request.prefix_db_agency#.pAssessments ON pAssessments.Patient_ID = pPatients.Patient_ID WHERE pPatients.Patient_ID = AND pAssessments.Assmt_ID = AND pPatients.status = AND pAssessments.status = SELECT pAssessments.F26,pAssessments.F26 AS Assessment_Reason_M0100, pAssessments.Assmt_ID, pAssessments.F177 AS Cert_Start, pAssessments.F178 AS Cert_End ,pAssessments.F180, pAssessments.F25 AS Admission_Status FROM #Request.prefix_db_agency#.pAssessments WHERE pAssessments.Patient_ID = AND pAssessments.status = request.authorization = CreateObject("component","components.general.authorization").init() authorizations = request.authorization.getauthorizationslist(#URL.AID#); SELECT * FROM authorizations WHERE status = SELECT pSchedules.Schedule_ID,pSchedules.Patient_ID,pSchedules.Auth_ID, pSchedules.Mileage, pSchedules.Mi_Pay,pSchedules.Missed, pSchedules.Nonbillable, pSchedules.Progress_Note, pSchedules.Emp_ID, pSchedules.Pay_ID, 0 AS Visit_Type, pSchedules.SuperVision,pSchedules.Initial_visit,pSchedules.Followup_visit,pSchedules.Visit_Type, pSchedules.Paperwork, pSchedules.Travel, pSchedules.PtPayer_ID, pSchedules.Rev_ID, pSchedules.Visit_Date, pSchedules.StartTime, pSchedules.EndTime, pSchedules.Assmt_ID, pSchedules.Notes From #Request.prefix_db_agency#.pSchedules Where pSchedules.Patient_ID = AND pSchedules.Assmt_ID = AND pSchedules.status < 1 SELECT * From Getschedule Where Schedule_ID = SELECT Emp_ID, Emp_Last, Emp_First, Status, Loc_ID, Emp_Type FROM #Request.prefix_db_lookup#.pEmployee WHERE Loc_ID = '#session.AgencyId#' AND Status < 2 AND Emp_Type != 'Physician' GROUP BY Emp_ID ORDER BY Status, Emp_Last, Emp_First SELECT * FROM #Request.prefix_db_lookup#.assessment_answers_lookup WHERE question_id = 3 SELECT Emp_ID, Emp_Last, Emp_First FROM GetEI WHERE Status = ORDER BY Emp_Last, Emp_First SELECT Employee_Payroll.EmpPay_ID, Employee_Payroll.Emp_ID, Agency_Payroll.Visit_Type, Agency_Payroll.Description FROM #Request.prefix_db_agency#.Employee_Payroll, #Request.prefix_db_agency#.Agency_Payroll WHERE Agency_Payroll.Agency_ID = '#session.AgencyID#' AND Agency_Payroll.Deleted != 'Y' AND Employee_Payroll.Payroll_ID = Agency_Payroll.Payroll_ID AND Employee_Payroll.Emp_ID = '#GetSched.Emp_ID#' AND Employee_Payroll.Deleted != 'Y' ORDER BY Employee_Payroll.Emp_ID, Agency_Payroll.Visit_Type, Agency_Payroll.Description

Edit Add Visit for #Getpat.Pt_Last#, #Getpat.Pt_First#

Supplies Return to chart

style="display:none">