Entity Definition

Logical Name : WorkstationRuleApplication
Physical Name : CO_APLN_WS_RU

An association indicating applicability of a WorkstationRule to a Workstation.

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
WorkstationID (FK)(PK) The unique identifier for the WORKSTATION, typically the serial number. ID_WS Identity integer Workstation(AS_WS)
WorkstationRuleTypeCode (FK)(PK) A code that refers to a specific WORKSTATION RULE type. TY_RU_WS Code2 char(2) WorkstationRule(RU_WS)
WorkstationRuleNumber (FK)(PK) A reference number for a specific WORKSTATION RULE. ID_RU_WS Identity integer WorkstationRule(RU_WS)
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 WorkstationRule(RU_WS)
EffectiveDate The date on which a specific WORKSTATION RULE becomes effective. DC_APLN_EF EffectiveDateTime datetime
ExpirationDate The date on which a specific WORKSTATION RULE expires. DC_APLN_EP ExpirationDateTime datetime
CreateDateTimestamp The time and date on which a specific WORKSTATION RULE is created. TS_APLN_CRT AuditDateTime datetime


Parent Entity Verb Phrase Child Entity
Workstation is governed through WorkstationRuleApplication
WorkstationRule governs WorkstationRuleApplication
WorkstationRuleApplication is tracked by WorkstationRuleOverrideHistory

Logical Views containing WorkstationRuleApplication

Logical View
Logical 06210 - Access Control - Rules View
Logical 06220 - Access Control - Overrides View