Debug Form Data:
hdnempdata = "#Form.hdnempdata#"
Form keys = "#StructKeyList(Form)#"
Form.hdnempdata type = "#GetMetadata(Form.hdnempdata).getName()#"

SELECT soc.F81, soc.F34 FROM #Request.prefix_db_agency#.pAssessments soc INNER JOIN #Request.prefix_db_agency#.pAssessments curr ON curr.Admit_ID = soc.Admit_ID AND curr.Status = 0 WHERE curr.Assmt_ID = AND soc.Status = 0 AND soc.F26 LIKE '1%' ORDER BY soc.Assmt_ID ASC LIMIT 1 request.authorization = CreateObject("component","components.general.authorization").init() authorizations = request.authorization.getauthorizationslist(#Form.Assmt_ID_Temp#); SELECT * FROM authorizations WHERE status = AND Auth_ID = SELECT F177 AS Cert_Start, F178 AS Cert_End FROM #Request.prefix_db_agency#.pAssessments WHERE Assmt_ID = AND Status = 0

Certification Period Violation

Visit date #DateFormat(edate, "mm/dd/yyyy")# must fall within the certification period (#DateFormat(GetCertDates.Cert_Start, "mm/dd/yyyy")# - #DateFormat(GetCertDates.Cert_End, "mm/dd/yyyy")#)

Over-Scheduling Detected

#overSchedulingResult#

Please adjust the visit duration or select a different authorization.

SELECT * FROM #Request.prefix_db_agency#.pRevenue_Code WHERE Rev_CodeID = AND Status = 0 LIMIT 1 SELECT * FROM #Request.prefix_db_agency#.pRevenue_Code WHERE Rev_CodeID IN (SELECT Rev_ID FROM #Request.prefix_db_agency#.pAuths WHERE Auth_ID IN () AND Status = 0 GROUP BY Auth_ID ) SELECT * FROM #Request.prefix_db_agency#.pAuths WHERE Auth_ID IN () AND Status = 0 GROUP BY Auth_ID SELECT IFNULL(MAX(Schedule_ID),0)+1 As pSchedule_ID FROM #Request.prefix_db_agency#.pSchedules SELECT IFNULL(MAX(Visit_no),0)+1 As pVisit_no FROM #Request.prefix_db_agency#.pSchedules WHERE Patient_ID = AND Assmt_ID = AND Skill = AND status = INSERT INTO #Request.prefix_db_agency#.pSchedules( Schedule_ID, Patient_ID, Assmt_ID, Auth_ID, PtPayer_ID, Rev_ID,HCPCS_ID, Emp_ID, Pay_ID, Skill, Visit_no, Status, Nonbillable, Missed, Visit_Date, StartTime, EndTime, Total_Units, Mi_Pay, Mileage, Travel, Paperwork, Progress_Note, Notes,Schedule_Notes, homebound, Sch_Latitude,Sch_Longitude, Date_Create, Created_by, Date_Change, Change_by ) VALUES ( , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , ) request.authorization = CreateObject("component","components.general.authorization").init() authorizations = request.authorization.getauthorizationslist(#form.Assmt_ID_Temp#); SELECT * FROM authorizations WHERE status = AND Auth_ID = SELECT * FROM #Request.prefix_db_agency#.pSchedules WHERE status = AND Auth_ID = AND Missed = 0 SELECT pAdmit.Admit_Type FROM #Request.prefix_db_agency#.pAssessments LEFT JOIN #Request.prefix_db_agency#.pAdmit ON pAssessments.Admit_ID = pAdmit.Admit_ID AND pAdmit.Status = 0 WHERE pAssessments.Assmt_ID = AND pAssessments.Status = 0 UPDATE #Request.prefix_db_agency#.pSchedules SET prn_visit = 1 WHERE Auth_ID = AND Status = 0 AND Assmt_ID = ORDER BY Visit_no DESC LIMIT #diff_vists# request.ass = CreateObject("component","components.general.assessments").init(); getassment = request.ass.get_assessments(#Patient_ID#,#Assmt_ID#); SELECT * FROM #Request.prefix_db_agency#.pAssessments WHERE Assmt_ID = AND Status = 0 ORDER BY AutoAssmt_ID DESC

Scheduling Problem

You must select at least one date to schedule.

Please click the Back button in your browser to correct the problem.

Scheduling Problem

For an Admission Visit, you can only specify one visit date.

Please click the Back button in your browser to correct the problem.

Scheduling Problem

One of the dates you specified is outside the Certification Period.

Please click the Back button in your browser to correct the problem.