[Home] [Help] [Dependency Information]
Object Name: | BIX_DM_AGENT_OUTCOME_SUM |
---|---|
Object Type: | TABLE |
Owner: | BIX |
Subobject Name: | |
Status: | VALID |
This table stores informations related to the outcomes of the outbound calls . The dimensions of the tables are campaign , campaign schedule, site, outcome, result, reason, direction, media item type, agent and time . The data is captured at the half-hour time bucket .
Tablespace: | APPS_TS_SUMMARY |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
BIX_DM_AGENT_OUTCOME_SUM_N1 | NORMAL | NONUNIQUE | APPS_TS_SUMMARY |
PERIOD_START_DATE_TIME
RESOURCE_ID CAMPAIGN_ID CAMPAIGN_SCHEDULE_ID SERVER_GROUP_ID |
BIX_DM_AGENT_OUTCOME_SUM_N2 | NORMAL | NONUNIQUE | APPS_TS_SUMMARY |
PERIOD_START_DATE_TIME
CAMPAIGN_ID CAMPAIGN_SCHEDULE_ID SERVER_GROUP_ID |
BIX_DM_AGENT_OUTCOME_SUM_N3 | NORMAL | NONUNIQUE | APPS_TS_SUMMARY |
PERIOD_START_DATE
CAMPAIGN_ID CAMPAIGN_SCHEDULE_ID OUTCOME_ID RESULT_ID |
BIX_DM_AGENT_OUTCOME_SUM_N4 | NORMAL | NONUNIQUE | APPS_TS_SUMMARY |
PERIOD_START_DATE
RESOURCE_ID CAMPAIGN_ID CAMPAIGN_SCHEDULE_ID OUTCOME_ID RESULT_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
AGENT_OUTCOME_SUM_ID | NUMBER | Yes | Unique identifier generated from a sequence . | |
CREATED_BY | NUMBER | Yes | Standard WHO Column | |
CREATION_DATE | DATE | Yes | Standard WHO Column | |
LAST_UPDATED_BY | NUMBER | Yes | Standard WHO Column | |
LAST_UPDATE_DATE | DATE | Yes | Standard WHO Column | |
LAST_UPDATE_LOGIN | NUMBER | Standard WHO Column | ||
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 | NUMBER | Date when a concurrent program last updated this record . | ||
CAMPAIGN_ID | NUMBER | Unique identifier for the marketing campaign . | ||
CAMPAIGN_SCHEDULE_ID | NUMBER | Unique identifier for the marketing campaign schedule . | ||
SERVER_GROUP_ID | NUMBER | (15) | Yes | Unique identifier for the site of the call . |
OUTCOME_ID | NUMBER | (15) | Unique Identifier for the outcome of the call . | |
RESULT_ID | NUMBER | (15) | Unique identifier for the result of the call . | |
REASON_ID | NUMBER | (15) | Unique identifier for the reason of the call . | |
DIRECTION | VARCHAR2 | (240) | Identifies the direction of the call . The value of this column is 'Outbound' for outbound calls and 'Inbound' for inbound calls . | |
MEDIA_ITEM_TYPE | VARCHAR2 | (80) | Not Used . | |
RESOURCE_ID | NUMBER | Unique identifier for the agent . | ||
PERIOD_START_DATE | DATE | Yes | The date that the measures correspond to . | |
PERIOD_START_TIME | VARCHAR2 | (5) | Yes | The half-hour bucket that the measures correspond to . |
PERIOD_START_DATE_TIME | DATE | The date-time that the measures correspond to . This column is a concatenation of the columns period_start_date and period_start_time . | ||
NUMBER_OF_CALLS | NUMBER | Number of Calls . | ||
CONTACT_FLAG | VARCHAR2 | (3) | This flag indicates whether the call can be considered as contacted . It is derived from the outcome of the call . | |
POSITIVE_RESPONSE_FLAG | VARCHAR2 | (3) | This flag indicates whether the call can be considered as positive response . It is derived from the result of the call . | |
CONNECT_FLAG | VARCHAR2 | (3) | This flag indicates whether the call is connected . It is derived from the outcome of the call . |
Cut, paste (and edit) the following text to query this object:
SELECT AGENT_OUTCOME_SUM_ID
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, CAMPAIGN_ID
, CAMPAIGN_SCHEDULE_ID
, SERVER_GROUP_ID
, OUTCOME_ID
, RESULT_ID
, REASON_ID
, DIRECTION
, MEDIA_ITEM_TYPE
, RESOURCE_ID
, PERIOD_START_DATE
, PERIOD_START_TIME
, PERIOD_START_DATE_TIME
, NUMBER_OF_CALLS
, CONTACT_FLAG
, POSITIVE_RESPONSE_FLAG
, CONNECT_FLAG
FROM BIX.BIX_DM_AGENT_OUTCOME_SUM;
BIX.BIX_DM_AGENT_OUTCOME_SUM does not reference any database object
BIX.BIX_DM_AGENT_OUTCOME_SUM is referenced by following:
|
|
|