[Home] [Help] [Dependency Information]
Object Name: | IEC_G_REP_SUBSET_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 subsets.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CAMPAIGN_ID | NUMBER | (15) | Campaign id. | |
CAMPAIGN_STATUS_CODE | VARCHAR2 | (30) | Yes | Campaign status code. |
SCHEDULE_ID | NUMBER | (15) | Yes | Campaign schedule id. |
SCHEDULE_STATUS_CODE | VARCHAR2 | (30) | Yes | Schedule status code. |
LIST_HEADER_ID | NUMBER | (15) | Yes | List header id. |
LIST_STATUS_CODE | VARCHAR2 | (30) | List status code. | |
SUBSET_ID | NUMBER | (15) | Yes | Subset id. |
RECORD_LOADED | NUMBER | Number of records loaded. | ||
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 | Obsolete column. | ||
RECORD_CALLED_AND_REMOVED | NUMBER | Obsolete column. |
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
, SUBSET_ID
, RECORD_LOADED
, 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
, RECORD_CALLED_AND_REMOVED
FROM APPS.IEC_G_REP_SUBSET_DETAILS_V;
|
|
|