Skip to main content

Status dimension table

Table Name

Column Name

Column Type

Primary Key

Mapped Dimension Table

Bi_DimStatus_s3

DimStatusId

INT

PK

Bi_DimStatus_s3

StatusTypeCode

NVARCHAR(400)

Bi_DimStatus_s3

StatusDisplayValue

NVARCHAR(400)

Bi_DimStatus_s3

StatusCode

NVARCHAR(400)

Bi_DimStatus_s3

StatusValue

INT

Bi_DimStatus_s3

void

BOOLEAN

Bi_DimStatus_s3

EtlLastUpdatedOn

TIMESTAMP

Bi_DimStatus_s3

EtlLastUpdatedBy

NVARCHAR(50)

Bi_DimStatus_s3

PodName

VARCHAR(20)

Bi_DimStatus_s3

organizationid

VARCHAR(36)

Bi_DimStatus_s3

groupid

BIGINT