Dict-Physical

Table MD_IssueTrackingUser

Card of table MD_IssueTrackingUser

Name	MD_IssueTrackingUser
Dimensional Type	Dimension
Comment	A generic container for basically anyone listed as a client/user 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 + the system name (defaults to WebHelpDesk). Note 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. 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. Also, administrators of ticket-tracking systems typically use their client/user fields for things other than people. At Carleton, for example, we create clients/users that are actually rooms, and assign machines in labs to those clients. As a result, we need this dimension, and can't simply use a generic employee dimension in the data warehouse.

Check constraint name of the table MD_IssueTrackingUser

CKT_MD_ISSUETRACKINGUSER

List of incoming references of the table MD_IssueTrackingUser

Relationship_128

MF_IssueTrackingAssetValue

MD_ITUser_SurrogateKey

Relationship_251

MF_KeyedComputerInUse

MD_ITUser_SurrogateKey

Relationship_252

MF_KeyedComputerSoftwareUsage

MD_ITUser_SurrogateKey

Relationship_261

MF_KeyedComputerEvent

MD_ITUser_SurrogateKey

Relationship_ClientToTicket

MF_IssueTrackingTicket

MD_ITUser_SurrogateKeyClient

List of referencing views of the table MD_IssueTrackingUser

VMD_IssueTrackingUser

VMD_ISSUETRACKINGUSER

List of diagrams containing the table MD_IssueTrackingUser

IssueTrackingDiagram

List of columns of the table MD_IssueTrackingUser

MD_ITUser_SurrogateKey

<None>

numeric

MD_ITUser_ID

Unique ID for user, taken from the system named in MD_ITTech_IssueTrackingSystem.

DW_CodeDesc

varchar(32)

MD_ITUser_IssueTrackingSystem

Name of issue tracking system. We may have multiple systems, and their user list may end up overlapping, or not, 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_ITUser_GivenName

DW_GivenName

nvarchar(32)

MD_ITUser_Surname

DW_Surname

nvarchar(32)

MD_ITUser_DeptAbbrev

Department for a user in our issue tracking system. Note that a department may also be associated with each trouble ticket, and in some cases that value may not match the value here. And one or both may be 'Unknown.'

DW_DepartmentCode

char(5)

MD_ITUser_Location

DW_CodeDesc

varchar(32)

MD_ITUser_Room

DW_CodeDesc

varchar(32)

MD_ITUser_ColleagueID

DW_ColleagueID

char(7)

MD_ITUser_IsActive

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

DW_YesNoOrUnknown

varchar(7)

MD_ITUser_AuditKey

DW_AuditKey

bigint

MD_ITUser_Timestamp

<None>

timestamp

List of indexes of the table MD_IssueTrackingUser

MD_ISSUETRACKINGUSER_PK

TRUE

FALSE

MD_IssueTrackingUser

MD_ISSUETRACKINGUSER_AK

TRUE

FALSE

TRUE

MD_IssueTrackingUser

List of keys of the table MD_IssueTrackingUser

Identifier_1

AltKey

Home