[Home] [Help] [Dependency Information]
Object Name: | BEN_BATCH_PROC_INFO |
---|---|
Object Type: | TABLE |
Owner: | BEN |
FND Design Data: | BEN.BEN_BATCH_PROC_INFO |
Subobject Name: | |
Status: | VALID |
BEN_BATCH_PROC_INFO contains statistical data about each benefits concurrent manager process that was run. It includes information such as the start and end time of the job, elapsed time, number of persons processed, and the number of errors generated.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
BEN_BATCH_PROC_INFO_PK | NORMAL | UNIQUE | APPS_TS_TX_IDX | BATCH_PROC_ID |
BEN_BATCH_PROC_INFO_FK1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | BENEFIT_ACTION_ID |
BEN_BATCH_PROC_INFO_FK2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | BUSINESS_GROUP_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
BATCH_PROC_ID | NUMBER | (15) | Yes | System generated primary key column. |
BUSINESS_GROUP_ID | NUMBER | (15) | Yes | Foreign Key to HR_ORGANIZATION_UNITS |
BENEFIT_ACTION_ID | NUMBER | (15) | Yes | Foreign key to BEN_BENEFIT_ACTION. |
STRT_DT | DATE | Start date. | ||
END_DT | DATE | End date. | ||
STRT_TM | VARCHAR2 | (90) | Start time. | |
END_TM | VARCHAR2 | (90) | End time. | |
ELPSD_TM | VARCHAR2 | (90) | Elapsed time. | |
PER_SLCTD | NUMBER | (15) | Number of persons selected. | |
PER_PROC | NUMBER | (15) | Number of persons processed. | |
PER_UNPROC | NUMBER | (15) | Number of persons un-processed. | |
PER_PROC_SUCC | NUMBER | (15) | Number of persons processed successfully. | |
PER_ERR | NUMBER | (15) | Number of persons with errors. | |
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) | Yes | System-generated primary key. Increments by one each update. |
Cut, paste (and edit) the following text to query this object:
SELECT BATCH_PROC_ID
, BUSINESS_GROUP_ID
, BENEFIT_ACTION_ID
, STRT_DT
, END_DT
, STRT_TM
, END_TM
, ELPSD_TM
, PER_SLCTD
, PER_PROC
, PER_UNPROC
, PER_PROC_SUCC
, PER_ERR
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, CREATED_BY
, CREATION_DATE
, OBJECT_VERSION_NUMBER
FROM BEN.BEN_BATCH_PROC_INFO;
BEN.BEN_BATCH_PROC_INFO does not reference any database object
BEN.BEN_BATCH_PROC_INFO is referenced by following:
|
|
|