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

Source

View Text - Preformatted


select ELIG_MRTL_STAT_CVG_ID ELIG_MRTL_STAT_CVG_ID, EFFECTIVE_START_DATE EFFECTIVE_START_DATE, EFFECTIVE_END_DATE EFFECTIVE_END_DATE, BUSINESS_GROUP_ID BUSINESS_GROUP_ID, MRTL_STAT_CD MRTL_STAT_CD, CVG_STRT_CD CVG_STRT_CD, CVG_THRU_CD CVG_THRU_CD, DPNT_CVG_ELIGY_PRFL_ID DPNT_CVG_ELIGY_PRFL_ID, CVG_STRT_RL CVG_STRT_RL, CVG_THRU_RL CVG_THRU_RL, EMS_ATTRIBUTE_CATEGORY EMS_ATTRIBUTE_CATEGORY, EMS_ATTRIBUTE1 EMS_ATTRIBUTE1, EMS_ATTRIBUTE2 EMS_ATTRIBUTE2, EMS_ATTRIBUTE3 EMS_ATTRIBUTE3, EMS_ATTRIBUTE4 EMS_ATTRIBUTE4, EMS_ATTRIBUTE5 EMS_ATTRIBUTE5, EMS_ATTRIBUTE6 EMS_ATTRIBUTE6, EMS_ATTRIBUTE7 EMS_ATTRIBUTE7, EMS_ATTRIBUTE8 EMS_ATTRIBUTE8, EMS_ATTRIBUTE9 EMS_ATTRIBUTE9, EMS_ATTRIBUTE10 EMS_ATTRIBUTE10, EMS_ATTRIBUTE11 EMS_ATTRIBUTE11, EMS_ATTRIBUTE12 EMS_ATTRIBUTE12, EMS_ATTRIBUTE13 EMS_ATTRIBUTE13, EMS_ATTRIBUTE14 EMS_ATTRIBUTE14, EMS_ATTRIBUTE15 EMS_ATTRIBUTE15, EMS_ATTRIBUTE16 EMS_ATTRIBUTE16, EMS_ATTRIBUTE17 EMS_ATTRIBUTE17, EMS_ATTRIBUTE18 EMS_ATTRIBUTE18, EMS_ATTRIBUTE19 EMS_ATTRIBUTE19, EMS_ATTRIBUTE20 EMS_ATTRIBUTE20, EMS_ATTRIBUTE21 EMS_ATTRIBUTE21, EMS_ATTRIBUTE22 EMS_ATTRIBUTE22, EMS_ATTRIBUTE23 EMS_ATTRIBUTE23, EMS_ATTRIBUTE24 EMS_ATTRIBUTE24, EMS_ATTRIBUTE25 EMS_ATTRIBUTE25, EMS_ATTRIBUTE26 EMS_ATTRIBUTE26, EMS_ATTRIBUTE27 EMS_ATTRIBUTE27, EMS_ATTRIBUTE28 EMS_ATTRIBUTE28, EMS_ATTRIBUTE29 EMS_ATTRIBUTE29, EMS_ATTRIBUTE30 EMS_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 from "BEN"."BEN_ELIG_MRTL_STAT_CVG_F"

View Text - HTML Formatted

SELECT ELIG_MRTL_STAT_CVG_ID ELIG_MRTL_STAT_CVG_ID
, EFFECTIVE_START_DATE EFFECTIVE_START_DATE
, EFFECTIVE_END_DATE EFFECTIVE_END_DATE
, BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, MRTL_STAT_CD MRTL_STAT_CD
, CVG_STRT_CD CVG_STRT_CD
, CVG_THRU_CD CVG_THRU_CD
, DPNT_CVG_ELIGY_PRFL_ID DPNT_CVG_ELIGY_PRFL_ID
, CVG_STRT_RL CVG_STRT_RL
, CVG_THRU_RL CVG_THRU_RL
, EMS_ATTRIBUTE_CATEGORY EMS_ATTRIBUTE_CATEGORY
, EMS_ATTRIBUTE1 EMS_ATTRIBUTE1
, EMS_ATTRIBUTE2 EMS_ATTRIBUTE2
, EMS_ATTRIBUTE3 EMS_ATTRIBUTE3
, EMS_ATTRIBUTE4 EMS_ATTRIBUTE4
, EMS_ATTRIBUTE5 EMS_ATTRIBUTE5
, EMS_ATTRIBUTE6 EMS_ATTRIBUTE6
, EMS_ATTRIBUTE7 EMS_ATTRIBUTE7
, EMS_ATTRIBUTE8 EMS_ATTRIBUTE8
, EMS_ATTRIBUTE9 EMS_ATTRIBUTE9
, EMS_ATTRIBUTE10 EMS_ATTRIBUTE10
, EMS_ATTRIBUTE11 EMS_ATTRIBUTE11
, EMS_ATTRIBUTE12 EMS_ATTRIBUTE12
, EMS_ATTRIBUTE13 EMS_ATTRIBUTE13
, EMS_ATTRIBUTE14 EMS_ATTRIBUTE14
, EMS_ATTRIBUTE15 EMS_ATTRIBUTE15
, EMS_ATTRIBUTE16 EMS_ATTRIBUTE16
, EMS_ATTRIBUTE17 EMS_ATTRIBUTE17
, EMS_ATTRIBUTE18 EMS_ATTRIBUTE18
, EMS_ATTRIBUTE19 EMS_ATTRIBUTE19
, EMS_ATTRIBUTE20 EMS_ATTRIBUTE20
, EMS_ATTRIBUTE21 EMS_ATTRIBUTE21
, EMS_ATTRIBUTE22 EMS_ATTRIBUTE22
, EMS_ATTRIBUTE23 EMS_ATTRIBUTE23
, EMS_ATTRIBUTE24 EMS_ATTRIBUTE24
, EMS_ATTRIBUTE25 EMS_ATTRIBUTE25
, EMS_ATTRIBUTE26 EMS_ATTRIBUTE26
, EMS_ATTRIBUTE27 EMS_ATTRIBUTE27
, EMS_ATTRIBUTE28 EMS_ATTRIBUTE28
, EMS_ATTRIBUTE29 EMS_ATTRIBUTE29
, EMS_ATTRIBUTE30 EMS_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
FROM "BEN"."BEN_ELIG_MRTL_STAT_CVG_F"