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.

VIEW: BEN.BEN_ELIG_DPNT_CVRD_OTHR_PGM_F#

Source

View Text - Preformatted


select ELIG_DPNT_CVRD_OTHR_PGM_ID ELIG_DPNT_CVRD_OTHR_PGM_ID, EFFECTIVE_START_DATE EFFECTIVE_START_DATE, EFFECTIVE_END_DATE EFFECTIVE_END_DATE, EXCLD_FLAG EXCLD_FLAG, ONLY_PLS_SUBJ_COBRA_FLAG ONLY_PLS_SUBJ_COBRA_FLAG, PGM_ID PGM_ID, ELIGY_PRFL_ID ELIGY_PRFL_ID, BUSINESS_GROUP_ID BUSINESS_GROUP_ID, EDG_ATTRIBUTE_CATEGORY EDG_ATTRIBUTE_CATEGORY, EDG_ATTRIBUTE1 EDG_ATTRIBUTE1, EDG_ATTRIBUTE2 EDG_ATTRIBUTE2, EDG_ATTRIBUTE3 EDG_ATTRIBUTE3, EDG_ATTRIBUTE4 EDG_ATTRIBUTE4, EDG_ATTRIBUTE5 EDG_ATTRIBUTE5, EDG_ATTRIBUTE6 EDG_ATTRIBUTE6, EDG_ATTRIBUTE7 EDG_ATTRIBUTE7, EDG_ATTRIBUTE8 EDG_ATTRIBUTE8, EDG_ATTRIBUTE9 EDG_ATTRIBUTE9, EDG_ATTRIBUTE10 EDG_ATTRIBUTE10, EDG_ATTRIBUTE11 EDG_ATTRIBUTE11, EDG_ATTRIBUTE12 EDG_ATTRIBUTE12, EDG_ATTRIBUTE13 EDG_ATTRIBUTE13, EDG_ATTRIBUTE14 EDG_ATTRIBUTE14, EDG_ATTRIBUTE15 EDG_ATTRIBUTE15, EDG_ATTRIBUTE16 EDG_ATTRIBUTE16, EDG_ATTRIBUTE17 EDG_ATTRIBUTE17, EDG_ATTRIBUTE18 EDG_ATTRIBUTE18, EDG_ATTRIBUTE19 EDG_ATTRIBUTE19, EDG_ATTRIBUTE20 EDG_ATTRIBUTE20, EDG_ATTRIBUTE21 EDG_ATTRIBUTE21, EDG_ATTRIBUTE22 EDG_ATTRIBUTE22, EDG_ATTRIBUTE23 EDG_ATTRIBUTE23, EDG_ATTRIBUTE24 EDG_ATTRIBUTE24, EDG_ATTRIBUTE25 EDG_ATTRIBUTE25, EDG_ATTRIBUTE26 EDG_ATTRIBUTE26, EDG_ATTRIBUTE27 EDG_ATTRIBUTE27, EDG_ATTRIBUTE28 EDG_ATTRIBUTE28, EDG_ATTRIBUTE29 EDG_ATTRIBUTE29, EDG_ATTRIBUTE30 EDG_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, ENRL_DET_DT_CD ENRL_DET_DT_CD, ORDR_NUM ORDR_NUM from "BEN"."BEN_ELIG_DPNT_CVRD_OTHR_PGM_F"

View Text - HTML Formatted

SELECT ELIG_DPNT_CVRD_OTHR_PGM_ID ELIG_DPNT_CVRD_OTHR_PGM_ID
, EFFECTIVE_START_DATE EFFECTIVE_START_DATE
, EFFECTIVE_END_DATE EFFECTIVE_END_DATE
, EXCLD_FLAG EXCLD_FLAG
, ONLY_PLS_SUBJ_COBRA_FLAG ONLY_PLS_SUBJ_COBRA_FLAG
, PGM_ID PGM_ID
, ELIGY_PRFL_ID ELIGY_PRFL_ID
, BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, EDG_ATTRIBUTE_CATEGORY EDG_ATTRIBUTE_CATEGORY
, EDG_ATTRIBUTE1 EDG_ATTRIBUTE1
, EDG_ATTRIBUTE2 EDG_ATTRIBUTE2
, EDG_ATTRIBUTE3 EDG_ATTRIBUTE3
, EDG_ATTRIBUTE4 EDG_ATTRIBUTE4
, EDG_ATTRIBUTE5 EDG_ATTRIBUTE5
, EDG_ATTRIBUTE6 EDG_ATTRIBUTE6
, EDG_ATTRIBUTE7 EDG_ATTRIBUTE7
, EDG_ATTRIBUTE8 EDG_ATTRIBUTE8
, EDG_ATTRIBUTE9 EDG_ATTRIBUTE9
, EDG_ATTRIBUTE10 EDG_ATTRIBUTE10
, EDG_ATTRIBUTE11 EDG_ATTRIBUTE11
, EDG_ATTRIBUTE12 EDG_ATTRIBUTE12
, EDG_ATTRIBUTE13 EDG_ATTRIBUTE13
, EDG_ATTRIBUTE14 EDG_ATTRIBUTE14
, EDG_ATTRIBUTE15 EDG_ATTRIBUTE15
, EDG_ATTRIBUTE16 EDG_ATTRIBUTE16
, EDG_ATTRIBUTE17 EDG_ATTRIBUTE17
, EDG_ATTRIBUTE18 EDG_ATTRIBUTE18
, EDG_ATTRIBUTE19 EDG_ATTRIBUTE19
, EDG_ATTRIBUTE20 EDG_ATTRIBUTE20
, EDG_ATTRIBUTE21 EDG_ATTRIBUTE21
, EDG_ATTRIBUTE22 EDG_ATTRIBUTE22
, EDG_ATTRIBUTE23 EDG_ATTRIBUTE23
, EDG_ATTRIBUTE24 EDG_ATTRIBUTE24
, EDG_ATTRIBUTE25 EDG_ATTRIBUTE25
, EDG_ATTRIBUTE26 EDG_ATTRIBUTE26
, EDG_ATTRIBUTE27 EDG_ATTRIBUTE27
, EDG_ATTRIBUTE28 EDG_ATTRIBUTE28
, EDG_ATTRIBUTE29 EDG_ATTRIBUTE29
, EDG_ATTRIBUTE30 EDG_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
, ENRL_DET_DT_CD ENRL_DET_DT_CD
, ORDR_NUM ORDR_NUM
FROM "BEN"."BEN_ELIG_DPNT_CVRD_OTHR_PGM_F"