Dict-Physical

Table MD_IssueTrackingTech

Card of table MD_IssueTrackingTech

Name	MD_IssueTrackingTech
Dimensional Type	Dimension
Comment	A generic container for basically anyone listed as a tech in the WebHelpDesk database - or the database for whatever trouble ticket submission/tracking package we happen to be using. Business key is the client ID for the tech + the system name (defaults to WebHelpDesk). Note that the client ID for the tech is different from the client ID for clients in MD_IssueTrackingUser. Note also that there is an 'Unknown' client, intended to make mandatory client, tech, and logged-by joins possible between this dimension and the MF_IssueTrackingTicket fact table, even if this information is not available. Unlike other 'people' dimensions, this dimension does not track changes. It is a type-I-SCD-only dimension. This dimension is needed (rather than just reusing other 'people' dimensions in the data warehouse) because people may exist in one or another ticket-tracking system that don't exist in any other system of record. Or, people may exist in a given ticket tracking system that exist elsewhere, in 'official' people dimensions, but that can't be joined appropriately, due to typographical errors or out-of-date information.

Check constraint name of the table MD_IssueTrackingTech

CKT_MD_ISSUETRACKINGTECH

List of incoming references of the table MD_IssueTrackingTech

Relationship_LoggedByToTicket

MF_IssueTrackingTicket

MD_ITUser_SurrogateKeyLoggedBy

Relationship_TechToTicket

MF_IssueTrackingTicket

MD_ITTech_SurrogateKey

List of referencing views of the table MD_IssueTrackingTech

VMD_IssueTrackingLoggedBy

VMD_ISSUETRACKINGLOGGEDBY

VMD_IssueTrackingTech

VMD_ISSUETRACKINGTECH

List of diagrams containing the table MD_IssueTrackingTech

IssueTrackingDiagram

List of columns of the table MD_IssueTrackingTech

MD_ITTech_SurrogateKey

<None>

numeric

MD_ITTech_ID

Unique ID for tech taken from the system named in MD_ITTech_IssueTrackingSystem.

DW_CodeDesc

varchar(32)

MD_ITTech_IssueTrackingSystem

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

DW_GivenName

nvarchar(32)

MD_ITTech_Surname

DW_Surname

nvarchar(32)

MD_ITTech_DeptAbbrev

Department associated with a given tech. This field is not well maintained in Web Help Desk as of 2010.

DW_DepartmentCode

char(5)

MD_ITTech_Room

DW_CodeDesc

varchar(32)

MD_ITTech_Supervisor

DW_CommonName

nvarchar(64)

MD_ITTech_IsActive

'Yes' if a tech is labeled inactive or is marked deleted.

DW_YesNoOrUnknown

varchar(7)

MD_ITTech_AuditKey

DW_AuditKey

bigint

MD_ITTech_Timestamp

<None>

timestamp

List of indexes of the table MD_IssueTrackingTech

MD_ISSUETRACKINGTECH_PK

TRUE

FALSE

MD_IssueTrackingTech

MD_ISSUETRACKINGTECH_AK

TRUE

FALSE

TRUE

MD_IssueTrackingTech

List of keys of the table MD_IssueTrackingTech

Identifier_1

AltKey

Home