eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

TABLE: CS.CSY_RESPONSE_RESOLUTIONS

Object Details

Object Name:	CSY_RESPONSE_RESOLUTIONS
Object Type:	TABLE
Owner:	CS
FND Design Data:	CS.CSY_RESPONSE_RESOLUTIONS
Subobject Name:
Status:	VALID

This table contains summary of service request data by agents and groups. The service request summary contained in this table is: Backlog position for agent and group,. Number of Service Request Responded, Number of Service Request Resolved, Time taken to respond service requests, Time taken to resolve service requests, Movement of Service Request between agents and groups.

Storage Details

Tablespace:	APPS_TS_SUMMARY
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
CSY_RESPONSE_RESOLUTIONS_U1	NORMAL	UNIQUE	APPS_TS_SUMMARY	OWNER_TYPE SUMMARY_DATE INCIDENT_OWNER_ID OWNER_GROUP_ID INCIDENT_SEVERITY_ID

Columns

Name	Datatype	Length	Mandatory	Comments
SUMMARY_DATE	DATE		Yes	Service Request Summary Date
OWNER_TYPE	VARCHAR2	(1)	Yes	This column indicates if summary belongs to an agent or group. It's valid values are 'A' for agent and 'G' for group.
OWNER_GROUP_ID	NUMBER		Yes	Service Request Group Owner identifier
INCIDENT_OWNER_ID	NUMBER		Yes	Service Request Owner identifier
INCIDENT_SEVERITY_ID	NUMBER		Yes	Incident Severity identifier
TOTAL_RESPONSE_TIME	NUMBER	(15)		Total time taken to response. This value is in minutes.
TOTAL_REQUESTS_RESPONDED	NUMBER	(15)		Total number of Service Requests Responded
TOTAL_WAIT_ON_AGENT_RESP	NUMBER	(15)		Total time service requests waited on agent before response by agent
TOTAL_WAIT_ON_OTHERS_RESP	NUMBER	(15)		Total time service requests waited on other than agent before response by agent
TOTAL_REQUESTS_RESOLVED	NUMBER	(15)		Total number of Service Request Resolved
TOTAL_RESOLVE_TIME	NUMBER	(15)		Total time taken taken to resolved service requests
TOTAL_WAIT_ON_AGENT_RESL	NUMBER	(15)		Total time service requesst waited on agent before resolution
TOTAL_WAIT_ON_INT_ORG_RESL	NUMBER	(15)		total time Service Requests waited on internal organization before resolution
TOTAL_WAIT_ON_EXT_ORG_RESL	NUMBER	(15)		total time Service Requests waited on external organization before resolution
TOTAL_WAIT_ON_SUPPORT_RESL	NUMBER	(15)		total time Service Requests waited on support organization before resolution
TOTAL_WAIT_ON_CUSTOMER_RESL	NUMBER	(15)		total time Service Requests waited on customer before resolution
TOTAL_RESP_SLA_MISSED	NUMBER	(15)		Total number of Response Service Level Agreement missed
TOTAL_RESL_SLA_MISSED	NUMBER	(15)		Total number of Resolution Service Level Agreement missed
BEGINNING_BACKLOG	NUMBER	(15)		Total number of service requests that are not closed at the beginning of Summary Date
ENDING_BACKLOG	NUMBER	(15)		Total number of service requests that are not closed at the end of Summary Date
TOTAL_SR_ASSIGNED	NUMBER	(15)		Total number of service requests assigned to Agent or group from some other agents or groups
TOTAL_SR_REASSIGNED_TO_OTHERS	NUMBER	(15)		Total number of service requests reassigned from and Agent or a group from some other agents or groups
LAST_UPDATE_DATE	DATE		Yes	Standard who column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard who column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard who column
CREATION_DATE	DATE		Yes	Standard who column
CREATED_BY	NUMBER	(15)	Yes	Standard who column
PROGRAM_ID	NUMBER			Identifies the concurrent program
PROGRAM_LOGIN_ID	NUMBER			Identifies the Oracle Applications concurrent program login identifier
PROGRAM_APPLICATION_ID	NUMBER			Identifies the Oracle Application that spawned concurrent program
REQUEST_ID	NUMBER			Identifies the concurrent request instance that spawned concurrent program

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT SUMMARY_DATE
,      OWNER_TYPE
,      OWNER_GROUP_ID
,      INCIDENT_OWNER_ID
,      INCIDENT_SEVERITY_ID
,      TOTAL_RESPONSE_TIME
,      TOTAL_REQUESTS_RESPONDED
,      TOTAL_WAIT_ON_AGENT_RESP
,      TOTAL_WAIT_ON_OTHERS_RESP
,      TOTAL_REQUESTS_RESOLVED
,      TOTAL_RESOLVE_TIME
,      TOTAL_WAIT_ON_AGENT_RESL
,      TOTAL_WAIT_ON_INT_ORG_RESL
,      TOTAL_WAIT_ON_EXT_ORG_RESL
,      TOTAL_WAIT_ON_SUPPORT_RESL
,      TOTAL_WAIT_ON_CUSTOMER_RESL
,      TOTAL_RESP_SLA_MISSED
,      TOTAL_RESL_SLA_MISSED
,      BEGINNING_BACKLOG
,      ENDING_BACKLOG
,      TOTAL_SR_ASSIGNED
,      TOTAL_SR_REASSIGNED_TO_OTHERS
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATION_DATE
,      CREATED_BY
,      PROGRAM_ID
,      PROGRAM_LOGIN_ID
,      PROGRAM_APPLICATION_ID
,      REQUEST_ID
FROM CS.CSY_RESPONSE_RESOLUTIONS;

Dependencies

[top of page]

CS.CSY_RESPONSE_RESOLUTIONS does not reference any database object

CS.CSY_RESPONSE_RESOLUTIONS is referenced by following:

APPS: CSY_AGENT_RESPN_RESOL_MV; CSY_GROUP_RESPN_RESOL_MV; CSY_RESPONSE_RESOLUTIONS