SVC_SR_SUMMARIZATIONS
This table stores various high-level metrics related to service requests. Each row captures a snapshot of the overall state of service requests at a specific point in time and remains unchanged once created.
Details
-
Schema: FUSION
-
Object owner: SVC
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
SVC_SR_SUMMARIZATIONS_PK |
SR_SUMMARIZATION_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments | Status |
|---|---|---|---|---|---|---|
| SR_SUMMARIZATION_ID | NUMBER | 18 | Yes | Auto-generated number and primary key for this table. | ||
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | Active | ||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | Active | |
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | Active | ||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | Active | |
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | Active | ||
| OBJECT_VERSION_NUMBER | NUMBER | 9 | Yes | Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. | Active | |
| STRIPE_CD | VARCHAR2 | 30 | Yes | Lookup code that indicates the stripe code, such as CRM, HCM, or PRM. | ||
| SUMMARIZATION_DATE | TIMESTAMP | Yes | Date on which summarization data gets captured. | |||
| SR_CREATED | NUMBER | 18 | Count of all SRs created on the specific date. | |||
| SR_CRITICAL_CREATED | NUMBER | 18 | Count of Critical SRs created on the specific date. | |||
| SR_OPEN | NUMBER | 18 | Count of all SRs opened on the specific date. | |||
| SR_OPEN_CRITICAL | NUMBER | 18 | Count of Critical SRs opened on the specific date. | |||
| SR_REOPEN | NUMBER | 18 | Count of all SRs re-opened on the date. | |||
| SR_REOPEN_CRITICAL | NUMBER | 18 | Count of Critical SRs re-opened on the date. | |||
| SR_INITIAL_QUEUE_ASSIGN | NUMBER | 18 | Count of all SRs assigned to a queue for the first time on the date. | |||
| SR_INITIAL_AGENT_ASSIGN | NUMBER | 18 | Count of all SRs assigned to a named resource for the first time. | |||
| SR_QUEUE_REASSIGN | NUMBER | 18 | Count of all SRs re-assigned to a different queue on the date. | |||
| SR_AGENT_REASSIGN | NUMBER | 18 | Count of all SRs re-assigned to a different agent on the date. | |||
| SR_UPDATED | NUMBER | 18 | Count of all SRs that saw some update activity on the date. | |||
| SR_RESOLVED | NUMBER | 18 | Count of all SRs resolved on the date. | |||
| SR_CLOSED | NUMBER | 18 | Count of all SRs closed on the date. | |||
| SR_DELETED | NUMBER | 18 | Count of all SRs deleted (soft) on the date. | |||
| SR_PURGED | NUMBER | 18 | Count of all SRs permanently deleted on the date. | |||
| SR_ALL_OPEN | NUMBER | 18 | Count of all open SRs (irrespective of creation date) as on the date. | |||
| SR_ALL_OPEN_CRITICAL | NUMBER | 18 | Count of all open and critical SRs (irrespective of creation date) as on the date. | |||
| SR_ALL_REOPEN_CRITICAL | NUMBER | 18 | Count of all SRs that are critical and re-opened (any date) and still open on that date. | |||
| SR_ALL_REOPEN | NUMBER | 18 | Count of all SRs that were re-opened (any date) and still open on that date. | |||
| SR_ALL_NEW | NUMBER | 18 | Count of all SRs in new status type. | |||
| SR_ALL_INPROGRESS | NUMBER | 18 | Count of all SRs in In Progress status type. | |||
| SR_ALL_WAITING | NUMBER | 18 | Count of all SRs in Waiting status type. | |||
| SR_ALL_UNASSIGNED | NUMBER | 18 | Count of all SRs not assigned to a specific agent yet (including in queues). | |||
| SR_ALL_UNCLAIM | NUMBER | 18 | Count of all SRs across Count of all queues that have not been claimed yet. | |||
| SR_ALL_AWAITING_CUSTOMER | NUMBER | 18 | Count of all SRs awaiting customer response. | |||
| SR_ALL_PENDING_AGENT | NUMBER | 18 | Count of all SRs pending agent action. | |||
| SR_ALL_UNRESOLVED | NUMBER | 18 | Count of all unresolved SRs. | |||
| SR_ALL_RESOLVED | NUMBER | 18 | Count of all resolved SRs but not yet closed. | |||
| SR_ALL_CLOSED | NUMBER | 18 | Count of all closed SRs. | |||
| SR_ALL_DELETED | NUMBER | 18 | Count of all SRs that are deleted (soft). | |||
| SR_ALL_PURGED | NUMBER | 18 | Count of all SRs permanently deleted. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| SVC_SR_SUMMARIZATIONS_N1 | Non Unique | Default | SUMMARIZATION_DATE |
| SVC_SR_SUMMARIZATIONS_PK | Unique | Default | SR_SUMMARIZATION_ID |