[Home] [Help]
[Dependency Information]
[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 deprecated | |
| 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 deprecated | |
| SEND_ORIG_LIST_FLG | VARCHAR2 | (5) | Obsolete deprecated | |
| SCRIPT_NAME | VARCHAR2 | (32) | Obsolete deprecated | |
| 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 deprecated | |
| 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 deprecated | ||
| 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 deprecated | |
| LAST_QBLOCK_BYTES | NUMBER | (9) | Bytes used in last .QLD file block | |
| MASTER_FILE_SPEC | VARCHAR2 | (250) | Obsolete deprecated | |
| MASTER_TABLE | VARCHAR2 | (30) | Table or view name from which customer data is loaded | |
| MASTER_FS_LEN | NUMBER | (9) | Obsolete deprecated | |
| NUM_AGENTS | NUMBER | (9) | Obsolete deprecated | |
| 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 deprecated | |
| 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 deprecated | |
| TALK_TIME_LOCAL | NUMBER | (9) | Obsolete deprecated | |
| PACING_METHOD | NUMBER | (9) | Obsolete deprecated | |
| PACE_Y_N | VARCHAR2 | (5) | Obsolete deprecated | |
| 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 deprecated | |
| 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:
IEO
IEO_CP_SERVICES_ALL#
|
|
|
|