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.

VIEW: BEN.BEN_BNFT_VRBL_RT_F#

Source

View Text - Preformatted


select BNFT_VRBL_RT_ID BNFT_VRBL_RT_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, VRBL_RT_PRFL_ID VRBL_RT_PRFL_ID, BVR_ATTRIBUTE_CATEGORY BVR_ATTRIBUTE_CATEGORY, BVR_ATTRIBUTE1 BVR_ATTRIBUTE1, BVR_ATTRIBUTE2 BVR_ATTRIBUTE2, BVR_ATTRIBUTE3 BVR_ATTRIBUTE3, BVR_ATTRIBUTE4 BVR_ATTRIBUTE4, BVR_ATTRIBUTE5 BVR_ATTRIBUTE5, BVR_ATTRIBUTE6 BVR_ATTRIBUTE6, BVR_ATTRIBUTE7 BVR_ATTRIBUTE7, BVR_ATTRIBUTE8 BVR_ATTRIBUTE8, BVR_ATTRIBUTE9 BVR_ATTRIBUTE9, BVR_ATTRIBUTE10 BVR_ATTRIBUTE10, BVR_ATTRIBUTE11 BVR_ATTRIBUTE11, BVR_ATTRIBUTE12 BVR_ATTRIBUTE12, BVR_ATTRIBUTE13 BVR_ATTRIBUTE13, BVR_ATTRIBUTE14 BVR_ATTRIBUTE14, BVR_ATTRIBUTE15 BVR_ATTRIBUTE15, BVR_ATTRIBUTE16 BVR_ATTRIBUTE16, BVR_ATTRIBUTE17 BVR_ATTRIBUTE17, BVR_ATTRIBUTE18 BVR_ATTRIBUTE18, BVR_ATTRIBUTE19 BVR_ATTRIBUTE19, BVR_ATTRIBUTE20 BVR_ATTRIBUTE20, BVR_ATTRIBUTE21 BVR_ATTRIBUTE21, BVR_ATTRIBUTE22 BVR_ATTRIBUTE22, BVR_ATTRIBUTE23 BVR_ATTRIBUTE23, BVR_ATTRIBUTE24 BVR_ATTRIBUTE24, BVR_ATTRIBUTE25 BVR_ATTRIBUTE25, BVR_ATTRIBUTE26 BVR_ATTRIBUTE26, BVR_ATTRIBUTE27 BVR_ATTRIBUTE27, BVR_ATTRIBUTE28 BVR_ATTRIBUTE28, BVR_ATTRIBUTE29 BVR_ATTRIBUTE29, BVR_ATTRIBUTE30 BVR_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 from "BEN"."BEN_BNFT_VRBL_RT_F"

View Text - HTML Formatted

SELECT BNFT_VRBL_RT_ID BNFT_VRBL_RT_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
, VRBL_RT_PRFL_ID VRBL_RT_PRFL_ID
, BVR_ATTRIBUTE_CATEGORY BVR_ATTRIBUTE_CATEGORY
, BVR_ATTRIBUTE1 BVR_ATTRIBUTE1
, BVR_ATTRIBUTE2 BVR_ATTRIBUTE2
, BVR_ATTRIBUTE3 BVR_ATTRIBUTE3
, BVR_ATTRIBUTE4 BVR_ATTRIBUTE4
, BVR_ATTRIBUTE5 BVR_ATTRIBUTE5
, BVR_ATTRIBUTE6 BVR_ATTRIBUTE6
, BVR_ATTRIBUTE7 BVR_ATTRIBUTE7
, BVR_ATTRIBUTE8 BVR_ATTRIBUTE8
, BVR_ATTRIBUTE9 BVR_ATTRIBUTE9
, BVR_ATTRIBUTE10 BVR_ATTRIBUTE10
, BVR_ATTRIBUTE11 BVR_ATTRIBUTE11
, BVR_ATTRIBUTE12 BVR_ATTRIBUTE12
, BVR_ATTRIBUTE13 BVR_ATTRIBUTE13
, BVR_ATTRIBUTE14 BVR_ATTRIBUTE14
, BVR_ATTRIBUTE15 BVR_ATTRIBUTE15
, BVR_ATTRIBUTE16 BVR_ATTRIBUTE16
, BVR_ATTRIBUTE17 BVR_ATTRIBUTE17
, BVR_ATTRIBUTE18 BVR_ATTRIBUTE18
, BVR_ATTRIBUTE19 BVR_ATTRIBUTE19
, BVR_ATTRIBUTE20 BVR_ATTRIBUTE20
, BVR_ATTRIBUTE21 BVR_ATTRIBUTE21
, BVR_ATTRIBUTE22 BVR_ATTRIBUTE22
, BVR_ATTRIBUTE23 BVR_ATTRIBUTE23
, BVR_ATTRIBUTE24 BVR_ATTRIBUTE24
, BVR_ATTRIBUTE25 BVR_ATTRIBUTE25
, BVR_ATTRIBUTE26 BVR_ATTRIBUTE26
, BVR_ATTRIBUTE27 BVR_ATTRIBUTE27
, BVR_ATTRIBUTE28 BVR_ATTRIBUTE28
, BVR_ATTRIBUTE29 BVR_ATTRIBUTE29
, BVR_ATTRIBUTE30 BVR_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
FROM "BEN"."BEN_BNFT_VRBL_RT_F"