ZenotiHelp

Resource Dimension Table

ZTZenoti Docs Team Updated April 10, 2026 1 min readGuide

Dimension table storing resource (room/equipment) details per center, including capacity, category, and display attributes. Populated from the organization's resource configuration.

Columns

Column Name Data Type Nullable Description
resourcewid BIGINT IDENTITY No Surrogate warehouse key for the resource dimension
resourceid VARCHAR(36) Yes Natural unique identifier of the resource
centerid VARCHAR(36) Yes Identifier of the center the resource belongs to
resourcetypeid VARCHAR(36) Yes Identifier of the resource type classification
capacity INTEGER Yes Maximum capacity of the resource (e.g., room seats)
showinreceipt BOOLEAN Yes Flag indicating whether the resource name appears on receipts
canexceedroomcapacity BOOLEAN Yes Flag indicating whether bookings can exceed the stated room capacity
void BOOLEAN Yes Soft-delete flag; TRUE means the record is logically deleted
roomcategoryid VARCHAR(36) Yes Identifier of the room category the resource is assigned to
roomcategorycode VARCHAR(800) Yes Short code for the room category
roomcategoryname VARCHAR(800) Yes Display name of the room category
resourcename VARCHAR(128) Yes Display name of the resource
resourcetypename VARCHAR(128) Yes Display name of the resource type
indicatorcolor VARCHAR(128) Yes Hex or named color used to represent the resource in the UI
resourcecode VARCHAR(128) Yes Short code for the resource

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

resourcewid

Foreign Keys

Column References
centerid Bi_DimCenter.centerid
resourcetypeid Resource type reference
roomcategoryid Room category reference
Was this article helpful?
Your feedback helps us improve our documentation.