View VMF_IssueTrackingTicket

Card of view VMF_IssueTrackingTicket

Name

VMF_IssueTrackingTicket

Comment

See documentation on MF_IssueTrackingTicket in the StarsIssueTracking package.

Dimensional Type

Fact


SQL query of the view VMF_IssueTrackingTicket

select
MF_ITTicket_ID,
MF_ITTicket_IssueTrackingSystem,
MD_ITStatus_SurrogateKey,
MD_ITPriority_SurrogateKey,
MD_ITProblemType_SurrogateKey,
MD_ITTechGroup_SurrogateKey,
MD_ITAsset_SurrogateKey,
MD_Room_SurrogateKey,
MD_Building_SurrogateKey,
MD_CarlDept_SurrogateKey,
MD_CollPers_SurrogateKeyEmp,
MD_CollPers_SurrogateKeyDStu,
MD_ITTech_SurrogateKey,
MD_ITUser_SurrogateKeyClient,
MD_ITUser_SurrogateKeyLoggedBy,
MF_ITTicket_ReportDate,
MF_ITTicket_ReportTime,
MF_ITTicket_FirstResponseDate,
MF_ITTicket_FirstResponseTime,
MF_ITTicket_WorkStartDate,
MF_ITTicket_WorkStartTime,
MF_ITTicket_WorkEndDate,
MF_ITTicket_WorkEndTime,
MF_ITTicket_CloseDate,
MF_ITTicket_CloseTime,
MF_ITTicket_TicketTimeAsOfLastUpdate,
MF_ITTicket_ElapsedTime,
MF_ITTicket_IsDeleted,
1 AS MF_ITTicket_Count
from
MF_ISSUETRACKINGTICKET


List of outgoing view references of the view VMF_IssueTrackingTicket

Name

Parent Table/View

ViewReference_103

VMD_CarletonDepartment (Shortcut)

ViewReference_105

VMD_IssueTrackingAsset

ViewReference_106

VMD_IssueTrackingUser

ViewReference_107

VMD_Time (Shortcut)

ViewReference_108

VMD_Date (Shortcut)

ViewReference_109

VMD_Room

ViewReference_110

VMD_Building

ViewReference_111

VMD_IssueTrackingProblemType

ViewReference_112

VMD_IssueTrackingPriority

ViewReference_113

VMD_IssueTrackingTechGroup

ViewReference_114

VMD_IssueTrackingStatus

ViewReference_115

VMD_DegreeStudent (Shortcut)

ViewReference_116

VMD_Employee (Shortcut)

ViewReference_117

VMD_IssueTrackingTech

ViewReference_118

VMD_IssueTrackingUser

ViewReference_129

VMD_IssueTrackingLoggedBy


List of referenced objects of the view VMF_IssueTrackingTicket

Name

MF_IssueTrackingTicket


List of diagrams containing the view VMF_IssueTrackingTicket

Name

ViewsIssueTrackingDiagram


List of permissions of the view VMF_IssueTrackingTicket

Grant

User

SELECT,VIEW DEFINITION

IssueTrackingReader


List of view columns of the view VMF_IssueTrackingTicket

Name

Data Type

Comment

Length

MF_ITTicket_ID

varchar(32)

Degenerate dimension housing the unique key for a given trouble ticket in a given help desk system. See MD_ITTicket_IssueTrackingSystem attribute for the generic name of the system. This also is a degenerate dimension.

 

MF_ITTicket_IssueTrackingSystem

nvarchar(64)

Name of system from which the MF_ITTicket_TicketID was extracted.

 

MD_ITStatus_SurrogateKey

numeric

 

 

MD_ITPriority_SurrogateKey

numeric

 

 

MD_ITProblemType_SurrogateKey

numeric

 

 

MD_ITTechGroup_SurrogateKey

numeric

 

 

MD_ITAsset_SurrogateKey

numeric

 

 

MD_Room_SurrogateKey

numeric

 

 

MD_Building_SurrogateKey

numeric

Foreign key pointing to a building in MD_Building. Note that Web Help Desk doesn't have buildings per se. Buildings are inferred, in general, from rooms.

 

MD_CarlDept_SurrogateKey

numeric

 

 

MD_CollPers_SurrogateKeyEmp

numeric

 

 

MD_CollPers_SurrogateKeyDStu

numeric

 

 

MD_ITTech_SurrogateKey

numeric

 

 

MD_ITUser_SurrogateKeyClient

numeric

 

 

MD_ITUser_SurrogateKeyLoggedBy

numeric

 

 

MF_ITTicket_ReportDate

int

Integer representation of the date (e.g., 20070101 for 1 Jan 2007). Defaults to 99991231, for situations where a date is required but none is available.

 

MF_ITTicket_ReportTime

int

Integer representing the time of day in the format HHMMSS (e.g., 23:01:01 at one minute one second after eleven o'clock in the evening). Not typically used for reporting.

Unlike MD_Date_Dateinteger (in MD_Date), this integer is not really human-readable, because it's not set up for base-10. Rather, it's calculated using the formula: (hour << 16) Or (min << 8) Or (sec), where the Or's are logical, and the << operator is a binary left shift.

 

MF_ITTicket_FirstResponseDate

int

Integer representation of the date (e.g., 20070101 for 1 Jan 2007). Defaults to 99991231, for situations where a date is required but none is available.

 

MF_ITTicket_FirstResponseTime

int

Integer representing the time of day in the format HHMMSS (e.g., 23:01:01 at one minute one second after eleven o'clock in the evening). Not typically used for reporting.

Unlike MD_Date_Dateinteger (in MD_Date), this integer is not really human-readable, because it's not set up for base-10. Rather, it's calculated using the formula: (hour << 16) Or (min << 8) Or (sec), where the Or's are logical, and the << operator is a binary left shift.

 

MF_ITTicket_WorkStartDate

int

Integer representation of the date (e.g., 20070101 for 1 Jan 2007). Defaults to 99991231, for situations where a date is required but none is available.

 

MF_ITTicket_WorkStartTime

int

Integer representing the time of day in the format HHMMSS (e.g., 23:01:01 at one minute one second after eleven o'clock in the evening). Not typically used for reporting.

Unlike MD_Date_Dateinteger (in MD_Date), this integer is not really human-readable, because it's not set up for base-10. Rather, it's calculated using the formula: (hour << 16) Or (min << 8) Or (sec), where the Or's are logical, and the << operator is a binary left shift.

 

MF_ITTicket_WorkEndDate

int

Integer representation of the date (e.g., 20070101 for 1 Jan 2007). Defaults to 99991231, for situations where a date is required but none is available.

 

MF_ITTicket_WorkEndTime

int

Integer representing the time of day in the format HHMMSS (e.g., 23:01:01 at one minute one second after eleven o'clock in the evening). Not typically used for reporting.

Unlike MD_Date_Dateinteger (in MD_Date), this integer is not really human-readable, because it's not set up for base-10. Rather, it's calculated using the formula: (hour << 16) Or (min << 8) Or (sec), where the Or's are logical, and the << operator is a binary left shift.

 

MF_ITTicket_CloseDate

int

Integer representation of the date (e.g., 20070101 for 1 Jan 2007). Defaults to 99991231, for situations where a date is required but none is available.

 

MF_ITTicket_CloseTime

int

Integer representing the time of day in the format HHMMSS (e.g., 23:01:01 at one minute one second after eleven o'clock in the evening). Not typically used for reporting.

Unlike MD_Date_Dateinteger (in MD_Date), this integer is not really human-readable, because it's not set up for base-10. Rather, it's calculated using the formula: (hour << 16) Or (min << 8) Or (sec), where the Or's are logical, and the << operator is a binary left shift.

 

MF_ITTicket_TicketTimeAsOfLastUpdate

int

Integer reflecting the amount of time a given ticket has been open as of the last update, in minutes.

Will be set to zero if a ticket has been deleted.

 

MF_ITTicket_ElapsedTime

int

Integer representing the amount of time elapsed, in minutes, between when a ticket was initially set up or reported (MD_ITTicket_ReportDate) and either now, or time ticket close datetime, whichever is less (earlier in time). If a ticket was deleted, it is marked as MF_ITTicket_IsDeleted = 'Yes', and this field is set to zero.

This figure is naturally current only as of the last time this fact table was updated.

The elapsed time does not take into account periods where a ticket is idling. For that, see MF_ITTicket_TicketTimeAsOfLastUpdate.

 

MF_ITTicket_IsDeleted

char(3)

Degenerate dimension. 'Yes' if a ticket has been deleted. 'No' otherwise.

Having this flag allows us not to actually delete deleted tickets. Instead we simply mark them as deleted (as Web Help Desk does). When a ticket is deleted, though, we do set the TicketTime and TicketTimeAsOfLastUpdate to zero.

 

MF_ITTicket_Count

 

 

 


Previous
Home
Next