Organization royalty categories dimension table (Redshift)
Table name: Bi_DimOrgRoyaltyCategory
Dimension table defining organization-level royalty categories used to classify and calculate royalty distributions.
Field | Field type | Description | Primary Key | Mapped Dimension table | Mapped Dimension field |
|---|---|---|---|---|---|
OrgRoyaltyCategorywid | BIGINT | Surrogate warehouse key for the organization royalty category record | PK | ||
OrgRoyaltyCategoryId | VARCHAR(36) | Unique identifier (GUID) for the organization royalty category | |||
OrganizationId | VARCHAR(36) | Unique identifier (GUID) of the organization | an organization entity in the source system | ||
RoyaltyCategoryName | NVARCHAR(2048) | Display name of the royalty category | |||
AddedBy | VARCHAR(36) | Unique identifier (GUID) of the user who created the category | a user entity in the source system | ||
AddedOn | TIMESTAMP | Timestamp when the category was created | |||
Void | BOOLEAN | Indicates whether the record has been voided/soft-deleted | |||
CategoryDescription | NVARCHAR(MAX) | Detailed description of the royalty category | |||
CategoryCode | NVARCHAR(512) | Code assigned to the royalty category | |||
Active | BOOLEAN | Indicates whether the royalty category is currently active | |||
CalculationParameter | INT | Parameter controlling how royalty calculations are performed for this category | |||
ETLLastUpdatedOn | TIMESTAMP | Timestamp of the last ETL update (defaults to current UTC time) | |||
ETLLastUpdatedBy | VARCHAR(50) | User who last updated the record via ETL (defaults to current user) | |||
Podname | VARCHAR(20) | Name of the source pod from which the data originated | |||
groupid | BIGINT | Group identifier for multi-tenant partitioning |