VIEW: BEN.BEN_ELIG_TTL_CVG_VOL_PRTE_F#

Source

View Text - Preformatted

select ELIG_TTL_CVG_VOL_PRTE_ID ELIG_TTL_CVG_VOL_PRTE_ID, EFFECTIVE_START_DATE EFFECTIVE_START_DATE, EFFECTIVE_END_DATE EFFECTIVE_END_DATE, BUSINESS_GROUP_ID BUSINESS_GROUP_ID, EXCLD_FLAG EXCLD_FLAG, NO_MN_CVG_VOL_AMT_APLS_FLAG NO_MN_CVG_VOL_AMT_APLS_FLAG, NO_MX_CVG_VOL_AMT_APLS_FLAG NO_MX_CVG_VOL_AMT_APLS_FLAG, ELIGY_PRFL_ID ELIGY_PRFL_ID, ETC_ATTRIBUTE_CATEGORY ETC_ATTRIBUTE_CATEGORY, ETC_ATTRIBUTE1 ETC_ATTRIBUTE1, ETC_ATTRIBUTE2 ETC_ATTRIBUTE2, ETC_ATTRIBUTE3 ETC_ATTRIBUTE3, ETC_ATTRIBUTE4 ETC_ATTRIBUTE4, ETC_ATTRIBUTE5 ETC_ATTRIBUTE5, ETC_ATTRIBUTE6 ETC_ATTRIBUTE6, ETC_ATTRIBUTE7 ETC_ATTRIBUTE7, ETC_ATTRIBUTE8 ETC_ATTRIBUTE8, ETC_ATTRIBUTE9 ETC_ATTRIBUTE9, ETC_ATTRIBUTE10 ETC_ATTRIBUTE10, ETC_ATTRIBUTE11 ETC_ATTRIBUTE11, ETC_ATTRIBUTE12 ETC_ATTRIBUTE12, ETC_ATTRIBUTE13 ETC_ATTRIBUTE13, ETC_ATTRIBUTE14 ETC_ATTRIBUTE14, ETC_ATTRIBUTE15 ETC_ATTRIBUTE15, ETC_ATTRIBUTE16 ETC_ATTRIBUTE16, ETC_ATTRIBUTE17 ETC_ATTRIBUTE17, ETC_ATTRIBUTE18 ETC_ATTRIBUTE18, ETC_ATTRIBUTE19 ETC_ATTRIBUTE19, ETC_ATTRIBUTE20 ETC_ATTRIBUTE20, ETC_ATTRIBUTE21 ETC_ATTRIBUTE21, ETC_ATTRIBUTE22 ETC_ATTRIBUTE22, ETC_ATTRIBUTE23 ETC_ATTRIBUTE23, ETC_ATTRIBUTE24 ETC_ATTRIBUTE24, ETC_ATTRIBUTE25 ETC_ATTRIBUTE25, ETC_ATTRIBUTE26 ETC_ATTRIBUTE26, ETC_ATTRIBUTE27 ETC_ATTRIBUTE27, ETC_ATTRIBUTE28 ETC_ATTRIBUTE28, ETC_ATTRIBUTE29 ETC_ATTRIBUTE29, ETC_ATTRIBUTE30 ETC_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, ORDR_NUM ORDR_NUM, MN_CVG_VOL_AMT MN_CVG_VOL_AMT, MX_CVG_VOL_AMT MX_CVG_VOL_AMT, CVG_VOL_DET_CD CVG_VOL_DET_CD, CVG_VOL_DET_RL CVG_VOL_DET_RL from "BEN"."BEN_ELIG_TTL_CVG_VOL_PRTE_F"

View Text - HTML Formatted

SELECT ELIG_TTL_CVG_VOL_PRTE_ID ELIG_TTL_CVG_VOL_PRTE_ID
, EFFECTIVE_START_DATE EFFECTIVE_START_DATE
, EFFECTIVE_END_DATE EFFECTIVE_END_DATE
, BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, EXCLD_FLAG EXCLD_FLAG
, NO_MN_CVG_VOL_AMT_APLS_FLAG NO_MN_CVG_VOL_AMT_APLS_FLAG
, NO_MX_CVG_VOL_AMT_APLS_FLAG NO_MX_CVG_VOL_AMT_APLS_FLAG
, ELIGY_PRFL_ID ELIGY_PRFL_ID
, ETC_ATTRIBUTE_CATEGORY ETC_ATTRIBUTE_CATEGORY
, ETC_ATTRIBUTE1 ETC_ATTRIBUTE1
, ETC_ATTRIBUTE2 ETC_ATTRIBUTE2
, ETC_ATTRIBUTE3 ETC_ATTRIBUTE3
, ETC_ATTRIBUTE4 ETC_ATTRIBUTE4
, ETC_ATTRIBUTE5 ETC_ATTRIBUTE5
, ETC_ATTRIBUTE6 ETC_ATTRIBUTE6
, ETC_ATTRIBUTE7 ETC_ATTRIBUTE7
, ETC_ATTRIBUTE8 ETC_ATTRIBUTE8
, ETC_ATTRIBUTE9 ETC_ATTRIBUTE9
, ETC_ATTRIBUTE10 ETC_ATTRIBUTE10
, ETC_ATTRIBUTE11 ETC_ATTRIBUTE11
, ETC_ATTRIBUTE12 ETC_ATTRIBUTE12
, ETC_ATTRIBUTE13 ETC_ATTRIBUTE13
, ETC_ATTRIBUTE14 ETC_ATTRIBUTE14
, ETC_ATTRIBUTE15 ETC_ATTRIBUTE15
, ETC_ATTRIBUTE16 ETC_ATTRIBUTE16
, ETC_ATTRIBUTE17 ETC_ATTRIBUTE17
, ETC_ATTRIBUTE18 ETC_ATTRIBUTE18
, ETC_ATTRIBUTE19 ETC_ATTRIBUTE19
, ETC_ATTRIBUTE20 ETC_ATTRIBUTE20
, ETC_ATTRIBUTE21 ETC_ATTRIBUTE21
, ETC_ATTRIBUTE22 ETC_ATTRIBUTE22
, ETC_ATTRIBUTE23 ETC_ATTRIBUTE23
, ETC_ATTRIBUTE24 ETC_ATTRIBUTE24
, ETC_ATTRIBUTE25 ETC_ATTRIBUTE25
, ETC_ATTRIBUTE26 ETC_ATTRIBUTE26
, ETC_ATTRIBUTE27 ETC_ATTRIBUTE27
, ETC_ATTRIBUTE28 ETC_ATTRIBUTE28
, ETC_ATTRIBUTE29 ETC_ATTRIBUTE29
, ETC_ATTRIBUTE30 ETC_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
, ORDR_NUM ORDR_NUM
, MN_CVG_VOL_AMT MN_CVG_VOL_AMT
, MX_CVG_VOL_AMT MX_CVG_VOL_AMT
, CVG_VOL_DET_CD CVG_VOL_DET_CD
, CVG_VOL_DET_RL CVG_VOL_DET_RL
FROM "BEN"."BEN_ELIG_TTL_CVG_VOL_PRTE_F"