Description
All issue transactions for the CSP enterprise can not be retrieved accurately for reporting issue totals. Cartesian product error found in data exported from Inquiries > Unit Issue Activity > ICNs Issued/Returned view. See attached for more details.
Recommended
Recommend a monthly data extract of the CSP enterprise issue transactions to be provided. This would include all individual and unit issue transactions that occurred within the month.
The following columns are required in this data set. See attached data dictionary for reference.
Region
Site
Warehouse
Transaction Type
Issue Number
NSN
Nomenclature
Unit Price
Condition Code
Serial Number
Lot Number
Contract Number
Expire Date
Maintenance Date
Maint Due Date
Calibration Date
Cal Due Date
Quantity
Date
Unit
UIC
User_ID
Comments
Mission Critical
Yes, this data is needed for monthly and ad-hoc reporting requirements, to help maintain inventory accuracy and assist the CSP Program Management Office personnel in operational decisions.
Benefits
Having this data will reduce time/cost by preventing users from having to complete multiple steps to get the information needed to fulfill monthly and ad-hoc reports, and also improves reporting accuracy by preventing users from manually manipulating large data sets to achieve the required results.
Users
All IIF/UIF
11 Mar 2021 – cancelled per Jack Sanders
No Longer Needed.
Disclaimer | Accessibility