MSCITS Job Status

JobNumber	18507
RequestDate	4/20/2009
ScheduledDate	5/4/2009
CompletionDate
SuperBillingName	CENTRAL ADMINISTRATION
Building	Clinical Science Research Bldg
Room	2nd floor link
JobDescription	Install 7 lines. Buzz will walk with Sachs. Lee will activate when Sachs complete. May be a bid job.
ContactFirstName	Roy
ContactLastName	VanHee
Results	cancel per mlk.
Applix Incident

Misc

Sort By: [Jobstatus.description] [15 : 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 ='18507'