Entity Definition

Logical Name : Employee
Physical Name : PA_EM

An individual that works for a retail store, accepts direction from the retail store management and satisfies the statutory criteria requiring that payroll taxes and benefit contributions be paid by the retailer.

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
EmployeeID (PK) A unique, non-significant number used to identify a store employee. ID_EM Identity integer
WorkerID (FK) A unique system-assigned identifier for the Person who is a particular Worker. ID_WRKR Identity integer Worker(PA_WRKR)
StatusCode The status code regarding the EMPLOYEE, i.e. active or inactive. SC_EM Code2Status char(2)


Parent Entity Verb Phrase Child Entity
Worker is a Employee

Logical Views containing Employee

Logical View
Logical 02305 - Retail Transaction - Header View
Logical 02310 - Retail Transaction - Item Sale View
Logical 06310 - Party - Role View
Logical 06330 - Party - Identification View
Logical 06700 - Event Scheduler View
Logical 11100 - Worker - Macro View
Logical 11160 - Worker - Reporting View