Reasons dimension table
Table Name | Column Name | Column Type | Primary Key | Mapped Dimension Table |
|---|---|---|---|---|
Bi_DimReasons_s3 | ReasonId | VARCHAR(36) | ||
Bi_DimReasons_s3 | ReasonCode | NVARCHAR(512) | ||
Bi_DimReasons_s3 | Reason | NVARCHAR(1024) | ||
Bi_DimReasons_s3 | Description | NVARCHAR(2048) | ||
Bi_DimReasons_s3 | ObjectType | INT | ||
Bi_DimReasons_s3 | ActionType | INT | ||
Bi_DimReasons_s3 | OrganizationId | VARCHAR(36) | ||
Bi_DimReasons_s3 | Active | BOOLEAN | ||
Bi_DimReasons_s3 | CreatedDate | TIMESTAMP | ||
Bi_DimReasons_s3 | ReasonPK | DECIMAL(19,0) | PK | |
Bi_DimReasons_s3 | EtlLastUpdatedOn | TIMESTAMP | ||
Bi_DimReasons_s3 | EtlLastUpdatedBy | NVARCHAR(50) | ||
Bi_DimReasons_s3 | PodName | VARCHAR(20) | ||
Bi_DimReasons_s3 | groupid | BIGINT |