SELECT * FROM #Request.prefix_db_lookup#.Incident i WHERE i.Incident_ID = #url.ID# SELECT * FROM #Request.prefix_db_lookup#.Incident i, #Request.prefix_db_lookup#.Employee e, #Request.prefix_db_agency#.employee_auth u, #Request.prefix_db_lookup#.Agency a WHERE e.Employee_ID = i.Employee_ID and e.Employee_ID = u.eaID AND a.Agency_ID = i.Agency_ID AND i.Incident_ID = #url.ID# SELECT * FROM #Request.prefix_db_lookup#.Employee e, #Request.prefix_db_agency#.employee_auth u, #Request.prefix_db_lookup#.Incident i WHERE e.Employee_ID = u.eaID AND e.Agency_ID = i.Agency_ID AND i.Incident_ID = #url.ID# AND e.Status = 'active' AND u.eaRole like '%Project%' SELECT * FROM #Request.prefix_db_lookup#.Employee e, #Request.prefix_db_agency#.employee_auth u, #Request.prefix_db_lookup#.Incident i WHERE e.Employee_ID = u.eaID AND e.Agency_ID = i.Agency_ID AND i.Incident_ID = #url.ID# AND e.Status = 'active' AND e.Password != '' SELECT p.Last_Name_M0040, p.First_Name_M0040 FROM #Request.prefix_db_lookup#.Employee e, #Request.prefix_db_lookup#.Incident i, #Request.prefix_db_agency#.patient p, #Request.prefix_db_agency#.Assessment_New a, #Request.prefix_db_agency#.Payer y WHERE e.Agency_ID = i.Agency_ID and i.Agency_ID = p.Agency_ID and p.Patient_ID = a.Patient_ID and a.Payer_ID = y.Payer_ID AND i.Incident_ID = #url.ID# and y.Output_Type = 'Medicare' and a.Certification_End > Now() and (a.Assessment_Reason_M0100 like '1%' or a.Assessment_Reason_M0100 like '4%') and a.Deleted = 0 Group by p.Patient_ID SELECT Topic FROM #Request.prefix_db_lookup#.IncidentTopic where Subject is null Order by Topic SELECT * FROM #Request.prefix_db_lookup#.Incident i, #Request.prefix_db_lookup#.Employee e, #Request.prefix_db_lookup#.Agency a, #Request.prefix_db_lookup#.IncidentTables t WHERE e.Employee_ID = i.Employee_ID AND a.Agency_ID = i.Agency_ID AND i.InternalMemo = '#session.InternalMemo#' and i.InternalMemo = t.TicketDropDown Group by i.Title INSERT INTO #Request.prefix_db_agency#.comm_comments ( CommId ,IncidentId ,AgencyId ,EmployeeId ,Comment ,Created ) VALUES ( '0' ,#url.ID# ,#GetIncident.Agency_ID# ,#GetIncident.Employee_ID# ,'#form.comment#' ,#CreateODBCDateTime(Now())# ) SELECT cc.* FROM #Request.prefix_db_agency#.comm_comments cc WHERE cc.IncidentId = '#url.ID#' ORDER BY cc.id ASC MyHomecareBiz.com

New Problem

Ticket Number
#GetIncident.Incident_ID#  #GetIncident.Incident#
Incident
Description
#GetIncident.WhatHappened#
Patient(s)
#GetIncident.Patient#
Who
#GetIncident.First_Name# #GetIncident.Last_Name#
#GetIncident.Agency_Name#
#GetIncident.Agency_Login#  #GetIncident.Agency_ID#
AssignedTo
Topic
Function checked> No Function checked> Add checked> Edit checked> Delete checked> View checked> Print checked> Export
Data Capture Method checked> No Method checked> MHCB checked> PowerPath checked> Telephony checked> Progress E-Z
Instructions Subject
Instructions
for manual
Language (2-3 words max)
Memo to Agency
  
Comment #GetComments.Comment#
  
Add a Comment

Related Tickets for #GetTix.InternalMemo#

Date Function Method Title Instructions
#DATEFORMAT(DateCreated,"mm/dd/yy")#
#Function#
#DataCapture#
#Title#

Project Managers

#Last_Name#, #First_Name#

Employee Metrics

Name Roles Outcomes Better Outcomes Same Outcomes Worse Utilization Rollover No # Visits No 1/4
#Last_Name#, #First_Name#
Clinical Field
#OMBetter#%
#OMSame#%
#OMWorse#%
#AVG_Utilization#%
#DE_Rollover_No#
#DE_Schedule_Wrong#

Current Assessments

Name
#Last_Name_M0040#, #First_Name_M0040#