Queries

The user may query all of the databases from one common interface without the concern of maintaining multiple accounts and passwords on several machines. In addition, the user does not have to navigate through each systems user interface, learn various command line parameters, and deal with slow screen response. Each query is entered on the screen at the user's personal computer and stored in a temporary file until "Submit" has been selected. The queries must be submitted prior to leaving the screen, otherwise, the data will be lost. When submit is selected, the queries will be sent to the LINK server. The transmitted queries will be queued and processed by the server. The server must queue queries for differing databases and attempts to give each client equal time against each database.

Databases

AFMC Tracker Air Force Material Command Tracker (AFMC-Tracker)
DSS Distribution Standard System
DAASC Defense Automatic Addressing System Center
GSA-MUFFIN General Services Administration Inquiry System
DRMS Defense Reutilization and Marketing Service
LIDB Army's Logistics Integrated Database
LIPS Logistics Information Processing System
LOGRUN Logistics Remote Users Network
SAMMS/BSM Standard Automated Materiel Management System/Business Systems Modernization
SmartLINK Smart Logistics Information NetworK
SNAPSHOT Navy’s Stock Inquiry System
THF Navy's Transaction History File
USAF SCS (D035) Air Force Stock Control System (D035)
USMC SCS Marine Corps' Stock Control System
VMSIR Virtual Master Stock Inventory Record
WPS Worldwide Port System

Queries and Auto Queries

Required This text area assists the user by stating what information is expected.
File Upload This brings the user to the batch upload (file selection) page and provides samples of required (type/format) data
Go to Record # This allows you to enter a particular record number to view or edit when multiple records have been entered.
Delete Items When selected, causes the current query entry to be deleted.
Delete All Items When selected, causes all of the queries entered to be deleted.
Previous When selected, lets you view the previously entered queries.
Next When selected, lets you enter another query.
Submit When selected, submits the queries to the server. The queries must be submitted prior to leaving the screen, otherwise, the data will be lost.
Auto Query Off The user may elect to have a query performed automatically on a daily (cyclic) basis. The start option must be selected in order for daily queries to be built. The Auto Query Off option is the default for each new record.
Start The start button must be selected to cause the query to be built as a daily query.
Days, Weeks, and Hour The user may choose which days of the week the queries are to be performed and the number of weeks to repeat the query. The user may also select the hour 00-23 (GMT) on which the query will be performed.
Stop The user selects the stop button to remove a specific query from the daily queries held on the LINK server. The user first enters their query, then selects the stop button. Then select Submit. This action will remove the query that was entered from the daily queries held on the LINK server.
Stop ALL Previous Selecting this button then submit causes all daily queries held on the LINK server to be removed which match the user's CLIENT and USER query parameters.
Back The user is returned to the previous screen. The user should select this button when all queries for the dialog have been entered and submitted. The queries must be submitted prior to leaving the screen, otherwise, the data will be lost.
Drop Down Lists The dropdown lists contain various options for user queries.
Validation Rules Each input field is validated for length and content (A-Z,0-9, etc).