ZenotiHelp

Equipment Dimension Table

ZTZenoti Docs Team Updated April 10, 2026 1 min readGuide

Dimension table storing equipment details per center, including capacity, booking rules, and activation status. Populated from the organization's equipment configuration.

Columns

Column Name Data Type Nullable Description
equipmentwid BIGINT IDENTITY No Surrogate warehouse key for the equipment dimension
equipmentpk NUMERIC(19,0) Yes Source system primary key for the equipment
equipmentid VARCHAR(36) Yes Natural unique identifier of the equipment
capacity INTEGER Yes Maximum capacity or quantity available for the equipment
centerid VARCHAR(36) Yes Identifier of the center the equipment belongs to
lastupdated TIMESTAMP Yes Timestamp of the last update in the source system
void BOOLEAN Yes Soft-delete flag; TRUE means the record is logically deleted
active BOOLEAN Yes Flag indicating whether the equipment is currently active
allowtobookmorethancapacity BOOLEAN Yes Flag indicating whether bookings can exceed the stated equipment capacity
description VARCHAR(65535) Yes Detailed description of the equipment
equipmentname VARCHAR(1024) Yes Display name of the equipment
equipmentcode VARCHAR(128) Yes Short code identifying the equipment

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

equipmentwid

Foreign Keys

Column References
centerid Bi_DimCenter.centerid
Was this article helpful?
Your feedback helps us improve our documentation.