VIEW: BEN.BEN_ELIG_TO_PRTE_RSN_F#

Source

View Text - Preformatted

select ELIG_TO_PRTE_RSN_ID ELIG_TO_PRTE_RSN_ID, EFFECTIVE_START_DATE EFFECTIVE_START_DATE, EFFECTIVE_END_DATE EFFECTIVE_END_DATE, BUSINESS_GROUP_ID BUSINESS_GROUP_ID, PRTN_OVRIDBL_FLAG PRTN_OVRIDBL_FLAG, IGNR_PRTN_OVRID_FLAG IGNR_PRTN_OVRID_FLAG, ELIG_INELIG_CD ELIG_INELIG_CD, LER_ID LER_ID, PEO_ATTRIBUTE3 PEO_ATTRIBUTE3, PEO_ATTRIBUTE4 PEO_ATTRIBUTE4, PTIP_ID PTIP_ID, PEO_ATTRIBUTE5 PEO_ATTRIBUTE5, PEO_ATTRIBUTE6 PEO_ATTRIBUTE6, PLIP_ID PLIP_ID, PEO_ATTRIBUTE7 PEO_ATTRIBUTE7, PEO_ATTRIBUTE8 PEO_ATTRIBUTE8, PEO_ATTRIBUTE9 PEO_ATTRIBUTE9, PEO_ATTRIBUTE10 PEO_ATTRIBUTE10, PEO_ATTRIBUTE11 PEO_ATTRIBUTE11, PEO_ATTRIBUTE12 PEO_ATTRIBUTE12, PEO_ATTRIBUTE13 PEO_ATTRIBUTE13, PEO_ATTRIBUTE14 PEO_ATTRIBUTE14, PEO_ATTRIBUTE15 PEO_ATTRIBUTE15, PEO_ATTRIBUTE16 PEO_ATTRIBUTE16, PEO_ATTRIBUTE17 PEO_ATTRIBUTE17, PEO_ATTRIBUTE18 PEO_ATTRIBUTE18, PEO_ATTRIBUTE19 PEO_ATTRIBUTE19, PEO_ATTRIBUTE20 PEO_ATTRIBUTE20, PEO_ATTRIBUTE21 PEO_ATTRIBUTE21, PEO_ATTRIBUTE22 PEO_ATTRIBUTE22, PEO_ATTRIBUTE23 PEO_ATTRIBUTE23, PEO_ATTRIBUTE24 PEO_ATTRIBUTE24, PEO_ATTRIBUTE25 PEO_ATTRIBUTE25, PEO_ATTRIBUTE26 PEO_ATTRIBUTE26, PEO_ATTRIBUTE27 PEO_ATTRIBUTE27, PEO_ATTRIBUTE28 PEO_ATTRIBUTE28, PEO_ATTRIBUTE29 PEO_ATTRIBUTE29, PEO_ATTRIBUTE30 PEO_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, PRTN_EFF_STRT_DT_CD PRTN_EFF_STRT_DT_CD, PRTN_EFF_STRT_DT_RL PRTN_EFF_STRT_DT_RL, PRTN_EFF_END_DT_CD PRTN_EFF_END_DT_CD, PRTN_EFF_END_DT_RL PRTN_EFF_END_DT_RL, WAIT_PERD_UOM WAIT_PERD_UOM, WAIT_PERD_VAL WAIT_PERD_VAL, WAIT_PERD_DT_TO_USE_CD WAIT_PERD_DT_TO_USE_CD, WAIT_PERD_DT_TO_USE_RL WAIT_PERD_DT_TO_USE_RL, MX_POE_UOM MX_POE_UOM, MX_POE_VAL MX_POE_VAL, MX_POE_RL MX_POE_RL, WAIT_PERD_RL WAIT_PERD_RL, MX_POE_DET_DT_CD MX_POE_DET_DT_CD, MX_POE_DET_DT_RL MX_POE_DET_DT_RL, OIPL_ID OIPL_ID, PL_ID PL_ID, PGM_ID PGM_ID, PEO_ATTRIBUTE_CATEGORY PEO_ATTRIBUTE_CATEGORY, PEO_ATTRIBUTE1 PEO_ATTRIBUTE1, MX_POE_APLS_CD MX_POE_APLS_CD, PEO_ATTRIBUTE2 PEO_ATTRIBUTE2, VRFY_FMLY_MMBR_CD VRFY_FMLY_MMBR_CD, VRFY_FMLY_MMBR_RL VRFY_FMLY_MMBR_RL from "BEN"."BEN_ELIG_TO_PRTE_RSN_F"

View Text - HTML Formatted

SELECT ELIG_TO_PRTE_RSN_ID ELIG_TO_PRTE_RSN_ID
, EFFECTIVE_START_DATE EFFECTIVE_START_DATE
, EFFECTIVE_END_DATE EFFECTIVE_END_DATE
, BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, PRTN_OVRIDBL_FLAG PRTN_OVRIDBL_FLAG
, IGNR_PRTN_OVRID_FLAG IGNR_PRTN_OVRID_FLAG
, ELIG_INELIG_CD ELIG_INELIG_CD
, LER_ID LER_ID
, PEO_ATTRIBUTE3 PEO_ATTRIBUTE3
, PEO_ATTRIBUTE4 PEO_ATTRIBUTE4
, PTIP_ID PTIP_ID
, PEO_ATTRIBUTE5 PEO_ATTRIBUTE5
, PEO_ATTRIBUTE6 PEO_ATTRIBUTE6
, PLIP_ID PLIP_ID
, PEO_ATTRIBUTE7 PEO_ATTRIBUTE7
, PEO_ATTRIBUTE8 PEO_ATTRIBUTE8
, PEO_ATTRIBUTE9 PEO_ATTRIBUTE9
, PEO_ATTRIBUTE10 PEO_ATTRIBUTE10
, PEO_ATTRIBUTE11 PEO_ATTRIBUTE11
, PEO_ATTRIBUTE12 PEO_ATTRIBUTE12
, PEO_ATTRIBUTE13 PEO_ATTRIBUTE13
, PEO_ATTRIBUTE14 PEO_ATTRIBUTE14
, PEO_ATTRIBUTE15 PEO_ATTRIBUTE15
, PEO_ATTRIBUTE16 PEO_ATTRIBUTE16
, PEO_ATTRIBUTE17 PEO_ATTRIBUTE17
, PEO_ATTRIBUTE18 PEO_ATTRIBUTE18
, PEO_ATTRIBUTE19 PEO_ATTRIBUTE19
, PEO_ATTRIBUTE20 PEO_ATTRIBUTE20
, PEO_ATTRIBUTE21 PEO_ATTRIBUTE21
, PEO_ATTRIBUTE22 PEO_ATTRIBUTE22
, PEO_ATTRIBUTE23 PEO_ATTRIBUTE23
, PEO_ATTRIBUTE24 PEO_ATTRIBUTE24
, PEO_ATTRIBUTE25 PEO_ATTRIBUTE25
, PEO_ATTRIBUTE26 PEO_ATTRIBUTE26
, PEO_ATTRIBUTE27 PEO_ATTRIBUTE27
, PEO_ATTRIBUTE28 PEO_ATTRIBUTE28
, PEO_ATTRIBUTE29 PEO_ATTRIBUTE29
, PEO_ATTRIBUTE30 PEO_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
, PRTN_EFF_STRT_DT_CD PRTN_EFF_STRT_DT_CD
, PRTN_EFF_STRT_DT_RL PRTN_EFF_STRT_DT_RL
, PRTN_EFF_END_DT_CD PRTN_EFF_END_DT_CD
, PRTN_EFF_END_DT_RL PRTN_EFF_END_DT_RL
, WAIT_PERD_UOM WAIT_PERD_UOM
, WAIT_PERD_VAL WAIT_PERD_VAL
, WAIT_PERD_DT_TO_USE_CD WAIT_PERD_DT_TO_USE_CD
, WAIT_PERD_DT_TO_USE_RL WAIT_PERD_DT_TO_USE_RL
, MX_POE_UOM MX_POE_UOM
, MX_POE_VAL MX_POE_VAL
, MX_POE_RL MX_POE_RL
, WAIT_PERD_RL WAIT_PERD_RL
, MX_POE_DET_DT_CD MX_POE_DET_DT_CD
, MX_POE_DET_DT_RL MX_POE_DET_DT_RL
, OIPL_ID OIPL_ID
, PL_ID PL_ID
, PGM_ID PGM_ID
, PEO_ATTRIBUTE_CATEGORY PEO_ATTRIBUTE_CATEGORY
, PEO_ATTRIBUTE1 PEO_ATTRIBUTE1
, MX_POE_APLS_CD MX_POE_APLS_CD
, PEO_ATTRIBUTE2 PEO_ATTRIBUTE2
, VRFY_FMLY_MMBR_CD VRFY_FMLY_MMBR_CD
, VRFY_FMLY_MMBR_RL VRFY_FMLY_MMBR_RL
FROM "BEN"."BEN_ELIG_TO_PRTE_RSN_F"