Automated Ticketing Management System

1. User Design Documentation For ATMS Application Automated Ticketing Management System by Airware

2. Background and ExperienceAviation Consulting General Consulting Ticket MGMT System Program/Construction MGMT IT Group Sitemap  |  © Copyright 2008 Airware. All Rights Reserved.   |  Contact Us

3. Airware, LLC Automated Ticket Management System Click to Log-In

4. Transmittal For the purpose of the Document Review, all contents are deemed as Confidential in connection with this proposal to the representative listed below. The material is considered as business information in order to evaluate the prospective vendor. ATMS This document also contains a recommended (proposed) design called Automated Ticketing Management System. This strategy is to ensure that all truck disposal data for each truckers’ deliveries can be tracked and monitored using reporting controls. Therefore, we are submitting this proposed strategy for review, consideration, and response. Should you have any questions, please feel free to submit your suggestions or comments for discussion or consideration. Respectfully, Terry William, President Airware Transportation & Logistics

5. Table of Contents • Introduction/background………………. pg. 4 A. Objective Software Application Functions • Log-In………………………………………………… pg. 5 • Menu………………………………………………….pg. 6 • Report generator………………………….. pg. 16

6. IntroductionThe ultimate objective is to track and manage all truckers delivery activity, at any point in time. In addition, the solution will be able to query and report standard or ad-hoc reports as required by the user. The Automated Ticketing Management System’s (ATMS) web-based software application (ATMS) will aide the administrative and management staff in ensuring the information is accurate and on-hand for any required reporting for each truck’s activity. BackgroundMost organizations have a responsibility to manage each project’s operational efficiency as well as possess a robust and mission-critical reporting tool of each project’s operational activities.It is recommended that the organization understand the critical need to manage the project activities under their control. The entity must take ownership, responsibility and accountability for their operational activities. An improperly and/or poorly managed project rarely meets the objectives, nor does it provide the required functionality and completion in a timely and accurate manner, but more importantly, it does not adhere to budget. In order to minimize risks and maximize the statistics of success, specific processes and project management activities must be established and adhered to. • ObjectiveThe objective of this Automated Ticketing Management System is to give the administrators easy entry, storage and retrieval - access of the data through hyperlink (web-architect), where each user can access anyplace or anytime. In laymen terms, hyperlink is defined as….. ATMS covers three (6) key fields which establish the entity-relationship for each transaction: • Vendor ID (Hard Coded) – Prime Contractor’s Name • Ticket Control ID • Truck ID • Material ID • Subcontractor ID (Name) • Retainer

7. Vendor Name: Job Name: Location: Software Application Functions Log-in Screen • Go to Site www.airwarellc.com2) Click ATMS link3) Enter server name. (i.e. computer name\sqlexpress)4) Enter database name. (i.e. Deliverable)5) Click “Login” to log into database and open application 6) Once log-in occurs, the DATA page will appear; this is the main menu page. Notice at the top left hand corner of the page you will see two options: • File Reports • The File option represents the database storage and retrieval function.The Reports represents the query and reporting function.We will begin the with File function

8. Menu ATMS Ticketing Management Application Vendor ID: Truck ID: OK Exit Menu The menu allows you to continue to navigate through the application. 1. The File tab consists of New and Exit. a. The New link brings up a sub-menu to access each page i. Data Entry ii. Reports iii. Sign Off b. The Exit link allows you to exit the program. Either the menu or Exit buttons can be used to close the program. 2. The Reports tab brings up the Generate Report link. This link brings you to the Reports page.Note: The menu can be accessed from any page

9. Menu ATMS Ticketing Management Application Data Entry Reports Sign Off New Exit Menu The menu allows you to continue to navigate through the application. 1. The File tab consists of New and Exit. a. The New link brings up a sub-menu to access each page i. Data Entry ii. Reports iii. Sign Off b. The Exit link allows you to exit the program. Either the menu or Exit buttons can be used to close the program. 2. The Reports tab brings up the Generate Report link. This link brings you to the Reports page.Note: The menu can be accessed from any page

10. Origin Smith Jones Thomas WB CB AB 52446 52459 52461 Zone C Zone D Zone E Landfill Grind Levee 1226412 1226411 1226140 Sand Gravel Clay Rate: Truck ID Entry Form 2 Miles: 3 Material ID: Vendor ID: 5 Truck ID: Disposal: 4 Data Entry 9 6 17 Gentilly Recovery New Orleans 7 18 1 Date: 11 Disposal Site: 8 Ticket Control #: 12 Yards: % Full: 14 19 2nd Tier/ Subcontractor: 10 13 Measured Capacity: 15 16 Save Cancel Retention: Gross Amount: Gross Billable: Actual Yard: Net Amount: 1) Enter all data into respective fields (see next page for field information) and press “Enter”. All ‘arrow down’ fields are pull-down user-defined (Look-up) data elementsSee next pages for field definitions and descriptions.

12. All Tasks Related to Trucker I All Tasks Related to Trucker ID All Issues Related to Trucker ID Due Dates Create Report 1. Click on reports in the menu, which is located on every page. . 2. Select the report * that you want to run from the drop-down menu. 3. The Report allows you to query on dates or tasks in the database and produce a report of the relevant data in the application. *Note: a.) “All Tasks Related to Trucker” shows every task that is a part of a project. The report shows the any/all relative data for Truckers Activities, Description, etc. b.) “Dates” shows any activity for that period timeframe To create a report for and press “Enter”.

13. Vendor ID Truck ID If the Truck ID is not selected then the query will return all of the Truck IDs’ associated with the selected Vendor

14. 4b.) If “All Issues (Flags) Related to Truckers” is selected, enter the Project ID of the project you want to generate a report for and press “Enter”.

15. 4c.) If “Due Dates” is selected enter the range of dates you want to search for. You can enter the dates manually or you can use the calendar (see below).

16. 4c.) When you click on the arrow, a calendar will appear. You can use the arrows on each side of the calendar to select a different month. When you find the date you want, click the date. Do this for both dates. Once you have chosen your range, click “Enter”.

17. 5.) Press the plus sign inside the report box to expand the list.

18. 6.) Click on the name of the database to see your results.

19. 7.) You can sort the list by clicking on the column heading.

20. AUTOMATED TRACKING DEVICE Sample Logo for web Site link

21. Notes