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

Source

View Text - Preformatted


select ENRLD_ANTHR_PTIP_RT_ID ENRLD_ANTHR_PTIP_RT_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, VRBL_RT_PRFL_ID VRBL_RT_PRFL_ID, BUSINESS_GROUP_ID BUSINESS_GROUP_ID, ENT_ATTRIBUTE_CATEGORY ENT_ATTRIBUTE_CATEGORY, ENT_ATTRIBUTE1 ENT_ATTRIBUTE1, ENT_ATTRIBUTE2 ENT_ATTRIBUTE2, ENT_ATTRIBUTE3 ENT_ATTRIBUTE3, ENT_ATTRIBUTE4 ENT_ATTRIBUTE4, ENT_ATTRIBUTE5 ENT_ATTRIBUTE5, ENT_ATTRIBUTE6 ENT_ATTRIBUTE6, ENT_ATTRIBUTE7 ENT_ATTRIBUTE7, ENT_ATTRIBUTE8 ENT_ATTRIBUTE8, ENT_ATTRIBUTE9 ENT_ATTRIBUTE9, ENT_ATTRIBUTE10 ENT_ATTRIBUTE10, ENT_ATTRIBUTE11 ENT_ATTRIBUTE11, ENT_ATTRIBUTE12 ENT_ATTRIBUTE12, ENT_ATTRIBUTE13 ENT_ATTRIBUTE13, ENT_ATTRIBUTE14 ENT_ATTRIBUTE14, ENT_ATTRIBUTE15 ENT_ATTRIBUTE15, ENT_ATTRIBUTE16 ENT_ATTRIBUTE16, ENT_ATTRIBUTE17 ENT_ATTRIBUTE17, ENT_ATTRIBUTE18 ENT_ATTRIBUTE18, ENT_ATTRIBUTE19 ENT_ATTRIBUTE19, ENT_ATTRIBUTE20 ENT_ATTRIBUTE20, ENT_ATTRIBUTE21 ENT_ATTRIBUTE21, ENT_ATTRIBUTE22 ENT_ATTRIBUTE22, ENT_ATTRIBUTE23 ENT_ATTRIBUTE23, ENT_ATTRIBUTE24 ENT_ATTRIBUTE24, ENT_ATTRIBUTE25 ENT_ATTRIBUTE25, ENT_ATTRIBUTE26 ENT_ATTRIBUTE26, ENT_ATTRIBUTE27 ENT_ATTRIBUTE27, ENT_ATTRIBUTE28 ENT_ATTRIBUTE28, ENT_ATTRIBUTE29 ENT_ATTRIBUTE29, ENT_ATTRIBUTE30 ENT_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_ENRLD_ANTHR_PTIP_RT_F"

View Text - HTML Formatted

SELECT ENRLD_ANTHR_PTIP_RT_ID ENRLD_ANTHR_PTIP_RT_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
, VRBL_RT_PRFL_ID VRBL_RT_PRFL_ID
, BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, ENT_ATTRIBUTE_CATEGORY ENT_ATTRIBUTE_CATEGORY
, ENT_ATTRIBUTE1 ENT_ATTRIBUTE1
, ENT_ATTRIBUTE2 ENT_ATTRIBUTE2
, ENT_ATTRIBUTE3 ENT_ATTRIBUTE3
, ENT_ATTRIBUTE4 ENT_ATTRIBUTE4
, ENT_ATTRIBUTE5 ENT_ATTRIBUTE5
, ENT_ATTRIBUTE6 ENT_ATTRIBUTE6
, ENT_ATTRIBUTE7 ENT_ATTRIBUTE7
, ENT_ATTRIBUTE8 ENT_ATTRIBUTE8
, ENT_ATTRIBUTE9 ENT_ATTRIBUTE9
, ENT_ATTRIBUTE10 ENT_ATTRIBUTE10
, ENT_ATTRIBUTE11 ENT_ATTRIBUTE11
, ENT_ATTRIBUTE12 ENT_ATTRIBUTE12
, ENT_ATTRIBUTE13 ENT_ATTRIBUTE13
, ENT_ATTRIBUTE14 ENT_ATTRIBUTE14
, ENT_ATTRIBUTE15 ENT_ATTRIBUTE15
, ENT_ATTRIBUTE16 ENT_ATTRIBUTE16
, ENT_ATTRIBUTE17 ENT_ATTRIBUTE17
, ENT_ATTRIBUTE18 ENT_ATTRIBUTE18
, ENT_ATTRIBUTE19 ENT_ATTRIBUTE19
, ENT_ATTRIBUTE20 ENT_ATTRIBUTE20
, ENT_ATTRIBUTE21 ENT_ATTRIBUTE21
, ENT_ATTRIBUTE22 ENT_ATTRIBUTE22
, ENT_ATTRIBUTE23 ENT_ATTRIBUTE23
, ENT_ATTRIBUTE24 ENT_ATTRIBUTE24
, ENT_ATTRIBUTE25 ENT_ATTRIBUTE25
, ENT_ATTRIBUTE26 ENT_ATTRIBUTE26
, ENT_ATTRIBUTE27 ENT_ATTRIBUTE27
, ENT_ATTRIBUTE28 ENT_ATTRIBUTE28
, ENT_ATTRIBUTE29 ENT_ATTRIBUTE29
, ENT_ATTRIBUTE30 ENT_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_ENRLD_ANTHR_PTIP_RT_F"