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

Source

View Text - Preformatted


select ELIG_LOS_PRTE_ID ELIG_LOS_PRTE_ID, EFFECTIVE_START_DATE EFFECTIVE_START_DATE, EFFECTIVE_END_DATE EFFECTIVE_END_DATE, BUSINESS_GROUP_ID BUSINESS_GROUP_ID, LOS_FCTR_ID LOS_FCTR_ID, ELIGY_PRFL_ID ELIGY_PRFL_ID, EXCLD_FLAG EXCLD_FLAG, ELS_ATTRIBUTE_CATEGORY ELS_ATTRIBUTE_CATEGORY, ELS_ATTRIBUTE1 ELS_ATTRIBUTE1, ELS_ATTRIBUTE2 ELS_ATTRIBUTE2, ELS_ATTRIBUTE3 ELS_ATTRIBUTE3, ELS_ATTRIBUTE4 ELS_ATTRIBUTE4, ELS_ATTRIBUTE5 ELS_ATTRIBUTE5, ELS_ATTRIBUTE6 ELS_ATTRIBUTE6, ELS_ATTRIBUTE7 ELS_ATTRIBUTE7, ELS_ATTRIBUTE8 ELS_ATTRIBUTE8, ELS_ATTRIBUTE9 ELS_ATTRIBUTE9, ELS_ATTRIBUTE10 ELS_ATTRIBUTE10, ELS_ATTRIBUTE11 ELS_ATTRIBUTE11, ELS_ATTRIBUTE12 ELS_ATTRIBUTE12, ELS_ATTRIBUTE13 ELS_ATTRIBUTE13, ELS_ATTRIBUTE14 ELS_ATTRIBUTE14, ELS_ATTRIBUTE15 ELS_ATTRIBUTE15, ELS_ATTRIBUTE16 ELS_ATTRIBUTE16, ELS_ATTRIBUTE17 ELS_ATTRIBUTE17, ELS_ATTRIBUTE18 ELS_ATTRIBUTE18, ELS_ATTRIBUTE19 ELS_ATTRIBUTE19, ELS_ATTRIBUTE20 ELS_ATTRIBUTE20, ELS_ATTRIBUTE21 ELS_ATTRIBUTE21, ELS_ATTRIBUTE22 ELS_ATTRIBUTE22, ELS_ATTRIBUTE23 ELS_ATTRIBUTE23, ELS_ATTRIBUTE24 ELS_ATTRIBUTE24, ELS_ATTRIBUTE25 ELS_ATTRIBUTE25, ELS_ATTRIBUTE26 ELS_ATTRIBUTE26, ELS_ATTRIBUTE27 ELS_ATTRIBUTE27, ELS_ATTRIBUTE28 ELS_ATTRIBUTE28, ELS_ATTRIBUTE29 ELS_ATTRIBUTE29, ELS_ATTRIBUTE30 ELS_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, CRITERIA_SCORE CRITERIA_SCORE, CRITERIA_WEIGHT CRITERIA_WEIGHT from "BEN"."BEN_ELIG_LOS_PRTE_F"

View Text - HTML Formatted

SELECT ELIG_LOS_PRTE_ID ELIG_LOS_PRTE_ID
, EFFECTIVE_START_DATE EFFECTIVE_START_DATE
, EFFECTIVE_END_DATE EFFECTIVE_END_DATE
, BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, LOS_FCTR_ID LOS_FCTR_ID
, ELIGY_PRFL_ID ELIGY_PRFL_ID
, EXCLD_FLAG EXCLD_FLAG
, ELS_ATTRIBUTE_CATEGORY ELS_ATTRIBUTE_CATEGORY
, ELS_ATTRIBUTE1 ELS_ATTRIBUTE1
, ELS_ATTRIBUTE2 ELS_ATTRIBUTE2
, ELS_ATTRIBUTE3 ELS_ATTRIBUTE3
, ELS_ATTRIBUTE4 ELS_ATTRIBUTE4
, ELS_ATTRIBUTE5 ELS_ATTRIBUTE5
, ELS_ATTRIBUTE6 ELS_ATTRIBUTE6
, ELS_ATTRIBUTE7 ELS_ATTRIBUTE7
, ELS_ATTRIBUTE8 ELS_ATTRIBUTE8
, ELS_ATTRIBUTE9 ELS_ATTRIBUTE9
, ELS_ATTRIBUTE10 ELS_ATTRIBUTE10
, ELS_ATTRIBUTE11 ELS_ATTRIBUTE11
, ELS_ATTRIBUTE12 ELS_ATTRIBUTE12
, ELS_ATTRIBUTE13 ELS_ATTRIBUTE13
, ELS_ATTRIBUTE14 ELS_ATTRIBUTE14
, ELS_ATTRIBUTE15 ELS_ATTRIBUTE15
, ELS_ATTRIBUTE16 ELS_ATTRIBUTE16
, ELS_ATTRIBUTE17 ELS_ATTRIBUTE17
, ELS_ATTRIBUTE18 ELS_ATTRIBUTE18
, ELS_ATTRIBUTE19 ELS_ATTRIBUTE19
, ELS_ATTRIBUTE20 ELS_ATTRIBUTE20
, ELS_ATTRIBUTE21 ELS_ATTRIBUTE21
, ELS_ATTRIBUTE22 ELS_ATTRIBUTE22
, ELS_ATTRIBUTE23 ELS_ATTRIBUTE23
, ELS_ATTRIBUTE24 ELS_ATTRIBUTE24
, ELS_ATTRIBUTE25 ELS_ATTRIBUTE25
, ELS_ATTRIBUTE26 ELS_ATTRIBUTE26
, ELS_ATTRIBUTE27 ELS_ATTRIBUTE27
, ELS_ATTRIBUTE28 ELS_ATTRIBUTE28
, ELS_ATTRIBUTE29 ELS_ATTRIBUTE29
, ELS_ATTRIBUTE30 ELS_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
, CRITERIA_SCORE CRITERIA_SCORE
, CRITERIA_WEIGHT CRITERIA_WEIGHT
FROM "BEN"."BEN_ELIG_LOS_PRTE_F"