Entity Definition

Logical Name : TimeClock
Physical Name : PA_TCLK

A clock that records the time a Worker does a particular action.

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
TimeClockID (PK) A unqiue system-assigned number identifying a particular TimeClock ID_TCLK Identity integer
EquipmentID (FK) The fixed asset number assigned by the retailer for this particular piece of equipment. ID_EQ Identity integer Equipment(AS_EQ)
TimeClockName A short description of where the TimeClock is located. NM_TCLK Name varchar(40)


Parent Entity Verb Phrase Child Entity
Equipment is a TimeClock
TimeClock records WorkerTimePunchEntry

Logical Views containing TimeClock

Logical View
Logical 06400 - Store Equipment View
Logical 11150 - Worker - Time Punch View