Organization user relationship dimension table (Redshift)
Bi_DimOrgUserRelationship
Master dimension table containing the defined relationship types between guests and their contacts, including relationship labels, codes, and associated permissions.
Field | Field type | Description | Primary Key | Mapped Dimension table | Mapped Dimension field |
|---|---|---|---|---|---|
OrgUserRelationshipWId | BIGINT IDENTITY | Surrogate warehouse key for the org user relationship record | PK | ||
RelationshipId | VARCHAR(36) | Unique identifier (GUID) of the relationship record from the source system | |||
Relationship | NVARCHAR(255) | Display name of the relationship type | |||
OrganizationId | VARCHAR(36) | Unique identifier (GUID) of the organization | an organization entity in the source system | ||
Description | NVARCHAR(512) | Descriptive text for the relationship type | |||
RelationshipCode | NVARCHAR(50) | Short code identifying the relationship type | |||
Active | BOOLEAN | Indicates whether the relationship type is currently active | |||
Perms | INT | Permission flags associated with the relationship type; see source system definition | |||
Void | BOOLEAN | Indicates whether the record has been voided/soft-deleted | |||
CreatedBy | VARCHAR(36) | Identifier (GUID) of the user who created the record | |||
CreatedDate | TIMESTAMP | Timestamp when the record was created | |||
LastUpdatedBy | VARCHAR(36) | Identifier (GUID) of the user who last updated the record | |||
LastUpdated | TIMESTAMP | Timestamp when the record was last updated | |||
OrgUserRelationshipPK | BIGINT | Source system primary key for the relationship record | |||
groupid | BIGINT | Group identifier for multi-tenant partitioning | |||
EtlCreatedDate | TIMESTAMP | Timestamp when the ETL process created this record | |||
PodName | NVARCHAR(100) | Name of the source pod from which the data originated |