[Home] [Help] [Dependency Information]
Object Name: | BIX_DM_AGENT_CALL_SUM |
---|---|
Object Type: | TABLE |
Owner: | BIX |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Tablespace: | APPS_TS_SUMMARY |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
BIX_DM_AGENT_CALL_SUM_N1 | NORMAL | NONUNIQUE | APPS_TS_SUMMARY |
PERIOD_START_DATE_TIME
RESOURCE_ID |
BIX_DM_AGENT_CALL_SUM_N2 | NORMAL | NONUNIQUE | APPS_TS_SUMMARY |
PERIOD_START_DATE_TIME
CLASSIFICATION_ID |
BIX_DM_AGENT_CALL_SUM_N4 | NORMAL | NONUNIQUE | APPS_TS_SUMMARY | PERIOD_START_DATE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CALLS_SUMMARY_ID | NUMBER | Yes | Unique identifier generated from a sequence . | |
LAST_UPDATE_DATE | DATE | Standard Who column | ||
LAST_UPDATED_BY | NUMBER | (15) | Standard Who column | |
CREATION_DATE | DATE | Standard Who column | ||
CREATED_BY | NUMBER | (15) | Standard Who column | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who column | |
RESOURCE_ID | NUMBER | Resource identifier | ||
CLASSIFICATION_ID | NUMBER | Call classification identifier | ||
SERVER_GROUP_ID | NUMBER | Server Group identifier. Refers to IEO_SVR_SERVERS.SERVER_ID. | ||
FROM_SERVER_GROUP_ID | NUMBER | Not currently used | ||
MEDIA_ITEM_TYPE | VARCHAR2 | (50) | Type of Interaction. Currently always 'TELEPHONY'. | |
DNIS | VARCHAR2 | (32) | External phone number dialed by cistomers (usually 1-800...). Refers to table CCT_MW_ROUTE_POINTS. | |
CURRENCY_CODE | VARCHAR2 | (15) | Transaction currency | |
PERIOD_START_DATE | DATE | Start date of the call | ||
PERIOD_START_TIME | VARCHAR2 | (30) | Start time of the half hour time bucket | |
PERIOD_START_DATE_TIME | DATE | Concatenation of PERIOD_START_DATE and PERIOD_START_TIME columns | ||
CALLS_OFFERED | NUMBER | Number of calls offered | ||
CALLS_IN_QUEUE | NUMBER | Number of calls in queue | ||
IN_CALLS_HANDLED | NUMBER | Number of inbound calls handled | ||
CALLS_TRANSFERED | NUMBER | Number of calls transferred | ||
CALLS_ABANDONED | NUMBER | Number of calls abandoned | ||
IN_CALLS_HANDLD_GT_THN_X_TIME | NUMBER | Number of inbound calls handled in a time frame greater than the one defined in the BIX_DM_GOALS table | ||
CALLS_ANSWRD_WITHIN_X_TIME | NUMBER | Number of calls answered in a time frame defined in the BIX_DM_GOALS table | ||
OUT_CALLS_HANDLED | NUMBER | Number of outbound calls handled | ||
OUT_CALS_HANDLD_GT_THN_X_TIME | NUMBER | Number of outbound calls handled in a time frame defined in the BIX_DM_GOALS table | ||
PRIMARY_COUNT | NUMBER | Not currently used | ||
OTHER_COUNT | NUMBER | Not currently used | ||
IVR_TIME | NUMBER | Interactive Voice Response time | ||
ROUTE_TIME | NUMBER | Routing time | ||
QUEUE_TIME | NUMBER | Queue time | ||
IN_TALK_TIME | NUMBER | Inbound talk time | ||
IN_WRAP_TIME | NUMBER | Inbound wrap time | ||
ABANDON_TIME | NUMBER | Abandon time | ||
OUT_TALK_TIME | NUMBER | Outbound talk time | ||
OUT_WRAP_TIME | NUMBER | Outbound wrap time | ||
LOGIN_TIME | NUMBER | Agent login time | ||
IDLE_TIME | NUMBER | Agent idle time | ||
AVAILABLE_TIME | NUMBER | Agent available time | ||
MIN_IVR_TIME | NUMBER | Minimum Interactive Voice Response time | ||
MAX_IVR_TIME | NUMBER | Maximum Interactive Voice Response time | ||
MIN_ROUTE_TIME | NUMBER | Minimum route time | ||
MAX_ROUTE_TIME | NUMBER | Maximum route time | ||
MIN_QUEUE_TIME | NUMBER | Minimum queue time | ||
MAX_QUEUE_TIME | NUMBER | Maximum queue time | ||
IN_MIN_TALK_TIME | NUMBER | Inbound minimum talk time | ||
IN_MAX_TALK_TIME | NUMBER | Inbound maximum talk time | ||
OUT_MIN_TALK_TIME | NUMBER | Outbound minimum talk time | ||
OUT_MAX_TALK_TIME | NUMBER | Outbound maximum talk time | ||
MIN_ABANDON_TIME | NUMBER | Minimum abandon time | ||
MAX_ABANDON_TIME | NUMBER | Maximum abandon time | ||
IN_MIN_WRAP_TIME | NUMBER | Inbound minimum wrap time | ||
IN_MAX_WRAP_TIME | NUMBER | Inbound maximum wrap time | ||
OUT_MIN_WRAP_TIME | NUMBER | Outbound minimum wrap time | ||
OUT_MAX_WRAP_TIME | NUMBER | Outbound maximum wrap time | ||
SERVICE_REQUESTS_CREATED | NUMBER | Number of service requests created | ||
SERVICE_REQUESTS_OPENED | NUMBER | Number of service requests opened | ||
SERVICE_REQUESTS_CLOSED | NUMBER | Number of service requests closed | ||
LEADS_CREATED | NUMBER | Number of leads created | ||
LEADS_UPDATED | NUMBER | Number of leads updated | ||
LEADS_AMOUNT | NUMBER | Leads amount in preferred (consolidated) currency | ||
OPPORTUNITIES_CREATED | NUMBER | Number of opportunities created | ||
OPPORTUNITIES_UPDATED | NUMBER | Number of opportunities updated | ||
OPPORTUNITIES_WON | NUMBER | Number of opportunities won | ||
OPPORTUNITIES_WON_AMOUNT | NUMBER | Amount of opportunities won in preferred (consolidated) currency | ||
TOTAL_CALLS_COST | NUMBER | Total calls cost | ||
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive Flexfield structure defining column | |
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 | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
SECURITY_GROUP_ID | NUMBER | Subscriber id for CRM Online Services use | ||
REQUEST_ID | NUMBER | Request identifier of last concurrent program to update this record | ||
PROGRAM_APPLICATION_ID | NUMBER | Application identifier of last concurrent program to update this record | ||
PROGRAM_ID | NUMBER | Identifier of last concurrent program to update this record | ||
PROGRAM_UPDATE_DATE | DATE | Date when a concurrent program last updated this record | ||
SOURCE_CODE | VARCHAR2 | (30) | Source Code of the marketing campaign associated with this record. Refers to AMS_CAMPAIGNS_VL view. | |
CONVERSION_RATE | NUMBER | Not currently used | ||
LEADS_AMOUNT_TXN | NUMBER | Leads amount in transaction currency | ||
OPPORTUNITIES_WON_AMOUNT_TXN | NUMBER | Opportunities won amount in transaction currency | ||
CAMPAIGN_ID | NUMBER | Campaign identifier of the marketing campaign associated with this record. Refers to AMS_CAMPAIGNS_VL view. | ||
CAMPAIGN_SCHEDULE | VARCHAR2 | (30) | No longer used | |
CAMPAIGN_SCHEDULE_ID | NUMBER | Campaign schedule identifier of the marketing campaign associated with this record. Refers to AMS_CAMPAIGNS_VL view. | ||
CLASSIFICATION_VALUE_ID | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT CALLS_SUMMARY_ID
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, RESOURCE_ID
, CLASSIFICATION_ID
, SERVER_GROUP_ID
, FROM_SERVER_GROUP_ID
, MEDIA_ITEM_TYPE
, DNIS
, CURRENCY_CODE
, PERIOD_START_DATE
, PERIOD_START_TIME
, PERIOD_START_DATE_TIME
, CALLS_OFFERED
, CALLS_IN_QUEUE
, IN_CALLS_HANDLED
, CALLS_TRANSFERED
, CALLS_ABANDONED
, IN_CALLS_HANDLD_GT_THN_X_TIME
, CALLS_ANSWRD_WITHIN_X_TIME
, OUT_CALLS_HANDLED
, OUT_CALS_HANDLD_GT_THN_X_TIME
, PRIMARY_COUNT
, OTHER_COUNT
, IVR_TIME
, ROUTE_TIME
, QUEUE_TIME
, IN_TALK_TIME
, IN_WRAP_TIME
, ABANDON_TIME
, OUT_TALK_TIME
, OUT_WRAP_TIME
, LOGIN_TIME
, IDLE_TIME
, AVAILABLE_TIME
, MIN_IVR_TIME
, MAX_IVR_TIME
, MIN_ROUTE_TIME
, MAX_ROUTE_TIME
, MIN_QUEUE_TIME
, MAX_QUEUE_TIME
, IN_MIN_TALK_TIME
, IN_MAX_TALK_TIME
, OUT_MIN_TALK_TIME
, OUT_MAX_TALK_TIME
, MIN_ABANDON_TIME
, MAX_ABANDON_TIME
, IN_MIN_WRAP_TIME
, IN_MAX_WRAP_TIME
, OUT_MIN_WRAP_TIME
, OUT_MAX_WRAP_TIME
, SERVICE_REQUESTS_CREATED
, SERVICE_REQUESTS_OPENED
, SERVICE_REQUESTS_CLOSED
, LEADS_CREATED
, LEADS_UPDATED
, LEADS_AMOUNT
, OPPORTUNITIES_CREATED
, OPPORTUNITIES_UPDATED
, OPPORTUNITIES_WON
, OPPORTUNITIES_WON_AMOUNT
, TOTAL_CALLS_COST
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE14
, ATTRIBUTE13
, ATTRIBUTE15
, SECURITY_GROUP_ID
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, SOURCE_CODE
, CONVERSION_RATE
, LEADS_AMOUNT_TXN
, OPPORTUNITIES_WON_AMOUNT_TXN
, CAMPAIGN_ID
, CAMPAIGN_SCHEDULE
, CAMPAIGN_SCHEDULE_ID
, CLASSIFICATION_VALUE_ID
FROM BIX.BIX_DM_AGENT_CALL_SUM;
BIX.BIX_DM_AGENT_CALL_SUM does not reference any database object
BIX.BIX_DM_AGENT_CALL_SUM is referenced by following:
|
|
|