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

Source

View Text - Preformatted


select ELIG_PER_TYP_PRTE_ID ELIG_PER_TYP_PRTE_ID, EFFECTIVE_START_DATE EFFECTIVE_START_DATE, EFFECTIVE_END_DATE EFFECTIVE_END_DATE, BUSINESS_GROUP_ID BUSINESS_GROUP_ID, EXCLD_FLAG EXCLD_FLAG, ELIGY_PRFL_ID ELIGY_PRFL_ID, EPT_ATTRIBUTE_CATEGORY EPT_ATTRIBUTE_CATEGORY, EPT_ATTRIBUTE1 EPT_ATTRIBUTE1, EPT_ATTRIBUTE2 EPT_ATTRIBUTE2, EPT_ATTRIBUTE3 EPT_ATTRIBUTE3, EPT_ATTRIBUTE4 EPT_ATTRIBUTE4, EPT_ATTRIBUTE5 EPT_ATTRIBUTE5, EPT_ATTRIBUTE6 EPT_ATTRIBUTE6, EPT_ATTRIBUTE7 EPT_ATTRIBUTE7, EPT_ATTRIBUTE8 EPT_ATTRIBUTE8, EPT_ATTRIBUTE9 EPT_ATTRIBUTE9, EPT_ATTRIBUTE10 EPT_ATTRIBUTE10, EPT_ATTRIBUTE11 EPT_ATTRIBUTE11, EPT_ATTRIBUTE12 EPT_ATTRIBUTE12, EPT_ATTRIBUTE13 EPT_ATTRIBUTE13, EPT_ATTRIBUTE14 EPT_ATTRIBUTE14, EPT_ATTRIBUTE15 EPT_ATTRIBUTE15, EPT_ATTRIBUTE16 EPT_ATTRIBUTE16, EPT_ATTRIBUTE17 EPT_ATTRIBUTE17, EPT_ATTRIBUTE18 EPT_ATTRIBUTE18, EPT_ATTRIBUTE19 EPT_ATTRIBUTE19, EPT_ATTRIBUTE20 EPT_ATTRIBUTE20, EPT_ATTRIBUTE21 EPT_ATTRIBUTE21, EPT_ATTRIBUTE22 EPT_ATTRIBUTE22, EPT_ATTRIBUTE23 EPT_ATTRIBUTE23, EPT_ATTRIBUTE24 EPT_ATTRIBUTE24, EPT_ATTRIBUTE25 EPT_ATTRIBUTE25, EPT_ATTRIBUTE26 EPT_ATTRIBUTE26, EPT_ATTRIBUTE27 EPT_ATTRIBUTE27, EPT_ATTRIBUTE28 EPT_ATTRIBUTE28, EPT_ATTRIBUTE29 EPT_ATTRIBUTE29, EPT_ATTRIBUTE30 EPT_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, PER_TYP_CD PER_TYP_CD, ORDR_NUM ORDR_NUM, PERSON_TYPE_ID PERSON_TYPE_ID, CRITERIA_SCORE CRITERIA_SCORE, CRITERIA_WEIGHT CRITERIA_WEIGHT from "BEN"."BEN_ELIG_PER_TYP_PRTE_F"

View Text - HTML Formatted

SELECT ELIG_PER_TYP_PRTE_ID ELIG_PER_TYP_PRTE_ID
, EFFECTIVE_START_DATE EFFECTIVE_START_DATE
, EFFECTIVE_END_DATE EFFECTIVE_END_DATE
, BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, EXCLD_FLAG EXCLD_FLAG
, ELIGY_PRFL_ID ELIGY_PRFL_ID
, EPT_ATTRIBUTE_CATEGORY EPT_ATTRIBUTE_CATEGORY
, EPT_ATTRIBUTE1 EPT_ATTRIBUTE1
, EPT_ATTRIBUTE2 EPT_ATTRIBUTE2
, EPT_ATTRIBUTE3 EPT_ATTRIBUTE3
, EPT_ATTRIBUTE4 EPT_ATTRIBUTE4
, EPT_ATTRIBUTE5 EPT_ATTRIBUTE5
, EPT_ATTRIBUTE6 EPT_ATTRIBUTE6
, EPT_ATTRIBUTE7 EPT_ATTRIBUTE7
, EPT_ATTRIBUTE8 EPT_ATTRIBUTE8
, EPT_ATTRIBUTE9 EPT_ATTRIBUTE9
, EPT_ATTRIBUTE10 EPT_ATTRIBUTE10
, EPT_ATTRIBUTE11 EPT_ATTRIBUTE11
, EPT_ATTRIBUTE12 EPT_ATTRIBUTE12
, EPT_ATTRIBUTE13 EPT_ATTRIBUTE13
, EPT_ATTRIBUTE14 EPT_ATTRIBUTE14
, EPT_ATTRIBUTE15 EPT_ATTRIBUTE15
, EPT_ATTRIBUTE16 EPT_ATTRIBUTE16
, EPT_ATTRIBUTE17 EPT_ATTRIBUTE17
, EPT_ATTRIBUTE18 EPT_ATTRIBUTE18
, EPT_ATTRIBUTE19 EPT_ATTRIBUTE19
, EPT_ATTRIBUTE20 EPT_ATTRIBUTE20
, EPT_ATTRIBUTE21 EPT_ATTRIBUTE21
, EPT_ATTRIBUTE22 EPT_ATTRIBUTE22
, EPT_ATTRIBUTE23 EPT_ATTRIBUTE23
, EPT_ATTRIBUTE24 EPT_ATTRIBUTE24
, EPT_ATTRIBUTE25 EPT_ATTRIBUTE25
, EPT_ATTRIBUTE26 EPT_ATTRIBUTE26
, EPT_ATTRIBUTE27 EPT_ATTRIBUTE27
, EPT_ATTRIBUTE28 EPT_ATTRIBUTE28
, EPT_ATTRIBUTE29 EPT_ATTRIBUTE29
, EPT_ATTRIBUTE30 EPT_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
, PER_TYP_CD PER_TYP_CD
, ORDR_NUM ORDR_NUM
, PERSON_TYPE_ID PERSON_TYPE_ID
, CRITERIA_SCORE CRITERIA_SCORE
, CRITERIA_WEIGHT CRITERIA_WEIGHT
FROM "BEN"."BEN_ELIG_PER_TYP_PRTE_F"