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_ELIG_DPNT_CVRD_OTHR_PTIP_D

Product:	BEN - Advanced Benefits
Description:
Implementation/DBA Data:	APPS.BEN_ELIG_DPNT_CVRD_OTHR_PTIP_D

View Text

SELECT EDT.ELIG_DPNT_CVRD_OTHR_PTIP_ID
, EDT.EFFECTIVE_START_DATE
, EDT.EFFECTIVE_END_DATE
, EDT.EXCLD_FLAG
, EDT.ORDR_NUM
, EDT.ENRL_DET_DT_CD
, EDT.ONLY_PLS_SUBJ_COBRA_FLAG
, EDT.PTIP_ID
, EDT.ELIGY_PRFL_ID
, EDT.BUSINESS_GROUP_ID
, EDT.EDT_ATTRIBUTE_CATEGORY
, EDT.EDT_ATTRIBUTE1
, EDT.EDT_ATTRIBUTE2
, EDT.EDT_ATTRIBUTE3
, EDT.EDT_ATTRIBUTE4
, EDT.EDT_ATTRIBUTE5
, EDT.EDT_ATTRIBUTE6
, EDT.EDT_ATTRIBUTE7
, EDT.EDT_ATTRIBUTE8
, EDT.EDT_ATTRIBUTE9
, EDT.EDT_ATTRIBUTE10
, EDT.EDT_ATTRIBUTE11
, EDT.EDT_ATTRIBUTE12
, EDT.EDT_ATTRIBUTE13
, EDT.EDT_ATTRIBUTE14
, EDT.EDT_ATTRIBUTE15
, EDT.EDT_ATTRIBUTE16
, EDT.LAST_UPDATE_DATE
, EDT.LAST_UPDATED_BY
, EDT.LAST_UPDATE_LOGIN
, EDT.CREATED_BY
, EDT.CREATION_DATE
, EDT.OBJECT_VERSION_NUMBER
FROM BEN_ELIG_DPNT_CVRD_OTHR_PTIP_F EDT

Columns

Name
ELIG_DPNT_CVRD_OTHR_PTIP_ID
EFFECTIVE_START_DATE
EFFECTIVE_END_DATE
EXCLD_FLAG
ORDR_NUM
ENRL_DET_DT_CD
ONLY_PLS_SUBJ_COBRA_FLAG
PTIP_ID
ELIGY_PRFL_ID
BUSINESS_GROUP_ID
EDT_ATTRIBUTE_CATEGORY
EDT_ATTRIBUTE1
EDT_ATTRIBUTE2
EDT_ATTRIBUTE3
EDT_ATTRIBUTE4
EDT_ATTRIBUTE5
EDT_ATTRIBUTE6
EDT_ATTRIBUTE7
EDT_ATTRIBUTE8
EDT_ATTRIBUTE9
EDT_ATTRIBUTE10
EDT_ATTRIBUTE11
EDT_ATTRIBUTE12
EDT_ATTRIBUTE13
EDT_ATTRIBUTE14
EDT_ATTRIBUTE15
EDT_ATTRIBUTE16
LAST_UPDATE_DATE
LAST_UPDATED_BY
LAST_UPDATE_LOGIN
CREATED_BY
CREATION_DATE
OBJECT_VERSION_NUMBER