[Home] [Help] [Dependency Information]
Object Name: | IEO_CP_SERVICES_ALL |
---|---|
Object Type: | TABLE |
Owner: | IEO |
FND Design Data: | IEO.IEO_CP_SERVICES_ALL |
Subobject Name: | |
Status: | VALID |
Setup/configuration for all Campaign Plus services on this system
Tablespace: | APPS_TS_ARCHIVE |
---|---|
PCT Free: | 10 |
PCT Used: |
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. |
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;
IEO.IEO_CP_SERVICES_ALL does not reference any database object
IEO.IEO_CP_SERVICES_ALL is referenced by following:
|
|
|