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.