MSCITS Job Status

JobNumber	1091
RequestDate	12/4/1995
ScheduledDate	3/29/1996
CompletionDate
SuperBillingName	PHYSICAL THERAPY
Building	SLCH Hospital
Room	1st Floor
JobDescription	New network lines for new construction.
ContactFirstName	Cindy
ContactLastName	Gutierrez
Results	Old Job # 715
Applix Incident

Misc

Sort By: [RequestDate] [4 : 18041]
The following data is the associated Line number(s) and IP addresse(s) for the displayed job.There may not be any records associated with the job.

Warning: User supplied query returns no records for display
SELECT Unumber.unumber , A.description, C.description ,Unumber.IPaddress FROM Unumber,ActivityType A,ConnectionType C WHERE A.activitytypecode = Unumber.activitytypecode and C.connectiontypecode = Unumber.connectiontypecode and Unumber.Jobnumber ='1091'