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

TABLE: BEN.BEN_COMP_OBJ_CACHE_ROW

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


BEN_COMP_OBJECT_CACHE_ROW holds the denormalized compensation information for a run of the Manage life events process.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Primary Key: BEN_COMP_OBJ_CACHE_ROW_PK
  1. ColumnCOMP_OBJ_CACHE_ROW_ID
Indexes
Index Type Uniqueness Tablespace Column
BEN_COMP_OBJ_CACHE_ROW_PK NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnCOMP_OBJ_CACHE_ROW_ID
BEN_COMP_OBJ_CACHE_ROW_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnCOMP_OBJ_CACHE_ID
Columns
Name Datatype Length Mandatory Comments
COMP_OBJ_CACHE_ROW_ID NUMBER (15) Yes System generated primary key column.
COMP_OBJ_CACHE_ID NUMBER (15) Yes Foreign key to BEN_COMP_OBJ_CACHE.
PGM_ID NUMBER (15)
Foreign key to BEN_PGM_F.
PTIP_ID NUMBER (15)
Foreign Key to BEN_PTIP_F.
PLIP_ID NUMBER (15)
Foreign key to BEN_PLIP_F.
PL_ID NUMBER (15)
Foreign Key to BEN_PL_F.
OIPL_ID NUMBER (15)
Foreign Key to BEN_OIPL_F.
PL_NIP VARCHAR2 (1) Yes Plan not in program.
ELIG_TRAN_STATE VARCHAR2 (100)
Eligibility transition state.
TRK_INELIG_PER_FLAG VARCHAR2 (1) Yes Track Ineligible Person Y or N.
PAR_PGM_ID NUMBER (15)
Foreign key top BEN_PGM_F.
PAR_PTIP_ID NUMBER (15)
Foreign key top BEN_PTIP_F.
PAR_PLIP_ID NUMBER (15)
Foreign key top BEN_PLIP_F.
PAR_PL_ID NUMBER (15)
Foreign key top BEN_PL_F.
FLAG_BIT_VAL NUMBER (15)
Bit value Y or N.
OIPLIP_FLAG_BIT_VAL NUMBER (15)
Option in plan in program bit value Y or N.
OIPLIP_ID NUMBER (15)
Foreign Key to BEN_OIPLIP_F.
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.
LAST_UPDATED_BY NUMBER (15)
Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE

Standard Who column - date when a user last updated this row.
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).
PAR_OPT_ID NUMBER

Foreign key top BEN_OPT_F.
Query Text

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


SELECT COMP_OBJ_CACHE_ROW_ID
,      COMP_OBJ_CACHE_ID
,      PGM_ID
,      PTIP_ID
,      PLIP_ID
,      PL_ID
,      OIPL_ID
,      PL_NIP
,      ELIG_TRAN_STATE
,      TRK_INELIG_PER_FLAG
,      PAR_PGM_ID
,      PAR_PTIP_ID
,      PAR_PLIP_ID
,      PAR_PL_ID
,      FLAG_BIT_VAL
,      OIPLIP_FLAG_BIT_VAL
,      OIPLIP_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      PAR_OPT_ID
FROM BEN.BEN_COMP_OBJ_CACHE_ROW;

Dependencies

[top of page]

BEN.BEN_COMP_OBJ_CACHE_ROW does not reference any database object

BEN.BEN_COMP_OBJ_CACHE_ROW is referenced by following:

SchemaBEN
ViewBEN_COMP_OBJ_CACHE_ROW#