|
Name |
|
|
Comment |
See docs on MD_IssueTrackingTech in the StarsIssueTracking package. |
|
Dimensional Type |
Dimension |
|
select |
|
Name |
Child Table/View |
|
ViewReference_117 |
|
Name |
|
Name |
|
Grant |
User |
|
SELECT,VIEW DEFINITION |
IssueTrackingReader |
|
Name |
Data Type |
Comment |
Length |
|
MD_ITTech_SurrogateKey |
numeric |
|
|
|
MD_ITTech_ID |
varchar(32) |
Unique ID for tech taken from the system named in MD_ITTech_IssueTrackingSystem. |
|
|
MD_ITTech_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_ITTech_GivenName |
nvarchar(32) |
|
|
|
MD_ITTech_Surname |
nvarchar(32) |
|
|
|
MD_ITTech_DeptAbbrev |
char(5) |
Department associated with a given tech. This field is not well maintained in Web Help Desk as of 2010. |
|
|
MD_ITTech_Room |
varchar(32) |
|
|
|
MD_ITTech_Supervisor |
nvarchar(64) |
|
|
|
MD_ITTech_IsActive |
varchar(7) |
'Yes' if a tech is labeled inactive or is marked deleted. |
|
|
|
|