VIEW: BEN.BEN_PTIP_F#

Source

View Text - Preformatted

select PTIP_ID PTIP_ID, EFFECTIVE_START_DATE EFFECTIVE_START_DATE, EFFECTIVE_END_DATE EFFECTIVE_END_DATE, PTIP_STAT_CD PTIP_STAT_CD, COORD_CVG_FOR_ALL_PLS_FLAG COORD_CVG_FOR_ALL_PLS_FLAG, DPNT_CVG_NO_CTFN_RQD_FLAG DPNT_CVG_NO_CTFN_RQD_FLAG, DPNT_ADRS_RQD_FLAG DPNT_ADRS_RQD_FLAG, DPNT_LEGV_ID_RQD_FLAG DPNT_LEGV_ID_RQD_FLAG, DPNT_DOB_RQD_FLAG DPNT_DOB_RQD_FLAG, CRS_THIS_PL_TYP_ONLY_FLAG CRS_THIS_PL_TYP_ONLY_FLAG, NO_MX_PL_TYP_OVRID_FLAG NO_MX_PL_TYP_OVRID_FLAG, PRVDS_CR_FLAG PRVDS_CR_FLAG, WVBL_FLAG WVBL_FLAG, DRVD_FCTR_DPNT_CVG_FLAG DRVD_FCTR_DPNT_CVG_FLAG, NO_MN_PL_TYP_OVERID_FLAG NO_MN_PL_TYP_OVERID_FLAG, SBJ_TO_SPS_LF_INS_MX_FLAG SBJ_TO_SPS_LF_INS_MX_FLAG, SBJ_TO_DPNT_LF_INS_MX_FLAG SBJ_TO_DPNT_LF_INS_MX_FLAG, USE_TO_SUM_EE_LF_INS_FLAG USE_TO_SUM_EE_LF_INS_FLAG, PL_TYP_ID PL_TYP_ID, PGM_ID PGM_ID, BUSINESS_GROUP_ID BUSINESS_GROUP_ID, DRVBL_FCTR_APLS_RTS_FLAG DRVBL_FCTR_APLS_RTS_FLAG, DRVBL_FCTR_PRTN_ELIG_FLAG DRVBL_FCTR_PRTN_ELIG_FLAG, ELIG_APLS_FLAG ELIG_APLS_FLAG, PRTN_ELIG_OVRID_ALWD_FLAG PRTN_ELIG_OVRID_ALWD_FLAG, TRK_INELIG_PER_FLAG TRK_INELIG_PER_FLAG, CTP_ATTRIBUTE_CATEGORY CTP_ATTRIBUTE_CATEGORY, CTP_ATTRIBUTE1 CTP_ATTRIBUTE1, CTP_ATTRIBUTE2 CTP_ATTRIBUTE2, CTP_ATTRIBUTE3 CTP_ATTRIBUTE3, CTP_ATTRIBUTE4 CTP_ATTRIBUTE4, CTP_ATTRIBUTE5 CTP_ATTRIBUTE5, CTP_ATTRIBUTE6 CTP_ATTRIBUTE6, CTP_ATTRIBUTE7 CTP_ATTRIBUTE7, CTP_ATTRIBUTE8 CTP_ATTRIBUTE8, CTP_ATTRIBUTE9 CTP_ATTRIBUTE9, CTP_ATTRIBUTE10 CTP_ATTRIBUTE10, CTP_ATTRIBUTE11 CTP_ATTRIBUTE11, CTP_ATTRIBUTE12 CTP_ATTRIBUTE12, CTP_ATTRIBUTE13 CTP_ATTRIBUTE13, CTP_ATTRIBUTE14 CTP_ATTRIBUTE14, CTP_ATTRIBUTE15 CTP_ATTRIBUTE15, CTP_ATTRIBUTE16 CTP_ATTRIBUTE16, CTP_ATTRIBUTE17 CTP_ATTRIBUTE17, CTP_ATTRIBUTE18 CTP_ATTRIBUTE18, CTP_ATTRIBUTE19 CTP_ATTRIBUTE19, CTP_ATTRIBUTE20 CTP_ATTRIBUTE20, CTP_ATTRIBUTE21 CTP_ATTRIBUTE21, CTP_ATTRIBUTE22 CTP_ATTRIBUTE22, CTP_ATTRIBUTE23 CTP_ATTRIBUTE23, CTP_ATTRIBUTE24 CTP_ATTRIBUTE24, CTP_ATTRIBUTE25 CTP_ATTRIBUTE25, CTP_ATTRIBUTE26 CTP_ATTRIBUTE26, CTP_ATTRIBUTE27 CTP_ATTRIBUTE27, CTP_ATTRIBUTE28 CTP_ATTRIBUTE28, CTP_ATTRIBUTE29 CTP_ATTRIBUTE29, CTP_ATTRIBUTE30 CTP_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, DPNT_DSGN_CD DPNT_DSGN_CD, DPNT_CVG_STRT_DT_CD DPNT_CVG_STRT_DT_CD, DPNT_CVG_STRT_DT_RL DPNT_CVG_STRT_DT_RL, DPNT_CVG_END_DT_CD DPNT_CVG_END_DT_CD, DPNT_CVG_END_DT_RL DPNT_CVG_END_DT_RL, POSTELCN_EDIT_RL POSTELCN_EDIT_RL, MX_CVG_ALWD_AMT MX_CVG_ALWD_AMT, MN_ENRD_RQD_OVRID_NUM MN_ENRD_RQD_OVRID_NUM, MX_ENRD_ALWD_OVRID_NUM MX_ENRD_ALWD_OVRID_NUM, ORDR_NUM ORDR_NUM, RQD_PERD_ENRT_NENRT_VAL RQD_PERD_ENRT_NENRT_VAL, RQD_PERD_ENRT_NENRT_TM_UOM RQD_PERD_ENRT_NENRT_TM_UOM, IVR_IDENT IVR_IDENT, RQD_ENRT_PERD_TCO_CD RQD_ENRT_PERD_TCO_CD, RQD_PERD_ENRT_NENRT_RL RQD_PERD_ENRT_NENRT_RL, ENRT_CVG_STRT_DT_CD ENRT_CVG_STRT_DT_CD, ENRT_CVG_STRT_DT_RL ENRT_CVG_STRT_DT_RL, ENRT_CVG_END_DT_CD ENRT_CVG_END_DT_CD, ENRT_CVG_END_DT_RL ENRT_CVG_END_DT_RL, RT_STRT_DT_CD RT_STRT_DT_CD, RT_STRT_DT_RL RT_STRT_DT_RL, RT_END_DT_CD RT_END_DT_CD, RT_END_DT_RL RT_END_DT_RL, URL_REF_NAME URL_REF_NAME, ACRS_PTIP_CVG_ID ACRS_PTIP_CVG_ID, CMBN_PTIP_OPT_ID CMBN_PTIP_OPT_ID, CMBN_PTIP_ID CMBN_PTIP_ID, AUTO_ENRT_MTHD_RL AUTO_ENRT_MTHD_RL, ENRT_MTHD_CD ENRT_MTHD_CD, ENRT_CD ENRT_CD, ENRT_RL ENRT_RL, DFLT_ENRT_CD DFLT_ENRT_CD, DFLT_ENRT_DET_RL DFLT_ENRT_DET_RL, VRFY_FMLY_MMBR_CD VRFY_FMLY_MMBR_CD, VRFY_FMLY_MMBR_RL VRFY_FMLY_MMBR_RL, PER_CVRD_CD PER_CVRD_CD, SHORT_CODE SHORT_CODE, SHORT_NAME SHORT_NAME, LEGISLATION_CODE LEGISLATION_CODE, LEGISLATION_SUBGROUP LEGISLATION_SUBGROUP, SUSP_IF_DPNT_SSN_NT_PRV_CD SUSP_IF_DPNT_SSN_NT_PRV_CD, SUSP_IF_DPNT_DOB_NT_PRV_CD SUSP_IF_DPNT_DOB_NT_PRV_CD, SUSP_IF_DPNT_ADR_NT_PRV_CD SUSP_IF_DPNT_ADR_NT_PRV_CD, SUSP_IF_CTFN_NOT_DPNT_FLAG SUSP_IF_CTFN_NOT_DPNT_FLAG, DPNT_CTFN_DETERMINE_CD DPNT_CTFN_DETERMINE_CD, ALL_INELIG ALL_INELIG from "BEN"."BEN_PTIP_F"

View Text - HTML Formatted

SELECT PTIP_ID PTIP_ID
, EFFECTIVE_START_DATE EFFECTIVE_START_DATE
, EFFECTIVE_END_DATE EFFECTIVE_END_DATE
, PTIP_STAT_CD PTIP_STAT_CD
, COORD_CVG_FOR_ALL_PLS_FLAG COORD_CVG_FOR_ALL_PLS_FLAG
, DPNT_CVG_NO_CTFN_RQD_FLAG DPNT_CVG_NO_CTFN_RQD_FLAG
, DPNT_ADRS_RQD_FLAG DPNT_ADRS_RQD_FLAG
, DPNT_LEGV_ID_RQD_FLAG DPNT_LEGV_ID_RQD_FLAG
, DPNT_DOB_RQD_FLAG DPNT_DOB_RQD_FLAG
, CRS_THIS_PL_TYP_ONLY_FLAG CRS_THIS_PL_TYP_ONLY_FLAG
, NO_MX_PL_TYP_OVRID_FLAG NO_MX_PL_TYP_OVRID_FLAG
, PRVDS_CR_FLAG PRVDS_CR_FLAG
, WVBL_FLAG WVBL_FLAG
, DRVD_FCTR_DPNT_CVG_FLAG DRVD_FCTR_DPNT_CVG_FLAG
, NO_MN_PL_TYP_OVERID_FLAG NO_MN_PL_TYP_OVERID_FLAG
, SBJ_TO_SPS_LF_INS_MX_FLAG SBJ_TO_SPS_LF_INS_MX_FLAG
, SBJ_TO_DPNT_LF_INS_MX_FLAG SBJ_TO_DPNT_LF_INS_MX_FLAG
, USE_TO_SUM_EE_LF_INS_FLAG USE_TO_SUM_EE_LF_INS_FLAG
, PL_TYP_ID PL_TYP_ID
, PGM_ID PGM_ID
, BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, DRVBL_FCTR_APLS_RTS_FLAG DRVBL_FCTR_APLS_RTS_FLAG
, DRVBL_FCTR_PRTN_ELIG_FLAG DRVBL_FCTR_PRTN_ELIG_FLAG
, ELIG_APLS_FLAG ELIG_APLS_FLAG
, PRTN_ELIG_OVRID_ALWD_FLAG PRTN_ELIG_OVRID_ALWD_FLAG
, TRK_INELIG_PER_FLAG TRK_INELIG_PER_FLAG
, CTP_ATTRIBUTE_CATEGORY CTP_ATTRIBUTE_CATEGORY
, CTP_ATTRIBUTE1 CTP_ATTRIBUTE1
, CTP_ATTRIBUTE2 CTP_ATTRIBUTE2
, CTP_ATTRIBUTE3 CTP_ATTRIBUTE3
, CTP_ATTRIBUTE4 CTP_ATTRIBUTE4
, CTP_ATTRIBUTE5 CTP_ATTRIBUTE5
, CTP_ATTRIBUTE6 CTP_ATTRIBUTE6
, CTP_ATTRIBUTE7 CTP_ATTRIBUTE7
, CTP_ATTRIBUTE8 CTP_ATTRIBUTE8
, CTP_ATTRIBUTE9 CTP_ATTRIBUTE9
, CTP_ATTRIBUTE10 CTP_ATTRIBUTE10
, CTP_ATTRIBUTE11 CTP_ATTRIBUTE11
, CTP_ATTRIBUTE12 CTP_ATTRIBUTE12
, CTP_ATTRIBUTE13 CTP_ATTRIBUTE13
, CTP_ATTRIBUTE14 CTP_ATTRIBUTE14
, CTP_ATTRIBUTE15 CTP_ATTRIBUTE15
, CTP_ATTRIBUTE16 CTP_ATTRIBUTE16
, CTP_ATTRIBUTE17 CTP_ATTRIBUTE17
, CTP_ATTRIBUTE18 CTP_ATTRIBUTE18
, CTP_ATTRIBUTE19 CTP_ATTRIBUTE19
, CTP_ATTRIBUTE20 CTP_ATTRIBUTE20
, CTP_ATTRIBUTE21 CTP_ATTRIBUTE21
, CTP_ATTRIBUTE22 CTP_ATTRIBUTE22
, CTP_ATTRIBUTE23 CTP_ATTRIBUTE23
, CTP_ATTRIBUTE24 CTP_ATTRIBUTE24
, CTP_ATTRIBUTE25 CTP_ATTRIBUTE25
, CTP_ATTRIBUTE26 CTP_ATTRIBUTE26
, CTP_ATTRIBUTE27 CTP_ATTRIBUTE27
, CTP_ATTRIBUTE28 CTP_ATTRIBUTE28
, CTP_ATTRIBUTE29 CTP_ATTRIBUTE29
, CTP_ATTRIBUTE30 CTP_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
, DPNT_DSGN_CD DPNT_DSGN_CD
, DPNT_CVG_STRT_DT_CD DPNT_CVG_STRT_DT_CD
, DPNT_CVG_STRT_DT_RL DPNT_CVG_STRT_DT_RL
, DPNT_CVG_END_DT_CD DPNT_CVG_END_DT_CD
, DPNT_CVG_END_DT_RL DPNT_CVG_END_DT_RL
, POSTELCN_EDIT_RL POSTELCN_EDIT_RL
, MX_CVG_ALWD_AMT MX_CVG_ALWD_AMT
, MN_ENRD_RQD_OVRID_NUM MN_ENRD_RQD_OVRID_NUM
, MX_ENRD_ALWD_OVRID_NUM MX_ENRD_ALWD_OVRID_NUM
, ORDR_NUM ORDR_NUM
, RQD_PERD_ENRT_NENRT_VAL RQD_PERD_ENRT_NENRT_VAL
, RQD_PERD_ENRT_NENRT_TM_UOM RQD_PERD_ENRT_NENRT_TM_UOM
, IVR_IDENT IVR_IDENT
, RQD_ENRT_PERD_TCO_CD RQD_ENRT_PERD_TCO_CD
, RQD_PERD_ENRT_NENRT_RL RQD_PERD_ENRT_NENRT_RL
, ENRT_CVG_STRT_DT_CD ENRT_CVG_STRT_DT_CD
, ENRT_CVG_STRT_DT_RL ENRT_CVG_STRT_DT_RL
, ENRT_CVG_END_DT_CD ENRT_CVG_END_DT_CD
, ENRT_CVG_END_DT_RL ENRT_CVG_END_DT_RL
, RT_STRT_DT_CD RT_STRT_DT_CD
, RT_STRT_DT_RL RT_STRT_DT_RL
, RT_END_DT_CD RT_END_DT_CD
, RT_END_DT_RL RT_END_DT_RL
, URL_REF_NAME URL_REF_NAME
, ACRS_PTIP_CVG_ID ACRS_PTIP_CVG_ID
, CMBN_PTIP_OPT_ID CMBN_PTIP_OPT_ID
, CMBN_PTIP_ID CMBN_PTIP_ID
, AUTO_ENRT_MTHD_RL AUTO_ENRT_MTHD_RL
, ENRT_MTHD_CD ENRT_MTHD_CD
, ENRT_CD ENRT_CD
, ENRT_RL ENRT_RL
, DFLT_ENRT_CD DFLT_ENRT_CD
, DFLT_ENRT_DET_RL DFLT_ENRT_DET_RL
, VRFY_FMLY_MMBR_CD VRFY_FMLY_MMBR_CD
, VRFY_FMLY_MMBR_RL VRFY_FMLY_MMBR_RL
, PER_CVRD_CD PER_CVRD_CD
, SHORT_CODE SHORT_CODE
, SHORT_NAME SHORT_NAME
, LEGISLATION_CODE LEGISLATION_CODE
, LEGISLATION_SUBGROUP LEGISLATION_SUBGROUP
, SUSP_IF_DPNT_SSN_NT_PRV_CD SUSP_IF_DPNT_SSN_NT_PRV_CD
, SUSP_IF_DPNT_DOB_NT_PRV_CD SUSP_IF_DPNT_DOB_NT_PRV_CD
, SUSP_IF_DPNT_ADR_NT_PRV_CD SUSP_IF_DPNT_ADR_NT_PRV_CD
, SUSP_IF_CTFN_NOT_DPNT_FLAG SUSP_IF_CTFN_NOT_DPNT_FLAG
, DPNT_CTFN_DETERMINE_CD DPNT_CTFN_DETERMINE_CD
, ALL_INELIG ALL_INELIG
FROM "BEN"."BEN_PTIP_F"