VIEW: BEN.BEN_LEE_RSN_F#

Source

View Text - Preformatted

select LEE_RSN_ID LEE_RSN_ID, EFFECTIVE_START_DATE EFFECTIVE_START_DATE, EFFECTIVE_END_DATE EFFECTIVE_END_DATE, BUSINESS_GROUP_ID BUSINESS_GROUP_ID, CLS_ENRT_DT_TO_USE_CD CLS_ENRT_DT_TO_USE_CD, DYS_AFTR_END_TO_DFLT_NUM DYS_AFTR_END_TO_DFLT_NUM, ENRT_CVG_END_DT_CD ENRT_CVG_END_DT_CD, POPL_ENRT_TYP_CYCL_ID POPL_ENRT_TYP_CYCL_ID, ENRT_CVG_STRT_DT_CD ENRT_CVG_STRT_DT_CD, ENRT_PERD_STRT_DT_CD ENRT_PERD_STRT_DT_CD, ENRT_PERD_STRT_DT_RL ENRT_PERD_STRT_DT_RL, ENRT_PERD_END_DT_CD ENRT_PERD_END_DT_CD, LER_ID LER_ID, ADDL_PROCG_DYS_NUM ADDL_PROCG_DYS_NUM, DYS_NO_ENRL_NOT_ELIG_NUM DYS_NO_ENRL_NOT_ELIG_NUM, DYS_NO_ENRL_CANT_ENRL_NUM DYS_NO_ENRL_CANT_ENRL_NUM, RT_END_DT_CD RT_END_DT_CD, RT_END_DT_RL RT_END_DT_RL, RT_STRT_DT_CD RT_STRT_DT_CD, RT_STRT_DT_RL RT_STRT_DT_RL, ENRT_CVG_END_DT_RL ENRT_CVG_END_DT_RL, LEN_ATTRIBUTE_CATEGORY LEN_ATTRIBUTE_CATEGORY, ENRT_CVG_STRT_DT_RL ENRT_CVG_STRT_DT_RL, ENRT_PERD_END_DT_RL ENRT_PERD_END_DT_RL, LEN_ATTRIBUTE1 LEN_ATTRIBUTE1, LEN_ATTRIBUTE2 LEN_ATTRIBUTE2, LEN_ATTRIBUTE3 LEN_ATTRIBUTE3, LEN_ATTRIBUTE4 LEN_ATTRIBUTE4, LEN_ATTRIBUTE5 LEN_ATTRIBUTE5, LEN_ATTRIBUTE6 LEN_ATTRIBUTE6, LEN_ATTRIBUTE7 LEN_ATTRIBUTE7, LEN_ATTRIBUTE8 LEN_ATTRIBUTE8, LEN_ATTRIBUTE9 LEN_ATTRIBUTE9, LEN_ATTRIBUTE10 LEN_ATTRIBUTE10, LEN_ATTRIBUTE11 LEN_ATTRIBUTE11, LEN_ATTRIBUTE12 LEN_ATTRIBUTE12, LEN_ATTRIBUTE13 LEN_ATTRIBUTE13, LEN_ATTRIBUTE14 LEN_ATTRIBUTE14, LEN_ATTRIBUTE15 LEN_ATTRIBUTE15, LEN_ATTRIBUTE16 LEN_ATTRIBUTE16, LEN_ATTRIBUTE17 LEN_ATTRIBUTE17, LEN_ATTRIBUTE18 LEN_ATTRIBUTE18, LEN_ATTRIBUTE19 LEN_ATTRIBUTE19, LEN_ATTRIBUTE20 LEN_ATTRIBUTE20, LEN_ATTRIBUTE21 LEN_ATTRIBUTE21, LEN_ATTRIBUTE22 LEN_ATTRIBUTE22, LEN_ATTRIBUTE23 LEN_ATTRIBUTE23, LEN_ATTRIBUTE24 LEN_ATTRIBUTE24, LEN_ATTRIBUTE25 LEN_ATTRIBUTE25, LEN_ATTRIBUTE26 LEN_ATTRIBUTE26, LEN_ATTRIBUTE27 LEN_ATTRIBUTE27, LEN_ATTRIBUTE28 LEN_ATTRIBUTE28, LEN_ATTRIBUTE29 LEN_ATTRIBUTE29, LEN_ATTRIBUTE30 LEN_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, ENRT_PERD_DET_OVRLP_BCKDT_CD ENRT_PERD_DET_OVRLP_BCKDT_CD, REINSTATE_CD REINSTATE_CD, REINSTATE_OVRDN_CD REINSTATE_OVRDN_CD, ENRT_PERD_STRT_DAYS ENRT_PERD_STRT_DAYS, ENRT_PERD_END_DAYS ENRT_PERD_END_DAYS, DEFER_DEENROL_FLAG DEFER_DEENROL_FLAG, REOPEN_LE_ON_REPROCESS REOPEN_LE_ON_REPROCESS from "BEN"."BEN_LEE_RSN_F"

View Text - HTML Formatted

SELECT LEE_RSN_ID LEE_RSN_ID
, EFFECTIVE_START_DATE EFFECTIVE_START_DATE
, EFFECTIVE_END_DATE EFFECTIVE_END_DATE
, BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, CLS_ENRT_DT_TO_USE_CD CLS_ENRT_DT_TO_USE_CD
, DYS_AFTR_END_TO_DFLT_NUM DYS_AFTR_END_TO_DFLT_NUM
, ENRT_CVG_END_DT_CD ENRT_CVG_END_DT_CD
, POPL_ENRT_TYP_CYCL_ID POPL_ENRT_TYP_CYCL_ID
, ENRT_CVG_STRT_DT_CD ENRT_CVG_STRT_DT_CD
, ENRT_PERD_STRT_DT_CD ENRT_PERD_STRT_DT_CD
, ENRT_PERD_STRT_DT_RL ENRT_PERD_STRT_DT_RL
, ENRT_PERD_END_DT_CD ENRT_PERD_END_DT_CD
, LER_ID LER_ID
, ADDL_PROCG_DYS_NUM ADDL_PROCG_DYS_NUM
, DYS_NO_ENRL_NOT_ELIG_NUM DYS_NO_ENRL_NOT_ELIG_NUM
, DYS_NO_ENRL_CANT_ENRL_NUM DYS_NO_ENRL_CANT_ENRL_NUM
, RT_END_DT_CD RT_END_DT_CD
, RT_END_DT_RL RT_END_DT_RL
, RT_STRT_DT_CD RT_STRT_DT_CD
, RT_STRT_DT_RL RT_STRT_DT_RL
, ENRT_CVG_END_DT_RL ENRT_CVG_END_DT_RL
, LEN_ATTRIBUTE_CATEGORY LEN_ATTRIBUTE_CATEGORY
, ENRT_CVG_STRT_DT_RL ENRT_CVG_STRT_DT_RL
, ENRT_PERD_END_DT_RL ENRT_PERD_END_DT_RL
, LEN_ATTRIBUTE1 LEN_ATTRIBUTE1
, LEN_ATTRIBUTE2 LEN_ATTRIBUTE2
, LEN_ATTRIBUTE3 LEN_ATTRIBUTE3
, LEN_ATTRIBUTE4 LEN_ATTRIBUTE4
, LEN_ATTRIBUTE5 LEN_ATTRIBUTE5
, LEN_ATTRIBUTE6 LEN_ATTRIBUTE6
, LEN_ATTRIBUTE7 LEN_ATTRIBUTE7
, LEN_ATTRIBUTE8 LEN_ATTRIBUTE8
, LEN_ATTRIBUTE9 LEN_ATTRIBUTE9
, LEN_ATTRIBUTE10 LEN_ATTRIBUTE10
, LEN_ATTRIBUTE11 LEN_ATTRIBUTE11
, LEN_ATTRIBUTE12 LEN_ATTRIBUTE12
, LEN_ATTRIBUTE13 LEN_ATTRIBUTE13
, LEN_ATTRIBUTE14 LEN_ATTRIBUTE14
, LEN_ATTRIBUTE15 LEN_ATTRIBUTE15
, LEN_ATTRIBUTE16 LEN_ATTRIBUTE16
, LEN_ATTRIBUTE17 LEN_ATTRIBUTE17
, LEN_ATTRIBUTE18 LEN_ATTRIBUTE18
, LEN_ATTRIBUTE19 LEN_ATTRIBUTE19
, LEN_ATTRIBUTE20 LEN_ATTRIBUTE20
, LEN_ATTRIBUTE21 LEN_ATTRIBUTE21
, LEN_ATTRIBUTE22 LEN_ATTRIBUTE22
, LEN_ATTRIBUTE23 LEN_ATTRIBUTE23
, LEN_ATTRIBUTE24 LEN_ATTRIBUTE24
, LEN_ATTRIBUTE25 LEN_ATTRIBUTE25
, LEN_ATTRIBUTE26 LEN_ATTRIBUTE26
, LEN_ATTRIBUTE27 LEN_ATTRIBUTE27
, LEN_ATTRIBUTE28 LEN_ATTRIBUTE28
, LEN_ATTRIBUTE29 LEN_ATTRIBUTE29
, LEN_ATTRIBUTE30 LEN_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
, ENRT_PERD_DET_OVRLP_BCKDT_CD ENRT_PERD_DET_OVRLP_BCKDT_CD
, REINSTATE_CD REINSTATE_CD
, REINSTATE_OVRDN_CD REINSTATE_OVRDN_CD
, ENRT_PERD_STRT_DAYS ENRT_PERD_STRT_DAYS
, ENRT_PERD_END_DAYS ENRT_PERD_END_DAYS
, DEFER_DEENROL_FLAG DEFER_DEENROL_FLAG
, REOPEN_LE_ON_REPROCESS REOPEN_LE_ON_REPROCESS
FROM "BEN"."BEN_LEE_RSN_F"