Failure Analysis

This table shows the Infor LN table from which fields are retrieved for the dimension:

Table	Description
qmpqm200	Failure Reporting Analysis and Corrective Action System

This table shows the attribute mapping to LN table fields for the dimension:

Attribute	Mapping
Cancel Reason	qmpqm200.cnrs
Company	qmpqm200.compnr
E-Item Revision	qmpqm200.revn
Effectivity Unit	qmpqm200.effn
Fracas Number	qmpqm200.frac
Failure Type	qmpqm200.ftyp
Failure Type Filter	qmpqm200.ftyp
Failure Type Sort	qmpqm200.ftyp
Failure Analysis	qmpqm200.frac
Desc	qmpqm200.dsca
Failure Category	qmpqm200.frct
Failure Category Desc	qmptc021.dsca
Failure Code	qmpqm200.frcd
Failure Code Desc	qmpqm022.dsca
Failure Reported Date	qmpqm200.frpd
Failure Solved Date	qmpqm200.fsld
Failure Stage	qmpqm200.frst
Failure Stage Desc	qmpqm020.dsca
Instrument	qmpqm200.inst
Instrument Desc	qmptc008.dsca
Instrument Group	qmpqm200.intg
Instrument Group Desc	qmptc024.dsca
Instrument Number	qmpqm200.inno
Line Type	qmpqm200.styp
Line Type Filter	qmpqm200.styp
Line Type Sort	qmpqm200.styp
Operation	qmpqm200.opno
Order Number	qmpqm200.orno
Parent Fracas Line	qmpqm200.ifln
Parent Fracas Number	qmpqm200.ifcr
Position	qmpqm200.pono
Production Item	qmpqm200.pitm
Production Lot Number	qmpqm200.plot
Production Serial Number	qmpqm200.pser
Repeated Failure	qmpqm200.rptd
Repeated Failure Filter	qmpqm200.rptd
Repeated Failure Sort	qmpqm200rptd
Reported Lot	qmpqm200.clot
Reported Serial	qmpqm200.cser
Reported at Supplier or Subcontractor	qmpqm200.rpas
Reported at Supplier or Subcontractor Filter	qmpqm200.rpas
Reported at Supplier or Subcontractor Sort	qmpqm200rpas
Sequence	qmpqm200.seqn
Specify Other	qmpqm200.othr
Status	qmpqm200.stat
Status Filter	qmpqm200.stat
Status Sort	qmpqm200.stat
Team	qmpqm200.mrbc
Unknown	1 for null records, else 0
deleted	1 if deleted in LN, else 0
Customer Defined Fields	Standard list of fields