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

Source

View Text - Preformatted


select ELIG_LOA_RSN_PRTE_ID ELIG_LOA_RSN_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, ELR_ATTRIBUTE_CATEGORY ELR_ATTRIBUTE_CATEGORY, ELR_ATTRIBUTE1 ELR_ATTRIBUTE1, ELR_ATTRIBUTE2 ELR_ATTRIBUTE2, ELR_ATTRIBUTE3 ELR_ATTRIBUTE3, ELR_ATTRIBUTE4 ELR_ATTRIBUTE4, ELR_ATTRIBUTE5 ELR_ATTRIBUTE5, ELR_ATTRIBUTE6 ELR_ATTRIBUTE6, ELR_ATTRIBUTE7 ELR_ATTRIBUTE7, ELR_ATTRIBUTE8 ELR_ATTRIBUTE8, ELR_ATTRIBUTE9 ELR_ATTRIBUTE9, ELR_ATTRIBUTE10 ELR_ATTRIBUTE10, ELR_ATTRIBUTE11 ELR_ATTRIBUTE11, ELR_ATTRIBUTE12 ELR_ATTRIBUTE12, ELR_ATTRIBUTE13 ELR_ATTRIBUTE13, ELR_ATTRIBUTE14 ELR_ATTRIBUTE14, ELR_ATTRIBUTE15 ELR_ATTRIBUTE15, ELR_ATTRIBUTE16 ELR_ATTRIBUTE16, ELR_ATTRIBUTE17 ELR_ATTRIBUTE17, ELR_ATTRIBUTE18 ELR_ATTRIBUTE18, ELR_ATTRIBUTE19 ELR_ATTRIBUTE19, ELR_ATTRIBUTE20 ELR_ATTRIBUTE20, ELR_ATTRIBUTE21 ELR_ATTRIBUTE21, ELR_ATTRIBUTE22 ELR_ATTRIBUTE22, ELR_ATTRIBUTE23 ELR_ATTRIBUTE23, ELR_ATTRIBUTE24 ELR_ATTRIBUTE24, ELR_ATTRIBUTE25 ELR_ATTRIBUTE25, ELR_ATTRIBUTE26 ELR_ATTRIBUTE26, ELR_ATTRIBUTE27 ELR_ATTRIBUTE27, ELR_ATTRIBUTE28 ELR_ATTRIBUTE28, ELR_ATTRIBUTE29 ELR_ATTRIBUTE29, ELR_ATTRIBUTE30 ELR_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, ABSENCE_ATTENDANCE_TYPE_ID ABSENCE_ATTENDANCE_TYPE_ID, ORDR_NUM ORDR_NUM, ABS_ATTENDANCE_REASON_ID ABS_ATTENDANCE_REASON_ID, CRITERIA_SCORE CRITERIA_SCORE, CRITERIA_WEIGHT CRITERIA_WEIGHT from "BEN"."BEN_ELIG_LOA_RSN_PRTE_F"

View Text - HTML Formatted

SELECT ELIG_LOA_RSN_PRTE_ID ELIG_LOA_RSN_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
, ELR_ATTRIBUTE_CATEGORY ELR_ATTRIBUTE_CATEGORY
, ELR_ATTRIBUTE1 ELR_ATTRIBUTE1
, ELR_ATTRIBUTE2 ELR_ATTRIBUTE2
, ELR_ATTRIBUTE3 ELR_ATTRIBUTE3
, ELR_ATTRIBUTE4 ELR_ATTRIBUTE4
, ELR_ATTRIBUTE5 ELR_ATTRIBUTE5
, ELR_ATTRIBUTE6 ELR_ATTRIBUTE6
, ELR_ATTRIBUTE7 ELR_ATTRIBUTE7
, ELR_ATTRIBUTE8 ELR_ATTRIBUTE8
, ELR_ATTRIBUTE9 ELR_ATTRIBUTE9
, ELR_ATTRIBUTE10 ELR_ATTRIBUTE10
, ELR_ATTRIBUTE11 ELR_ATTRIBUTE11
, ELR_ATTRIBUTE12 ELR_ATTRIBUTE12
, ELR_ATTRIBUTE13 ELR_ATTRIBUTE13
, ELR_ATTRIBUTE14 ELR_ATTRIBUTE14
, ELR_ATTRIBUTE15 ELR_ATTRIBUTE15
, ELR_ATTRIBUTE16 ELR_ATTRIBUTE16
, ELR_ATTRIBUTE17 ELR_ATTRIBUTE17
, ELR_ATTRIBUTE18 ELR_ATTRIBUTE18
, ELR_ATTRIBUTE19 ELR_ATTRIBUTE19
, ELR_ATTRIBUTE20 ELR_ATTRIBUTE20
, ELR_ATTRIBUTE21 ELR_ATTRIBUTE21
, ELR_ATTRIBUTE22 ELR_ATTRIBUTE22
, ELR_ATTRIBUTE23 ELR_ATTRIBUTE23
, ELR_ATTRIBUTE24 ELR_ATTRIBUTE24
, ELR_ATTRIBUTE25 ELR_ATTRIBUTE25
, ELR_ATTRIBUTE26 ELR_ATTRIBUTE26
, ELR_ATTRIBUTE27 ELR_ATTRIBUTE27
, ELR_ATTRIBUTE28 ELR_ATTRIBUTE28
, ELR_ATTRIBUTE29 ELR_ATTRIBUTE29
, ELR_ATTRIBUTE30 ELR_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
, ABSENCE_ATTENDANCE_TYPE_ID ABSENCE_ATTENDANCE_TYPE_ID
, ORDR_NUM ORDR_NUM
, ABS_ATTENDANCE_REASON_ID ABS_ATTENDANCE_REASON_ID
, CRITERIA_SCORE CRITERIA_SCORE
, CRITERIA_WEIGHT CRITERIA_WEIGHT
FROM "BEN"."BEN_ELIG_LOA_RSN_PRTE_F"