Data Warehouse Views - Latest

Last updated
Save as PDF

1. Description

It is a Management Data Warehouse, which is a form of a database that contains data collected from a server. All the data is maintained in the form of tables, which contain a schema. This data is used for generating custom reports for an Organization for in-depth data analysis.

CMO Data Warehouse is hosted on SQL Server.

2. Views in Data Warehouse

Views in the Data Warehouse represent the data that a user can see in the CMO web application.

Currently, there are four Views in the CMO Data Warehouse, which are as follows:

1. Action

2. Event

3. Finding

4. Obligation

View 1 – Tables used in Action Views and their corresponding columns

S. No	Tables Used in Action Views	Columns in Tables	Data Type
1.	DimAction	ActionNumber	nvarchar
2.	DimAction	ActionNumber	sysname
3.	DimAction	ActionRiskName	nvarchar
4.	DimAction	ActionRiskName	sysname
5.	DimAction	ActionRiskScore	int
6.	DimAction	ActionText	nvarchar
7.	DimAction	ActionText	sysname
8.	DimAction	ApprovedDateTime	datetime
9.	DimAction	CompletedDateTime	datetime
10.	DimAction	CreatedDateTime	datetime
11.	DimAction	DimActionId	int
12.	DimAction	DimActionPriorityId	int
13.	DimAction	DimActionRiskConsequenceId	int
14.	DimAction	DimActionRiskLikelihoodId	int
15.	DimAction	DimActionStatusId	int
16.	DimAction	DimApprovedByUserId	int
17.	DimAction	DimBranchId	int
18.	DimAction	DimCompletedByUserId	int
19.	DimAction	DimCreatedByUserId	int
20.	DimAction	DimEntityId	int
21.	DimAction	DimEventSegmentId	int
22.	DimAction	DimFindingId	int
23.	DimAction	DimOrgUnitId	int
24.	DimAction	DimParentActionId	int
25.	DimAction	DimResponsibleUserId	int
26.	DimAction	DueDateTime	datetime
27.	DimAction	LastUpdatedDateTime	datetime2
28.	DimAction	OriginalActionId	uniqueidentifier
29.	DimAction	Pending	int
30.	DimAction	RequestExtensionDateTime	datetime2
31.	DimActionAttachment	CreatedDateTime	datetime2
32.	DimActionAttachment	DimActionAttachmentId	int
33.	DimActionAttachment	DimActionCommentId	int
34.	DimActionAttachment	DimActionId	int
35.	DimActionAttachment	DimAttachmentTypeId	int
36.	DimActionAttachment	DimCreatedDateId	int
37.	DimActionAttachment	DimModifiedDateId	int
38.	DimActionAttachment	DimUploadedFileId	int
39.	DimActionAttachment	DimUserId	int
40.	DimActionAttachment	IsConfidential	bit
41.	DimActionAttachment	ModifiedDateTime	datetime2
42.	DimActionAttachment	OriginalActionAttachmentId	uniqueidentifier
43.	DimActionCategory	ActionCategoryName	nvarchar
44.	DimActionCategory	ActionCategoryName	sysname
45.	DimActionCategory	DimActionCategoryId	int
46.	DimActionCategory	DimBranchId	int
47.	DimActionCategory	DimParentActionCategoryId	int
48.	DimActionCategory	OriginalActionCategoryId	int
49.	DimActionComment	ActionCommentLogDateTime	datetime
50.	DimActionComment	ActionCommentText	nvarchar
51.	DimActionComment	ActionCommentText	sysname
52.	DimActionComment	DimActionCommentId	int
53.	DimActionComment	DimActionCommentLogDateId	int
54.	DimActionComment	DimActionId	int
55.	DimActionComment	DimUserId	int
56.	DimActionComment	OriginalActionCommentId	uniqueidentifier
57.	DimActionCustomField	ActionCustomFieldName	nvarchar
58.	DimActionCustomField	ActionCustomFieldName	sysname
59.	DimActionCustomField	ActionCustomFieldTypeId	int
60.	DimActionCustomField	ActionCustomFieldValue	nvarchar
61.	DimActionCustomField	ActionCustomFieldValue	sysname
62.	DimActionCustomField	CustomFieldId	int
63.	DimActionCustomField	DimActionCustomFieldId	int
64.	DimActionCustomField	DimActionId	int
65.	DimActionCustomField	OriginalActionCustomFieldId	uniqueidentifier
66.	DimActionPriority	ActionPriorityName	nvarchar
67.	DimActionPriority	ActionPriorityName	sysname
68.	DimActionPriority	DimActionPriorityId	int
69.	DimActionPriority	DimBranchId	int
70.	DimActionPriority	OriginalActionPriorityId	uniqueidentifier
71.	DimActionStatus	ActionStatusName	nvarchar
72.	DimActionStatus	ActionStatusName	sysname
73.	DimActionStatus	CanBeOverdue	bit
74.	DimActionStatus	DimActionStatusId	int
75.	DimActionStatus	DimBranchId	int
76.	DimActionStatus	OriginalActionStatusId	int
77.	DimActionVerifyInfo	CreatedDateTime	datetime
78.	DimActionVerifyInfo	DimActionId	int
79.	DimActionVerifyInfo	DimActionVerifyInfoId	int
80.	DimActionVerifyInfo	DimVerifiedByUserId	int
81.	DimActionVerifyInfo	DimVerifiedDateTimeId	int
82.	DimActionVerifyInfo	ModifiedDateTime	datetime
83.	DimActionVerifyInfo	OriginalActionVerifyInfoId	uniqueidentifier
84.	DimActionVerifyInfo	VerifiedDateTime	datetime
85.	DimActionWorkflowTransition	ActionWorkflowTransitionName	nvarchar
86.	DimActionWorkflowTransition	ActionWorkflowTransitionName	sysname
87.	DimActionWorkflowTransition	DimActionWorkflowTransitionId	int
88.	DimActionWorkflowTransition	OriginalActionWorkflowTransitionId	uniqueidentifier

View 2 - Tables used in Event Views and their corresponding columns

S. No	Tables Used in Event Views	Columns in Tables	Data Type
1.	DimEvent	DimAuditorUserId	int
2.	DimEvent	DimBranchId	int
3.	DimEvent	DimCreatedFromEventId	int
4.	Dim Event	DimEntityId	int
5.	DimEvent	DimEventCreatedByUserId	int
6.	DimEvent	DimEventId	int
7.	DimEvent	DimEventRiskConsequenceId	int
8.	DimEvent	DimEventRiskLikelihoodId	int
9.	DimEvent	DimEventStatusId	int
10.	DimEvent	DimEventSubStatusId	int
11.	DimEvent	DimEventTemplateId	int
12.	DimEvent	DimEventVerifiedByUserId	int
13.	DimEvent	DimOrgUnitId	int
14.	DimEvent	EventCommencedDateTime	datetime
15.	DimEvent	EventCompletedDateTime	datetime
16.	DimEvent	EventCreatedDateTime	datetime
17.	DimEvent	EventDateTime	datetime
18.	DimEvent	EventDueDateTime	datetime
19.	DimEvent	EventFindings	nvarchar
20.	DimEvent	EventFindings	sysname
21.	DimEvent	EventInReviewDateTime	datetime
22.	DimEvent	EventLatitude	float
23.	DimEvent	EventLongitude	float
24.	DimEvent	EventManualScore	float
25.	DimEvent	EventName	nvarchar
26.	DimEvent	EventName	sysname
27.	DimEvent	EventNotes	nvarchar
28.	DimEvent	EventNotes	sysname
29.	DimEvent	EventNumber	nvarchar
30.	DimEvent	EventNumber	sysname
31.	DimEvent	EventPossibleScore	float
32.	Dim Event	EventRecommendations	nvarchar
33.	DimEvent	EventRecommendations	sysname
34.	DimEvent	EventRiskName	nvarchar
35.	DimEvent	EventRiskName	sysname
36.	DimEvent	EventRiskScore	int
37.	DimEvent	EventScore	float
38.	DimEvent	EventStartDateTime	datetime
39.	DimEvent	EventVerifiedDateTime	datetime
40.	DimEvent	IsConfidential	bit
41.	DimEvent	LastUpdatedDateTime	datetime2
42.	DimEvent	OriginalEventId	uniqueidentifier
43.	DimEventConfidentialUser	DimEventId	int
44.	DimEventConfidentialUser	DimUserId	int
45.	DimEventCustomField	CustomFieldId	int
46.	DimEventCustomField	DimEventCustomFieldId	int
47.	DimEventCustomField	DimEventId	int
48.	DimEventCustomField	EventCustomFieldName	nvarchar
49.	DimEventCustomField	EventCustomFieldName	sysname
50.	DimEventCustomField	EventCustomFieldTypeId	int
51.	DimEventCustomField	EventCustomFieldValue	nvarchar
52.	DimEventCustomField	EventCustomFieldValue	sysname
53.	DimEventCustomField	OriginalEventCustomFieldId	uniqueidentifier
54.	DimEventField	DimEventFieldId	int
55.	DimEventField	DimEventSegmentId	int
56.	DimEventField	DimEventTemplateFieldId	int
57.	DimEventField	EventFieldScore	float
58.	DimEventField	EventFieldValue	nvarchar
59.	DimEventField	EventFieldValue	sysname
60.	DimEventField	OriginalEventFieldId	uniqueidentifier
61.	DimEventLostTime	DimEventLostTimeId	int
62.	DimEventLostTime	DimEventPartyInvolvedId	int
63.	DimEventLostTime	DimEventSegmentId	int
64.	DimEventLostTime	DimLostTimeTypeId	int
65.	DimEventLostTime	DimUserId	int
66.	DimEventLostTime	EventLostTimeIsOngoing	bit
67.	DimEventLostTime	EventLostTimeMonth	int
68.	DimEventLostTime	EventLostTimeNumberOfDays	decimal
69.	DimEventLostTime	EventLostTimeYear	int
70.	DimEventLostTime	OriginalEventLostTimeId	uniqueidentifier
71.	DimEventMasterTemplate	DimBranchId	int
72.	DimEventMasterTemplate	DimEventMasterTemplateId	int
73.	DimEventMasterTemplate	EventMasterTemplateDescription	nvarchar
74.	DimEventMasterTemplate	EventMasterTemplateDescription	sysname
75.	DimEventMasterTemplate	EventMasterTemplateName	nvarchar
76.	DimEventMasterTemplate	EventMasterTemplateName	sysname
77.	DimEventMasterTemplate	OriginalEventMasterTemplateId	uniqueidentifier
78.	DimEventMasterTemplate	UniqueId	int
79.	DimEventNote	DimEventId	int
80.	DimEventNote	DimEventNoteDateId	int
81.	DimEventNote	DimEventNoteId	int
82.	DimEventNote	DimUserId	int
83.	DimEventNote	EventNote	nvarchar
84.	DimEventNote	EventNote	sysname
85.	DimEventNote	EventNoteDateTime	datetime
86.	DimEventNote	OriginalEventNoteId	int
87.	DimEventPartyInvolved	DimEventId	int
88.	DimEventPartyInvolved	DimEventPartyInvolvedId	int
89.	DimEventPartyInvolved	DimInvolvementTypeId	int
90.	DimEventPartyInvolved	DimUserId	int
91.	DimEventPartyInvolved	EventPartyInvolvedComments	nvarchar
92.	DimEventPartyInvolved	EventPartyInvolvedComments	sysname
93.	DimEventPartyInvolved	EventPartyInvolvedDateTime	datetime
94.	DimEventPartyInvolved	OriginalEventPartyInvolvedId	uniqueidentifier
95.	DimEventSection	DimEventId	int
96.	DimEventSection	DimEventSectionId	int
97.	DimEventSection	DimEventTemplateSectionId	int
98.	DimEventSection	DimParentEventSectionId	int
99.	DimEventSection	EventSectionPossibleScore	float
100.	DimEventSection	EventSectionScore	float
101.	DimEventSection	OriginalEventSectionId	uniqueidentifier
102.	DimEventSectionSequence	DimEventId	int
103.	DimEventSectionSequence	DimEventSectionId	int
104.	DimEventSectionSequence	DimEventSectionSequenceId	int
105.	DimEventSectionSequence	DimEventTemplateSectionId	int
106.	DimEventSectionSequence	EventSectionFullSequence	nvarchar
107.	DimEventSectionSequence	EventSectionFullSequence	sysname
108.	DimEventSectionSequence	EventSectionSequence	int
109.	DimEventSectionSequence	EventSectionSort	float
110.	DimEventSectionSequence	OriginalEventSectionSequenceId	int
111.	DimEventSegment	DimEventSectionId	int
112.	DimEventSegment	DimEventSegmentId	int
113.	DimEventSegment	DimEventTemplateSegmentId	int
114.	DimEventSegment	DimObligationId	int
115.	DimEventSegment	EventSegmentPossibleScore	float
116.	DimEventSegment	EventSegmentScore	float
117.	DimEventSegment	OriginalEventSegmentId	uniqueidentifier
118.	DimEventSegmentAttachment	CreatedDateTime	datetime2
119.	DimEventSegmentAttachment	DimAttachmentTypeId	int
120.	DimEventSegmentAttachment	DimCreatedDateId	int
121.	DimEventSegmentAttachment	DimEventSegmentAttachmentId	int
122.	DimEventSegmentAttachment	DimEventSegmentId	int
123.	DimEventSegmentAttachment	DimModifiedDateId	int
124.	DimEventSegmentAttachment	DimUploadedFileId	int
125.	DimEventSegmentAttachment	DimUserId	int
126.	DimEventSegmentAttachment	IsConfidential	bit
127.	DimEventSegmentAttachment	ModifiedDateTime	datetime2
128.	DimEventSegmentAttachment	OriginalEventSegmentAttachmentId	uniqueidentifier
129.	DimEventStatus	DimBranchId	int
130.	DimEventStatus	DimEventStatusId	int
131.	DimEventStatus	EventStatusCode	int
132.	DimEventStatus	EventStatusColorId	int
133.	DimEventStatus	EventStatusName	nvarchar
134.	DimEventStatus	EventStatusName	sysname
135.	DimEventStatus	OriginalEventStatusId	int
136.	DimEventSubStatus	DimBranchId	int
137.	DimEventSubStatus	DimEventSubStatusId	int
138.	DimEventSubStatus	EventSubStatusName	nvarchar
139.	DimEventSubStatus	EventSubStatusName	sysname
140.	DimEventSubStatus	OriginalEventSubStatusId	int
141.	DimEventTemplate	DimBranchId	int
142.	DimEventTemplate	DimEventMasterTemplateId	int
143.	DimEventTemplate	DimEventTemplateId	int
144.	DimEventTemplate	EventTemplateDescription	nvarchar
145.	DimEventTemplate	EventTemplateDescription	sysname
146.	DimEventTemplate	EventTemplateName	nvarchar
147.	DimEventTemplate	EventTemplateName	sysname
148.	DimEventTemplate	EventTemplateRevisionNumber	int
149.	DimEventTemplate	OriginalEventTemplateId	int
150.	DimEventTemplateCategory	DimBranchId	int
151.	DimEventTemplateCategory	DimEventTemplateCategoryId	int
152.	DimEventTemplateCategory	DimParentEventTemplateCategoryId	int
153.	DimEventTemplateCategory	EventTemplateCategoryName	nvarchar
154.	DimEventTemplateCategory	EventTemplateCategoryName	sysname
155.	DimEventTemplateCategory	OriginalEventTemplateCategoryId	int
156.	DimEventTemplateClass	DimBranchId	int
157.	DimEventTemplateClass	DimEventTemplateClassId	int
158.	DimEventTemplateClass	DimParentEventTemplateClassId	int
159.	DimEventTemplateClass	EventTemplateClassName	nvarchar
160.	DimEventTemplateClass	EventTemplateClassName	sysname
161.	DimEventTemplateClass	OriginalEventTemplateClassId	int
162.	DimEventTemplateField	DimEventTemplateFieldId	int
163.	DimEventTemplateField	DimEventTemplateFieldTypeId	int
164.	DimEventTemplateField	DimEventTemplateSegmentId	int
165.	DimEventTemplateField	EventTemplateFieldAlias	nvarchar
166.	DimEventTemplateField	EventTemplateFieldAlias	sysname
167.	DimEventTemplateField	EventTemplateFieldLabel	nvarchar
168.	DimEventTemplateField	EventTemplateFieldLabel	sysname
169.	DimEventTemplateField	EventTemplateFieldMasterId	uniqueidentifier
170.	DimEventTemplateField	EventTemplateFieldScore	float
171.	DimEventTemplateField	OriginalEventTemplateFieldId	int
172.	DimEventTemplateFieldType	DimEventTemplateFieldTypeId	int
173.	DimEventTemplateFieldType	EventTemplateFieldTypeName	nvarchar
174.	DimEventTemplateFieldType	EventTemplateFieldTypeName	sysname
175.	DimEventTemplateSection	DimEventTemplateID	int
176.	DimEventTemplateSection	DimEventTemplateSectionId	int
177.	DimEventTemplateSection	DimParentEventTemplateSectionId	int
178.	DimEventTemplateSection	EventTemplateSectionMasterId	uniqueidentifier
179.	DimEventTemplateSection	EventTemplateSectionName	nvarchar
180.	DimEventTemplateSection	EventTemplateSectionName	sysname
181.	DimEventTemplateSection	EventTemplateSectionWeight	int
182.	DimEventTemplateSection	OriginalEventTemplateSectionId	int
183.	DimEventTemplateSegment	DimEventTemplateSectionId	int
184.	DimEventTemplateSegment	DimEventTemplateSegmentId	int
185.	DimEventTemplateSegment	EventTemplateSegmentGuidanceNotes	nvarchar
186.	DimEventTemplateSegment	EventTemplateSegmentGuidanceNotes	sysname
187.	DimEventTemplateSegment	EventTemplateSegmentLabel	nvarchar
188.	DimEventTemplateSegment	EventTemplateSegmentLabel	sysname
189.	DimEventTemplateSegment	EventTemplateSegmentLabelHtml	nvarchar
190.	DimEventTemplateSegment	EventTemplateSegmentLabelHtml	sysname
191.	DimEventTemplateSegment	EventTemplateSegmentMasterId	uniqueidentifier
192.	DimEventTemplateSegment	EventTemplateSegmentPossibleScore	float
193.	DimEventTemplateSegment	OriginalEventTemplateSegmentId	int
194.	DimEventWorkflow	DimEventId	int
195.	DimEventWorkflow	DimEventWorkflowId	int
196.	DimEventWorkflow	DimEventWorkFlowStartedByUserId	int
197.	DimEventWorkflow	DimEventWorkflowStartedDateId	int
198.	DimEventWorkflow	DimEventWorkFlowTerminatedByUserId	int
199.	DimEventWorkflow	DimEventWorkFlowTerminatedDateId	int
200.	DimEventWorkflow	EventWorkflowNote	nvarchar
201.	DimEventWorkflow	EventWorkflowNote	sysname
202.	DimEventWorkflow	EventWorkFlowStartedDateTime	datetime
203.	DimEventWorkflow	EventWorkFlowTerminatedDateTime	datetime
204.	DimEventWorkflow	OriginalEventWorkflowId	int
205.	DimEventWorkflowStep	DimActionId	int
206.	DimEventWorkflowStep	DimEventWorkflowId	int
207.	DimEventWorkflowStep	DimEventWorkflowStepId	int
208.	DimEventWorkflowStep	DimResponsibleUserId	int
209.	DimEventWorkflowStep	DimStartedDateId	int
210.	DimEventWorkflowStep	Duration	int
211.	DimEventWorkflowStep	OriginalEventWorkflowStepId	int
212.	DimEventWorkflowStep	StartedDateTime	datetime2
213.	DimEventWorkflowStep	StepName	nvarchar
214.	DimEventWorkflowStep	StepName	sysname

View 3 - Tables used in Finding Views and their corresponding columns

S. No	Tables Used in Finding Views	Columns in Tables	Data Type
1.	DimFinding	DimBranchId	int
2.	DimFinding	DimEntityId	int
3.	DimFinding	DimEventSegmentId	int
4.	DimFinding	DimFindingId	int
5.	DimFinding	DimFindingResidualRiskConsequenceId	int
6.	DimFinding	DimFindingResidualRiskLikelihoodId	int
7.	DimFinding	DimFindingRiskConsequenceId	int
8.	DimFinding	DimFindingRiskLikelihoodId	int
9.	DimFinding	DimFindingStatusId	int
10.	DimFinding	DimFindingTargetRiskConsequenceId	int
11.	DimFinding	DimFindingTargetRiskLikelihoodId	int
12.	DimFinding	DimOrgUnitId	int
13.	DimFinding	DimProcessId	int
14.	DimFinding	DimUserId	int
15.	DimFinding	FindingComment	nvarchar
16.	DimFinding	FindingComment	sysname
17.	DimFinding	FindingDateTime	datetime
18.	DimFinding	FindingNumber	nvarchar
19.	DimFinding	FindingNumber	sysname
20.	DimFinding	FindingRiskName	nvarchar
21.	DimFinding	FindingRiskName	sysname
22.	DimFinding	FindingRiskScore	nvarchar
23.	DimFinding	FindingRiskScore	sysname
24.	DimFinding	FindingText	nvarchar
25.	DimFinding	FindingText	sysname
26.	DimFinding	LastUpdatedDateTime	datetime2
27.	DimFinding	OriginalFindingId	uniqueidentifier
28.	DimFinding	ResidualRiskName	nvarchar
29.	DimFinding	ResidualRiskName	sysname
30.	DimFinding	ResidualRiskScore	nvarchar
31.	DimFinding	ResidualRiskScore	sysname
32.	DimFinding	TargetRiskName	nvarchar
33.	DimFinding	TargetRiskName	sysname
34.	DimFinding	TargetRiskScore	nvarchar
35.	DimFinding	TargetRiskScore	sysname
36.	DimFindingAttachment	CreatedDateTime	datetime2
37.	DimFindingAttachment	DimAttachmentTypeId	int
38.	DimFindingAttachment	DimCreatedDateId	int
39.	DimFindingAttachment	DimFindingAttachmentId	int
40.	DimFindingAttachment	DimFindingId	int
41.	DimFindingAttachment	DimModifiedDateId	int
42.	DimFindingAttachment	DimUploadedFileId	int
43.	DimFindingAttachment	DimUserId	int
44.	DimFindingAttachment	IsConfidential	bit
45.	DimFindingAttachment	ModifiedDateTime	datetime2
46.	DimFindingAttachment	OriginalFindingAttachmentId	uniqueidentifier
47.	DimFindingCategory	DimBranchId	int
48.	DimFindingCategory	DimFindingCategoryId	int
49.	DimFindingCategory	DimParentFindingCategoryId	int
50.	DimFindingCategory	FindingCategoryName	nvarchar
51.	DimFindingCategory	FindingCategoryName	sysname
52.	DimFindingCategory	IsRiskCategory	bit
53.	DimFindingCategory	OriginalFindingCategoryId	int
54.	DimFindingCategory	PercentScoreReduction	int
55.	DimFindingComment	DimFindingCommentId	int
56.	DimFindingComment	DimFindingCommentLogDateId	int
57.	DimFindingComment	DimFindingId	int
58.	DimFindingComment	DimUserId	int
59.	DimFindingComment	FindingCommentLogDateTime	datetime
60.	DimFindingComment	FindingCommentText	nvarchar
61.	DimFindingComment	FindingCommentText	sysname
62.	DimFindingComment	OriginalFindingCommentId	uniqueidentifier
63.	DimFindingCustomField	CustomFieldId	int
64.	DimFindingCustomField	DimFindingCustomFieldId	int
65.	DimFindingCustomField	DimFindingId	int
66.	DimFindingCustomField	FindingCustomFieldName	nvarchar
67.	DimFindingCustomField	FindingCustomFieldName	sysname
68.	DimFindingCustomField	FindingCustomFieldTypeId	int
69.	DimFindingCustomField	FindingCustomFieldValue	nvarchar
70.	DimFindingCustomField	FindingCustomFieldValue	sysname
71.	DimFindingCustomField	OriginalFindingCustomFieldId	uniqueidentifier
72.	DimFindingFramework	DimBranchId	int
73.	DimFindingFramework	DimEntityId	int
74.	DimFindingFramework	DimFindingFrameworkId	int
75.	DimFindingFramework	OriginalFindingFrameworkId	uniqueidentifier
76.	DimFindingStatus	DimFindingStatusId	int
77.	DimFindingStatus	FindingStatusName	nvarchar
78.	DimFindingStatus	FindingStatusName	sysname
79.	DimFindingStatus	OriginalFindingStatusId	int

View 4 - Tables used in Obligation Views and their corresponding columns

S. No	Tables Used in Obligation Views	Columns in Tables	Data Type
1.	DimObligation	DimBranchId	int
2.	DimObligation	DimLicenseAuthorityId	int
3.	DimObligation	DimObligationId	int
4.	DimObligation	DimObligationRiskConsequenceId	int
5.	DimObligation	DimObligationRiskLikelihoodId	int
6.	DimObligation	DimObligationStatusId	int
7.	DimObligation	DimObligationTypeId	int
8.	DimObligation	DimOrgUnitId	int
9.	DimObligation	DimParentObligationId	int
10.	DimObligation	DimResponsibleUserId	int
11.	DimObligation	DimUserId	int
12.	DimObligation	LastUpdatedDateTime	datetime2
13.	DimObligation	ObligationDescription	nvarchar
14.	DimObligation	ObligationDescription	sysname
15.	DimObligation	ObligationDetail	nvarchar
16.	DimObligation	ObligationDetail	sysname
17.	DimObligation	ObligationName	nvarchar
18.	DimObligation	ObligationName	sysname
19.	DimObligation	ObligationNumber	int
20.	DimObligation	ObligationReference	nvarchar
21.	DimObligation	ObligationReference	sysname
22.	DimObligation	ObligationRiskName	nvarchar
23.	DimObligation	ObligationRiskName	sysname
24.	DimObligation	ObligationRiskScore	float
25.	DimObligation	OriginalObligationId	uniqueidentifier
26.	DimObligationAttachment	CreatedDateTime	datetime2
27.	DimObligationAttachment	DimAttachmentTypeId	int
28.	DimObligationAttachment	DimCreatedDateId	int
29.	DimObligationAttachment	DimModifiedDateId	int
30.	DimObligationAttachment	DimObligationAttachmentId	int
31.	DimObligationAttachment	DimObligationId	int
32.	DimObligationAttachment	DimUploadedFileId	int
33.	DimObligationAttachment	DimUserId	int
34.	DimObligationAttachment	ModifiedDateTime	datetime2
35.	DimObligationAttachment	OriginalObligationAttachmentId	uniqueidentifier
36.	DimObligationComment	DimObligationCommentId	int
37.	DimObligationComment	DimObligationCommentLogDateId	int
38.	DimObligationComment	DimObligationId	int
39.	DimObligationComment	DimUserId	int
40.	DimObligationComment	ObligationCommentLogDateTime	datetime
41.	DimObligationComment	ObligationCommentText	nvarchar
42.	DimObligationComment	ObligationCommentText	sysname
43.	DimObligationComment	OriginalObligationCommentId	uniqueidentifier
44.	DimObligationCustomField	CustomFieldId	int
45.	DimObligationCustomField	DimObligationCustomFieldId	int
46.	DimObligationCustomField	DimObligationId	int
47.	DimObligationCustomField	ObligationCustomFieldName	nvarchar
48.	DimObligationCustomField	ObligationCustomFieldName	sysname
49.	DimObligationCustomField	ObligationCustomFieldTypeId	int
50.	DimObligationCustomField	ObligationCustomFieldValue	nvarchar
51.	DimObligationCustomField	ObligationCustomFieldValue	sysname
52.	DimObligationCustomField	OriginalObligationCustomFieldId	uniqueidentifier
53.	DimObligationName	DimBranchId	int
54.	DimObligationName	DimObligationNameId	int
55.	DimObligationName	ObligationNameTitle	nvarchar
56.	DimObligationName	ObligationNameTitle	sysname
57.	DimObligationName	OriginalObligationNameId	uniqueidentifier
58.	DimObligationStatus	DimObligationStatusId	int
59.	DimObligationStatus	ObligationStatusColorId	int
60.	DimObligationStatus	ObligationStatusName	nvarchar
61.	DimObligationStatus	ObligationStatusName	sysname
62.	DimObligationStatus	OriginalObligationStatusId	int
63.	DimObligationTopic	DimBranchId	int
64.	DimObligationTopic	DimObligationTopicId	int
65.	DimObligationTopic	DimParentObligationTopicId	int
66.	DimObligationTopic	ObligationTopicName	nvarchar
67.	DimObligationTopic	ObligationTopicName	sysname
68.	DimObligationTopic	OriginalObligationTopicId	uniqueidentifier
69.	DimObligationType	DimBranchId	int
70.	DimObligationType	DimObligationTypeId	int
71.	DimObligationType	ObligationTypeName	nvarchar
72.	DimObligationType	ObligationTypeName	sysname
73.	DimObligationType	OriginalObligationTypeId	uniqueidentifier