Entity Definition

Logical Name : WorkerDiscountGroupAssignment
Physical Name : CO_GP_EM_MBS_DSC

An association between an employee and an employee discount group which makes the employee eligible for the price reductions available to the discount group.

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
EmployeeDiscountGroupID (FK)(PK) The identifier for a specific EMPLOYEE DISCOUNT GROUP. ID_GP_EM_DSC Identity integer WorkerDiscountGroup(CO_GP_EM_DSC)
WorkerID (FK)(PK) A unique system-assigned identifier for the Person who is a particular Worker. ID_WRKR Identity integer Worker(PA_WRKR)
Description Description associated with this employee discount group. DE_GP_EM_DSC_GP DescriptionShort varchar(255)
IdentityVerifyRequiredFlag A flag to denote whether the identity of the EMPLOYEE has been verified. FL_IDN_VR_RQ_EM Flag integer


Parent Entity Verb Phrase Child Entity
WorkerDiscountGroup is composed of WorkerDiscountGroupAssignment
Worker is a member of WorkerDiscountGroupAssignment

Logical Views containing WorkerDiscountGroupAssignment

Logical View
Logical 11100 - Worker - Macro View
Logical 11140 - Worker - Retail Transaction View