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.