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

Source

View Text - Preformatted


select ELIG_MLTRY_STAT_CVG_ID ELIG_MLTRY_STAT_CVG_ID, EFFECTIVE_START_DATE EFFECTIVE_START_DATE, EFFECTIVE_END_DATE EFFECTIVE_END_DATE, BUSINESS_GROUP_ID BUSINESS_GROUP_ID, MLTRY_STAT_CD MLTRY_STAT_CD, CVG_STRT_CD CVG_STRT_CD, CVG_THRU_CD CVG_THRU_CD, CVG_STRT_RL CVG_STRT_RL, CVG_THRU_RL CVG_THRU_RL, EMC_ATTRIBUTE_CATEGORY EMC_ATTRIBUTE_CATEGORY, EMC_ATTRIBUTE1 EMC_ATTRIBUTE1, EMC_ATTRIBUTE2 EMC_ATTRIBUTE2, EMC_ATTRIBUTE3 EMC_ATTRIBUTE3, EMC_ATTRIBUTE4 EMC_ATTRIBUTE4, EMC_ATTRIBUTE5 EMC_ATTRIBUTE5, EMC_ATTRIBUTE6 EMC_ATTRIBUTE6, EMC_ATTRIBUTE7 EMC_ATTRIBUTE7, EMC_ATTRIBUTE8 EMC_ATTRIBUTE8, EMC_ATTRIBUTE9 EMC_ATTRIBUTE9, EMC_ATTRIBUTE10 EMC_ATTRIBUTE10, EMC_ATTRIBUTE11 EMC_ATTRIBUTE11, EMC_ATTRIBUTE12 EMC_ATTRIBUTE12, EMC_ATTRIBUTE13 EMC_ATTRIBUTE13, EMC_ATTRIBUTE14 EMC_ATTRIBUTE14, EMC_ATTRIBUTE15 EMC_ATTRIBUTE15, EMC_ATTRIBUTE16 EMC_ATTRIBUTE16, EMC_ATTRIBUTE17 EMC_ATTRIBUTE17, EMC_ATTRIBUTE18 EMC_ATTRIBUTE18, EMC_ATTRIBUTE19 EMC_ATTRIBUTE19, EMC_ATTRIBUTE20 EMC_ATTRIBUTE20, EMC_ATTRIBUTE21 EMC_ATTRIBUTE21, EMC_ATTRIBUTE22 EMC_ATTRIBUTE22, EMC_ATTRIBUTE23 EMC_ATTRIBUTE23, EMC_ATTRIBUTE24 EMC_ATTRIBUTE24, EMC_ATTRIBUTE25 EMC_ATTRIBUTE25, EMC_ATTRIBUTE26 EMC_ATTRIBUTE26, EMC_ATTRIBUTE27 EMC_ATTRIBUTE27, EMC_ATTRIBUTE28 EMC_ATTRIBUTE28, EMC_ATTRIBUTE29 EMC_ATTRIBUTE29, EMC_ATTRIBUTE30 EMC_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, DPNT_CVG_ELIGY_PRFL_ID DPNT_CVG_ELIGY_PRFL_ID from "BEN"."BEN_ELIG_MLTRY_STAT_CVG_F"

View Text - HTML Formatted

SELECT ELIG_MLTRY_STAT_CVG_ID ELIG_MLTRY_STAT_CVG_ID
, EFFECTIVE_START_DATE EFFECTIVE_START_DATE
, EFFECTIVE_END_DATE EFFECTIVE_END_DATE
, BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, MLTRY_STAT_CD MLTRY_STAT_CD
, CVG_STRT_CD CVG_STRT_CD
, CVG_THRU_CD CVG_THRU_CD
, CVG_STRT_RL CVG_STRT_RL
, CVG_THRU_RL CVG_THRU_RL
, EMC_ATTRIBUTE_CATEGORY EMC_ATTRIBUTE_CATEGORY
, EMC_ATTRIBUTE1 EMC_ATTRIBUTE1
, EMC_ATTRIBUTE2 EMC_ATTRIBUTE2
, EMC_ATTRIBUTE3 EMC_ATTRIBUTE3
, EMC_ATTRIBUTE4 EMC_ATTRIBUTE4
, EMC_ATTRIBUTE5 EMC_ATTRIBUTE5
, EMC_ATTRIBUTE6 EMC_ATTRIBUTE6
, EMC_ATTRIBUTE7 EMC_ATTRIBUTE7
, EMC_ATTRIBUTE8 EMC_ATTRIBUTE8
, EMC_ATTRIBUTE9 EMC_ATTRIBUTE9
, EMC_ATTRIBUTE10 EMC_ATTRIBUTE10
, EMC_ATTRIBUTE11 EMC_ATTRIBUTE11
, EMC_ATTRIBUTE12 EMC_ATTRIBUTE12
, EMC_ATTRIBUTE13 EMC_ATTRIBUTE13
, EMC_ATTRIBUTE14 EMC_ATTRIBUTE14
, EMC_ATTRIBUTE15 EMC_ATTRIBUTE15
, EMC_ATTRIBUTE16 EMC_ATTRIBUTE16
, EMC_ATTRIBUTE17 EMC_ATTRIBUTE17
, EMC_ATTRIBUTE18 EMC_ATTRIBUTE18
, EMC_ATTRIBUTE19 EMC_ATTRIBUTE19
, EMC_ATTRIBUTE20 EMC_ATTRIBUTE20
, EMC_ATTRIBUTE21 EMC_ATTRIBUTE21
, EMC_ATTRIBUTE22 EMC_ATTRIBUTE22
, EMC_ATTRIBUTE23 EMC_ATTRIBUTE23
, EMC_ATTRIBUTE24 EMC_ATTRIBUTE24
, EMC_ATTRIBUTE25 EMC_ATTRIBUTE25
, EMC_ATTRIBUTE26 EMC_ATTRIBUTE26
, EMC_ATTRIBUTE27 EMC_ATTRIBUTE27
, EMC_ATTRIBUTE28 EMC_ATTRIBUTE28
, EMC_ATTRIBUTE29 EMC_ATTRIBUTE29
, EMC_ATTRIBUTE30 EMC_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
, DPNT_CVG_ELIGY_PRFL_ID DPNT_CVG_ELIGY_PRFL_ID
FROM "BEN"."BEN_ELIG_MLTRY_STAT_CVG_F"