[Home] [Help] [Dependency Information]
Object Name: | BEN_BATCH_PARAMETER |
---|---|
Object Type: | TABLE |
Owner: | BEN |
FND Design Data: | BEN.BEN_BATCH_PARAMETER |
Subobject Name: | |
Status: | VALID |
BEN_BATCH_PARAMETER identifies the number of threads, the chunk size per thread, and maximum
number of errors allowed per thread before that thread is errored, for each benefits concurrent
manager process and business group.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
BEN_BATCH_PARAMETER_PK | NORMAL | UNIQUE | APPS_TS_TX_IDX | BATCH_PARAMETER_ID |
BEN_BATCH_PARAMETER_FK1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | BUSINESS_GROUP_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
BATCH_PARAMETER_ID | NUMBER | (15) | Yes | System generated primary key column. |
BATCH_EXE_CD | VARCHAR2 | (30) | Batch process name. | |
BUSINESS_GROUP_ID | NUMBER | (15) | Yes | Foreign Key to HR_ORGANIZATION_UNITS |
THREAD_CNT_NUM | NUMBER | (15) | Number of threads. | |
MAX_ERR_NUM | NUMBER | (15) | Maximum error number. | |
CHUNK_SIZE | NUMBER | (15) | Size of each chunk for concurrent process. | |
LAST_UPDATE_DATE | DATE | Standard Who column - date when a user last updated this row. | ||
LAST_UPDATED_BY | NUMBER | (15) | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). | |
CREATED_BY | NUMBER | (15) | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). | |
CREATION_DATE | DATE | Standard who column - date when this row was created. | ||
OBJECT_VERSION_NUMBER | NUMBER | (9) | System-generated primary key. Increments by one each update. |
Cut, paste (and edit) the following text to query this object:
SELECT BATCH_PARAMETER_ID
, BATCH_EXE_CD
, BUSINESS_GROUP_ID
, THREAD_CNT_NUM
, MAX_ERR_NUM
, CHUNK_SIZE
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, CREATED_BY
, CREATION_DATE
, OBJECT_VERSION_NUMBER
FROM BEN.BEN_BATCH_PARAMETER;
BEN.BEN_BATCH_PARAMETER does not reference any database object
BEN.BEN_BATCH_PARAMETER is referenced by following:
|
|
|