system. Some of the responsibilities of the FSA are as
Control access to the computer system by
assigning user IDs and, if necessary, removing user IDs
Ensure database backups are performed.
Restore the FOSAMS data base when files are
damaged or lost.
Ensure required reports from the computer
system (especially ammunition transaction reports) are
forwarded to the communications center in a timely
manner for transmitting.
Serves as the principal point-of-contact in
communications with the FOSAMS Program
management office and the FOSAMS trouble desk for
Ensure new software and/or operating system
updates provided by the PMO are installed on the local
The FOSAMS generates various reports to aid in
the management of ammunition. There are three basic
report categoriesdaily transaction reports, monthly
reports, and general reports.
The following reports are part of the daily functions.
Application and various inquiries of the data base can
be made in the inquiry subsystem.
DAILY TRANSACTION REPORT. This
report will list all transactions processed that day and
should be run every workday.
AGED VERIFICATION REPORT. This report
lists transactions from receipt and asset maintenance
that have not been verified by scanning. If the record is
between 5 and 9 days old, it is printed on the report.
Aged Scanner Work File. For each record of the
scanner work file, the transaction date is compared to
the system date. If the record is between 5 and 9 days
old, it is printed on the report. If the record is 10 days
old or older, it is printed on the report with an indication
that the record has been deleted from the scanner work
file. Scanner work records are obtained from receipt,
issue, asset maintenance, inventory, and restow
Aged Temporary Stow Record. Each activity
assigns a specific number of days in which material can
be temporarily stowed at another activity. The number
of days assigned are added to the date of the temporary
stow, and a list is printed for each record that is within
10 days of the system date, or older than the system date.
The report is printed each day until the temporary stow
indicator is removed, or the item is issued.
The monthly reports should be run at the beginning
of every month (or as often as needed).
AGED NAR REPORT. The Notice of
Ammunition Reclassification (NAR) history file is
searched for all records that do not have a date entered
in the NAR completion date field. A listing is provided
for all lots with the specific NAR number with a
transaction date more than 2 days older than the current
MASTER LOT ASSET DISCREPANCY
REPORT. This report is produced after various
checks of data base quantities to assure data integrity.
INVENTORY ADJUSTMENT REPORT. This
report lists inventory adjustments and adjustment
reversals by ATR Source code and extended dollar value
of the adjustment. The report provides the Physical
Security code. Information from this report is used to
prepare the Physical Inventory report section of the
DOD Inventory Control Effectiveness Report and to
determine if there is a requirement to prepare a missing,
lost or stolen report.
INVENTORY REMINDER REPORT. This
report lists assets that are required to be inventoried
within the next 30 days. A requirement for annual or
semiannual inventory is based on the Security Risk Code
of the item. The date of last inventory of each National
Item Identification Number in the master asset file is
compared to the current system date and the inventory
MAINTENANCE DUE DATE REMINDER
REPORT. Each record in the lot/serial asset file with
a maintenance due date that expires within the next 3
months is listed on this report.
The general reports are accessed through the inquiry
subsystem and should be printed/run as often as needed.
The FAA is working with its aviation security partners in...