User notes dimension table
Table Name | Column Name | Column Type | Primary Key | Mapped Dimension Table |
|---|---|---|---|---|
Bi_DimUserNotes_s3 | NoteId | VARCHAR(36) | PK | |
Bi_DimUserNotes_s3 | UserId | VARCHAR(36) | ||
Bi_DimUserNotes_s3 | CenterId | VARCHAR(36) | ||
Bi_DimUserNotes_s3 | ObjectId | VARCHAR(36) | ||
Bi_DimUserNotes_s3 | NoteType | NVARCHAR(4096) | ||
Bi_DimUserNotes_s3 | Privacytype | NVARCHAR(4096) | ||
Bi_DimUserNotes_s3 | IsPrivate | BOOLEAN | ||
Bi_DimUserNotes_s3 | Note | NVARCHAR(65535) | ||
Bi_DimUserNotes_s3 | Alert | BOOLEAN | ||
Bi_DimUserNotes_s3 | CreatedBy | VARCHAR(36) | ||
Bi_DimUserNotes_s3 | CreateDate | TIMESTAMP | ||
Bi_DimUserNotes_s3 | UpdatedBy | VARCHAR(36) | ||
Bi_DimUserNotes_s3 | UpdatedOn | TIMESTAMP | ||
Bi_DimUserNotes_s3 | SOURCE | NVARCHAR(128) | ||
Bi_DimUserNotes_s3 | Entity | DECIMAL(19,0) | ||
Bi_DimUserNotes_s3 | Void | BOOLEAN | ||
Bi_DimUserNotes_s3 | EtlLastUpdatedOn | TIMESTAMP | ||
Bi_DimUserNotes_s3 | EtlLastUpdatedBy | NVARCHAR(50) | ||
Bi_DimUserNotes_s3 | PodName | VARCHAR(20) | ||
Bi_DimUserNotes_s3 | organizationid | VARCHAR(36) | ||
Bi_DimUserNotes_s3 | groupid | BIGINT |