ZenotiHelp

Center Royalty Settings Dimension Table

ZTZenoti Docs Team Updated April 10, 2026 1 min readHow-to

Dimension table storing default center-level royalty percentage settings by item type (service, product, membership, etc.) without category association.

Columns

Column Name Data Type Nullable Description
CenterRoyaltywid BIGINT IDENTITY No Surrogate warehouse key for the center royalty settings record
CenterRoyaltyId VARCHAR(36) Yes Unique identifier (GUID) for the center royalty settings record
CenterId VARCHAR(36) Yes Unique identifier (GUID) of the center
ServiceRoyaltyPercentage FLOAT Yes Default royalty percentage applied to services at this center
ProductRoyaltyPercentage FLOAT Yes Default royalty percentage applied to products at this center
MembershipRoyaltyPercentage FLOAT Yes Default royalty percentage applied to memberships at this center
PackageRoyaltyPercentage FLOAT Yes Default royalty percentage applied to packages at this center
GiftcardRoyaltyPercentage FLOAT Yes Default royalty percentage applied to gift cards 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
PrepaidcardRoyaltyPercentage FLOAT Yes Default royalty percentage applied to prepaid cards at this center
ClassRoyaltyPercentage FLOAT Yes Default royalty percentage applied to classes at this 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

CenterRoyaltywid

Foreign Keys

Column References
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.