VIEW: BEN.BEN_ELIGY_PRFL_F#

Source

View Text - Preformatted

select ELIGY_PRFL_ID ELIGY_PRFL_ID, EFFECTIVE_START_DATE EFFECTIVE_START_DATE, EFFECTIVE_END_DATE EFFECTIVE_END_DATE, NAME NAME, STAT_CD STAT_CD, BUSINESS_GROUP_ID BUSINESS_GROUP_ID, ELIG_ENRLD_PLIP_FLAG ELIG_ENRLD_PLIP_FLAG, ELIG_CBR_QUALD_BNF_FLAG ELIG_CBR_QUALD_BNF_FLAG, ELIG_ENRLD_PTIP_FLAG ELIG_ENRLD_PTIP_FLAG, ELIG_DPNT_CVRD_PLIP_FLAG ELIG_DPNT_CVRD_PLIP_FLAG, ELIG_DPNT_CVRD_PTIP_FLAG ELIG_DPNT_CVRD_PTIP_FLAG, ELIG_DPNT_CVRD_PGM_FLAG ELIG_DPNT_CVRD_PGM_FLAG, ELIG_JOB_FLAG ELIG_JOB_FLAG, ELIG_HRLY_SLRD_FLAG ELIG_HRLY_SLRD_FLAG, ELIG_PSTL_CD_FLAG ELIG_PSTL_CD_FLAG, ELIG_LBR_MMBR_FLAG ELIG_LBR_MMBR_FLAG, ELIG_LGL_ENTY_FLAG ELIG_LGL_ENTY_FLAG, ELIG_BENFTS_GRP_FLAG ELIG_BENFTS_GRP_FLAG, ELIG_WK_LOC_FLAG ELIG_WK_LOC_FLAG, ELIG_BRGNG_UNIT_FLAG ELIG_BRGNG_UNIT_FLAG, ELIG_AGE_FLAG ELIG_AGE_FLAG, ELIG_LOS_FLAG ELIG_LOS_FLAG, ELIG_PER_TYP_FLAG ELIG_PER_TYP_FLAG, ELIG_FL_TM_PT_TM_FLAG ELIG_FL_TM_PT_TM_FLAG, ELIG_EE_STAT_FLAG ELIG_EE_STAT_FLAG, ELIG_GRD_FLAG ELIG_GRD_FLAG, ELIG_PCT_FL_TM_FLAG ELIG_PCT_FL_TM_FLAG, ELIG_ASNT_SET_FLAG ELIG_ASNT_SET_FLAG, ELIG_HRS_WKD_FLAG ELIG_HRS_WKD_FLAG, ELIG_COMP_LVL_FLAG ELIG_COMP_LVL_FLAG, ELIG_ORG_UNIT_FLAG ELIG_ORG_UNIT_FLAG, ELIG_LOA_RSN_FLAG ELIG_LOA_RSN_FLAG, ELIG_PYRL_FLAG ELIG_PYRL_FLAG, ELIG_SCHEDD_HRS_FLAG ELIG_SCHEDD_HRS_FLAG, ELIG_PY_BSS_FLAG ELIG_PY_BSS_FLAG, ELIGY_PRFL_RL_FLAG ELIGY_PRFL_RL_FLAG, ELIG_CMBN_AGE_LOS_FLAG ELIG_CMBN_AGE_LOS_FLAG, CNTNG_PRTN_ELIG_PRFL_FLAG CNTNG_PRTN_ELIG_PRFL_FLAG, ELIG_PRTT_PL_FLAG ELIG_PRTT_PL_FLAG, ELIG_PPL_GRP_FLAG ELIG_PPL_GRP_FLAG, ELIG_SVC_AREA_FLAG ELIG_SVC_AREA_FLAG, ELIG_PTIP_PRTE_FLAG ELIG_PTIP_PRTE_FLAG, ELIG_NO_OTHR_CVG_FLAG ELIG_NO_OTHR_CVG_FLAG, ELIG_ENRLD_PL_FLAG ELIG_ENRLD_PL_FLAG, ELIG_ENRLD_OIPL_FLAG ELIG_ENRLD_OIPL_FLAG, ELIG_ENRLD_PGM_FLAG ELIG_ENRLD_PGM_FLAG, ELIG_DPNT_CVRD_PL_FLAG ELIG_DPNT_CVRD_PL_FLAG, ELIG_LVG_RSN_FLAG ELIG_LVG_RSN_FLAG, ELIG_OPTD_MDCR_FLAG ELIG_OPTD_MDCR_FLAG, ELIG_TBCO_USE_FLAG ELIG_TBCO_USE_FLAG, ELP_ATTRIBUTE_CATEGORY ELP_ATTRIBUTE_CATEGORY, ELP_ATTRIBUTE1 ELP_ATTRIBUTE1, ELP_ATTRIBUTE2 ELP_ATTRIBUTE2, ELP_ATTRIBUTE3 ELP_ATTRIBUTE3, ELP_ATTRIBUTE4 ELP_ATTRIBUTE4, ELP_ATTRIBUTE5 ELP_ATTRIBUTE5, ELP_ATTRIBUTE6 ELP_ATTRIBUTE6, ELP_ATTRIBUTE7 ELP_ATTRIBUTE7, ELP_ATTRIBUTE8 ELP_ATTRIBUTE8, ELP_ATTRIBUTE9 ELP_ATTRIBUTE9, ELP_ATTRIBUTE10 ELP_ATTRIBUTE10, ELP_ATTRIBUTE11 ELP_ATTRIBUTE11, ELP_ATTRIBUTE12 ELP_ATTRIBUTE12, ELP_ATTRIBUTE13 ELP_ATTRIBUTE13, ELP_ATTRIBUTE14 ELP_ATTRIBUTE14, ELP_ATTRIBUTE15 ELP_ATTRIBUTE15, ELP_ATTRIBUTE16 ELP_ATTRIBUTE16, ELP_ATTRIBUTE17 ELP_ATTRIBUTE17, ELP_ATTRIBUTE18 ELP_ATTRIBUTE18, ELP_ATTRIBUTE19 ELP_ATTRIBUTE19, ELP_ATTRIBUTE20 ELP_ATTRIBUTE20, ELP_ATTRIBUTE21 ELP_ATTRIBUTE21, ELP_ATTRIBUTE22 ELP_ATTRIBUTE22, ELP_ATTRIBUTE23 ELP_ATTRIBUTE23, ELP_ATTRIBUTE24 ELP_ATTRIBUTE24, ELP_ATTRIBUTE25 ELP_ATTRIBUTE25, ELP_ATTRIBUTE26 ELP_ATTRIBUTE26, ELP_ATTRIBUTE27 ELP_ATTRIBUTE27, ELP_ATTRIBUTE28 ELP_ATTRIBUTE28, ELP_ATTRIBUTE29 ELP_ATTRIBUTE29, ELP_ATTRIBUTE30 ELP_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, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, DESCRIPTION DESCRIPTION, ASG_TYP_CD ASG_TYP_CD, ASMT_TO_USE_CD ASMT_TO_USE_CD, ELIG_DPNT_OTHR_PTIP_FLAG ELIG_DPNT_OTHR_PTIP_FLAG, ELIG_GNDR_FLAG ELIG_GNDR_FLAG, ELIG_DSBLTY_CTG_FLAG ELIG_DSBLTY_CTG_FLAG, ELIG_DSBLTY_DGR_FLAG ELIG_DSBLTY_DGR_FLAG, ELIG_DSBLTY_RSN_FLAG ELIG_DSBLTY_RSN_FLAG, ELIG_MRTL_STS_FLAG ELIG_MRTL_STS_FLAG, ELIG_PRBTN_PERD_FLAG ELIG_PRBTN_PERD_FLAG, ELIG_SP_CLNG_PRG_PT_FLAG ELIG_SP_CLNG_PRG_PT_FLAG, ELIG_SUPPL_ROLE_FLAG ELIG_SUPPL_ROLE_FLAG, ELIG_QUAL_TITL_FLAG ELIG_QUAL_TITL_FLAG, ELIG_PSTN_FLAG ELIG_PSTN_FLAG, BNFT_CAGR_PRTN_CD BNFT_CAGR_PRTN_CD, ELIG_DSBLD_FLAG ELIG_DSBLD_FLAG, ELIG_TTL_CVG_VOL_FLAG ELIG_TTL_CVG_VOL_FLAG, ELIG_TTL_PRTT_FLAG ELIG_TTL_PRTT_FLAG, ELIG_COMPTNCY_FLAG ELIG_COMPTNCY_FLAG, ELIG_HLTH_CVG_FLAG ELIG_HLTH_CVG_FLAG, ELIG_ANTHR_PL_FLAG ELIG_ANTHR_PL_FLAG, ELIG_PERF_RTNG_FLAG ELIG_PERF_RTNG_FLAG, ELIG_QUA_IN_GR_FLAG ELIG_QUA_IN_GR_FLAG, ELIG_CRIT_VALUES_FLAG ELIG_CRIT_VALUES_FLAG from "BEN"."BEN_ELIGY_PRFL_F"

View Text - HTML Formatted

SELECT ELIGY_PRFL_ID ELIGY_PRFL_ID
, EFFECTIVE_START_DATE EFFECTIVE_START_DATE
, EFFECTIVE_END_DATE EFFECTIVE_END_DATE
, NAME NAME
, STAT_CD STAT_CD
, BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, ELIG_ENRLD_PLIP_FLAG ELIG_ENRLD_PLIP_FLAG
, ELIG_CBR_QUALD_BNF_FLAG ELIG_CBR_QUALD_BNF_FLAG
, ELIG_ENRLD_PTIP_FLAG ELIG_ENRLD_PTIP_FLAG
, ELIG_DPNT_CVRD_PLIP_FLAG ELIG_DPNT_CVRD_PLIP_FLAG
, ELIG_DPNT_CVRD_PTIP_FLAG ELIG_DPNT_CVRD_PTIP_FLAG
, ELIG_DPNT_CVRD_PGM_FLAG ELIG_DPNT_CVRD_PGM_FLAG
, ELIG_JOB_FLAG ELIG_JOB_FLAG
, ELIG_HRLY_SLRD_FLAG ELIG_HRLY_SLRD_FLAG
, ELIG_PSTL_CD_FLAG ELIG_PSTL_CD_FLAG
, ELIG_LBR_MMBR_FLAG ELIG_LBR_MMBR_FLAG
, ELIG_LGL_ENTY_FLAG ELIG_LGL_ENTY_FLAG
, ELIG_BENFTS_GRP_FLAG ELIG_BENFTS_GRP_FLAG
, ELIG_WK_LOC_FLAG ELIG_WK_LOC_FLAG
, ELIG_BRGNG_UNIT_FLAG ELIG_BRGNG_UNIT_FLAG
, ELIG_AGE_FLAG ELIG_AGE_FLAG
, ELIG_LOS_FLAG ELIG_LOS_FLAG
, ELIG_PER_TYP_FLAG ELIG_PER_TYP_FLAG
, ELIG_FL_TM_PT_TM_FLAG ELIG_FL_TM_PT_TM_FLAG
, ELIG_EE_STAT_FLAG ELIG_EE_STAT_FLAG
, ELIG_GRD_FLAG ELIG_GRD_FLAG
, ELIG_PCT_FL_TM_FLAG ELIG_PCT_FL_TM_FLAG
, ELIG_ASNT_SET_FLAG ELIG_ASNT_SET_FLAG
, ELIG_HRS_WKD_FLAG ELIG_HRS_WKD_FLAG
, ELIG_COMP_LVL_FLAG ELIG_COMP_LVL_FLAG
, ELIG_ORG_UNIT_FLAG ELIG_ORG_UNIT_FLAG
, ELIG_LOA_RSN_FLAG ELIG_LOA_RSN_FLAG
, ELIG_PYRL_FLAG ELIG_PYRL_FLAG
, ELIG_SCHEDD_HRS_FLAG ELIG_SCHEDD_HRS_FLAG
, ELIG_PY_BSS_FLAG ELIG_PY_BSS_FLAG
, ELIGY_PRFL_RL_FLAG ELIGY_PRFL_RL_FLAG
, ELIG_CMBN_AGE_LOS_FLAG ELIG_CMBN_AGE_LOS_FLAG
, CNTNG_PRTN_ELIG_PRFL_FLAG CNTNG_PRTN_ELIG_PRFL_FLAG
, ELIG_PRTT_PL_FLAG ELIG_PRTT_PL_FLAG
, ELIG_PPL_GRP_FLAG ELIG_PPL_GRP_FLAG
, ELIG_SVC_AREA_FLAG ELIG_SVC_AREA_FLAG
, ELIG_PTIP_PRTE_FLAG ELIG_PTIP_PRTE_FLAG
, ELIG_NO_OTHR_CVG_FLAG ELIG_NO_OTHR_CVG_FLAG
, ELIG_ENRLD_PL_FLAG ELIG_ENRLD_PL_FLAG
, ELIG_ENRLD_OIPL_FLAG ELIG_ENRLD_OIPL_FLAG
, ELIG_ENRLD_PGM_FLAG ELIG_ENRLD_PGM_FLAG
, ELIG_DPNT_CVRD_PL_FLAG ELIG_DPNT_CVRD_PL_FLAG
, ELIG_LVG_RSN_FLAG ELIG_LVG_RSN_FLAG
, ELIG_OPTD_MDCR_FLAG ELIG_OPTD_MDCR_FLAG
, ELIG_TBCO_USE_FLAG ELIG_TBCO_USE_FLAG
, ELP_ATTRIBUTE_CATEGORY ELP_ATTRIBUTE_CATEGORY
, ELP_ATTRIBUTE1 ELP_ATTRIBUTE1
, ELP_ATTRIBUTE2 ELP_ATTRIBUTE2
, ELP_ATTRIBUTE3 ELP_ATTRIBUTE3
, ELP_ATTRIBUTE4 ELP_ATTRIBUTE4
, ELP_ATTRIBUTE5 ELP_ATTRIBUTE5
, ELP_ATTRIBUTE6 ELP_ATTRIBUTE6
, ELP_ATTRIBUTE7 ELP_ATTRIBUTE7
, ELP_ATTRIBUTE8 ELP_ATTRIBUTE8
, ELP_ATTRIBUTE9 ELP_ATTRIBUTE9
, ELP_ATTRIBUTE10 ELP_ATTRIBUTE10
, ELP_ATTRIBUTE11 ELP_ATTRIBUTE11
, ELP_ATTRIBUTE12 ELP_ATTRIBUTE12
, ELP_ATTRIBUTE13 ELP_ATTRIBUTE13
, ELP_ATTRIBUTE14 ELP_ATTRIBUTE14
, ELP_ATTRIBUTE15 ELP_ATTRIBUTE15
, ELP_ATTRIBUTE16 ELP_ATTRIBUTE16
, ELP_ATTRIBUTE17 ELP_ATTRIBUTE17
, ELP_ATTRIBUTE18 ELP_ATTRIBUTE18
, ELP_ATTRIBUTE19 ELP_ATTRIBUTE19
, ELP_ATTRIBUTE20 ELP_ATTRIBUTE20
, ELP_ATTRIBUTE21 ELP_ATTRIBUTE21
, ELP_ATTRIBUTE22 ELP_ATTRIBUTE22
, ELP_ATTRIBUTE23 ELP_ATTRIBUTE23
, ELP_ATTRIBUTE24 ELP_ATTRIBUTE24
, ELP_ATTRIBUTE25 ELP_ATTRIBUTE25
, ELP_ATTRIBUTE26 ELP_ATTRIBUTE26
, ELP_ATTRIBUTE27 ELP_ATTRIBUTE27
, ELP_ATTRIBUTE28 ELP_ATTRIBUTE28
, ELP_ATTRIBUTE29 ELP_ATTRIBUTE29
, ELP_ATTRIBUTE30 ELP_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
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, DESCRIPTION DESCRIPTION
, ASG_TYP_CD ASG_TYP_CD
, ASMT_TO_USE_CD ASMT_TO_USE_CD
, ELIG_DPNT_OTHR_PTIP_FLAG ELIG_DPNT_OTHR_PTIP_FLAG
, ELIG_GNDR_FLAG ELIG_GNDR_FLAG
, ELIG_DSBLTY_CTG_FLAG ELIG_DSBLTY_CTG_FLAG
, ELIG_DSBLTY_DGR_FLAG ELIG_DSBLTY_DGR_FLAG
, ELIG_DSBLTY_RSN_FLAG ELIG_DSBLTY_RSN_FLAG
, ELIG_MRTL_STS_FLAG ELIG_MRTL_STS_FLAG
, ELIG_PRBTN_PERD_FLAG ELIG_PRBTN_PERD_FLAG
, ELIG_SP_CLNG_PRG_PT_FLAG ELIG_SP_CLNG_PRG_PT_FLAG
, ELIG_SUPPL_ROLE_FLAG ELIG_SUPPL_ROLE_FLAG
, ELIG_QUAL_TITL_FLAG ELIG_QUAL_TITL_FLAG
, ELIG_PSTN_FLAG ELIG_PSTN_FLAG
, BNFT_CAGR_PRTN_CD BNFT_CAGR_PRTN_CD
, ELIG_DSBLD_FLAG ELIG_DSBLD_FLAG
, ELIG_TTL_CVG_VOL_FLAG ELIG_TTL_CVG_VOL_FLAG
, ELIG_TTL_PRTT_FLAG ELIG_TTL_PRTT_FLAG
, ELIG_COMPTNCY_FLAG ELIG_COMPTNCY_FLAG
, ELIG_HLTH_CVG_FLAG ELIG_HLTH_CVG_FLAG
, ELIG_ANTHR_PL_FLAG ELIG_ANTHR_PL_FLAG
, ELIG_PERF_RTNG_FLAG ELIG_PERF_RTNG_FLAG
, ELIG_QUA_IN_GR_FLAG ELIG_QUA_IN_GR_FLAG
, ELIG_CRIT_VALUES_FLAG ELIG_CRIT_VALUES_FLAG
FROM "BEN"."BEN_ELIGY_PRFL_F"