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

Source

View Text - Preformatted


select ELIG_DPNT_CVRD_OTHR_PTIP_ID ELIG_DPNT_CVRD_OTHR_PTIP_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, PTIP_ID PTIP_ID, ELIGY_PRFL_ID ELIGY_PRFL_ID, BUSINESS_GROUP_ID BUSINESS_GROUP_ID, EDT_ATTRIBUTE_CATEGORY EDT_ATTRIBUTE_CATEGORY, EDT_ATTRIBUTE1 EDT_ATTRIBUTE1, EDT_ATTRIBUTE2 EDT_ATTRIBUTE2, EDT_ATTRIBUTE3 EDT_ATTRIBUTE3, EDT_ATTRIBUTE4 EDT_ATTRIBUTE4, EDT_ATTRIBUTE5 EDT_ATTRIBUTE5, EDT_ATTRIBUTE6 EDT_ATTRIBUTE6, EDT_ATTRIBUTE7 EDT_ATTRIBUTE7, EDT_ATTRIBUTE8 EDT_ATTRIBUTE8, EDT_ATTRIBUTE9 EDT_ATTRIBUTE9, EDT_ATTRIBUTE10 EDT_ATTRIBUTE10, EDT_ATTRIBUTE11 EDT_ATTRIBUTE11, EDT_ATTRIBUTE12 EDT_ATTRIBUTE12, EDT_ATTRIBUTE13 EDT_ATTRIBUTE13, EDT_ATTRIBUTE14 EDT_ATTRIBUTE14, EDT_ATTRIBUTE15 EDT_ATTRIBUTE15, EDT_ATTRIBUTE16 EDT_ATTRIBUTE16, EDT_ATTRIBUTE17 EDT_ATTRIBUTE17, EDT_ATTRIBUTE18 EDT_ATTRIBUTE18, EDT_ATTRIBUTE19 EDT_ATTRIBUTE19, EDT_ATTRIBUTE20 EDT_ATTRIBUTE20, EDT_ATTRIBUTE21 EDT_ATTRIBUTE21, EDT_ATTRIBUTE22 EDT_ATTRIBUTE22, EDT_ATTRIBUTE23 EDT_ATTRIBUTE23, EDT_ATTRIBUTE24 EDT_ATTRIBUTE24, EDT_ATTRIBUTE25 EDT_ATTRIBUTE25, EDT_ATTRIBUTE26 EDT_ATTRIBUTE26, EDT_ATTRIBUTE27 EDT_ATTRIBUTE27, EDT_ATTRIBUTE28 EDT_ATTRIBUTE28, EDT_ATTRIBUTE29 EDT_ATTRIBUTE29, EDT_ATTRIBUTE30 EDT_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, ENRL_DET_DT_CD ENRL_DET_DT_CD from "BEN"."BEN_ELIG_DPNT_CVRD_OTHR_PTIP_F"

View Text - HTML Formatted

SELECT ELIG_DPNT_CVRD_OTHR_PTIP_ID ELIG_DPNT_CVRD_OTHR_PTIP_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
, PTIP_ID PTIP_ID
, ELIGY_PRFL_ID ELIGY_PRFL_ID
, BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, EDT_ATTRIBUTE_CATEGORY EDT_ATTRIBUTE_CATEGORY
, EDT_ATTRIBUTE1 EDT_ATTRIBUTE1
, EDT_ATTRIBUTE2 EDT_ATTRIBUTE2
, EDT_ATTRIBUTE3 EDT_ATTRIBUTE3
, EDT_ATTRIBUTE4 EDT_ATTRIBUTE4
, EDT_ATTRIBUTE5 EDT_ATTRIBUTE5
, EDT_ATTRIBUTE6 EDT_ATTRIBUTE6
, EDT_ATTRIBUTE7 EDT_ATTRIBUTE7
, EDT_ATTRIBUTE8 EDT_ATTRIBUTE8
, EDT_ATTRIBUTE9 EDT_ATTRIBUTE9
, EDT_ATTRIBUTE10 EDT_ATTRIBUTE10
, EDT_ATTRIBUTE11 EDT_ATTRIBUTE11
, EDT_ATTRIBUTE12 EDT_ATTRIBUTE12
, EDT_ATTRIBUTE13 EDT_ATTRIBUTE13
, EDT_ATTRIBUTE14 EDT_ATTRIBUTE14
, EDT_ATTRIBUTE15 EDT_ATTRIBUTE15
, EDT_ATTRIBUTE16 EDT_ATTRIBUTE16
, EDT_ATTRIBUTE17 EDT_ATTRIBUTE17
, EDT_ATTRIBUTE18 EDT_ATTRIBUTE18
, EDT_ATTRIBUTE19 EDT_ATTRIBUTE19
, EDT_ATTRIBUTE20 EDT_ATTRIBUTE20
, EDT_ATTRIBUTE21 EDT_ATTRIBUTE21
, EDT_ATTRIBUTE22 EDT_ATTRIBUTE22
, EDT_ATTRIBUTE23 EDT_ATTRIBUTE23
, EDT_ATTRIBUTE24 EDT_ATTRIBUTE24
, EDT_ATTRIBUTE25 EDT_ATTRIBUTE25
, EDT_ATTRIBUTE26 EDT_ATTRIBUTE26
, EDT_ATTRIBUTE27 EDT_ATTRIBUTE27
, EDT_ATTRIBUTE28 EDT_ATTRIBUTE28
, EDT_ATTRIBUTE29 EDT_ATTRIBUTE29
, EDT_ATTRIBUTE30 EDT_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
, ENRL_DET_DT_CD ENRL_DET_DT_CD
FROM "BEN"."BEN_ELIG_DPNT_CVRD_OTHR_PTIP_F"