Key Performance Indicators - Intergraph Smart Materials - Version 2016 R4 (8.4.0) - Help - Hexagon PPM

Intergraph Smart Materials Classic Help (2016)

PPMProduct
Intergraph Smart Materials
PPMCategory_custom
Help
Version_SPMat
2016 R4 (8.4)

This report is only available if Mobile Scan is installed.

You can use this report to display the key performance indicators which were written into the m_kpi_event table by Smart Materials Mobile Scan. All events for material receiving reports, material transfer reports, physical inventory counts, and material issue reports are tracked in this event table.

  • This is an interactive report.

  • Click and select the column where you want to search, type the search criterion in the Search box, and click Go to apply the search.

  • To change the number of displayed rows, select a value from the Rows list.

Additionally, you can customize the report to meet your requirements, save the report, and download the result in csv or html format (see Use Actions menu).

Data Sources

The table below shows the Smart Materials screen(s) where the data is entered that is displayed in this report. Additionally, this table shows the synchronization table and the CIPs used by the report, and the name of the log file created by the sync job or the report.

Screen

Mobile Scan

Table

CIP

Log File

The following table shows all values displayed in the report, with the related Smart Materials screen and field where the value is displayed, the database table and column where the value is stored, and CIPs, functions, or procedures that are used to retrieve the value. Optionally, additional comment on the value is entered in the last column.

Value

Screen

Field

Database Column

Other Source/Comment

Project

Mobile Scan

Project

m_kpi_event.proj_id

Project from Mobile Scan

Document Type

Mobile Scan

n/a

m_kpi_event.pk_type

The source type of Mobile Scan (can be MRR, MTR, MTRO, MTRI, OITO, OITI, PickItem, MIR, PICS)

Document Number

Mobile Scan

n/a

Fetched from the corresponding source table based on

m_kpi_event.pk_type and m_kpi_event.pk_id

The corresponding document number based on the document type, For example, MRR number if the type is MRR.

Origin Document Type

Mobile Scan

n/a

m_kpi_event.sub_pk_type

Can be either IIS_ID, POH_ID,

RELN_ID, ITEM_SHIP_ID, or

PIC_ID

Origin Document Number

Mobile Scan

n/a

Fetched from the corresponding source table based on

m_kpi_event.sub_pk_type and

m_kpi_event.sub_pk_id

The corresponding document number based on the document type, For example, Agreement number if the type is POH_ID.

NULL for ITEM_SHIP_ID and PIC_ID as they do not have a straight forward number.

Origin

Mobile Scan

n/a

Can represent the details from the Origin based on the Origin Document Type:

  • Ident Code if sub_pk_type is IIS_ID,

  • Combination of Agreement Number + Pos + Sub Pos + IS Pos + IS Sub if sub_pk_type is ITEM_SHIP_ID,

  • NULL for POH_ID and RELN_ID as the Origin Document Number is sufficient,

  • Physical Count Sheet for PIC_ID.

Event

Mobile Scan

n/a

m_kpi_event.event

The action performed by Mobile Scan

Action

Mobile Scan

n/a

m_kpi_event.text

Additional details about the event

Scan Date

Mobile Scan

n/a

m_kpi_event.date_reported

The date the item was scanned by Mobile Scan