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.