Entity Definition

Logical Name : MSREquipmentStatisticsReading
Physical Name : DO_EQRDG_MSR

A set of performance statistics that have been taken from Magnetic Stripe Reader (MSR) 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 Number of successful reads. QU_CNT_GD_RD QuantityShortCount decimal(3,0)
FailedReadCount Number of failed reads. QU_CNT_FLD_RD QuantityShortCount decimal(3,0)
UnreadableCardCount Number of unreadable cards. QU_CNT_UNRDBLE_CRD QuantityShortCount decimal(3,0)


Parent Entity Verb Phrase Child Entity
EquipmentStatisticsReading can be a MSREquipmentStatisticsReading

Logical Views containing MSREquipmentStatisticsReading

Logical View
Logical 06400 - Store Equipment View