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

Source

View Text - Preformatted


select ELIG_JOB_PRTE_ID ELIG_JOB_PRTE_ID, EFFECTIVE_START_DATE EFFECTIVE_START_DATE, EFFECTIVE_END_DATE EFFECTIVE_END_DATE, JOB_ID JOB_ID, EXCLD_FLAG EXCLD_FLAG, BUSINESS_GROUP_ID BUSINESS_GROUP_ID, ELIGY_PRFL_ID ELIGY_PRFL_ID, EJP_ATTRIBUTE_CATEGORY EJP_ATTRIBUTE_CATEGORY, EJP_ATTRIBUTE1 EJP_ATTRIBUTE1, EJP_ATTRIBUTE2 EJP_ATTRIBUTE2, EJP_ATTRIBUTE3 EJP_ATTRIBUTE3, EJP_ATTRIBUTE4 EJP_ATTRIBUTE4, EJP_ATTRIBUTE5 EJP_ATTRIBUTE5, EJP_ATTRIBUTE6 EJP_ATTRIBUTE6, EJP_ATTRIBUTE7 EJP_ATTRIBUTE7, EJP_ATTRIBUTE8 EJP_ATTRIBUTE8, EJP_ATTRIBUTE9 EJP_ATTRIBUTE9, EJP_ATTRIBUTE10 EJP_ATTRIBUTE10, EJP_ATTRIBUTE11 EJP_ATTRIBUTE11, EJP_ATTRIBUTE12 EJP_ATTRIBUTE12, EJP_ATTRIBUTE13 EJP_ATTRIBUTE13, EJP_ATTRIBUTE14 EJP_ATTRIBUTE14, EJP_ATTRIBUTE15 EJP_ATTRIBUTE15, EJP_ATTRIBUTE16 EJP_ATTRIBUTE16, EJP_ATTRIBUTE17 EJP_ATTRIBUTE17, EJP_ATTRIBUTE18 EJP_ATTRIBUTE18, EJP_ATTRIBUTE19 EJP_ATTRIBUTE19, EJP_ATTRIBUTE20 EJP_ATTRIBUTE20, EJP_ATTRIBUTE21 EJP_ATTRIBUTE21, EJP_ATTRIBUTE22 EJP_ATTRIBUTE22, EJP_ATTRIBUTE23 EJP_ATTRIBUTE23, EJP_ATTRIBUTE24 EJP_ATTRIBUTE24, EJP_ATTRIBUTE25 EJP_ATTRIBUTE25, EJP_ATTRIBUTE26 EJP_ATTRIBUTE26, EJP_ATTRIBUTE27 EJP_ATTRIBUTE27, EJP_ATTRIBUTE28 EJP_ATTRIBUTE28, EJP_ATTRIBUTE29 EJP_ATTRIBUTE29, EJP_ATTRIBUTE30 EJP_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_JOB_PRTE_F"

View Text - HTML Formatted

SELECT ELIG_JOB_PRTE_ID ELIG_JOB_PRTE_ID
, EFFECTIVE_START_DATE EFFECTIVE_START_DATE
, EFFECTIVE_END_DATE EFFECTIVE_END_DATE
, JOB_ID JOB_ID
, EXCLD_FLAG EXCLD_FLAG
, BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, ELIGY_PRFL_ID ELIGY_PRFL_ID
, EJP_ATTRIBUTE_CATEGORY EJP_ATTRIBUTE_CATEGORY
, EJP_ATTRIBUTE1 EJP_ATTRIBUTE1
, EJP_ATTRIBUTE2 EJP_ATTRIBUTE2
, EJP_ATTRIBUTE3 EJP_ATTRIBUTE3
, EJP_ATTRIBUTE4 EJP_ATTRIBUTE4
, EJP_ATTRIBUTE5 EJP_ATTRIBUTE5
, EJP_ATTRIBUTE6 EJP_ATTRIBUTE6
, EJP_ATTRIBUTE7 EJP_ATTRIBUTE7
, EJP_ATTRIBUTE8 EJP_ATTRIBUTE8
, EJP_ATTRIBUTE9 EJP_ATTRIBUTE9
, EJP_ATTRIBUTE10 EJP_ATTRIBUTE10
, EJP_ATTRIBUTE11 EJP_ATTRIBUTE11
, EJP_ATTRIBUTE12 EJP_ATTRIBUTE12
, EJP_ATTRIBUTE13 EJP_ATTRIBUTE13
, EJP_ATTRIBUTE14 EJP_ATTRIBUTE14
, EJP_ATTRIBUTE15 EJP_ATTRIBUTE15
, EJP_ATTRIBUTE16 EJP_ATTRIBUTE16
, EJP_ATTRIBUTE17 EJP_ATTRIBUTE17
, EJP_ATTRIBUTE18 EJP_ATTRIBUTE18
, EJP_ATTRIBUTE19 EJP_ATTRIBUTE19
, EJP_ATTRIBUTE20 EJP_ATTRIBUTE20
, EJP_ATTRIBUTE21 EJP_ATTRIBUTE21
, EJP_ATTRIBUTE22 EJP_ATTRIBUTE22
, EJP_ATTRIBUTE23 EJP_ATTRIBUTE23
, EJP_ATTRIBUTE24 EJP_ATTRIBUTE24
, EJP_ATTRIBUTE25 EJP_ATTRIBUTE25
, EJP_ATTRIBUTE26 EJP_ATTRIBUTE26
, EJP_ATTRIBUTE27 EJP_ATTRIBUTE27
, EJP_ATTRIBUTE28 EJP_ATTRIBUTE28
, EJP_ATTRIBUTE29 EJP_ATTRIBUTE29
, EJP_ATTRIBUTE30 EJP_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_JOB_PRTE_F"