WorkerDiscountLineItem

Entity Definition

Logical Name : WorkerDiscountLineItem
Physical Name : TR_LTM_EM_DSC

A special kind of retail line item set up to record and keep track of employee discounts taken in a transaction.

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)
RetailTransactionLineItemSequenceNumber (FK)(PK) The sequence number of line item within the context of this RetailTransaction. IC_LN_ITM LineNumber smallint
WorkerID (FK) A unique system-assigned identifier for the Person who is a particular Worker. ID_WRKR Identity integer Worker(PA_WRKR)
Amount The discount amount granted to an EMPLOYEE when making a purchase. The item sales are typically held separately in order to assess whether the EMPLOYEE is abusing the privilege. MO_ITM_LN_EM_DSC Money decimal(16,5)

Relationships

Parent Entity Verb Phrase Child Entity
Worker is granted WorkerDiscountLineItem
PriceModificationLineItem can be a WorkerDiscountLineItem

Logical Views containing WorkerDiscountLineItem

Logical View
Logical 01400 - Item Rewards Derivation - Transaction Level
Logical 02300 - Retail Transaction - Macro View
Logical 11100 - Worker - Macro View
Logical 11140 - Worker - Retail Transaction View