Entity Definition

Logical Name : Contractor
Physical Name : PA_CNTR

A person who is not an Employee but provides services to the retail enterprise. Services provided are charged to the retail enterprise by a Vendor.

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
ContractorID (PK) An alternate ID assigned to a Contractor. ID_CNTR Identity integer
WorkerID (FK) A unique system-assigned identifier for the Person who is a particular Worker. ID_WRKR Identity integer Worker(PA_WRKR)
VendorID (FK) A unique system assigned identifier for the Vendor. ID_VN Identity integer Vendor(PA_VN)


Parent Entity Verb Phrase Child Entity
Worker is a Contractor
Vendor provides Contractor

Logical Views containing Contractor

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