VIEW: BEN.BEN_PIL_ELCTBL_CHC_POPL#

Source

View Text - Preformatted

select PIL_ELCTBL_CHC_POPL_ID PIL_ELCTBL_CHC_POPL_ID, PER_IN_LER_ID PER_IN_LER_ID, PGM_ID PGM_ID, CBR_ELIG_PERD_STRT_DT CBR_ELIG_PERD_STRT_DT, CBR_ELIG_PERD_END_DT CBR_ELIG_PERD_END_DT, PEL_ATTRIBUTE_CATEGORY PEL_ATTRIBUTE_CATEGORY, PEL_ATTRIBUTE1 PEL_ATTRIBUTE1, PEL_ATTRIBUTE2 PEL_ATTRIBUTE2, PEL_ATTRIBUTE3 PEL_ATTRIBUTE3, PEL_ATTRIBUTE4 PEL_ATTRIBUTE4, PEL_ATTRIBUTE5 PEL_ATTRIBUTE5, PEL_ATTRIBUTE6 PEL_ATTRIBUTE6, PEL_ATTRIBUTE7 PEL_ATTRIBUTE7, PEL_ATTRIBUTE8 PEL_ATTRIBUTE8, PEL_ATTRIBUTE9 PEL_ATTRIBUTE9, PEL_ATTRIBUTE10 PEL_ATTRIBUTE10, PEL_ATTRIBUTE11 PEL_ATTRIBUTE11, PEL_ATTRIBUTE12 PEL_ATTRIBUTE12, PEL_ATTRIBUTE13 PEL_ATTRIBUTE13, PEL_ATTRIBUTE14 PEL_ATTRIBUTE14, PEL_ATTRIBUTE15 PEL_ATTRIBUTE15, PEL_ATTRIBUTE16 PEL_ATTRIBUTE16, PEL_ATTRIBUTE17 PEL_ATTRIBUTE17, PEL_ATTRIBUTE18 PEL_ATTRIBUTE18, PEL_ATTRIBUTE19 PEL_ATTRIBUTE19, PEL_ATTRIBUTE20 PEL_ATTRIBUTE20, PEL_ATTRIBUTE21 PEL_ATTRIBUTE21, PEL_ATTRIBUTE22 PEL_ATTRIBUTE22, PEL_ATTRIBUTE23 PEL_ATTRIBUTE23, PEL_ATTRIBUTE24 PEL_ATTRIBUTE24, PEL_ATTRIBUTE25 PEL_ATTRIBUTE25, PEL_ATTRIBUTE26 PEL_ATTRIBUTE26, PEL_ATTRIBUTE27 PEL_ATTRIBUTE27, PEL_ATTRIBUTE28 PEL_ATTRIBUTE28, PEL_ATTRIBUTE29 PEL_ATTRIBUTE29, PEL_ATTRIBUTE30 PEL_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, BUSINESS_GROUP_ID BUSINESS_GROUP_ID, DFLT_ENRT_DT DFLT_ENRT_DT, DFLT_ASND_DT DFLT_ASND_DT, ELCNS_MADE_DT ELCNS_MADE_DT, CLS_ENRT_DT_TO_USE_CD CLS_ENRT_DT_TO_USE_CD, ENRT_TYP_CYCL_CD ENRT_TYP_CYCL_CD, ENRT_PERD_END_DT ENRT_PERD_END_DT, ENRT_PERD_STRT_DT ENRT_PERD_STRT_DT, PROCG_END_DT PROCG_END_DT, PIL_ELCTBL_POPL_STAT_CD PIL_ELCTBL_POPL_STAT_CD, ACTY_REF_PERD_CD ACTY_REF_PERD_CD, UOM UOM, AUTO_ASND_DT AUTO_ASND_DT, ENRT_PERD_ID ENRT_PERD_ID, LEE_RSN_ID LEE_RSN_ID, PL_ID PL_ID, BDGT_ACC_CD BDGT_ACC_CD, POP_CD POP_CD, BDGT_DUE_DT BDGT_DUE_DT, BDGT_EXPORT_FLAG BDGT_EXPORT_FLAG, BDGT_ISS_DT BDGT_ISS_DT, BDGT_STAT_CD BDGT_STAT_CD, WS_ACC_CD WS_ACC_CD, WS_DUE_DT WS_DUE_DT, WS_EXPORT_FLAG WS_EXPORT_FLAG, WS_ISS_DT WS_ISS_DT, WS_STAT_CD WS_STAT_CD, ASSIGNMENT_ID ASSIGNMENT_ID, COMMENTS COMMENTS, MGR_OVRID_PERSON_ID MGR_OVRID_PERSON_ID, WS_MGR_ID WS_MGR_ID, MGR_OVRID_DT MGR_OVRID_DT, REINSTATE_CD REINSTATE_CD, REINSTATE_OVRDN_CD REINSTATE_OVRDN_CD, DEFER_DEENROL_FLAG DEFER_DEENROL_FLAG, DEENROL_MADE_DT DEENROL_MADE_DT, REOPEN_LE_ON_REPROCESS REOPEN_LE_ON_REPROCESS from "BEN"."BEN_PIL_ELCTBL_CHC_POPL"

View Text - HTML Formatted

SELECT PIL_ELCTBL_CHC_POPL_ID PIL_ELCTBL_CHC_POPL_ID
, PER_IN_LER_ID PER_IN_LER_ID
, PGM_ID PGM_ID
, CBR_ELIG_PERD_STRT_DT CBR_ELIG_PERD_STRT_DT
, CBR_ELIG_PERD_END_DT CBR_ELIG_PERD_END_DT
, PEL_ATTRIBUTE_CATEGORY PEL_ATTRIBUTE_CATEGORY
, PEL_ATTRIBUTE1 PEL_ATTRIBUTE1
, PEL_ATTRIBUTE2 PEL_ATTRIBUTE2
, PEL_ATTRIBUTE3 PEL_ATTRIBUTE3
, PEL_ATTRIBUTE4 PEL_ATTRIBUTE4
, PEL_ATTRIBUTE5 PEL_ATTRIBUTE5
, PEL_ATTRIBUTE6 PEL_ATTRIBUTE6
, PEL_ATTRIBUTE7 PEL_ATTRIBUTE7
, PEL_ATTRIBUTE8 PEL_ATTRIBUTE8
, PEL_ATTRIBUTE9 PEL_ATTRIBUTE9
, PEL_ATTRIBUTE10 PEL_ATTRIBUTE10
, PEL_ATTRIBUTE11 PEL_ATTRIBUTE11
, PEL_ATTRIBUTE12 PEL_ATTRIBUTE12
, PEL_ATTRIBUTE13 PEL_ATTRIBUTE13
, PEL_ATTRIBUTE14 PEL_ATTRIBUTE14
, PEL_ATTRIBUTE15 PEL_ATTRIBUTE15
, PEL_ATTRIBUTE16 PEL_ATTRIBUTE16
, PEL_ATTRIBUTE17 PEL_ATTRIBUTE17
, PEL_ATTRIBUTE18 PEL_ATTRIBUTE18
, PEL_ATTRIBUTE19 PEL_ATTRIBUTE19
, PEL_ATTRIBUTE20 PEL_ATTRIBUTE20
, PEL_ATTRIBUTE21 PEL_ATTRIBUTE21
, PEL_ATTRIBUTE22 PEL_ATTRIBUTE22
, PEL_ATTRIBUTE23 PEL_ATTRIBUTE23
, PEL_ATTRIBUTE24 PEL_ATTRIBUTE24
, PEL_ATTRIBUTE25 PEL_ATTRIBUTE25
, PEL_ATTRIBUTE26 PEL_ATTRIBUTE26
, PEL_ATTRIBUTE27 PEL_ATTRIBUTE27
, PEL_ATTRIBUTE28 PEL_ATTRIBUTE28
, PEL_ATTRIBUTE29 PEL_ATTRIBUTE29
, PEL_ATTRIBUTE30 PEL_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
, BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, DFLT_ENRT_DT DFLT_ENRT_DT
, DFLT_ASND_DT DFLT_ASND_DT
, ELCNS_MADE_DT ELCNS_MADE_DT
, CLS_ENRT_DT_TO_USE_CD CLS_ENRT_DT_TO_USE_CD
, ENRT_TYP_CYCL_CD ENRT_TYP_CYCL_CD
, ENRT_PERD_END_DT ENRT_PERD_END_DT
, ENRT_PERD_STRT_DT ENRT_PERD_STRT_DT
, PROCG_END_DT PROCG_END_DT
, PIL_ELCTBL_POPL_STAT_CD PIL_ELCTBL_POPL_STAT_CD
, ACTY_REF_PERD_CD ACTY_REF_PERD_CD
, UOM UOM
, AUTO_ASND_DT AUTO_ASND_DT
, ENRT_PERD_ID ENRT_PERD_ID
, LEE_RSN_ID LEE_RSN_ID
, PL_ID PL_ID
, BDGT_ACC_CD BDGT_ACC_CD
, POP_CD POP_CD
, BDGT_DUE_DT BDGT_DUE_DT
, BDGT_EXPORT_FLAG BDGT_EXPORT_FLAG
, BDGT_ISS_DT BDGT_ISS_DT
, BDGT_STAT_CD BDGT_STAT_CD
, WS_ACC_CD WS_ACC_CD
, WS_DUE_DT WS_DUE_DT
, WS_EXPORT_FLAG WS_EXPORT_FLAG
, WS_ISS_DT WS_ISS_DT
, WS_STAT_CD WS_STAT_CD
, ASSIGNMENT_ID ASSIGNMENT_ID
, COMMENTS COMMENTS
, MGR_OVRID_PERSON_ID MGR_OVRID_PERSON_ID
, WS_MGR_ID WS_MGR_ID
, MGR_OVRID_DT MGR_OVRID_DT
, REINSTATE_CD REINSTATE_CD
, REINSTATE_OVRDN_CD REINSTATE_OVRDN_CD
, DEFER_DEENROL_FLAG DEFER_DEENROL_FLAG
, DEENROL_MADE_DT DEENROL_MADE_DT
, REOPEN_LE_ON_REPROCESS REOPEN_LE_ON_REPROCESS
FROM "BEN"."BEN_PIL_ELCTBL_CHC_POPL"