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_PERSON_ACTION_ITEMS

Object Details

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

BEN_PERSON_ACTION_ITEMS identifies action items for a person.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
BEN_PERSON_ACTION_ITEMS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ACTN_TYP_ID
BEN_PERSON_ACTION_ITEMS_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	TRANSACTION_ID TRANSACTION_TYPE
BEN_PERSON_ACTION_ITEMS_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PERSON_ID
BEN_PERSON_ACTION_ITEMS_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ASSIGNMENT_ID
BEN_PERSON_ACTION_ITEMS_N5	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	STATUS
BEN_PERSON_ACTION_ITEMS_N6	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	DUE_DATE
BEN_PERSON_ACTION_ITEMS_U1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PERSON_ACTION_ITEM_ID

Columns

Name	Datatype	Length	Mandatory	Comments
PERSON_ACTION_ITEM_ID	NUMBER	(15)	Yes	System generated primary key
ACTN_TYP_ID	NUMBER	(15)	Yes	Foreign key to BEN_ACTN_TYP
TRANSACTION_TYPE	VARCHAR2	(60)		Transaction type
TRANSACTION_ID	NUMBER	(15)	Yes	Foreign key to BEN_ICD_TRANSACTION
PERSON_ID	NUMBER	(15)	Yes	Foreign key to PER_ALL_PEOPLE_F
ASSIGNMENT_ID	NUMBER	(15)	Yes	Foreign key to PER_ALL_ASSIGNMENTS_F
EFFECTIVE_DATE	DATE			Effective date
PL_ID	NUMBER	(15)		Foreign key to BEN_PL_F
STATUS	VARCHAR2	(30)		Status
DUE_DATE	DATE			Due Date
OBJECT_VERSION_NUMBER	NUMBER	(9)		Change Indicator column
COMPLETE_DATE	DATE			Complete date
VOID_DATE	DATE			Void date
LAST_UPDATE_DATE	DATE			Standard who column
LAST_UPDATED_BY	NUMBER	(15)		Standard who column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard who column
CREATED_BY	NUMBER	(15)		Standard who column
CREATION_DATE	DATE			Standard who column

Query Text

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


SELECT PERSON_ACTION_ITEM_ID
,      ACTN_TYP_ID
,      TRANSACTION_TYPE
,      TRANSACTION_ID
,      PERSON_ID
,      ASSIGNMENT_ID
,      EFFECTIVE_DATE
,      PL_ID
,      STATUS
,      DUE_DATE
,      OBJECT_VERSION_NUMBER
,      COMPLETE_DATE
,      VOID_DATE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
FROM BEN.BEN_PERSON_ACTION_ITEMS;

Dependencies

[top of page]

BEN.BEN_PERSON_ACTION_ITEMS does not reference any database object

BEN.BEN_PERSON_ACTION_ITEMS is referenced by following:

BEN: BEN_PERSON_ACTION_ITEMS#