Organization user relationship dimension table (s3)
Bi_DimOrgUserRelationship_s3
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 |
|---|---|---|---|---|---|
RelationshipId | VARCHAR(36) | GUID uniquely identifying the relationship record | PK | ||
Relationship | NVARCHAR(255) | Display name of the relationship type | |||
OrganizationId | VARCHAR(36) | GUID of the organization | Bi_DimCenter | ||
Description | NVARCHAR(512) | Descriptive text for the relationship type | |||
RelationshipCode | NVARCHAR(50) | Short code identifying the relationship type | |||
Active | BOOLEAN | 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 is voided (soft-deleted) | |||
CreatedBy | VARCHAR(36) | GUID of the user who created the record | |||
CreatedDate | TIMESTAMP | Timestamp when the record was created | |||
LastUpdatedBy | VARCHAR(36) | 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 | Identifier for the data group used in ETL partitioning | |||
EtlLastUpdatedOn | TIMESTAMP | Timestamp of the last ETL update for this record | |||
EtlLastUpdatedBy | NVARCHAR(50) | User or process that last updated this record via ETL | |||
podname | VARCHAR(20) | Name of the source pod from which the data originated |