Database Reference
In-Depth Information
I.Impact_IncidentImpactId = IImpact.IncidentImpactId
LEFT OUTER JOIN DisplayStringDimvw IImpactDS ON
IImpact.EnumTypeId = IImpactDS.BaseManagedEntityId
AND IImpactDS.LanguageCode = 'ENU'
LEFT OUTER JOIN IncidentUrgencyvw IUrgency ON
I.Urgency_IncidentUrgencyId =
IUrgency.IncidentUrgencyId
LEFT OUTER JOIN DisplayStringDimvw IUrgencyDS ON
IUrgency.EnumTypeId = IUrgencyDS.BaseManagedEntityId
AND IUrgencyDS.LanguageCode = 'ENU'
LEFT OUTER JOIN IncidentSourcevw ISource ON
I.Source_IncidentSourceId = ISource.IncidentSourceId
LEFT OUTER JOIN DisplayStringDimvw ISourceDS ON
ISource.EnumTypeId = ISourceDS.BaseManagedEntityId
AND ISourceDS.LanguageCode = 'ENU'
LEFT OUTER JOIN IncidentTierQueuesvw ITierQueue ON
I.TierQueue_IncidentTierQueuesId =
ITierQueue.IncidentTierQueuesId
LEFT OUTER JOIN DisplayStringDimvw ITierQueueDS ON
ITierQueue.EnumTypeId =
ITierQueueDS.BaseManagedEntityId
AND ITierQueueDS.LanguageCode = 'ENU'
LEFT OUTER JOIN IncidentClassificationvw
IClassification ON
I.Classification_IncidentClassificationId =
IClassification.IncidentClassificationId
LEFT OUTER JOIN DisplayStringDimvw IClassificationDS ON
IClassification.EnumTypeId =
IClassificationDS.BaseManagedEntityId
AND IClassificationDS.LanguageCode = 'ENU'
LEFT OUTER JOIN IncidentResolutionCategoryvw
IResolutionCategory ON
I.ResolutionCategory_IncidentResolutionCategoryId =
IResolutionCategory.IncidentResolutionCategoryId
