Employee Schedule Fact Table
ZTZenoti Docs Team Updated April 10, 2026 2 min readGuide
Stores employee schedule records including shift start/end times, break categories, attendance tracking, resource assignments, service time, and schedule compliance metrics.
Columns
| Column Name | Data Type | Nullable | Description |
|---|---|---|---|
| factemployeeschedulewid | BIGINT IDENTITY | No | Surrogate primary key (auto-generated) |
| factemployeescheduleid | NUMERIC(19,0) | Yes | Source system identifier for the schedule fact |
| recordpk | NUMERIC(19,0) | Yes | Source primary key of the schedule record |
| employeewid | BIGINT | Yes | Foreign key to the employee (user) dimension |
| centerwid | BIGINT | Yes | Foreign key to the center dimension |
| podid | INTEGER | Yes | Pod identifier for multi-tenant partitioning |
| scheduledate | TIMESTAMP | Yes | Date of the schedule entry |
| starttime | TIMESTAMP | Yes | Scheduled shift start time |
| endtime | TIMESTAMP | Yes | Scheduled shift end time |
| employeeschedulestatuswid | BIGINT | Yes | Foreign key to the employee schedule status dimension |
| employeebreakcategorywid | BIGINT | Yes | Foreign key to the employee break category dimension |
| resourcewid | BIGINT | Yes | Foreign key to the resource (room/bed) dimension |
| employeeattendancewid | BIGINT | Yes | Foreign key to the employee attendance dimension |
| centertimingwid | BIGINT | Yes | Foreign key to the center timing dimension |
| void | BOOLEAN | Yes | Indicates if the record is voided |
| worktaskwid | BIGINT | Yes | Foreign key to the work task dimension |
| servicetime | DOUBLE PRECISION | Yes | Time spent servicing guests (in minutes or hours) |
| expectedcheckintime | DOUBLE PRECISION | Yes | Expected check-in time offset |
| expectedcheckouttime | DOUBLE PRECISION | Yes | Expected check-out time offset |
| recoverytime | INTEGER | Yes | Recovery time between appointments in minutes |
| withinscheduleinminutes | DOUBLE PRECISION | Yes | Minutes worked within the scheduled shift |
| OutsideScheduleInMinutes | DOUBLE PRECISION | Yes | Minutes worked outside the scheduled shift |
| ismandatorybreakcomplete | BOOLEAN | YES | Whether mandatory break was completed |
| timeoffinminutes | INTEGER | YES | Total time off in minutes |
| vacationtimeoffinmins | FLOAT | YES | Vacation time off in minutes |
| holidaytimeoffinmins | FLOAT | YES | Holiday time off in minutes |
| additionaltimeoffinmins | FLOAT | YES | Additional time off in minutes |
Note: All fact tables also include standard ETL metadata columns (
podname,organizationid,groupid,etlCreatedDate) which are omitted from this reference for brevity.
Primary Key
factemployeeschedulewid
Foreign Keys
| Column | References |
|---|---|
| employeewid | Bi_DimUser.userwid |
| centerwid | Bi_DimCenter.centerwid |
| resourcewid | Bi_DimResource.resourcewid |
Enumerator Values
| Column | Values |
|---|---|
| void | true = Voided, false = Active |
| IsMandatoryBreakComplete | true = Completed, false = Not completed |
| RecordType | 1 = Schedule 2 = Break 3 = MultipleAttendance 4 = Attendance 5 = StagedSchedule 6 = StagedAttendance |
Was this article helpful?
Your feedback helps us improve our documentation.