Previous to V3.0
SQL Tables in Cora OpsManager
Following are the SQL tables you need to know before modifying or creating new report/dashboard object:
Table | Description | Table Name |
Cases Details Table | Current case status and more info. | UACT31fad8982d3446c79f83c3f7fbde3441 |
Closed Cases View | For each Closed or Pending Closure case, the close date and the user who closed the case. Available from version 1.7. | vw_OpsCenter_BI_ClosedCases |
Status History Log | For each case, what is the status history i.e. who changed the status and when. | UACT1eb8ce0f0566496c8be117f9e0f19d7b |
Statuses Table | Cases statuses codes and names. | UTCMB8230dbb471b54872b8beb67bdd7c463c |
Category Table | Cases category codes and names. | UTCMBfb0df735ae3e4715a3c0b28953bb586e |
Types Table | Cases type codes per category and type names. | UTCMB6d55c1086e1c4a3ba8a19a321c89f8bc |
Sub Types Table | Cases sub types codes per type and sub type names. | UTCMBe96dd72769b049dcaee9c705acb96e2d |
Priorities Table | Cases priorities code and names. | UTCMB327e788a1ee6456eba43bda317e3ac24 |
Case Audit Table | Audit details for each case. | UACTa79fc0da0d83440aaae1941a68959c0f |
Tasks Table | Tasks details per case. | USLf197425dadd5446a95fab04374f91784_Tasks |
Tasks Assigned To Employees | For each case, who are the employees working on it. | USLf197425dadd5446a95fab04374f91784_TaskEmployeeAssignments |
Allocated Cases | For each case, to which group it has been allocated. | USLf197425dadd5446a95fab04374f91784_AllocatedCases |
QA Table | Case that has been sent to QA, and its results. | UACT9bd6705efa414c47b5f377bc31cfa019 |
Case Attachments Table | All attachments information per case. | UACT6e0fd6cfcb564f5bb9ed12bf15840bc7 |
Reasons Table | Reason codes and Reason text. | UTCMBdc32b2249b7f416bab328def86b3fd3f |
V3.0 and later
SQL Tables in Cora OpsManager
Following are the SQL tables you need to know before modifying or creating new report/dashboard object:
| Table | Description | Table Name |
|---|---|---|
| Case Details Table | Current case status and more info | UACT31fad8982d3446c79f83c3f7fbde3441 |
| Closed Cases View | For each Closed or Pending Closure case, brings the close date and the user who closed the case – Available from version 1.7 | vw_CoraOps_BI_ClosedCases |
| Status History Log | For each case, what is the statuses history - who change the status and when | UACT1eb8ce0f0566496c8be117f9e0f19d7b |
| Statuses Table | Lookup table - Case status codes and names | UTCMB8230dbb471b54872b8beb67bdd7c463c |
| Category Table | Lookup table - Case category codes and names | UTCMBfb0df735ae3e4715a3c0b28953bb586e |
| Types Table | Lookup table – Case type codes per category and type names | UTCMB6d55c1086e1c4a3ba8a19a321c89f8bc |
| Sub Types Table | Lookup table – Case sub type codes per type and sub type names | UTCMBe96dd72769b049dcaee9c705acb96e2d |
| Priorities Table | Lookup table – Case priority codes and names | UTCMB327e788a1ee6456eba43bda317e3ac24 |
| Case Audit Table | Audit details for each case | UACTa79fc0da0d83440aaae1941a68959c0f |
| Cases Table | All cases per solution |
|
| Allocated Cases | For each case, to which group it has been allocated |
|
| Tasks Tables | Task details per case |
|
| Assigned Tasks | Task assignment per case and solution |
|
| QA Table | Cases that have been sent to QA, and their QA results | UACT9bd6705efa414c47b5f377bc31cfa019 |
| Case Attachments Table | All attachments information per case | UACT6e0fd6cfcb564f5bb9ed12bf15840bc7 |
| Messages Table | All messages related to each case | UACT6a7a37e1014b49f09784fe73ab50aead |
| Reasons Table | Reason codes and text | UTCMBdc32b2249b7f416bab328def86b3fd3f |
