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.

VIEW: BEN.BEN_ELIG_PER_ELCTBL_CHC#

Source

View Text - Preformatted


select ELIG_PER_ELCTBL_CHC_ID ELIG_PER_ELCTBL_CHC_ID, BUSINESS_GROUP_ID BUSINESS_GROUP_ID, ROLL_CRS_FLAG ROLL_CRS_FLAG, CRNTLY_ENRD_FLAG CRNTLY_ENRD_FLAG, DFLT_FLAG DFLT_FLAG, ELCTBL_FLAG ELCTBL_FLAG, MNDTRY_FLAG MNDTRY_FLAG, ALWS_DPNT_DSGN_FLAG ALWS_DPNT_DSGN_FLAG, COMP_LVL_CD COMP_LVL_CD, AUTO_ENRT_FLAG AUTO_ENRT_FLAG, CTFN_RQD_FLAG CTFN_RQD_FLAG, PER_IN_LER_ID PER_IN_LER_ID, YR_PERD_ID YR_PERD_ID, INTERIM_ELIG_PER_ELCTBL_CHC_ID INTERIM_ELIG_PER_ELCTBL_CHC_ID, PIL_ELCTBL_CHC_POPL_ID PIL_ELCTBL_CHC_POPL_ID, OIPLIP_ID OIPLIP_ID, PL_ORDR_NUM PL_ORDR_NUM, PLIP_ORDR_NUM PLIP_ORDR_NUM, PTIP_ORDR_NUM PTIP_ORDR_NUM, OIPL_ORDR_NUM OIPL_ORDR_NUM, EPE_ATTRIBUTE_CATEGORY EPE_ATTRIBUTE_CATEGORY, EPE_ATTRIBUTE1 EPE_ATTRIBUTE1, EPE_ATTRIBUTE2 EPE_ATTRIBUTE2, EPE_ATTRIBUTE3 EPE_ATTRIBUTE3, EPE_ATTRIBUTE4 EPE_ATTRIBUTE4, EPE_ATTRIBUTE5 EPE_ATTRIBUTE5, EPE_ATTRIBUTE6 EPE_ATTRIBUTE6, EPE_ATTRIBUTE7 EPE_ATTRIBUTE7, EPE_ATTRIBUTE8 EPE_ATTRIBUTE8, EPE_ATTRIBUTE9 EPE_ATTRIBUTE9, EPE_ATTRIBUTE10 EPE_ATTRIBUTE10, EPE_ATTRIBUTE11 EPE_ATTRIBUTE11, EPE_ATTRIBUTE12 EPE_ATTRIBUTE12, EPE_ATTRIBUTE13 EPE_ATTRIBUTE13, EPE_ATTRIBUTE14 EPE_ATTRIBUTE14, EPE_ATTRIBUTE15 EPE_ATTRIBUTE15, EPE_ATTRIBUTE16 EPE_ATTRIBUTE16, EPE_ATTRIBUTE17 EPE_ATTRIBUTE17, EPE_ATTRIBUTE18 EPE_ATTRIBUTE18, EPE_ATTRIBUTE19 EPE_ATTRIBUTE19, EPE_ATTRIBUTE20 EPE_ATTRIBUTE20, EPE_ATTRIBUTE21 EPE_ATTRIBUTE21, EPE_ATTRIBUTE22 EPE_ATTRIBUTE22, EPE_ATTRIBUTE23 EPE_ATTRIBUTE23, EPE_ATTRIBUTE24 EPE_ATTRIBUTE24, EPE_ATTRIBUTE25 EPE_ATTRIBUTE25, EPE_ATTRIBUTE26 EPE_ATTRIBUTE26, EPE_ATTRIBUTE27 EPE_ATTRIBUTE27, EPE_ATTRIBUTE28 EPE_ATTRIBUTE28, EPE_ATTRIBUTE29 EPE_ATTRIBUTE29, EPE_ATTRIBUTE30 EPE_ATTRIBUTE30, 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, REQUEST_ID REQUEST_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, MUST_ENRL_ANTHR_PL_ID MUST_ENRL_ANTHR_PL_ID, SPCL_RT_PL_ID SPCL_RT_PL_ID, SPCL_RT_OIPL_ID SPCL_RT_OIPL_ID, BNFT_PRVDR_POOL_ID BNFT_PRVDR_POOL_ID, CMBN_PTIP_ID CMBN_PTIP_ID, CMBN_PTIP_OPT_ID CMBN_PTIP_OPT_ID, CMBN_PLIP_ID CMBN_PLIP_ID, OIPL_ID OIPL_ID, PGM_ID PGM_ID, PL_ID PL_ID, PL_TYP_ID PL_TYP_ID, PLIP_ID PLIP_ID, PTIP_ID PTIP_ID, ENRT_CVG_STRT_DT_CD ENRT_CVG_STRT_DT_CD, ENRT_CVG_STRT_DT_RL ENRT_CVG_STRT_DT_RL, PRTT_ENRT_RSLT_ID PRTT_ENRT_RSLT_ID, DPNT_CVG_STRT_DT_CD DPNT_CVG_STRT_DT_CD, DPNT_CVG_STRT_DT_RL DPNT_CVG_STRT_DT_RL, ENRT_CVG_STRT_DT ENRT_CVG_STRT_DT, DPNT_DSGN_CD DPNT_DSGN_CD, LER_CHG_DPNT_CVG_CD LER_CHG_DPNT_CVG_CD, ERLST_DEENRT_DT ERLST_DEENRT_DT, PROCG_END_DT PROCG_END_DT, CRYFWD_ELIG_DPNT_CD CRYFWD_ELIG_DPNT_CD, IN_PNDG_WKFLOW_FLAG IN_PNDG_WKFLOW_FLAG, COMMENTS COMMENTS, ELIG_FLAG ELIG_FLAG, ELIG_OVRID_DT ELIG_OVRID_DT, ELIG_OVRID_PERSON_ID ELIG_OVRID_PERSON_ID, INELIG_RSN_CD INELIG_RSN_CD, MGR_OVRID_DT MGR_OVRID_DT, MGR_OVRID_PERSON_ID MGR_OVRID_PERSON_ID, WS_MGR_ID WS_MGR_ID, ASSIGNMENT_ID ASSIGNMENT_ID, APPROVAL_STATUS_CD APPROVAL_STATUS_CD, FONM_CVG_STRT_DT FONM_CVG_STRT_DT from "BEN"."BEN_ELIG_PER_ELCTBL_CHC"

View Text - HTML Formatted

SELECT ELIG_PER_ELCTBL_CHC_ID ELIG_PER_ELCTBL_CHC_ID
, BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, ROLL_CRS_FLAG ROLL_CRS_FLAG
, CRNTLY_ENRD_FLAG CRNTLY_ENRD_FLAG
, DFLT_FLAG DFLT_FLAG
, ELCTBL_FLAG ELCTBL_FLAG
, MNDTRY_FLAG MNDTRY_FLAG
, ALWS_DPNT_DSGN_FLAG ALWS_DPNT_DSGN_FLAG
, COMP_LVL_CD COMP_LVL_CD
, AUTO_ENRT_FLAG AUTO_ENRT_FLAG
, CTFN_RQD_FLAG CTFN_RQD_FLAG
, PER_IN_LER_ID PER_IN_LER_ID
, YR_PERD_ID YR_PERD_ID
, INTERIM_ELIG_PER_ELCTBL_CHC_ID INTERIM_ELIG_PER_ELCTBL_CHC_ID
, PIL_ELCTBL_CHC_POPL_ID PIL_ELCTBL_CHC_POPL_ID
, OIPLIP_ID OIPLIP_ID
, PL_ORDR_NUM PL_ORDR_NUM
, PLIP_ORDR_NUM PLIP_ORDR_NUM
, PTIP_ORDR_NUM PTIP_ORDR_NUM
, OIPL_ORDR_NUM OIPL_ORDR_NUM
, EPE_ATTRIBUTE_CATEGORY EPE_ATTRIBUTE_CATEGORY
, EPE_ATTRIBUTE1 EPE_ATTRIBUTE1
, EPE_ATTRIBUTE2 EPE_ATTRIBUTE2
, EPE_ATTRIBUTE3 EPE_ATTRIBUTE3
, EPE_ATTRIBUTE4 EPE_ATTRIBUTE4
, EPE_ATTRIBUTE5 EPE_ATTRIBUTE5
, EPE_ATTRIBUTE6 EPE_ATTRIBUTE6
, EPE_ATTRIBUTE7 EPE_ATTRIBUTE7
, EPE_ATTRIBUTE8 EPE_ATTRIBUTE8
, EPE_ATTRIBUTE9 EPE_ATTRIBUTE9
, EPE_ATTRIBUTE10 EPE_ATTRIBUTE10
, EPE_ATTRIBUTE11 EPE_ATTRIBUTE11
, EPE_ATTRIBUTE12 EPE_ATTRIBUTE12
, EPE_ATTRIBUTE13 EPE_ATTRIBUTE13
, EPE_ATTRIBUTE14 EPE_ATTRIBUTE14
, EPE_ATTRIBUTE15 EPE_ATTRIBUTE15
, EPE_ATTRIBUTE16 EPE_ATTRIBUTE16
, EPE_ATTRIBUTE17 EPE_ATTRIBUTE17
, EPE_ATTRIBUTE18 EPE_ATTRIBUTE18
, EPE_ATTRIBUTE19 EPE_ATTRIBUTE19
, EPE_ATTRIBUTE20 EPE_ATTRIBUTE20
, EPE_ATTRIBUTE21 EPE_ATTRIBUTE21
, EPE_ATTRIBUTE22 EPE_ATTRIBUTE22
, EPE_ATTRIBUTE23 EPE_ATTRIBUTE23
, EPE_ATTRIBUTE24 EPE_ATTRIBUTE24
, EPE_ATTRIBUTE25 EPE_ATTRIBUTE25
, EPE_ATTRIBUTE26 EPE_ATTRIBUTE26
, EPE_ATTRIBUTE27 EPE_ATTRIBUTE27
, EPE_ATTRIBUTE28 EPE_ATTRIBUTE28
, EPE_ATTRIBUTE29 EPE_ATTRIBUTE29
, EPE_ATTRIBUTE30 EPE_ATTRIBUTE30
, 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
, REQUEST_ID REQUEST_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, MUST_ENRL_ANTHR_PL_ID MUST_ENRL_ANTHR_PL_ID
, SPCL_RT_PL_ID SPCL_RT_PL_ID
, SPCL_RT_OIPL_ID SPCL_RT_OIPL_ID
, BNFT_PRVDR_POOL_ID BNFT_PRVDR_POOL_ID
, CMBN_PTIP_ID CMBN_PTIP_ID
, CMBN_PTIP_OPT_ID CMBN_PTIP_OPT_ID
, CMBN_PLIP_ID CMBN_PLIP_ID
, OIPL_ID OIPL_ID
, PGM_ID PGM_ID
, PL_ID PL_ID
, PL_TYP_ID PL_TYP_ID
, PLIP_ID PLIP_ID
, PTIP_ID PTIP_ID
, ENRT_CVG_STRT_DT_CD ENRT_CVG_STRT_DT_CD
, ENRT_CVG_STRT_DT_RL ENRT_CVG_STRT_DT_RL
, PRTT_ENRT_RSLT_ID PRTT_ENRT_RSLT_ID
, DPNT_CVG_STRT_DT_CD DPNT_CVG_STRT_DT_CD
, DPNT_CVG_STRT_DT_RL DPNT_CVG_STRT_DT_RL
, ENRT_CVG_STRT_DT ENRT_CVG_STRT_DT
, DPNT_DSGN_CD DPNT_DSGN_CD
, LER_CHG_DPNT_CVG_CD LER_CHG_DPNT_CVG_CD
, ERLST_DEENRT_DT ERLST_DEENRT_DT
, PROCG_END_DT PROCG_END_DT
, CRYFWD_ELIG_DPNT_CD CRYFWD_ELIG_DPNT_CD
, IN_PNDG_WKFLOW_FLAG IN_PNDG_WKFLOW_FLAG
, COMMENTS COMMENTS
, ELIG_FLAG ELIG_FLAG
, ELIG_OVRID_DT ELIG_OVRID_DT
, ELIG_OVRID_PERSON_ID ELIG_OVRID_PERSON_ID
, INELIG_RSN_CD INELIG_RSN_CD
, MGR_OVRID_DT MGR_OVRID_DT
, MGR_OVRID_PERSON_ID MGR_OVRID_PERSON_ID
, WS_MGR_ID WS_MGR_ID
, ASSIGNMENT_ID ASSIGNMENT_ID
, APPROVAL_STATUS_CD APPROVAL_STATUS_CD
, FONM_CVG_STRT_DT FONM_CVG_STRT_DT
FROM "BEN"."BEN_ELIG_PER_ELCTBL_CHC"