ZenotiHelp

Category Services Dimension Table

ZTZenoti Docs Team Updated April 10, 2026 1 min readGuide

Dimension table that maps services to their associated categories within an organization.

Columns

Column Name Data Type Nullable Description
ServiceCategorywid BIGINT IDENTITY No Surrogate warehouse key for the service-category mapping record
ServiceCategoryPK DECIMAL(19,0) Yes Source system primary key for the service-category relationship
ServiceId VARCHAR(36) Yes Unique identifier (GUID) of the service
CategoryId VARCHAR(36) Yes Unique identifier (GUID) of the category
Void BOOLEAN Yes Indicates whether the record has been voided/soft-deleted

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

ServiceCategorywid

Foreign Keys

Column References
ServiceId a service entity in the source system
CategoryId a category entity in the source system
OrganizationId an organization entity in the source system

Enumerator Values

Column Values
Void FALSE = Active, TRUE = Voided
Was this article helpful?
Your feedback helps us improve our documentation.