eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: BEN.BEN_EXT_CHG_EVT_LOG

Object Details

Object Name:	BEN_EXT_CHG_EVT_LOG
Object Type:	TABLE
Owner:	BEN
FND Design Data:	BEN.BEN_EXT_CHG_EVT_LOG
Subobject Name:
Status:	VALID

BEN_EXT_CHG_EVT_LOG contains the list of changes that occur to a person as a result of actions such as receiving an assignment, enrolling in a comp plan or changing an address.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Primary Key: BEN_EXT_CHG_EVT_LOG_PK

EXT_CHG_EVT_LOG_ID

Indexes

Index	Type	Uniqueness	Tablespace	Column
BEN_EXT_CHG_EVT_LOG_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	EXT_CHG_EVT_LOG_ID
BEN_EXT_CHG_EVT_LOG_FK1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	BUSINESS_GROUP_ID
BEN_EXT_CHG_EVT_LOG_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PERSON_ID

Columns

Name	Datatype	Length	Mandatory	Comments
EXT_CHG_EVT_LOG_ID	NUMBER	(15)	Yes	System generated primary key column.
BUSINESS_GROUP_ID	NUMBER	(15)	Yes	Foreign Key to HR_ORGANIZATION_UNITS
CHG_EVT_CD	VARCHAR2	(30)	Yes	Change event type.
CHG_EFF_DT	DATE		Yes	Change effective date.
PERSON_ID	NUMBER	(15)	Yes	Foreign Key to PER_PEOPLE_F.
OLD_VAL1	VARCHAR2	(600)		Old Val1.
OLD_VAL2	VARCHAR2	(600)		Old Val2.
OLD_VAL3	VARCHAR2	(600)		Old Val3.
OLD_VAL4	VARCHAR2	(600)		Old Val4.
OLD_VAL5	VARCHAR2	(600)		Old Val5.
OLD_VAL6	VARCHAR2	(600)		Old Val6.
NEW_VAL1	VARCHAR2	(600)		New Val1.
NEW_VAL2	VARCHAR2	(600)		New Val2.
NEW_VAL3	VARCHAR2	(600)		New Val3.
NEW_VAL4	VARCHAR2	(600)		New Val4.
NEW_VAL5	VARCHAR2	(600)		New Val5.
NEW_VAL6	VARCHAR2	(600)		New Val6.
CHG_USER_ID	NUMBER	(15)		Change user identifier.
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.
CHG_ACTL_DT	DATE			Change actual date.
PRMTR_01	VARCHAR2	(90)		Parameter 01.
PRMTR_02	VARCHAR2	(90)		Parameter 02.
PRMTR_03	VARCHAR2	(90)		Parameter 03.
PRMTR_04	VARCHAR2	(90)		Parameter 04.
PRMTR_05	VARCHAR2	(90)		Parameter 05.
PRMTR_06	VARCHAR2	(90)		Parameter 06.
PRMTR_07	VARCHAR2	(90)		Parameter 07.
PRMTR_08	VARCHAR2	(90)		Parameter 08.
PRMTR_09	VARCHAR2	(90)		Parameter 09.
PRMTR_10	VARCHAR2	(90)		Parameter 10.

Query Text

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


SELECT EXT_CHG_EVT_LOG_ID
,      BUSINESS_GROUP_ID
,      CHG_EVT_CD
,      CHG_EFF_DT
,      PERSON_ID
,      OLD_VAL1
,      OLD_VAL2
,      OLD_VAL3
,      OLD_VAL4
,      OLD_VAL5
,      OLD_VAL6
,      NEW_VAL1
,      NEW_VAL2
,      NEW_VAL3
,      NEW_VAL4
,      NEW_VAL5
,      NEW_VAL6
,      CHG_USER_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
,      OBJECT_VERSION_NUMBER
,      CHG_ACTL_DT
,      PRMTR_01
,      PRMTR_02
,      PRMTR_03
,      PRMTR_04
,      PRMTR_05
,      PRMTR_06
,      PRMTR_07
,      PRMTR_08
,      PRMTR_09
,      PRMTR_10
FROM BEN.BEN_EXT_CHG_EVT_LOG;

Dependencies

[top of page]

BEN.BEN_EXT_CHG_EVT_LOG does not reference any database object

BEN.BEN_EXT_CHG_EVT_LOG is referenced by following:

APPS: BEN_EXT_CHG_EVT_LOG; BEN_EXT_CHG_EVT_LOG_WHO