[Home] [Help] [Dependency Information]
Object Name: | CSY_GROUP_RESPN_RESOL_B |
---|---|
Object Type: | TABLE |
Owner: | CS |
Subobject Name: | |
Status: | VALID |
This table store Service Request Resolution quality summary for agent groups
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
CSY_GROUP_RESPN_RESOL_B_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
PERIOD_TYPE
PERIOD_NAME INCIDENT_SEVERITY_ID OWNER_GROUP_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PERIOD_TYPE | VARCHAR2 | (30) | Yes | Period Type for the report |
PERIOD_NAME | VARCHAR2 | (80) | Yes | Name of the period |
INCIDENT_SEVERITY_ID | NUMBER | Yes | Service request severity | |
OWNER_GROUP_ID | NUMBER | Yes | Group id of the SR owner | |
TOTAL_RESPONSE_TIME | NUMBER | total response time of the group | ||
TOTAL_SR_RESPONDED | NUMBER | Total Sr responded by the group | ||
TOTAL_RESP_SLA_MISSED | NUMBER | Total SLS response miseed by group | ||
TOTAL_AGENT_WAIT | NUMBER | Group agent wait time | ||
TOTAL_OTHERS_WAIT | NUMBER | Others wait time on the group | ||
TOTAL_RESOLVE_TIME | NUMBER | Total Resolve tiem by the group | ||
TOTAL_SR_RESOLVED | NUMBER | Total number of SR resolved by the group | ||
TOTAL_WAIT_AGENT | NUMBER | Total wait time on agent of the group | ||
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 SLS resolution missed | ||
BEGINNING_BACKLOG | NUMBER | Backlog start time | ||
ENDING_BACKLOG | NUMBER | Backlog end time | ||
TOTAL_SR_ASSIGNED | NUMBER | Total SR assigned to the group | ||
TOTAL_SR_REASSIGNED_TO_OTHERS | NUMBER | Total SR reassigned to others |
Cut, paste (and edit) the following text to query this object:
SELECT PERIOD_TYPE
, PERIOD_NAME
, INCIDENT_SEVERITY_ID
, OWNER_GROUP_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_GROUP_RESPN_RESOL_B;
CS.CSY_GROUP_RESPN_RESOL_B does not reference any database object
CS.CSY_GROUP_RESPN_RESOL_B is referenced by following:
|
|
|