VIEW: BEN.BEN_LER_CHG_DPNT_CVG_F#

Source

View Text - Preformatted

select LER_CHG_DPNT_CVG_ID LER_CHG_DPNT_CVG_ID, EFFECTIVE_START_DATE EFFECTIVE_START_DATE, EFFECTIVE_END_DATE EFFECTIVE_END_DATE, BUSINESS_GROUP_ID BUSINESS_GROUP_ID, ADD_RMV_CVG_CD ADD_RMV_CVG_CD, CVG_EFF_END_CD CVG_EFF_END_CD, CVG_EFF_STRT_CD CVG_EFF_STRT_CD, PGM_ID PGM_ID, LER_CHG_DPNT_CVG_CD LER_CHG_DPNT_CVG_CD, PL_ID PL_ID, LER_ID LER_ID, LER_CHG_DPNT_CVG_RL LER_CHG_DPNT_CVG_RL, CVG_EFF_STRT_RL CVG_EFF_STRT_RL, CVG_EFF_END_RL CVG_EFF_END_RL, LDC_ATTRIBUTE_CATEGORY LDC_ATTRIBUTE_CATEGORY, LDC_ATTRIBUTE1 LDC_ATTRIBUTE1, LDC_ATTRIBUTE2 LDC_ATTRIBUTE2, LDC_ATTRIBUTE3 LDC_ATTRIBUTE3, LDC_ATTRIBUTE4 LDC_ATTRIBUTE4, LDC_ATTRIBUTE5 LDC_ATTRIBUTE5, LDC_ATTRIBUTE6 LDC_ATTRIBUTE6, LDC_ATTRIBUTE7 LDC_ATTRIBUTE7, LDC_ATTRIBUTE8 LDC_ATTRIBUTE8, LDC_ATTRIBUTE9 LDC_ATTRIBUTE9, LDC_ATTRIBUTE10 LDC_ATTRIBUTE10, LDC_ATTRIBUTE11 LDC_ATTRIBUTE11, LDC_ATTRIBUTE12 LDC_ATTRIBUTE12, LDC_ATTRIBUTE13 LDC_ATTRIBUTE13, LDC_ATTRIBUTE14 LDC_ATTRIBUTE14, LDC_ATTRIBUTE15 LDC_ATTRIBUTE15, LDC_ATTRIBUTE16 LDC_ATTRIBUTE16, LDC_ATTRIBUTE17 LDC_ATTRIBUTE17, LDC_ATTRIBUTE18 LDC_ATTRIBUTE18, LDC_ATTRIBUTE19 LDC_ATTRIBUTE19, LDC_ATTRIBUTE20 LDC_ATTRIBUTE20, LDC_ATTRIBUTE21 LDC_ATTRIBUTE21, LDC_ATTRIBUTE22 LDC_ATTRIBUTE22, LDC_ATTRIBUTE23 LDC_ATTRIBUTE23, LDC_ATTRIBUTE24 LDC_ATTRIBUTE24, LDC_ATTRIBUTE25 LDC_ATTRIBUTE25, LDC_ATTRIBUTE26 LDC_ATTRIBUTE26, LDC_ATTRIBUTE27 LDC_ATTRIBUTE27, LDC_ATTRIBUTE28 LDC_ATTRIBUTE28, LDC_ATTRIBUTE29 LDC_ATTRIBUTE29, LDC_ATTRIBUTE30 LDC_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, PTIP_ID PTIP_ID, SUSP_IF_CTFN_NOT_PRVD_FLAG SUSP_IF_CTFN_NOT_PRVD_FLAG, CTFN_DETERMINE_CD CTFN_DETERMINE_CD from "BEN"."BEN_LER_CHG_DPNT_CVG_F"

View Text - HTML Formatted

SELECT LER_CHG_DPNT_CVG_ID LER_CHG_DPNT_CVG_ID
, EFFECTIVE_START_DATE EFFECTIVE_START_DATE
, EFFECTIVE_END_DATE EFFECTIVE_END_DATE
, BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, ADD_RMV_CVG_CD ADD_RMV_CVG_CD
, CVG_EFF_END_CD CVG_EFF_END_CD
, CVG_EFF_STRT_CD CVG_EFF_STRT_CD
, PGM_ID PGM_ID
, LER_CHG_DPNT_CVG_CD LER_CHG_DPNT_CVG_CD
, PL_ID PL_ID
, LER_ID LER_ID
, LER_CHG_DPNT_CVG_RL LER_CHG_DPNT_CVG_RL
, CVG_EFF_STRT_RL CVG_EFF_STRT_RL
, CVG_EFF_END_RL CVG_EFF_END_RL
, LDC_ATTRIBUTE_CATEGORY LDC_ATTRIBUTE_CATEGORY
, LDC_ATTRIBUTE1 LDC_ATTRIBUTE1
, LDC_ATTRIBUTE2 LDC_ATTRIBUTE2
, LDC_ATTRIBUTE3 LDC_ATTRIBUTE3
, LDC_ATTRIBUTE4 LDC_ATTRIBUTE4
, LDC_ATTRIBUTE5 LDC_ATTRIBUTE5
, LDC_ATTRIBUTE6 LDC_ATTRIBUTE6
, LDC_ATTRIBUTE7 LDC_ATTRIBUTE7
, LDC_ATTRIBUTE8 LDC_ATTRIBUTE8
, LDC_ATTRIBUTE9 LDC_ATTRIBUTE9
, LDC_ATTRIBUTE10 LDC_ATTRIBUTE10
, LDC_ATTRIBUTE11 LDC_ATTRIBUTE11
, LDC_ATTRIBUTE12 LDC_ATTRIBUTE12
, LDC_ATTRIBUTE13 LDC_ATTRIBUTE13
, LDC_ATTRIBUTE14 LDC_ATTRIBUTE14
, LDC_ATTRIBUTE15 LDC_ATTRIBUTE15
, LDC_ATTRIBUTE16 LDC_ATTRIBUTE16
, LDC_ATTRIBUTE17 LDC_ATTRIBUTE17
, LDC_ATTRIBUTE18 LDC_ATTRIBUTE18
, LDC_ATTRIBUTE19 LDC_ATTRIBUTE19
, LDC_ATTRIBUTE20 LDC_ATTRIBUTE20
, LDC_ATTRIBUTE21 LDC_ATTRIBUTE21
, LDC_ATTRIBUTE22 LDC_ATTRIBUTE22
, LDC_ATTRIBUTE23 LDC_ATTRIBUTE23
, LDC_ATTRIBUTE24 LDC_ATTRIBUTE24
, LDC_ATTRIBUTE25 LDC_ATTRIBUTE25
, LDC_ATTRIBUTE26 LDC_ATTRIBUTE26
, LDC_ATTRIBUTE27 LDC_ATTRIBUTE27
, LDC_ATTRIBUTE28 LDC_ATTRIBUTE28
, LDC_ATTRIBUTE29 LDC_ATTRIBUTE29
, LDC_ATTRIBUTE30 LDC_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
, PTIP_ID PTIP_ID
, SUSP_IF_CTFN_NOT_PRVD_FLAG SUSP_IF_CTFN_NOT_PRVD_FLAG
, CTFN_DETERMINE_CD CTFN_DETERMINE_CD
FROM "BEN"."BEN_LER_CHG_DPNT_CVG_F"