eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

VIEW: BEN.BEN_BNFT_VRBL_RT_RL_F#

Source

View Text - Preformatted


select BNFT_VRBL_RT_RL_ID BNFT_VRBL_RT_RL_ID, EFFECTIVE_START_DATE EFFECTIVE_START_DATE, EFFECTIVE_END_DATE EFFECTIVE_END_DATE, BUSINESS_GROUP_ID BUSINESS_GROUP_ID, CVG_AMT_CALC_MTHD_ID CVG_AMT_CALC_MTHD_ID, FORMULA_ID FORMULA_ID, BRR_ATTRIBUTE_CATEGORY BRR_ATTRIBUTE_CATEGORY, BRR_ATTRIBUTE1 BRR_ATTRIBUTE1, BRR_ATTRIBUTE2 BRR_ATTRIBUTE2, BRR_ATTRIBUTE3 BRR_ATTRIBUTE3, BRR_ATTRIBUTE4 BRR_ATTRIBUTE4, BRR_ATTRIBUTE5 BRR_ATTRIBUTE5, BRR_ATTRIBUTE6 BRR_ATTRIBUTE6, BRR_ATTRIBUTE7 BRR_ATTRIBUTE7, BRR_ATTRIBUTE8 BRR_ATTRIBUTE8, BRR_ATTRIBUTE9 BRR_ATTRIBUTE9, BRR_ATTRIBUTE10 BRR_ATTRIBUTE10, BRR_ATTRIBUTE11 BRR_ATTRIBUTE11, BRR_ATTRIBUTE12 BRR_ATTRIBUTE12, BRR_ATTRIBUTE13 BRR_ATTRIBUTE13, BRR_ATTRIBUTE14 BRR_ATTRIBUTE14, BRR_ATTRIBUTE15 BRR_ATTRIBUTE15, BRR_ATTRIBUTE16 BRR_ATTRIBUTE16, BRR_ATTRIBUTE17 BRR_ATTRIBUTE17, BRR_ATTRIBUTE18 BRR_ATTRIBUTE18, BRR_ATTRIBUTE19 BRR_ATTRIBUTE19, BRR_ATTRIBUTE20 BRR_ATTRIBUTE20, BRR_ATTRIBUTE21 BRR_ATTRIBUTE21, BRR_ATTRIBUTE22 BRR_ATTRIBUTE22, BRR_ATTRIBUTE23 BRR_ATTRIBUTE23, BRR_ATTRIBUTE24 BRR_ATTRIBUTE24, BRR_ATTRIBUTE25 BRR_ATTRIBUTE25, BRR_ATTRIBUTE26 BRR_ATTRIBUTE26, BRR_ATTRIBUTE27 BRR_ATTRIBUTE27, BRR_ATTRIBUTE28 BRR_ATTRIBUTE28, BRR_ATTRIBUTE29 BRR_ATTRIBUTE29, BRR_ATTRIBUTE30 BRR_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_TO_APLY_NUM ORDR_TO_APLY_NUM from "BEN"."BEN_BNFT_VRBL_RT_RL_F"

View Text - HTML Formatted

SELECT BNFT_VRBL_RT_RL_ID BNFT_VRBL_RT_RL_ID
, EFFECTIVE_START_DATE EFFECTIVE_START_DATE
, EFFECTIVE_END_DATE EFFECTIVE_END_DATE
, BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, CVG_AMT_CALC_MTHD_ID CVG_AMT_CALC_MTHD_ID
, FORMULA_ID FORMULA_ID
, BRR_ATTRIBUTE_CATEGORY BRR_ATTRIBUTE_CATEGORY
, BRR_ATTRIBUTE1 BRR_ATTRIBUTE1
, BRR_ATTRIBUTE2 BRR_ATTRIBUTE2
, BRR_ATTRIBUTE3 BRR_ATTRIBUTE3
, BRR_ATTRIBUTE4 BRR_ATTRIBUTE4
, BRR_ATTRIBUTE5 BRR_ATTRIBUTE5
, BRR_ATTRIBUTE6 BRR_ATTRIBUTE6
, BRR_ATTRIBUTE7 BRR_ATTRIBUTE7
, BRR_ATTRIBUTE8 BRR_ATTRIBUTE8
, BRR_ATTRIBUTE9 BRR_ATTRIBUTE9
, BRR_ATTRIBUTE10 BRR_ATTRIBUTE10
, BRR_ATTRIBUTE11 BRR_ATTRIBUTE11
, BRR_ATTRIBUTE12 BRR_ATTRIBUTE12
, BRR_ATTRIBUTE13 BRR_ATTRIBUTE13
, BRR_ATTRIBUTE14 BRR_ATTRIBUTE14
, BRR_ATTRIBUTE15 BRR_ATTRIBUTE15
, BRR_ATTRIBUTE16 BRR_ATTRIBUTE16
, BRR_ATTRIBUTE17 BRR_ATTRIBUTE17
, BRR_ATTRIBUTE18 BRR_ATTRIBUTE18
, BRR_ATTRIBUTE19 BRR_ATTRIBUTE19
, BRR_ATTRIBUTE20 BRR_ATTRIBUTE20
, BRR_ATTRIBUTE21 BRR_ATTRIBUTE21
, BRR_ATTRIBUTE22 BRR_ATTRIBUTE22
, BRR_ATTRIBUTE23 BRR_ATTRIBUTE23
, BRR_ATTRIBUTE24 BRR_ATTRIBUTE24
, BRR_ATTRIBUTE25 BRR_ATTRIBUTE25
, BRR_ATTRIBUTE26 BRR_ATTRIBUTE26
, BRR_ATTRIBUTE27 BRR_ATTRIBUTE27
, BRR_ATTRIBUTE28 BRR_ATTRIBUTE28
, BRR_ATTRIBUTE29 BRR_ATTRIBUTE29
, BRR_ATTRIBUTE30 BRR_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_TO_APLY_NUM ORDR_TO_APLY_NUM
FROM "BEN"."BEN_BNFT_VRBL_RT_RL_F"