ZenotiHelp

Schedule Fact Consolidated

ZTZenoti Docs Team Updated April 10, 2026 4 min readGuide

Consolidated employee schedule fact table combining schedule, break, holiday, resource, and work task details with employee and center dimensions for workforce scheduling and utilization analytics.

Columns

Column Name Data Type Nullable Description
Employee wid BIGINT Yes Warehouse identifier for the employee dimension. Sourced from Dim_Employee.wid.
organization name VARCHAR(512) Yes Name of the organization. Sourced from Dim_Organization.organization_name.
organization account name VARCHAR(256) Yes Account name of the organization. Sourced from Dim_Organization.organization_account_name.
zone name VARCHAR(800) Yes Name of the zone the center belongs to. Sourced from Dim_Center.zone_name.
center name VARCHAR(128) Yes Name of the center. Sourced from Dim_Center.center_name.
utilization factor VARCHAR(200) Yes Utilization factor for scheduling. Sourced from Fact_EmployeeSchedule.utilization_factor.
center city VARCHAR(128) Yes City where the center is located. Sourced from Dim_Center.center_city.
center zip VARCHAR(32) Yes Zip/postal code of the center. Sourced from Dim_Center.center_zip.
center state name VARCHAR(1024) Yes State name of the center. Sourced from Dim_Center.center_state_name.
country name VARCHAR(1024) Yes Country name of the center. Sourced from Dim_Center.country_name.
operating center BOOLEAN Yes Whether the center is an operating center. Sourced from Dim_Center.operating_center.
employee first name VARCHAR(160) Yes First name of the employee. Sourced from Dim_Employee.first_name.
employee last name VARCHAR(256) Yes Last name of the employee. Sourced from Dim_Employee.last_name.
employee middle name VARCHAR(128) Yes Middle name of the employee. Sourced from Dim_Employee.middle_name.
employee mobile phone VARCHAR(64) Yes Mobile phone of the employee. Sourced from Dim_Employee.mobile_phone.
employee code VARCHAR(128) Yes Code of the employee. Sourced from Dim_Employee.employee_code.
employee - code VARCHAR(128) Yes Alternate code of the employee. Sourced from Dim_Employee.employee_code_alt.
employee tags VARCHAR(65535) Yes Tags associated with the employee. Sourced from Dim_Employee.tags.
employee gender VARCHAR(14) Yes Gender of the employee. Sourced from Dim_Employee.gender.
employee job name VARCHAR(510) Yes Job title of the employee. Sourced from Dim_Employee.job_name.
mandatory break time per day INTEGER Yes Mandatory break time per day in minutes. Sourced from Fact_EmployeeSchedule.mandatory_break_time_per_day.
is employee inactive BOOLEAN Yes Whether the employee is inactive. Sourced from Dim_Employee.is_inactive.
employee start date TIMESTAMP Yes Start date of the employee. Sourced from Dim_Employee.start_date.
employee last date TIMESTAMP Yes Last working date of the employee. Sourced from Dim_Employee.last_date.
scheduledate TIMESTAMP Yes Date of the schedule. Sourced from Fact_EmployeeSchedule.scheduledate.
starttime TIMESTAMP Yes Start time of the schedule slot. Sourced from Fact_EmployeeSchedule.starttime.
endtime TIMESTAMP Yes End time of the schedule slot. Sourced from Fact_EmployeeSchedule.endtime.
service time BIGINT Yes Service time in minutes. Sourced from Fact_EmployeeSchedule.service_time.
day of week VARCHAR(320) Yes Day of the week for the schedule. Sourced from Fact_EmployeeSchedule.day_of_week.
center start time FLOAT8 Yes Center opening time. Sourced from Dim_Center.center_start_time.
center end time FLOAT8 Yes Center closing time. Sourced from Dim_Center.center_end_time.
online booking start time FLOAT8 Yes Online booking start time. Sourced from Dim_Center.online_booking_start_time.
online booking end time FLOAT8 Yes Online booking end time. Sourced from Dim_Center.online_booking_end_time.
record name VARCHAR(36) Yes Name of the schedule record type. Sourced from Fact_EmployeeSchedule.record_name.
employee break category name VARCHAR(1024) Yes Name of the employee break category. Sourced from Fact_EmployeeSchedule.employee_break_category_name.
employee break category code VARCHAR(512) Yes Code of the employee break category. Sourced from Fact_EmployeeSchedule.employee_break_category_code.
employee break duration INTEGER Yes Duration of the employee break in minutes. Sourced from Fact_EmployeeSchedule.employee_break_duration.
break account name VARCHAR(1024) Yes Account name for the break. Sourced from Fact_EmployeeSchedule.break_account_name.
active BOOLEAN Yes Whether the schedule record is active. Sourced from Fact_EmployeeSchedule.active.
count in utilization BOOLEAN Yes Whether to count in utilization calculation. Sourced from Fact_EmployeeSchedule.count_in_utilization.
status name VARCHAR(1024) Yes Status name of the schedule. Sourced from Fact_EmployeeSchedule.status_name.
resource name VARCHAR(128) Yes Name of the resource/room. Sourced from Dim_Resource.resource_name.
resource type name VARCHAR(128) Yes Type name of the resource. Sourced from Dim_Resource.resource_type_name.
capacity INTEGER Yes Capacity of the resource. Sourced from Dim_Resource.capacity.
show in receipt BOOLEAN Yes Whether to show the resource in receipts. Sourced from Dim_Resource.show_in_receipt.
indicator color VARCHAR(128) Yes Color indicator for the resource. Sourced from Dim_Resource.indicator_color.
resource code VARCHAR(128) Yes Code of the resource. Sourced from Dim_Resource.resource_code.
can exceed room capacity BOOLEAN Yes Whether room capacity can be exceeded. Sourced from Dim_Resource.can_exceed_room_capacity.
room category code VARCHAR(800) Yes Code of the room category. Sourced from Dim_Resource.room_category_code.
room category name VARCHAR(800) Yes Name of the room category. Sourced from Dim_Resource.room_category_name.
center code VARCHAR(40) Yes Code of the center. Sourced from Dim_Center.center_code.
base center code VARCHAR(40) Yes Code of the employee's base center. Sourced from Dim_Center.base_center_code.
base center name VARCHAR(4000) Yes Name of the employee's base center. Sourced from Dim_Center.base_center_name.
holiday date TIMESTAMP Yes Date of the holiday. Sourced from Fact_EmployeeSchedule.holiday_date.
holiday description VARCHAR(800) Yes Description of the holiday. Sourced from Fact_EmployeeSchedule.holiday_description.
is holiday valid BOOLEAN Yes Whether the holiday is valid. Sourced from Fact_EmployeeSchedule.is_holiday_valid.
Lunch Time Old FLOAT8 Yes Legacy lunch time value. Sourced from Fact_EmployeeSchedule.lunch_time_old.
Scheduled Hours FLOAT8 Yes Total scheduled hours. Sourced from Fact_EmployeeSchedule.scheduled_hours.
WorkTaskCode NVARCHAR(512) Yes Code of the work task. Sourced from Fact_EmployeeSchedule.work_task_code.
WorkTaskName NVARCHAR(1024) Yes Name of the work task. Sourced from Fact_EmployeeSchedule.work_task_name.
Minutes To ADD INTEGER Yes Minutes offset to add for timezone conversion. Sourced from Dim_Center.minutes_to_add.
Recovery Time BIGINT Yes Recovery time in minutes. Sourced from Fact_EmployeeSchedule.recovery_time.
factemployeescheduleid NUMERIC(19,0) Yes Internal identifier for the schedule fact record. Sourced from Fact_EmployeeSchedule.id.
status VARCHAR(1024) Yes Status of the schedule record. Sourced from Fact_EmployeeSchedule.status.
minutes withinschedule DOUBLE PRECISION Yes Minutes within the scheduled time. Sourced from Fact_EmployeeSchedule.minutes_withinschedule.
minutes outsideschedule DOUBLE PRECISION Yes Minutes outside the scheduled time. Sourced from Fact_EmployeeSchedule.minutes_outsideschedule.
Is Mandatory Break Complete BOOLEAN Yes Whether mandatory break was completed. Sourced from Fact_EmployeeSchedule.is_mandatory_break_complete.
TimeOff In Minutes INTEGER Yes Total time off in minutes. Sourced from Fact_EmployeeSchedule.timeoff_in_minutes.
Vacation TimeOff In Mins DOUBLE PRECISION Yes Vacation time off in minutes. Sourced from Fact_EmployeeSchedule.vacation_timeoff_in_mins.
Holiday TimeOff In Mins DOUBLE PRECISION Yes Holiday time off in minutes. Sourced from Fact_EmployeeSchedule.holiday_timeoff_in_mins.
Additional TimeOff In Mins DOUBLE PRECISION Yes Additional time off in minutes. Sourced from Fact_EmployeeSchedule.additional_timeoff_in_mins.

Primary Key

No explicit primary key defined. The factemployeescheduleid serves as the logical record identifier.

Foreign Keys

  • Employee wid - References Dim_Employee.wid
  • factemployeescheduleid - Internal identifier for the schedule fact

Enumerator Values

Column Name Known Values
record name Schedule record type
status name Schedule status name
status Schedule status
day of week Day of the week

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.