DBA Data[Home] [Help]

VIEW: BEN.BEN_ELIG_DPNT_RBV#

Source

View Text - Preformatted

select DPNT_INELIG_FLAG DPNT_INELIG_FLAG, ELIG_DPNT_ID ELIG_DPNT_ID, CREATE_DT CREATE_DT, OVRDN_FLAG OVRDN_FLAG, DPNT_PERSON_ID DPNT_PERSON_ID, BUSINESS_GROUP_ID BUSINESS_GROUP_ID, EGD_ATTRIBUTE_CATEGORY EGD_ATTRIBUTE_CATEGORY, EGD_ATTRIBUTE1 EGD_ATTRIBUTE1, EGD_ATTRIBUTE2 EGD_ATTRIBUTE2, EGD_ATTRIBUTE3 EGD_ATTRIBUTE3, EGD_ATTRIBUTE4 EGD_ATTRIBUTE4, EGD_ATTRIBUTE5 EGD_ATTRIBUTE5, EGD_ATTRIBUTE6 EGD_ATTRIBUTE6, EGD_ATTRIBUTE7 EGD_ATTRIBUTE7, EGD_ATTRIBUTE8 EGD_ATTRIBUTE8, EGD_ATTRIBUTE9 EGD_ATTRIBUTE9, EGD_ATTRIBUTE10 EGD_ATTRIBUTE10, EGD_ATTRIBUTE11 EGD_ATTRIBUTE11, EGD_ATTRIBUTE12 EGD_ATTRIBUTE12, EGD_ATTRIBUTE13 EGD_ATTRIBUTE13, EGD_ATTRIBUTE14 EGD_ATTRIBUTE14, EGD_ATTRIBUTE15 EGD_ATTRIBUTE15, EGD_ATTRIBUTE16 EGD_ATTRIBUTE16, EGD_ATTRIBUTE17 EGD_ATTRIBUTE17, EGD_ATTRIBUTE18 EGD_ATTRIBUTE18, EGD_ATTRIBUTE19 EGD_ATTRIBUTE19, EGD_ATTRIBUTE20 EGD_ATTRIBUTE20, EGD_ATTRIBUTE21 EGD_ATTRIBUTE21, EGD_ATTRIBUTE22 EGD_ATTRIBUTE22, EGD_ATTRIBUTE23 EGD_ATTRIBUTE23, EGD_ATTRIBUTE24 EGD_ATTRIBUTE24, EGD_ATTRIBUTE25 EGD_ATTRIBUTE25, EGD_ATTRIBUTE26 EGD_ATTRIBUTE26, EGD_ATTRIBUTE27 EGD_ATTRIBUTE27, EGD_ATTRIBUTE28 EGD_ATTRIBUTE28, EGD_ATTRIBUTE29 EGD_ATTRIBUTE29, EGD_ATTRIBUTE30 EGD_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, REQUEST_ID REQUEST_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, ELIG_STRT_DT ELIG_STRT_DT, ELIG_THRU_DT ELIG_THRU_DT, OVRDN_THRU_DT OVRDN_THRU_DT, INELG_RSN_CD INELG_RSN_CD, ELIG_PER_ELCTBL_CHC_ID ELIG_PER_ELCTBL_CHC_ID, PER_IN_LER_ID PER_IN_LER_ID, ELIG_PER_ID ELIG_PER_ID, ELIG_PER_OPT_ID ELIG_PER_OPT_ID, ELIG_CVRD_DPNT_ID ELIG_CVRD_DPNT_ID, BENEFIT_ACTION_ID BENEFIT_ACTION_ID, PERSON_ACTION_ID PERSON_ACTION_ID from "BEN"."BEN_ELIG_DPNT_RBV"
View Text - HTML Formatted

SELECT DPNT_INELIG_FLAG DPNT_INELIG_FLAG
, ELIG_DPNT_ID ELIG_DPNT_ID
, CREATE_DT CREATE_DT
, OVRDN_FLAG OVRDN_FLAG
, DPNT_PERSON_ID DPNT_PERSON_ID
, BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, EGD_ATTRIBUTE_CATEGORY EGD_ATTRIBUTE_CATEGORY
, EGD_ATTRIBUTE1 EGD_ATTRIBUTE1
, EGD_ATTRIBUTE2 EGD_ATTRIBUTE2
, EGD_ATTRIBUTE3 EGD_ATTRIBUTE3
, EGD_ATTRIBUTE4 EGD_ATTRIBUTE4
, EGD_ATTRIBUTE5 EGD_ATTRIBUTE5
, EGD_ATTRIBUTE6 EGD_ATTRIBUTE6
, EGD_ATTRIBUTE7 EGD_ATTRIBUTE7
, EGD_ATTRIBUTE8 EGD_ATTRIBUTE8
, EGD_ATTRIBUTE9 EGD_ATTRIBUTE9
, EGD_ATTRIBUTE10 EGD_ATTRIBUTE10
, EGD_ATTRIBUTE11 EGD_ATTRIBUTE11
, EGD_ATTRIBUTE12 EGD_ATTRIBUTE12
, EGD_ATTRIBUTE13 EGD_ATTRIBUTE13
, EGD_ATTRIBUTE14 EGD_ATTRIBUTE14
, EGD_ATTRIBUTE15 EGD_ATTRIBUTE15
, EGD_ATTRIBUTE16 EGD_ATTRIBUTE16
, EGD_ATTRIBUTE17 EGD_ATTRIBUTE17
, EGD_ATTRIBUTE18 EGD_ATTRIBUTE18
, EGD_ATTRIBUTE19 EGD_ATTRIBUTE19
, EGD_ATTRIBUTE20 EGD_ATTRIBUTE20
, EGD_ATTRIBUTE21 EGD_ATTRIBUTE21
, EGD_ATTRIBUTE22 EGD_ATTRIBUTE22
, EGD_ATTRIBUTE23 EGD_ATTRIBUTE23
, EGD_ATTRIBUTE24 EGD_ATTRIBUTE24
, EGD_ATTRIBUTE25 EGD_ATTRIBUTE25
, EGD_ATTRIBUTE26 EGD_ATTRIBUTE26
, EGD_ATTRIBUTE27 EGD_ATTRIBUTE27
, EGD_ATTRIBUTE28 EGD_ATTRIBUTE28
, EGD_ATTRIBUTE29 EGD_ATTRIBUTE29
, EGD_ATTRIBUTE30 EGD_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
, REQUEST_ID REQUEST_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, ELIG_STRT_DT ELIG_STRT_DT
, ELIG_THRU_DT ELIG_THRU_DT
, OVRDN_THRU_DT OVRDN_THRU_DT
, INELG_RSN_CD INELG_RSN_CD
, ELIG_PER_ELCTBL_CHC_ID ELIG_PER_ELCTBL_CHC_ID
, PER_IN_LER_ID PER_IN_LER_ID
, ELIG_PER_ID ELIG_PER_ID
, ELIG_PER_OPT_ID ELIG_PER_OPT_ID
, ELIG_CVRD_DPNT_ID ELIG_CVRD_DPNT_ID
, BENEFIT_ACTION_ID BENEFIT_ACTION_ID
, PERSON_ACTION_ID PERSON_ACTION_ID
FROM "BEN"."BEN_ELIG_DPNT_RBV"