Home

CHAPTER ONE

1. d a Property Information sheets eet XXXXX 16 13 USER MANUAL SPARKS January 28 2003 Step 2a If the Site Type for the Site just added is Toll Plaza or Interchange then the Engineering Design Department Roadway Section should add the Toll Plaza Collection Info which is located on the Site Detail Tab Site Detail Building Fuel Info Concepts Inzpiservices Leases Utilities Parking Opening Date Open Last Record Update 12 4 2002 Mailing Address Desc Comment E Address 1 Legislator Address 2 T M Entry City Legislatrye District T Direction State Em Hours of Operation Open 24 Open Closed and Ride Available Direction i Number of Mon Hevenue Cards Issued Longitude Latitude Tum Around Back Gate Access Operator Contact Access Road Name Insurance Information Access Road Description Property Information Record Validation Validate Site Record Figure 2 ADD TOLL COLLECTION INFORMATION Toll Collection Types toll plaza test Available T oll Toll Collection Types Collection Types Available at this Toll Plaza Collecti
2. BRODGERS 77120003 Farmers Market Makt 8 3 2002 BRODGERS 93202 BHODGERS Delete Selected Recond Modit Records Save Cancel 4 The ADD RECORD Button s caption is changed to SAVE the CANCEL button is activated and the DELETE SELECTED RECORD MODIFY RECORDS and EXIT buttons are disabled Save SAVE Button Causes any changes that you have made to be made to the table The SAVE button s caption will return to Add Record The CANCEL button will be disabled The DELETE SELECTED RECORD MODIFY RECORDS and EXIT buttons will be enabled again Cancel CANCEL Button Causes any changes that you have made to be lost The SAVE button s caption will return to Add Record The CANCEL button will be disabled The DELETE SELECTED RECORD MODIFY RECORDS and EXIT buttons will be enabled again 139 USER MANUAL SPARKS January 28 2003 Add Hew Record ADD NEW RECORD Button Will add an additional line in the data grid as seen below SPARES Common Lookup Tables Manager SPARKS Common Database Tables Selecta Common Table ta Update Concept Type Current Table Concept Type r af records 4 jCode n Vaue 2 RHecordllpdate r o Username fro 7712001 Service Station Service Staion 9 3 2002 BR DGERS 77120002 0 88200 BRODGERS 7120003 Famers Market FamesMake 83202
3. 145 D tat m uid MEUM ME RUE 150 122 156 G 5 55 CY REPE USUS 158 CHAPTER SIX ADDITIONAL 166 A CONTACT INFORMATION FORM 44600 004000000 166 B INSURANCE INFORMATION FORM 170 C PROPERLY INFORMATION FOR VL 173 D TOLL PLAZA COLLECTION INFORMATION 175 ROOF DETAILS FORM ibd MUNITUM B II IUS 179 183 65 189 H CONSTRUCTION HISTORY 2 2 0000001200 192 I RENTAL RATE INFORMATION 198 PROCESS INSPECTIONS FORM i bene 201 I FORM 204 L WASTE WATER SYSTEM DETAILS FORM mmn 208 M WATER SYSTEM DETAILS 211 PARKING CONSTRUCTION RENOVATION HISTORY FORM 214 CHAPTER SEVEN PRINTING REPORTS 217 REPOR ELT 218 Crystal
4. 218 218 Opens Query Builder ne eye 219 B Pel Ne ORS 221 Delceba POElOQ oor 221 BS ES Gy EI onse mM 222 CHAPTER EIGHT ONBASE APPLICATION 223 2 STC 223 IMPORT INSPECTION REPORTS eicit 224 USER MANUAL SPARKS January 28 2003 Page Intentionally left Blank USER MANUAL SPARKS January 28 2003 CHAPTER ONE INTRODUCTION Welcome to the SPARKS Application A WHAT IS THE SPARKS APPLICATION SPARKS is an acronym for the SITE PLANNING ASSET AND RESOURCE KNOWLEDGE SYSTEM Key components that are part of the SPARKS application are 1 Provide tools to manage data SPARKS including e Data conversion utilities for importing inspection and survey Excel spreadsheets into SPARKS e Data maintenance utilities add modify delete 2 Provide the ability to query and find data records in SPARKS 3 Provide the ability to generate standardized reports The application resides on the Turnpike Network and is accessible through the Citrix farm The application was developed using Visual Basic 6 0 and utilizes an Oracle 8 1 6 database USER MANUAL SPARKS January 28 2003 CHAPTER TWO BUSINESS FLOW The purpose of this chapter is to provide the logic of the flow of data through the SPARKS application The information provided in this chapter will detail the ord
5. jaw 29209 2545580 525700 10 21 2002 Magical Pancake Hous 2002 3 0 47604 7 12200 10 21 2002 CiniBuns am 3 120 202 80 1547700 10 21 2002 MalslalanCusne 2002 3 125980 27850010 21 2002 NEWYORKPZZA _ 20p 3 270 21878870 2 125 88500 10 21 2002 h L E nnn ru d Hmmm For more details on the SALES INFORMATION FORM please refer to Chapter 6 Section 74 Adding Concept Info Check List Task 1 Concessions Management Department o Add Main Vendor Concept Info o Add Vendor Concept Contact Info o Email Risk Management to add Vendor Concept Insurance If there are Vendor Concept Photos o Add Vendor Concept Photos Risk Management Department o Add Vendor Concept Insurance Info o Add Vendor Concept Insurance Contact Info Task 2 Concessions Management Department o Add Rental Rate Info Task 3 Concessions Management Department o If the Vendor Concept is a Fuel Vendor o Add Fuel Sales Info o If the Vendor Concept is a Non Fuel Vendor o Add Non Fuel Sales Info 75 USER MANUAL SPARKS January 28 2003 USER MANUAL SPARKS January 28 2003 E INSPECTIONS AND ADDING SERVICES IMPORT INSPECTION INFORMATION STEP 1 INSPECTORS FILL OUT ELECTRONIC COPY OF INSPECTION REPORT INSPECTORS EMAIL A COPY OF THE REPORT TO ANTHONY LIBERATORE Organizational Process Application Process 76
6. EXEXXXXXXXXXEXXEXXEXEXEXEXXXXXXEXXEXXEXEXEXEXXXEXEXMEXEXEXEXEXEXEXEXEXEXMEXMXMXMI EMNXMZMZXXMEXXXEMXXXEMXXXMMXXMMXXXEMXXEMXXEMXXEEMXXEMXXMMEXXEMXXXEMXXXEXMXXMMXXXEKMXMI re itle MIDMEEXEIMEIEEIEENEEEXEEZENXAXEEEEEXAEEAEEEEEEMEEXXXEEXEEEEAENMAEEEEEEXEXEAXENXEEXEEEENXEAXAXEXEI Address City Zip code Phone one ona ee TET S Fax Email Emergency Contact Number H esponsible H PLI E imi 168 USER MANUAL SPARKS January 28 2003 CANCEL Button Appears when the D 7 Button is clicked When this button is clicked any field changes will be lost and any original field values will be restored SAVE Button Becomes enabled when t
7. VA Fields Available gt m Parking Construction Type The type of construction done The valid values are accessible from the drop down list Pavement Type The type of pavement used for the construction The valid values are accessible from the drop down list Construction Date The date the construction project began The format for the date is MM DD YYYY Parking Lot Name The name of the parking lot that is having construction Description A text field that describes the work that was done as part of the construction project 214 USER MANUAL SPARKS January 28 2003 Buttons Available EXTT Button Will Close the Parking Lot Construction Renovation History Form return control to the main form L EDIT Button Will make data that can be changed a light blue color The ED T button will become the CANCEL Button and the VEW Button will become the SAVE Button NEW Button Will clear all fields for you add a new record The D 7 button will become the CANCEL Button and the WEW Button will become the SAVE Button CANCEL Button Appears when the D 7 Button is clicked When this button is clicked any field changes will be lost and any original field values will be restored SAVE Button Becomes enabled when the D 7 button is clicked When this button is clicked all changes will be saved to the database 215 USER MANUAL SPARKS January
8. OK Button Will run a query to find the records that have a Site Type matching the value you chose from the list box If no records are found the following message will show If records are found the form will close and only records of that Site Type will be displayed SPARKS Application Message Records this Site Type 145 PENNA TURN 3 USER MANUAL SPARKS January 28 2003 Cancel i CANCEL Button Will close the Select Records form and return control to the main form Query Builder If you wish to run a query to find a more specific record or group of records use this button QUERY BUILDER Button Will open the build query form Build a Selection Filter Fields Available Field Values MILEPOST _ COUNTY MUNICIPALITY START MILEPOST ENO MILEPOST DIRECTION STATIDIN Filter MAINT DISTRICT Sm FC DISTRICT __ SITE CODE Done Current Selection Filter 146 USER MANUAL SPARKS January 28 2003 Fields Available ROUTE MILEPOST COUNTY MUNICIPALITY START MILEPOST END MILEPOST DIRECTION STATION MAINT DISTRICT FL_DISTRICT SITE_TYPE_CODE EXIT The fields available list box shows the names for each of the fields the main SPARKS table Choose the field you wish to run a query against by single clicking the field In this example Site_Name has been chosen E and
9. File Administrative Tasks Edit Commaon Loakup Tables ctrl E s nter Mew Counts b Enter New Demographic Data Edit Security Information F County Municipality Showing record 1 af 227 5 20 10 New service plaza Montgomery Plymouth Begin Direction Station Fare Collection Dist Maint District Site Type Located Between 20 10 20 90 123 45 2 4 Service Plaza and 3 Site Detail Buildings Fuel Info Concepts Insp Services Leases Parking Opening Date 3 2 1995 Site Status HISTORICAL Last Record Update 11 7 2002 test z Mailing Address Desc Comment Legislator Address 2 Legislative District egislative Distric State zo Hours of Operation Open 24 Hours Open TUAM Closed Service Plaza Usage Number of Man Revenue Cards Issued 12 Other Longitude 24 5555555555 Latitude Back Gate Access Access Road Name Insurance Information Access Haad Description Property Information Record Validation 10 28 2002 ROTOEVS Validate Site Record For more details on Editing Common Lookup Tables please refer to Chapter 4 Section A 108 USER MANUAL SPARKS January 28 2003 II EDIT SECURITY INFORMATION The second option that is available is Edit Security Information Single clicking the menu
10. 123 45 2 4 Service Plaza and 3 Site Detail Buildings Fuel Infa Concepts Insp servicez Leases Parking Opening Date 3 2 1385 Gite Status Open Last Record Update 11 25 2002 test z Mailing Address Desc Comment rr Leqislator Address 2 City Legislative District State Hours of Operation Open 24 Hours Open 700 Closed Service Plaza Usage Type Number of Non Revenue Cards Issued 12 Other Longitude 124 5555555555 Latitude Turm amp mund Back Gate Access OperatorContact Access Road Insurance Information Access Road Description Property Information Record Validation 10 28 2002 ROTDEYS Validate Site Record Single Click the New Button 10 USER MANUAL SPARKS January 28 2003 PTC Site Planning Asset and Resource Knowledge System User MMCCONME File Administrative Tasks ES General Site Information Route and Milepost ae On Hasa Sie Mame Municipality Showing record 1 of 227 es prune Begin End Direction Station Fare Collection Dist Maint District Site Type Exit Old Num XXXXEXXXXEXM XWEXEXEXEXXEN XNXEXEXXXENMI XXEXEXEMNXEXEXXEEXXEXENMI HEARS x 1 PETIPETI site Detail Buildings Fuel Into Ltilities Parking Opening Date LE Mailing Ad
11. USER MANUAL SPARKS January 28 2003 I INSPECTIONS AND SERVICES INFORMATION site Detail Buildings Fuel Info Concepts Insp Services Leases LItilitie s Parking Process Inspection Spreadsheets Services Buttons Available Process Inspection Spreadsheets PROCESS INSPECTION SPREADSHEETS Button Opens the Process Inspections form For more details on the Process Inspections form please refer to Chapter 6 Section K Services SERVICES Button Opens the Services form For more details on the Services form please refer to Chapter 6 Section L 130 USER MANUAL SPARKS January 28 2003 J LEASE INFORMATION site Detail Building Fuel Into Concepts Insp services Leases Utilities Parking Last Record Update 10 17 2002 Lease Contract Information Lease Type Lease Humber 7 Operator Date Executed 03 01 2000 Lease operator Start Date 03 15 2000 Location Expiration D ate 02 02 2002 M Extension D ate 03 16 2006 Terms m gt gt Fields Available Lease Number A text field referencing the Lease Number that is associated with the lease Lease Type The type of lease The valid values are available in the drop down list Operator Name A text field containing the name of the Operator the lease is associated with Location A text field that represents the location associated with the lease Terms A text field that describes the terms of the
12. Begin Direction Station Fare Collection Dist Maint District Site Exit Exit Num SMA ME Y YYYrrii Y VYYYYYYY vuiver Site Detail Buildings Fuel Infa Concepts InspiServices Litilitie s Parking Opening Date Site Status z Last Record Update Malling Address Desc Comment Addes 2 Legislator Address 2 v Entry City Legislative District Direction State Hours of Operation Open 24 Hours Open Closed Park and Ride Available Direction Number of Won Revenue Cards Issued Tall Plaza Collection Infa Longitude Latitude Tum Around Back Gate Access Operator Contact AAS EX 3 Access Road S MOEEIEMGMEGEMEEEEMEEZEMENEMXEEEEMEEEEEMEEEXMEENEEXxENEMEEEMXEEEXEXEEXEEXEXEXEEXEXXXXEI Insurance Information Pt ttt ttt ttt tatters Oocess Road Description SSE Be BES Bee DD EG a a a x 3 x mx mx mE x EXEMEMEXMEEMEXM SHE WEEEEEXEEEEEEXEEXEEXEEEXEXEXXE XX 1 bb ee e e
13. MOVE FIRST Button A Record Navigation button As long as you are not on the First Record in the table this button can be used to move to the first record MOVE PREVIOUS Button A Record Navigation button As long as you are not on the First Record in the table this button can be used to move to the previous record MOVE NEXT Button A Record Navigation button As long as you are not on the Last Record in the table this button can be used to move to the next record Move to the last record in the current selection MOVE LAST Button A Record Navigation button As long as you are not on the Last Record in the table this button can be used to move to the last record PICTURES Button Opens the pictures form For more details on the functionality available on the pictures form please refer to Chapter 4 Section G 114 USER MANUAL SPARKS January 28 2003 On Base Launch Interface to OnBase Application ONBASE Button This button is currently not operational At some time it will provide a link to various document image types that are stored in the Onbase application SAVE Button This button will appear after you have hit the VEW button or the EDIT button When this button is clicked any field changes will be saved to the database x CANCEL Button This button will appear after you have hit the WEW button or the EDIT button When this button is clicked any field change
14. za EM The OPERATOR buttons that are between the Fields Available and the Field Values list boxes are used to create the query In the example here we are using the Site Name field so we will choose the equal button by single clicking it Note In most but not all cases the Equal button would be used for a Text field the greater than less than equal and not equal buttons will be used for Numeric fields The and or buttons are used to build more complex queries See the Complex Query result example below 147 USER MANUAL SPARKS January 28 2003 Field Values AKH Mainline Toll Plaza Tower Administration Building Allegheny Valley Interchange Allentown Service Station Amazing Facility American ower Amos Hutchinson Manten Bald Knob Tower Beacon Tower When a field is chosen from the Fields Available List Box the Field Values List box will fill with all of the unique values that are found for that field in the main SPARKS table To choose a value from the list single click it In this example A K H Tower has been chosen Current Selection Fllter SITE_NAME Tower The Query statement you are building will show in the Current Selection Filter text box Done DONE Button Will complete the Query based upon the results the Current Selection Filter text box If there are errors that are preventing the query from running they will appear The Query Builder form will c
15. 2 _Text Search Note Search Clear Keywords Clear Exit Choose the same document type that you just imported a document for from the Document Types keywords Haute Le And Milepost 40 00 And Inspection Date 1071072002 Enter the values you typed into the keyword values while doing the import Find Hit the find button 228 USER MANUAL SPARKS January 28 2003 OnBase Client e x File Document User Processing Admin Window Help 19158 Exe Document Retrieval Document Type Groups Document Types Baker Documents BE Utility Baker Engineering Engineering Drawings CATALOG IT Word Documents Excel Restroom Inspections CATALOG Meeting Documents Excel Documents Test Engineering Documents Excel Restaurant Inspections HR Documents Excel Service Plaza Inspections IT Documents Restaurant Inspections 11 08 2002 November 2002 October 2002 September 2002 August 2002 From PLAZA NEW SERVICE PLAZA 5 DATE 10 28 2002 E suus aT iS ri Numberoutofordder ES Wall Erana weer ae clean Porcelain countertops clean god repair dry _ Properly mounted Spigot fixtures clean repair 112 Paper 15 or more fall J Sink Walls pipe floor clean 4 pp Mg eeecepus ia placoproperiy 1 Dwenr
16. Last Record Update Contact Type 0 perator Name Company C Title Address City PO State Hl Zip code Phone 1 Fax 2 Email Emergency Contact Number Responsible Hours j j For more details on the Contact Information form please refer to Chapter 6 Section A Step 7 Upon receiving the email from the Engineering Design Department Roadway Section the Risk Management Department will add the Site Insurance information into the application The Site Insurance Information is accessed from the Site Detail Tab 22 USER MANUAL SPARKS January 28 2003 Site Detail Building Fuel Info Concepts Insp services Leases Utilities Parking Opening Date 3 2 1335 Cite Status Open Last Record Update 11 26 2002 test Mailing Address Desc Comment est Legislator Address 2 City Legislative District State ip Hours of Operation 24 Hous Open 7 00AM Closed Service Plaza Usage Type Number of Non Revenue Cards Issued 12 Uther Longitude 124 5555555555 Latitude Back Gate Access Operator Contact Access Road Name Insurance Information Access Road Description Record Validation 1026 2002 ROTDEY 3 Validate Site Record Property Information Figure A 9 ADD INSURANCE INFORMATION Insurance Information Site New service plaza test Last Record Update 14 20 20
17. Parking Last Record Update 10 28 2002 Building Structure nformation Building Structure Building Structure testing Main Service Plaza Building Location Root Details Comment hhkihki Fire Detection Equipment System Fire Suppression Rest ca est Rooms Gross Square Footage 39 00 Capacity E Construction History Closed Construction Material d lt gt Record Validation 10 28 2002 ROTDEY3 Validate Bld Structure Record 34 USER MANUAL SPARKS January 28 2003 Figure B 3 ADD ROOF INFORMATION im Ronf Detail New service plaza testing Last Record Update 17 7 2002 Roof Type Butu 22 Roof Information Roof Contractor IIT Roof Install Date nazam 0 Roof Manufacturer Roof Warranty Warranty Date Warranty Length Warranty Esp Date Waranty Compar Waranty Descnipton Comments Warranty Contact For more details on the PHOTOS FORM please refer to Chapter 6 Section P 35 USER MANUAL SPARKS January 28 2003 If there is a roof warranty then continue with step 4 Step 4 The Engineering Facilities Department should add the Warranty Contact information The Warranty Contact Form is accessed from the Roof Details form i Roof Detail New service plaza testing Last Record Update 1177 2002 Roof Type Built up Roof Information Hanf Contractor hew roof Roof Install Date 117 1
18. The Available Service Types list box shows all available types The values in the list box come from the Services Types lookup table 204 PENNA TURN 2 USER MANUAL SPARKS January 28 2003 Service Types Available at this Site Service Type 1 REEBRD UPDATE 82 22 D jPenchrss 0820 29 108 232 p 10 16 2002 Touch and Ga 10 08 2002 Service Types Available at this Site shows the types that are currently in use at the Site The Record updated field lets you know the date they were added into the system Buttons Available EXIT Button Will Close the Services Form and return control to the main form L EDIT Button Will Enable the ADD SELECTED SERVICE TYPE Button and the REMOVE SELECTED SERVICE TYPE FROM THIS SITE Button The EDIT button will become the CANCEL Button and the SAVE Button will be enabled 205 PENA 4 TURN i USER MANUAL SPARKS January 28 2003 Services available at Allentown Service Station Available Service Types Service Types Available at this Site Travel Info SemiceTupe UPDATE Picnic Areas b Travel Infa 0972022002 Pet Areas 08 20 2002 wae PeAes 108 2002 ITN 0152002 Touch and Ga z Touch and Go 1008 2002 Dial a Truck Add Selected Service Type gt gt lt lt Remove Selected Service Type From this Site CANCEL Button Appears when
19. USER MANUAL SPARKS January 28 2003 Step 1 The Inspectors will fill out an electronic version of one of inspection reports For examples of the Reports please refer to Appendix A Inspection Reports Examples Step 2 The Inspectors will email a copy of the report to Anthony Liberatore Step 3 Concessions Management Imports Inspection data into the SPARKS application The Inspection Import is accessible from the Insp Services Tab site Detail Buildings Fuel Into Concepts Insp Services Leases LItilitie s Parking Process Inspection Spreadsheets Services 71 USER MANUAL SPARKS January 28 2003 Figure E 1 PROCESS INSPECTIONS Process Inspections for Site New service plaza Inspector EIE Z1 For more details on the PROCESS INSPECTIONS FORM please refer to Chapter 6 Section K 78 USER MANUAL SPARKS January 28 2003 Inspections Check List Inspectors o Fill out Electronic Copy of Inspection Report o Email a copy of the report to Anthony Liberatore Concessions Management Department o Import Report Data 79 USER MANUAL SPARKS ADD SERVICES EMAIL IS RECEIVED FROM THE ENGINEERING DESIGN DEPARTME ROADWAY SECTION TO ADD Organizational Process oen ALL ACTIVITIES PERFORMED THIS FLOW ARE DONE BY THE CONCESSIONS MANAGEMENT DEPARTMENT 80 USER MANUAL SPARKS January 28 2003 Step 1 Upon receiving an email from the Enginee
20. 123 45 2 4 Service Plaza and 31 Site Detail Buidings Fuel Info Concepts Inspi ser vices Leases Parking Opening Date 3 2 1995 Site Status HISTORICAL Update 10 28 2002 Address D esc Comment r Address 1 Legislator Address 2 Legislative Disinct agile Drine State en Hours of Dperalian Open24Hous Open Closed amp 00PM Service Plaza Usage Type Number of Non Aevenue Cards Issued 12 Longitude 1245555555555 Lathude Tumn amp ound Back Gale Access peratar Contact Access Road Name Insurance Infermmatian Access Road Description atlas n Property Information Record Vaidaton 10 28 2002 ROTDEV3 Validate Site There are two Menu items in the SPARKS application To access the sub items in the menu single click the Menu item For more details regarding the Menu items please refer to Chapter 3 Section B 103 USER MANUAL SPARKS January 28 2003 Route and Milepost 6 SiteName Municipalty Showing record 1 of 222 County ey Fen Begin EndMP Direction Station Fare Collection Dist Maint Disticl Site Type Located Between 2010 20 50 NB 123 45 2 4 Service Plaza al and 31 Site Detail Buidings Fuel Info Concepts Insp Services Leases Utilities Parking Opening Date 3 2 1995 Site Status HISTORICAL Last Record Update 10 28 2002 test Add
21. 225 USER MANUAL SPARKS January 28 2003 Choose the Document type based upon the type you are importing from Document Type Engineenng Drawings Excel Restroom Inspections Excel Restaurant inspectors d Excel Service Plaza Inspections HH Jab Descriptions Document types EXCEL RESTAURANT INSPECTIONS RESTAURANT INSPECTION REPORT EXCEL RESTROOM INSPECTIONS RESTROOM INSPECTION REPORT EXCEL SERVICE PLAZA INSPECTIONS SERVICE PLAZA INSPECTION REPORT File Type 5 Excel Spreadsheet Document Date 1 10842002 File Type This will change automatically to MS Excel Spreadsheet Document Date Will automatically fill with the current system date Change it if you wish Keywords Route Milepost Inspection Date Keywords section of the document is where you enter the criteria that will link the document back to the information in the SPARKS application 226 USER MANUAL SPARKS January 28 2003 Route Unique designator for the part of the Turnpike s Roadway that the Site resides e The Accepted values for the Route Field are O O T Mainline A Northeast Extension B Beaver Valley Expressway G Greensburg Amos K Hutchinson Bypass M Mon Fayette Expressway Milepost Unique designator for the mile marker from the Turnpike s Roadway where the site resides e The accepted values for the Milepost field are O If Route T then Milepost
22. NEUEN Ent City Legislative District legislative district Direction State ip Hours of Operation Open 24 Hours Oper Closed Park and Ride Available Direction Humber of Man Hevenue Cards Issued 5 Tall Plaza Collection Info Longitude Latitude Tum Around Back Gate Access Operator Contact Access Road Insurance Information Access Road Description Property Infarmatian Record Validation 08 06 2002 BRODGERS Validate Site Record 63 USER MANUAL SPARKS January 28 2003 selected anota 64 USER MANUAL SPARKS January 28 2003 Step 4 The Concessions Management Department should contact the Risk Management department via electronic mail to inform them that they can add the Vendor Concept Insurance Information The following Site information should be included in the email e Route e Begin Milepost e End Milepost e Site Name 65 PENA Pire USER MANUAL SPARKS January 28 2003 Step 5 Upon receiving the email from the Concessions Management Department the Risk Management department should add the Vendor Concept Insurance Information for each Vendor Concept The Vendor Concept Insurance Information form is accessible from the Concepts tab site Detail Building Fuel Info Concepts Inspiservices Leases Ltilties Parking Last Record Update 10 22 2002 Vendor Site Operator JArbys Concept Site
23. Photo Description pole Photo Description A brief description of what the photo is showing 164 Eia USER MANUAL SPARKS January 28 2003 Buttons Available CLOSE Button Will close the Display Photo form and return full control to the Select Sparks Photo form N EDIT Button Will allow you to change the photo date or photo description fields SAVE Button The D 7 Button changes to this button when it is clicked This button will save any changes to the photo date or photo description to the database CANCEL Button Is enabled when the D 7 Button is clicked This button will remove any changes that were made to the photo date or photo description fields without saving them 165 USER MANUAL SPARKS January 28 2003 CHAPTER SIX ADDITIONAL FORMS A CONTACT INFORMATION FORM The Contact information form contains important contact information for the Site and its related data The form can be accessed from the Site Detail Tab Fuel Info Tab Concepts Tab Utilities Tab Insurance Information Form and Roof Details Information form Contact Information Last Record Update Contact Type 0 perator Name Company Title Address City 2 State ip code Phone Email Emergency Contact Number Responsible Hours sf 166 USER MANUAL SPARKS January 28 2003 Field
24. USER MANUAL SPARKS January 28 2003 SPARKS SITE PLANNING ASSET AND RESOURCE KNOWLEDGE SYSTEM USER MANUAL FINAL January 28 2003 USER MANUAL SPARKS January 28 2003 TABLE OF CONTENTS CHAPTER ONE INTRODUCTION 6 A WHAT IS THE SPARKS 100000 6 CHAPTER TWO BUSINESS FLOW cee 7 c secre see op eae one ees fi Figure A 1 ADD GENERAL SITE INFORMATION sese 11 Figure A 2 ADD TOLL COLLECTION INFORMATION t l4 Figure A 3 EMAIL DEPARTMENTS ABOUT THE ADDITION OF NEW SITE 15 ADD SUE PHOTOS MEME 17 Figure A 5 ADD SITE LONGITUDE LATITUDE ensem 18 Figure A 6 ADD PROPERTY 19 y D Fin ADDS ETNE O mt 20 Figure A 8 ADD SITE CONTACT INFORMATION 2 002 22 Figure A 9 23 Figure 10 ADD PARKING LOT INFORMATION sess 24 Figure 11 ADD REMAINING SITE INFORMATION 25 Figure 12 VALIDATE SITE 26 B 4 1 12 0 4 143144 4 400440 0400400 28 Figure 1 ADD BUILDINGS eene 31 Pere BZADDSIRUCTURE PHOTOS recenp nra eE URINE 33
25. _ aa BRODGERS _ Delete Selected Recond Records Save Cancel 4 You will be able to enter a value into the Value and Description fields To save the changes or cancel the changes see the SAVE and CANCEL buttons functionality on the previous page CLOSE Button Will Close the Common Tables form return control to the main form 140 USER MANUAL SPARKS January 28 2003 B BROWSING RECORDS When the BROWSE Button is chosen from anywhere the application the Browse Form will open SPARKS Data Browse Mode Se e EET AT IS MILEP 4 New service plaza 201 Mengemey Pmouh 2 F Lansdale change A 30173 Herten Temamerci 13072 amar Quakertown MaintanenjA 88 Bucks _ 4374 Jaor Quakertown InterchanglA Bucks a7 amio South Moutain Lehdh _ 5 janssP Allentown Service StatigA 688 Lehigh Upper Macunge 559 057 Lehigh Valley InterchandA 527 Lehigh SeuhWhiehal 57 7 Law _ Slatinaton Maintanence A 7007 Lehigh 707 aw o t SlsingenMeinlenanceA Washinton 7007 Lehigh TunnelNo 1 705 7025 1 Lehch 711 Lehigh TunnelNo 2 1 Cabon 7146 Mahoning Valey necha 7888 75 aosta Hickey Run Service PdA 14 Cab
26. A text field representing the corporate name of the Fuel company used at this site Location A text field representing the location at the site where the fuel station is located Number of Islands A numerical value representing the Number of Islands at the site Number of Pumps A numerical value representing the Number of Pumps as the site Number of Full Service Pumps A numerical value representing the Number of Full Service Pumps at the site Minimum Canopy Clearance A numerical value representing the canopy clearance in feet Canopy Light Type A text field that identifies the light type used on the canopy Convenience Store Check Box Click the check box if there is a convenience store at the site 126 USER MANUAL SPARKS January 28 2003 Pay at the Pump Service Check Box Click the check box if there is pay at the pump service at the site Emergency Plan Click the check box if there is an Emergency Plan at the site Fuel Brand The brand of fuel used at the site The valid values are available in the drop down list Inspection Date The last date that the Fire Suppression system was inspected The date should be formatted as follows MM DD YYYY Description A text field that describes the Fire Suppression system Leak Detection System A text field that describes the Leak Detection System Spill Control Plan A text field that describes the Spill Control Plan De Icing Materials Used A text field that list
27. ADD SELECTED COLLECTION TYPE Button Will move any highlighted value from the Available Toll Collection Types list box to the Toll Collection Types Available at this Toll Plaza data grid If the value is already in the table the following message will appear SPARKS Application Message This Collection Type Currently Exists ADD 177 USER MANUAL SPARKS January 28 2003 lt lt Remove Selected Collection From This Tall Plaza REMOVE SELECTED COLLECTION TYPE FROM THIS TOLL PLAZA Button Will remove the line in the data grid with the gt from this Site 178 USER MANUAL SPARKS January 28 2003 E ROOF DETAILS FORM The Roof Details Form contains any roof information for the buildings at the Site The Roof Details form is only accessible from the Buildings Tab w Root Detail New service plaza testing Last Record Update 1022 2002 Hanf Built up Root Information Roof Contractor root Roof Install Date 11 1 2001 Root Manufacturer Add Warranty Record Bj 2 3 Fields Available Roof Type A list box containing the roof type All valid values are found in the drop down list Roof Contractor A text field containing the name of the Roof Contractor Roof Install Date A date field representing when the roof was installed The format for the date is MM DD YYYY Roof Manufacturer A text field containing the name of the Roof Ma
28. Figure B 3 ADD 2 11 12 41 0100 0 0 0616 6660 ee 35 Figure B 4 ADD WARRANTY 37 Figure B 5 ADD EQUIPMENT esses 39 Figure B 6 ADD EQUIPMENT nnn 4 Figure 7 ADD CONSTRUCTION HISTORY INFORMATION 42 Figure B 8 ADD RESTROOM RECORDS eese 44 Figure B 9 UPDATE RESTROOM RECORDS eene 45 Figure B 10 ADD FIRE SUPPRESSION FUEL 46 Figure 11 VALIDATE 5 2 2 222222 47 ADDING FUPLINFORMA MON 556 49 Figure ADDING FUEL 50 Figure 2 ADDING FUEL 22 2 52 POV OS 54 Figure C 4 ADD FUEL INSURANCE 55 Figure C 5 ADD INSURANCE 57 D ADDING CONCEPTS INFORMATION 59 Figure D 1 ADD MAIN 2 60 Figure D 2 ADD VENDOR CONCEPT CONTACT INFORMATION 62 Figure D 3 ADD VENDOR CONCEPT PHOTOS eene 64 USER MANUAL SPARKS January 28 2003 F
29. KW A text field containing the KVA for the Generator KVA A text field describing the fuel used for the Generator Fuel z 4 QS Q x NE T o Q A 5 Under HVAC DETAILS TAB Accessed by clickin RECORD Button This will only be available if the e HVA U Details Warranty Information HVAC xxX xxX xxX xxX xxX XXX xxX xxX xxX xxX Control Terminal HVAC System MEXXEXEXXEXEEREXAEXXAXXXXXXEXXEXXEXAXXXEXXXXEXXEXXEXXXXXAXXXXXXXXXEXAXXXXXXXXXXXXXXXXXXxXX The type of HVAC system this is All valid values are available from the drop down list HVAC Type A text field describing the control terminal for the HVAC system Control Term HVAC System Type A text field describing the system that is used to run the HVAC A text field describing the modem being used to run the HVAC system Modem 185 USER MANUAL SPARKS January 28 2003 Under the PRESSURE VESSEL TAB Accessed by clicking the ADD VESSEL DETAIL R
30. Responsible Party System Details Contact Information 88 USER MANUAL SPARKS January 28 2003 If the Utility Type is Water System then continue with Step 2 Step 2 The Engineering Facilities Department should add the Water System Details Information The System Details form is accessible from the Utilities Tab site Detail Building Fuel Info Concepts Inspi services Leases Utilities Parking Last Record Update 10 11 2002 Utility Information Utility Utility Provider water compar Water System Account Number Meter Location Materials Used Size Responsible Party Contact Information 89 PENNA TURN Je Figure G 2 ADDING WATER SYSTEM DETAILS USER MANUAL SPARKS January 28 2003 i Water System Details New service plaza water company X Milepost Last Record Update Water System Type Status Casing Size Casing Depth 383 Well Depth Static Water Level Yield 2 anstall Date Pump Data Pump Setting Driller P Storage Quantity Storage Type Storage Yolume Water Pressure Treatment Water Authority Location Description 3 71 51 For more details the WATER SYSTEM DETAILS FORM please refer to Chapter 6 Section N 90 USER MANUAL SPARKS January 28 2003 If the Utility Type is Waste Water System then continue with Step 2 Step 3 The Engineering Facilities Departmen
31. Structure Record 38 USER MANUAL SPARKS January 28 2003 Figure B 5 ADD EQUIPMENT INFORMATION Equipment New service plaza testing Equipment Last Record Update 10 30 2002 Description est Location basement Date Installed 0040 2000 0 Serial Number 5645498498 000202 9 4 90 Model Number 65465456456 0 Manufacturer Capacities Area Served Fuel Type Power Supply fire on 102122000 Comments i Warranty Information Warranty Date 1271272000 Warranty E sp Warranty Length Warranty Company Waranty Description Comments For more details the EQUIPMENT FORM please refer to Chapter 6 Section 39 USER MANUAL SPARKS January 28 2003 If there are Equipment photos then continue with Step 6 Step 6 The Engineering Facilities Department should add the Equipment photos PTC Site Planning Asset and Resource Knowledge System User MMCCONME File Administrative Tasks General Site Information and Milepost 5 County Municipality Showing record 3 af 228 30 13 Lansdale Interchange Montgomery Towamencin Begin End Direction Station Fare Collection Dist Maint District Site Type Exit Old Num 30 13 30 13 555 00 4 Toll Plaza 31 Site Detail Buildings Fuel Info Concepts Insp Services Leases Utilities Farking Opening Date 12 12 2002 Sit
32. Verda a Delete Selected Record Modity Records Add Hew Record ance 5 select a Common Table to Update Concept Type From the Common Table drop down list you choose the table that you want to edit Current Table Concept Type i of records 4 The four Text boxes listed below the Common Table drop down list let you know what table you are editing and the number of records that are currently in the table In this example we are editing the Concept Type table and there are 4 records 137 USER MANUAL SPARKS January 28 2003 20004 Vendng The data grid below the four label text boxes shows the value of all the records in the current table To change the record you are currently pointing to you single click the small box next to the code field gt Delete Selected Record DELETE SELECTED RECORD Button Whatever record you have chosen will be deleted when this button is clicked Modify Records MODIFY RECORDS Button Whatever record you have chosen will be available to edit when this button is clicked The form will change as seen below 138 USER MANUAL SPARKS January 28 2003 SPARES Common Lookup Tables Manager SPARKS Common Database Tables select a Common Table ta Update Concept Type Current Table E Type of records 4 o Lescinian Record Update 1 01 User name
33. 2003 C BUTTON BAR PTC Site Planning Asset and Resource Knowledge System User ROTDE 3 4 o Route and SiteName County Municipality Showing record 1 of 227 fa 20 10 New service plaza Montgomery Plymouth Begin EndM P Direction Station Fare Collection Dist Maint District Site Type Located Between 20 10 20 90 NB 123 45 2 4 Service Plaza 2 Site Detail Buildings Fuel Info Concepts Insp Services Leases Utilities Parking Opening Date 3 2 1995 Site Status HISTORICAL Last Record Update 11 7 2002 tes Mailing Address Desc Comment 7 Legislator Address 2 Legislative District city egislative Distric State Zip Hours of Operation Open24Hours Open 7 00AM Closed Service Plaza Usage Type Number of Non Revenue Cards Issued 12 Longitude 24 5555555555 Latitude v Tum amp round Back Gate Access Operator Contact Access Road Name R Insurance Information Access Road Description Property Information Record Validation 10 28 2002 ROTDEV3 Validate Site Record File Administrative Tasks For all of the Buttons the button bar if you move your mouse over the button and leave it there for a brief moment a Tool Tip will appear explaining what the button does The tool tips for each button appear next to the picture of the buttons below REP
34. 28 2003 a DELETE Button When this button is clicked you will be prompted to see if you actually want to delete the current record Delete Record Confirmation 2 ARE YOU SURE YOU WANT TO DELETE THE CURRENT CONSTRUCTION HISTORY RECORD If the YES Button is clicked the record will be removed from the database If the Button is clicked nothing will happen lt gt gt RECORD NAVIGATION Buttons Allow you to scroll through the each of the roofs for the buildings at the Site These navigation buttons function in the same manner as the main navigation buttons Browse All Records BROWSE ALL RECORDS Button Will open the browse form showing the construction history records For more details about the browse form please refer to Chapter 4 Section 216 USER MANUAL SPARKS January 28 2003 CHAPTER SEVEN PRINTING REPORTS This document does not show an example of each report Chapter 7 is broken into 2 sections REPORTS LIST ADDITIONAL FORMS When you click the REPORTS button The reports selection form opens SPARKS Report Selection Select the desired report from the list below Facility List Restaurant Sales and Rental Detail Report Restaurant Sales Revenue Summary Report Serice Station Sales and Rental Detail Report Semice Station Sales Revenue Summary Report Annual Inspection Report Service Station Inspection Query Restaurant Inspection Query Rest Roo
35. Button 104 General Site 105 Tab Control Information essen 106 B MENU OPTIONS esterni tet t 107 File Menu MEME 107 Administrative Tasks 0 0 cccccccccccccccscescceseeccccscesccsseescesscesecssecscesscscessceseeess 108 C 2 2 0 0000000000000000000000 sete teet ee trenes 112 D GENERAL SITE INFORMATION eene nnn n nnnm nnne eut 116 E SITE DETAIL INFORMATIONN eene n nnnm nmn 121 F BUILDINGS nnn nnn nnm nemen retenus 124 FUELINFORMATION maru 126 H CONCEPTS 2 0022 10000000000000000000 entente rentre 128 I INSPECTIONS AND SERVICES INFORMATION enn 130 7 LEASEINFORMATION 131 5 20 0 0 02 0 00000000000000 133 L 2 0 0 0 0 008100000 nnnm 135 CHAPTER FIVE MENU AND BUTTON FUNCTIONALITY rr 137 A EDITING COMMON LOOKUP 5 2 2 2 0000000000000000 137 B BROWSING 022 4 68 00000000000 141 USER MANUAL SPARKS January 28 2003
36. Button the record will remain in the database 154 USER MANUAL SPARKS January 28 2003 SAVE Button This button will appear after you have hit the WEW button or the EDIT button When this button is clicked any field changes will be saved to the database CANCEL Button This button will appear after you have hit the VEW button or the EDIT button When this button is clicked any field changes will be lost and any original field values will be restored 155 PENNA TURN Pire USER MANUAL SPARKS January 28 2003 F QUICK FIND p open If the QUICK FIND Button is clicked from the button bar the Quick Find form will Quick Find for Site Select by Site name Mainline Toll Find Site Houte Milepost T 1 43 m Find Milepost Cancel Select by Site name Mainline Tall Plaza Select by Site Name drop down list Choose the site that you want to move to from the list by clicking the and single clicking the site name from the list Find Site FIND SITE Button Will move the record pointer to the site that matches the site name form the Site Name drop down list The Quick Find form will close and control will be returned to the main form The site with the site name chosen will now be displaying on the main form Route Milepost 1 43 Route drop down list and Milepost drop down list Choose a Route and Milepost value by
37. Direction and Site Type 11 USER MANUAL SPARKS January 28 2003 The Engineering Design Department Roadway Section should also add information on the Site Detail Tab Site Detail Buildings Fuel Info Concepts Insp Services Parking Opening Date Gite Status E Last Record Update Mailing Address Desc Comment Legislator Address 2 m T Entr City Legislative District nee State Ip Hours of Operation 24 Open Closed E Park and Ride Available Direction Number of Mon Revenue Cards Issued Tall Plaza Collection Info Longitude Latitude Tum Around Back Gate Access Operator Contact ota atm at am aa ota hm at aa am atm atm ate aa sta aa afm afm aha ate am atm ae afm atm stm ota 9 T XEEXEZXXXEEXXEXXXEXXEXXXEXXEXXXXxxxxxxxxxxXxxxxxxxxxxxEExXxXXEEXEXXXEXEXXXEXEXEXI Insurance Information Property Information Record Validation 01 27 2003 STONTOS Validate Site Record 12 USER MANUAL SPARKS January 28 2003 Single Click the Save button to save the changes to the database PTC Site Planning Asset and Resource Knowledge System User Eile Administrative Tasks General Site Information Route and Milepost _ SiteName County Municipality Showing record 1 of 227 pe
38. Footage 33 00 LLL 3 Construction History Coed sti Construction Maternal Record Validation 1022822002 ROTDEYS Validate Bld Structure Record The buildings tab contains a record for each of the buildings the site Fields Available Building Structure Name A text field that contains the name of the Building Building Structure Type The Type of building The valid values are available in the drop down list Location A text field that contains the location on the site where the building is located Comment A text field containing any additional comments regarding the Building Fire Detection System Provides an explanation of the Fire Detection system Fire Suppression System Provides an explanation of the Fire Suppression system Gross Square Footage A numerical value representing the Square Footage of the building Capacity A numerical value representing the legal number of people that can be in the building 124 USER MANUAL SPARKS January 28 2003 Building Structure Status The status of the building The valid values are available in the drop down list Construction Material A text field describing the materials used in the construction of the building Buttons Available Roof Details ROOF DETAILS Button Opens the Roof Details form For more details on the Roof Details form please refer to Chapter 6 Section E Equipment EQUIPMENT Button Opens the Equipment form F
39. L Application Process c gt Decision Process 59 USER MANUAL SPARKS January 28 2003 Adding Concepts Information is done in three completely separate tasks Task 1 can be completed upon learning the vendors concepts that will be part of the service plaza record Task 2 can be completed upon receiving a copy of the signed lease agreement from the vendor concept Task 3 can be completed upon receiving the sales reports from the vendor concepts TASK 1 Step 1 The Concessions Management department should add the Vendor Concepts information for each vendor concept Figure D 1 ADD MAIN CONCEPT INFORMATION site Detail Building Fuel Into Concepts Insp services Leases Litilities Parking Last Record Update 10 22 2002 Vendor Mame Site Operator Arbys Concept Site Number Location at Site tthis iz a test Description Restaurant Concept Square Footage 1545 00 Hours of Operation Open 24 Hours Open 15 Closed 15 48 s Sales Information Insurance Information Hental Hate Information Contact Information 60 USER MANUAL SPARKS January 28 2003 Step 2 The Concessions Management Department should enter the Vendor Concept Contact Information for each Vendor Concept The Vendor Concept Contact Information form is accessible from the Concepts Tab site Detail Building Fuel Info Concepts Inspiservices Leases Parking Last Record Up
40. Location A text field representing the location of the meter if this utility uses a meter Materials Used A text field representing the materials used for the meter used by this utility Size A text field representing the size of the meter for this utility if a meter is used Responsible Party A text field representing who is responsible for the meter if there s one for this utility 133 USER MANUAL SPARKS January 28 2003 Buttons Available lt gt RECORD NAVIGATION Buttons Allow you to scroll through the utilities for the Site These navigation buttons function in the same manner as the main navigation buttons If the Utility Type Water System System Detalls SYSTEM DETAILS Button Opens the Water System Details form For more details on the Water System Details form please refer to Chapter 6 Section M Contact Information CONTACT INFORMATION Button Opens the Contact Information form For more details on the Contact Information form please refer to Chapter 6 Section A 134 USER MANUAL SPARKS January 28 2003 L PARKING INFORMATION site Detail Buildings Fuel Info Concepts Insp Servicez Leases Parking Last Record Update 10 28 2002 Number of Spaces Cars 120 Handicap 222 Trucks 222 Oversize 222 Buses 2223 Employee 222 Overnight Restrictions Parking Lot Construction A enovation History Fields Available Number of Spaces Cars The numbe
41. MANUAL SPARKS January 28 2003 If the vendor is a Fuel Vendor then continue with Step 1a Stepia Upon receiving a copy of the Vendor Concept Sales data the Concessions Management department should add the Sales Information for each Vendor Concept The Sales Information Form is accessible from the Concepts Tab site Detail Building Fuel Info Concepts Inspiservices Leases Parking Last Record Update 10 22 2002 Vendor Mame Site Operator Concept Site Number Location at Site tthis is a test Description Concept Type Restaurant Concept Square Footage 1545 00 Hours of Operation Open 24 Hours Open 15 AM Closed 16 48 lt Sales Information Insurance Information Contact Information 71 USER MANUAL SPARKS January 28 2003 Figure D 7 ADD FUEL SALES INFORMATION vi Vendo Year Period Gal Gas Gal Diesel Gal OtherSales Phone Phenecards Rent Rent Due Diesel Rate Dy 202 5 anto 800000 10000 1500 000 000 100000 1000000 0031 sueco 22 4 1800000 1500000 27500 100000 15000 10000 6000000 600000 0046 seo 202 3 380000 80000 10000 100 00 190000 19000 0046 sueco e 2 1 00000 100000 20000 150000 180000 50000 45000 450001 000 sme o 1 980 88800 15000 120000 5404 500 440000 44000 0081 sueco 20 5 78000 810000 10500 15500 10044 2000 30000 300000 0091 Service Station Sales Information For more details
42. Number Location at Site tthis iz a test Description Concept Type Restaurant Concept Square Footage 1545 00 Hours of Operation Open 24 Hours Open 15 Closed 16 48 k l gt lt Sales Information Insurance Information Hental Hate Information Contact Information Figure D 4 ADDING VENDOR CONCEPT INSURANCE INFORMATION Insurance Information Site New service plaza test Last Record Update 14 20 2002 Insurance Company Erie Insane Policy Number Equipment Boiler 00000 Insurance Type Liability Insurance Policy Effective Date 1040 2000 Policy Expiration Date 10 10 2003 Insurance Contact Info 10000 D eductible H For more details on the INSURANCE INFORMATION FORM please refer to Chapter 6 Section B 66 PENA 4 TURN Pire USER MANUAL SPARKS January 28 2003 Step 6 The Risk Management department should add the Vendor Concept Insurance Contact Information for each Vendor Concept The Insurance Contact form is accessible from the Vendor Concept Insurance form Insurance Information Site New service plaza test Last Record Update 12720 2002 Insurance Company Name Erie Insane 0005 0 0020200 Policy Number Equipment Boiler Insurance Type Liability Insurance 4 Policy Effective Date 1000 2002 Policy Expiration Date 10 10 2003 Insurance Contact Infa Deductible 10000 a 7 67
43. SPARKS January 28 2003 Buttons Available 9 EXIT Button Will Close the Insurance Information Form and return control to the main form 2 EDIT Button Will change any field that be changed to a light blue color EDIT button will become the CANCEL Button and the SAVE Button will be enabled Insurance Information Fuel Info New service plaza Last Record Update Insurance Company Mame Policy Number Insurance Policy Effective Date Policy Expiration Date aj 9 CANCEL Button Appears when the D 7 Button is clicked When this button is clicked any field changes will be lost and any original field values will be restored SAVE Button Becomes enabled when the D 7 button is clicked When this button is clicked all changes will be saved to the database 171 a DELETE Button When this button is clicked you will be prompted to see if you actually want to delete the current record USER MANUAL SPARKS January 28 2003 Record Delete Confirmation ARE YOU SURE YOU TO DELETE THE CURRENT INSURANCE RECORD If the YES Button is clicked the record will be removed from the database If the Button is clicked nothing will happen 172 Jt USER MANUAL SPARKS January 28 2003 C PROPERTY INFORMATION FORM The Property Information form contains information about the physical property where the
44. The Equipment Form contains information for each piece of equipment that is at the Site The Equipment Form is only available from the Buildings Tab Equipment Lansdale Interchange Main Building Equipment Msc mr Last Record Update 8 20 2002 Description Misc Equip Location 5 Date Installed Serial Number P Model Number Manufacturer 00 Capacities Area Served Fuel Power Supply Comments E wm Warranty Information Fields Available Equipment Type The Type of Equipment All valid values are accessible from the drop down list Description A text field containing the description of the equipment Location A text field containing the location at the site where the equipment is Date Installed The date the equipment became operational The format for the date is MM DD YYYY Serial Number A text field containing the serial number off the equipment 183 USER MANUAL SPARKS January 28 2003 Model Number A text field containing the model number for the equipment Manufacturer text field containing the name of the manufacturer for the equipment Capacities A text field containing the capacity levels for the equipment Area Served A text field describing the area of the Site that is serviced by the equipment Fuel Type Power Supply A text field describing the Fuel Type used or the type of power used to operate the equipment Comments A
45. USER MANUAL SPARKS January 28 2003 Figure D 5 ADDING VENDOR CONCEPT INSURANCE CONTACT INFO Contact Information For more details on the CONTACT INFORMATION FORM please refer to Chapter 6 Section A 68 PENNA TURN 2 5 2 USER MANUAL SPARKS January 28 2003 Step1 Upon receiving copy of the signed Vendor Concept Lease the Concessions Management department should add the Rental Rate Information for each Vendor Concept The Rental Rate Information Form is accessible from the Concepts Tab site Detail Building Fuel Into Concepts Inspiservices Leases Ltilties Parking Last Record Update 10 22 2002 Vendor Mame Site Operator Arbys Location at Site tthis is atest Description Concept Site Number Concept Type Restaurant Concept Square Footage 1545 00 Hours of Operation Open 24 Hours Open 154M Closed 16 48 lt Sales Information Insurance Information Rental Aate Information Contact Information 69 USER MANUAL SPARKS January 28 2003 Figure D 6 ADDING RENTAL RATE INFORMATION m Rental Rates New service plaza test building 2 x Concept endor Arbys Resturant Rates Base Percentage Tier 2 Percent Tier 2 Amount Tier 3 Percent Tier 3 Amount Annual Minimum Rental Term years For more details on the RENTAL RATE INFORMATION FORM please refer to Chapter 6 Section J 70 a TASK 3 USER
46. be lost and any original field values will be restored SAVE Button Becomes enabled when the D 7 button is clicked When this button is clicked all changes will be saved to the database 187 USER MANUAL SPARKS January 28 2003 DELETE Button When this button is clicked you will be prompted to see if you actually want to delete the current record Equipment Delete Confirmation ARE YOU SURE YOU SANT TO DELETE THE CURRENT EQUIPMENT RECORD If the YES Button is clicked the record will be removed from the database If the Button is clicked nothing will happen lt 9 RECORD NAVIGATION Buttons Allow you to scroll through the each of the roofs for the buildings at the Site These navigation buttons function in the same manner as the main navigation buttons 188 4 TURN USER MANUAL SPARKS January 28 2003 G RESTROOMS FORM The Restrooms form contains information for each restroom at the Site The Restroom Form is only available from the Buildings Tab Rest Room Information Quakertown Maintanence Shed test Last Record Update Rest Room ID Rest Room Type Toilets Hand Dryers Urinals Towel Holders Sinks Sensor Flush Unita Handicap Sensor Operated Sinks Showers Vending Machines Baby Change Station Attendant Duty Fields Available Rest Room ID A unique number created by the system when a new re
47. clicking on the next to each and single clicking the values you wish to find 156 USER MANUAL SPARKS January 28 2003 Find Milepost FIND MILEPOST Button Will move the record pointer to the site that matches the route and milepost values chosen for the drop down lists The Quick Find form will close and control will be returned to the main form The site with the route and milepost values chosen will now be displaying on the main form 157 USER MANUAL SPARKS January 28 2003 G DEALING WITH PICTURES Ta DE Or If the PICTURES Button is clicked the Select Sparks photos form will open Select Sparks Photos Lansdale Interchange Lansdale Interchange Select Photo Type Site Fuel Info Eoncept endar Structure Utilities Equipment Find Photos Add New Protos 5 3 Display Selected Photo Langdale Interchange A label in the top middle of the form displays the name of the site that you are currently residing on 158 USER MANUAL SPARKS January 28 2003 Select Photo Type Site Fuel Info f Concept endar Structure Utilities Equipment The first thing you must do is select the Photo Type that interests you Notice that some of the Photo types may be grayed out because they are not relevant to the Site In this example we are looking at an Interchange so Concepts Vendors are not relevant Add New Photos ADD NEW PHOTOS Button
48. on the SALES INFORMATION FORM please refer to Chapter 6 Section 72 PENNA TURN i Pire If the vendor is a Fuel Vendor then continue with Step 1b USER MANUAL SPARKS January 28 2003 Stepib Upon receiving a copy of the Vendor Concept Sales data the Concessions Management department should add the Sales Information for each Vendor Concept The Sales Information Form is accessible from the Concepts Tab site Detail Building Fuel Info Concepts Inspiservices Leases LItilitie s Parking Last Record Update 10 22 2002 Vendor Mame Site Operator Concept Site Number Location at Site tthis is a best Description Concept Type Restaurant Concept Square Footage 1545 00 Hours of Operation Open 24 Hours Open 7 115 Closed 16 48 lt Information Insurance infomation Information Contact Information 73 USER MANUAL SPARKS January 28 2003 Figure D 8 ADDING NON FUEL SALES INFORMATION Service Station Sales Data New service plaza test building 2 Vendor ear Updated bys 421401222 1 26 20 9 Pancake Houd 202 0 149 1312300T1 28 200 ofpancakes 2 13 115 besessen 11 28 2002 Jorinese Chicken 072672002 E PFO House of Hamburgers 2008 jMatshiant se 232 0172672002 NewvRKPZZA ama 13
49. site resides The Property Information form is accessed from the Site Detail tab only Property Detail Information New service plaza Acreage Last Record Update 107 2872002 3000 00 Deed Book Deed Book Page Number 23 29 Deed Number 008 Hight afv ay Information 23 feet to the right Z3 feet to the lett gt Acreage A numerical value representing the total acres that encompass the site Fields Available Deed Book A numerical value representing the book number where the deed for the site is kept Deed Book Page Number A numerical value representing the first page in the deed book where the deed for this site resides Deed Number The deed number assigned to the deed for this site Right of Way Information A text field in which any right of way information is 173 USER MANUAL SPARKS January 28 2003 Buttons Available Button Will Close the Property Information Form and return control to the main form 2 EDIT Button Will change any field that can be changed to a light blue color The EDIT button will become the CANCEL Button and the SAVE Button will be enabled Property Detail Information New service plaza Acreage Last Record Update 107 2872002 CFEEFEFEZIE EZEELZFELEELEEZLEEEELZLELI EXEXEXZXCXZXXZXXNEXXZEXEXEXZXXZAXXX 3000 00 WEXXNXNENZNNXNXNNXNXXXNENNXXNXENX E mm mm mm mom mom mom mom mw mum mm b ub min min m b min min mi
50. the D 7 Button is clicked When this button is clicked any field changes will be lost and any original field values will be restored SAVE Button Becomes enabled when the D 7 button is clicked When this button is clicked all changes will be saved to the database Add Selected Service Type gt gt ADD SELECTED SERVICE TYPE Button Will move any highlighted value from the Available Toll Service Types list box to the Service Types Available at this Site data grid If the value is already in the table the following message will appear 206 USER MANUAL SPARKS January 28 2003 SPARKS Application Message e This Service Type Currently Exists ADD z Remove Selected Service Type From this Site REMOVE SELECTED SERVICE TYPE FROM THIS SITE Button Will remove the line in the data grid with the gt from this Site 207 USER MANUAL SPARKS January 28 2003 L WASTE WATER SYSTEM DETAILS FORM The Waste Water System Details Form contains information about the waste water system at the site The form will appear when the SYSTEM DETAILS Button is clicked on the Utilities tab if the Utility Type is Waste Water System The Waste Water System form is only accessible from the Utilities tab m Waste Water System Details New service plaza Sewer Milepost Install Date Sewer Authority National Pollutant Discharge Elimination System HPDES Permit Number Permit Expira
51. the Lease information on the Lease Tab Figure F 1 ADDING LEASE INFORMATION site Detail Building Fuel Info Concepts nap Services Leases Litilitie a Parking Last Record Update 10 17 2002 Lease Contract Information Lease Number Operator Mame Date Executed 03 01 2000 Lease operator Start D ate 0371572000 p Expiration Date 02 02 2002 Extension Date 03 16 2006 Terms For more details the LEASE INFORMATION please refer to Chapter 4 Section J 84 USER MANUAL SPARKS January 28 2003 Add Leases Check List Concessions Management Department o Add Leases Info 85 USER MANUAL SPARKS January 28 2003 G ADDING UTILITIES See the diagram on the next page 86 USER MANUAL SPARKS January 28 2003 ADD UTILITIES Organizational Process Application Process Decision Process ALL ACTIVITIES PERFORMED THIS FLOW ARE BY THE ENGINEERING FACILITIES DEPARTMENT 87 USER MANUAL SPARKS January 28 2003 Step 1 The Engineering Facilities Department should add the Main Utility information on the Utilities Tab Figure G 1 ADDING MAIN UTILITY INFORMATION site Detail Building Fuel Info Concepts Inspi servicez Leases Utilities Parking Last Record Update 11 4 2002 Utility Information Utility Utility Provider 2 Water System Account Number Meter Location Materials Used Size
52. the field you wish to sort on by single clicking the field In this example Site_Name has been chosen 150 TURN PIKE USER MANUAL SPARKS January 28 2003 1 4 Ascending ASCENDING Button When this button is clicked the field highlighted in the fields available and the letters ASC will be moved into the selected fields list box Descending DESCENDING Button When this button is clicked the field highlighted in the fields available and the letters DESC will be moved into the selected fields list box Remove REMOVE Button This button is used to remove fields from the selected fields list box To remove a field single click it and use this button Done DONE Button This button will close the SORT form any sorting options in the selected fields list box will be processed and control will be returned to the main form Selected Fields SITE ASC The selected fields list box shows the results of the sort statements you have selected 151 USER MANUAL SPARKS January 28 2003 E APPLICATION SECURITY Last Record Update 12 30 2002 LOGON USER ID BRODGERS Allow User Update Access to the following Secunty Groups can choose more than 1 from this Group Security Edit Lookup T ables Photos Traffic D emographics Choose 1 fram thie Group Roadway Section Risk Management Dept Right of Way Section w Facilities Department fw Conce
53. 02 Insurance Company Erie Insane 0000000000000 Policy Number Equipment Boiler 00000 Insurance Type Liability Insurance Policy Effective Date 1040 2000 Policy Expiration Date 10 10 2003 Insurance Contact Info 10000 D eductible H For more details on the Toll Collection Types Form please refer to Chapter 6 Section B 23 PENA TURN i PIRE USER MANUAL SPARKS January 28 2003 Step 8 The Engineering Design Roadway Section should add the Site Parking Lot information including the Parking Lot Construction History The parking information is accessed on the Parking Tab Figure A 10 ADD PARKING LOT INFORMATION Parking Last Accord Update 10 28 2002 Number of Spacer 12 Hardicap 222 Trucks 222 Oversize 222 Buses gt Employer 222 Overman Riexstrictians Parking Lot Construction Renovation History Parking Lot Construcktion Renovation History New service plaza Last Record Update 10 29 2002 Parking Construction Type Pavement Type Gravel Construction Date 101142002 Parking Lot Description Browse All Records ET ees psu VA For more details on the Toll Collection Types Form please refer to Chapter 6 Section O 24 USER MANUAL SPARKS January 28 2003 Step 9 The Engineering Facilities department should add the remaining Site information on the Site Detail Tab Figure
54. 1 13 Year 2002 Cancel This form appears if you choose of the Sales reports Restaurant Sales and Rental Detail Report Restaurant Sales Revenue Summary Service Station Sales and Rental Detail Report Service Station Sales Revenue Summary Report Period 1 13 Enter a value from 1 13 for the period you wish to print sales data for Year xxxx Enter a four digit year to print sales data for OK Button Will open the crystal report for the period and year chosen If there is data for that period the following message will appear SPARKS Application Message xX Records to Print Far Ehe Selected Report 221 USER MANUAL SPARKS January 28 2003 Cancel CANCEL Button Will close the Select Period form and return control to the Select Report form Select a Year Select a Report Tear Year xxx 2002 Cancel This form appears if you choose the Annual Inspection Report Year xxxx Enter a four digit year to print the Annual Inspection report for OK Button Will open the crystal report for year chosen If there is no data for that year the following message will appear SPARKS Application Message e Records to Print Far Ehe Selected Report Cancel CANCEL Button Will close the Select Period form and return control to the Select Report form 227 USER MANUAL SPARKS January 28 2003 CHA
55. 13 jthneseChckenShadk 22 13 2 13 08 Matts House ofHambuges 2002 i3 1028 2002 MalslalanDusne 200 13 0728 00 NEWYORKPEZA i3 S YON Bos Magical Pancake Houd 2002 3 So 47850 712200 10 21 2002 Buska 09 254550 525700 10 21 2002 2208 12X 212150 547700 10 21 2002 italan Cusine 200 3 120 1259801 278500 10 21 2002 NEWYORKPZZA _ 20 3 270 21878870 212588500 10 21 2002 Breyerslee Cream 200 940 900 9000100272002 Burger Kin 72428 5800 60000010 2 2002 rn Con Tn gna od 03 J A data grid on the form contains all the sales information The data grid is sorted by Year and period The data grid is locked when the form opens Therefore you cannot change any values without using the D 7 Button or the WEW Button Buttons Available Y SELECTION Button Opens the query form For more details on how to use the query form please refer to Chapter 4 Section C x SELECT ALL Button If you have a limited selection when this button is clicked it will show all of the records 195 USER MANUAL SPARKS January 28 2003 EXIT Button Will Close the Sales Information Form and return control to the main form Fd EDIT Button Will make any data that can be changed a light blue color The ED T button will become the CANCEL B
56. 37 Quakertown MaintanentA 3 Bucks 4374 043777 usketowninerchang 4377 Bucks 4377 051 005 SouhMounsnTowe 1 5 55 Allentown Service Staiga 588 Lehigh 555 L jamz3irR Lehigh Valey IntechanjA 5731 Lehigh South Whitehall 573 A0700 _ Slatington Maintanence A 7007 Lehigh 7007 407005 MantenancelA 77007 Lehigh Washington 7007 ar02 Lehigh TunnelNo 1 7025 Lehigh 7028 L jaUrinc A 713 Lehigh 12 JASN Lehigh Tunnel No 2 71 56 L janserR Mshoring Valey IntercHA 5 Frankin 588 HikesRunSewicePld 8814 PennFores 8814 7 4090105 Eig Boulder Tower 301 r ab BST H Pocono Interchange 94 59 Carbon Kidder 94 59 The data grid shows all the records the table unless a customization has been done by using the select button or the customize data grid button 144 USER MANUAL SPARKS January 28 2003 C RUNNING A QUERY When the Selection Button is chosen from the main form the Select Record form opens Select Records to Display Select to Display ONLY Records for one of the following Site Types Toll Collection Bus Expansion Communication Equipment Facilities Expansion Info Management Tunnel Other Service Plaza Roadway Cancel Query Builder
57. 72001 Root Manufacturer Roof waranty Warranty Date Warranty Exp Date Warranty Company Warranty Description Comments Waranty Contact 36 USER MANUAL SPARKS January 28 2003 Figure B 4 ADD WARRANTY CONTACT INFORMATION Contact Information Last Record Update Contact Type warranty Mame Company Title Address City 50505 State Hl Zip code NEED Phone O Fax 2 Email O OE Emergency Contact Number Responsible Hours For more details on the CONTACT INFORMATION FORM please refer to Chapter 6 Section A 37 USER MANUAL SPARKS January 28 2003 If there is Equipment in the building then continue with Step 5 Step 5 The Engineering Facilities Department should add the Equipment information for each piece of equipment in the building The Equipment information Form is accessed from the Buildings Tab site Detail Buildings Fuel Info Concepts Insp Servicez Leases Lhilities Parking Last Record Update 10 28 2002 Building Structure Information Building Structure Type Building Structure Mame testing Main Service Plaza Building Location Roof Details Comment hhkjhk System Fire Suppression Rest Rooms Gross Square Footage Sait Construction History Building Structure SIE Closed Construction Material Record Validation 1022822002 lt gt Validate Bld
58. A 11 ADD REMAINING SITE INFORMATION Site Detail Buildings Fuel Into Concepts Inzpiservices Leases Ltilities Parking Opening Date 3 2 1335 Site Status Open Last Record Update 11 26 2002 i Mailing Address Desc Comment Legislator Address 2 Legislative District City egislative Distric State Hours of Operation Open 24 Hours Open 2 00 Closed Service Plaza Usage Type Number of Man Hevenue Cards Issued 12 Uther Longitude 124 5555555555 Latitude Back Gate Access Operator Contact Access Road Name Insurance Information Access Road Description Property Infarmatian Record Validation 10 28 2002 ROTDEYS Validate Site Record 25 USER MANUAL SPARKS January 28 2003 Step 10 The Engineering Design Roadway Section should validate the site The Validate Site button is accessible from the Site Detail Tab Figure A 12 VALIDATE SITE INFORMATION Site Detail Buildings Fuel Into Concepts Insp services Leases Ltilities Parking Opening Date 3 2 1335 Cite Status Open Last Record Update 11 26 2002 test z Mailing Address Desc Comment Rest 4 Legislator Address 2 City Legislative District State ip Hours of Operation Open24Hous Open 7 00AM Closed Service Plaza Usage Type Number af Mon Hevenue Cards Issued 12 Uther Longitude 124 5555555555 Latitude Tur
59. Amos K Hutchinson Bypass M Mon Fayette Expressway 116 USER MANUAL SPARKS January 28 2003 Milepost Unique designator for the mile marker from the Turnpike s Roadway where the site resides e The accepted values for the Milepost field are o If Route T then Milepost can be between 0 00 and 359 00 If Route A then Milepost can be between 20 0 and 130 64 o If Route then Milepost can be between 28 47 and 44 87 o If Route then Milepost can be between 0 3 and 13 41 o If Route then Milepost can be between 1 6 and 7 84 e Or Milepost can be between 30 00 and 35 62 Site Name Unique designator for name of the Facility The Radio Button next to the Route Milepost Label will sort all records by the Route and Milepost values This is the default order when the application starts The Radio button next to the Site Name label will sort all the records by Site Name County Municipality Showing record 1 of 222 Montgomery Plymouth County Identifies the county in which the Site resides You cannot edit this field The field will be automatically filled in once you save the record with a proper route and milepost value Municipality Identifies the municipality in which the Site resides You cannot edit this field The field will be automatically filled in once you save the record with a proper route and milepost value Showing record 1 of 222 label Lets you know your current position in the main table Thi
60. Between These two fields identify the Exits that the site falls between You cannot edit either of these fields 120 USER MANUAL SPARKS January 28 2003 E SITE DETAIL INFORMATION Site Detail Buildings Fuel Info Concepts Insp services Leases Utilities Parking Opening Date 3 2 1385 Site Status HISTORICAL Last Record Update 10 28 2002 test Mailing Address Desc Comment d Legislator Address 2 City Legislative District State Hours of Operation Open 24 Hours Open 2 00 AM Closed Service Plaza Usage Type Humber of Mon Hevenue Cards Issued 12 Other Longitude 124 5555555555 Latitude Turm ound Back Gate Access perator L antact Access Haad Mame Insurance Information Access Road Description Property Information Record Validation 10 28 2002 ROTDEVS Validate Site Record Fields Available Opening Date A date field that represents when the site opened The date should be formatted as follows MM DD YYYY Site Status Represents the current status of the Site The valid values are available in the drop down list Desc Comment A free form field that allows you to enter any additional comments about the site Legislator The name of the Legislator who is responsible for the area the site is located Legislative District A unique numerical representation for the district of the legislator listed in the legislator field Hours of O
61. C 3 ADD FUEL INFO PHOTOS Select Sparks Photos New service plaza Brsplay selected rata 54 USER MANUAL SPARKS January 28 2003 TASK 2 Step 1 The Risk Management department should add the Fuel Insurance Information The Fuel Insurance information form can be accessed from the Fuel Tab Fuel Info Concepts Insp servicez Leases Utilities Farking Site Detail Buildings Last Record Update 117772002 Corporate Name asd asdfasdfasdi Convenience Store Location Pay at the Pump Service Number of Islands Number of Pumps Emergency Plan Number of Full Service Pumps Minimum Canopy Clearance Ft Fuel Brand Sunoco Canopy Light type NEED Fire Suppression System Inspection Date Description M Contact Information Leak Detection System Spill Control Plan Insurance Information De icing materials used Monitoring Well Infa Figure C 4 ADD FUEL INSURANCE INFORMATION Insurance Information Site New service plaza test D Last Record Update 14 20 2002 Insurance Company Erie Insane 000000000000 Policy Number Equipment Boiler 000 Insurance Type Liability Insurance Policy Effective Date 10702002 Policy Expiration Date 10 10 2003 Insurance Contact Info 10000 Deductible For more details on the INSURANCE INFORMATION FORM please refer to Chapter 6 Section 55 T USER MANUAL SPARKS January 28 2003 Step 2 The Risk Ma
62. Check the box if the user is a member of the Roadway Section Edit group This check box determines if the D 7 NEW and DELETE buttons appear in the button bar Right of Way Check Box Check the box if the user is a member of the Right of Way Edit Group Concessions Inspectors Check Box Check the box if the user is a member of the Concessions Inspectors Edit Group Risk Management Department Check Box Check the box if the user is a member of the Risk Management Department Edit group Facilities Department Check Box Check the box if the user is a member of the Facilities Department Edit Group Read Only Check Box Check the box if the user has read only access to the application 153 USER MANUAL SPARKS January 28 2003 Buttons Available CLOSE Button Will close the security form and return control to the main form RECORD NAVIGATION Buttons Allow you to scroll through the records in the Security table These buttons function in the same manner as all the other RECORD NAVIGATION buttons in the application NEW Button Will clear all the fields allowing you add a new user 2 EDIT Button Will unlock the fields so that you can change the values a DELETE Button Will prompt you to be sure you want to delete the current user Delete the Current Record 2 Are vou sure you want to delete user MBORTZ If you click the YES Button the record will be deleted If you click the VO
63. District Site Located Between 2010 20 90 NE 123 45 2 4 Service Plaza and en Site Detail Buildings Fuel Into Concepts Inspi services Leases Utilities Farking Opening Date 27271996 Site Status HISTORICAL Last Record Update 11 7 2002 test z Mailing Address Desc Comment fet addes Legislator Address 2 Legislative District Ciy egislative Distric State Hours of Operation Open 24 Hours Open TOO AM Closed Service Plaza Usage Number of Nan Revenue Cards Issued 14 Other Longitude 124 5555555555 Latitude Tum amp mund Back Gate Access perator Contact Access Hoad Insurance Information Access Road Description Property Information Record Validation 10 26 2002 ROTDEYS Validate Site Record 107 PENA USER MANUAL SPARKS January 28 2003 Administrative Tasks The Administrative Tasks menu can be accessed by single clicking the menu option or by using the shortcut key ALT There are four sub menu options in the Administrative Tasks Menu Two of those options are available at this time 1 EDIT COMMON LOOKUP TABLES OPTION The first option that is available is Edit Common Lookup Tables This option can be accessed by single clicking the menu option or by using the shortcut key CTRL E Site Planning Asset and Resource Knowledge System User ROTDEY3
64. District Site Type Exit Old Num 30 13 30 13 555 00 4 Toll Plaza 31 Site Detail Buildings Fuel Info Concepts Insp Services Leases Utilities Parking Opening Date 12 12 2002 Site Status HISTORICAL Last Record Update 10 8 2008 the landsdale interchange Mailing Address Desc Comment ire Address 1 Legislator legislator 12 Address 2 e TE Entry City Legislative District legislative district Direction State E Hours of Operation 24 Open Closed Exit Park and Ride Available Direction Number of Mon Hevenue Cards Issued 5 Tall Plaza Collection Info Longitude Latitude 9 Back Gate Access Operator Contact Access Road Mame Insurance Information Access Road Description Property Infarmatian Record Validation 08 06 2002 BRODGERS Validate Site Record 32 USER MANUAL SPARKS January 28 2003 Upay selected Photo For more details on the SPARKS PHOTOS FORM please refer to Chapter 5 Section G 33 USER MANUAL SPARKS January 28 2003 If there are utilities being used with the building then refer to the Adding Utilities Flow Step 3 The Engineering Facilities Department should add the Roof Details information The Roof Details form is accessed from the Buildings Tab site Detail Buildings Fuel Info Concepts nap Services Leases
65. ECORD Button This will only be available if the equipment type Is pressure vessel Warranty Information Pressure Vessel Details Labor and Industry Number Humber Vessel XEXXMZXXEMZXEMEXXXEEXXXEXXXEZNXXXIMXX XEXXEXEXXEEXEXXEXXEXEXEXXXEXIBWE MEEZEXEENXXMEEXXMENEXXEEXEXENMM FEE HHNH HHHH HEHA XXEX FEE FEE KENA FEE HHHH HEHA BENE HEEN HAE HHN FEE FEE x x x x x x Xx x x x x x x x PA Labor and Industry Number A text field containing the PA Department of Labor and Industry Number for the Pressure Vessel ID Number A text field containing the Identification Number for the Pressure Vessel Condensate Pumps A text field containing information on the Condensate Pumps Capacity A text field containing the capac
66. IT Button Will make any field that can be changed a light blue color The button will become the CANCEL Button and the SAVE Button will be enabled CANCEL Button Appears when the D 7 Button is clicked When this button is clicked any field changes will be lost and any original field values will be restored 212 T USER MANUAL SPARKS January 28 2003 SAVE Button Becomes enabled when the D 7 button is clicked When this button is clicked all changes will be saved to the database DELETE Button When this button is clicked you will be prompted to see if you actually want to delete the current record Delete Confirmation ARE YOU SURE YOU WANT TO DELETE THE CURRENT RECORD If the YES Button is clicked the record will be removed from the database If the Button is clicked nothing will happen 213 USER MANUAL SPARKS January 28 2003 N PARKING LOT CONSTRUCTION RENOVATION HISTORY FORM The Parking Lot Construction Renovation History Form contains information related to each of the parking lot construction projects at a Site The Parking Lot Construction Renovation History Form is only accessible from the Parking tab Parking Lot Construcktion Renovation History New service plaza Last Record Update 10 29 2002 Parking Construction Type Pavement Type Gravel Construction Date 0 11 2002 Parking Lot Description Browse All Records 4g
67. Number of Full Service Pumps Minimum Canopy Clearance Ft Fuel Brand Sunoca Canopy Light type Fire Suppression System Inspection Date ae Contact Information Description __Dantact Infomation Leak Detection System Insurance Information Spill Control Plan materials used Monitoring Yell Info Concessions Management add Fuel Information please refer to the Adding Fuel Info Flow For more information on the Fuel Tab please refer to Chapter 2 Section C 46 USER MANUAL SPARKS January 28 2003 Step 11 The Engineering Facilities Department should validate the buildings on the buildings tab The validation button is located on the Buildings tab Figure B 11 VALIDATE BUILDINGS STRUCTURES site Detail Buildings Fuel Info Concepts Insp servicez Leases Parking Last Record Update 10 21 2002 Building Structure Information Building Structure Building Structure Mame test building 2 Maintenance Building Location Roof Details Comment Fire Detection Equipment System Fire Suppression 444444244444 Eneken Rest Rooms Grozs Square Capacity Footage Construction History Building tructure lom Status Open Construction Material Record Validation 12 10 2002 47 USER MANUAL SPARKS January 28 2003 Adding a Building Check List Concessions Management o Update Restroom records o Add Fuel Informa
68. ORTS Button Opens the Report Selection Form For more details on printing reports please refer to Chapter 7 112 USER MANUAL SPARKS January 28 2003 BROWSE Button Opens the Browse form For more details on the functionality available on the Browse form please refer to Chapter 4 Section B SELECTION Button Opens the Query form For more details on the how to run Query please refer to Chapter 4 Section C SELECT ALL Button If you have limited the records you are viewing using the Selection button this button will allow you to view all records again SORT Button Opens the Sort Form For more details on how to sort records please refer to Section D of Chapter 4 Sorting Records EDIT Button Puts the application into Edit mode NEW Button Puts the application into Add mode For more details on how to add Records please refer to Chapter 2 DELETE Button Will change the site status of the record from its current value to HISTORICAL For more details on deleting records please refer to Chapter 5 Section C 113 USER MANUAL SPARKS January 28 2003 SECURITY Button Opens the Security Form For more details on the functionality available on the Security Form please refer to Chapter 4 Section E QUICK FIND Button Opens the Quick find Form For more details on the functionality available on the Quick find form please refer to Chapter 4 Section F Ke
69. PIKE Toll Collection Types Available at this Toll Plaza USER MANUAL SPARKS January 28 2003 Collection Type RECORD UPDATE ticket 085 200 DiDmp 10 23 2002 08 15 2002 Toll Collection Types Available at this Toll Plaza shows the types that are currently in use at the Site The Record updated field lets you know the date they were added into the system Buttons Available 51 EXIT Button Will Close the Toll Plaza Collection Form and return control to the main form Fd EDIT Button Will Enable the ADD SELECTED COLLECTION TYPE Button and the REMOVE SELECTED COLLECTION TYPE FROM THIS TOLL PLAZA Button The EDIT button will become the CANCEL Button and the SAVE Button will be enabled 176 USER MANUAL SPARKS January 28 2003 Toll Collection Types Lansdale Interchange Available T oll Toll Collection Types Collection Types Available at this Toll Plaza Collection Type 1 RECORD UPDATE Die 10 28 29 IE lt lt Remove Selected Collection Type Add Selected Collection Type gt gt Sean ae Tal Seas CANCEL Button Appears when the D 7 Button is clicked When this button is clicked any field changes will be lost and any original field values will be restored SAVE Button Becomes enabled when the D 7 button is clicked When this button is clicked all changes will be saved to the database Add Selected Collection Type gt gt
70. PTER EIGHT ONBASE APPLICATION The ONBASE application is the Turnpike s document management application The ONBASE application is used in this project to store images of the Inspection reports that are filled out A APPLICATION LOGON ZOnBsse Double Click the Onbase Icon the Citrix Program Neighborhood OnBase Logon server Name OnBase Client observer Version 3 5 3 Tour use of the OnBase Software indicates your agreement to the terms and conditions of the OnB ase User Name End User License Agreement Click here to view the license This Product Licensed Unregistered Password Copyright 1992 2001 Hyland Software Inc Depending on modules licensed this program may contain portions of Imaging technology Snowbound Software Inc technology eros Inc OK Cancel hail interface technology Intuitive Data Solutions technology Smart Storage Inc CE A technology Frassi Europe SARL Build 3 5 3 24 User Name Your NT Logon ID Usually the first letter in your first name and the first 7 letters of your last name Password Type in your assigned password If you are not sure of what it is contact Rick Snell at 5445 or Matthew McConnell at x3723 223 USER MANUAL SPARKS January 28 2003 B IMPORT INSPECTION REPORTS In order for the inspection reports to be viewed they must first be imported into the application This section provides the steps to perform this oper
71. TORY FORM The Construction History Form contains information related to each of the construction projects at a Site The Construction History Form is only accessible from the Buildings tab Construction Renovation History Quakertown Maintanence Shed test Last Record Update 10 28 2002 Construction Type Major Renovation Begin Date 3 1 71333 End Date Description Browse All Records Fields Available Construction Type The type of construction done The valid values are accessible from the drop down list Begin Date The date the construction project began The format for the date is MM DD YYYY End Date The date the construction project was completed The format for the date is MM DD YYYY Description A text field that describes the work that was done as part of the construction project 192 USER MANUAL SPARKS January 28 2003 Buttons Available EXTT Button Will Close the Construction History Form and return control to the main form L EDIT Button Will make data that can be changed a light blue color The ED T button will become the CANCEL Button and the VEW Button will become the SAVE Button NEW Button Will clear all fields for you add a new record The D 7 button will become the CANCEL Button and the WEW Button will become the SAVE Button CANCEL Button Appears when the D 7 Button is clicked When this button is clicked any field chan
72. TURN 2 pire SPARKS Data Browse Mode USER MANUAL SPARKS January 28 2003 SITE ID SITE NAME 2020108 T jA0313T 8 Lansdale Interchana mz Quakertown Maintar ama7TR Quakertown Inerche Jae South Mountain Tow jamssP Allentown Service St L A0573TT H Lehigh Valley Interc Lang Slsingion Mainlaner 070 07 Slalington Maintenar Lehigh Tunnel No 1 AW i0t ASN Lehigh Tunnel No 2 Big Boulder Tower Pocono Interchange n ANIA B4F Pnennn The data grid now shows only the Site ID This field will always show because it is the key and the Site Name the field we chose from the customize browse form CUSTOMIZE ALL Button Shows all fields from the database table if they are not all showing SELECTION Button Opens the Query form For more details the how to run query please refer to Chapter 4 Section C S4 SELECT ALL Button If you have limited the records you are viewing using the Selection button this button will allow you to view all records again SORT Button Opens the Sort Form For more details on how to sort records please refer to Chapter 4 Section D 143 USER MANUAL SPARKS January 28 2003 SITE SITE AOUTE MILEPOST COUNTY MUNICIPALITY START MILEP 201 0 301 Lansdale Interchange 3013 Montgomery 3013 7 04
73. Temperature qua M weaker MES GEM __ Soap dispensers 1 2 fullwithsame soap 115 Clean inside amp out no odor Clean igoodrepair SSCS _ iieri 8 3 dispensers uniforminstyle BEA af _ Dispensers foreachsink _ Hinges clean 5 1 Mirrors Clean good Fed ve zaps in partitions cin AN clean around and behind edges MEE 41 gt Shee INSPnESH1 14 Ln Ir TestDocs O EET image will display 229
74. able OUperatorLontact OPERATOR CONTACT Button Opens the Contact Information form For more details on the Contact Information form please refer to Chapter 6 Section A Insurance Information INSURANCE INFORMATION Button Opens the Insurance Information form For more details on the Insurance Information form please refer to Chapter 6 Section B Property Information PROPERTY INFORMATION Button Opens the Property Information form For more details on the Property Information form please refer to Chapter 6 Section C Validate Site Record VALIDATE SITE RECORD Button Will change the validation label based upon the user logged on and the current system date Record Validation 06 06 2002 BRODGERS If the Site Type Toll Plaza or Interchange Tall Plaza Collection Info TOLL PLAZA COLLECTION INFO Button Opens the Toll Plaza Collection Information form For more details on the Toll Plaza Collection Information form please refer to Chapter 6 Section D 123 USER MANUAL SPARKS January 28 2003 F BUILDINGS INFORMATION site Detail Buildings Fuel Infa Concepts InspServices Leases Parking Last Record Update 10 26 2002 Buildings tructure Information Building Structure Type Building structure Mame testing Main Service Plaza Building Location Roof Details Comment hhkihki Fire Detection Equipment System Fire Suppression Oa Sustem Rest Rooms Gross Square
75. ailable J3 EXIT Button Will Close the Rest Rooms Form and return control to the main form L EDIT Button Will make any data that can be changed light blue color The EDIT button will become the CANCEL Button and the WEW Button will become the SAVE Button 190 USER MANUAL SPARKS January 28 2003 NEW Button Will clear all fields for you add a new record The button will become the CANCEL Button and the VEW Button will become the SAVE Button CANCEL Button Appears when the D 7 Button is clicked When this button is clicked any field changes will be lost and any original field values will be restored SAVE Button Becomes enabled when the D 7 button is clicked When this button is clicked all changes will be saved to the database DELETE Button When this button is clicked you will be prompted to see if you actually want to delete the current record Delete Confirmation 2 ARE YOU SURE YOU WANT TO DELETE THE CURRENT REST ROOM RECORD If the YES Button is clicked the record will be removed from the database If the Button is clicked nothing will happen lt 9 RECORD NAVIGATION Buttons Allow you to scroll through the each of the roofs for the buildings at the Site These navigation buttons function in the same manner as the main navigation buttons 19 4 TURN USER MANUAL SPARKS January 28 2003 H CONSTRUCTION HIS
76. an Record Validation 08 06 2002 BRODGERS Validate Site Record 16 USER MANUAL SPARKS January 28 2003 Figure A 4 ADD SITE PHOTOS Select Sparks Photos Lansdale Interchange L Loncept Vishay Selected anoto e For more details on the PHOTOS FORM please refer to Chapter 5 Section G 17 Site Detail PENNA Figure A 5 ADD SITE LONGITUDE LATITUDE Opening Date 3 2 1335 Site Status test Desc Comment Legislator Legislative District Hours of Operation Open 24 Hours Open POOAM Closed Number of Mon Hevenue Cards Issued Longitude 124 5555555555 Latitude wv Turn round Back Gate Access Access Road Mame Access Road Description Record Validation 10 26 2002 RO TBEV3 Validate Site Record 18 Building Fuel Into Concepts Insp servicez USER MANUAL SPARKS January 28 2003 Step 4 Upon receiving the email from the Engineering Design Department Roadway Section the Engineering Design Department Right of Way Section will add the site latitude longitude and property information Leases Utilities Parking Last Record Update 11 26 2002 Mailing Address Address 1 Address 2 City State ip Service Plaza Usage Other Operator Contact Insurance Information Property Information USER MANUAL SPARKS January 28 2003 Site Detail Building Fuel Info Concept
77. and Milepost lt 67 22 then Fare Collection District 1 If Route T and Milepost gt 75 39 and Milepost lt 201 29 then Fare Collection District 2 If Route T and Milepost gt 226 54 and Milepost lt 311 93 then Fare Collection District 3 If Route T and Milepost gt 326 62 and Milepost lt 358 11 then Fare Collection District 4 If Route A then Fare Collection District 5 If Route B G M then Fare Collection District 1 Maint District A unique numerical representation for the Maintenance District that the site resides in The value of this field is dependent upon the route and milepost values The following guide should be used to enter this value O If Route T and Milepost gt 0 00 and Milepost lt 100 00 then Maintenance District 1 If Route T and Milepost gt 100 01 and Milepost lt 200 00 then Maintenance District 2 If Route T and Milepost gt 200 01 and Milepost lt 300 00 then Maintenance District 3 If Route T and Milepost gt 300 01 and Milepost lt 359 10 then Maintenance District 4 If Route A and Milepost gt 20 00 and Milepost lt 32 84 then Maintenance District 4 If Route A and Milepost gt 32 85 then Maintenance District 5 If Route B G or M then Maintenance District 1 119 USER MANUAL SPARKS January 28 2003 Site Type A unique identifier for the type of site The valid values are available in a drop down list Located
78. are logging onto the Citrix Server the following dialogue will appear 96 USER MANUAL SPARKS January 28 2003 Pa Citrix Test x Program Neighborhood 1990 2002 cir Systems Tne All rights reserved Windows Usemame mmcconne Password seen central Save Password In the Username textbox you should type your NT logon id This is usually your first initials and your first 7 letters of your last name or your entire last name if it is less than 7 characters In the Password textbox you should type your NT password The same one you use to logon your machine In the Domain textbox you should type CENTRAL Case is not important It is recommended that you check the Save Password check box otherwise you will have to do this each time you logon 97 USER MANUAL SPARKS January 28 2003 8 xl Fille View Tools Help X Refresh Delete Properties Settings Views Visual Basic 6 Sedi 7 Astar e Sin Cyc far a M e pw Cup us gavi 8 ss ATTE CATE Note The list seen in this image may not be the same list you have SPARKS Used to launch the application 98 USER MANUAL SPARKS January 28 2003 If this is the first time that you are logging onto the SPARKS application you may be prompted with the same logon as below PA Citrix Test x Program N
79. ation File Mew Open Import Close Close All Save As Print Ctrl F Render Statement Print Setup Send k Exit Once the ONBASE Application has opened choose the Import Option of the File menu Import Document Full Path to File Delete File After Import Document Type File Type Document Date 1140 o 2002 Keywords The import form will open up 224 USER MANUAL SPARKS January 28 2003 Full Path to File Hit the BROWSE Button to find the location of the report you want to import The open dialogue will open up allowing you to find the report Open Look in EJ SPARKS L 4020_10 2 Restaurant Blank Form dif SPARKSOLD 110 12 Restaurant10_28 Te SunRecap _ Documentation 38 Restroom Blank Form 58 T55 2010022002 Rest 2 5 S amp Restroom1 28 T55 o010022002 Rest 1 Concepts 3 service Station Blank Form 6 55 9010022002 5 Facility 88 ServiceStation10 28 Facility 2 5 Data Dump 2 McDonaldsRecap Sparks Fa Pavement History 2000 SPARE SDE dro em Computer Open Hee Open as read only Help File name Files of type All Files Cancel 2 Find the file and hit the OPEN Button The open dialogue will close and the path should now be in the FULL PATH TO FILE text box Full Path ta File E PARKS Restroom 28 xls
80. can be between 0 00 and 359 00 If Route A then Milepost can be between 20 0 and 130 64 If Route B then Milepost can be between 28 47 and 44 87 If Route G then Milepost can be between 0 3 and 13 41 If Route M then Milepost can be between 1 6 and 7 84 e Or Milepost can be between 30 00 and 35 62 Inspection Date The date the inspection was completed The format for the date is MM DD YYYY Import IMPORT Button Will import the document into the ONBASE application document type you choose Clear CLEAR Button Will clear all the fields and allow you to start over again Exil EXIT Button Will Close the import form 22 a s CHECKING TO SEE IF THE IMPORT WAS SUCCESSFUL USER MANUAL SPARKS January 28 2003 The ONBASE application does not show a message to the users when the import was successful Therefore it is necessary for you to do a retrieval of the document i EZ OnBase Client Fie Document User Processing Admin Window Help SS Document Retrieval Document Type Groups Document Types Baker Documents CATALOG Meeting Documents Engineering Documents Excel Restaurant Inspections HR Documents Excel Service Plaza Inspections IT Documents HR Job Descriptions 2002 a E Route And October 2002 September 2002 August 2002 Milepost And July 2002 op ree Inspection Date From VIE x E Io
81. d Select All SPARES Records Will display all records from the main Sparks table Select Records Only From New service plaza Will display only records for the New Service Plazas Customize Record Selection Will open the Query form For more details on the Querying records please refer to Chapter 4 Section C Buttons Available EXTT Button Will close the reports selection form and return control to the main form 219 USER MANUAL SPARKS January 28 2003 Process selected Report PROCESS SELECTED REPORT Button The function of this button varies based upon the report chosen e This button will launch the crystal report if one of the following is chosen o Facility List Vendor Concept List Contact List Service Plaza Services Report e This button will launch the Select a period form if one of the following is chosen o Restaurant Sales and Rental Detail Report Restaurant Sales Revenue Summary Service Station Sales and Rental Detail Report Service Station Sales Revenue Summary Report e This button will launch the Select a year form if the following is chosen o Annual Inspection Report e This button will launch the Inspection Reports form if of the following is chosen o Service Station Inspection Report Restaurant Inspection Report Rest Rooms Inspection Report 220 USER MANUAL SPARKS January 28 2003 B ADDITIONAL FORMS Select a Period Select a Report Period Period
82. d values are accessible from the drop down list Status The status of the waster system Casing Size The size of the casing that is used in the water system Casing Depth The depth of the casing that is used in the water system Well Depth The depth of the well used by the water system 211 USER MANUAL SPARKS January 28 2003 Static Water Level The static water level used by the water system Yield The yield of the water system Install Date The date the water system was installed The format of the date is MM DD YYYY Pump Data Information about the pump used by the water system Pump Setting The setting for the pump used by the water system Driller Information about the driller used by the water system Storage Quantity The amount of storage quantity available for the water system Storage Type The type of storage used by the water system Storage Volume The volume of storage available for the water system Water Pressure The level of water pressure for the water system Treatment A description of the treatment done on the water in the water system Water Authority The local water authority that is involved with the water system Location Description A comments field that can be used to describe the location of the water system or a description of the water system Buttons Available EXIT Button Will Close the Water System Details Form and return control to the main form ED
83. date 10 22 2002 Vendor Site Operator Concept Site Number Location at Site tthis atest Description Concept Type Restaurant Concept Square Footage 1545 00 Hours of Operation Open 24 Hours Open 7715 AM Closed 16 48 lt Sales Information Insurance Information Rental Hate Information Contact Information 61 USER MANUAL SPARKS January 28 2003 Figure D 2 ADD VENDOR CONCEPT CONTACT INFORMATION Contact Information 62 USER MANUAL SPARKS January 28 2003 If there are Vendor Concept Photos then continue with Step 3 Step 3 The Concessions Management department should add the Vendor Concept Photos PTC Site Planning Asset and Resource Knowledge System User MMCCONNE File Administrative Tasks General Site Information and Milepost SiteName County Municipality Showing record 3 of 228 30 13 Lansdale Interchange Montgomery Towamencin Begin End Direction Station Fare Collection Dist Maint District Site Type Exit Old Exit Num 30 13 30 13 555 00 4 Toll Plaza 31 Site Detail Buildings Fuel Info Concepts Insp Services Leases Litilitiez Parking Opening Date 12 1 2 2002 Site Status HISTORICAL Last Record Update 10 8 2002 this 1 the landsdale interchange 2 naling aee Desc Comment E Legislator legislator 12 Address 2
84. dress Desc Comment Address 1 Legislator Address 2 TU E Entry City Legislative District See Direction State m Hours of Operation Open24Hours Open Closed Park and Ride Available Number of Nan Hevenue Cards Issued Toll Plaza Collection Info Longitude Latitude Tum Around Back Gate Access Operator Contact Access Road Insurance Information Access Road Description n eese uice ne 3 Property Infarmatian Record Validation 01 27 2003 STONTOS Validate Site Record start 8 User 44 amp gc y 7 51 This will put the application into Add Mode The Engineering Design Department Roadway Section should enter values into the General Site Information section Figure A 1 ADD GENERAL SITE INFORMATION General Site Information Route and Milepost Site Name Municipality Showing record 1 of 228 Begin End Direction Station Fare Collection Dist Maint District Site Type Located Between XXXEEXXXXM XXXMEEXXXXM XXXEEXXXXI XXXMZEXXXXXEMEXXXI XXXEXXXI xx XXXMZEXXXXM 1 1 EXXMXXENNM 3 PEPEE EEEE EEEE EEEE laa and Values must be entered for the following fields Route Milepost Site Name Begin M P End M P
85. e Access Opersto Cortact Access Road Name Insurance Infomation Access Road Descaptian Property mlonmatian Hecond Validation 10 28 2002 Validate Site Record The names on the tab headings explain the data that is represented on that particular tab For more details on the contents fields valid values etc of each tab refer to the Sections of Chapter 3 as shown here Section E Site Detail Information Section F Buildings Information Section G Fuel Information Section H Concepts Information Section I Inspection and Services Information Section J Leases Information Section K Utilities Information Section L Parking Information 106 USER MANUAL SPARKS January 28 2003 B MENU OPTIONS File Menu The File Menu can be accessed by single clicking the menu option or by using the shortcut key ALT F I EXIT OPTION There is one sub menu option in the File Menu The option is Exit This will cause the application to close The Exit option can be accessed by single clicking the menu option or by using the shortcut key ALT X PTC Site Planning Asset and Resource Knowledge System User ROTDEV3 File Admir istrative Tasks General Site Information Route and Milepost SiteName County Municipality Showing record 1 af 227 20 10 New service plaza Montgomery Plymouth Begin Direction Station Fare Collection Dist Maint
86. e Status HISTORICAL Last Record Update 10 8 2002 this 1 the landsdale interchange Mailing Address Desc Comment Address 1 Legislator legislator 12 Address 2 ore TE Entry City Legislative District legislative district bei Direction State E EE Hours of Operation Ha Open 24 Open Closed Exit Park and Ride Available Direction Number of Non Revenue Cards Issued 5 Tall Plaza Collection Info Longitude Latitude Turndround Back Gate Access Operator Contact Access Road Mame Insurance Information Access Road Description Property Infarmatian Record Validation 08 06 2002 BRODGERS Validate Site Record 40 USER MANUAL SPARKS January 28 2003 Depay selected enoto For more details on the PHOTOS FORM please refer to 5 Section G 41 USER MANUAL SPARKS January 28 2003 Step 7 The Engineering Facilities Department should add the Construction History for each of the buildings The Construction History Form is accessed from the Buildings Tab site Detail Buildings Fuel Info Concepts Insp services Leases Lhilities Parking Last Record Update 10 28 2002 Building tructure Information Building Structure Building Structure Mame testing Main Service Plaza Building Location Roof Details Comment hhkihki Fire Detection Equipment System d Rd Rest Room 99 00 Capacity Foota
87. eighborhood 1990 2002 ir Systems Ine All rights reserved Windows Usemame mmcconne Password eem Domain central Save Password Fill out the form in the same manner as you did above 99 USER MANUAL SPARKS January 28 2003 Splash Screen If you are part of the Security table the following splash screen will appear PTC Site Planning Asset and Resource Knowledge System File Administrative Tasks SPARKS fe page eel fhe emacs dete The application will then load the main form For more information on the main SPARKS form see Chapter 3 of this document 100 USER MANUAL SPARKS January 28 2003 No Authorization If you are not in the Security table the following screen will appear Application Authorization Failure SPARKS We are sorry but you are authorized to use this application If you feel that you should have access please contact The Help Desk at Ext 56 8 Follow the instructions in the message if you feel that you should have access to the application 101 USER MANUAL SPARKS January 28 2003 CHAPTER FOUR APPLICATION FORMAT A APPLICATION LAYOUT The Image below is what the application looks like when it is first started PTC Site Planning Asset and Resource Knowledge System User ROTDEV3 File Administrative Tasks General Site Information Route and Milepost 8 Site Name County Municipal
88. endor provides Concept Type The Type of Concept that the vendor is The valid values are available in the drop down list Concept Square Footage The total square footage that the concept resides on The value must be numeric Hours of Operation There are two options with this field You can choose the Check box marked Opened 24 Hours or you can enter the Open and Closed times into the appropriate fields After you enter a value it will be formatted in the following format HH MM AM PM 128 USER MANUAL SPARKS January 28 2003 Buttons Available Sales Information SALES INFORMATION Button Opens the Sales Information form For more details on the Sales Information form please refer to Chapter 6 Section I Rental Hate Information RENTAL RATE INFORMATION Button Opens the Rental Rate Information form For more details on the Rental Rate Information form please refer to Chapter 6 Section J Insurance Information INSURANCE INFORMATION Button Opens the Insurance Information form For more details on the Insurance Information form please refer to Chapter 6 Section B Contact Information CONTACT INFORMATION Button Opens the Contact Information form For more details on the Contact Information form please refer to Chapter 6 Section A ees RECORD NAVIGATION Buttons Allows you to scroll through the concepts for the Site These navigation buttons function in the same manner as the main navigation buttons 129
89. er that data should be entered into the system where the data should be entered who should enter it and the contact that is necessary between the various departments A ADDING A SITE Site Definition A site is a location along the Turnpike roadway on which structures are built for the purpose of providing a service to the customers traveling on our roads Examples of Sites are Toll Plazas Service Plazas and Roadway Sites like Maintenance Sheds PENNA TURN i Pine USER MANUAL SPARKS January 28 2003 Adding a Site Organizational Process 1 Application Process 5 Decision Process SITE TYPE INTERCHANGE OR TOLL PLAZA SITE TYPE ALL SITE TYPES STEP 2B ENGINEERING DESIGN ROADWAY SECTION EMAILS CONCESSIONS MANAGEMENT RIGHT OF WAY SECTION FACILITIES AND RISK SEE FIGURE USER MANUAL SPARKS January 28 2003 a USER MANUAL SPARKS January 28 2003 Step 1 Engineering Design Department Roadway Section will add the Site into the application PTC Site Planning Asset and Resource Knowledge System User MMCCONNE File Administrative Tasks General Site Information Route and Milepost Name County Municipality Showing record 1 of 228 o 20 10 New service plaza Montgomery Plymouth Begin Direction Station Fare Collection Dist Maint District Site Type Located Between 20 10 20 90
90. ge Construction History Building Structure Closed Construction Material l gt zi Record Validation 10 28 2002 RO TDE S3 Validate Structure Record Figure B 7 ADD CONSTRUCTION HISTORY INFORMATION Lonstruction Renovation History New service plaza testing Last Record Update Construction Type Begin Date End Date Description Browse All Records Bt elella For more details on the CONSTRUCTION HISTORY FORM please refer to Chapter 6 Section H 42 USER MANUAL SPARKS January 28 2003 If there are Restrooms in the building then continue with Step 8 Step 8 The Engineering Facilities Department should add the Restroom information The Restroom information form is accessible from the Buildings Tab site Detail Buildings Fuel Info Concepts Inspiservicez Leases Parking Last Record Update 10 28 2002 Building Structure nformation Building Structure Building Structure testing Main Service Plaza Building Location Roof Details Comment hhkihki Fire Detection Equipment System Fire Suppression 7 Rest Rooms Gross Square Footage 2 Construction History Building structure PST Closed Construction Material lt l Record Validation 10 28 2002 ROTDEYS Validate Record 43 PENNA el Figure B 8 ADD RESTROOM RECORDS USER MANUAL SPARKS Januar
91. ges will be lost and any original field values will be restored SAVE Button Becomes enabled when the D 7 button is clicked When this button is clicked all changes will be saved to the database 193 USER MANUAL SPARKS January 28 2003 a DELETE Button When this button is clicked you will be prompted to see if you actually want to delete the current record Delete Record Confirmation 2 ARE YOU SURE YOU WANT TO DELETE THE CURRENT CONSTRUCTION HISTORY RECORD If the YES Button is clicked the record will be removed from the database If the Button is clicked nothing will happen lt gt gt RECORD NAVIGATION Buttons Allow you to scroll through the each of the roofs for the buildings at the Site These navigation buttons function in the same manner as the main navigation buttons Browse All Records BROWSE ALL RECORDS Button Will open the browse form showing the construction history records For more details about the browse form please refer to Chapter 4 Section 194 USER MANUAL SPARKS January 28 2003 SALES INFORMATION FORM The Sales Information form contains Sales information for each of the vendors at the site The Sales Information form is only accessible from the Concepts tab Restaurant Sales Data New service plaza testing Vi Vendor seer Period RentRec Sales RentDue d3 _
92. he D 7 button is clicked When this button is clicked all changes will be saved to the database DELETE Button When this button is clicked you will be prompted to see if you actually want to delete the current record Contact Delete Confirmation ARE YOU SURE YOU WANT TO DELETE THE CURRENT CONTACT RECORD If the YES Button is clicked the record will be removed from the database If the Button is clicked nothing will happen 169 USER MANUAL SPARKS January 28 2003 B INSURANCE INFORMATION FORM The Insurance information form contains important insurance information for the Site and its related data The form can be accessed from the Site Detail Tab Fuel Info Tab and the Concepts tab Insurance Information Fuel Info New service plaza Last Record Update Insurance Company Mame Policy Number Insurance Type Policy Effective Date Policy Expiration Date Insurance Contact Into 3 Als amp Fields Available Insurance Company Name The full name of the Insurance Company Policy Number The number related to the policy held by the Turnpike Commission Insurance Type drop down list of the types of Insurance All valid values are contained in the drop down list Policy Effective Date The date the Policy took effect The format of the date is MM DD YYYY Policy Expiration Date The date the Policy will expire The format of the date is MM DD YYYY 170 USER MANUAL
93. ict State ip Hours of Operation Open 24 Hours Open 2 00 Closed Service Plaza Usage Type Number af Mon Hevenue Cards Issued 12 Uther Longitude 124 5555555555 Latitude Turn Araund Back Gate Access Operator Contact Access Road Mame Insurance Information Access Road Description Property Information Record Validation 10 28 2002 RO TDE V3 Validate Site Record 20 USER MANUAL SPARKS January 28 2003 STEP 6 The Concessions Management Department will add Site Contact information into the application The Site Contact Information is accessed from the Site Detail Tab site Detail Buildings Fuel Infa Concepts Leases Utilities Parking Opening Date 3 2 1335 Gite Status Open Last Record Update 11 26 2002 test E Mailing Address Desc Comment E Tr Legislator Address 2 Legislative District city egislative Distric State Hours of Operation Open 24 Open Service Plaza Usage Type Number of Non Revenue Cards Issued 12 Other Longitude E 24 55 8585855855 Latitude Turn Araund Back Gate Access Access Haad Mame Insurance Information Access Road Description Property Information Record Validation 10 28 2002 ROTDEYS Validate Site Record 21 USER MANUAL SPARKS January 28 2003 Figure A 8 ADD SITE CONTACT INFORMATION Contact Information
94. ies Department will add the Buildings information into the application The Buildings Information is accessed from the Buildings Tab Figure B 1 ADD BUILDINGS INFORMATION m site Detail Buildings Fuel Info Concepts Inspiservices Leases Parking Last Record Update 10 28 2002 Building Structure Information Building Structure Building Structure Mame testing Main Service Plaza Building Location Roof Details Comment hhkihki Fire Detection Equipment System Fire Suppression Rest Rooms Gross Square Capacity Footage 5 Construction History Building S tructure SSH Closed Construction Material Record Validation 10 26 2002 ROTDEVS 5 gt gt Validate 219 Structure Record For more details on the Buildings information and the Buildings Tab please refer to Chapter 4 Section F 31 USER MANUAL SPARKS January 28 2003 If there are Buildings or Structure Photos then continue with Step 2 Step 2 The Engineering Facilities department should add the Buildings or Structure photos PTC Site Planning Asset and Resource Knowledge System User MMCCONME File Administrative Tasks General Site Information and Milepost SiteName County Municipality Showing record 3 af 228 30 13 Lansdale Interchange Montgomery Towamencin Begin End Direction Station Fare Collection Dist Maint
95. igure D 4 ADDING VENDOR CONCEPT INSURANCE INFORMATION 66 Figure D 5 ADDING VENDOR CONCEPT INSURANCE CONTACT INFO 68 Figure D 6 ADDING RENTAL RATE INFORMATION eene 70 Figure D 7 ADD FUEL SALES INFORMATION 72 Figure D 8 ADDING NON FUEL 74 E INSPECTIONS AND ADDING SERVICES eren nnne 76 Liu EITPROCESS INSPECTION E 78 Figure E 4 ADDING 81 FE 83 Figure F 84 G ADDING eee enne nnn n nnn nnne rnt ern rere retenues 86 Figure G 1 ADDING MAIN 2000000 88 Figure G 2 ADDING WATER SYSTEM 5 2 2 2 90 Figure G 3 ADDING WASTE WATER SYSTEM 8 92 Figure G 4 ADDING UTILITY 94 CHAPTER THREE APPLICATION 585 22222 2 2 96 ACCESSING THE APPLICATION 96 100 No 12 ener nemen emeret renes 101 CHAPTER FOUR APPLICATION FORMAT 102 A APPLICATION MIF S40 DL 102 Men OPOS oasis teint 103
96. is clicked When this button is clicked all changes will be saved to the database 209 PENNA I DELETE Button When this button is clicked you will be prompted to see if you actually want to delete the current record USER MANUAL SPARKS January 28 2003 Delete Confirmation ARE YOU SURE YOU WANT TO DELETE THE CURRENT RECORD If the YES Button is clicked the record will be removed from the database If the Button is clicked nothing will happen 210 4 TURN USER MANUAL SPARKS January 28 2003 M WATER SYSTEM DETAILS FORM The Water System Details Form contains information about the water system at the site The form will appear when the SYSTEM DETAILS Button is clicked on the Utilities tab if the Utility Type is Water System The Water System form is only accessible from the Utilities tab m Water System Details New service plaza water company Milepost Last Record Update Water System Type Status Casing Size Po Casing Depth fo Well Depth Static Water Level Yield anstall Date Pump Data Pump Setting Driller Storage Quantity Storage Type Storage Volume Water Pressure Treatment Water Authority Location Description Fields Available Milepost A numeric value for the Turnpike mile marker at which the waste water system resides Water System Type The type of water system The vali
97. ity Showing record 1 af 222 20 10 service plaza Montgomery Plymouth Begin Direction Station Fare Collection Dist Maint District Site Located Between 20 10 20 90 123 45 2 4 Service Plaza and 51 Site Detail Buildings Fuel Into Concepts Inspiservices Leases Utilities Parking Opening Date 3 2 1935 Gite Status HISTORICAL Last Record Update 10 26 2002 test Mailing Address Desc Comment ETE D Legislator Address 2 Legislative District City egislative Distric Sae Hours of Operation Open 24 Hours Open TAM Closed 8 00 PM Service Plaza Usage Type Number of Non Revenue Cards Issued 12 Uther Longitude 24 55555555565 Latitude Turredround Back Gate Access OperatorContact Access Road Mame Insurance Information Access Road Description Property Information Record Validation 10 28 2002 ROTDEVS Validate Site Record 102 USER MANUAL SPARKS January 28 2003 Menu Options Site Planning Asset and Resource Knowledge System User ROTDEV3 File Administrative Tasks 78 Sie Route and Milepost 6 Name County Municipality Showing record 1 of 222 fe 2010 New sevice plaza Plymexth Begin EndM P Direction Staton Fare Collection Dist Maint District Site Tupe Located Between 2010 20 90
98. ity levels of the Pressure Vessel Vessel Type The type of Pressure Vessel All valid values are available from the drop down list Buttons Available 99 EXTT Button Will Close the Equipment Form and return control to the main form 2 EDIT Button Will make data that can be changed a light blue color The ED T button will become the CANCEL Button and the SAVE Button will be enabled NEW Button Will clear all fields for you add new record The D 7 button will become the CANCEL Button and the WEW Button will become the SAVE Button 186 USER MANUAL SPARKS January 28 2003 Add Warranty Record ADD WARRANTY RECORD Button Will show the warranty fields on the Warranty tab Add Generator Detail Record ADD GENERATOR DETAIL RECORD Button Will show the generator details fields the Emerg Generator Details tab This Button will only appear if the Equipment type is Generator Add HVAC Detail Record ADD HVAC DETAIL RECORD Button Will show the HVAC details fields the HVAC Details tab This Button will only appear if the Equipment type is HVAC Add vessel Detail Record ADD VESSEL DETAIL RECORD Button Will show the Vessel details fields on the Pressure Vessel Details tab This Button will only appear if the Equipment type is Pressure Vessel CANCEL Button Appears when the 277 Button is clicked When this button is clicked any field changes will
99. lease Date Entered A date field that represents when the lease was entered into The date should be formatted as follows MM DD YYYY Start Date A date field that represents when the lease started The date should be formatted as follows MM DD YYYY Expiration Date A date field that represents when the lease will expire The date should be formatted as follows MM DD YYYY Extension Date A date field that represents when the lease can be extended The date should be formatted as follows M DD YYYY USER MANUAL SPARKS January 28 2003 Buttons Available ez lt RECORD NAVIGATION Buttons Allows you to scroll through the leases for the Site These navigation buttons function the same manner as the main navigation buttons 132 USER MANUAL SPARKS January 28 2003 K UTILITIES INFORMATION site Detail Building Fuel Info Concepts Inspi services Leases Utilities Parking Last Record 10 11 2002 Utility Information Utility Utility Provider watercompany 000000 water System Account Humber Meter Location Materials Used Size Responsible Party System Details Contact Information Ke Fields Available Utility Provider A text field representing the name of the utility provider Utility Type The type of utility The valid values are available in the drop down list Account Number A text field representing the account number for the lease Meter
100. lose returning control to the main form displaying only the records that match the Selection Filter from above Mew Filter NEW FILTER Button Will clear the Current Selection Filter text box and allow you to build a new query Cancel CANCEL Button Will clear the Current Selection Filter text box close the query builder form and return control to the main form 148 USER MANUAL SPARKS January 28 2003 COMPLEX QUERY STATEMENT Current Selection Filter ROUTE and MILEPOST gt 0 65 and MILEPOST lt 3 95 The statement above shows the use of the A D operator button 149 USER MANUAL SPARKS January 28 2003 D SORTING RECORDS When the SORT Button is chosen from anywhere within the application the Sorting form will open Change the sort order for a recordset Available Fields Selected Fields Ascending ROUTE MILEPOST COUNTY MUNICIPALITY START_MILEPOST Remove END MILEPOST DIRECTION Done STATION MAINT_DISTRICT FC_DISTRICT SITE_TYPE_CODE EXIT OLD_EXIT ENTRY_DIRECTION EXIT DIRECTION Descending E Available Fields SITE ROUTE MILEPOST COUNTY MUNICIPALITY START MILEPOST ENO MILEPOST DIRECTION STATION MAINT DISTRICT FL DISTRICT SITE ENTRY_DIRECTION E IT DIRECTION The fields available list box shows the names for each of the fields in the main SPARKS table Choose
101. m Around Back Gate Access Operator Contact Access Road Mame Insurance Information Access Road Description Property Information Record Validation 10 28 2002 ROTDEYS Validate Site Record 26 USER MANUAL SPARKS January 28 2003 Adding a Site Check List Engineering Design Roadway Section e Add General Site Info e If Site Type Interchange or Toll Plaza o Add Toll Collection Info e Email the Concessions Management Right of Way Section Facilities and Risk Management Department e If there are Site Photos o Add Site Photos e Add Parking Lot Info e Validate Site Engineering Design Right of Way Section e Add Site Latitude Longitude e Add Property Info Concessions Management Department e Site Info e Add Site Contact Info Risk Management Department e Add Insurance Information 21 USER MANUAL SPARKS January 28 2003 ADDING A BUILDING See Diagram on the next page 28 USER MANUAL SPARKS January 28 2003 PTC COMPLETES A NEW BUILDING ON A SITE ADD BUILDING Organizational Process mem Application Process lt i fum Decision Process ALL ACTIVITIES PERFORMED THIS FLOW ARE DONE BY THE ENGINEERING FACILITIES DEPARTMENT UNLESS OTHERWISE NOTED 29 i L4 TURN PIRE USER MANUAL SPARKS January 28 2003 YES L 30 USER MANUAL SPARKS January 28 2003 Step 1 The Engineering Facilit
102. m Inspection Query Contact List YendorfConcept List Traffic Counts Demographic Data Service Plaza Services Report Report Record Selection Select All SPARKS Records C Select Records Only From New service plaza Frocess selected Report Customize Record Selection 57 217 USER MANUAL SPARKS January 28 2003 REPORTS LIST select the desired report from the list below Restaurant Sales and Rental Detail Report Restaurant Sales Revenue Summary Report Annual Inspection Report Serice Station Inspection Query Restaurant Inspection Query Rest Room Inspection Query Traffic Counts Demographic Data service Plaza Services Report Above is a list of canned reports that have been built into the application Crystal Reports FACILITY LIST RESTAURANT SALES AND RENTAL DETAIL REPORT RESTAURANT SALES REVENUE SUMMARY SERVICE STATION SALES AND RENTAL DETAIL REPORT SERVICE STATION SALES REVENUE SUMMARY REPORT ANNUAL INSPECTION REPORT CONTACT LIST VENDOR CONCEPT LIST SERVICE PLAZA SERVICES REPORT Excel Exports SITE DATE DUMP EXCEL REPORT 218 USER MANUAL SPARKS January 28 2003 Opens the Query Builder SERVICE STATION INSPECTION QUERY RESTAURANT INSPECTION QUERY REST ROOM INSPECTION QUERY Report Record Selection Select All SPARKS Records Select Records Only From New service plaza Customize Record Selection There are three options for which records get printe
103. mps Emergency Plan Number of Full Service Pumps Minimum Canopy Clearance Ft Fuel Brand Sunoco Canopy Light type Fire Suppression System Inspectian Date Description Contact Information Leak Detection System Insurance Information Spill Control Plan De icing materials used Monitoring well Info 50 USER MANUAL SPARKS January 28 2003 Step 2 The Concessions Management department should add the Fuel Contact information The Fuel Contact Form can be accessed from the Fuel Info Tab site Detail Fuel Info Concepts Inspiservices Leases Parking Building Last Record Update 11 7 2002 Corporate Name asdiasdfasd asdi Convenience Store Location Pay at the Pump Service Mumber of Islands Number of Pumps Emergency Plan Number of Full Service Pumps Minimum Canopy Clearance Ft Fuel Brand Sunoco Canopy Light type NEED Fire Suppression System Inspection D ate Description Contact Information Leak Detection System Spill Control Flan Insurance Information De icing materials used Monitoring Well Info 51 USER MANUAL SPARKS January 28 2003 Figure C 2 ADDING FUEL CONTACT INFORMATION Contact Information For more details on the CONTACT INFORMATION FORM please refer to Chapter 6 Section A 52 USER MANUAL SPARKS January 28 2003 If there a
104. n min d Deed Book Deed Book Page Number HREM EA RAMA MAS 23 23 EXEXEXEXEXEXXXXXXXXXXXEXXXXE EEXXXEEXXEXXEEXXEXEEE EXEXEXEEEEXEXEXEEEEXXXXEXEX oe CANCEL Button Appears when the D 7 Button is clicked When this button is clicked any field changes will be lost and any original field values will be restored SAVE Button Becomes enabled when the D 7 button is clicked When this button is clicked all changes will be saved to the database 174 USER MANUAL SPARKS January 28 2003 D TOLL PLAZA COLLECTION INFORMATION FORM The Toll Plaza Collection Information form contains the toll collection types that are available for a Site The form will only be available if the Site Type is Toll Plaza or Interchange The form is accessible only from the Site Detail Tab Toll Collection Types Lansdale Interchange Available Toll Toll Collection Types Collection Types Available at this Toll Plaza Eallectian RECORD UPDATE je 085 200 1028 2002 0871572002 lt lt Remove Selected Collection 5 i Add Selected Collection Type gt gt From Thiz Toll Plaza Available T oll Collection Types The Available Toll Collection Types list box shows all available types The values in the list box come from the Toll Collection Types lookup table 175 PEMMA 4 TURN
105. nagement department should add the Insurance Contact Information The Insurance Contact form is accessible from the Fuel Insurance form Insurance Information Site New service plaza test Last Record Update 12 20 2002 Insurance Company Erie Insane Policy Humber Equipment Boiler 00000 Insurance Type Liability Insurance 03 Policy Effective Date 1090 2000 Policy Expiration D ate 10 10 2003 Insurance Contact Infa 10000 Deduchble j 56 USER MANUAL SPARKS January 28 2003 Figure C 5 ADD INSURANCE CONTACT INFORMATION Contact Information For more details on the CONTACT INFORMATION FORM please refer to Chapter 6 Section A 57 USER MANUAL SPARKS January 28 2003 Adding Fuel Info Check List Taski Concessions Management Department o Add Fuel Info o Add Fuel Contact Info If there are Fuel Info Photos o Add Fuel Info Photos Task 2 Risk Management Department o Add Fuel Insurance Info o Add Fuel Insurance Contact Info 58 i USER MANUAL SPARKS January 28 2003 D ADDING CONCEPTS INFORMATION ADD CONCEPTS TASK 1 TASK 2 CONCESSIONS MANAGEMENT RECEIVES A SIGNED COPY OF THE VENDOR CONCEPT LEASE TASK 3 CONCESSIONS MANAGEMENT RECEIVES A COPY OF THE SALES FROM THE VENDOR CONCEPT STEP 4 EMAILS THE RISK MANAGEMENT DEPARMENT TO ADD CONCEPT INSURANCE INFORMATION C 7 Organizational Process
106. nufacturer 179 USER MANUAL SPARKS January 28 2003 Under the WARRANT INFORMATION Accessed during and Edit or Add Roof Warranty Warranty Date Warranty Exp Date Warranty Company Warranty Descniption Comments varant ontact Warranty Date The date the warranty began The format for the date is MM DD YYYY Warranty Expiration Date The date the warranty will expire The format for the date is MM DD YYYY A text field containing the name of the Warranty Company Warranty Company Warranty Description Comments A text field containing the description of the warranty or any additional comments that are necessary to describe the Warranty A text field containing the number of years that make up the Warranty Length length of the warranty 180 enc dU e ex 9 e e 55 S B o un O a gt A E c m 5 5 iis 9 7 5 lt c wr oe ae oe ae ae lt gt EG Ss 4 S x S 2 2 5 C 2 EE 2 gt 5 5 Y e S c a X E c 9 gt E 2 Y E Gb CY O D WY 5 5 9 D o CY gt c 9 O 5 7 p v og 5 ate aa ae oa 0 Kan Q D 5 C e m 4 p D a C 5 B
107. o the Network Directory where the inspections are kept and hit the OPEN Button The following verification message should appear 202 USER MANUAL SPARKS January 28 2003 Site Name Verification Current Site is Allentown Service Station Excel File Site Mame NEW SERVICE PLAZA Do you wish ka continue If the YES Button is clicked the report will be imported into the database If the Button is clicked nothing will happen If the import was successful then you will get the following message SPARKS Application Message RestRooms Inspection Report Successfully Imported 203 PENNA 4 TURN USER MANUAL SPARKS January 28 2003 K SERVICES FORM The Services form contains the service types that are available for a Site The form is accessible only from the Insp Services tab Services available at Allentown Service Station Available Service Types Travel Info Picnic Areas Pet Areas Welcome Center Touch and Go Dial a T ruck Add Selected Service gt gt Available Service Types Travel Infa Picnic Areas Pet Areas Welcome Center Touch and Ga Dial a Truck Service Types Available at this Site Service Tye UPDATE 0920000 0 Penchra 09207002 O Pemes 057202 10 16 2002 Touch and Ga 10 08 2002 lt lt Remove Selected Semice Tupe Prom this Site
108. obert Long Facilities Department Don Santostefano Risk Management Betty Little 15 a USER MANUAL SPARKS January 28 2003 Step 3 If pictures of the new site have been taken then the Engineering Design Department Roadway Section should add Site Photos PTC Site Planning Asset and Resource Knowledge System User MMCCONME File Administrative Tasks General Site Information Route and Milepost SiteName County Municipality Showing record 3 of 228 30 13 Lansdale Interchange Montgomery Towamencin Begin End Direction Station Fare Collection Dist Maint District Site Type Exit Old Num 30 13 30 13 555 00 4 Toll Plaza 31 Site Detail Buildings Fuel Info Concepts Insp Services Leases Utilities Parking Opening Date 12 12 2002 Site Status HISTORICAL Last Record Update 10 8 2008 the landsdale interchange Mailing Address Desc Comment ies Address 1 Legislator legislator 12 Address 2 Lit Legislative District legislative district y State zp Hours of Operation 24 Open Closed Exit Park and Ride Available Direction Number of Mon Hevenue Cards Issued 5 Tall Plaza Collection Info Longitude Latitude 9 Back Gate Access Operator Contact Access Road Name m Insurance Information Access Road Description Property Infarmati
109. on Penn Fones JEST 08011 Big Boulder Tower 1 Cabon 901 Ir 5ST F Pocono Interchange 94 59 Carbon Kidder 94 59 CLOSE Button Will close the browse form and return you to the main form CUSTOMIZE BROWSE Button Will open the customize Data Grid form 141 USER MANUAL SPARKS January 28 2003 Customize Data Grid Fields amp vailable Fields Selected tr MILEPOST COUNTY MUNICIPALITY START MILEPOST END MILEPOST Done DIRECTION STATION MAINT DISTRICT FC DISTRICT SITE TYPE CODE EXIT Fields Available Fields Selected SITE NAME ROUTE MILEPOST COUNTY MUNICIPALITY START MILEPOST END MILEPOST DIRECTION STATION MAINT DISTRICT FC DISTRICT SITE CODE EXIT Fields Available A list of all the fields from the main SPARKS table Fields Selected A list of all the fields selected from the fields available list box Choose any of the values from the Fields available list box and use the buttons below Done EN Choose the button to move the value from the list box on the left side to the list box on the right side In this example the Site Name was moved to the right list box Choose the button to move the value highlighted on the right side out of the list box Choose the Done button when you have completed making your selection The screen shot below shows the result of the example above Site Name 142 4
110. on Type RECORD UPDATE lt lt Remove Selected Collection 3 H Add Selected Collection gt gt Fram This Tall Plaza For more details on the Toll Collection Types Form please refer to Chapter 6 Section D 14 gt TURN USER MANUAL SPARKS January 28 2003 Step 2b The Engineering Design Department Roadway Section should contact the Concessions Management department Right of Way Section Facilities and Risk Management department via electronic mail to let them know that a new Site has been added to the application The email should be formatted as seen below Figure A 3 EMAIL DEPARTMENTS ABOUT THE ADDITION OF NEW SITE m Site Added to the SPARKS Application Message Rich Text P x Eile Edit View Insert Format Tools Actions Help asu t 0 086 1 4 0 A 7 Bortz Natalie Liberatore Anthony Lang Robert SantasteFano Donald Little Elizabeth eu Subject site Added to the SPARKS Application site has been added to the SPARES application with the following key information You are now able to begin entering any information that your department is responsible for If there are any questions regarding this site please contact Pam Hatalowich at extension 5365 The email should be sent to the following users Concessions Management Natalie Bortz Tony Liberatore Right of Way Section R
111. onsLookup Tables ctrl E D Enter Mew Traffic Counts Enter New Demographic Data Edit Security Information F County Municipality Showing record 1 of 227 20 10 New service plaza Montgomery Plymouth Begin Direction Station Fare Collection Dist Maint District Site Type Located Between 20 10 20 90 123 45 4 Service Plaza and 3 Site Detail Building Fuel Infa Concepts Insp servicez Leases Litilitie s Parking Opening Date 3 2 1895 Site Status HISTORICAL Last Record Update 11 2 2002 a Mailing Address Desc Comment iL of Legislator Address 2 Legislative District City egislative Distric sae Hours af Operation Open 24Hours Open FOO AM Closed Service Plaza Usage Type Number of Norn Revenue Cards Issued 12 Uther Longitude 124 5555555555 Latitude Turm amp mund Back Gate Access OperatorContact Access Road Insurance Information Access Road Description Property Information Record Validation 10 28 2002 3 Validate Site Record The New Traffic Counts option is not available at this time If you choose this option by single clicking the menu option you will get the following message SPARKS Application Message This Selection Not Available 110 USER MANUAL SPARKS January 28 2003 IV ENTER NEW DEMOGRAPHIC DATA PTC Site Planning Asse
112. option can access this option PTC Site Planning Asset and Resource Knowledge System User ROTDE 3 Iof x File Administrative Tasks Edit Common Lookup Tables Enter New Traffic Counts Enter New Demographic Data Edit Security Information County Municipality Showing record 1 of 227 20 10 New service plaza Montgomery Plymouth Begin M P EndM P Direction Station Fare Collection Dist Maint District Site Type Located Between 20 10 20 90 NB 123 45 2 4 Service Plaza and 31 Site Detail Buildings Fuel Info Concepts Insp Services Leases Utilities Parking Opening Date 3 2 1835 Site Status HISTORICAL Last Record Update 11 7 2002 test n Mailing amp ddress Desc Comment ko y ITA fe Legislator Address 2 Legislative District State Zip Hours of Operation Open24Hous Open 7 004M Closed Service Plaza Usage Type Number of Non Revenue Cards Issued 12 Other Longitude 124 5555555555 Latitude v Tum round Back Gate Access Operator Contact Access Road Name Insurance Information Access Road Description Property Information Record Validation 10 28 2002 ROTDEV3 Validate Site Record 109 USER MANUAL SPARKS January 28 2003 III ENTER NEW TRAFFIC COUNTS PTC Site Planning Asset and Resource Knowledge System User ROTDE S OF gt lt Administrative Tasks Edit Comm
113. or more details on the Equipment form please refer to Chapter 6 Section F Rooms REST ROOMS Button Opens the Rest Rooms form For more details on the Rest Rooms form please refer to Chapter 6 Section G Construction History CONSTRUCTION HISTORY Button Opens the Construction History form For more details on the Construction History form please refer to Chapter 6 Section H Validate Bld Structure Record VALIDATE BLD STRUCTURE RECORD Button Will change the validation label based upon the user logged on and the current system date Record Validation 10 46 2002 RO TB ES lt gt lt RECORD NAVIGATION Buttons Allow you to scroll through the buildings for the Site These navigation buttons function in the same manner as the main navigation buttons 125 USER MANUAL SPARKS January 28 2003 G FUEL INFORMATION site Detail Buildings Fuel Info Concepts Inspi services Leases Parking Last Record Update Corporate Name Convenience Store Location Pay atthe Pump Service Number of Islands Number of Purnps Emergency Plan Mumber of Full Service Pumps Minimum Canopy Clearance Ft Fuel Brand Canopy Light type FO Fire Suppression System Inspection Date Description 7 Contact Information Leak Detection System Spill Control Plan Insurance Information De icing materials used Monitoring Well Info Fields Available Corporate Name
114. oto you want to add And click the Open Button If you want to close this form without adding a picture choose the _ Came Button 161 a Photo Preview USER MANUAL SPARKS January 28 2003 Once you find the photo you want to add it will appear in the Photo Preview After you enter a photo date and photo description you can click the SAVE PHOTO TO DATABASE Button Save Photo to Database SAVE PHOTO DATABASE Button Will save the location of the photo the photo date and description to the Photos database table 162 USER MANUAL SPARKS January 28 2003 Find Photos FIND PHOTOS Button will find all the photos that are associated with the Site based upon the Photo Type and display a list of them in the list box 09 01 22002 09 12 2002 test 0970172002 Burger King 09 11 2002 Burger King 06 01 22001 Out side photo of the grass See ther 070872002 Boiler 10 21 2002 test matt 01701 2001 tESTING ANOTHER PHOTO 10 18 2002 Flag Pole 10718 2002 test 2 18 2002 brad 10 10 2002 test 10 10 2002 Test photo Display Selected Photo DISPLAY SELECTED PHOTO Button will open the display photo form 163 USER MANUAL SPARKS January 28 2003 Display Photo 09 01 2002 Flag pole Photo Date Photo Description Flag pole 9 122002 Fields Available Fhoto D ate 92122002 Photo Date date the photo was taken Must MM DD YYYY format
115. ou m m D 5 v 2 2 o0 ET 5 2 j 5 5g z 2 m n Soc 75 n 4 Q E58 SF E 2 m lt O Se z z E 50N E gt o a i 5 ia A 2 gt z T iJ N 5 as Q 5 A 2 Q 0 R ugs WARRANTY CONTACT Button Will open the Contact information form For more details 181 on the Contact Information form please refer to Chapter 6 Section USER MANUAL SPARKS January 28 2003 CANCEL Button Appears when the D 7 Button is clicked When this button is clicked any field changes will be lost and any original field values will be restored SAVE Button Becomes enabled when the D 7 button is clicked When this button is clicked all changes will be saved to the database DELETE Button When this button is clicked you will be prompted to see if you actually want to delete the current record Delete Confirmation ARE YOU SURE YOU SANT TO DELETE THE CURRENT ROOF DETAIL RECORD If the YES Button is clicked the record will be removed from the database If the Button is clicked nothing will happen 9 RECORD NAVIGATION Buttons Allow you to scroll through the each of the roofs for the buildings at the Site These navigation buttons function in the same manner as the main navigation buttons 182 USER MANUAL SPARKS January 28 2003 F EQUIPMENT FORM
116. peration There are two options with this field You can choose the Check box marked Opened 24 Hours or you can enter the Open and Closed times into the appropriate fields After you enter a value it will be formatted in the following format HH MM AM PM Number of Non Revenue Cards Issued A numeric value for the number of cards issued for the site The value must be a number 121 USER MANUAL SPARKS January 28 2003 Longitude A numeric value that represents the geographical Longitude of the site Latitude A numeric value that represents the geographical Latitude of the site Turn Around A check box that should be checked if there is a turn around at this site Back Access Gate A check box that should be checked if there is a back access gate at the site Access Road Name The road name given to the access road if there is one at the site Access Road Description Any comments that you feel are necessary to describe the access road Mailing Address Contains the Street Address Address 1 and Address 2 the City State and Zip Code for the Site If the Site Type Service Plaza Service Plaza Usage The value represents the usage type for this service plaza The valid values are available in a drop down list If the Site Type Toll Plaza or Interchange Park and Ride Available A check box that should be checked if there is Park and Ride service available 122 USER MANUAL SPARKS January 28 2003 Buttons Avail
117. r of parking spaces for cars This field must be a numeric value Trucks The number of parking spaces for trucks This field must be a numeric value Buses The number of parking spaces for buses This field must be a numeric value Handicap The number of handicap parking spaces This field must be a numeric value Oversize The number of oversize parking spaces This field must be a numeric value Employee The number of employee parking spaces This field must be a numeric value Overnight Restrictions A text field describing any Overnight Restrictions that may exist 135 USER MANUAL SPARKS January 28 2003 Buttons Available Parking Lot Construction A enovation History PARKING LOT CONSTRUCTION RENOVATION HISTORY Button Opens the Parking Lot History form For more details on the Parking Lot History form please refer to Chapter 6 Section N 136 USER MANUAL SPARKS January 28 2003 CHAPTER FIVE MENU AND BUTTON BAR FUNCTIONALITY A EDITING COMMON LOOKUP TABLES SPARES Common Lookup Tables Manager SPARKS Common Database Tables Select Common Table ta Update Concept Type Current Table Concept Type r af records 4 Vaue 2 RHecordllpdate r o User fro 7912001 Service Station SemceStaon 83702 BR DGERS 77120002 fRestawan Redauwa 0 88700 _ 72003 Famers Maket Famers Maket 83202 5 _
118. re Fuel Info Photos then continue with Step 3 Step 3 The Concessions Management department should add the Fuel Info Photos PTC Site Planning Asset and Resource Knowledge System User MMCCONME File Administrative Tasks General Site Information and Milepost SiteName County Municipality Showing record 3 of 228 a 30 13 Lansdale Interchange Montgomery Towamencin Begin End Direction Station Fare Collection Dist Maint District Site Type Exit Old Num 30 13 30 13 555 00 4 Toll Plaza 31 Site Detail Building Fuel Info Concepts Insp Services Leases Litilties Parking Opening Date 12 12 2002 Site Status HISTORICAL Last Record Update 10 8 2002 this 1 the landsdale interchange 2 v aling Desc Comment E Legislator legislator 12 Address 2 27 ECHERSUTE Entry City PO Legislative District legislative district Direction State m Hours of Operation Open 24 Hours Open Closed Esil Park and Ride Available Direction Humber of Man RHevenue Cards Issued 5 Tall Plaza Collection Info Longitude Latitude Turm amp round Back Gate Access Operator Contact Access Road Insurance Information Access Road Description Property Infarmatian Record Validation 08 06 2002 BRODGERS Validate Site Record 53 USER MANUAL SPARKS January 28 2003 Figure
119. ress Desc Commert 1 Legislator Address 2 Legislative Distnct State Zn Hours of Operation Open24Hous 700AM Closed 800 Service Plaza Usage Number of Revenue Cards Issued 12 Othe Longitude 124 5555555555 Latitude Tun amp vund v Back Gate Access Operetor Corkact Access Road Name Insurance Infomation Access Road Description Property Information Record Vaidation 10 28 2002 ROTDEV3 Validate Site Record The buttons on the button bar control the data processing and reporting that are done while using the SPARKS application For more details regarding the buttons specific functionality please refer to Chapter 3 Section C 104 gt General Site Information USER MANUAL SPARKS January 28 2003 PTC Site Planning Asset and Resource Knowledge System User File Administrative Tasks ele et Route and Milepost SiteName Municipality Showing record 1 of 222 County 20 10 New service plaza Montgomery Plymouth Begin EndM P Direction Station Fare Collection Dist Mark Distiict Site Type Located Between 2010 20 90 NB 123 45 2 4 Service Plaza I and 31 ste peto Opening Date 3 2 1995 Site Status HISTORICAL lest Desc Comment Legislator Legislative Distnct Hours of Open 24 7 00AM Clo
120. ring Design Department Roadway Section the Concessions Management should add the Services information The services information form is accessible from the Insp Services Tab site Detail Building Fuel Into Concepts Insp services Leases Utilities Services Figure 4 ADDING SERVICES Services available at New service plaza Available Service Types Service Types Available at this Site Travel Infa SemiceTypeg 1 RECORD UFDATE Picnic Areas gt 11 20 2002 Pet Areas 10 28 2002 V Jwelcome Center 10 28 2002 TTN 10 28 2002 Touch and Go 10 28 2002 D ial a Truck Touch and Go 10 28 2002 EN Dial a T ruck 107 2872002 Add Selected Semice Tupe gt gt lt lt Remove Selected Semice Fram this Site For more details on the SERVICES FORM please refer to Chapter 6 Section L 81 USER MANUAL SPARKS January 28 2003 Add Services Check List Concessions Management Department Add Services Info 82 USER MANUAL SPARKS January 28 2003 F ADDING LEASES ADD LEASES CONCESSIONS MANAGEMENT RECEIVES A SIGHED OF THE LEASE SEND Organizational Process Application Process ALL ACTIVITIES PERFORMED THIS FLOW ARE BY THE COHCESSIOHS MAHAGEMEHT DEPARTMENT 83 USER MANUAL SPARKS January 28 2003 Step 1 Upon receiving a copy of the signed Lease agreement the Concessions Management should add
121. s Available Contact Type This value will change based upon the tab that you access the form from e Site Detail Tab Operator e Fuel Info Tab Fuel e Concepts Vendor e Utilities Utility e Insurance Information Form Insurance e Roof Details Information Form Warranty Name The full name of the Contact Company The company name for the Contact Title The job title of the Contact Address The Address of the Contact Includes e City State e Zip Phone The phone number at which the Contact can be reached Fax The fax number at which the Contact can receive faxes Email The email address at which the Contact receives emails Emergency Contact Number In the event of an emergency this is an additional number the Contact should be reached at Responsible Hours The hours that the Contact is responsible and can be contacted during 167 USER MANUAL SPARKS January 28 2003 Buttons Available EXIT Button Will Close the Contact Information Form and return control to the main form EDIT Button Will change any field that can be changed to a light blue color The ED T button will become the CANCEL Button and the SAVE Button will be enabled Contact Information Last Record Update Contact Type Operator Hame FEFEEPEPEPPEEPPEFPPEPEPEPEFPEPEFPPPEFEPEFEEEEEEFEFPEEEEEETEEPETEEPEPEPEFEPEFPBEEI EMXMNXNEMZXXEMXYXEXMXXEMXXMMXXMEMXXEMXXXEMXXXEMXXXEEMXXEMXXMEMXXEMXXEMXXEMXXMMXXMMMI
122. s Insp services Leases Utilities Parking Opening Date 53 2 1995 Gite Status Open Last Record Update 11 25 2002 test E Mailing Address Desc Comment Legislator Address 2 City Legislative District State Hours of Operation Open 24Hours Open UDAM Closed Service Plaza Usage Type Number of Non Revenue Cards Issued 12 Other Longitude 124 5555555555 Latitude Back Gate Access Operator Contact Access Road Mame Insurance Information Access Road Description Record Validation 10 28 2002 HO TDEV 3 Validate Site Record Figure A 6 ADD PROPERTY INFORMATION Property Detail Information toll plaza test Acreage Last Record Update 12 4 2002 Deed Book Deed Book Page Number Deed Number Hight afv ay Information A H For more details the Property Detail Information form please refer to Chapter 6 Section C 19 USER MANUAL SPARKS January 28 2003 Step 5 Upon receiving the email from the Engineering Design Department Roadway Section the Concessions Management Department will add the Site Info Figure A 7 ADD SITE INFO Site Detail Buildings Fuel Into Concepts Insp services Leases Ltilities Parking Opening Date 3 2 1335 Cite Status Open Last Record Update 11 26 2002 test Mailing Address Desc Comment est Legislator Address 2 City Legislative Distr
123. s Used Size Responsible Party 93 USER MANUAL SPARKS January 28 2003 Figure G 4 ADDING UTILITY CONTACT INFORMATION Contact Information For more details on the CONTACT INFORMATION FORM please refer to Chapter 6 Section A 94 USER MANUAL SPARKS January 28 2003 Adding Utilities Check List Engineering Facilities Department o Add Main Utility Info o If the Utility is a Water System o Add Water System Details o If the Utility is a Waste Water System Waste Water System Details o Add Utility Contact Info 95 USER MANUAL SPARKS January 28 2003 CHAPTER THREE APPLICATION ACCESS A ACCESSING THE APPLICATION The SPARKS Application will be accessed through the Citrix Program Neighborhood G 520 to Oracle Shortcut to Conversion HotSync Shortcut to OnBase Contig Concept Ty Disk Tools Erpe Sel PASS 5 e 2 SPORT t Terra OnBase Config Navigato S JSView in re Pro Mainframe Terrain 215 Navigator Application E Shortcut to NewCars CARS Production RAMS Production FF 4 Citrix Program Fleet Tracking Neighborhood System um Ge Acrobat Weekly Status Reader 4 0 Palm Desktop p Easy CD start KS calendar Microso Documentation Manual 116 P windows Media Pl Volume Control 5 dg 4 23 D 7 49 AM If this is the first time that you
124. s label will change as you navigate through the records Begin Direction Station Fare Collection Dist M aint District Site Type Located Between 20 10 20 90 123 45 2 4 Service Plaza and 3l Begin MP The unique designator from the Turnpike mile marker where the Site begins In most cases this field s value should match the milepost fields value The values should be within the limits set for the Milepost field 117 USER MANUAL SPARKS January 28 2003 End MP The unique designator from the Turnpike mile marker where the Site ends The values should be within the limits set for the Milepost field Direction The value to distinguish which side of the roadway the site is located The valid values for the direction field are based upon the Route field value f Route T then Direction can EB WB If Route A then Direction can NB or SB If Route G then Direction can NB or SB If Route M then Direction can NB or SB f Route B then Direction can NB or SB Station A geographical value representing the location of the site 118 USER MANUAL SPARKS January 28 2003 Fare Collection District A unique numerical representation for the Fare Collection district that the site resides in The value of this field is dependent upon the route and milepost values The following guide should be used to enter this value If Route and Milepost gt 0 00
125. s the de icing materials that are used Monitoring Well Info A text field that describes the monitoring well information Buttons Available OperatorLontact OPERATOR CONTACT Button Opens the Contact Information form For more details on the Contact Information form please refer to Chapter 6 Section A Insurance Information INSURANCE INFORMATION Button Opens the Insurance Information form For more details on the Insurance Information form please refer to Chapter 6 Section B 127 USER MANUAL SPARKS January 28 2003 H CONCEPTS INFORMATION site Detail Building Fuel Info Concepts Inspiservices Leases Ltilties Parking Last Record Update 10 22 2002 Vendor Site Operator Burger King Concept Site Number Location at Site tthis iz a test Description Concept Type Restaurant Concept Square Footage 1545 00 Hours of Operation Open 24 Hours Open Closed 4 48 PM lt Sales Information Insurance Information Rental Rate Information Contact Information Fields Available Vendor Name A text field representing the name of the Vendor Site Operator Check Box Determines whether there is a site operator for this vendor Location as Site A text field used to describe the location of the vendor at the Site Concept Site Number A text field that represents the site number for the vendor Description A text field that describes the service the v
126. s will be lost and any original field values will be restored 115 USER MANUAL SPARKS January 28 2003 D GENERAL SITE INFORMATION PTC Site Planning Asset and Resource Knowledge System User File Administrative Tasks e ellas General Site Route and Milepost is Site Municipality Showing record 1 of 222 fk 2010 New service plaza 22 Plymouth Begin EndM P Direction Station Fare Collection Dist Maint Distiict Sie Located Between 2 CN ee remo Opening Date 3 2 1995 Site Status HISTORICAL mm Record Update 10 28 2002 test Desc Comment Legislator Legislative Distnct Hours of Operation Open24Hous 7 00AM Closed 8 00 PM Service Plaza Usage Type Othe Number of Non Revenue Card Issued 12 Longitude fi 245555555555 Latitude v TuinAround 7 Back Gate Access Operator Cortact Access Road Name Insurance Information Access Road Description Propeity Information Record Vaidation 10 28 2002 ROTDEV3 Validate Site Record Route and Milepost SiteName Route Unique designator for the part of the Turnpike s Roadway that the Site resides e The Accepted values for the Route Field are o T Mainline A Northeast Extension Beaver Valley Expressway o G Greensburg
127. sed 800 PM Service Plaza Usage Type Othe Number of Non Revenue Card Issued 12 Longitude fi 245555555555 Latitude v TuinAround 7 Back Gate Access Operator Corkact Access Road Name Insurance Information Access Road Description Property Information Record Vslidation 10 28 2002 ROTDEV3 Validate Site Record The General Site information contains the key pieces of information that are necessary for uniquely identifying each site For more details on each field and valid values please refer to Chapter 3 Section D 105 USER MANUAL SPARKS January 28 2003 Tab Control Information __ Site Planning Asset and Resource Knowledge System User ROTDEV3 Ele Administrative Tasks General Site Information andMiepos SieName County Municipality Showing record 1 of 222 2010 New cervice plaza Montgomery Pipmext EndM P Direction Station Fare Colection Dist Mar Detuct Ste Located Belween Opening Date 3 2 1995 Site Status HISTORICAL Record Update 10 28 2002 Address Desc Comment a Adder Legislator Legislative Hours of Opesabon Open 24 Hows Open 700AM Closed 800 PM Service Usage Type Other Site Detail Buidings Fuel infa Number of Non Aevenue Card Issued 12 Longitude 124 5555555555 Latitude Tun ound 7 Back Gal
128. ssions Inspectors v Read Access 152 USER MANUAL SPARKS January 28 2003 Fields Available Note You can choose one or more of the following options Logon user 14 The users NT logon id This is usually your first initial and your first 7 letters of your last name or your entire last name if it is less than 7 characters Examples Matthew McConnell User id MMCCONNE last name gt 8 characters Robert Smith User id RSMITH last name lt 8 characters Security Check Box Check the box if the user should have the ability to add update or delete users from the security table Note Only the owner of the application a backup and IT developers will usually have this checked Photos Check Box Check the box if the user should have the ability to add update or delete photo information This check box determines if the PHOTOS Button appears on the button bar Traffic Demographics Check Box Check the box if the user should have the ability to add Traffic or Demographic statistics This check determines if the Enter New Traffic Counts and Enter New Demographics Administrative menu options are grayed out Edit Lookup Tables Check Box Check the box if the user should have the ability to add update and delete Lookup table information This check box determines if the Edit Lookup Tables Administrative Menu option is grayed out Note You can choose ONLY ONE of the following options Roadway Section Check Box
129. st be paid Tier 2 Amount A number representing the 2 tier minimum rent that must be paid Tier 3 Amount A number representing the 3 tier minimum rent that must be paid Term years A number representing the number of years the rental agreement is for Buttons Available Bi EXIT Button Will Close the Rental Rate Information Form and return control to the main form EDIT Button Will make any data that can be changed a light blue color The ED T button will become the CANCEL Button and the SAVE Button will be enabled e CANCEL Button Appears when the D 7 Button is clicked When this button is clicked any field changes will be lost and any original field values will be restored SAVE Button Becomes enabled when the D 7 button is clicked When this button is clicked all changes will be saved to the database 199 USER MANUAL SPARKS January 28 2003 mus DELETE Button When this button is clicked you will be prompted to see if you actually want to delete the current record Delete Confirmation ARE YOU SURE YOU WANT TO DELETE THE RENTAL RATES RECORD If the YES Button is clicked the record will be removed from the database If the Button is clicked nothing will happen lt 9 RECORD NAVIGATION Buttons Allow you to scroll through the each of the roofs for the buildings at the Site These navigation buttons function in the same manner as the main navigation but
130. stroom record is added Rest Room Type The type of restroom The valid values are available from the drop down list Toilets A number representing the number of toilets in the Rest Room This field must be a number Urinals A number representing the number of urinals in the Rest Room This field must be a number Sinks A number representing the number of sinks in the Rest Room This field must be a number 189 USER MANUAL SPARKS January 28 2003 Handicap Fac A number representing the number of handicap toilets in the Rest Room This field must be a number Showers A number representing the number of showers in the Rest Room This field must be a number Hand Dryers A number representing the number of hand dryers in the Rest Room This field must be a number Towel Holders A number representing the number of towel holders in the Rest Room This field must be a number Sensor Flush Units A number representing the number of sensor flush units in the Rest Room This field must be a number Sensor Operator Sinks A number representing the number of sensor operator sinks in the Rest Room This field must be a number Vending Machines Check Box Check this box if there are vending machines in the Rest Room Baby Change Station Check Box Check this box if there is a baby changing station in the Rest Room Attendant on Duty Check Box Check this box if there is an attendant on duty in the Rest Room Buttons Av
131. t and Resource Knowledge System User ROTDEV3 Mi Administrative Tasks Edit Common Lookup Tables Enter Mew Traffic Counts ctrl E Enter Mew Demographic Data 8 Edit Security Information F County Municipality Showing record 1 of 227 2010 New service paza Montgomey Begin Direction Station Fare Collection Dist Maint District Site Type Located Between 20 10 20 90 123 45 2 4 Service Plaza and al Site Detail Buildings Fuel Info Concepts Insp sServices Leases Parking Opening Date 3 2 1985 Site Status HISTORICAL Last Record Update 11 7 2002 test E Mailing Address Desc Comment fet Legislator Address 2 City Legislative District State Zip Hours of Operation Open 24 Hours Open Closed Service Plaza Usage Type Number af Norn Revenue Cards Issued 12 Uther Longitude 124 5555555555 Latitude Turm Around Back Gate Access Operator Contact Access Road Mame Insurance Information Access Road Description Property Information Record Validation 10 28 2002 ROTDEVS Validate Site Record New Demographic Data option is not available at this time If you choose this option by single clicking the menu option you will get the following message SPARKS Application Message e This Selection Not Available 111 USER MANUAL SPARKS January 28
132. t should add the Waste Water System Details Information The System Details form is accessible from the Utilities Tab site Detail Building Fuel Info Concepts Inspi services Leases Utilities Parking Last Record Update 10 11 2002 Utility Information Utility Utility Provider water compar Water System Account Number Meter Location Materials Used Size Responsible Party Contact Information 91 USER MANUAL SPARKS January 28 2003 Figure G 3 ADDING WASTE WATER SYSTEM DETAILS i Waste Water System Details New service plaza Sewer Last Record Update 11 7 2002 Milepost 1 10 Waste Water System Type Install Date 10710 2000 Septic Sewer Authority National Pollutant Discharge Elimination System HPDES Permit Number Permit Expiration Date HPDES Responsible Party Location Description s For more details on the WASTE WATER SYSTEM DETAILS FORM please refer to Chapter 6 Section M 92 USER MANUAL SPARKS January 28 2003 Step 4 The Engineering Facilities Department should add the Utility Contact Information The Utility Contact Information form is accessible from the Utilities Tab site Detail Building Fuel Info Concepts Insp services Leases Utilities Farking Last Record Update 10 17 2002 Utility Information Utility Utility Provider Sewer Waste Water System Account Humber Meter Location Material
133. text field containing any additional comments about the equipment Under the WARRANT INFORMATION TAB Accessed by clicking the ADD WARRANTY RECORD Button Waranty Information Php e 0000 0000 KXXZEXXZEXZZZXZXZXEXEEEI Ve L h ape Bari eee Lengt Warranty Description Comments Warranty Date The date the warranty took effect The format for the date is MM DD YYYY Warranty Exp The date the warranty will expire The format for the date is MM DD YYYY Warranty Length A text field containing the number of years that make up the length of the warranty Warranty Company A text field containing the name of the warranty company Warranty Description Comments A text field containing the description of the warranty or any additional comments that are necessary to describe the Warranty 184 USER MANUAL SPARKS January 28 2003 the ADD This will only be avatlable if the Under the EMERG GENERATOR DETAILS TAB Accessed by clickin GENERATOR DETAIL RECORD Button is Generator t equipmen D c ium m s D D 9 ium D E Warranty Information Voltgage EVA EM A text field containing the Voltage for the Generator Voltage Phase A text field containing the Phase for the Generator A text field containing the Kilowatts for the Generator
134. tion Engineering Facilities o Add Building Information o If there are building Photos o Add Structure Building Photos o Add Roof Details o If there is a Roof Warranty o Add Warranty Contact Info o If there is Equipment in the Building o Add Equipment Info o If there are Equipment Photos Add Equipment Photos o Add Construction History o If there is a Restroom in the building o Add Restroom Record If there is a fuel Island on the Site o Add Fire Suppression System Fuel Information o Validate Structures 48 T USER MANUAL SPARKS January 28 2003 C ADDING FUEL INFORMATION ADD FUEL INFO TASK 2 Completed by the Risk TASK 1 Completed by the Concessions Management Department Management Department gt Organizational Process Application Process lt gt Decision Process 49 USER MANUAL SPARKS January 28 2003 Adding Fuel Information is done in two completely separate tasks Task 1 is the responsibility of the Concessions Management Department Task 2 is the responsibility of the Risk Management Department TASK 1 Step 1 The Concessions Management department should add the Fuel Information on the Fuel Info Tab Figure C 1 ADDING FUEL INFORMATION site Detail Building Fuel Info Concepts Inspi services Leases Parking Last Record Update 11 7 2002 Corporate Name asdfasdiasdfasdi Convenience Store Location Pay atthe Pump Service Number of Islands Mumber of Pu
135. tion Date HPDES Responsible Party Last Record Update Location Description Fields available Milepost A numeric value for the Turnpike mile marker at which the waste water system resides Install Date The date the waste water system was installed The format of the date is MM DD YYYY Waste Water System Type The type of waste water system The valid values are accessible from the drop down list Sewer Authority A text field containing the name of the sewer authority NPDES Permit Number A text field containing the NPDES permit number Permit Expiration Date The date the NPDES permit will expire The format of the date is MM DD YYYY 208 USER MANUAL SPARKS January 28 2003 NPDES Responsible Party A text field containing the name of the NPDES person responsible for our NPDES permit Location Description A text field that describes the location at the site of the Waste Water system Buttons Available 51 EXTT Button Will Close the Waste Water System Details Form and return control to the main form EDIT Button Will make any field that can be changed a light blue color The EDIT button will become the CANCEL Button and the SAVE Button will be enabled CANCEL Button Appears when the 277 Button is clicked When this button is clicked any field changes will be lost and any original field values will be restored SAVE Button Becomes enabled when the D 7 button
136. tons 200 USER MANUAL SPARKS January 28 2003 J PROCESS INSPECTIONS FORM The Process Inspections Form is provided so that after an inspector has filled out one of the Inspection forms they can import the data into the SPARKS application for the purpose of running queries at a later date This process should only be done after the inspector has completed the inspection report and the inspection report has been saved to the Network The form is accessible only from the Insp Services tab Process Inspections for Site New service plaza Select Inspection Type ta Process Restaurant C Rest Rooms Service Station Inspectors Select Inspection Type to Process Restaurant Rest Rooms Service Station Select Inspection Type to Process Radio Buttons Choose the type of inspection report you want to process Inspectors Inspectors Drop down list Choose the Inspector from the drop down list that completed the report 201 USER MANUAL SPARKS January 28 2003 Buttons Available EXIT Button Will Close the Process Inspections Form and return control to the main form PROCESS INSPECTION FORM Button Will open the Open File Common Dialog Select an Inspection Form to Process Look in Sy 020 10 ER File name Open Files of type Inspection Forms xls Cancel Open as read only My Network Navigate t
137. utton and the WEW Button will become the SAVE Button NEW Button Will open the enter new sales period form Enter a New Sales Period Period 1 13 Year 2002 OF Cancel Period Enter a value from 1 13 Year Enter a four digit year OK Button Will create a new line in the data grid on the Sales Information form for each of the vendors at the site If the Period value you have entered already exists then the following message will appear SPARKS Application Message Records Exist Far Period 13 Year 2002 196 USER MANUAL SPARKS January 28 2003 The EDIT button will become the CANCEL Button and the VEW Button will become the SAVE Button CANCEL Button Will Close the enter a new sales period form and return control to the sales information form CANCEL Button Appears when the D 7 Button is clicked When this button is clicked any field changes will be lost and any original field values will be restored SAVE Button Becomes enabled when the D 7 button is clicked When this button is clicked all changes will be saved to the database DELETE Button When this button is clicked you will be prompted to see if you actually want to delete the current record The current record is the record in the data grid with the next to it Delete Confirmation 2 ARE YOU SURE YOU WANT TO DELETE THE 1 SELECTED SALES RECORDS If the YES Button is clicked the record
138. will be removed from the database If the Button is clicked nothing will happen 197 PENA TURN i USER MANUAL SPARKS January 28 2003 1 RENTAL RATE INFORMATION FORM The Rental Rate Information form contains information about the rental rates for the various vendors at the site The Rental Rate Information form is only accessible from the Concepts tab site Detail Building Fuel Into Concepts Inspiservices Leases Litilitie s Parking Last Record Update 12 10 2002 Vendor Mame Site Operator Arbys Concept Site Number Location at Site tthis iz a Fest Description 7 Concept Type Restaurant Concept Square Footage 1545 00 of Operation Open 24 Hours Open 15 AM Closed 16 48 lt Sales Information Insurance Information Rental Hate Information Contact Information w Rental Rates New service plaza testing Concept Yendor Burger King Hesturant Hates Base Percentage Tier 2 Percent Tier 2 Amount Tier 3 Percent Tier 3 Amount Annual Minimum Rental Term years 198 USER MANUAL SPARKS January 28 2003 Fields Available Base Percentage A number representing the base rental rate percentage Tier 2 Percent A number representing the 2 tier rental rate percentage Tier 3 Percent A number representing the 3 tier rental rate percentage Annual Minimum Rental A number representing the Annual minimum rent that mu
139. will open the Add Sparks photos form Add Sparks Photos New service plaza Mew service plaza Select Photo Type Fuellnfa Concept endor Structure Utilities Equipment Photo Preview Photo Date Select Photo Photo Descriptor 5 Save Photo to Database 159 USER MANUAL SPARKS January 28 2003 Select Photo Type Fuellnfa Structure Utilities Equipment Much like the main photos form you choose the Photo type that you want to add Fields Available Photo D ate Photo Date The date the photo was taken Must be in MM DD YYYY format Photo Description n Photo Description A brief description of what the photo is showing 160 USER MANUAL SPARKS January 28 2003 Buttons Available Select Photo SELECT PHOTO Button Will open the Open Common Dialogue Get Photo Ix Look Sy 020 10 INE gi 020 1 00000 1 Ps A020 10P 0100016 BY 020 10 000002 20 10P 000018 020 10P nonon3 20 10 _000020 020 10 000004 020_10 _000021 4020_10 _000005 EF 4020_10 _000006 EF 4020_10 _000013 4020_10 _000014 Sf 4020_10 _000015 Documents Compute Te File name 020 10P 000001 Network Open as read only 7 You should navigate to find the ph
140. y 28 2003 Rest Room Information New service plaza testing Rest ID Rest Room Type Last Record Update Toilets Hand Dryers Urinals Towel Holders Sinks Sensor Flush Units Handicap Fac Sensor Operated Sinks Showers Vending Machines Baby Change Station Attendant on Duty For more details on the REST ROOM FORM please refer to Chapter 6 Section G Step 9 The Concessions Management Department should update each of the Restroom Records 44 USER MANUAL SPARKS January 28 2003 Rest Room ID Rest Room Toilets Hand Dryers Urinals TowelHoldes Sinks Sensor Flush Units Handicap Sensor Operated Sinks Showers Vending Machines Baby Change Station Attendant on Duty For more details on the REST ROOM FORM please refer to Chapter 6 Section G 45 PENNA 4 TURN 2 Pire If there is a fuel island at the Site then continue with Step 10 USER MANUAL SPARKS January 28 2003 Step 10 The Engineering Facilities Department should add the Fire Suppression System information on the Fuel Tab Figure B 10 ADD FIRE SUPPRESSION FUEL INFORMATION site Detail Building Fuel Info Concepts Insp Services Leases Parking Last Record Update 11 7 2002 Corporate Name asdfasdiasdiasdi Convenience Store Location FO Pay at the Pump Service Number of Islands Number of Pumps Emergency Plan

CHAPTER ONE

Contents

Download Pdf Manuals

Related Search

Related Contents