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.

[Home] [Help]

View: BENBV_PIL_ELCTBL_CHC_POPL_V

Product:	BEN - Advanced Benefits
Description:	This view identifies the persons and the programs or plans not in program for which they have electable choices as a result of a life event.
Implementation/DBA Data:	APPS.BENBV_PIL_ELCTBL_CHC_POPL_V

View Text

SELECT PEL.CBR_ELIG_PERD_STRT_DT
, PEL.CBR_ELIG_PERD_END_DT
, PEL.PROGRAM_UPDATE_DATE
, PEL.DFLT_ENRT_DT
, PEL.DFLT_ASND_DT
, PEL.ELCNS_MADE_DT
, PEL.ENRT_PERD_END_DT
, PEL.ENRT_PERD_STRT_DT
, PEL.PROCG_END_DT
, PEL.UOM
, PEL.AUTO_ASND_DT
, PEL.BDGT_DUE_DT
, PEL.BDGT_ISS_DT
, PEL.WS_DUE_DT
, PEL.WS_ISS_DT
, PEL.COMMENTS
, PEL.MGR_OVRID_DT
, /* DESCRIPTIVE FLEXFIELD */ '_DF:BEN:BEN_PIL_ELCTBL_CHC_POPL:PEL'
, /* CODES */ PEL.CLS_ENRT_DT_TO_USE_CD
, HR_BIS.BIS_DECODE_LOOKUP('BEN_CLS_ENRT_DT_TO_USE'
, PEL.CLS_ENRT_DT_TO_USE_CD)
, PEL.ENRT_TYP_CYCL_CD
, HR_BIS.BIS_DECODE_LOOKUP('BEN_ENRT_TYP_CYCL'
, PEL.ENRT_TYP_CYCL_CD)
, PEL.PIL_ELCTBL_POPL_STAT_CD
, HR_BIS.BIS_DECODE_LOOKUP('BEN_PER_IN_LER_STAT'
, PEL.PIL_ELCTBL_POPL_STAT_CD)
, PEL.ACTY_REF_PERD_CD
, HR_BIS.BIS_DECODE_LOOKUP('BEN_ACTY_REF_PERD'
, PEL.ACTY_REF_PERD_CD)
, PEL.BDGT_ACC_CD
, HR_BIS.BIS_DECODE_LOOKUP('BEN_BDGT_ACC'
, PEL.BDGT_ACC_CD)
, PEL.POP_CD
, HR_BIS.BIS_DECODE_LOOKUP('BEN_POP'
, PEL.POP_CD)
, PEL.BDGT_STAT_CD
, HR_BIS.BIS_DECODE_LOOKUP('BEN_BDGT_STAT'
, PEL.BDGT_STAT_CD)
, PEL.WS_ACC_CD
, HR_BIS.BIS_DECODE_LOOKUP('BEN_WS_ACC'
, PEL.WS_ACC_CD)
, PEL.WS_STAT_CD
, HR_BIS.BIS_DECODE_LOOKUP('BEN_WS_STAT'
, PEL.WS_STAT_CD)
, PEL.BDGT_EXPORT_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, PEL.BDGT_EXPORT_FLAG)
, PEL.WS_EXPORT_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, PEL.WS_EXPORT_FLAG)
, /* ID COLUMNS */ PEL.PIL_ELCTBL_CHC_POPL_ID
, PEL.PER_IN_LER_ID
, PEL.PGM_ID
, PEL.REQUEST_ID
, PEL.PROGRAM_APPLICATION_ID
, PEL.PROGRAM_ID
, PEL.BUSINESS_GROUP_ID
, PEL.ENRT_PERD_ID
, PEL.LEE_RSN_ID
, PEL.PL_ID
, PEL.ASSIGNMENT_ID
, PEL.MGR_OVRID_PERSON_ID
, PEL.WS_MGR_ID
, /* WHO COLUMNS */ PEL.LAST_UPDATE_DATE
, PEL.LAST_UPDATED_BY
, PEL.CREATED_BY
, PEL.CREATION_DATE
FROM BEN_PIL_ELCTBL_CHC_POPL PEL
WHERE PEL.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID
, PEL.BUSINESS_GROUP_ID) WITH READ ONLY

Columns

Name
CBR_ELIG_PERD_STRT_DT
CBR_ELIG_PERD_END_DT
PROGRAM_UPDATE_DATE
DFLT_ENRT_DT
DFLT_ASND_DT
ELCNS_MADE_DT
ENRT_PERD_END_DT
ENRT_PERD_STRT_DT
PROCG_END_DT
UOM
AUTO_ASND_DT
BDGT_DUE_DT
BDGT_ISS_DT
WS_DUE_DT
WS_ISS_DT
COMMENTS
MGR_OVRID_DT
"_DF:PEL"
CLS_ENRT_DT_TO_USE_CD
CLS_ENRT_DT_TO_USE_CD_M
ENRT_TYP_CYCL_CD
ENRT_TYP_CYCL_CD_M
PIL_ELCTBL_POPL_STAT_CD
PIL_ELCTBL_POPL_STAT_CD_M
ACTY_REF_PERD_CD
ACTY_REF_PERD_CD_M
BDGT_ACC_CD
BDGT_ACC_CD_M
POP_CD
POP_CD_M
BDGT_STAT_CD
BDGT_STAT_CD_M
WS_ACC_CD
WS_ACC_CD_M
WS_STAT_CD
WS_STAT_CD_M
BDGT_EXPORT_FLAG
BDGT_EXPORT_FLAG_M
WS_EXPORT_FLAG
WS_EXPORT_FLAG_M
PIL_ELCTBL_CHC_POPL_ID
PER_IN_LER_ID
PGM_ID
REQUEST_ID
PROGRAM_APPLICATION_ID
PROGRAM_ID
BUSINESS_GROUP_ID
ENRT_PERD_ID
LEE_RSN_ID
PL_ID
ASSIGNMENT_ID
MGR_OVRID_PERSON_ID
WS_MGR_ID
LAST_UPDATE_DATE
LAST_UPDATED_BY
CREATED_BY
CREATION_DATE