[Home] [Help] [Dependency Information]
Object Name: | BEN_BATCH_RANGES |
---|---|
Object Type: | TABLE |
Owner: | BEN |
FND Design Data: | BEN.BEN_BATCH_RANGES |
Subobject Name: | |
Status: | VALID |
BEN_BATCH_RANGES contains ranges of people that are going to be processedby multi-threaded
programs. The number of people in a range is set by the chunk size for that particular concurrent program. The threads within a concurrent program attempt to process ranges of people until all ranges have been exhausted. The total number of ranges will be the number of people to be processed divided by the chunk size.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
BEN_BATCH_RANGES_PK | NORMAL | UNIQUE | APPS_TS_TX_IDX | RANGE_ID |
BEN_BATCH_RANGES_CK | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
BENEFIT_ACTION_ID
RANGE_STATUS_CD |
BEN_BATCH_RANGES_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | ENDING_PERSON_ACTION_ID |
BEN_BATCH_RANGES_N2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | STARTING_PERSON_ACTION_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
RANGE_ID | NUMBER | (15) | Yes | System generated primary key column. |
BENEFIT_ACTION_ID | NUMBER | (15) | Yes | Foreign key to BEN_BENEFIT_ACTION. |
RANGE_STATUS_CD | VARCHAR2 | (30) | Yes | Range status. |
STARTING_PERSON_ACTION_ID | NUMBER | (15) | Yes | Foreign key to BEN_PERSON_ACTIONS. |
ENDING_PERSON_ACTION_ID | NUMBER | (15) | Yes | Foreign key to PER_PEOPLE_F. |
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 RANGE_ID
, BENEFIT_ACTION_ID
, RANGE_STATUS_CD
, STARTING_PERSON_ACTION_ID
, ENDING_PERSON_ACTION_ID
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, CREATED_BY
, CREATION_DATE
, OBJECT_VERSION_NUMBER
FROM BEN.BEN_BATCH_RANGES;
BEN.BEN_BATCH_RANGES does not reference any database object
BEN.BEN_BATCH_RANGES is referenced by following:
|
|
|