Skip to content

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

VIEW: BEN.BEN_PIL_EPE_POPL_RBV#

Object Details
Object Name: BEN_PIL_EPE_POPL_RBV#
Object Type: VIEW
Owner: BEN
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
PIL_ELCTBL_CHC_POPL_ID NUMBER (15) Yes
PER_IN_LER_ID NUMBER (15) Yes
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

LAST_UPDATED_BY NUMBER (15)
LAST_UPDATE_LOGIN NUMBER (15)
CREATED_BY NUMBER (15)
CREATION_DATE DATE

REQUEST_ID NUMBER (15)
PROGRAM_APPLICATION_ID NUMBER (15)
PROGRAM_ID NUMBER (15)
PROGRAM_UPDATE_DATE DATE

OBJECT_VERSION_NUMBER NUMBER (9)
BUSINESS_GROUP_ID NUMBER (15)
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)
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# references the following:

SchemaBEN
TableBEN_PIL_EPE_POPL_RBV
BEN.BEN_PIL_EPE_POPL_RBV# is referenced by following:

SchemaAPPS
SynonymBEN_PIL_EPE_POPL_RBV
TriggerBEN_PIL_EPE_POPL_RBV_WHO