The following logs and reports are available to help track and manage PDM activities.
A description of each is provided below.
The Parameter Group Log report (filtered to parameter groups) and the Parameter Log report (filtered to individual parameters) provide capabilities to track parameter result data, including all changes, from the Pre-staging table through Essential database population. Each record is assigned a Transaction Type that describes a PDM event, such as "Imported from Pre-staging", "Modified by Rule", or "Staging Value Edited". Transactions are displayed as line items in the log. The data available for review includes:
Record Timestamps/States
Transaction Types
Email Notification Recipients
Override ID/Approver ID
Parameter Group/Level/Material
Process Unit
Values/Unit of Measure
Text Value/Override Comment
Invalid/Missing/BDL Values
Substituted Values (If multiple rules were applied, all substitutions performed are included.)
Pre-staging Data Origin
Rule Name
Batch ID (the last line item column)
Many Date and Transaction Type filters are available to help you locate a specific set of records for review. Details about the filters are provided below.
Log data can be filtered by the log timestamp (default), value date/time, batch start date/end date, or the batch import time. A user-defined start and end date can also be entered. Generic time period options, such as Today, Yesterday, and Last Quarter, are available for selection. The Start Date and End Date fields will be automatically completed based on the selection. For example, select Last Week and the previous week's Sunday date plus 12:00:00 AM (inclusive) are entered as the start date/time. The end date/time is the following Sunday's date and 12:00:00 AM (exclusive).
Note:
By default, log data is grouped by batch transaction. This option
can be cleared; however, it is recommended that a Start
Date and End Date be entered
before clearing the setting to maximize log performance. The Group
by Batch Transaction option is displayed in the report header section.
Log records can be filtered by Transaction Type on the batch level and/or the value level. Available filters are listed below. Results-related filters refer to parameter results in your Essential database. Review-related filters refer to the Staging table revalidation process. Options to Select All/Clear All filters are available.
Batch Level
Imported to Staging
Imported to Results
Revalidated from Review (Staging table revalidation process)
Revalidated from Results (Validation Parameter Results process)
Staging Values Edited
Notification
Attempted Notification (email address is missing)
Error
Value Level
Imported from Pre-staging
Rule (comments)
Modified by Rule
Staging Value Edited
Revalidated Value from Review (Staging table revalidation process)
Revalidated Value from Results (Validation Parameter Results process)
Imported Value to Results
Import to Results Failed
Value Set to Missing
Value Error
A Log Record Count is displayed below the Transaction Type Filters section. When a filter is added or removed, the record count is automatically updated. Log data can be exported to Excel.
The log is automatically updated when a filter is added or removed.
Collapse the filter sections to view additional log rows as an alternative to using the vertical scroll bar. Click a section header to collapse/expand the section.
Resize column widths by dragging the column boundaries in the heading row of the log.
Move columns by dragging a column heading to the new location.
For the Parameter Group Log, select a record to view additional parameter information, when available, in a separate window. Press the Ctrl key and click anywhere in the window to close the window.
To generate a parameter
group log
Use one of the following methods to access the Parameter Group Log report:
Click the View Log button in the Parameter Group Batch Details section on the Parameter Group Import Review form.
Click Reports > PDM Reports > Parameter Group Log Report and click a parameter group link to open the log.
Review the data displayed for the group. Refer to Log Navigation Tips for additional information when necessary.
Use the Date Filters and Transaction Type Filters to view a specific set of data. Use the following guidelines to enter dates:
Type a different date or click the Calendar button to select a date.
Type a new time, as well as AM/PM designation when applicable, or click the Clock button to select a different time. Alternately, you can place your cursor before a number and click the up/down arrows to change that number.
Select a period of time by clicking one of the available options. The Start Date and End Date fields will be automatically completed based on the selection. For example, click Last Week and the previous week's Sunday date plus 12:00:00 AM (inclusive) are entered as the start date/time. The end date/time is the following Sunday's date and 12:00:00 AM (exclusive).
Click the Export button in the report header section to export the log data to Excel.
To generate a parameter
log
Click Reports > PDM Reports > Parameter Log Report and click a parameter link to open the log.
Review the data displayed for the parameter. Refer to Log Navigation Tips for additional information when applicable.
Use the Date Filters and Transaction Type Filters to view a specific set of data.
Type a different date or click the Calendar button to select a date.
Type a new time, as well as AM/PM designation when applicable, or click the Clock button to select a different time. Alternately, you can place your cursor before a number and click the up/down arrows to change that number.
Select a period of time by clicking one of the available options. The Start Date and End Date fields will be automatically completed based on the selection. For example, click Last Week and the previous week's Sunday date plus 12:00:00 AM (inclusive) are entered as the start date/time. The end date/time is the following Sunday's date and 12:00:00 AM (exclusive).
Click the Export button in the report header section to export the log data to Excel.
Review for data import interruptions on the Parameter Group History Gap browse view. The date and time of the previous import and the next import are available to help determine if import data is missing. The parameter group link provides access to the Parameter Group Import Review form.
Click Reports > PDM Reports > Parameter Group Import History Gap to access the browse view. Standard Essential search options are available.
Log Navigation Tips