Resource Service Association Dimension Table
ZTZenoti Docs Team Updated April 10, 2026 1 min readGuide
Dimension table linking resources (e.g., employees, rooms) to services they can perform, including category assignment and commission factor.
Columns
| Column Name | Data Type | Nullable | Description |
|---|---|---|---|
| resourceserviceassociationwid | BIGINT IDENTITY | No | Surrogate warehouse identifier (auto-generated) |
| resourceserviceid | VARCHAR(36) | Yes | Source system unique identifier for the resource-service association |
| resourceid | VARCHAR(36) | Yes | Unique identifier of the resource |
| serviceid | VARCHAR(36) | Yes | Unique identifier of the service |
| categoryid | VARCHAR(36) | Yes | Unique identifier of the service category |
| factor | FLOAT8 | Yes | Commission or pricing factor for this resource-service pairing |
| Void | BOOLEAN | Yes | Soft-delete flag |
| centerid | VARCHAR(36) | Yes | Unique identifier of the center |
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
resourceserviceassociationwid
Foreign Keys
| Column | References |
|---|---|
| resourceid | the resource dimension (Bi_DimResource or equivalent) |
| serviceid | the service dimension (Bi_DimService or equivalent) |
| categoryid | the service category dimension |
| centerid | the center dimension |
Was this article helpful?
Your feedback helps us improve our documentation.