2.3 Data Requirements

The following section describes where the data flows will be captured and the frequency of data transfers for analysis during the pilot test.

2.3.1 Test Information Stored

2.3.1.1 In general, the UTT system shall retain all user data online for a period of time configurable by authorized users from a minimum of 14 days to a maximum of 6 months. (UTT system users may create their own systems to capture and store information indefinitely.)

2.3.1.2 For the pilot test, all data shall be saved for the duration of the test and analysis period.

2.3.2 Test Data Collection Rates

Definition

The data collection rate specifies the frequency of recording the pilot test information.

Performance constraints and requirements

2.3.2.1 For the pilot test, data shall be collected from every message.

2.3.3 Test Data Storage Means and Format

Definition

Data storage means and format defines the method by which pilot test data is stored for analysis.

Performance constraints and requirements

2.3.3.1 Pilot test data shall be stored in Microsoft Excel spreadsheets.

2.3.3.2 Pilot test data shall be secured in a 64-bit encrypted, password protected zip file, and written to a CD.

2.3.4 Test Data Retrieval

Definition

Pilot test data retrieval specifies the requirements for capturing data produced during the test. In general, trailer and tractor information is sent over the air from mobile terminals, processed in a network management computer, and then sent to individual user accounts. For this test, the applications receiving this data are web applications hosted by the UTT system provider. Relevant test data will be retrieved from these databases and then processed and saved in spreadsheet format.

Performance constraints and requirements

Pilot test data shall be processed into a common format.

Pilot test data shall be categorized by user, vehicle, transaction type, and event type.

Pilot test data shall be imported into an Excel spreadsheet weekly.

Pilot test data shall be organized within the spreadsheet in pivot tables to provide summary data views.

Previous | Next