DBA Data[Home] [Help]

VIEW: HRI.HRI_EQ_BEN_ELCTN_EVTS#

Source

View Text - Preformatted

select LF_EVT_OCRD_DT LF_EVT_OCRD_DT, EVENT_DATE EVENT_DATE, PERSON_ID PERSON_ID, PGM_ID PGM_ID, ELIG_IND ELIG_IND, ENRT_IND ENRT_IND, DFLT_IND DFLT_IND, EVENT_CD EVENT_CD, DFLT_ENRT_DT DFLT_ENRT_DT, DFLT_ASND_DT DFLT_ASND_DT, ELCNS_MADE_DT ELCNS_MADE_DT, ENRT_TYP_CYCL_CD ENRT_TYP_CYCL_CD, ENRT_PERD_END_DT ENRT_PERD_END_DT, ENRT_PERD_STRT_DT ENRT_PERD_STRT_DT, PROCG_END_DT PROCG_END_DT, PIL_ELCTBL_POPL_STAT_CD PIL_ELCTBL_POPL_STAT_CD, AUTO_ASND_DT AUTO_ASND_DT, FND_CONCURRENT_REQUEST_ID FND_CONCURRENT_REQUEST_ID, BUSINESS_GROUP_ID BUSINESS_GROUP_ID, PIL_ELCTBL_CHC_POPL_ID PIL_ELCTBL_CHC_POPL_ID, PER_IN_LER_ID PER_IN_LER_ID, PL_ID PL_ID, ENRT_PERD_ID ENRT_PERD_ID, ASSIGNMENT_ID ASSIGNMENT_ID, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE from "HRI"."HRI_EQ_BEN_ELCTN_EVTS"
View Text - HTML Formatted

SELECT LF_EVT_OCRD_DT LF_EVT_OCRD_DT
, EVENT_DATE EVENT_DATE
, PERSON_ID PERSON_ID
, PGM_ID PGM_ID
, ELIG_IND ELIG_IND
, ENRT_IND ENRT_IND
, DFLT_IND DFLT_IND
, EVENT_CD EVENT_CD
, DFLT_ENRT_DT DFLT_ENRT_DT
, DFLT_ASND_DT DFLT_ASND_DT
, ELCNS_MADE_DT ELCNS_MADE_DT
, ENRT_TYP_CYCL_CD ENRT_TYP_CYCL_CD
, ENRT_PERD_END_DT ENRT_PERD_END_DT
, ENRT_PERD_STRT_DT ENRT_PERD_STRT_DT
, PROCG_END_DT PROCG_END_DT
, PIL_ELCTBL_POPL_STAT_CD PIL_ELCTBL_POPL_STAT_CD
, AUTO_ASND_DT AUTO_ASND_DT
, FND_CONCURRENT_REQUEST_ID FND_CONCURRENT_REQUEST_ID
, BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, PIL_ELCTBL_CHC_POPL_ID PIL_ELCTBL_CHC_POPL_ID
, PER_IN_LER_ID PER_IN_LER_ID
, PL_ID PL_ID
, ENRT_PERD_ID ENRT_PERD_ID
, ASSIGNMENT_ID ASSIGNMENT_ID
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
FROM "HRI"."HRI_EQ_BEN_ELCTN_EVTS"