VIEW: BEN.BEN_ELIG_SCHEDD_HRS_PRTE_F#

Source

View Text - Preformatted

select ELIG_SCHEDD_HRS_PRTE_ID ELIG_SCHEDD_HRS_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, ESH_ATTRIBUTE_CATEGORY ESH_ATTRIBUTE_CATEGORY, ESH_ATTRIBUTE1 ESH_ATTRIBUTE1, ESH_ATTRIBUTE2 ESH_ATTRIBUTE2, ESH_ATTRIBUTE3 ESH_ATTRIBUTE3, ESH_ATTRIBUTE4 ESH_ATTRIBUTE4, ESH_ATTRIBUTE5 ESH_ATTRIBUTE5, ESH_ATTRIBUTE6 ESH_ATTRIBUTE6, ESH_ATTRIBUTE7 ESH_ATTRIBUTE7, ESH_ATTRIBUTE8 ESH_ATTRIBUTE8, ESH_ATTRIBUTE9 ESH_ATTRIBUTE9, ESH_ATTRIBUTE10 ESH_ATTRIBUTE10, ESH_ATTRIBUTE11 ESH_ATTRIBUTE11, ESH_ATTRIBUTE12 ESH_ATTRIBUTE12, ESH_ATTRIBUTE13 ESH_ATTRIBUTE13, ESH_ATTRIBUTE14 ESH_ATTRIBUTE14, ESH_ATTRIBUTE15 ESH_ATTRIBUTE15, ESH_ATTRIBUTE16 ESH_ATTRIBUTE16, ESH_ATTRIBUTE17 ESH_ATTRIBUTE17, ESH_ATTRIBUTE18 ESH_ATTRIBUTE18, ESH_ATTRIBUTE19 ESH_ATTRIBUTE19, ESH_ATTRIBUTE20 ESH_ATTRIBUTE20, ESH_ATTRIBUTE21 ESH_ATTRIBUTE21, ESH_ATTRIBUTE22 ESH_ATTRIBUTE22, ESH_ATTRIBUTE23 ESH_ATTRIBUTE23, ESH_ATTRIBUTE24 ESH_ATTRIBUTE24, ESH_ATTRIBUTE25 ESH_ATTRIBUTE25, ESH_ATTRIBUTE26 ESH_ATTRIBUTE26, ESH_ATTRIBUTE27 ESH_ATTRIBUTE27, ESH_ATTRIBUTE28 ESH_ATTRIBUTE28, ESH_ATTRIBUTE29 ESH_ATTRIBUTE29, ESH_ATTRIBUTE30 ESH_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, HRS_NUM HRS_NUM, FREQ_CD FREQ_CD, ORDR_NUM ORDR_NUM, DETERMINATION_CD DETERMINATION_CD, DETERMINATION_RL DETERMINATION_RL, MAX_HRS_NUM MAX_HRS_NUM, ROUNDING_CD ROUNDING_CD, ROUNDING_RL ROUNDING_RL, SCHEDD_HRS_RL SCHEDD_HRS_RL, CRITERIA_SCORE CRITERIA_SCORE, CRITERIA_WEIGHT CRITERIA_WEIGHT from "BEN"."BEN_ELIG_SCHEDD_HRS_PRTE_F"

View Text - HTML Formatted

SELECT ELIG_SCHEDD_HRS_PRTE_ID ELIG_SCHEDD_HRS_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
, ESH_ATTRIBUTE_CATEGORY ESH_ATTRIBUTE_CATEGORY
, ESH_ATTRIBUTE1 ESH_ATTRIBUTE1
, ESH_ATTRIBUTE2 ESH_ATTRIBUTE2
, ESH_ATTRIBUTE3 ESH_ATTRIBUTE3
, ESH_ATTRIBUTE4 ESH_ATTRIBUTE4
, ESH_ATTRIBUTE5 ESH_ATTRIBUTE5
, ESH_ATTRIBUTE6 ESH_ATTRIBUTE6
, ESH_ATTRIBUTE7 ESH_ATTRIBUTE7
, ESH_ATTRIBUTE8 ESH_ATTRIBUTE8
, ESH_ATTRIBUTE9 ESH_ATTRIBUTE9
, ESH_ATTRIBUTE10 ESH_ATTRIBUTE10
, ESH_ATTRIBUTE11 ESH_ATTRIBUTE11
, ESH_ATTRIBUTE12 ESH_ATTRIBUTE12
, ESH_ATTRIBUTE13 ESH_ATTRIBUTE13
, ESH_ATTRIBUTE14 ESH_ATTRIBUTE14
, ESH_ATTRIBUTE15 ESH_ATTRIBUTE15
, ESH_ATTRIBUTE16 ESH_ATTRIBUTE16
, ESH_ATTRIBUTE17 ESH_ATTRIBUTE17
, ESH_ATTRIBUTE18 ESH_ATTRIBUTE18
, ESH_ATTRIBUTE19 ESH_ATTRIBUTE19
, ESH_ATTRIBUTE20 ESH_ATTRIBUTE20
, ESH_ATTRIBUTE21 ESH_ATTRIBUTE21
, ESH_ATTRIBUTE22 ESH_ATTRIBUTE22
, ESH_ATTRIBUTE23 ESH_ATTRIBUTE23
, ESH_ATTRIBUTE24 ESH_ATTRIBUTE24
, ESH_ATTRIBUTE25 ESH_ATTRIBUTE25
, ESH_ATTRIBUTE26 ESH_ATTRIBUTE26
, ESH_ATTRIBUTE27 ESH_ATTRIBUTE27
, ESH_ATTRIBUTE28 ESH_ATTRIBUTE28
, ESH_ATTRIBUTE29 ESH_ATTRIBUTE29
, ESH_ATTRIBUTE30 ESH_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
, HRS_NUM HRS_NUM
, FREQ_CD FREQ_CD
, ORDR_NUM ORDR_NUM
, DETERMINATION_CD DETERMINATION_CD
, DETERMINATION_RL DETERMINATION_RL
, MAX_HRS_NUM MAX_HRS_NUM
, ROUNDING_CD ROUNDING_CD
, ROUNDING_RL ROUNDING_RL
, SCHEDD_HRS_RL SCHEDD_HRS_RL
, CRITERIA_SCORE CRITERIA_SCORE
, CRITERIA_WEIGHT CRITERIA_WEIGHT
FROM "BEN"."BEN_ELIG_SCHEDD_HRS_PRTE_F"