[Home] [Help] [Dependency Information]
Object Name: | BIX_DM_GROUP_SESSBYCAMP_SUM |
---|---|
Object Type: | TABLE |
Owner: | BIX |
Subobject Name: | |
Status: | VALID |
This table stores informations related to the agent group's login time and work time . The dimensions are agent group , time , site , campaign and campaign schedule . The data is summarized to the half hour bucket .
Tablespace: | APPS_TS_SUMMARY |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
BIX_DM_GROUP_SESSBYCAMP_SUM_N1 | NORMAL | NONUNIQUE | APPS_TS_SUMMARY |
PERIOD_START_DATE_TIME
GROUP_ID CAMPAIGN_ID CAMPAIGN_SCHEDULE_ID SERVER_GROUP_ID |
BIX_DM_GROUP_SESSBYCAMP_SUM_N2 | NORMAL | NONUNIQUE | APPS_TS_SUMMARY |
PERIOD_START_DATE_TIME
CAMPAIGN_ID CAMPAIGN_SCHEDULE_ID SERVER_GROUP_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
GROUP_SESSBYCAMP_SUM_ID | NUMBER | Yes | Unique identifier generated from a sequence . | |
CREATION_DATE | DATE | Yes | Standard Who Column . | |
CREATED_BY | NUMBER | Yes | Standard Who Column . | |
LAST_UPDATE_DATE | DATE | Yes | Standard Who Column . | |
LAST_UPDATED_BY | NUMBER | Yes | Standard Who Column . | |
LAST_UPDATE_LOGIN | NUMBER | Standard Who Column . | ||
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_ID | NUMBER | Identifier of last concurrent program to update this record . | ||
PROGRAM_APPLICATION_ID | NUMBER | Application identifier of last concurrent program to update this record . | ||
PROGRAM_UPDATE_DATE | DATE | Date when a concurrent program last updated this record . | ||
GROUP_ID | NUMBER | Yes | Unique identifier for the agent group . | |
SERVER_GROUP_ID | NUMBER | (15) | Unique identifier for site . | |
CAMPAIGN_ID | NUMBER | Unique identifier for marketing campaign . | ||
CAMPAIGN_SCHEDULE_ID | NUMBER | Unique identifier for marketing campaign schedule . | ||
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 . | ||
WORK_TIME | NUMBER | The total work time for all the agents in the agent group . | ||
AVAILABLE_TIME | NUMBER | The total available time for all the agents belonging to the agent group . |
Cut, paste (and edit) the following text to query this object:
SELECT GROUP_SESSBYCAMP_SUM_ID
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, SECURITY_GROUP_ID
, REQUEST_ID
, PROGRAM_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_UPDATE_DATE
, GROUP_ID
, SERVER_GROUP_ID
, CAMPAIGN_ID
, CAMPAIGN_SCHEDULE_ID
, PERIOD_START_DATE
, PERIOD_START_TIME
, PERIOD_START_DATE_TIME
, WORK_TIME
, AVAILABLE_TIME
FROM BIX.BIX_DM_GROUP_SESSBYCAMP_SUM;
BIX.BIX_DM_GROUP_SESSBYCAMP_SUM does not reference any database object
BIX.BIX_DM_GROUP_SESSBYCAMP_SUM is referenced by following:
|
|
|