ZenotiHelp

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.