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.widfactemployeescheduleid- 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.