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

TABLE: BEN.BEN_PIL_EPE_POPL_RBV

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

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
BEN_PIL_EPE_POPL_RBV_PK NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnBENEFIT_ACTION_ID
ColumnPIL_ELCTBL_CHC_POPL_ID
BEN_PIL_EPE_POPL_RBV_FK2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPERSON_ACTION_ID
Columns
Name Datatype Length Mandatory Comments
PIL_ELCTBL_CHC_POPL_ID NUMBER (15) Yes
PER_IN_LER_ID NUMBER (15) Yes Foreign Key to BEN_PER_IN_LER.
PGM_ID NUMBER (15)
CBR_ELIG_PERD_STRT_DT DATE

CBR_ELIG_PERD_END_DT DATE

PEL_ATTRIBUTE_CATEGORY VARCHAR2 (30)
PEL_ATTRIBUTE1 VARCHAR2 (150)
PEL_ATTRIBUTE2 VARCHAR2 (150)
PEL_ATTRIBUTE3 VARCHAR2 (150)
PEL_ATTRIBUTE4 VARCHAR2 (150)
PEL_ATTRIBUTE5 VARCHAR2 (150)
PEL_ATTRIBUTE6 VARCHAR2 (150)
PEL_ATTRIBUTE7 VARCHAR2 (150)
PEL_ATTRIBUTE8 VARCHAR2 (150)
PEL_ATTRIBUTE9 VARCHAR2 (150)
PEL_ATTRIBUTE10 VARCHAR2 (150)
PEL_ATTRIBUTE11 VARCHAR2 (150)
PEL_ATTRIBUTE12 VARCHAR2 (150)
PEL_ATTRIBUTE13 VARCHAR2 (150)
PEL_ATTRIBUTE14 VARCHAR2 (150)
PEL_ATTRIBUTE15 VARCHAR2 (150)
PEL_ATTRIBUTE16 VARCHAR2 (150)
PEL_ATTRIBUTE17 VARCHAR2 (150)
PEL_ATTRIBUTE18 VARCHAR2 (150)
PEL_ATTRIBUTE19 VARCHAR2 (150)
PEL_ATTRIBUTE20 VARCHAR2 (150)
PEL_ATTRIBUTE21 VARCHAR2 (150)
PEL_ATTRIBUTE22 VARCHAR2 (150)
PEL_ATTRIBUTE23 VARCHAR2 (150)
PEL_ATTRIBUTE24 VARCHAR2 (150)
PEL_ATTRIBUTE25 VARCHAR2 (150)
PEL_ATTRIBUTE26 VARCHAR2 (150)
PEL_ATTRIBUTE27 VARCHAR2 (150)
PEL_ATTRIBUTE28 VARCHAR2 (150)
PEL_ATTRIBUTE29 VARCHAR2 (150)
PEL_ATTRIBUTE30 VARCHAR2 (150)
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.
REQUEST_ID NUMBER (15)
Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID).
PROGRAM_APPLICATION_ID NUMBER (15)
Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID).
PROGRAM_ID NUMBER (15)
Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID).
PROGRAM_UPDATE_DATE DATE

Concurrent Program who column - date when a program last updated this row).
OBJECT_VERSION_NUMBER NUMBER (9)
System-generated primary key. Increments by one each update.
BUSINESS_GROUP_ID NUMBER (15)
Foreign Key to HR_ORGANIZATION_UNITS
DFLT_ENRT_DT DATE

DFLT_ASND_DT DATE

ELCNS_MADE_DT DATE

CLS_ENRT_DT_TO_USE_CD VARCHAR2 (30)
ENRT_TYP_CYCL_CD VARCHAR2 (30)
ENRT_PERD_END_DT DATE

ENRT_PERD_STRT_DT DATE

PROCG_END_DT DATE

PIL_ELCTBL_POPL_STAT_CD VARCHAR2 (30)
ACTY_REF_PERD_CD VARCHAR2 (30)
UOM VARCHAR2 (30)
AUTO_ASND_DT DATE

ENRT_PERD_ID NUMBER (15)
LEE_RSN_ID NUMBER (15)
PL_ID NUMBER (15)
Foreign Key to BEN_PL_F.
BDGT_ACC_CD VARCHAR2 (30)
POP_CD VARCHAR2 (30)
BDGT_DUE_DT DATE

BDGT_EXPORT_FLAG VARCHAR2 (30) Yes
BDGT_ISS_DT DATE

BDGT_STAT_CD VARCHAR2 (30)
WS_ACC_CD VARCHAR2 (30)
WS_DUE_DT DATE

WS_EXPORT_FLAG VARCHAR2 (30) Yes
WS_ISS_DT DATE

WS_STAT_CD VARCHAR2 (30)
BENEFIT_ACTION_ID NUMBER
Yes
PERSON_ACTION_ID NUMBER

Query Text

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


SELECT PIL_ELCTBL_CHC_POPL_ID
,      PER_IN_LER_ID
,      PGM_ID
,      CBR_ELIG_PERD_STRT_DT
,      CBR_ELIG_PERD_END_DT
,      PEL_ATTRIBUTE_CATEGORY
,      PEL_ATTRIBUTE1
,      PEL_ATTRIBUTE2
,      PEL_ATTRIBUTE3
,      PEL_ATTRIBUTE4
,      PEL_ATTRIBUTE5
,      PEL_ATTRIBUTE6
,      PEL_ATTRIBUTE7
,      PEL_ATTRIBUTE8
,      PEL_ATTRIBUTE9
,      PEL_ATTRIBUTE10
,      PEL_ATTRIBUTE11
,      PEL_ATTRIBUTE12
,      PEL_ATTRIBUTE13
,      PEL_ATTRIBUTE14
,      PEL_ATTRIBUTE15
,      PEL_ATTRIBUTE16
,      PEL_ATTRIBUTE17
,      PEL_ATTRIBUTE18
,      PEL_ATTRIBUTE19
,      PEL_ATTRIBUTE20
,      PEL_ATTRIBUTE21
,      PEL_ATTRIBUTE22
,      PEL_ATTRIBUTE23
,      PEL_ATTRIBUTE24
,      PEL_ATTRIBUTE25
,      PEL_ATTRIBUTE26
,      PEL_ATTRIBUTE27
,      PEL_ATTRIBUTE28
,      PEL_ATTRIBUTE29
,      PEL_ATTRIBUTE30
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      OBJECT_VERSION_NUMBER
,      BUSINESS_GROUP_ID
,      DFLT_ENRT_DT
,      DFLT_ASND_DT
,      ELCNS_MADE_DT
,      CLS_ENRT_DT_TO_USE_CD
,      ENRT_TYP_CYCL_CD
,      ENRT_PERD_END_DT
,      ENRT_PERD_STRT_DT
,      PROCG_END_DT
,      PIL_ELCTBL_POPL_STAT_CD
,      ACTY_REF_PERD_CD
,      UOM
,      AUTO_ASND_DT
,      ENRT_PERD_ID
,      LEE_RSN_ID
,      PL_ID
,      BDGT_ACC_CD
,      POP_CD
,      BDGT_DUE_DT
,      BDGT_EXPORT_FLAG
,      BDGT_ISS_DT
,      BDGT_STAT_CD
,      WS_ACC_CD
,      WS_DUE_DT
,      WS_EXPORT_FLAG
,      WS_ISS_DT
,      WS_STAT_CD
,      BENEFIT_ACTION_ID
,      PERSON_ACTION_ID
FROM BEN.BEN_PIL_EPE_POPL_RBV;

Dependencies

[top of page]

BEN.BEN_PIL_EPE_POPL_RBV does not reference any database object

BEN.BEN_PIL_EPE_POPL_RBV is referenced by following:

SchemaAPPS
SynonymBEN_PIL_EPE_POPL_RBV
TriggerBEN_PIL_EPE_POPL_RBV_WHO