VIEW: BEN.BEN_PRTT_ENRT_RSLT_F#

Source

View Text - Preformatted

select PRTT_ENRT_RSLT_ID PRTT_ENRT_RSLT_ID, EFFECTIVE_START_DATE EFFECTIVE_START_DATE, EFFECTIVE_END_DATE EFFECTIVE_END_DATE, ENRT_CVG_STRT_DT ENRT_CVG_STRT_DT, ENRT_CVG_THRU_DT ENRT_CVG_THRU_DT, SSPNDD_FLAG SSPNDD_FLAG, PRTT_IS_CVRD_FLAG PRTT_IS_CVRD_FLAG, ENRT_MTHD_CD ENRT_MTHD_CD, ENRT_OVRIDN_FLAG ENRT_OVRIDN_FLAG, NO_LNGR_ELIG_FLAG NO_LNGR_ELIG_FLAG, PERSON_ID PERSON_ID, PL_ID PL_ID, LER_ID LER_ID, BUSINESS_GROUP_ID BUSINESS_GROUP_ID, PL_ORDR_NUM PL_ORDR_NUM, PLIP_ORDR_NUM PLIP_ORDR_NUM, PTIP_ORDR_NUM PTIP_ORDR_NUM, OIPL_ORDR_NUM OIPL_ORDR_NUM, PEN_ATTRIBUTE_CATEGORY PEN_ATTRIBUTE_CATEGORY, PEN_ATTRIBUTE1 PEN_ATTRIBUTE1, PEN_ATTRIBUTE2 PEN_ATTRIBUTE2, PEN_ATTRIBUTE3 PEN_ATTRIBUTE3, PEN_ATTRIBUTE4 PEN_ATTRIBUTE4, PEN_ATTRIBUTE5 PEN_ATTRIBUTE5, PEN_ATTRIBUTE6 PEN_ATTRIBUTE6, PEN_ATTRIBUTE7 PEN_ATTRIBUTE7, PEN_ATTRIBUTE8 PEN_ATTRIBUTE8, PEN_ATTRIBUTE9 PEN_ATTRIBUTE9, PEN_ATTRIBUTE10 PEN_ATTRIBUTE10, PEN_ATTRIBUTE11 PEN_ATTRIBUTE11, PEN_ATTRIBUTE12 PEN_ATTRIBUTE12, PEN_ATTRIBUTE13 PEN_ATTRIBUTE13, PEN_ATTRIBUTE14 PEN_ATTRIBUTE14, PEN_ATTRIBUTE15 PEN_ATTRIBUTE15, PEN_ATTRIBUTE16 PEN_ATTRIBUTE16, PEN_ATTRIBUTE17 PEN_ATTRIBUTE17, PEN_ATTRIBUTE18 PEN_ATTRIBUTE18, PEN_ATTRIBUTE19 PEN_ATTRIBUTE19, PEN_ATTRIBUTE20 PEN_ATTRIBUTE20, PEN_ATTRIBUTE21 PEN_ATTRIBUTE21, PEN_ATTRIBUTE22 PEN_ATTRIBUTE22, PEN_ATTRIBUTE23 PEN_ATTRIBUTE23, PEN_ATTRIBUTE24 PEN_ATTRIBUTE24, PEN_ATTRIBUTE25 PEN_ATTRIBUTE25, PEN_ATTRIBUTE26 PEN_ATTRIBUTE26, PEN_ATTRIBUTE27 PEN_ATTRIBUTE27, PEN_ATTRIBUTE28 PEN_ATTRIBUTE28, PEN_ATTRIBUTE29 PEN_ATTRIBUTE29, PEN_ATTRIBUTE30 PEN_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, BNFT_AMT BNFT_AMT, BNFT_NNMNTRY_UOM BNFT_NNMNTRY_UOM, BNFT_TYP_CD BNFT_TYP_CD, UOM UOM, ORGNL_ENRT_DT ORGNL_ENRT_DT, ENRT_OVRID_RSN_CD ENRT_OVRID_RSN_CD, ERLST_DEENRT_DT ERLST_DEENRT_DT, ENRT_OVRID_THRU_DT ENRT_OVRID_THRU_DT, BNFT_ORDR_NUM BNFT_ORDR_NUM, PRTT_ENRT_RSLT_STAT_CD PRTT_ENRT_RSLT_STAT_CD, COMP_LVL_CD COMP_LVL_CD, PGM_ID PGM_ID, PL_TYP_ID PL_TYP_ID, OIPL_ID OIPL_ID, PTIP_ID PTIP_ID, PER_IN_LER_ID PER_IN_LER_ID, ASSIGNMENT_ID ASSIGNMENT_ID, RPLCS_SSPNDD_RSLT_ID RPLCS_SSPNDD_RSLT_ID from "BEN"."BEN_PRTT_ENRT_RSLT_F"

View Text - HTML Formatted

SELECT PRTT_ENRT_RSLT_ID PRTT_ENRT_RSLT_ID
, EFFECTIVE_START_DATE EFFECTIVE_START_DATE
, EFFECTIVE_END_DATE EFFECTIVE_END_DATE
, ENRT_CVG_STRT_DT ENRT_CVG_STRT_DT
, ENRT_CVG_THRU_DT ENRT_CVG_THRU_DT
, SSPNDD_FLAG SSPNDD_FLAG
, PRTT_IS_CVRD_FLAG PRTT_IS_CVRD_FLAG
, ENRT_MTHD_CD ENRT_MTHD_CD
, ENRT_OVRIDN_FLAG ENRT_OVRIDN_FLAG
, NO_LNGR_ELIG_FLAG NO_LNGR_ELIG_FLAG
, PERSON_ID PERSON_ID
, PL_ID PL_ID
, LER_ID LER_ID
, BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, PL_ORDR_NUM PL_ORDR_NUM
, PLIP_ORDR_NUM PLIP_ORDR_NUM
, PTIP_ORDR_NUM PTIP_ORDR_NUM
, OIPL_ORDR_NUM OIPL_ORDR_NUM
, PEN_ATTRIBUTE_CATEGORY PEN_ATTRIBUTE_CATEGORY
, PEN_ATTRIBUTE1 PEN_ATTRIBUTE1
, PEN_ATTRIBUTE2 PEN_ATTRIBUTE2
, PEN_ATTRIBUTE3 PEN_ATTRIBUTE3
, PEN_ATTRIBUTE4 PEN_ATTRIBUTE4
, PEN_ATTRIBUTE5 PEN_ATTRIBUTE5
, PEN_ATTRIBUTE6 PEN_ATTRIBUTE6
, PEN_ATTRIBUTE7 PEN_ATTRIBUTE7
, PEN_ATTRIBUTE8 PEN_ATTRIBUTE8
, PEN_ATTRIBUTE9 PEN_ATTRIBUTE9
, PEN_ATTRIBUTE10 PEN_ATTRIBUTE10
, PEN_ATTRIBUTE11 PEN_ATTRIBUTE11
, PEN_ATTRIBUTE12 PEN_ATTRIBUTE12
, PEN_ATTRIBUTE13 PEN_ATTRIBUTE13
, PEN_ATTRIBUTE14 PEN_ATTRIBUTE14
, PEN_ATTRIBUTE15 PEN_ATTRIBUTE15
, PEN_ATTRIBUTE16 PEN_ATTRIBUTE16
, PEN_ATTRIBUTE17 PEN_ATTRIBUTE17
, PEN_ATTRIBUTE18 PEN_ATTRIBUTE18
, PEN_ATTRIBUTE19 PEN_ATTRIBUTE19
, PEN_ATTRIBUTE20 PEN_ATTRIBUTE20
, PEN_ATTRIBUTE21 PEN_ATTRIBUTE21
, PEN_ATTRIBUTE22 PEN_ATTRIBUTE22
, PEN_ATTRIBUTE23 PEN_ATTRIBUTE23
, PEN_ATTRIBUTE24 PEN_ATTRIBUTE24
, PEN_ATTRIBUTE25 PEN_ATTRIBUTE25
, PEN_ATTRIBUTE26 PEN_ATTRIBUTE26
, PEN_ATTRIBUTE27 PEN_ATTRIBUTE27
, PEN_ATTRIBUTE28 PEN_ATTRIBUTE28
, PEN_ATTRIBUTE29 PEN_ATTRIBUTE29
, PEN_ATTRIBUTE30 PEN_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
, BNFT_AMT BNFT_AMT
, BNFT_NNMNTRY_UOM BNFT_NNMNTRY_UOM
, BNFT_TYP_CD BNFT_TYP_CD
, UOM UOM
, ORGNL_ENRT_DT ORGNL_ENRT_DT
, ENRT_OVRID_RSN_CD ENRT_OVRID_RSN_CD
, ERLST_DEENRT_DT ERLST_DEENRT_DT
, ENRT_OVRID_THRU_DT ENRT_OVRID_THRU_DT
, BNFT_ORDR_NUM BNFT_ORDR_NUM
, PRTT_ENRT_RSLT_STAT_CD PRTT_ENRT_RSLT_STAT_CD
, COMP_LVL_CD COMP_LVL_CD
, PGM_ID PGM_ID
, PL_TYP_ID PL_TYP_ID
, OIPL_ID OIPL_ID
, PTIP_ID PTIP_ID
, PER_IN_LER_ID PER_IN_LER_ID
, ASSIGNMENT_ID ASSIGNMENT_ID
, RPLCS_SSPNDD_RSLT_ID RPLCS_SSPNDD_RSLT_ID
FROM "BEN"."BEN_PRTT_ENRT_RSLT_F"