ZenotiHelp

Employee Attendance Dimension Table

ZTZenoti Docs Team Updated April 10, 2026 1 min readGuide

Dimension table storing employee attendance record type definitions used to classify attendance entries.

Columns

Column Name Data Type Nullable Description
dimemployeeattendancewid BIGINT IDENTITY No Surrogate warehouse key for the employee attendance record
recordpk NUMERIC(19,0) Yes Source system primary key for the attendance record type
recordname VARCHAR(36) Yes Name or label of the attendance record type

Note: All dimension tables also include standard ETL metadata columns (podname, organizationid, groupid, etlLastUpdatedOn, etlLastUpdatedBy) which are omitted from this reference for brevity.

Primary Key

dimemployeeattendancewid

Foreign Keys

This table has no foreign key relationships to other analytics tables.

Was this article helpful?
Your feedback helps us improve our documentation.