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

Source

View Text - Preformatted


select ELIG_PPL_GRP_PRTE_ID ELIG_PPL_GRP_PRTE_ID, EFFECTIVE_START_DATE EFFECTIVE_START_DATE, EFFECTIVE_END_DATE EFFECTIVE_END_DATE, EXCLD_FLAG EXCLD_FLAG, ORDR_NUM ORDR_NUM, ELIGY_PRFL_ID ELIGY_PRFL_ID, EPG_ATTRIBUTE_CATEGORY EPG_ATTRIBUTE_CATEGORY, EPG_ATTRIBUTE1 EPG_ATTRIBUTE1, EPG_ATTRIBUTE2 EPG_ATTRIBUTE2, EPG_ATTRIBUTE3 EPG_ATTRIBUTE3, EPG_ATTRIBUTE4 EPG_ATTRIBUTE4, EPG_ATTRIBUTE5 EPG_ATTRIBUTE5, EPG_ATTRIBUTE6 EPG_ATTRIBUTE6, EPG_ATTRIBUTE7 EPG_ATTRIBUTE7, EPG_ATTRIBUTE8 EPG_ATTRIBUTE8, EPG_ATTRIBUTE9 EPG_ATTRIBUTE9, EPG_ATTRIBUTE10 EPG_ATTRIBUTE10, EPG_ATTRIBUTE11 EPG_ATTRIBUTE11, EPG_ATTRIBUTE12 EPG_ATTRIBUTE12, EPG_ATTRIBUTE13 EPG_ATTRIBUTE13, EPG_ATTRIBUTE14 EPG_ATTRIBUTE14, EPG_ATTRIBUTE15 EPG_ATTRIBUTE15, EPG_ATTRIBUTE16 EPG_ATTRIBUTE16, EPG_ATTRIBUTE17 EPG_ATTRIBUTE17, EPG_ATTRIBUTE18 EPG_ATTRIBUTE18, EPG_ATTRIBUTE19 EPG_ATTRIBUTE19, EPG_ATTRIBUTE20 EPG_ATTRIBUTE20, EPG_ATTRIBUTE21 EPG_ATTRIBUTE21, EPG_ATTRIBUTE22 EPG_ATTRIBUTE22, EPG_ATTRIBUTE23 EPG_ATTRIBUTE23, EPG_ATTRIBUTE24 EPG_ATTRIBUTE24, EPG_ATTRIBUTE25 EPG_ATTRIBUTE25, EPG_ATTRIBUTE26 EPG_ATTRIBUTE26, EPG_ATTRIBUTE27 EPG_ATTRIBUTE27, EPG_ATTRIBUTE28 EPG_ATTRIBUTE28, EPG_ATTRIBUTE29 EPG_ATTRIBUTE29, EPG_ATTRIBUTE30 EPG_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, PEOPLE_GROUP_ID PEOPLE_GROUP_ID, BUSINESS_GROUP_ID BUSINESS_GROUP_ID, CRITERIA_SCORE CRITERIA_SCORE, CRITERIA_WEIGHT CRITERIA_WEIGHT from "BEN"."BEN_ELIG_PPL_GRP_PRTE_F"

View Text - HTML Formatted

SELECT ELIG_PPL_GRP_PRTE_ID ELIG_PPL_GRP_PRTE_ID
, EFFECTIVE_START_DATE EFFECTIVE_START_DATE
, EFFECTIVE_END_DATE EFFECTIVE_END_DATE
, EXCLD_FLAG EXCLD_FLAG
, ORDR_NUM ORDR_NUM
, ELIGY_PRFL_ID ELIGY_PRFL_ID
, EPG_ATTRIBUTE_CATEGORY EPG_ATTRIBUTE_CATEGORY
, EPG_ATTRIBUTE1 EPG_ATTRIBUTE1
, EPG_ATTRIBUTE2 EPG_ATTRIBUTE2
, EPG_ATTRIBUTE3 EPG_ATTRIBUTE3
, EPG_ATTRIBUTE4 EPG_ATTRIBUTE4
, EPG_ATTRIBUTE5 EPG_ATTRIBUTE5
, EPG_ATTRIBUTE6 EPG_ATTRIBUTE6
, EPG_ATTRIBUTE7 EPG_ATTRIBUTE7
, EPG_ATTRIBUTE8 EPG_ATTRIBUTE8
, EPG_ATTRIBUTE9 EPG_ATTRIBUTE9
, EPG_ATTRIBUTE10 EPG_ATTRIBUTE10
, EPG_ATTRIBUTE11 EPG_ATTRIBUTE11
, EPG_ATTRIBUTE12 EPG_ATTRIBUTE12
, EPG_ATTRIBUTE13 EPG_ATTRIBUTE13
, EPG_ATTRIBUTE14 EPG_ATTRIBUTE14
, EPG_ATTRIBUTE15 EPG_ATTRIBUTE15
, EPG_ATTRIBUTE16 EPG_ATTRIBUTE16
, EPG_ATTRIBUTE17 EPG_ATTRIBUTE17
, EPG_ATTRIBUTE18 EPG_ATTRIBUTE18
, EPG_ATTRIBUTE19 EPG_ATTRIBUTE19
, EPG_ATTRIBUTE20 EPG_ATTRIBUTE20
, EPG_ATTRIBUTE21 EPG_ATTRIBUTE21
, EPG_ATTRIBUTE22 EPG_ATTRIBUTE22
, EPG_ATTRIBUTE23 EPG_ATTRIBUTE23
, EPG_ATTRIBUTE24 EPG_ATTRIBUTE24
, EPG_ATTRIBUTE25 EPG_ATTRIBUTE25
, EPG_ATTRIBUTE26 EPG_ATTRIBUTE26
, EPG_ATTRIBUTE27 EPG_ATTRIBUTE27
, EPG_ATTRIBUTE28 EPG_ATTRIBUTE28
, EPG_ATTRIBUTE29 EPG_ATTRIBUTE29
, EPG_ATTRIBUTE30 EPG_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
, PEOPLE_GROUP_ID PEOPLE_GROUP_ID
, BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, CRITERIA_SCORE CRITERIA_SCORE
, CRITERIA_WEIGHT CRITERIA_WEIGHT
FROM "BEN"."BEN_ELIG_PPL_GRP_PRTE_F"