SELECT pSchedules.* FROM #Request.prefix_db_agency#.pSchedules WHERE Schedule_ID = AND status = 0 UPDATE #Request.prefix_db_agency#.pProgress t1, #Request.prefix_db_agency#.pProgress t2 SET t1.Status = 5 WHERE t1.Progress_ID < t2.Progress_ID AND t1.Schedule_ID = t2.Schedule_ID AND t1.Status = 0 AND t2.Status = t1.Status AND t1.Schedule_ID = AND (t1.Careplan_ID = t2.Careplan_ID OR (SUBSTRING(t1.Description, 7) = SUBSTRING(t2.Description, 7))) AND t1.Description like '##%' AND t1.Careplan_ID > 0 SELECT COUNT(CASE WHEN Type = 'goal' || Description like 'GG%' THEN 1 END) AS goal_count, COUNT(CASE WHEN Type = 'procedure' THEN 1 END) AS procedure_count, COUNT(CASE WHEN Type = 'problem' THEN 1 END) AS problem_count, COUNT(CASE WHEN Type = 'vital' THEN 1 END) AS vital_count FROM #Request.prefix_db_agency#.pProgress WHERE Schedule_ID = AND Status = 0 UPDATE #Request.prefix_db_agency#.pProgress SET Status = 6, Date_Change = , Change_by = WHERE Schedule_ID = AND Status = 0 SELECT * FROM #Request.prefix_db_agency#.pAssessments WHERE Assmt_ID = '#URL.AID#' SELECT Assmt_ID FROM #Request.prefix_db_agency#.pAssessments WHERE Admit_ID = AND status = 0 UPDATE #Request.prefix_db_agency#.pProgress pp INNER JOIN #Request.prefix_db_agency#.pProblem pr ON pp.Careplan_ID = pr.Problem_ID SET pp.Description = pr.Description, pp.Careplan_ID = pr.Problem_ID WHERE pp.Schedule_ID = AND pp.Status = 0 AND pr.Status = 0 AND pp.Description LIKE '##%' AND pp.Careplan_ID > 0 AND pp.Type = 'problem' AND pr.Assmt_ID IN () UPDATE #Request.prefix_db_agency#.pProgress pp INNER JOIN #Request.prefix_db_agency#.pProblem pr ON SUBSTRING(pp.Description, 7) = SUBSTRING(pr.Description, 7) SET pp.Description = pr.Description, pp.Careplan_ID = pr.Problem_ID WHERE pp.Schedule_ID = AND pp.Status = 0 AND pr.Status = 0 AND pp.Description LIKE '##%' AND pp.Careplan_ID > 0 AND pp.Type = 'problem' AND pr.Assmt_ID IN () AND pp.Careplan_ID != pr.Problem_ID ---> SELECT pProgress.* FROM #Request.prefix_db_agency#.pProgress WHERE pProgress.Assmt_ID = AND pProgress.Schedule_ID = AND pProgress.Status = GROUP BY pProgress.Progress_ID SELECT pSchedules.* FROM #Request.prefix_db_agency#.pSchedules WHERE pSchedules.Patient_ID = "#get_schedule.Patient_ID#" AND pSchedules.Visit_Date < '#get_schedule.Visit_Date#' AND pSchedules.Visit_Type IS NULL AND pSchedules.Skill = '#get_schedule.Skill#' AND pSchedules.Missed = 0 AND pSchedules.Status = AND pSchedules.Assmt_ID IN (SELECT pAssessments.Assmt_ID FROM #Request.prefix_db_agency#.pAssessments JOIN #Request.prefix_db_agency#.pAdmit ON pAdmit.Admit_ID = pAssessments.Admit_ID AND pAdmit.status = 0 WHERE pAssessments.Patient_ID = "#get_schedule.Patient_ID#" AND pAssessments.status = 0 ) ORDER BY Visit_Date DESC SELECT * FROM #Request.prefix_db_agency#.pProgress WHERE status = 0 AND Assmt_ID IN (SELECT pAssessments.Assmt_ID FROM #Request.prefix_db_agency#.pAssessments JOIN #Request.prefix_db_agency#.pAdmit ON pAdmit.Admit_ID = pAssessments.Admit_ID AND pAdmit.status = 0 WHERE pAssessments.Patient_ID = "#get_schedule.Patient_ID#" AND pAssessments.status = 0 ) AND healing_stage LIKE '%healed%' SELECT * FROM #Request.prefix_db_agency#.pProblem WHERE status = 0 AND Assmt_ID = (#URL.AID#) AND status = 0 AND M0_No IN ('wound','SK') AND Description like '##%' AND Problem_ID NOT IN ( SELECT Careplan_ID FROM #Request.prefix_db_agency#.pProgress WHERE pProgress.Assmt_ID = AND pProgress.Schedule_ID = AND status = 0 AND Type = 'problem' AND Description like '##%' ) AND TRIM(SUBSTRING(Description, LOCATE('-', description) + 1)) NOT IN ( SELECT TRIM(SUBSTRING(Description, LOCATE('-', description) + 1)) FROM #Request.prefix_db_agency#.pProgress WHERE pProgress.Assmt_ID = AND pProgress.Schedule_ID = AND status = 0 AND Type = 'problem' AND Description like '##%' ) AND Problem_ID NOT IN (#resolved_wounds_id#) AND Description NOT IN ( ) GROUP BY Problem_ID,Description INSERT IGNORE INTO #Request.prefix_db_agency#.pProgress ( Careplan_ID,Assmt_ID, Item_ID, Schedule_ID, Type, Description,Status,Visit_no, Date_Create, Created_by, Date_Change, Change_by ) VALUES ( , , , , , , , , , , , ) 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.M1100_PTNT_LVG_STUTN, pAssessments.F310 AS vital_omit ,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 M1100_PTNT_LVG_STUTN, 0 AS vital_omit 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 IN (0,1,4) AND pAssessments.Assmt_ID = AND pAssessments.status = SELECT Assmt_ID, pAssessments.Admit_ID, F25, F26,F27, F34, F81, F37, F38, F47,F49,F240, F82, F138, F83, F139, F73, F72, F140, F143,F177,F178,F176, F223,F296,F297,F300,F301,F302,F303,F304,F305,F322,pAssessments.Record_Created_By,F40, CASE WHEN LEFT(F26,1) = '4' THEN IFNULL(F40,0) WHEN LEFT(F26,2) = 'OT' THEN IFNULL(F38,0) WHEN F26 = 'SN Adult Evaluation' THEN IFNULL(F47,0) ELSE IFNULL(F34,0) END AS M1700, CASE WHEN (LEFT(F26,1) = '1' OR LEFT(F26,1) = '4') THEN IFNULL(F72,0) WHEN F26 = 'SN Adult Evaluation' THEN IFNULL(F49,0) ELSE IFNULL(F240,0) END AS M2102d, IFNULL(LEFT(F82,1),0) AS GG0100A, IFNULL(LEFT(F83,1),0) AS GG0100B FROM #Request.prefix_db_agency#.pAssessments WHERE pAssessments.Patient_ID = AND pAssessments.Admit_ID = AND (pAssessments.F26 like '1%' OR pAssessments.F26 like '4%' OR pAssessments.F26 like '%Eval%') AND pAssessments.status = 0 ORDER BY F27 ASC,pAssessments.F177 DESC ORDER BY pAdmit.AutoAdmit_ID DESC ---> 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,pAdmit.Admit_Type FROM #Request.prefix_db_agency#.pAssessments JOIN #Request.prefix_db_agency#.pAdmit ON pAdmit.Admit_ID = pAssessments.Admit_ID AND pAdmit.status = 0 WHERE pAssessments.Patient_ID = AND pAssessments.status = SELECT * FROM #Request.prefix_db_agency#.pAssessments LEFT OUTER JOIN #Request.prefix_db_agency#.pPatients ON pAssessments.Patient_ID = pPatients.Patient_ID WHERE pPatients.Loc_ID = AND pAssessments.Patient_ID = AND pAssessments.status = 0 AND pAssessments.Admit_ID = AND pPatients.status < 2 Order By F176 ASC SELECT pSchedules.*, pSchedules.Skill AS Skill, pSchedules.Skill, pSchedules.EVV_Reason_Code_ID, pSchedules.Paperwork, pSchedules.Travel, pSchedules.PtPayer_ID, pSchedules.Rev_ID, pSchedules.Visit_Date,IFNULL(pSchedules.Initial_visit,0) AS Initialvisit, pSchedules.StartTime, pSchedules.EndTime, pSchedules.Assmt_ID,pAssessments.F26 AS Assessment_Reason_M0100,pAssessments.F177 AS Cert_Start, pAssessments.F178 AS Cert_End, pAssessments.F304,pAssessments.F305,pAssessments.F306, pSchedules.Notes,IFNULL(pAssessments.AutoAssmt_ID,0) AS AutoAssmt_ID , IFNULL(pAssessments.Admit_ID,0) AS Admit_ID , CASE WHEN pSchedules.Skill = "SN" THEN pAssessments.F301 WHEN pSchedules.Skill = "PT" THEN pAssessments.F302 WHEN pSchedules.Skill = "OT" THEN pAssessments.F303 ELSE 0 END AS Goals_per_visit , CASE WHEN (pSchedules.Visit_Type = "1 - SOC - SN") THEN '1 - Start of care - further visits planned' WHEN (pSchedules.Visit_Type = "1 - SOC - PT" ) THEN '1 - Start of care - further visits planned - Physical Therapy' WHEN (pSchedules.Visit_Type = "1 - SOC - OT" ) THEN '1 - Start of care - further visits planned - Occupational Therapy' WHEN (pSchedules.Visit_Type = "3 - ROC - SN" || pSchedules.Visit_Type = "3 - ROC - PT") THEN '3 - Resumption of care (after inpatient stay)' WHEN (pSchedules.Visit_Type = "PT Eval" ) THEN 'PT Adult Evaluation' WHEN (pSchedules.Visit_Type = "OT Eval" ) THEN 'OT Adult Evaluation' WHEN (pSchedules.Visit_Type = "ST Eval" ) THEN 'ST Adult Evaluation' WHEN (pSchedules.Visit_Type = "SN Eval" ) THEN 'SN Adult Evaluation' WHEN (pSchedules.Visit_Type = "MSW Eval" ) THEN 'MSW Evaluation' WHEN (pSchedules.Visit_Type = "PT FU Eval" ) THEN 'PT Followup' WHEN (pSchedules.Visit_Type = "OT FU Eval" ) THEN 'OT Followup' WHEN (pSchedules.Visit_Type = "ST FU Eval" ) THEN 'ST Followup' WHEN (pSchedules.Visit_Type = "MSW FU Eval" ) THEN 'MSW Followup' WHEN (pSchedules.Visit_Type = "SN FU Eval" ) THEN 'SN Followup' WHEN (pSchedules.Visit_Type = "Hospice Comprehensive" ) THEN 'Hospice Comprehensive' WHEN (pSchedules.Visit_Type = "SN Hospice" ) THEN 'SN Hospice' WHEN (pSchedules.Visit_Type = "Chaplain Comprehensive Evaluation" ) THEN 'Chaplain Comprehensive Evaluation' WHEN (pSchedules.Visit_Type = "Hospice Discharge" ) THEN 'Hospice Discharge' WHEN (pSchedules.Visit_Type = "4 - Recertification" ) THEN '4 - Recertification (follow-up) reassessment' WHEN (pSchedules.Visit_Type = "4 - Recertification PT" ) THEN '4 - Recertification (follow-up) reassessment - PT' WHEN (pSchedules.Visit_Type = "4 - Recertification OT" ) THEN '4 - Recertification (follow-up) reassessment - OT' WHEN (pSchedules.Visit_Type = "5 - Other follow-up" ) THEN '5 - Other follow-up' WHEN (pSchedules.Visit_Type = "6 - Transfer no discharge" ) THEN '6 - Transferred to an inpatient facility - patient not discharged from agency' WHEN (pSchedules.Visit_Type = "7 - Transfer discharged" ) THEN '7 - Transferred to an inpatient facility - patient discharged from agency' WHEN (pSchedules.Visit_Type = "8 - Death" ) THEN '8 - Death at home' WHEN (pSchedules.Visit_Type = "9 - Discharge from agency" ) THEN '9 - Discharge from agency' ELSE pSchedules.Visit_Type END AS assesments From #Request.prefix_db_agency#.pSchedules LEFT OUTER JOIN #Request.prefix_db_agency#.pAssessments ON pAssessments.Assmt_ID = pSchedules.Assmt_ID AND pAssessments.status = 0 Where pSchedules.Patient_ID = AND pSchedules.Assmt_ID = AND pSchedules.status < 1 request.patients = CreateObject("component","components.general.patients").init() getvisitstypes = request.patients.getvisits_types(#Admit_Type#); SELECT * From Getschedule Where Schedule_ID = SELECT * From GetpPtPayer WHERE PtPayer_ID = '#GetSched.PtPayer_ID#' evvManager = CreateObject("component", "components.evv.EVVStatusManager").init(); evvVisitStatus = evvManager.getEVVStatusWithChangeDetection('visits', URL.SID, evvVisitAgencyID); evvVisitAuto = CreateObject("component", "components.evv.EVVVisitAutomation").init(); evvVisitActiveJob = evvVisitAuto.getActiveJobForSchedule(URL.SID, evvVisitAgencyID); EVV_Visit_Status = evvManager.resolveVisitEVVStatusDisplay(evvVisitStatus.EVV_Status, evvVisitActiveJob); GPS_end_time -
Admit_Type -
Visit_Type -
len(GetSched.EVV_start) EQ 0 AND len(GetSched.EVV_end) EQ 0> SELECT pSchedules.* 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.Status = 0 AND pAssessments.Admit_ID = '#GetSched.Admit_ID#' AND (pSchedules.Visit_Type like '1%' OR pSchedules.Visit_Type like 'SN Pediatric Evaluation') len(getsoc.GPS_start_time) EQ 0 OR len(getsoc.GPS_end_time) EQ 0> len(GetSched.EVV_start) EQ 0> Schedule_ID -
EVV payer agency -
EVV payer required -
visitRequiresEVV -
EVV Schedules -
diff_latitude -
diff_longitude -
showsubmit -
ShowEVV -
locktime -
lockpgnotes_byEVV -
showpatsign -
 SELECT Change_Memo FROM #Request.prefix_db_lookup#.EVV_Update_Log WHERE Schedule_ID = AND Status = 0 ORDER BY COALESCE(Date_Reason_Added, Date_Create) DESC, Date_Create DESC LIMIT 1 SELECT Reason_Code_ID, Description FROM #Request.prefix_db_lookup#.EVV_Reason_Codes WHERE Status = 0 ORDER BY Reason_Code_ID SELECT * FROM getallassesmentss WHERE Assmt_ID IN (#all_assmts#) AND F27 = '#GetSched.Skill#' AND F25 = 1 SELECT * FROM getallassesmentss WHERE Admit_ID = #visitAdmit_ID# AND F27 = '#GetSched.Skill#' AND F322 like 'ma%' SELECT pSchedules.*,pAssessments.F25 From #Request.prefix_db_agency#.pSchedules JOIN #Request.prefix_db_agency#.pAssessments ON (pAssessments.Assmt_ID = pSchedules.Assmt_ID OR pSchedules.Assmt_ID = 0) AND pAssessments.status = 0 Where pSchedules.Patient_ID = AND pSchedules.status = 0 AND pSchedules.Emp_ID = AND Schedule_ID != '#URL.SID#' AND pSchedules.Assmt_ID != 0 SELECT * FROM getuserassignedvisits Where Visit_Type IS NULL AND Visit_Date < '#todaydates#' AND Schedule_ID != '#URL.SID#' AND pgnotesdraft != 2 AND missed = 0 SELECT DISTINCT Assmt_ID FROM getuserassignedvisits Where Visit_Type IS NOT NULL AND F25 = 1 SELECT * FROM #Request.prefix_db_agency#.pCareplan WHERE Assmt_ID IN (#visit_assmts#) GROUP BY Assmt_ID lockpgnotes_bycareplan -
lockpgnotes_bylatenotes -
incompleassesment -
currentdate -
Visit_Date -
evv_show_reason_prompt -
evv_prompt_manual_time -
evv_prompt_missing_signature -
request.authorization = CreateObject("component","components.general.authorization").init(); authListAssmt_ID = Val(URL.AID); if (authListAssmt_ID EQ 0 && GetSched.recordCount GT 0) { authListAssmt_ID = Val(GetSched.Assmt_ID); } authListAdmit_ID = Val(visitAdmit_ID); if (authListAdmit_ID EQ 0 && GetSched.recordCount GT 0) { authListAdmit_ID = Val(GetSched.Admit_ID); } // When Assmt_ID or Admit_ID is missing, list all authorizations for the patient (same as authorizations.cfm). if (authListAssmt_ID EQ 0 || authListAdmit_ID EQ 0) { authorizations = request.authorization.getauthorizationslist(0, 0); } else { authorizations = request.authorization.getauthorizationslist(authListAssmt_ID, authListAdmit_ID); } SELECT * FROM authorizations WHERE status = 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 'LPN%' OR Skill_1 LIKE 'LVN%' OR Skill_2 LIKE 'LPN%' OR Skill_2 LIKE 'LVN%' OR Skill_3 LIKE 'LPN%' OR Skill_3 LIKE 'LVN%' (CASE WHEN Skill_1 like 'LPN%' OR Skill_1 like 'LVN%' THEN 'SN' ELSE Skill_1 END) like 'SN%' OR (CASE WHEN Skill_2 like 'LPN%' OR Skill_2 like 'LVN%' THEN 'SN' ELSE Skill_2 END) like 'SN%' OR (CASE WHEN Skill_3 like 'LPN%' OR Skill_3 like 'LVN%' THEN 'SN' ELSE Skill_3 END) like 'SN%' OR Skill_1 LIKE 'RN%' OR Skill_2 LIKE 'RN%' OR Skill_3 LIKE 'RN%' (CASE WHEN Skill_1 like 'LPN%' THEN 'SN' ELSE Skill_1 END) like '#skilltype#%' OR (CASE WHEN Skill_2 like 'LPN%' THEN 'SN' ELSE Skill_2 END) like '#skilltype#%' OR (CASE WHEN Skill_3 like 'LPN%' THEN 'SN' ELSE Skill_3 END) like '#skilltype#%' ) GROUP BY Emp_ID ORDER BY Status, Emp_Last, Emp_First 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 SELECT pCareplan.Date_Resolve,pProgress.*,pPathway.*,pProgress.Type AS ptype, IFNULL(pPathway.Value,0) AS measurevalue, pCareplan.Param_Lo,pCareplan.Param_Hi ,pCareplan.Param_other,pCareplan.Date_Target,pCareplan.AutoCareplan_ID , pCareplan.Skill, pCareplan.Notes AS pnotes,pCareplan.Goal_ID, pSchedules.Visit_Date, pCareplan.Assmt_ID As careplan_assmt_ID FROM #Request.prefix_db_agency#.pProgress LEFT OUTER JOIN #Request.prefix_db_lookup#.pPathway ON pPathway.Item_ID = pProgress.Item_ID AND pPathway.Type = pProgress.Type LEFT OUTER JOIN #Request.prefix_db_agency#.pSchedules ON pProgress.Schedule_ID = pSchedules.Schedule_ID AND pSchedules.status = 0 LEFT OUTER JOIN #Request.prefix_db_agency#.pCareplan ON pCareplan.Careplan_ID = pProgress.Careplan_ID AND pCareplan.Assmt_ID = pProgress.Assmt_ID AND (pCareplan.Skill = pSchedules.Skill OR (pSchedules.Skill = 'PTA' AND pCareplan.Skill = 'PT')) AND pCareplan.Status = 0 WHERE pProgress.Assmt_ID = AND pProgress.Schedule_ID = AND pSchedules.Skill = AND pProgress.Status = AND trim(pProgress.Description) != '' GROUP BY pProgress.Progress_ID ORDER BY pPathway.Header_No , pPathway.Order_ID ASC SELECT * FROM #Request.prefix_db_agency#.pCareplan WHERE Assmt_ID = AND Status = AND Skill = SELECT * FROM getpgnotes WHERE ptype = 'vital' SELECT * FROM getcareplan WHERE Param_Lo IS NULL OR Param_Hi IS NULL SELECT * FROM #Request.prefix_db_lookup#.pPathway WHERE Item_ID IN () AND Type = AND Param = 'Lo-Hi' SELECT * FROM #Request.prefix_db_agency#.pProblem WHERE Assmt_ID = AND Status = 0 AND (M0_No like 'M1021%' OR M0_No like 'M1023%') SELECT * FROM #Request.prefix_db_agency#.pProblem WHERE Assmt_ID = AND Status = 0 AND Skill = SELECT * FROM #Request.prefix_db_agency#.pWoundsVitals WHERE Assmt_ID = AND Status = 0 AND VitalOrWound = 'vital' ORDER BY Item_ID ASC SELECT pProgress.Progress_ID, pWoundsVitals.Param_Lo, pWoundsVitals.Param_Hi, pWoundsVitals.Description FROM #Request.prefix_db_agency#.pProgress LEFT OUTER JOIN #Request.prefix_db_agency#.pWoundsVitals ON pWoundsVitals.ID = pProgress.Careplan_ID WHERE pProgress.Assmt_ID = AND pProgress.Schedule_ID = AND pProgress.Status = 0 AND pProgress.Type = 'vital' AND pWoundsVitals.Status = 0 AND pWoundsVitals.Param_Lo IS NOT NULL AND pWoundsVitals.Param_Hi IS NOT NULL SELECT * FROM getwundvitals WHERE Param_Lo IS NULL OR Param_Hi IS NULL SELECT * FROM getcareplan WHERE ( Description like 'add patient-stated goal' OR Description like 'add discharge plan' ) SELECT * FROM getcareplan WHERE ( Type = 'discharge_plan' ) SELECT * FROM #Request.prefix_db_agency#.pSched_Procedure WHERE pSched_Procedure.Schedule_ID = AND pSched_Procedure.status = 0
Alert
X
Visit has been Updated
#Getpat.Pt_Last#, #Getpat.Pt_First#
Edit Add Visit > #dateformat(GetSched.Visit_Date,'mm/dd/yy')#
Decrypted IDs: Patient_ID: #Getschedule.Patient_ID# | Schedule_ID: #Getschedule.Schedule_ID# | Assmt_ID: #Getschedule.Assmt_ID# | AutoAssmt_ID: #Getschedule.AutoAssmt_ID# | Admit_ID: #Getschedule.Admit_ID#
EVV Status: #EVV_Visit_Status# EVV automation in progress class="btn default dark-stripe btn-sm hide" class="btn default dark-stripe btn-sm" id="start_visit" onclick="GPS_track('start_visit');"> Start Visit class="btn default dark-stripe btn-sm"class="btn default dark-stripe btn-sm hide" id="stop_visit" onclick="GPS_track('end_visit');"> End Visit Stop Visit Return to chart Return to Schedules Add Incident Add Communication View careplan Supplies
style="display:none">
No Assessment
No Assessment
#DateFormat(Getschedule.Cert_Start,"mm/dd/yyyy")# - #DateFormat(Getschedule.Cert_End,"mm/dd/yyyy")#
class="col-md-2"class="col-md-2 hide" >
session.isagencylogin EQ 1 OR session.eaPgNotes EQ 1>
class="input-group date date-picker" data-date-format="mm/dd/yyyy"> SELECT Skill_1 FROM #Request.prefix_db_lookup#.pEmployee WHERE Emp_ID = AND Loc_ID = LIMIT 1 disabled class="form-control" name="Visit_Date" id="Visit_Date" value="#DateFormat(displayVisitDate,"mm/dd/yyyy")#" placeholder="Select Date" onchange="updateHCPCSByVisitDate();clearAuthorizationDateInlineError();" oninput="clearAuthorizationDateInlineError();">
Date Format: mm/dd/yyyy
disabled onmouseout="chck();" onchange="change_StartTime(this.value);check_Visit();" type="text" name="Start_Time" id="Start_Time" class="form-control timepicker timepicker-no-seconds" value="#thehour#:#theminute# #thetod#">
disabled onchange="change_EndTime(this.value);check_Visit();" onmouseout="chck();" type="text" name="End_Time" id="End_Time" class="form-control timepicker timepicker-no-seconds" value="#thehour#:#theminute# #thetod#">
SELECT * FROM #Request.prefix_db_agency#.pRevenue_Code WHERE Status = 0 AND pRevenue_Code.Payer_ID = AND ( pRevenue_Code.Rev_CodeID = OR ( pRevenue_Code.Visit_Type = pRevenue_Code.Visit_Type = pRevenue_Code.Visit_Type = ( pRevenue_Code.Visit_Type = OR pRevenue_Code.Visit_Type = OR pRevenue_Code.Visit_Type = OR pRevenue_Code.Visit_Type = OR pRevenue_Code.Visit_Type = OR pRevenue_Code.HCPCS = OR pRevenue_Code.HCPCS = OR pRevenue_Code.Description LIKE OR pRevenue_Code.Description LIKE ) ( pRevenue_Code.Visit_Type = OR pRevenue_Code.Visit_Type = ) pRevenue_Code.Visit_Type = AND pRevenue_Code.HCPCS = AND ( Contract_Rate_Effective_Date IS NULL OR Contract_Rate_Effective_Date <= ) AND ( Contract_Rate_End_Date IS NULL OR Contract_Rate_End_Date >= ) 1 = 1 ) ) ORDER BY Visit_Type, HCPCS
class="col-md-4"class="col-md-4 hide">
#GetSched.Schedule_Notes#
disabled type="text" name="Emp_ID" id="selectemployee" style="display:none" value="#Emp_ID#" class="form-control" />
#Emp_Last#, #Emp_First# disabled type="text" name="Emp_ID" id="selectemployee" style="display:none" value="#Emp_ID#"/>
#Visit_Type#- #description#
class="col-md-2" class="col-md-2 hide" >
class="col-md-2" class="col-md-2 hide" >
class="col-md-4"class="col-md-4 hide" id="divvisittype">
class="hide">
style="background-color:##FF8F8F" onkeypress="document.getElementById('Sup_1').style.backgroundColor = '';">
style="background-color:##FF8F8F" onkeypress="document.getElementById('Sup_2').style.backgroundColor = '';">
style="background-color:##FF8F8F" onkeypress="document.getElementById('Sup_3').style.backgroundColor = '';">
class="hide">
style="background-color:##FF8F8F" onkeypress="document.getElementById('Maint_1').style.backgroundColor = '';">
style="background-color:##FF8F8F" onkeypress="document.getElementById('Maint_2').style.backgroundColor = '';">
style="background-color:##FF8F8F" onkeypress="document.getElementById('Maint_3').style.backgroundColor = '';">
GetSched.Emp_ID EQ session.employeeid> SELECT * FROM #Request.prefix_db_lookup#.VBP_Analysis WHERE M1100 like AND M1700 = '#M1700#' AND M2102d = '#M2102d#'

50-character minimum for Notes field.



) >

EVV – Reason code required

This visit does not have a patient signature. Please choose a reason code as an explanation as to why a signature could not be obtained.

A reason code is required unless both the EVV start and stop buttons were used. The start or end time was entered manually, so please choose a reason code and provide a memo.

EVV – Reason code & memo (saved)

*The user should start and stop EVV and reload the page to view the submit button.

 Add patient signature SELECT * FROM #Request.prefix_db_agency#.pAssessments WHERE F176 = '#GetSched.Visit_Date#' AND F26 = '#thereason#' AND Patient_ID = '#GetSched.Patient_ID#' AND Status = 0 AND Admit_ID = '#GetSched.Admit_ID#' ORDER BY F176 DESC GetSched.Followup_Visit EQ 1 AND showsubmit EQ false AND GetSched.Emp_ID EQ session.employeeid> Please click 'Start' to activate #thereason# link #thereason# Forms
Progress Notes Update for #skilltype# Visit - #dateformat(GetSched.Visit_Date,'mm/dd/yy')#
Return to chart Return to Schedules Add Incident Add Communication View careplan Pull Resolved goals Collapse All
style="display:none" --->>
(GetSched.Followup_visit NEQ '1' OR left(currentVisitType,1) EQ '3' OR left(currentVisitType,1) EQ '4' OR left(currentVisitType,1) EQ '9' OR currentVisitType EQ 'PT FU Eval' OR currentVisitType EQ 'OT FU Eval'OR currentVisitType EQ 'ST FU Eval' OR currentVisitType EQ 'SN FU Eval' OR currentVisitType EQ 'Palliative' )>

Careplan has not been created, is missing vital sign parameters, has incomplete discharge plan or patient goals.

None of diagnosis added. Click here to add it.

 SELECT * FROM #Request.prefix_db_agency#.pSched_Procedure WHERE pSched_Procedure.Schedule_ID = AND pSched_Procedure.status = 0

Click here to create Progress Note

please wait for create progress notes loading
SELECT * FROM #Request.prefix_db_agency#.pSched_Procedure WHERE pSched_Procedure.Schedule_ID = AND pSched_Procedure.status = 0

Click here to create Progress Note

--->
>

SELECT pSchedules.*,pAssessments.Admit_ID 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.status = 0 AND pSchedules.Patient_ID = AND pSchedules.Assmt_ID = AND pSchedules.Schedule_ID =