ZenotiHelp

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.