ZenotiHelp

Org Royalty Category Dimension Table

ZTZenoti Docs Team Updated April 10, 2026 1 min readGuide

Dimension table defining organization-level royalty categories used to classify and calculate royalty distributions.

Columns

Column Name Data Type Nullable Description
OrgRoyaltyCategorywid BIGINT IDENTITY No Surrogate warehouse key for the organization royalty category record
OrgRoyaltyCategoryId VARCHAR(36) Yes Unique identifier (GUID) for the organization royalty category
RoyaltyCategoryName NVARCHAR(2048) Yes Display name of the royalty category
AddedBy VARCHAR(36) Yes Unique identifier (GUID) of the user who created the category
AddedOn TIMESTAMP Yes Timestamp when the category was created
Void BOOLEAN Yes Indicates whether the record has been voided/soft-deleted
CategoryDescription NVARCHAR(MAX) Yes Detailed description of the royalty category
CategoryCode NVARCHAR(512) Yes Code assigned to the royalty category
Active BOOLEAN Yes Indicates whether the royalty category is currently active
CalculationParameter INT Yes Parameter controlling how royalty calculations are performed for this category

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

OrgRoyaltyCategorywid

Foreign Keys

Column References
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
Active FALSE = Inactive, TRUE = Active
CalculationParameter 1 = Percentage
2 = Flat Amount
3 = Tiered
Was this article helpful?
Your feedback helps us improve our documentation.