Entity Definition

Logical Name : OperatorBusinessUnitAssignment
Physical Name : CO_ASGMT_OPR_LCN

A permanent or temporary assignment of an OperatorID to a particular BusinessUnit, allowing Workers using the nominated OpertorID access to the IT systems used by the retail enterprise, at the nominated BusinessUnit; includes an OperatorNumber which (in combination with BusinessUnitID acts as an alternate key.

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
OperatorID (FK)(PK) A unique, automatically assigned number used to identify a workstation OPERATOR. ID_OPR Identity integer Operator(PA_OPR)
BusinessUnitID (FK)(PK) A unique retailer assigned identifier for an RetailStore, DistributionCenter or AdministrationCenter ID_BSN_UN Identity integer BusinessUnit(LO_BSN_UN)
EffectiveDateTime (PK) The date & time from which the assignment is valid. TS_EF EffectiveDateTime datetime
ExpirationDateTime The date & time until which the assignment is valid. TS_EP ExpirationDateTime datetime
OperatorNumber A locally unique identifier for the Operator while they are assigned to the nominated BusinessUnit. NU_OPR Identity integer


Parent Entity Verb Phrase Child Entity
Operator is assigned to OperatorBusinessUnitAssignment
BusinessUnit is assigned OperatorBusinessUnitAssignment

Logical Views containing OperatorBusinessUnitAssignment

Logical View
Logical 06210 - Access Control - Rules View
Logical 10120 - Enterprise - Location, WkStn, Operator, Till
Logical 11130 - Worker - Access Control View
Logical 11130 - Worker - Access Control View