Skip to main content

User update history dimension table

Table Name

Column Name

Column Type

Primary Key

Mapped Dimension Table

Bi_DimUserUpdateHistory_s3

UserHistoryPK

DECIMAL(19,0)

PK

Bi_DimUserUpdateHistory_s3

userid

VARCHAR(36)

Bi_DimUserUpdateHistory_s3

TuuhOrgId

VARCHAR(36)

Bi_DimUserUpdateHistory_s3

CurrentValue

NVARCHAR(65535)

Bi_DimUserUpdateHistory_s3

settingname

NVARCHAR(2048)

Bi_DimUserUpdateHistory_s3

startDate

TIMESTAMP

Bi_DimUserUpdateHistory_s3

enddate

TIMESTAMP

Bi_DimUserUpdateHistory_s3

EtlLastUpdatedOn

TIMESTAMP

Bi_DimUserUpdateHistory_s3

EtlLastUpdatedBy

NVARCHAR(50)

Bi_DimUserUpdateHistory_s3

organizationid

VARCHAR(36)

Bi_DimUserUpdateHistory_s3

PodName

VARCHAR(20)

Bi_DimUserUpdateHistory_s3

groupid

BIGINT