DBA Data[Home] [Help] [Dependency Information]


TABLE: IEO.IEO_CP_SERVICES_ALL

Object Details
Object Name: IEO_CP_SERVICES_ALL
Object Type: TABLE
Owner: IEO
FND Design Data: TableIEO.IEO_CP_SERVICES_ALL
Subobject Name:
Status: VALID


Setup/configuration for all Campaign Plus services on this system


Storage Details
Tablespace: TablespaceAPPS_TS_ARCHIVE
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
CP_SERVICE_ID NUMBER
Yes Primary key column
CREATED_BY NUMBER (15) Yes Standard WHO column
CREATION_DATE DATE
Yes Standard WHO column
LAST_UPDATED_BY NUMBER (15) Yes Standard WHO column
LAST_UPDATE_DATE DATE
Yes Standard WHO column
LAST_UPDATE_LOGIN NUMBER (15)
Standard WHO column
SREF_TYPE VARCHAR2 (5) Yes Always "S"
LIST_SRV_NAME VARCHAR2 (30) Yes List service name
RECYCLING_METHOD VARCHAR2 (30)
Obsolete
CALENDAR_FILE VARCHAR2 (128) Yes Location info (filename or other unique ID) for service calendar file
CAL_ALG_TYPE VARCHAR2 (10) Yes "SCHEDULE"
RCY_ALG_TYPE VARCHAR2 (10) Yes "RECYCLE"
ORG_ID NUMBER (15) Yes Multi-org support
REORG_RECHECK_FLG VARCHAR2 (5)
"Y"(es) if records should be rechecked and redistributed at shutdown
REORG_DATE DATE

Last reorganization date
REVISION NUMBER (9)
Timestamp when record was updated on disk
REORG_FLAG VARCHAR2 (5)
"Y"(es) if shutdown-time reorganization completed successfully
STOP_LIST_LD_FLAG VARCHAR2 (5)
Obsolete
SEND_ORIG_LIST_FLG VARCHAR2 (5)
Obsolete
SCRIPT_NAME VARCHAR2 (32)
Obsolete
SQL_SELECT_STR VARCHAR2 (1000)
WHERE clause for SQL SELECT statement that qualifies records for loading in this service
STOP_CNTCT_CH_FLAG VARCHAR2 (5)
Obsolete
T2PM NUMBER (9)
Number of records released from 2pm-2:59pm
T3PM NUMBER (9)
Number of records released from 3pm-3:59pm
T30_MIN NUMBER (9)
Number of records released in the last 30 minutes
T4PM NUMBER (9)
Number of records released from 4pm-4:59pm
T5PM NUMBER (9)
Number of records released from 5pm-5:59pm
T5_MIN NUMBER (9)
Number of records released in the last 5 minutes
T6PM NUMBER (9)
Number of records released from 6pm-6:59pm
T60_MIN NUMBER (9)
Number of records released in the last 60 minutes
T7PM NUMBER (9)
Number of records released from 7pm-7:59pm
T8PM NUMBER (9)
Number of records released from 8pm-8:59pm
T9PM NUMBER (9)
Number of records released from 9pm-9:59pm
T10PM NUMBER (9)
Number of records released from 10pm-10:59pm
T10_MIN NUMBER (9)
Number of records released in the last 10 minutes
T10AM NUMBER (9)
Number of records released from 10am-10:59am
T11PM NUMBER (9)
Number of records released from 11pm-11:59pm
LAST_STAT_REFRESH DATE

Obsolete
LIST_DB_NAME VARCHAR2 (128)
Database identifier for customer table
LISTDB_RELEASE_STR VARCHAR2 (1000)
Boolean logic that permits records to be released from this service
LISTDB_SELECT_STR VARCHAR2 (1000)
Boolean logic that qualifies records for loading in this service - not currently supported
LIST_DB_STATUS VARCHAR2 (5)
Obsolete
LAST_QBLOCK_BYTES NUMBER (9)
Bytes used in last .QLD file block
MASTER_FILE_SPEC VARCHAR2 (250)
Obsolete
MASTER_TABLE VARCHAR2 (30)
Table or view name from which customer data is loaded
MASTER_FS_LEN NUMBER (9)
Obsolete
NUM_AGENTS NUMBER (9)
Obsolete
NUM_BLKS_LIST_FILE NUMBER (9)
Size of .QLD file in 16KB blocks
NUM_CACHE_READS NUMBER (9)
Cache performance statistics
NUM_CACHE_WRITES NUMBER (9)
Cache performance statistics
NUM_CACHE_HITS NUMBER (9)
Cache performance statistics
NUM_CACHE_MISSES NUMBER (9)
Cache performance statistics
NUM_CACHE_COLLISNS NUMBER (9)
Cache performance statistics
NUM_FIELD_RECORDS NUMBER (9)
Number of columns used in customer records in .QLD
NUM_SET_RECORDS NUMBER (9)
Number of defined list groups/campaigns in this service
NUM_LIST_RECORDS NUMBER (9)
Number of lists in this service
NUM_CACHE_FLUSHES NUMBER (9)
Cache performance statistics
CHECK_DUPES_FLAG VARCHAR2 (5)
Determine whether or not duplicate records should be identified and purged at shutdown time. (Always "Y" currently)
PROP_RLS_FLAG VARCHAR2 (5)
Obsolete
CURRENT_ENTRY_CNT NUMBER (9)
Total number of records in this service
DIALING_OPTIONS VARCHAR2 (128)
Dialing options string passed to Predictive
ABANDON_LIMIT NUMBER (9)
Obsolete
TALK_TIME_LOCAL NUMBER (9)
Obsolete
PACING_METHOD NUMBER (9)
Obsolete
PACE_Y_N VARCHAR2 (5)
Obsolete
PBX_NAME VARCHAR2 (30)
Predictive service name associated with this service
LISTDB_TYPE NUMBER (9)
99 = SQL-based RDBMS
T1_MIN NUMBER (9)
Number of records released in the last 1 minute
T15_MIN NUMBER (9)
Number of records released in the last 15 minutes
T9AM NUMBER (9)
Number of records released from 9am-9:59am
T11AM NUMBER (9)
Number of records released from 11am-11:59am
T12PM NUMBER (9)
Number of records released from 12pm-12:59pm
T1PM NUMBER (9)
Number of records released from 1pm-1:59pm
TIME_ZONE NUMBER (38)
Time zone in which the server operates
ACCT_NAME_COLUMNS VARCHAR2 (100)
Name(s) of column(s) in MASTER_TABLE that, together, represent the customer name
DATA_FIELDS VARCHAR2 (1100)
Name(s) of column(s) in MASTER_TABLE that (in addition to ACCT_NAME_COLUMNS) populate each customer record in the .QLD
DB_PASSWORD VARCHAR2 (60)
Authorization info for LIST_DB_NAME
ACCOUNT_ID VARCHAR2 (30)
Name of column in MASTER_TABLE that holds unique customer ID
POST_PROC_FILE VARCHAR2 (128)
Location info (filename or other unique ID) for reycling algorithm file
JOURNAL_FLUSH NUMBER (9)
Journal flush interval - obsolete
DIALING_TYPE NUMBER (9)
Dialing type supported by this service (45 = predictive, 5 = preview)
NPR_LST_DB_LIST NUMBER (9)
Obsolete
USER_DATA_SIZE NUMBER (9)
Total size of the ACCT_NAME_COLUMNS and DATA_FIELDS columns record in the .QLD file
VERSION NUMBER (9)
Software version compatibility
CAMPAIGN_LIST_ID NUMBER (15)
FK to AMS_LIST_HEADERS_ALL, connects Campaign Plus to AMS Campaign
SECURITY_GROUP_ID NUMBER (15)
Used in hosted environments
OBJECT_VERSION_NUMBER NUMBER

Standard column used by HTML utilities.
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT CP_SERVICE_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      SREF_TYPE
,      LIST_SRV_NAME
,      RECYCLING_METHOD
,      CALENDAR_FILE
,      CAL_ALG_TYPE
,      RCY_ALG_TYPE
,      ORG_ID
,      REORG_RECHECK_FLG
,      REORG_DATE
,      REVISION
,      REORG_FLAG
,      STOP_LIST_LD_FLAG
,      SEND_ORIG_LIST_FLG
,      SCRIPT_NAME
,      SQL_SELECT_STR
,      STOP_CNTCT_CH_FLAG
,      T2PM
,      T3PM
,      T30_MIN
,      T4PM
,      T5PM
,      T5_MIN
,      T6PM
,      T60_MIN
,      T7PM
,      T8PM
,      T9PM
,      T10PM
,      T10_MIN
,      T10AM
,      T11PM
,      LAST_STAT_REFRESH
,      LIST_DB_NAME
,      LISTDB_RELEASE_STR
,      LISTDB_SELECT_STR
,      LIST_DB_STATUS
,      LAST_QBLOCK_BYTES
,      MASTER_FILE_SPEC
,      MASTER_TABLE
,      MASTER_FS_LEN
,      NUM_AGENTS
,      NUM_BLKS_LIST_FILE
,      NUM_CACHE_READS
,      NUM_CACHE_WRITES
,      NUM_CACHE_HITS
,      NUM_CACHE_MISSES
,      NUM_CACHE_COLLISNS
,      NUM_FIELD_RECORDS
,      NUM_SET_RECORDS
,      NUM_LIST_RECORDS
,      NUM_CACHE_FLUSHES
,      CHECK_DUPES_FLAG
,      PROP_RLS_FLAG
,      CURRENT_ENTRY_CNT
,      DIALING_OPTIONS
,      ABANDON_LIMIT
,      TALK_TIME_LOCAL
,      PACING_METHOD
,      PACE_Y_N
,      PBX_NAME
,      LISTDB_TYPE
,      T1_MIN
,      T15_MIN
,      T9AM
,      T11AM
,      T12PM
,      T1PM
,      TIME_ZONE
,      ACCT_NAME_COLUMNS
,      DATA_FIELDS
,      DB_PASSWORD
,      ACCOUNT_ID
,      POST_PROC_FILE
,      JOURNAL_FLUSH
,      DIALING_TYPE
,      NPR_LST_DB_LIST
,      USER_DATA_SIZE
,      VERSION
,      CAMPAIGN_LIST_ID
,      SECURITY_GROUP_ID
,      OBJECT_VERSION_NUMBER
FROM IEO.IEO_CP_SERVICES_ALL;

Dependencies

[top of page]

IEO.IEO_CP_SERVICES_ALL does not reference any database object

IEO.IEO_CP_SERVICES_ALL is referenced by following:

SchemaAPPS
SynonymIEO_CP_SERVICES_ALL