ZenotiHelp

Employee Schedule Status Dimension Table

ZTZenoti Docs Team Updated April 10, 2026 1 min readGuide

Dimension table storing employee schedule status definitions used to categorize the state of employee schedules within an organization.

Columns

Column Name Data Type Nullable Description
employeeschedulestatuswid BIGINT IDENTITY No Surrogate warehouse key for the employee schedule status record
statuspk NUMERIC(19,0) Yes Source system primary key for the schedule status
statusname VARCHAR(1024) Yes Display name of the schedule status
organizationname VARCHAR(512) Yes Name of the organization the status belongs to
accountname VARCHAR(256) Yes Name of the account associated with the status
void BOOLEAN Yes Indicates whether the record has been voided/soft-deleted

Note: All dimension tables also include standard ETL metadata columns (podname, organizationid, groupid, etlLastUpdatedOn, etlLastUpdatedBy) which are omitted from this reference for brevity.

Primary Key

employeeschedulestatuswid

Foreign Keys

Column References
organizationid an organization entity in the source system

Enumerator Values

Column Values
void FALSE = Active, TRUE = Voided
Was this article helpful?
Your feedback helps us improve our documentation.