Genpact Cora Knowledge Center

Support

SQL Tables in Cora OpsManager

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:

TableDescriptionTable Name
Case Details TableCurrent case status and more infoUACT31fad8982d3446c79f83c3f7fbde3441
Closed Cases ViewFor 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 LogFor each case, what is the statuses history - who change the status and whenUACT1eb8ce0f0566496c8be117f9e0f19d7b
Statuses TableLookup table -
Case status codes and names
UTCMB8230dbb471b54872b8beb67bdd7c463c
Category TableLookup table -
Case category codes and names
UTCMBfb0df735ae3e4715a3c0b28953bb586e
Types TableLookup table –
Case type codes per category and type names
UTCMB6d55c1086e1c4a3ba8a19a321c89f8bc
Sub Types TableLookup table –
Case sub type codes per type and sub type names
UTCMBe96dd72769b049dcaee9c705acb96e2d
Priorities TableLookup table –
Case priority codes and names
UTCMB327e788a1ee6456eba43bda317e3ac24
Case Audit TableAudit details for each caseUACTa79fc0da0d83440aaae1941a68959c0f
Cases TableAll cases per solution
  • tblSolutionCases
  • tblSolutionCasesClosed
  • view_CoraOps_SolutionCases_All
Allocated CasesFor each case, to which group it has been allocated
  • tblAllocatedSolutionCases
  • tblAllocatedSolutionCasesClosed
  • view_CoraOps_AllocatedSolutionCases_All
Tasks TablesTask details per case
  • tblSolutionTasks
  • tblSolutionTasksClosed
  • view_CoraOps_tblSolutionTasks_All
Assigned TasksTask assignment per case and solution
  • tblAllocatedSolutionTasks
  • tblAllocatedSolutionTasksClosed
  • view_CoraOps_AllocatedSolutionTasks_All
QA TableCases that have been sent to QA, and their QA resultsUACT9bd6705efa414c47b5f377bc31cfa019
Case Attachments TableAll attachments information per caseUACT6e0fd6cfcb564f5bb9ed12bf15840bc7
Messages TableAll messages related to each caseUACT6a7a37e1014b49f09784fe73ab50aead
Reasons TableReason codes and textUTCMBdc32b2249b7f416bab328def86b3fd3f