Aegis
Standard Report
Contents
Introduction ... 3
Quality and Test Reports ... 4
NPI Reports ... 13
Production & WIP Tracking Reports ... 18
System Administration Reports ... 23
Material and Traceability ... 25
Introduction
This document illustrates report and chart examples that are available from Aegis’ standard report templates. The templates are available for new and existing customers, as they may be directly imported into the Data Miner.
Each section includes a summary of the report content and its related data source(s). It also identifies ‘runtime parameters’, which is data criteria the end-user supplies to narrow down the data return and focus of the report or chart.
Aegis Standard Report Examples
Quality and Test Reports
First Pass Yield by Job
Description:
This report details the first pass yield at each operation for a given job/work order, and is grouped by customer, assembly, and job. Data Source: Yield
Runtime Parameter: Job(s)
First Pass Yield by Job with Defects
Defect Drill Down Report
Description:
This report details the first pass yield at each operation, and is grouped by job/work order and operation. Data Source: Joined Quality & Yield Runtime Parameter: Job(s)
Description: This Pareto chart returns the defect quantity for a specific time period grouped by defect code with the ability to drill down to the following levels in this order: assembly number, individual serial number, reference designator, and pin number. Data Source: Quality
Runtime Parameter: Time
Operator Defect Report by Time
DPMO 7912 Report by Job
Description:
This report returns the total number of defects an operator has logged for a given time period and is grouped by job/work order. Data Source: Quality Runtime Parameter: Job(s) Description:
This report returns the calculated DPMO per IPC 7912 (end-unit DPMO, and based only on completed units) for a given time period and is grouped by customer and assembly number. Data Source:
DPMO (IPC-7912) Runtime Parameter: Time
In-Process DPMO by Time
Description:
This report details the in-process DPMO value for each operation for a given time period and is grouped by job/work order. Data Source: DPMO (In-Process) Runtime Parameter: Time
Time Based Defect Report by Assembly
Description:
This report returns a Pareto chart with defects grouped by inspection codes on page 1, and details the defect data on
subsequent pages grouped by assembly for a given time period. Data Source:
Quality
Runtime Parameter: Time
Top 5 Defects by Cost
Top 5 Defects by Station Chart
Description:
This chart details the cost of quality for the top 5 inspection codes. A currency value may be related to each inspection code in order to yield these results. Data Source: Quality Runtime Parameter: None Description:
This chart details the top 5 inspection codes logged at a given operation point for a given time.
Data Source: Quality
Runtime Parameter: Operation and Time
Daily Yield this Month Chart
Technicians Log Report
Description: This two-pane chart details first pass yield percentage in the top pane and the unit count in the bottom pane for each day of the current month. Data Source: Yield
Runtime Parameter: None
Description:
This report returns the defect counts grouped by defect code for a given symptom to identify the most common defects for a given failure.
Data Source: Quality
Runtime Parameter: Assembly and Symptom (failure code).
Measured Value Report
Station Defect Report by Time
Description:
This report returns the measured data for a given serial number, operation point and measured data type and is grouped by serial number.
Data Source:
Test and Measurement Runtime Parameter: Serial Number, Operation and Measurement Name (test name). Description:
This report details the total defects by defect status for a given time and is grouped by operation point. Data Source: Quality Runtime Parameter: Time
Time Based Defect Report by Job
Description:
This report returns a Pareto chart with defects grouped by defect codes on page 1 and then details the defect data on subsequent pages grouped by defect code for a given job/work order.
Data Source: Quality
Runtime Parameter: Job(s)/Work Order(s)
NPI Reports
BOM Report by Assembly and Revision
Description:
This report returns the BOM line items for an assembly revision, listing the part number, description, quantity, and consolidated reference designators. Data Source: CAD-BOM Runtime Parameter: Assembly and Assembly (BOM) Revision
Bill of Materials by Side
Description:
This report returns the BOM line items for an assembly process revision, listing the part number, flattened reference designators, and description, and is grouped by assembly side. Data Source: CAD-BOM Runtime Parameter: Assembly (BOM) Revision and Process Revision
CAD Report by Process Revision
Factory Routing
Description: This report returns each reference location with part number, description, component package, polarity, x, y, rotation, assembly side, and operation points. Data Source: CAD-BOM
Runtime Parameter: Assembly (BOM) Revision and Process Revision
Description:
This report details the factory operation points in ascending sequence and lists the assembly side performed at that operation, if the data is filtered from another operation point, and the name of the line. Data Source:
Factory Model (product route/traveler)
Runtime Parameter: Factory Model(s)
Revision Signoff Status
Part Relationship by Internal Part Number
Description: This report details assembly (BOM) revisions, process revisions, and production ready assemblies that are ready for review and sign off and the user assigned to the signoff, and is grouped by assembly and signoff type. Data Source: Revision Sign-Off Runtime Parameter: None Description:
This report returns the customer part number, vendor part number, and manufacturer part number as they relate to the internal part number.
Data Source: Part Relationships Runtime Parameter: Part Number (Internal)
Deviation Report
Description:
This report returns the deviation name, date created, description, effective date, expiration date, and originator, and is grouped by deviation type and job/work order.
Data Source: Deviations
Runtime Parameter: Deviation Type (Any, Job, Process Revision, Part Number, Unit Serial Number, or Operation)
Production & WIP Tracking Reports
Job Status Report
Routing Certificate of Conformance
Description:
This report returns the product route history of a serial number through the operation points where WIP transactions were performed, and is grouped by serial number. Data Source: WIP Runtime Parameter: Serial Number(s) Description:
This report returns the details of all the jobs/work orders with their current status, and is grouped by customer and assembly. Data Source: Job Status Runtime Parameter: Time
Operator Activity Detail Report
Ready to Ship Report by Job
Description:
This report details all serial numbers processed by each operator, and is grouped by job/work order and operator. Data Source: WIP
Runtime Parameter: Job(s)/Work Order(s)
Description:
This report returns the quantity of assemblies that have successfully passed their last operation tracking point and is grouped by customer. Data Source: Ready to Ship Runtime Parameter: Job(s)/Work Order(s)
Sub-Assembly Relationships (Genealogy)
WIP Report by Serial Number
Description:
This report details the sub-assembly
relationship with each sub-assembly
name/number, revision, and serial number, and is grouped by job/work order. Data Source: WIP Runtime Parameter: Job(s)/Work Order(s) Description:
This report details the completion status of a serial number through each operation point. Data Source: WIP
Runtime Parameter: Serial Number(s)
Time Delta Report and Chart by Job
Description:
This report returns a report and separate chart (below) that details the difference between the estimated processing time and the actual time at an operation point for a given job/work order. Data Source: WIP
Runtime Parameter: Job(s)/Work Order(s)
WIP Report by Job
Completed Routing Steps by SN
Description:
This report details the date/time and last operation point for each serial number in a given job/work order. Data Source: Active WIP
Runtime Parameter: Job(s)/Work Order(s)
Description: This report details which operations a given serial number has completed, listing the operator, time started, and time completed. Data Source: WIP
Runtime Parameter: Job(s)/Work Order(s)
System Administration Reports
Operator Audit Log
Rights Report by User
Description:
This report details user information and what roles and rights have been enabled for them. Data Source:
User Detail
Runtime Parameter: User(s)
Description: This report details scanning errors that a user encountered while performing actions in the material verification system and is displayed with one user per page. Data Source:
Audit Log
Runtime Parameter: Time
Rights Report by User and Group
Description:
This report details user information and what roles and rights have been enabled for them, including any group roles and rights that supplement their privileges. Data Source: User Detail and User Group Detail
Runtime Parameter: User(s) and Group(s)
Material and Traceability
Kitting Shortage Report
Kitted Materials Report
Description:
This report details the materials that has been kitted to a given job. Data Source: Kitted Material Runtime Parameter: Job(s)/Work Order(s) Description:
This report returns a kit shortage quantity by comparing the material required and the available material in inventory for a given job/work order. Data Source:
Kit Requirements and Kit Material
Runtime Parameter: Job(s)/Work Order(s)
Installed Components Recall Report
Tooling Service Life Report
Description:
This report lists all the serial numbers that contain a given part and its lot number. Data Source: Installed Component Record Runtime Parameter: Lot Number Description:
This report details the total, used, and remaining service life for a given tool, grouped by tool type. Data Source: Tooling Inventory Report
Runtime Parameter: Item Types
Traceability by Serial Number Report
Description:
This report returns the customer name, assembly number, assembly revision, installed internal part numbers, related manufacturer part numbers to each internal part number, lot codes of the manufacture part numbers, operator, and operation point where the material was installed for a given serial number. Data Source: Installed Component Record
Runtime Parameter: Unit Serial Number
Production Machines
Machine Utilization
Wave Solder History
Description: This report lists the conditions for a wave solder machine for each serial number processed for a given assembly and job/work order. Data Source: Wave Solder Runtime Parameter: Assembly and Job/Work Order Description:
This report details the amount of time (in seconds) that a machine or operation existed in a given state/condition for a specified time period. Data Source: Utilization
Runtime Parameter: Time
