PeopleSoft Enterprise Engineering Reports

Appendix: PeopleSoft Enterprise Engineering Reports

PeopleSoft Enterprise applications offer a wide range of query and reporting possibilities. In addition to the standard reports that we deliver, we also provide reporting tools that you can use to create new reports.

This appendix provides an overview of PeopleSoft Enterprise Engineering reports and enables you to:

View summary tables of all reports.
View report details.
View standard financial reports.

Note. For samples of these and other reports in your application, see the PDF files published on CD-ROM with your documentation (for online users) or PeopleSoft 8 (SP2) Reporting Tools (for hard-copy users).

PeopleSoft Enterprise Engineering Standard Reports: General Description

This table lists the PeopleSoft Enterprise Engineering reports, sorted alphanumerically by report ID. The reports listed are all Structured Query Reports (SQRs). If you need more information about a report, refer to the report details at the end of this appendix.

Report ID and Report Name	Description	Navigation	Run Control Page
EGS1000 ECO Report	Lists ECO information for an item or range of items for a specific business unit for a specific date or range of dates. Includes department, classification, ECO status, priority, and the name of the requestor. Can be sorted by classification and ECO number; ECO number; item, schedule date, and priority; priority, schedule date, and ECO number; schedule date, priority, and ECO number; or status, schedule date, and ECO number.	Engineering, Engineering Changes, ECO Report, ECO Report	EG_ECO_REPORT
ENS1000 BOM Report	Lists the components on either manufacturing or engineering BOMs.	Engineering, BOMs and Revisions, Reports, Bills of Material, EBOM Report	EN_BOM_REPORT
ENS1001 Routing Report	Lists the routing information for both PeopleSoft Enterprise Manufacturing and PeopleSoft Enterprise Engineering routings.	Engineering, Routings, Engineering Routing Report, Routing Report	RUN_ENS1001
ENS1002 Compare Routings Report	Lists the differences between two manufacturing routings, two engineering routings, or one manufacturing routing and one engineering routing. Comparisons can also be based on the same item with different routing codes.	Engineering, Routings, Eng Routing Comparison Report, Routing Compare Report	RUN_ENS1002
ENS1003 Master Routing Where Used Report	Lists all items that reference another item as its master routing along with production data. This report is used in both PeopleSoft Enterprise Manufacturing and PeopleSoft Enterprise Engineering.	Engineering, Routings, Eng Master Rtg Where Used Rpt, Master Rtg Where Used Report	RUN_ENS1003
ENS1005 Compare BOMs Report	Lists the differences between a manufacturing and an engineering BOM, or two engineering BOMs.	Engineering, BOMs and Revisions, Reports, EBOM Comparison, EBOM Compare Report Engineering, BOMs and Revisions, Reports, EBOM Comparison, EBOM Compare Report, Print Options	EN_BOM_COMP_REPORT
ENS1010 BOM Cost Report	Lists the component costs on either manufacturing or engineering BOMs.	Engineering, BOMs and Revisions, Reports, EBOM Costed, EBOM Costed Report	EN_BOM_COST_REPORT
ENS2000 Item Where Used Report	Lists all the BOMs on which an item appears either as a component or a substitute for a component. You’ll find this information useful when you want to analyze the impact that component changes can have on all existing BOMs.	Engineering, BOMs and Revisions, Reports, Item Where Used	EN_WHEREUSED_RPT

PeopleSoft Enterprise Engineering Reports: A to Z

This section provides detailed information about fields for the individual reports in PeopleSoft Enterprise Engineering. The reports are listed alphanumerically by report ID.

EGS1000 - ECO Report

Status

Select a status. The status indicates where the ECO is in the approval process. You can route notification to the appropriate role user specified for the given workflow step, using workflow virtual approval processing, if enabled. You can print a report for ECOs with these statuses:

Approved: The ECO can be routed to the next appropriate user as defined within the approval rule set associated with the ECO type.
Canceled: Workflow notification can be routed back to the previous role user who submitted the ECO or approved the previous activity.
Converted: The ECO was converted from an ECR by the system.

The ECR number is referenced on the report.
Denied: Workflow notification can be routed back to the previous role user who submitted the ECO or approved the previous activity.
Pending: If you select this status, you can enter and save Notes text, but no workflow is sent by the system.

Sort Options

Select how you want the report to be sorted. Values are:

Classification, ECO Number
ECO Number
Item, Sched Date (schedule date), Priority
Priority, Sched Date, ECO Number
Sched Date, Priority, ECO Number
Status, Sched Date, ECO Number

ENS1000 - BOM Report

Print Options

These options denote detailed information that you may want to appear on the hard-copy report. You can select all attributes of the BOM or selected attributes. Attributes include:

Substitutes: Substitute items for the BOM components, if any exist.
Lower Level Outputs: Primary, co-product, and by-product items at lower levels of the BOM.
Component Dimensions: Actual dimensions of the component, such as height, length, width, and weight.
Reference Designators: The alphanumeric code that you can use to determine where a component is placed in an assembly.
Component Text: Any text associated with the BOM components.
Component Attachments: The names of any associated assembly attachments.
Component Documents: The names of any associated assembly documents.

Note. The names of component documents print only if PeopleSoft Enterprise Engineering is installed.
Assembly Text: Any text associated with the assembly.
Assembly Attachments: Names of any attachments (files) such as CAD drawings or product specifications.
Assembly Documents: Names of any associated documents used during assembly, such as CAD drawings or product specifications.

Note. The names of any assembly documents print only if PeopleSoft Enterprise Engineering is installed.

ENS1001 - Routing Report

Print Options

These options denote detailed information that you may want to appear on the report. You can select all or selected attributes to print, such as:

Header Documents: Any text associated with the routing header information.
Header Attachments: Any attachments (files) associated with the routing header information.
Operation Resources: Resources that are being used at the operation step.
Operation Time: The times necessary to complete this operation.

This may include tasks and run rates such as fixed run, post production, run, and setup times.
Conversion Code: Cost codes that determine the labor, machine, outside processing, and overhead cost of the operation.
Operation Documents: Lists the names of any documents associated with the operation, such as CAD drawings or product specifications.
Operation Attachments: Lists the names of routing operation attachments.

ENS1002 - Compare Routings Report

You use this report to compare baseline and target routing information.

Baseline Routing (RTG1):

Select a routing state. Values are: Engineering or Manufacturing.

Select an item ID range and a valid routing code.

Target Routing (RTG2):

Engineering appears by default as the routing state; it is a display-only field.

Select an item ID and a valid routing code.

To compare one routing code to another (for example, the primary routing to one of the item's alternates), enter the primary routing code (1) as the from and to routing for the Baseline Routing (RTG1). Then enter as the Target Routing (RTG2) the alternate routing code to which you want to compare the primary.

To see if any of an item's routings are comparable to another item's routing, enter the baseline routing codes (1 to 99 to compare the primary and all alternates) and the target's routing code to which all routings will be compared.

Print Options

These options denote detailed information that you may want to appear on the report. You can select all of the listed attributes, or selected attributes. Attributes include:

Header Detail: Information such as routing type, routing code, and routing state is printed on the report.
Header Documents: Any documents associated with the routing header information.
Header Attachments: Any attachments (files) associated with the routing header information.
Ops Sequence (operation sequence): The operation step that components or tasks may be added.
Subcontractor Detail: If the operation step is a subcontracted operation, the vendor information is printed on the report.
Operation Text: Any text associated with the operation step.
Conversion Code: Cost codes that determine the labor, machine, outside processing, and overhead cost of the operation.
Operation Resources: Resources that are being used at the operation step.
Operation Time: The times necessary to complete this operation.

This may include tasks and run rates such as fixed run, post production, run, and setup times.
Operation Documents: Lists the names of any documents associated with the operation, such as CAD drawings or product specifications.

Note. The Operation Documents print option is available only if you have PeopleSoft Enterprise Engineering installed.
Operation Attachments: Lists the names of routing operation attachments.

ENS1003 - Master Routing Where Used Report

Print Production Details

Select this check box if you want to print production information for all dates or a range of dates. The report includes all production whose start date falls within the criteria selected.

Status Selection

You can include production by selecting any of these statuses:

Entered
Firmed
Released
In Process
Pend Complete (pending complete)
Complete
Clsd Labor (closed to labor)
Clsd Acctg (closed to accounting)
Canceled

ENS1005 - Compare BOMs Report

Use the Compare BOM Report to compare any two engineering BOMs or a manufacturing BOM and an engineering BOM within the same business unit. Using this report, you can compare one or more baseline BOMs to one target BOM. In the Baseline BOM (BOM1) group box, specify the item ID BOM that serves as the basis for comparison. The baseline BOM may have an engineering or manufacturing BOM state. The item ID that you specify in the Target BOM (BOM2) group box is the BOM that you are comparing with the baseline BOM (BOM1). The target BOM has an engineering BOM state.

Differences

This field behaves the same way for all pages in this group. It displays the differences between the two BOMs. Values are:

Added: The component ID has been added to the compare BOM (BOM2).
Deleted: The component has been deleted from the compare BOM (BOM2).

The system determines whether a component has been deleted, by comparing the component IDs, operation sequences, and effectivity dates; this is what makes a component unique within a BOM.
Chg BOM1: If you have made a component change, you see the components listed.

The system lists a change when any information other than component ID, operation sequence, or effective date has changed.
Chg BOM2: If you have made a component change, you see the components listed.

The system lists a change when any information other than component ID, operation sequence, or effective date has changed.

The report includes component and assembly differences between the two BOMs so that you can use it to track changes.

Baseline BOM (BOM1):

Select the BOM state. Values are: Engineering or Manufacturing.

Select an item ID and a valid BOM code from the available options.

To use the BOM with a code of 1, select 1 in both fields. You can also compare all the existing BOMs for the item to the target routing by selecting the appropriate BOM codes.

Select the All Dates/Revs check box to compare all effective dates and revisions for the baseline BOMs. To compare a BOM with a specific effective date, clear the All Dates/Revs check box, and enter the specific effective date.

Target BOM (BOM2):

Engineering appears by default as the BOM state; it is display-only.

Select an item ID and a valid BOM code for the target BOM.

Select the All Dates/Revs check box to compare all effective dates and revisions for the BOM. To compare a BOM with a specific effective date, enter the specific effective date.

Print Options

These options denote detailed information that you may want to appear on the hard-copy report. You can select all attributes of the BOM or selected attributes. Attributes include:

Component Documents: The names of any associated assembly documents.

Note. The names of component documents prints only if PeopleSoft Enterprise Engineering is installed.
Component Attachments: The names of any associated assembly attachments.
Component Text: Any text associated with the BOM components.
Reference Designators: The alphanumeric code that you can use to determine where a component is placed in an assembly.
Substitutes: Substitute items for the BOM components, if any exist.
Component Dimensions: Actual dimensions of the component, such as height, length, width, and weight.
Top Level Outputs: Parent assembly items only.
Assembly Header: Any text associated with the assembly.
Assembly Documents: Names of any associated documents used during assembly, such as CAD drawings or product specifications.

Note. The names of any assembly documents print only if PeopleSoft Engineering is installed.
Assembly Attachments: Names of any attachments (files), such as CAD drawings or product specifications.

ENS1010 - BOM Cost Report

Cost as Batch	Select this check box if the BOM has multiple outputs.
Print Lower Level Outputs	Select this check box if you want the hard-copy report to include the costs of multiple output items for components that are end items.

ENS2000 - Item Where Used Report

You can select all or a range of components, substitutes, or outputs, if any exist for the component. If you select Components, the system searches to see if the items are specified as a component on a BOM. If you select Substitutes, the system searches to see if the item is a substitute item on a BOM. If you select All, the system checks to see if the item is a component or a substitute.

Select the All Dates/Revs check box to search all effective dates and revisions for the BOM. To search for components or substitutes effective on a specific date, enter an effective date.

Set Levels Up to 1, to view only the component’s parent assembly. The larger the number, the higher the level. For example, level 3 is three levels higher in the bill of material structure than the component.