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_BENFTS_GRP_RT_F#

Source

View Text - Preformatted


select BENFTS_GRP_RT_ID BENFTS_GRP_RT_ID, EFFECTIVE_START_DATE EFFECTIVE_START_DATE, EFFECTIVE_END_DATE EFFECTIVE_END_DATE, BUSINESS_GROUP_ID BUSINESS_GROUP_ID, BENFTS_GRP_ID BENFTS_GRP_ID, EXCLD_FLAG EXCLD_FLAG, VRBL_RT_PRFL_ID VRBL_RT_PRFL_ID, BRG_ATTRIBUTE_CATEGORY BRG_ATTRIBUTE_CATEGORY, BRG_ATTRIBUTE1 BRG_ATTRIBUTE1, BRG_ATTRIBUTE2 BRG_ATTRIBUTE2, BRG_ATTRIBUTE3 BRG_ATTRIBUTE3, BRG_ATTRIBUTE4 BRG_ATTRIBUTE4, BRG_ATTRIBUTE5 BRG_ATTRIBUTE5, BRG_ATTRIBUTE6 BRG_ATTRIBUTE6, BRG_ATTRIBUTE7 BRG_ATTRIBUTE7, BRG_ATTRIBUTE8 BRG_ATTRIBUTE8, BRG_ATTRIBUTE9 BRG_ATTRIBUTE9, BRG_ATTRIBUTE10 BRG_ATTRIBUTE10, BRG_ATTRIBUTE11 BRG_ATTRIBUTE11, BRG_ATTRIBUTE12 BRG_ATTRIBUTE12, BRG_ATTRIBUTE13 BRG_ATTRIBUTE13, BRG_ATTRIBUTE14 BRG_ATTRIBUTE14, BRG_ATTRIBUTE15 BRG_ATTRIBUTE15, BRG_ATTRIBUTE16 BRG_ATTRIBUTE16, BRG_ATTRIBUTE17 BRG_ATTRIBUTE17, BRG_ATTRIBUTE18 BRG_ATTRIBUTE18, BRG_ATTRIBUTE19 BRG_ATTRIBUTE19, BRG_ATTRIBUTE20 BRG_ATTRIBUTE20, BRG_ATTRIBUTE21 BRG_ATTRIBUTE21, BRG_ATTRIBUTE22 BRG_ATTRIBUTE22, BRG_ATTRIBUTE23 BRG_ATTRIBUTE23, BRG_ATTRIBUTE24 BRG_ATTRIBUTE24, BRG_ATTRIBUTE25 BRG_ATTRIBUTE25, BRG_ATTRIBUTE26 BRG_ATTRIBUTE26, BRG_ATTRIBUTE27 BRG_ATTRIBUTE27, BRG_ATTRIBUTE28 BRG_ATTRIBUTE28, BRG_ATTRIBUTE29 BRG_ATTRIBUTE29, BRG_ATTRIBUTE30 BRG_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_BENFTS_GRP_RT_F"

View Text - HTML Formatted

SELECT BENFTS_GRP_RT_ID BENFTS_GRP_RT_ID
, EFFECTIVE_START_DATE EFFECTIVE_START_DATE
, EFFECTIVE_END_DATE EFFECTIVE_END_DATE
, BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, BENFTS_GRP_ID BENFTS_GRP_ID
, EXCLD_FLAG EXCLD_FLAG
, VRBL_RT_PRFL_ID VRBL_RT_PRFL_ID
, BRG_ATTRIBUTE_CATEGORY BRG_ATTRIBUTE_CATEGORY
, BRG_ATTRIBUTE1 BRG_ATTRIBUTE1
, BRG_ATTRIBUTE2 BRG_ATTRIBUTE2
, BRG_ATTRIBUTE3 BRG_ATTRIBUTE3
, BRG_ATTRIBUTE4 BRG_ATTRIBUTE4
, BRG_ATTRIBUTE5 BRG_ATTRIBUTE5
, BRG_ATTRIBUTE6 BRG_ATTRIBUTE6
, BRG_ATTRIBUTE7 BRG_ATTRIBUTE7
, BRG_ATTRIBUTE8 BRG_ATTRIBUTE8
, BRG_ATTRIBUTE9 BRG_ATTRIBUTE9
, BRG_ATTRIBUTE10 BRG_ATTRIBUTE10
, BRG_ATTRIBUTE11 BRG_ATTRIBUTE11
, BRG_ATTRIBUTE12 BRG_ATTRIBUTE12
, BRG_ATTRIBUTE13 BRG_ATTRIBUTE13
, BRG_ATTRIBUTE14 BRG_ATTRIBUTE14
, BRG_ATTRIBUTE15 BRG_ATTRIBUTE15
, BRG_ATTRIBUTE16 BRG_ATTRIBUTE16
, BRG_ATTRIBUTE17 BRG_ATTRIBUTE17
, BRG_ATTRIBUTE18 BRG_ATTRIBUTE18
, BRG_ATTRIBUTE19 BRG_ATTRIBUTE19
, BRG_ATTRIBUTE20 BRG_ATTRIBUTE20
, BRG_ATTRIBUTE21 BRG_ATTRIBUTE21
, BRG_ATTRIBUTE22 BRG_ATTRIBUTE22
, BRG_ATTRIBUTE23 BRG_ATTRIBUTE23
, BRG_ATTRIBUTE24 BRG_ATTRIBUTE24
, BRG_ATTRIBUTE25 BRG_ATTRIBUTE25
, BRG_ATTRIBUTE26 BRG_ATTRIBUTE26
, BRG_ATTRIBUTE27 BRG_ATTRIBUTE27
, BRG_ATTRIBUTE28 BRG_ATTRIBUTE28
, BRG_ATTRIBUTE29 BRG_ATTRIBUTE29
, BRG_ATTRIBUTE30 BRG_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_BENFTS_GRP_RT_F"