Entity Definition

Logical Name : WorkstationRuleOverrideHistory
Physical Name : LE_HST_WS_RU_OVRD

A transaction record of which WorkstationRules are overriden and by which Operator.

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
TransactionID (FK)(PK) A universally unique identifier (UUID) for the Transaction. This may be assembled from alternate key members. ID_TRN IdentityUUID char(32) Transaction(TR_TRN)
WorkstationID (FK)(PK) The unique identifier for the WORKSTATION, typically the serial number. ID_WS Identity integer WorkstationRuleApplication(CO_APLN_WS_RU)
WorkstationRuleTypeCode (FK)(PK) A code that refers to a specific WORKSTATION RULE type. TY_RU_WS Code2 char(2) WorkstationRuleApplication(CO_APLN_WS_RU)
WorkstationRuleNumber (FK)(PK) A reference number for a specific WORKSTATION RULE. ID_RU_WS Identity integer WorkstationRuleApplication(CO_APLN_WS_RU)
WorkstationGroupID (FK)(PK) A unique identifier for a group of WORKSTATIONs. This could refer to the WORKSTATIONs at the checkout, delicatessen, customer service or in the goods receiving area of the store. ID_GP_WS Identity integer WorkstationRuleApplication(CO_APLN_WS_RU)
OperatorID A unique, automatically assigned number used to identify a workstation OPERATOR. ID_OPR Identity integer
OverrideFlag A flag to signify that a certain limit has been overriden. FL_OVRD_WS_RU Flag integer


Parent Entity Verb Phrase Child Entity
Transaction audited by WorkstationRuleOverrideHistory
WorkstationRuleApplication is tracked by WorkstationRuleOverrideHistory

Logical Views containing WorkstationRuleOverrideHistory

Logical View
Logical 06220 - Access Control - Overrides View