Entity Definition

Logical Name : EquipmentStatisticsReading
Physical Name : DO_RDG_EQ_STCS

A set of performance statistics that have been taken from a piece of Equipment 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 Equipment(AS_EQ)
TimeStamp (PK) The date and time that the EquipmentStatisticsReading was made. TS_RDG AuditDateTime datetime
ReadingTypeCode An alpha-numeric code denoting the type of Equipment statistics that is being recorded. TY_RDG Code4 char(4)
UnifiedPOSVersion The version of the Unified-POS specification supported by the Equipment at the time the StatisticsReading was taken. ID_VN_UPOS Name varchar(40)
DeviceCategory A code denoting the Unified-POS defined device category that this Equipment falls into. CD_DVC_CTGY Code6 char(6)
ManufacturerName The name of the Manufacturer, as reported by the Equipment in the EquipmentStatisticsReading. NM_MF Name varchar(40)
ModelName The name of the Manufacturer Model, as reported by the Equipment in the EquipmentStatisticsReading. NM_MDL Name varchar(40)
SerialNumber The Manufacturer assigned SerialNumber for this Equipment. ID_SRL_NUM IdentityAlphaNumeric varchar(20)
ManufactureDate The date the device was manufactured. DC_MF DateCalendar date
MechanicalRevision Device sub-version number identifying the revision of hardware that is being used. NM_RV_MCH Name varchar(40)
FirmwareRevision Device sub-version number identifying the revision of firware that is being used. NM_RVN_FWRE Name varchar(40)
Interface Device hardware interface (e.g. Serial, USB, etc...) NM_INFC Name varchar(40)
InstallationDate The date the device records as it's installation date. DC_INSTL DateCalendar date
HoursPoweredCount The number of hours the device has been turned on. QU_CNT_HRS_PWRD QuantityShortCount decimal(3,0)
CommunicationsErrorCount Number of communications errors the device has recorded. QU_CNT_CMN_ERR QuantityShortCount decimal(3,0)


Parent Entity Verb Phrase Child Entity
Equipment provides EquipmentStatisticsReading
EquipmentStatisticsReading can be a CashDrawerEquipmentStatisticsReading
EquipmentStatisticsReading can be a MotionSensorEquipmentStatisticsReading
EquipmentStatisticsReading can be a FiscalPrinterEquipmentStatisticsReading
EquipmentStatisticsReading can be a POSPrinterEquipmentStatisticsReading
EquipmentStatisticsReading can be a MSREquipmentStatisticsReading
EquipmentStatisticsReading can be a SignatureEquipmentCaptureStatisticsReading
EquipmentStatisticsReading can be a PINPadEquipmentStatisticsReading
EquipmentStatisticsReading can be a ToneIndicatorEquipmentStatisticsReading
EquipmentStatisticsReading can be a BumpBarEquipmentStatisticsReading
EquipmentStatisticsReading can be a POSKeyboardEquipmentStatisticsReading
EquipmentStatisticsReading can be a ScaleEquipmentStatisticsReading
EquipmentStatisticsReading can be a MICREquipmentStatisticsReading
EquipmentStatisticsReading can be a ScannerEquipmentStatisticsReading
EquipmentStatisticsReading can be a KeyLockEquipmentStatisticsReading
EquipmentStatisticsReading can be a LineDisplayEquipmentStatisticsReading

Logical Views containing EquipmentStatisticsReading

Logical View
Logical 06400 - Store Equipment View
Logical 20050 - Forecourt Tank Gauge View