VIEW: BEN.BEN_CLPSE_LF_EVT_F#

Source

View Text - Preformatted

select CLPSE_LF_EVT_ID CLPSE_LF_EVT_ID, EFFECTIVE_START_DATE EFFECTIVE_START_DATE, EFFECTIVE_END_DATE EFFECTIVE_END_DATE, BUSINESS_GROUP_ID BUSINESS_GROUP_ID, SEQ SEQ, EVAL_LER_ID EVAL_LER_ID, LER1_ID LER1_ID, EVAL_CD EVAL_CD, EVAL_LER_DET_CD EVAL_LER_DET_CD, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, LER9_ID LER9_ID, LER10_ID LER10_ID, BOOL1_CD BOOL1_CD, BOOL2_CD BOOL2_CD, LER2_ID LER2_ID, BOOL3_CD BOOL3_CD, LER3_ID LER3_ID, BOOL4_CD BOOL4_CD, LER4_ID LER4_ID, BOOL5_CD BOOL5_CD, LER5_ID LER5_ID, BOOL6_CD BOOL6_CD, LER6_ID LER6_ID, BOOL7_CD BOOL7_CD, LER7_ID LER7_ID, BOOL8_CD BOOL8_CD, LER8_ID LER8_ID, BOOL9_CD BOOL9_CD, EVAL_RL EVAL_RL, TLRNC_DYS_NUM TLRNC_DYS_NUM, EVAL_LER_DET_RL EVAL_LER_DET_RL, CLP_ATTRIBUTE_CATEGORY CLP_ATTRIBUTE_CATEGORY, CLP_ATTRIBUTE1 CLP_ATTRIBUTE1, CLP_ATTRIBUTE2 CLP_ATTRIBUTE2, CLP_ATTRIBUTE3 CLP_ATTRIBUTE3, CLP_ATTRIBUTE4 CLP_ATTRIBUTE4, CLP_ATTRIBUTE5 CLP_ATTRIBUTE5, CLP_ATTRIBUTE6 CLP_ATTRIBUTE6, CLP_ATTRIBUTE7 CLP_ATTRIBUTE7, CLP_ATTRIBUTE8 CLP_ATTRIBUTE8, CLP_ATTRIBUTE9 CLP_ATTRIBUTE9, CLP_ATTRIBUTE10 CLP_ATTRIBUTE10, CLP_ATTRIBUTE11 CLP_ATTRIBUTE11, CLP_ATTRIBUTE12 CLP_ATTRIBUTE12, CLP_ATTRIBUTE13 CLP_ATTRIBUTE13, CLP_ATTRIBUTE14 CLP_ATTRIBUTE14, CLP_ATTRIBUTE15 CLP_ATTRIBUTE15, CLP_ATTRIBUTE16 CLP_ATTRIBUTE16, CLP_ATTRIBUTE17 CLP_ATTRIBUTE17, CLP_ATTRIBUTE18 CLP_ATTRIBUTE18, CLP_ATTRIBUTE19 CLP_ATTRIBUTE19, CLP_ATTRIBUTE20 CLP_ATTRIBUTE20, CLP_ATTRIBUTE21 CLP_ATTRIBUTE21, CLP_ATTRIBUTE22 CLP_ATTRIBUTE22, CLP_ATTRIBUTE23 CLP_ATTRIBUTE23, CLP_ATTRIBUTE24 CLP_ATTRIBUTE24, CLP_ATTRIBUTE25 CLP_ATTRIBUTE25, CLP_ATTRIBUTE26 CLP_ATTRIBUTE26, CLP_ATTRIBUTE27 CLP_ATTRIBUTE27, CLP_ATTRIBUTE28 CLP_ATTRIBUTE28, CLP_ATTRIBUTE29 CLP_ATTRIBUTE29, CLP_ATTRIBUTE30 CLP_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 from "BEN"."BEN_CLPSE_LF_EVT_F"

View Text - HTML Formatted

SELECT CLPSE_LF_EVT_ID CLPSE_LF_EVT_ID
, EFFECTIVE_START_DATE EFFECTIVE_START_DATE
, EFFECTIVE_END_DATE EFFECTIVE_END_DATE
, BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, SEQ SEQ
, EVAL_LER_ID EVAL_LER_ID
, LER1_ID LER1_ID
, EVAL_CD EVAL_CD
, EVAL_LER_DET_CD EVAL_LER_DET_CD
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, LER9_ID LER9_ID
, LER10_ID LER10_ID
, BOOL1_CD BOOL1_CD
, BOOL2_CD BOOL2_CD
, LER2_ID LER2_ID
, BOOL3_CD BOOL3_CD
, LER3_ID LER3_ID
, BOOL4_CD BOOL4_CD
, LER4_ID LER4_ID
, BOOL5_CD BOOL5_CD
, LER5_ID LER5_ID
, BOOL6_CD BOOL6_CD
, LER6_ID LER6_ID
, BOOL7_CD BOOL7_CD
, LER7_ID LER7_ID
, BOOL8_CD BOOL8_CD
, LER8_ID LER8_ID
, BOOL9_CD BOOL9_CD
, EVAL_RL EVAL_RL
, TLRNC_DYS_NUM TLRNC_DYS_NUM
, EVAL_LER_DET_RL EVAL_LER_DET_RL
, CLP_ATTRIBUTE_CATEGORY CLP_ATTRIBUTE_CATEGORY
, CLP_ATTRIBUTE1 CLP_ATTRIBUTE1
, CLP_ATTRIBUTE2 CLP_ATTRIBUTE2
, CLP_ATTRIBUTE3 CLP_ATTRIBUTE3
, CLP_ATTRIBUTE4 CLP_ATTRIBUTE4
, CLP_ATTRIBUTE5 CLP_ATTRIBUTE5
, CLP_ATTRIBUTE6 CLP_ATTRIBUTE6
, CLP_ATTRIBUTE7 CLP_ATTRIBUTE7
, CLP_ATTRIBUTE8 CLP_ATTRIBUTE8
, CLP_ATTRIBUTE9 CLP_ATTRIBUTE9
, CLP_ATTRIBUTE10 CLP_ATTRIBUTE10
, CLP_ATTRIBUTE11 CLP_ATTRIBUTE11
, CLP_ATTRIBUTE12 CLP_ATTRIBUTE12
, CLP_ATTRIBUTE13 CLP_ATTRIBUTE13
, CLP_ATTRIBUTE14 CLP_ATTRIBUTE14
, CLP_ATTRIBUTE15 CLP_ATTRIBUTE15
, CLP_ATTRIBUTE16 CLP_ATTRIBUTE16
, CLP_ATTRIBUTE17 CLP_ATTRIBUTE17
, CLP_ATTRIBUTE18 CLP_ATTRIBUTE18
, CLP_ATTRIBUTE19 CLP_ATTRIBUTE19
, CLP_ATTRIBUTE20 CLP_ATTRIBUTE20
, CLP_ATTRIBUTE21 CLP_ATTRIBUTE21
, CLP_ATTRIBUTE22 CLP_ATTRIBUTE22
, CLP_ATTRIBUTE23 CLP_ATTRIBUTE23
, CLP_ATTRIBUTE24 CLP_ATTRIBUTE24
, CLP_ATTRIBUTE25 CLP_ATTRIBUTE25
, CLP_ATTRIBUTE26 CLP_ATTRIBUTE26
, CLP_ATTRIBUTE27 CLP_ATTRIBUTE27
, CLP_ATTRIBUTE28 CLP_ATTRIBUTE28
, CLP_ATTRIBUTE29 CLP_ATTRIBUTE29
, CLP_ATTRIBUTE30 CLP_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
FROM "BEN"."BEN_CLPSE_LF_EVT_F"