VIEW: BEN.BEN_OIPL_F#

Source

View Text - Preformatted

select OIPL_ID OIPL_ID, EFFECTIVE_START_DATE EFFECTIVE_START_DATE, EFFECTIVE_END_DATE EFFECTIVE_END_DATE, MNDTRY_FLAG MNDTRY_FLAG, DFLT_FLAG DFLT_FLAG, OIPL_STAT_CD OIPL_STAT_CD, ELIG_APLS_FLAG ELIG_APLS_FLAG, TRK_INELIG_PER_FLAG TRK_INELIG_PER_FLAG, DRVBL_FCTR_PRTN_ELIG_FLAG DRVBL_FCTR_PRTN_ELIG_FLAG, PRTN_ELIG_OVRID_ALWD_FLAG PRTN_ELIG_OVRID_ALWD_FLAG, DRVBL_FCTR_APLS_RTS_FLAG DRVBL_FCTR_APLS_RTS_FLAG, AUTO_ENRT_FLAG AUTO_ENRT_FLAG, PL_ID PL_ID, OPT_ID OPT_ID, BUSINESS_GROUP_ID BUSINESS_GROUP_ID, COP_ATTRIBUTE_CATEGORY COP_ATTRIBUTE_CATEGORY, COP_ATTRIBUTE1 COP_ATTRIBUTE1, COP_ATTRIBUTE2 COP_ATTRIBUTE2, COP_ATTRIBUTE3 COP_ATTRIBUTE3, COP_ATTRIBUTE4 COP_ATTRIBUTE4, COP_ATTRIBUTE5 COP_ATTRIBUTE5, COP_ATTRIBUTE6 COP_ATTRIBUTE6, COP_ATTRIBUTE7 COP_ATTRIBUTE7, COP_ATTRIBUTE8 COP_ATTRIBUTE8, COP_ATTRIBUTE9 COP_ATTRIBUTE9, COP_ATTRIBUTE10 COP_ATTRIBUTE10, COP_ATTRIBUTE11 COP_ATTRIBUTE11, COP_ATTRIBUTE12 COP_ATTRIBUTE12, COP_ATTRIBUTE13 COP_ATTRIBUTE13, COP_ATTRIBUTE14 COP_ATTRIBUTE14, COP_ATTRIBUTE15 COP_ATTRIBUTE15, COP_ATTRIBUTE16 COP_ATTRIBUTE16, COP_ATTRIBUTE17 COP_ATTRIBUTE17, COP_ATTRIBUTE18 COP_ATTRIBUTE18, COP_ATTRIBUTE19 COP_ATTRIBUTE19, COP_ATTRIBUTE20 COP_ATTRIBUTE20, COP_ATTRIBUTE21 COP_ATTRIBUTE21, COP_ATTRIBUTE22 COP_ATTRIBUTE22, COP_ATTRIBUTE23 COP_ATTRIBUTE23, COP_ATTRIBUTE24 COP_ATTRIBUTE24, COP_ATTRIBUTE25 COP_ATTRIBUTE25, COP_ATTRIBUTE26 COP_ATTRIBUTE26, COP_ATTRIBUTE27 COP_ATTRIBUTE27, COP_ATTRIBUTE28 COP_ATTRIBUTE28, COP_ATTRIBUTE29 COP_ATTRIBUTE29, COP_ATTRIBUTE30 COP_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, IVR_IDENT IVR_IDENT, ORDR_NUM ORDR_NUM, DFLT_ENRT_CD DFLT_ENRT_CD, PER_CVRD_CD PER_CVRD_CD, VRFY_FMLY_MMBR_CD VRFY_FMLY_MMBR_CD, AUTO_ENRT_MTHD_RL AUTO_ENRT_MTHD_RL, DFLT_ENRT_DET_RL DFLT_ENRT_DET_RL, RQD_PERD_ENRT_NENRT_UOM RQD_PERD_ENRT_NENRT_UOM, RQD_PERD_ENRT_NENRT_VAL RQD_PERD_ENRT_NENRT_VAL, RQD_PERD_ENRT_NENRT_RL RQD_PERD_ENRT_NENRT_RL, MNDTRY_RL MNDTRY_RL, POSTELCN_EDIT_RL POSTELCN_EDIT_RL, VRFY_FMLY_MMBR_RL VRFY_FMLY_MMBR_RL, URL_REF_NAME URL_REF_NAME, ENRT_CD ENRT_CD, ENRT_RL ENRT_RL, ACTL_PREM_ID ACTL_PREM_ID, PCP_DSGN_CD PCP_DSGN_CD, PCP_DPNT_DSGN_CD PCP_DPNT_DSGN_CD, SHORT_CODE SHORT_CODE, SHORT_NAME SHORT_NAME, HIDDEN_FLAG HIDDEN_FLAG, LEGISLATION_CODE LEGISLATION_CODE, LEGISLATION_SUBGROUP LEGISLATION_SUBGROUP, SUSP_IF_CTFN_NOT_PRVD_FLAG SUSP_IF_CTFN_NOT_PRVD_FLAG, CTFN_DETERMINE_CD CTFN_DETERMINE_CD, ALL_INELIG ALL_INELIG from "BEN"."BEN_OIPL_F"

View Text - HTML Formatted

SELECT OIPL_ID OIPL_ID
, EFFECTIVE_START_DATE EFFECTIVE_START_DATE
, EFFECTIVE_END_DATE EFFECTIVE_END_DATE
, MNDTRY_FLAG MNDTRY_FLAG
, DFLT_FLAG DFLT_FLAG
, OIPL_STAT_CD OIPL_STAT_CD
, ELIG_APLS_FLAG ELIG_APLS_FLAG
, TRK_INELIG_PER_FLAG TRK_INELIG_PER_FLAG
, DRVBL_FCTR_PRTN_ELIG_FLAG DRVBL_FCTR_PRTN_ELIG_FLAG
, PRTN_ELIG_OVRID_ALWD_FLAG PRTN_ELIG_OVRID_ALWD_FLAG
, DRVBL_FCTR_APLS_RTS_FLAG DRVBL_FCTR_APLS_RTS_FLAG
, AUTO_ENRT_FLAG AUTO_ENRT_FLAG
, PL_ID PL_ID
, OPT_ID OPT_ID
, BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, COP_ATTRIBUTE_CATEGORY COP_ATTRIBUTE_CATEGORY
, COP_ATTRIBUTE1 COP_ATTRIBUTE1
, COP_ATTRIBUTE2 COP_ATTRIBUTE2
, COP_ATTRIBUTE3 COP_ATTRIBUTE3
, COP_ATTRIBUTE4 COP_ATTRIBUTE4
, COP_ATTRIBUTE5 COP_ATTRIBUTE5
, COP_ATTRIBUTE6 COP_ATTRIBUTE6
, COP_ATTRIBUTE7 COP_ATTRIBUTE7
, COP_ATTRIBUTE8 COP_ATTRIBUTE8
, COP_ATTRIBUTE9 COP_ATTRIBUTE9
, COP_ATTRIBUTE10 COP_ATTRIBUTE10
, COP_ATTRIBUTE11 COP_ATTRIBUTE11
, COP_ATTRIBUTE12 COP_ATTRIBUTE12
, COP_ATTRIBUTE13 COP_ATTRIBUTE13
, COP_ATTRIBUTE14 COP_ATTRIBUTE14
, COP_ATTRIBUTE15 COP_ATTRIBUTE15
, COP_ATTRIBUTE16 COP_ATTRIBUTE16
, COP_ATTRIBUTE17 COP_ATTRIBUTE17
, COP_ATTRIBUTE18 COP_ATTRIBUTE18
, COP_ATTRIBUTE19 COP_ATTRIBUTE19
, COP_ATTRIBUTE20 COP_ATTRIBUTE20
, COP_ATTRIBUTE21 COP_ATTRIBUTE21
, COP_ATTRIBUTE22 COP_ATTRIBUTE22
, COP_ATTRIBUTE23 COP_ATTRIBUTE23
, COP_ATTRIBUTE24 COP_ATTRIBUTE24
, COP_ATTRIBUTE25 COP_ATTRIBUTE25
, COP_ATTRIBUTE26 COP_ATTRIBUTE26
, COP_ATTRIBUTE27 COP_ATTRIBUTE27
, COP_ATTRIBUTE28 COP_ATTRIBUTE28
, COP_ATTRIBUTE29 COP_ATTRIBUTE29
, COP_ATTRIBUTE30 COP_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
, IVR_IDENT IVR_IDENT
, ORDR_NUM ORDR_NUM
, DFLT_ENRT_CD DFLT_ENRT_CD
, PER_CVRD_CD PER_CVRD_CD
, VRFY_FMLY_MMBR_CD VRFY_FMLY_MMBR_CD
, AUTO_ENRT_MTHD_RL AUTO_ENRT_MTHD_RL
, DFLT_ENRT_DET_RL DFLT_ENRT_DET_RL
, RQD_PERD_ENRT_NENRT_UOM RQD_PERD_ENRT_NENRT_UOM
, RQD_PERD_ENRT_NENRT_VAL RQD_PERD_ENRT_NENRT_VAL
, RQD_PERD_ENRT_NENRT_RL RQD_PERD_ENRT_NENRT_RL
, MNDTRY_RL MNDTRY_RL
, POSTELCN_EDIT_RL POSTELCN_EDIT_RL
, VRFY_FMLY_MMBR_RL VRFY_FMLY_MMBR_RL
, URL_REF_NAME URL_REF_NAME
, ENRT_CD ENRT_CD
, ENRT_RL ENRT_RL
, ACTL_PREM_ID ACTL_PREM_ID
, PCP_DSGN_CD PCP_DSGN_CD
, PCP_DPNT_DSGN_CD PCP_DPNT_DSGN_CD
, SHORT_CODE SHORT_CODE
, SHORT_NAME SHORT_NAME
, HIDDEN_FLAG HIDDEN_FLAG
, LEGISLATION_CODE LEGISLATION_CODE
, LEGISLATION_SUBGROUP LEGISLATION_SUBGROUP
, SUSP_IF_CTFN_NOT_PRVD_FLAG SUSP_IF_CTFN_NOT_PRVD_FLAG
, CTFN_DETERMINE_CD CTFN_DETERMINE_CD
, ALL_INELIG ALL_INELIG
FROM "BEN"."BEN_OIPL_F"