ZenotiHelp

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 name references DimCenter
  • zone name references DimZone
  • organization account name references 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.