Dict-Physical

View VMD_IssueTrackingLoggedBy

Card of view VMD_IssueTrackingLoggedBy

Name	VMD_IssueTrackingLoggedBy
Comment	This is a role-playing dimension - basically just an alternate projection of VMD_IssueTrackingTech, and holds information on technical people assigned to tickets in our ticket-tracking or issue-tracking system. It links up specifically with VMF_IssueTrackingTicket, to give us information on the tech who initially logged a given ticket.
Dimensional Type	Dimension

SQL query of the view VMD_IssueTrackingLoggedBy

select
MD_ITTech_SurrogateKey AS MD_ITLogBy_SurrogateKey,
MD_ITTech_ID AS MD_ITLogBy_ID,
MD_ITTech_IssueTrackingSystem AS MD_ITLogBy_IssueTrackingSystem,
MD_ITTech_GivenName AS MD_ITLogBy_GivenName,
MD_ITTech_Surname AS MD_ITLogBy_Surname,
MD_ITTech_DeptAbbrev AS MD_ITLogBy_DeptAbbrev,
MD_ITTech_IsActive AS MD_ITLogBy_IsActive
from
MD_ISSUETRACKINGTECH

List of incoming view references of the view VMD_IssueTrackingLoggedBy

ViewReference_129

VMF_IssueTrackingTicket

List of referenced objects of the view VMD_IssueTrackingLoggedBy

MD_IssueTrackingTech

List of diagrams containing the view VMD_IssueTrackingLoggedBy

ViewsIssueTrackingDiagram

List of permissions of the view VMD_IssueTrackingLoggedBy

SELECT,VIEW DEFINITION

IssueTrackingReader

List of view columns of the view VMD_IssueTrackingLoggedBy

MD_ITLogBy_SurrogateKey

numeric

MD_ITLogBy_ID

varchar(32)

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

MD_ITLogBy_IssueTrackingSystem

nvarchar(64)

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.

MD_ITLogBy_GivenName

nvarchar(32)

MD_ITLogBy_Surname

nvarchar(32)

MD_ITLogBy_DeptAbbrev

char(5)

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

MD_ITLogBy_Room

varchar(7)

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

Home