Time Card Consolidated
ZTZenoti Docs Team Updated April 10, 2026 2 min readGuide
Consolidated table storing daily employee time card records including up to 10 check-in/check-out pairs, hours breakdowns, and production/non-production hour totals.
Columns
| Column Name | Data Type | Nullable | Description |
|---|---|---|---|
| organization account name | VARCHAR(256) | YES | Account name of the organization. Sourced from DimOrganization.organization_account_name. |
| center name | VARCHAR(256) | YES | Name of the center. Sourced from DimCenter.center_name. |
| zone name | VARCHAR(256) | YES | Name of the zone. Sourced from DimZone.zone_name. |
| ct date | DATE | YES | Reporting date for the time card entry. |
| employee first name | VARCHAR(256) | YES | First name of the employee. Sourced from DimEmployee.employee_first_name. |
| employee last name | VARCHAR(256) | YES | Last name of the employee. Sourced from DimEmployee.employee_last_name. |
| employee middle name | VARCHAR(256) | YES | Middle name of the employee. Sourced from DimEmployee.employee_middle_name. |
| employee code | VARCHAR(256) | YES | Code assigned to the employee. Sourced from DimEmployee.employee_code. |
| check in [1] | DATETIME | YES | First check-in time of the day. |
| check out [1] | DATETIME | YES | First check-out time of the day. |
| check in [2] | DATETIME | YES | Second check-in time of the day. |
| check out [2] | DATETIME | YES | Second check-out time of the day. |
| check in [3] | DATETIME | YES | Third check-in time of the day. |
| check out [3] | DATETIME | YES | Third check-out time of the day. |
| check in [4] | DATETIME | YES | Fourth check-in time of the day. |
| check out [4] | DATETIME | YES | Fourth check-out time of the day. |
| check in [5] | DATETIME | YES | Fifth check-in time of the day. |
| check out [5] | DATETIME | YES | Fifth check-out time of the day. |
| check in [6] | DATETIME | YES | Sixth check-in time of the day. |
| check out [6] | DATETIME | YES | Sixth check-out time of the day. |
| check in [7] | DATETIME | YES | Seventh check-in time of the day. |
| check out [7] | DATETIME | YES | Seventh check-out time of the day. |
| check in [8] | DATETIME | YES | Eighth check-in time of the day. |
| check out [8] | DATETIME | YES | Eighth check-out time of the day. |
| check in [9] | DATETIME | YES | Ninth check-in time of the day. |
| check out [9] | DATETIME | YES | Ninth check-out time of the day. |
| check in [10] | DATETIME | YES | Tenth check-in time of the day. |
| check out [10] | DATETIME | YES | Tenth check-out time of the day. |
| original hours | FLOAT | YES | Total original working hours recorded. |
| Holiday Hours | FLOAT | YES | Hours categorized as holiday hours. |
| Vacation Hours | FLOAT | YES | Hours categorized as vacation hours. |
| Paid BlockOut Hours | FLOAT | YES | Hours of paid block-out time. |
| Unpaid BlockOut Hours | FLOAT | YES | Hours of unpaid block-out time. |
| production hours | FLOAT | YES | Total production hours for the employee. |
| non production hours | FLOAT | YES | Total non-production hours for the employee. |
| employee start date | DATE | YES | Start date of the employee. Sourced from DimEmployee.employee_start_date. |
Primary Key
No explicit primary key defined. Composite of ct date, center name, and employee code uniquely identifies a record.
Foreign Keys
- Employee columns reference DimEmployee
center namereferences DimCenterzone namereferences DimZoneorganization account namereferences DimOrganization
Standard ETL metadata columns (EtlLastUpdatedOn, EtlLastUpdatedBy, podname, groupid) are present in the underlying table but omitted from this reference for brevity.
Was this article helpful?
Your feedback helps us improve our documentation.