.class" width=600 height=300>



<PARAM NAME="Title" VALUE="<CFOUTPUT>#GraphName# (i
n minutes), Date: #From#
-
#To#, Arrival Time:
#TimeFrom#:00 to #Timeto#:59</CFOUTPUT>">



<PARAM NAME="TitleFontName" VALUE="TimesRoman">


<PARAM NAME="TitleFontHeight" VALUE="13">


<PARAM NAME="ShowLegend" VALUE="yes">


<PARAM NAME="LegendFontName"

VALUE="TimesRoman">


<PARAM NAME="LegendFontHeight" VALUE="11">


<PARAM NAME="DrawBorders" VALUE="yes">


<PARAM NAME="ShowDateTime" VALUE="yes">


<PARAM NAME="Shadow" VALUE="2">



<! if statements to generate each chart based on resulting graph n
ame from above query>

<CFIF #Graph# IS "Triage_Wait">



<PARAM NAME="ChartData.Columns" VALUE="Items,Values">


<PARAM NAME="ChartData.Items" VALUE="<CFOUTPUT>#ValueList(GetTriageWait.RegistrationHour)#</CFOUTPUT>">


<PARAM NAME="ChartData.Values" VAL
UE="<CFOUTPUT>#ValueList(GetTriageWait.TriageWait)#</CFOUTPUT>">



<CFELSE>


<CFIF #Graph# IS "Room_Wait">



<<PARAM NAME="ChartData.Columns" VALUE="Items,Values">


<PARAM NAME="ChartData.Items" VALUE="<CFOUTPUT>#ValueList(GetRoomWait.RegistrationHour)
#</CFOUTPUT>">


<PARAM NAME="ChartData.Values" VALUE="<CFOUTPUT>#ValueList(GetRoomWait.RoomWait)#</CFOUTPUT>">



<CFELSE>


<CFIF #Graph# IS "Resident_Wait">



<PARAM NAME="ChartData.Columns" VALUE="Items,Values">


<PARAM NAME="ChartData.Items"
VALUE=
"<CFOUTPUT>#ValueList(GetResidentWait.RegistrationHour)#</CFOUTPUT>">


<PARAM NAME="ChartData.Values" VALUE="<CFOUTPUT>#ValueList(GetResidentWait.ResidentWait)#</CFOUTPUT>">



<CFELSE>


<CFIF #Graph# IS "Attending_Wait">



<PARAM NAME="ChartData.Column
s" VALUE="Items,Values">


<PARAM NAME="ChartData.Items"
VALUE="<CFOUTPUT>#ValueList(GetAttendingWait.RegistrationHour)#</CFOUTPUT>">


<PARAM NAME="ChartData.Values"
VALUE="<CFOUTPUT>#ValueList(GetAttendingWait.AttendingWait)#</CFOUTPUT>">



<CFELSE>


<
CFIF #Graph# IS "Interface_Wait">



<PARAM NAME="ChartData.Columns" VALUE="Items,Values">


<PARAM NAME="ChartData.Items"
VALUE="<CFOUTPUT>#ValueList(GetInterfaceWait.RegistrationHour)#</CFOUTPUT>">


<PARAM NAME="ChartData.Values" VALUE="<CFOUTPUT>#Va
lueList(GetInterfaceWait.InterfaceWait)#</CFOUTPUT>">



<CFELSE>


<CFIF #Graph# IS "Treatment_Wait">



<PARAM NAME="ChartData.Columns" VALUE="Items,Values">


<PARAM NAME="ChartData.Items"
VALUE="<CFOUTPUT>#ValueList(GetTreatmentWait.RegistrationHour)#<
/CFOUTPUT>">


<PARAM NAME="ChartData.Values"
VALUE="<CFOUTPUT>#ValueList(GetTreatmentWait.TreatmentWait)#</CFOUTPUT>">




<CFELSE>


<CFIF #Graph# IS "Disposition_Wait">



<PARAM NAME="ChartData.Columns" VALUE="Items,Values">


<PARAM NAME="ChartData.I
tems"
VALUE="<CFOUTPUT>#ValueList(GetDispositionWait.RegistrationHour)#</CFOUTPUT>">


<PARAM NAME="ChartData.Values"
VALUE="<CFOUTPUT>#ValueList(GetDispositionWait.DispositionWait)#</CFOUTPUT>">




<CFELSE>


<! start of code to graph total wait time>


<applet codebase="/Classes/CFGraphs/" code="MultiBarChart.class" width=600 height=300>

<pre>



<PARAM NAME="Title" VALUE="<CFOUTPUT>#GraphName# #From#
-
#To# (in minus) from #TimeFrom# to
#Timeto#</CFOUTPUT>">

</pre>


<PARAM NAME="TitleFontName" VALUE="
TimesRoman">


<PARAM NAME="TitleFontHeight" VALUE="13">


<PARAM NAME="ShowLegend" VALUE="yes">


<PARAM NAME="LegendFontName" VALUE="TimesRoman">


<PARAM NAME="LegendFontHeight" VALUE="11">


<PARAM NAME="DrawBorders" VALUE="yes">


<PARAM NAME="S
howDateTime" VALUE="yes">


<PARAM NAME="Shadow" VALUE="3">


<CFIF #Graph# IS "Total_Wait">



<PARAM NAME="ChartData.Columns" VALUE="Groups,Items,Values">


<PARAM NAME="ChartData.Groups" VALUE="<CFOUTPUT>#ValueList(GetTotalWait.RegistrationHour)#</CFO
UTPUT>">


<PARAM NAME="ChartData.Items" VALUE="Triage,Room,Resident,Attending,Interface,Treatment,Disposition">


<PARAM NAME="ChartData.Values" VALUE="<CFOUTPUT QUERY="GetTotalWait"> <#TriageWait#, #RoomWait#,
#ResidentWait#, #AttendingWait#, #Interfa
ceWait#, #TreatmentWait#, #DispositionWait#> </CFOUTPUT>">



</CFIF>

</applet>


</CFIF>

</CFIF>

</CFIF>

</CFIF>

</CFIF>

</CFIF>

</CFIF>


</applet>


</td></tr>

</table>


<! Comments for each bar chart to explain chart>

<CENTER>

<CFIF #Graph# IS "Triage_Wait
">


This graph represents the time a patient waited from <i>arrival</i> to the ED to <i>triage</i> time.

<CFELSE>

<CFIF #Graph# IS "Room_Wait">


This graph represents the time a patient waited from <i>triage</i> time to the time the patient w
as placed in a <i>room</i>.

<CFELSE>

<CFIF #Graph# IS "Resident_Wait">


This graph represents the time a patient waited from time in a <i>room</i> to the time a <i>resident</i> MD sees him/her.

<CFELSE>

<CFIF #Graph# IS "Attending_Wait">


Thi
s graph represents the time a patient waited from the time a <i>resident</i> MD visits to time an <i>attending</i> MD visits.

<CFELSE>

<CFIF #Graph# IS "Interface_Wait">


This graph represents the time a patient waited from an <i>attending</i> MD vi
sit to the <i>inerface</i> time for lab or x
-
ray.

<CFELSE>

<CFIF #Graph# IS "Treatment_Wait">


This graph represents the time a patient waited from <i>interface</i> to the <i>treatment</i> time.

<CFELSE>

<CFIF #Graph# IS "Disposition_Wait">


This graph represents the time a patient waited after <i>treatment</i> to the <i>disposition</i> time, either admitted or
discharged.

<CFELSE>

<CFIF #Graph# IS "Total_Wait">


This graph represents <i>all</i> of the wait times for each patient.

<CFEL
SE>


</CFIF>

</CFIF>

</CFIF>

</CFIF>

</CFIF>

</CFIF>

</CFIF>

</CFIF>


</BODY></HTML>

“vedenteruser.cfm”


<! This page is for administration only. IT allows new users to be entered into the

database with simple input forms.>


<HTML>

<HEAD><TITLE>VED User

Registration</TITLE></HEAD>

<BODY BACKGROUND="images/vandyback.gif">


<br>

<p align="center"><big><big><font face="Courier New"><strong>Please enter the following information to register a
user.</strong></font></big></big></p>


<h1><b> THIS PAGE FOR SYSTE
M ADMINISTRATOR USE ONLY </b></h1>


<FORM ACTION="veduserreg.cfm" METHOD=POST>


<PRE>

First Name: <INPUT TYPE="text" NAME="FirstName" SIZE=20>

Last Name: <INPUT TYPE="text" NAME="LastName" SIZE=20>

Department: <INPUT TYPE="text" NAME="Department"

SIZE=20>

Username: (10 characters or less) <INPUT TPYE="text" NAME="Username" SIZE=10>

Password: (10 characters or less) <INPUT TPYE="text" NAME="Password" SIZE=10>

<p>

<center> <INPUT TYPE="Submit" VALUE="Register User"> </center>

</PRE>

</FORM>

</BO
DY>

</HTML>



“veduserreg.cfm”


<! This page lets you know that the user has been entered into the system.

More users can be entered at this point with one option or the user

can login into the system.>


<CFINSERT DATASOURCE="emergency" TableName="Users"
>


<HTML>

<HEAD><TITLE>VED User Registration Complete</TITLE></HEAD>

<BODY BACKGROUND="images/vandyback.gif">


<br>

<p align="center"><big><big><font face="Courier New"><strong>Registation is Complete.</strong></font></big></big></p>



<PRE>

<FORM ACTION="
vedenteruser.cfm" METHOD=POST>

To enter more users into the system click this button: <INPUT TYPE="Submit" VALUE="More Users">

</FORM>


<FORM ACTION="velogin.cfm" METHOD=POST>

To go to login page click this button: <INPUT TYPE="Submit" VALUE="Go To Logi
n">

</FORM>

</PRE>

</BODY>

</HTML>

“vedenterdelete.cfm”


<!Administration page to delete data. Can only be accessed by entering the URL>


<!Query for the patient numbers in database>

<CFQUERY NAME="GetNumbers" DATASOURCE="emergency">


SELECT PatientNumbe
r FROM WaitTimesNew

</CFQUERY>



<html>

<body>


<h2>This form will delete any entry listed below out of the "WaitTimesNew" and "VisitDescription" tables</h2>

<FORM ACTION="veddelete.cfm" METHOD="post">

<PRE>


Please select the patient number you want to de
lete: <SELECT NAME="PatientNumber">








<CFOUTPUT QUERY="GetNumbers">









<OPTION VALUE=#PatientNumber#>
#PatientNumber#









</CFOUTPUT>








</SELECT>


<CENTER><INPUT TYPE="submit" VALUE="delete"></CENTER>

</PRE>

</FORM>


</body>

</html>



“veddelete.cfm”

<!
----------------------------------------------------------------


Below is the query which deletes the guest record based on the


PatientNumber passed to this template. The templates also generates


a page which
confirms the delete to the user. This page is only for


administrator access.

------------------------------------------------------------------
>

<CFQUERY NAME="SQL_Delete" DATASOURCE="emergency">


DELETE * FROM WaitTimesNew WHERE PatientNu
mber = #FORM.PatientNumber#

</CFQUERY>


<CFQUERY NAME="SQL_Delete" DATASOURCE="emergency">


DELETE * FROM VisitDescription WHERE PatientNumber = #FORM.PatientNumber#

</CFQUERY>



<HTML>

<HEAD><TITLE>Wait Log Deleted</TITLE></HEAD>

<BODY BACKGROUND
="images/vandyback.gif">




<H2>Registration Deleted</H2>

<CFOUTPUT>

<P>#FORM.PatientNumber# entry was deleted successfully.

</CFOUTPUT>

<FORM ACTION="vedoptions.cfm" METHOD=POST>


<CENTER><INPUT TYPE="Submit" VALUE=" Continue "></CENTER>

</FORM>


<
/BODY>

</HTML>

Appendix F

Emergency Department Flow Process




























1. Triage Wait 2. Room Wait 3. Resident Wait 4. Attending Wait 5. Interface Wait 6. Treatment Wait 7. Disposition

Wait




1

2

3

4

6

5

7