SELECT pPatients.Patient_ID, pPatients.Pt_First, pPatients.Pt_Last, pPatients.Pt_Middle ,IFNULL(pAssessments.Admit_ID,0) AS Admit_ID,IFNULL(pAssessments.AutoAssmt_ID,0) AS 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,pAdmit.Admit_Type ,0 AS Admit_ID, 0 AS AutoAssmt_ID, '' AS F26, 0 AS Assmt_ID, "" AS Cert_Start, "" AS Cert_End ,0 as Admission_Status, "" AS M0030_START_CARE_DT, "" AS Admit_Type FROM #Request.prefix_db_agency#.pPatients JOIN #Request.prefix_db_agency#.pAssessments ON pAssessments.Patient_ID = pPatients.Patient_ID JOIN #Request.prefix_db_agency#.pAdmit ON pAdmit.Admit_ID = pAssessments.Admit_ID AND pAdmit.status = 0 WHERE pPatients.Patient_ID = AND pPatients.status = AND pAssessments.Assmt_ID = AND pAssessments.status = SELECT * FROM #Request.prefix_db_agency#.pAuths WHERE status = AND Auth_ID = request.authorization = CreateObject("component","components.general.authorization").init() authorizations = request.authorization.getauthorizationslist(#URL.AID#); SELECT * FROM authorizations WHERE status = AND Auth_ID =

No authorization data found for Auth_ID: #URL.authid#

auth_measure field is missing from authorization data

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 = 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,pAssessments.Admit_ID FROM #Request.prefix_db_agency#.pAssessments WHERE pAssessments.Patient_ID = AND pAssessments.Assmt_ID = 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.F176, pAssessments.F25 AS Admission_Status FROM #Request.prefix_db_agency#.pAssessments WHERE pAssessments.Patient_ID = AND pAssessments.Admit_ID = AND pAssessments.status = AND (pAssessments.F26 like '1%' OR pAssessments.F26 like '4 - Recertification%') ORDER BY pAssessments.F178 DESC SELECT pSchedules.Schedule_ID FROM #Request.prefix_db_agency#.pSchedules INNER 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.Followup_visit = 1 AND IFNULL(pSchedules.Missed, 0) > 0 AND pSchedules.Visit_Type IS NOT NULL AND TRIM(pSchedules.Visit_Type) <> '' LIMIT 1 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.HCPCS_ID, pSchedules.StartTime, pSchedules.EndTime, pSchedules.Assmt_ID, pSchedules.Notes, pSchedules.prn_visit, pSchedules.prn_reason 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' AND Emp_ID > 50 AND (Skill_1 like '#getassessments.Skill#%' OR Skill_1 like 'LPN%') GROUP BY Emp_ID ORDER BY Status, Emp_Last, Emp_First request.patients = CreateObject("component","components.general.patients").init() getvisitstypes = request.patients.getvisits_types(#Admit_Type#); SELECT Emp_ID, Emp_Last, Emp_First FROM GetEI WHERE Status = AND Emp_ID > 50 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">