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.