BEN_BATCH_BNFT_CERT_INFO

BEN_BATCH_BNFT_CERT_INFO contains benefit certification 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.

Details

• Schema: FUSION

• Object owner: BEN

• Object type: TABLE

• Tablespace: APPS_TS_TX_DATA

Primary Key

Name	Columns
BEN_BATCH_BNFT_CERT_INFO_PK	BATCH_BENFT_CERT_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments
BATCH_BENFT_CERT_ID	NUMBER		18	Yes	System generated primary key column.
BENEFIT_ACTION_ID	NUMBER		18	Yes	Foreign key to BEN_BENEFIT_ACTION.
PERSON_ID	NUMBER		18	Yes	Foreign Key to PER_PEOPLE_F.
BENEFIT_RELATION_ID	NUMBER		18		Foreign Key to BEN_BENEFIT_RELATIONS_F
ACTN_TYP_ID	NUMBER		18		Foreign Key to BEN_ACTN_TYP_F.
TYP_CD	VARCHAR2	30			Type.
ENRT_CTFN_RECD_DT	DATE				Enrollment certification received date.
BUSINESS_GROUP_ID	NUMBER		18	Yes	Foreign Key to HR_ORGANIZATION_UNITS
LAST_UPDATE_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the last update of the row.
LAST_UPDATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who last updated the row.
LAST_UPDATE_LOGIN	VARCHAR2	32			Who column: indicates the session login associated to the user who last updated the row.
CREATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who created the row.
CREATION_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the creation of the row.

Indexes

Index	Uniqueness	Tablespace	Columns
BEN_BATCH_BNFT_CERT_INFO_FK2	Non Unique		BENEFIT_RELATION_ID
BEN_BATCH_B_CERT_INFO_FK1	Non Unique	Default	BENEFIT_ACTION_ID
BEN_BATCH_B_CERT_INFO_N2	Non Unique	Default	PERSON_ID
BEN_BATCH_B_CERT_INFO_PK1	Unique	Default	BATCH_BENFT_CERT_ID