Dict-Physical

Table MD_IssueTrackingStatus

Card of table MD_IssueTrackingStatus

Name	MD_IssueTrackingStatus
Dimensional Type	Dimension
Comment	Status of ticket, such as closed, canceled, waiting, resolved. Does not apply to assets - which have their own status values. Note that although some trouble tickets in our system(s) of record may come in with no status, we convert such status values to 'Unknown' or 'Not Specified' and link them to a dummy entry here, in this dimension.

Check constraint name of the table MD_IssueTrackingStatus

CKT_MD_ISSUETRACKINGSTATUS

List of incoming references of the table MD_IssueTrackingStatus

Relationship_117

MF_IssueTrackingTicket

MD_ITStatus_SurrogateKey

List of referencing views of the table MD_IssueTrackingStatus

VMD_IssueTrackingStatus

VMD_ISSUETRACKINGSTATUS

List of diagrams containing the table MD_IssueTrackingStatus

IssueTrackingDiagram

List of columns of the table MD_IssueTrackingStatus

MD_ITStatus_SurrogateKey

<None>

numeric

MD_ITStatus_ID

DW_CodeDesc

varchar(32)

MD_ITStatus_IssueTrackingSystem

Name of issue tracking system. We may have multiple systems, and their status 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)

MD_ITStatus_Name

Issue tracking systems typically create workflows, and as a side-effect update individual help requests or tickets with status values (e.g., waiting, resolved, etc.). This attribute holds the human-readable name/description for such status values.

DW_CommonName

nvarchar(64)

MD_ITStatus_AuditKey

DW_AuditKey

bigint

MD_ITStatus_Timestamp

<None>

timestamp