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.