Entity Definition

Logical Name : Worker
Physical Name : PA_WRKR

A person who provides services to a retail store. May be either an Employee or a Contractor.

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
WorkerID (PK) A unique system-assigned identifier for the Person who is a particular Worker. ID_WRKR Identity integer
WorkerTypeCode A unique retailer assigned code denoting the kind of Worker. TY_WRKR Code2 char(2)
WorkerPhotograph A binary data object containing a current photographic image of the Worker. BM_PGPH_WRKR Image varbinary
SpecialRequirements A narrative describing any special requirements the Worker has when working. e.g. Wheelchair access required. DE_SPL_RQMT DescriptionNarrative varchar(4000)
PartyRoleAssignmentID (FK) Token identifier for a PartyRoleAssignmentInstance. ID_PRTY_RO_ASGMT Identity integer PartyRoleAssignment(PA_RO_PRTY)


Parent Entity Verb Phrase Child Entity
PartyRoleAssignment is a Worker
Worker is depositor TenderDepositReceiptTransaction
Worker is a Employee
Worker assigns valuation for Trade-In-KindTenderLineItem
Worker is a Contractor
Worker works as WorkerOperatorAssignment
Worker works as WorkerServerAssignment
Worker acted as TransactionAssociate
Worker has WorkerTrainingRecord
Worker is classified via WorkerClassification
Worker has WorkerAvailability
Worker makes WorkerTimePunchEntry
Worker participates in ItemProcessingWorker
Worker is tracked by WorkerTimeAccrualHistory
Worker is assigned to WorkerEventAssignment
Worker is a member of WorkerDiscountGroupAssignment
Worker is tracked by WorkerDiscountedSalesHistory
Worker is granted WorkerDiscountLineItem
Worker is assigned to WorkerPositionAssignment
Worker receives tender via TipOutTransaction
Worker attends WorkerSchoolEnrollment
Worker has WorkerCertificate
Worker is granted RetailPriceModifier
Worker acted as LineItemAssociate
Worker buys SupplierItem

Logical Views containing Worker

Logical View
Logical 01300 - Item Price Maintenance View
Logical 02300 - Retail Transaction - Macro View
Logical 02305 - Retail Transaction - Header View
Logical 02310 - Retail Transaction - Item Sale View
Logical 02360 - Retail Transaction - Food Service View
Logical 02410 - Control Transaction - Sign On Off View
Logical 02510 - Tender Control Transaction - Movement View
Logical 02520 - Tender Control Transaction - Settlement View
Logical 06210 - Access Control - Rules View
Logical 06310 - Party - Role View
Logical 06320 - Party - Address and Contact View
Logical 06330 - Party - Identification View
Logical 06700 - Event Scheduler View
Logical 11100 - Worker - Macro View
Logical 11120 - Worker - Job Definition View
Logical 11130 - Worker - Access Control View
Logical 11130 - Worker - Access Control View
Logical 11140 - Worker - Retail Transaction View
Logical 11150 - Worker - Time Punch View
Logical 11160 - Worker - Reporting View
Logical 21000 - Fresh Item Management Macro View