Entity Definition

Logical Name : TimePunchApproval
Physical Name : CO_APVL_TPNCH

An after the fact confirmation that the TimePunch entry is valid.

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
TimePunchApprovalID (PK) A unique system assigned identifier for the after the fact confirmation that the TimePunch entry is valid. ID_APVL_TPNCH Identity integer
ReasonCode (FK) A unique retailer defined reason code for an action that is taken (or not taken) at a Workstation. e.g. Return reason codes - Past Use By Date, Defective Merchandise, etc. POSNoSale reason Codes - Customer Change Query CD_RSN Code varchar(20) Reason(CO_CD_RSN)
TimePunchEntryID (FK) A unique system-assigned identifier for the particular TimePunchEntry that is being approved. ID_ENR_TPNCH Identity integer WorkerTimePunchEntry(DO_TPNCH_WKR)
OperatorID (FK) A unique, automatically assigned number used to identify a workstation OPERATOR. ID_OPR Identity integer Operator(PA_OPR)
ApprovalDateTime The date and time the TimePunchApproval was made. DC_APVL AuditDateTime datetime


Parent Entity Verb Phrase Child Entity
WorkerTimePunchEntry is approved via TimePunchApproval
Operator approves TimePunchApproval
Reason classifies TimePunchApproval

Logical Views containing TimePunchApproval

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