Entity Definition

Logical Name : WorkerOperatorAssignment
Physical Name : CO_ASGMT_WRKR_OPR

A permanent or temporary assignment of a Worker to a particular OperatorID, allowing the Worker access to the IT systems used by the retail enterprise.

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
WorkerID (FK)(PK) A unique system-assigned identifier for the Person who is a particular Worker. ID_WRKR Identity integer Worker(PA_WRKR)
OperatorID (FK)(PK) A unique, automatically assigned number used to identify a workstation OPERATOR. ID_OPR Identity integer Operator(PA_OPR)
EffectiveDateTime (PK) The starting date and time from which the Worker to OperatorID assignment is effective TS_EF EffectiveDateTime datetime
ExpirationDateTime The ending date and time after which the Worker to OperatorID assignment is no longer effective TS_EP ExpirationDateTime datetime
StatusCode A two character retailer assigned code denoting the current status of the WorkerOperatorAssignment. SC_ASGMT Code2 char(2)


Parent Entity Verb Phrase Child Entity
Operator is assigned via WorkerOperatorAssignment
Worker works as WorkerOperatorAssignment

Logical Views containing WorkerOperatorAssignment

Logical View
Logical 01300 - Item Price Maintenance View
Logical 02410 - Control Transaction - Sign On Off View
Logical 02500 - Tender Control Transaction - Macro View
Logical 02520 - Tender Control Transaction - Settlement View
Logical 06210 - Access Control - Rules View
Logical 06310 - Party - Role View
Logical 11100 - Worker - Macro View
Logical 11130 - Worker - Access Control View
Logical 11130 - Worker - Access Control View
Logical 11140 - Worker - Retail Transaction View
Logical 11160 - Worker - Reporting View