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

TABLE: BEN.BEN_PERSON_ACTIONS

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


BEN_PERSON_ACTIONS identifies persons being processed in a benefits concurrent manager process.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Primary Key: BEN_PERSON_ACTIONS_PK
  1. ColumnPERSON_ACTION_ID
Indexes
Index Type Uniqueness Tablespace Column
BEN_PERSON_ACTIONS_PK NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnPERSON_ACTION_ID
BEN_PERSON_ACTIONS_FK3 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnBENEFIT_ACTION_ID
BEN_PERSON_ACTIONS_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPERSON_ID
BEN_PERSON_ACTIONS_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnLER_ID
BEN_PERSON_ACTION_N3 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnBENEFIT_ACTION_ID
ColumnPERSON_ID
Columns
Name Datatype Length Mandatory Comments
PERSON_ACTION_ID NUMBER (15) Yes System generated primary key column.
PERSON_ID NUMBER (15) Yes Foreign Key to PER_PEOPLE_F.
BENEFIT_ACTION_ID NUMBER (15) Yes Foreign key to BEN_BENEFIT_ACTION.
ACTION_STATUS_CD VARCHAR2 (30) Yes Action status.
OBJECT_VERSION_NUMBER NUMBER (15) Yes System-generated primary key. Increments by one each update.
LER_ID NUMBER (15)
Foreign Key to BEN_LER_F.
CHUNK_NUMBER NUMBER (15)
Number of chunks for concurrent process.
NON_PERSON_CD VARCHAR2 (30)
Non-person code.
Query Text

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


SELECT PERSON_ACTION_ID
,      PERSON_ID
,      BENEFIT_ACTION_ID
,      ACTION_STATUS_CD
,      OBJECT_VERSION_NUMBER
,      LER_ID
,      CHUNK_NUMBER
,      NON_PERSON_CD
FROM BEN.BEN_PERSON_ACTIONS;

Dependencies

[top of page]

BEN.BEN_PERSON_ACTIONS does not reference any database object

BEN.BEN_PERSON_ACTIONS is referenced by following:

SchemaBEN
ViewBEN_PERSON_ACTIONS#