Entity Definition

Logical Name : MICREquipmentStatisticsReading
Physical Name : DO_EQRDG_MICR

A set of performance statistics that have been taken from a Magnetic Ink Character Reader (MICR) connected to a Workstation.

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
EquipmentID (FK)(PK) The fixed asset number assigned by the retailer for this particular piece of equipment. ID_EQ Identity integer
TimeStamp (FK)(PK) The date and time that the EquipmentStatisticsReading was made. TS_RDG AuditDateTime datetime
GoodReadCount The number of successful MICR reads. QU_CNT_GD_RD QuantityShortCount decimal(3,0)
FailedReadCount The number of failed MICR reads. QU_CNT_FLD_RD QuantityShortCount decimal(3,0)
FailedDataParseCount The number of failed data parses. QU_CNT_FLD_PRSE_DTA QuantityShortCount decimal(3,0)


Parent Entity Verb Phrase Child Entity
EquipmentStatisticsReading can be a MICREquipmentStatisticsReading

Logical Views containing MICREquipmentStatisticsReading

Logical View
Logical 06400 - Store Equipment View