Transcript Automated Ticketing Management System

Airware
User Design Documentation
For
ATMS Application
by
Airware
ATMS
Airware
ATMS
Background and Experience Aviation Consulting General Consulting
Ticket MGMT System Program/Construction MGMT IT Group
Sitemap | © Copyright 2008 Airware. All Rights Reserved. | Contact Us
Airware
ATMS
Airware, LLC
Automated Ticket Management System
Click to Log-In
Airware
ATMS
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
Airware
ATMS
Table of Contents
i.
Introduction/background……………….pg. 4
A. Objective
Software Application Functions
ii.
Log-In…………………………………………………pg. 5
iii.
Menu………………………………………………….pg. 6
iv.
Report generator…………………………..pg. 16
Airware
ATMS
I.
Introduction
The 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.
Background
Most 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.
a. Objective
The 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
Airware
ATMS
Log-in Screen
1)
2)
3)
4)
5)
Go to Site www.airwarellc.com
Click ATMS link
Enter server name. (i.e. computer name\sqlexpress)
Enter database name. (i.e. Deliverable)
Click “Login” to log into database and open application
Vendor Name:
Job Name:
Location:
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:
a)
7)
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
Airware
ATMS
Menu
The menu allows you to continue to navigate through the application.
1.
2.
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.
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
Menu
ATMS Ticketing Management
Application
Vendor ID:
Truck ID:
OK
Exit
Airware
ATMS
Menu
The menu allows you to continue to navigate through the application.
1.
2.
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.
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
Menu
ATMS Ticketing Management
Application
Data Entry
Reports
Sign Off
New
Exit
Airware
ATMS
Enter all data into respective fields (see next page for field information) and press “Enter”.
1)
Data Entry
2
Truck ID Entry Form
1
Date:
Vendor ID:
Smith
Jones
Thomas
Truck ID:
52446
52459
52461
Material ID:
Sand
Gravel
Clay
Disposal:
Landfill
Grind
Levee
5
4
Ticket
Control #:
1226412
1226411
1226140
3
6
17
7
Disposal Site:
11
WB
CB
AB
Origin
9
Zone C
Zone D
Zone E
18
8
Measured Capacity:
14
2nd Tier/
Subcontractor:
Gentilly
Recovery
New Orleans
Yards:
Miles:
12
Rate:
% Full:
Retention:
19
Actual Yard:
Net Amount:
13
Gross Amount:
10
Gross Billable:
15
16
Save
Cancel
All ‘arrow down’ fields are pull-down user-defined (Look-up) data elements
See next pages for field definitions and descriptions.
Airware
ATMS
Data Form Fields
Description
Field Name
Type = Size
1 Date
2 Vendor ID
3 Truck ID
4 Ticket Control#
5 Material ID
6 Disposal
7 Disposal Site
8 Yards
9 Miles
10 % Full
11 Measured Capacity
12 Rate
13 Net Amount
Varchar (8)
Default
Varchar (20)
User-Assigned
Varchar (20)
User-Assigned
Varchar (12)
User-Assigned
Varchar (50)
User Defined
Varchar(12)
User-Defined
Varchar(25)
User-Defined
Numeric (10)
Calc (% x Capacity) - Formula
Numeric (10)
User-Entry
Numeric (FP) (4) User-Entry
Numeric(10)
User-Entry
Numeric (4)
User-Defined
$ Curr
User-Entry (formula) if .NE to
Bill / Amt, then Flag
14 Gross Amount
$Curr
Calc (need formula)
15 Gross Billable
16 Actual Yard
17 2nd Tier Subcontractor
18 Origin
19 Retention
$Curr
#NAME?
$Curr
User-Entry
Varchar(25)
User-Defined
Varchar(25)
User-Defined
$ Curr
Example (Add)
Airware
ATMS
Create Report
1.
2.
3.
Click on reports in the menu, which is located on every page. .
Select the report * that you want to run from the drop-down menu.
The Report allows you to query on dates or tasks in the database and produce a report of the
relevant data in the application.
All Tasks Related to Trucker I
All Tasks Related to Trucker ID
All Issues Related to Trucker ID
Due Dates
*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”.
Airware
ATMS
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
Airware
ATMS
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”.
Airware
4c.)
ATMS
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).
Airware
4c.)
ATMS
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”.
Airware
5.) Press the plus sign inside the report box to expand the list.
ATMS
Airware
ATMS
6.) Click on the name of the database to see your results.
Airware
7.) You can sort the list by clicking on the column heading.
ATMS
Airware
ATMS
AUTOMATED TRACKING DEVICE
Sample Logo for web Site link
Airware
ATMS