ZenotiHelp

Center Royalty Category Dimension Table

ZTZenoti Docs Team Updated April 10, 2026 1 min readGuide

Dimension table storing center-level royalty percentage configurations by item type (service, product, membership, etc.) for each royalty category.

Columns

Column Name Data Type Nullable Description
CenterRoyaltyCategorywid BIGINT IDENTITY No Surrogate warehouse key for the center royalty category record
CenterRoyaltyCategoryId VARCHAR(36) Yes Unique identifier (GUID) for the center royalty category
OrgRoyaltyCategoryId VARCHAR(36) Yes Unique identifier (GUID) of the parent organization royalty category
CenterId VARCHAR(36) Yes Unique identifier (GUID) of the center
ServiceRoyaltyPercentage FLOAT Yes Royalty percentage applied to services at this center
ProductRoyaltyPercentage FLOAT Yes Royalty percentage applied to products at this center
MembershipRoyaltyPercentage FLOAT Yes Royalty percentage applied to memberships at this center
PackageRoyaltyPercentage FLOAT Yes Royalty percentage applied to packages at this center
GiftcardRoyaltyPercentage FLOAT Yes Royalty percentage applied to gift cards at this center
PrepaidcardRoyaltyPercentage FLOAT Yes Royalty percentage applied to prepaid cards at this center
ClassRoyaltyPercentage FLOAT Yes Royalty percentage applied to classes at this center
AddedBy VARCHAR(36) Yes Unique identifier (GUID) of the user who created the record
AddedOn TIMESTAMP Yes Timestamp when the record was created
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

CenterRoyaltyCategorywid

Foreign Keys

Column References
OrgRoyaltyCategoryId the organization-level royalty category (Bi_DimOrgRoyaltyCategory)
CenterId a center entity in the source system
OrganizationID an organization entity in the source system
AddedBy a user 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.