Table MD_IssueTrackingProblemType

Card of table MD_IssueTrackingProblemType

Name

MD_IssueTrackingProblemType

Dimensional Type

Dimension

Comment

Problem types that may be assigned to issue tracking tickets.

Note that although some trouble tickets in our system(s) of record may come in with no problem type, we convert such NULL values to 'Unknown' or 'Not Specified' and link them to a dummy entry here, in this dimension.


Check constraint name of the table MD_IssueTrackingProblemType

CKT_MD_ISSUETRACKINGPROBLEMTYP


List of incoming references of the table MD_IssueTrackingProblemType

Name

Child Table

Foreign Key Columns

Relationship_124

MF_IssueTrackingTicket

MD_ITProblemType_SurrogateKey


List of referencing views of the table MD_IssueTrackingProblemType

Name

Code

VMD_IssueTrackingProblemType

VMD_ISSUETRACKINGPROBLEMTYPE


List of diagrams containing the table MD_IssueTrackingProblemType

Name

IssueTrackingDiagram


List of columns of the table MD_IssueTrackingProblemType

Name

Comment

Domain

Data Type

Length

MD_ITProblemType_SurrogateKey

 

<None>

numeric

 

MD_ITProblemType_ID

Unique internal identifier in issue tracking system representing a problem or "issue" type.

This is likely different from the description or name corresponding to this internal identifier.

DW_CodeDesc

varchar(32)

32

MD_ITProblemType_IssueTrackingSystem

Name of issue tracking system. We may have multiple systems, and their problem classifications may end up overlapping, so this attribute may be needed. As of 2011 it is not needed, since we have only Web Help Desk.

DW_CommonName

nvarchar(64)

64

MD_ITProblemType_Name

Name or description for a problem or "issue" type in a given issue tracking system (MD_ITProblemType_IssueTrackingSystem).

DW_CommonName

nvarchar(64)

64

MD_ITProblemType_Category

Intermediate problem type classifier

DW_CommonName

nvarchar(64)

64

MD_ITProblemType_Class

Most general problem type classifier

DW_CommonName

nvarchar(64)

64

MD_ITProblemType_AuditKey

 

DW_AuditKey

bigint

 

MD_ITProblemType_Timestamp

 

<None>

timestamp

 


List of indexes of the table MD_IssueTrackingProblemType

Name

Unique

Cluster

Primary

Foreign Key

Alternate Key

Table

MD_ISSUETRACKINGPROBLEMTYPE_PK

TRUE

TRUE

TRUE

FALSE

FALSE

MD_IssueTrackingProblemType

MD_ISSUETRACKINGPROBLEMTYPE_AK

TRUE

FALSE

FALSE

FALSE

TRUE

MD_IssueTrackingProblemType


List of keys of the table MD_IssueTrackingProblemType

Name

Identifier_1

AltKey


Previous
Home
Next