SELECT pSchedules.Schedule_ID,pSchedules.Patient_ID,pSchedules.Auth_ID, pSchedules.Mileage, pSchedules.Mi_Pay,pSchedules.Missed, pSchedules.Progress_Note, pSchedules.Emp_ID, pSchedules.Pay_ID, 0 AS Visit_Type,pSchedules.Assmt_ID, 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.Schedule_ID = AND pSchedules.status = 0 AND pSchedules.Assmt_ID = Select pPatients.Patient_ID, pPatients.Pt_First, pPatients.Pt_Last, pPatients.Pt_Middle From #Request.prefix_db_agency#.pPatients WHERE pPatients.Patient_ID = request.authorization = CreateObject("component","components.general.authorization").init() authorizations = request.authorization.getauthorizationslist(#session.Assmt_ID#); SELECT F26, Assmt_ID, F177 AS Cert_Start, F178 AS Cert_End ,F180, F25 as Admission_Status FROM #Request.prefix_db_agency#.pAssessments WHERE Patient_ID = AND status = ORDER BY F180 Desc SELECT Cert_Start AS Cert_Start1, Cert_End as Cert_End1, F26 from GetAssess where Assmt_ID = SELECT Pay_Name,Pay_ID from #Request.prefix_db_agency#.pPayer WHERE Loc_ID = AND Pay_Name <>'' and Status = and Pay_Name is not null group by Pay_Name order by Pay_Name SELECT Rev_Code, Rev_CodeID, HCPCS, Visit_Type, Payer_ID, Description FROM #Request.prefix_db_agency#.pRevenue_Code WHERE Agency_ID = And EClaim_Price IS NOT NULL And Status = And Quick_Books_Price IS NOT NULL AND Payer_ID = "GetSched.PtPayer_ID" Order by Visit_Type, HCPCS 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

Edit visit for #Pt_Last#, #Pt_First#

/patientadmin_new/index.cfm?page=patient&cat=patient"" class="remove">

Create Survey Question

Supplies

Assessment * #GetOneAssess.F26# #DateFormat(GetOneAssess.Cert_Start1, "mm/dd/yyyy")# - #DateFormat(GetOneAssess.Cert_End1, "mm/dd/yyyy")#

Visit Date

Date Format: mm/dd/yyyy

Start Time

End Time

Status: #GetAssess.Admission_Status#

Payer Name

Revenue Code

Authorizations

Search For Available Employees

Employees not scheduled during this visit time Employees who have entered their availability in MHCB Employees who have added their scheduling preferences

Employee

Survo Call

Paperwork Time use 15 for 15 minutes, 30 for 30 minutes etc

Mileage use 15 for 15 minutes, 30 for 30 minutes etc

Travel Time

checked> Pay Mileage

Notes

Missed?

checked> Yes checked> No

Progress Note?

checked> Yes checked> No


Create a New Patient Satisfaction Survey Question

Question :

Question Type: