Dict-Physical

Table MD_IssueTrackingTechGroup

Card of table MD_IssueTrackingTechGroup

Name	MD_IssueTrackingTechGroup
Dimensional Type	Dimension
Comment	Tech group that responds to issue tracking tickets. Note that although some trouble tickets in our system(s) of record may come in with no tech group, 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_IssueTrackingTechGroup

CKT_MD_ISSUETRACKINGTECHGROUP

List of incoming references of the table MD_IssueTrackingTechGroup

Relationship_118

MF_IssueTrackingTicket

MD_ITTechGroup_SurrogateKey

List of referencing views of the table MD_IssueTrackingTechGroup

VMD_IssueTrackingTechGroup

VMD_ISSUETRACKINGTECHGROUP

List of diagrams containing the table MD_IssueTrackingTechGroup

IssueTrackingDiagram

List of columns of the table MD_IssueTrackingTechGroup

MD_ITTechGroup_SurrogateKey

<None>

numeric

MD_ITTechGroup_ID

DW_CodeDesc

varchar(32)

MD_ITTechGroup_IssueTrackingSystem

Name of issue tracking system. We may have multiple systems, and their tech group names will probably end up differing, or worse yet, 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_ITTechGroup_Name

DW_CommonName

nvarchar(64)

MD_ITTechGroup_Manager

DW_CommonName

nvarchar(64)

MD_ITTechGroup_AuditKey

DW_AuditKey

bigint

MD_ITTechGroup_Timestamp