VIEW: BEN.BEN_LER_CHG_PGM_ENRT_F#

Source

View Text - Preformatted

select LER_CHG_PGM_ENRT_ID LER_CHG_PGM_ENRT_ID, EFFECTIVE_START_DATE EFFECTIVE_START_DATE, EFFECTIVE_END_DATE EFFECTIVE_END_DATE, CRNT_ENRT_PRCLDS_CHG_FLAG CRNT_ENRT_PRCLDS_CHG_FLAG, BUSINESS_GROUP_ID BUSINESS_GROUP_ID, PGM_ID PGM_ID, LER_ID LER_ID, STL_ELIG_CANT_CHG_FLAG STL_ELIG_CANT_CHG_FLAG, LGE_ATTRIBUTE_CATEGORY LGE_ATTRIBUTE_CATEGORY, LGE_ATTRIBUTE1 LGE_ATTRIBUTE1, LGE_ATTRIBUTE2 LGE_ATTRIBUTE2, LGE_ATTRIBUTE3 LGE_ATTRIBUTE3, LGE_ATTRIBUTE4 LGE_ATTRIBUTE4, LGE_ATTRIBUTE5 LGE_ATTRIBUTE5, LGE_ATTRIBUTE6 LGE_ATTRIBUTE6, LGE_ATTRIBUTE7 LGE_ATTRIBUTE7, LGE_ATTRIBUTE8 LGE_ATTRIBUTE8, LGE_ATTRIBUTE9 LGE_ATTRIBUTE9, LGE_ATTRIBUTE10 LGE_ATTRIBUTE10, LGE_ATTRIBUTE11 LGE_ATTRIBUTE11, LGE_ATTRIBUTE12 LGE_ATTRIBUTE12, LGE_ATTRIBUTE13 LGE_ATTRIBUTE13, LGE_ATTRIBUTE14 LGE_ATTRIBUTE14, LGE_ATTRIBUTE15 LGE_ATTRIBUTE15, LGE_ATTRIBUTE16 LGE_ATTRIBUTE16, LGE_ATTRIBUTE17 LGE_ATTRIBUTE17, LGE_ATTRIBUTE18 LGE_ATTRIBUTE18, LGE_ATTRIBUTE19 LGE_ATTRIBUTE19, LGE_ATTRIBUTE20 LGE_ATTRIBUTE20, LGE_ATTRIBUTE21 LGE_ATTRIBUTE21, LGE_ATTRIBUTE22 LGE_ATTRIBUTE22, LGE_ATTRIBUTE23 LGE_ATTRIBUTE23, LGE_ATTRIBUTE24 LGE_ATTRIBUTE24, LGE_ATTRIBUTE25 LGE_ATTRIBUTE25, LGE_ATTRIBUTE26 LGE_ATTRIBUTE26, LGE_ATTRIBUTE27 LGE_ATTRIBUTE27, LGE_ATTRIBUTE28 LGE_ATTRIBUTE28, LGE_ATTRIBUTE29 LGE_ATTRIBUTE29, LGE_ATTRIBUTE30 LGE_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, AUTO_ENRT_MTHD_RL AUTO_ENRT_MTHD_RL, DFLT_ENRT_CD DFLT_ENRT_CD, DFLT_ENRT_RL DFLT_ENRT_RL, ENRT_CD ENRT_CD, ENRT_MTHD_CD ENRT_MTHD_CD, ENRT_RL ENRT_RL from "BEN"."BEN_LER_CHG_PGM_ENRT_F"

View Text - HTML Formatted

SELECT LER_CHG_PGM_ENRT_ID LER_CHG_PGM_ENRT_ID
, EFFECTIVE_START_DATE EFFECTIVE_START_DATE
, EFFECTIVE_END_DATE EFFECTIVE_END_DATE
, CRNT_ENRT_PRCLDS_CHG_FLAG CRNT_ENRT_PRCLDS_CHG_FLAG
, BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, PGM_ID PGM_ID
, LER_ID LER_ID
, STL_ELIG_CANT_CHG_FLAG STL_ELIG_CANT_CHG_FLAG
, LGE_ATTRIBUTE_CATEGORY LGE_ATTRIBUTE_CATEGORY
, LGE_ATTRIBUTE1 LGE_ATTRIBUTE1
, LGE_ATTRIBUTE2 LGE_ATTRIBUTE2
, LGE_ATTRIBUTE3 LGE_ATTRIBUTE3
, LGE_ATTRIBUTE4 LGE_ATTRIBUTE4
, LGE_ATTRIBUTE5 LGE_ATTRIBUTE5
, LGE_ATTRIBUTE6 LGE_ATTRIBUTE6
, LGE_ATTRIBUTE7 LGE_ATTRIBUTE7
, LGE_ATTRIBUTE8 LGE_ATTRIBUTE8
, LGE_ATTRIBUTE9 LGE_ATTRIBUTE9
, LGE_ATTRIBUTE10 LGE_ATTRIBUTE10
, LGE_ATTRIBUTE11 LGE_ATTRIBUTE11
, LGE_ATTRIBUTE12 LGE_ATTRIBUTE12
, LGE_ATTRIBUTE13 LGE_ATTRIBUTE13
, LGE_ATTRIBUTE14 LGE_ATTRIBUTE14
, LGE_ATTRIBUTE15 LGE_ATTRIBUTE15
, LGE_ATTRIBUTE16 LGE_ATTRIBUTE16
, LGE_ATTRIBUTE17 LGE_ATTRIBUTE17
, LGE_ATTRIBUTE18 LGE_ATTRIBUTE18
, LGE_ATTRIBUTE19 LGE_ATTRIBUTE19
, LGE_ATTRIBUTE20 LGE_ATTRIBUTE20
, LGE_ATTRIBUTE21 LGE_ATTRIBUTE21
, LGE_ATTRIBUTE22 LGE_ATTRIBUTE22
, LGE_ATTRIBUTE23 LGE_ATTRIBUTE23
, LGE_ATTRIBUTE24 LGE_ATTRIBUTE24
, LGE_ATTRIBUTE25 LGE_ATTRIBUTE25
, LGE_ATTRIBUTE26 LGE_ATTRIBUTE26
, LGE_ATTRIBUTE27 LGE_ATTRIBUTE27
, LGE_ATTRIBUTE28 LGE_ATTRIBUTE28
, LGE_ATTRIBUTE29 LGE_ATTRIBUTE29
, LGE_ATTRIBUTE30 LGE_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
, AUTO_ENRT_MTHD_RL AUTO_ENRT_MTHD_RL
, DFLT_ENRT_CD DFLT_ENRT_CD
, DFLT_ENRT_RL DFLT_ENRT_RL
, ENRT_CD ENRT_CD
, ENRT_MTHD_CD ENRT_MTHD_CD
, ENRT_RL ENRT_RL
FROM "BEN"."BEN_LER_CHG_PGM_ENRT_F"