DBA Data[Home] [Help] [Dependency Information]

TABLE: BEN.BEN_BATCH_RATE_INFO

Object Details
Object Name: BEN_BATCH_RATE_INFO
Object Type: TABLE
Owner: BEN
FND Design Data: TableBEN.BEN_BATCH_RATE_INFO
Subobject Name:
Status: VALID


BEN_BATCH_RATE_INFO contains rate related data resulting from running concurrent manager processes.
.
BEN_BATCH tables store concurrent manager results so that this information is available for inclusion in reports, such as the activity summary report and audit log. This information is stored regardless of whether the process is run in validate (rollback) or commit mode.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Primary Key: BEN_BATCH_RATE_INFO_PK
  1. ColumnBATCH_RT_ID
Indexes
Index Type Uniqueness Tablespace Column
BEN_BATCH_RATE_INFO_PK NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnBATCH_RT_ID
BEN_BATCH_RATE_INFO_FK1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnBENEFIT_ACTION_ID
BEN_BATCH_RATE_INFO_FK2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnBUSINESS_GROUP_ID
BEN_BATCH_RATE_INFO_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPERSON_ID
BEN_BATCH_RATE_INFO_N3 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPL_ID
BEN_BATCH_RATE_INFO_N4 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnOIPL_ID
BEN_BATCH_RATE_INFO_N5 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPGM_ID
Columns
Name Datatype Length Mandatory Comments
BATCH_RT_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.
ENRT_CVG_STRT_DT DATE

Enrollment coverage start date.
ENRT_CVG_THRU_DT DATE

Enrollment coverage through date.
ACTN_CD VARCHAR2 (30)
Action code.
CLOSE_ACTN_ITM_DT DATE

Close action item date.
PERSON_ID NUMBER (15) Yes Foreign Key to PER_PEOPLE_F.
PGM_ID NUMBER (15)
Foreign key to BEN_PGM_F.
PL_ID NUMBER (15)
Foreign Key to BEN_PL_F.
OIPL_ID NUMBER (15)
Foreign Key to BEN_OIPL_F.
BNFT_RT_TYP_CD VARCHAR2 (30)
Benefit rate type.
DFLT_FLAG VARCHAR2 (30) Yes Default Y or N.
VAL NUMBER (38)
Value.
TX_TYP_CD VARCHAR2 (30)
Tax type.
ACTY_TYP_CD VARCHAR2 (30)
Activity type.
MN_ELCN_VAL NUMBER (38)
Minimum election value.
MX_ELCN_VAL NUMBER (38)
Maximum election value.
INCRMT_ELCN_VAL NUMBER (38)
Increment election value.
DFLT_VAL NUMBER (38)
Default value.
RT_STRT_DT DATE

Rate start date.
LAST_UPDATE_DATE DATE

Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY VARCHAR2 (15)
Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN VARCHAR2 (15)
Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
CREATED_BY VARCHAR2 (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.
OLD_VAL NUMBER

Old value.
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT BATCH_RT_ID
,      BUSINESS_GROUP_ID
,      BENEFIT_ACTION_ID
,      ENRT_CVG_STRT_DT
,      ENRT_CVG_THRU_DT
,      ACTN_CD
,      CLOSE_ACTN_ITM_DT
,      PERSON_ID
,      PGM_ID
,      PL_ID
,      OIPL_ID
,      BNFT_RT_TYP_CD
,      DFLT_FLAG
,      VAL
,      TX_TYP_CD
,      ACTY_TYP_CD
,      MN_ELCN_VAL
,      MX_ELCN_VAL
,      INCRMT_ELCN_VAL
,      DFLT_VAL
,      RT_STRT_DT
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
,      OBJECT_VERSION_NUMBER
,      OLD_VAL
FROM BEN.BEN_BATCH_RATE_INFO;

Dependencies

[top of page]

BEN.BEN_BATCH_RATE_INFO does not reference any database object

BEN.BEN_BATCH_RATE_INFO is referenced by following:

SchemaAPPS
SynonymBEN_BATCH_RATE_INFO