Product Data Reporting and Evaluation Program: Retrieval Tools: Reports, Records and Data

Purpose: There are several tools available to the user to query the PDREP database for information. One of the tools available are standardized, PDREP reports. Depending on the user’s objectives, by using these standardized reports, the user will be able to locate information for a time period and easily contrast that information with another time period for process analysis. Some reports will display a tabulated chart of data while others will display a list of items matching certain criteria. PDREP also offers a powerful Ad-Hoc feature which allows users to create unique, user-defined reports on available records. The user selects which data elements will be includes in the report and may further place limits on those data elements with specific qualifiers, in order to select only records that fall within those parameters.

General Procedure: Due to varying requirements and available systems, only some of the documentation is created in PDREP. Other documentation is created in other systems and is loaded into PDREP, which then performs the function of data retention for these records. These report functions allow users to find the stored documents, records or tabulated statistical information regardless of the origination point.

Report Applications available to PDREP users include:

DLA Contractor Summary - Summary report listing CAGE Code, Survey, Lab Tests or Contract Alert Data records for a particular contractor, time frame, CAGE Code or FSC.

Feedback Status - Feedback records by Number, Title, Origination Date, and Status for time period and user/programmer selected.

MIR L1/SS Quarterly - Material Inspection Record (MIR) totals by DCMA for all Level I/Sub Safe Government Source Inspected MIRs inspected during the specified year and quarter. Users can choose to run a history, summary, or detail report by FY quarter.

MIR Report - MIRs by FSC, Contract Number, MIR Number, Inspection Date, Lot Size, Units Rejected, Lot Rejected Indicator, Government Source Inspection Indicator, Nuclear Material Indicator, PQDR Serial Number, and Defect Attributes, for selected CAGE Code and time period.

PQDR Statistics - Displays counts for Government Furnished Material, Non-Government Furnished Material and Total for open and closed PQDRs and breakout of closed and verified with actions complete PQDRs.

PQDR Summary - Displays a partial PQDR record. The following fields will be displayed: Report Control Number, Preparation Date, Originator, Screening Point, Action Point, Support Point, CAGE, Defect Attribute, Cause, Contract, National Stock Number, Part Number, Nomenclature, Serial Number, SYSCOM, Status, MIR Number, Responsibility, Quantity Deficient, Description of Deficiency and Investigation Results.

SDR Quarterly - Part 1 provides a tabulation of dollar value, quantity, and age of resolved/unresolved SDRs by selected FY quarter. Part 2 provides summary of SDRs by Discrepancy Code.