Abstract: Provide a system for automatically building a query statement for a database. The system includes an electronic processor. The electronic processor is configured to provide a user interface displayed by a display device and including a plurality of tabs. The electronic processor is also configured to provide a first list of a plurality of data fields included in the database. The electronic processor is configured to receive, via the user interface, a first selection of one of the plurality of data fields from the first list and a second selection of a criterion for one of the plurality of data fields from the first list. The electronic processor is configured to automatically build the query statement for the database. The electronic processor is further configured to execute the query statement on the database and output results of executing the query statement.

Abstract: A secondary validator includes a communications interface with a first antenna and a second antenna having a shorter signal range than the first antenna. The validator also includes a processor and a memory having instructions that, when executed by the processor cause the validator to receive, using the first antenna, vehicle information from a first vehicle that is within a signal range of the first antenna. The vehicle information includes route information associated with the first vehicle. The validator provides an indication for a passenger that has exited the first vehicle to check out, reads checkout information from a fare media using the second antenna, detects another vehicle present within a signal range of the first antenna, and provides the checkout information and at least a portion of the transit vehicle information to a primary validator positioned on the another vehicle for subsequent transmission to a transit system back office.

Abstract: A secondary validator includes a communications interface with a first antenna and a second antenna having a shorter signal range than the first antenna. The validator also includes a processor and a memory having instructions that, when executed by the processor cause the validator to receive, using the first antenna, vehicle information from a first vehicle that is within a signal range of the first antenna. The vehicle information includes route information associated with the first vehicle. The validator provides an indication for a passenger that has exited the first vehicle to check out, reads checkout information from a fare media using the second antenna, detects another vehicle present within a signal range of the first antenna, and provides the checkout information and at least a portion of the transit vehicle information to a primary validator positioned on the another vehicle for subsequent transmission to a transit system back office.

Abstract: Provide a system for automatically building a query statement for a database. The system includes an electronic processor. The electronic processor is configured to provide a user interface displayed by a display device and including a plurality of tabs. The electronic processor is also configured to provide a first list of a plurality of data fields included in the database. The electronic processor is configured to receive, via the user interface, a first selection of one of the plurality of data fields from the first list and a second selection of a criterion for one of the plurality of data fields from the first list. The electronic processor is configured to automatically build the query statement for the database. The electronic processor is further configured to execute the query statement on the database and output results of executing the query statement.

Abstract: A system and method for secure data communication between users when logged on to a central server through a network. The system permits subscribers to the system to create associations with non-subscribers which permits those non-subscribers to access the system to send and receive secure data communication to the subscriber that created the association with the non-subscriber.