Entity Definition

Logical Name : PINPadEquipmentStatisticsReading
Physical Name : DO_EQRDG_PPD

A set of performance statistics that have been taken from a Personal Identification Number Pad (PINPad) 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
ValidPINEntryCount The number of valid PIN entries. QU_CNT_VLD_PIN QuantityShortCount decimal(3,0)
InvalidPINEntryCount Number of invalid PIN entries. QU_CNT_INVLD_PIN QuantityShortCount decimal(3,0)


Parent Entity Verb Phrase Child Entity
EquipmentStatisticsReading can be a PINPadEquipmentStatisticsReading

Logical Views containing PINPadEquipmentStatisticsReading

Logical View
Logical 06400 - Store Equipment View