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: BIX.BIX_DM_GOALS

Object Details

Object Name:	BIX_DM_GOALS
Object Type:	TABLE
Owner:	BIX
Subobject Name:
Status:	VALID

This table contains system wide business performance goals for the Interaction Intelligence application. Note that every time it is updated, the old record is obsoleted by placing a date in the END_DATE_ACTIVE. A new record is then created with the END_DATE_ACTIVE field left blank.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Length	Mandatory	Comments
CALL_TYPE_ID	NUMBER		Yes	Classification identifier
SL_PERCENTAGE_GOAL	NUMBER			Service level goal in percentage. This number contains the percentage of calls that has to be answered within the number of seconds contained in the SL_SECONDS_GOAL column.
SL_SECONDS_GOAL	NUMBER			The number of seconds within which a call has to be answered according to the service level agreement (see the description for the SL_PERCENTAGE_GOAL column).
MIN_CALL_TRESHOLD_GOAL	NUMBER			Minimum time in seconds a call has to last in order to be considered
INBOUND_ABANDON_PCT_GOAL	NUMBER			Inbound abandon rate goal (in percentages)
OUTBOUND_ABANDON_PCT_GOAL	NUMBER			Outbound abandon rate goal (in percentages)
CUSTOMIZATION_NPAR_1	NUMBER			Customization parameter for customer use
CUSTOMIZATION_NPAR_2	NUMBER			Customization parameter for customer use
CUSTOMIZATION_NPAR_3	NUMBER			Customization parameter for customer use
CUSTOMIZATION_NPAR_4	NUMBER			Customization parameter for customer use
CUSTOMIZATION_NPAR_5	NUMBER			Customization parameter for customer use
CUSTOMIZATION_CPAR_1	VARCHAR2	(100)		Customization parameter for customer use
CUSTOMIZATION_CPAR_2	VARCHAR2	(100)		Customization parameter for customer use
CUSTOMIZATION_CPAR_3	VARCHAR2	(100)		Customization parameter for customer use
CUSTOMIZATION_CPAR_4	VARCHAR2	(100)		Customization parameter for customer use
CUSTOMIZATION_CPAR_5	VARCHAR2	(100)		Customization parameter for customer use
SECURITY_GROUP_ID	NUMBER			Subscriber id for CRM Online Services use
LAST_UPDATE_DATE	DATE			Standard Who column
CREATED_BY	NUMBER			Standard Who column
CREATION_DATE	DATE			Standard Who column
LAST_UPDATED_BY	NUMBER			Standard Who column
LAST_UPDATE_LOGIN	NUMBER			Standard Who column
END_DATE_ACTIVE	DATE			The date when the content of the record ceases to be active. If this column is blank, then the record is still active.
ACCOUNTING_CODE	VARCHAR2	(80)		Accounting Code
ATTRIBUTE1	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE2	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE3	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE4	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE5	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE6	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE7	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE8	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE9	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE10	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE11	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE12	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE13	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE14	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE15	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Descriptive Flexfield structure defining column
MEDIA_TYPE	VARCHAR2	(20)		Not Used .
SL_FOR_REPLIED_EMAILS	NUMBER			Not Used .
CLASSIFICATION_VALUE_ID	NUMBER			Unique identifier for the classification .

Query Text

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


SELECT CALL_TYPE_ID
,      SL_PERCENTAGE_GOAL
,      SL_SECONDS_GOAL
,      MIN_CALL_TRESHOLD_GOAL
,      INBOUND_ABANDON_PCT_GOAL
,      OUTBOUND_ABANDON_PCT_GOAL
,      CUSTOMIZATION_NPAR_1
,      CUSTOMIZATION_NPAR_2
,      CUSTOMIZATION_NPAR_3
,      CUSTOMIZATION_NPAR_4
,      CUSTOMIZATION_NPAR_5
,      CUSTOMIZATION_CPAR_1
,      CUSTOMIZATION_CPAR_2
,      CUSTOMIZATION_CPAR_3
,      CUSTOMIZATION_CPAR_4
,      CUSTOMIZATION_CPAR_5
,      SECURITY_GROUP_ID
,      LAST_UPDATE_DATE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      END_DATE_ACTIVE
,      ACCOUNTING_CODE
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE_CATEGORY
,      MEDIA_TYPE
,      SL_FOR_REPLIED_EMAILS
,      CLASSIFICATION_VALUE_ID
FROM BIX.BIX_DM_GOALS;

Dependencies

[top of page]

BIX.BIX_DM_GOALS does not reference any database object

BIX.BIX_DM_GOALS is referenced by following:

APPS: BIX_DM_GOALS