Skip to main content

Issue status type dimension table

Table Name

Column Name

Column Type

Primary Key

Mapped Dimension Table

Mapped Dimension Table Column

Bi_DimIssueStatusType_s3

PK

DECIMAL(19,0)

PK

Bi_DimIssueStatusType_s3

IssueStatusTypeID

VARCHAR(36)

Bi_DimIssueStatusType_s3

StatusName

NVARCHAR(512)

Bi_DimIssueStatusType_s3

IssueTypeId

VARCHAR(36)

Bi_DimIssueStatusType_s3

Priority

INT

Bi_DimIssueStatusType_s3

OrganizationId

VARCHAR(36)

Bi_DimIssueStatusType_s3

Code

NVARCHAR(256)

Bi_DimIssueStatusType_s3

Description

NVARCHAR(4096)

Bi_DimIssueStatusType_s3

Active

BOOLEAN

Bi_DimIssueStatusType_s3

void

BOOLEAN

Bi_DimIssueStatusType_s3

EtlLastUpdatedOn

TIMESTAMP

Bi_DimIssueStatusType_s3

EtlLastUpdatedBy

NVARCHAR(50)

Bi_DimIssueStatusType_s3

PodName

VARCHAR(20)

Bi_DimIssueStatusType_s3

groupid

BIGINT