Entity Definition

Logical Name : WorkerTimePunchEntry
Physical Name : DO_TPNCH_WKR

A record of a Worker commencing or completing a particular Job.

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
TimePunchEntryID (PK) A unique system-assigned identifier for this particular TimePunchEntry ID_ENR_TPNCH Identity integer
TaskID (FK) A unique retailer assigned identifier for an individual activity that a Worker performs in the course of their Position. ID_TSK Identity integer Task(CO_TSK)
WorkerID (FK) A unique system-assigned identifier for the Person who is a particular Worker. ID_WRKR Identity integer Worker(PA_WRKR)
JobID (FK) A unique retailer assigned identifier for a particular Job. ID_JOB Identity integer Job(CO_JOB)
BusinessDayDate (FK) The calendar date of the BusinessDay. DC_DY_BSN DateCalendar date BusinessDay(CA_DY_BSN)
TimePunchDateTime The date and time of the TimePunch as recorded by the TimeClock or Workstation that was used to make it. DC_TPNCH AuditDateTime datetime
TimeClockID (FK) A unqiue system-assigned number identifying a particular TimeClock ID_TCLK Identity integer TimeClock(PA_TCLK)
TransactionID (FK) A universally unique identifier (UUID) for the Transaction. This may be assembled from alternate key members. ID_TRN IdentityUUID char(32) TimePunchTransaction(TR_TPNCH)
SiteID (FK) Token ID for a Site ID_STE Identity integer Site(LO_STE)


Parent Entity Verb Phrase Child Entity
Worker makes WorkerTimePunchEntry
TimePunchTransaction records WorkerTimePunchEntry
Task starts/ends with WorkerTimePunchEntry
TimeClock records WorkerTimePunchEntry
Site locates WorkerTimePunchEntry
BusinessDay contains WorkerTimePunchEntry
Job starts/ends with WorkerTimePunchEntry
WorkerTimePunchEntry is original TimePunchCorrection
WorkerTimePunchEntry is approved via TimePunchApproval
WorkerTimePunchEntry is correction TimePunchCorrection

Logical Views containing WorkerTimePunchEntry

Logical View
Logical 02200 - Transaction Macro View
Logical 02400 - Control Transaction Macro View
Logical 11150 - Worker - Time Punch View