[Home] [Help] [Dependency Information]
Object Name: | CSY_AGENT_RESPN_RESOL_B |
---|---|
Object Type: | TABLE |
Owner: | CS |
Subobject Name: | |
Status: | VALID |
This table Service Request Resolution quality summary for agents
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
CSY_AGENT_RESPN_RESOL_B_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
PERIOD_TYPE
PERIOD_NAME INCIDENT_SEVERITY_ID INCIDENT_OWNER_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PERIOD_TYPE | VARCHAR2 | (30) | Yes | Store Period Type for the report |
PERIOD_NAME | VARCHAR2 | (80) | Yes | Name of the period |
INCIDENT_SEVERITY_ID | NUMBER | Yes | Service Request severity | |
INCIDENT_OWNER_ID | NUMBER | Yes | Service Request Owner | |
TOTAL_RESPONSE_TIME | NUMBER | Total Response time for the period | ||
TOTAL_SR_RESPONDED | NUMBER | Total number of SR Responded for the period | ||
TOTAL_RESP_SLA_MISSED | NUMBER | Total missing SLA Service Request | ||
TOTAL_AGENT_WAIT | NUMBER | Total Agent wait time | ||
TOTAL_OTHERS_WAIT | NUMBER | Total others wait time | ||
TOTAL_RESOLVE_TIME | NUMBER | Total Resolve time for the Service Request | ||
TOTAL_SR_RESOLVED | NUMBER | Total number of SR resolved | ||
TOTAL_WAIT_AGENT | NUMBER | Total wait time on agent | ||
TOTAL_WAIT_SUPPORT | NUMBER | Total Wait time on support | ||
TOTAL_WAIT_INTERNAL | NUMBER | total Internal Wait time | ||
TOTAL_WAIT_EXTERNAL | NUMBER | Total External Wait time | ||
TOTAL_WAIT_CUSTOMER | NUMBER | Total Wait on customer | ||
TOTAL_RESL_SLA_MISSED | NUMBER | Total resolution SLA missed | ||
BEGINNING_BACKLOG | NUMBER | Start point of backlog | ||
ENDING_BACKLOG | NUMBER | End point of backlog | ||
TOTAL_SR_ASSIGNED | NUMBER | Total number of SR assigned | ||
TOTAL_SR_REASSIGNED_TO_OTHERS | NUMBER | Total number of SR reassigned to others |
Cut, paste (and edit) the following text to query this object:
SELECT PERIOD_TYPE
, PERIOD_NAME
, INCIDENT_SEVERITY_ID
, INCIDENT_OWNER_ID
, TOTAL_RESPONSE_TIME
, TOTAL_SR_RESPONDED
, TOTAL_RESP_SLA_MISSED
, TOTAL_AGENT_WAIT
, TOTAL_OTHERS_WAIT
, TOTAL_RESOLVE_TIME
, TOTAL_SR_RESOLVED
, TOTAL_WAIT_AGENT
, TOTAL_WAIT_SUPPORT
, TOTAL_WAIT_INTERNAL
, TOTAL_WAIT_EXTERNAL
, TOTAL_WAIT_CUSTOMER
, TOTAL_RESL_SLA_MISSED
, BEGINNING_BACKLOG
, ENDING_BACKLOG
, TOTAL_SR_ASSIGNED
, TOTAL_SR_REASSIGNED_TO_OTHERS
FROM CS.CSY_AGENT_RESPN_RESOL_B;
CS.CSY_AGENT_RESPN_RESOL_B does not reference any database object
CS.CSY_AGENT_RESPN_RESOL_B is referenced by following:
|
|
|