[Home] [Help] [Dependency Information]
Object Name: | IEC_G_REP_LIST_DETAILS_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
View of real-time report summary statistics for executing target groups.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CAMPAIGN_ID | NUMBER | Yes | Campaign id. | |
CAMPAIGN_STATUS_CODE | VARCHAR2 | (30) | Yes | Campaign status code. |
SCHEDULE_ID | NUMBER | Yes | Campaign schedule id. | |
SCHEDULE_STATUS_CODE | VARCHAR2 | (30) | Yes | Schedule status code. |
LIST_HEADER_ID | NUMBER | List header id. | ||
LIST_STATUS_CODE | VARCHAR2 | (30) | List status code. | |
DIALING_METHOD | VARCHAR2 | (30) | List's dialing method. | |
RECORD_LOADED | NUMBER | Number of records loaded. | ||
RECORD_VALID_ALL_CPS | NUMBER | Records Valid All Contact Points | ||
RECORD_VALID_SOME_CPS | NUMBER | Records Valid Some Contact Points | ||
RECORD_INVALID | NUMBER | Records Invalid | ||
RECORD_CALLED_ONCE | NUMBER | Number of records called at least once. | ||
RECORD_CALLED_ONCE_PERC | NUMBER | Percentage of records called at least once, based on records loaded. | ||
RECORD_REMOVED | NUMBER | Number of records removed. | ||
RECORD_REMOVED_PERC | NUMBER | Percentage of records removed, based on records loaded. | ||
RECORD_REMAINING | NUMBER | Number of records remaining. | ||
RECORD_REMAINING_PERC | NUMBER | Percentage of records remaining, based on records loaded. | ||
RECORD_AVAILABLE | NUMBER | Number of records that are currently available for calling. | ||
RECORD_AVAILABLE_PERC | NUMBER | Percentage of records available, based on records loaded. | ||
RECORD_UNAVAILABLE | NUMBER | Number of records that are currently unavailable for calling. | ||
RECORD_UNAVAILABLE_PERC | NUMBER | Percentage of records unavailable, based on records loaded. | ||
PREDICTED_EXHAUSTION | DATE | List's predicted exhaustion time. |
Cut, paste (and edit) the following text to query this object:
SELECT CAMPAIGN_ID
, CAMPAIGN_STATUS_CODE
, SCHEDULE_ID
, SCHEDULE_STATUS_CODE
, LIST_HEADER_ID
, LIST_STATUS_CODE
, DIALING_METHOD
, RECORD_LOADED
, RECORD_VALID_ALL_CPS
, RECORD_VALID_SOME_CPS
, RECORD_INVALID
, RECORD_CALLED_ONCE
, RECORD_CALLED_ONCE_PERC
, RECORD_REMOVED
, RECORD_REMOVED_PERC
, RECORD_REMAINING
, RECORD_REMAINING_PERC
, RECORD_AVAILABLE
, RECORD_AVAILABLE_PERC
, RECORD_UNAVAILABLE
, RECORD_UNAVAILABLE_PERC
, PREDICTED_EXHAUSTION
FROM APPS.IEC_G_REP_LIST_DETAILS_V;
|
|
|