VIEW: BEN.BEN_ENRT_PERD#

Source

View Text - Preformatted

select ENRT_PERD_ID ENRT_PERD_ID, BUSINESS_GROUP_ID BUSINESS_GROUP_ID, END_DT END_DT, STRT_DT STRT_DT, POPL_ENRT_TYP_CYCL_ID POPL_ENRT_TYP_CYCL_ID, YR_PERD_ID YR_PERD_ID, ENRT_CVG_END_DT_RL ENRT_CVG_END_DT_RL, RT_END_DT_RL RT_END_DT_RL, ENP_ATTRIBUTE_CATEGORY ENP_ATTRIBUTE_CATEGORY, ENP_ATTRIBUTE1 ENP_ATTRIBUTE1, ENP_ATTRIBUTE2 ENP_ATTRIBUTE2, ENP_ATTRIBUTE3 ENP_ATTRIBUTE3, ENP_ATTRIBUTE4 ENP_ATTRIBUTE4, ENP_ATTRIBUTE5 ENP_ATTRIBUTE5, ENP_ATTRIBUTE6 ENP_ATTRIBUTE6, ENP_ATTRIBUTE7 ENP_ATTRIBUTE7, ENP_ATTRIBUTE8 ENP_ATTRIBUTE8, ENP_ATTRIBUTE9 ENP_ATTRIBUTE9, ENP_ATTRIBUTE10 ENP_ATTRIBUTE10, ENP_ATTRIBUTE11 ENP_ATTRIBUTE11, ENP_ATTRIBUTE12 ENP_ATTRIBUTE12, ENP_ATTRIBUTE13 ENP_ATTRIBUTE13, ENP_ATTRIBUTE14 ENP_ATTRIBUTE14, ENP_ATTRIBUTE15 ENP_ATTRIBUTE15, ENP_ATTRIBUTE16 ENP_ATTRIBUTE16, ENP_ATTRIBUTE17 ENP_ATTRIBUTE17, ENP_ATTRIBUTE18 ENP_ATTRIBUTE18, ENP_ATTRIBUTE19 ENP_ATTRIBUTE19, ENP_ATTRIBUTE20 ENP_ATTRIBUTE20, ENP_ATTRIBUTE21 ENP_ATTRIBUTE21, ENP_ATTRIBUTE22 ENP_ATTRIBUTE22, ENP_ATTRIBUTE23 ENP_ATTRIBUTE23, ENP_ATTRIBUTE24 ENP_ATTRIBUTE24, ENP_ATTRIBUTE25 ENP_ATTRIBUTE25, ENP_ATTRIBUTE26 ENP_ATTRIBUTE26, ENP_ATTRIBUTE27 ENP_ATTRIBUTE27, ENP_ATTRIBUTE28 ENP_ATTRIBUTE28, ENP_ATTRIBUTE29 ENP_ATTRIBUTE29, ENP_ATTRIBUTE30 ENP_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, CLS_ENRT_DT_TO_USE_CD CLS_ENRT_DT_TO_USE_CD, DFLT_ENRT_DT DFLT_ENRT_DT, ENRT_CVG_STRT_DT_CD ENRT_CVG_STRT_DT_CD, ENRT_CVG_STRT_DT ENRT_CVG_STRT_DT, ENRT_CVG_END_DT ENRT_CVG_END_DT, ENRT_CVG_END_DT_CD ENRT_CVG_END_DT_CD, RT_STRT_DT_RL RT_STRT_DT_RL, PROCG_END_DT PROCG_END_DT, RT_STRT_DT_CD RT_STRT_DT_CD, RT_END_DT_CD RT_END_DT_CD, ENRT_CVG_STRT_DT_RL ENRT_CVG_STRT_DT_RL, ASND_LF_EVT_DT ASND_LF_EVT_DT, AUTO_DISTR_FLAG AUTO_DISTR_FLAG, BDGT_UPD_END_DT BDGT_UPD_END_DT, BDGT_UPD_STRT_DT BDGT_UPD_STRT_DT, DFLT_WS_ACC_CD DFLT_WS_ACC_CD, EMP_INTERVIEW_TYPE_CD EMP_INTERVIEW_TYPE_CD, HRCHY_TO_USE_CD HRCHY_TO_USE_CD, LER_ID LER_ID, POS_STRUCTURE_VERSION_ID POS_STRUCTURE_VERSION_ID, PRSVR_BDGT_CD PRSVR_BDGT_CD, USES_BDGT_FLAG USES_BDGT_FLAG, WS_UPD_END_DT WS_UPD_END_DT, WS_UPD_STRT_DT WS_UPD_STRT_DT, WTHN_YR_PERD_ID WTHN_YR_PERD_ID, ASG_UPDT_EFF_DATE ASG_UPDT_EFF_DATE, PERF_REVW_STRT_DT PERF_REVW_STRT_DT, ENRT_PERD_DET_OVRLP_BCKDT_CD ENRT_PERD_DET_OVRLP_BCKDT_CD, APPROVAL_MODE_CD APPROVAL_MODE_CD, DATA_FREEZE_DATE DATA_FREEZE_DATE, HRCHY_AME_APP_ID HRCHY_AME_APP_ID, HRCHY_AME_TRN_CD HRCHY_AME_TRN_CD, HRCHY_RL HRCHY_RL, SAL_CHG_REASON_CD SAL_CHG_REASON_CD, REINSTATE_CD REINSTATE_CD, REINSTATE_OVRDN_CD REINSTATE_OVRDN_CD, DEFER_DEENROL_FLAG DEFER_DEENROL_FLAG, REOPEN_LE_ON_REPROCESS REOPEN_LE_ON_REPROCESS from "BEN"."BEN_ENRT_PERD"

View Text - HTML Formatted

SELECT ENRT_PERD_ID ENRT_PERD_ID
, BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, END_DT END_DT
, STRT_DT STRT_DT
, POPL_ENRT_TYP_CYCL_ID POPL_ENRT_TYP_CYCL_ID
, YR_PERD_ID YR_PERD_ID
, ENRT_CVG_END_DT_RL ENRT_CVG_END_DT_RL
, RT_END_DT_RL RT_END_DT_RL
, ENP_ATTRIBUTE_CATEGORY ENP_ATTRIBUTE_CATEGORY
, ENP_ATTRIBUTE1 ENP_ATTRIBUTE1
, ENP_ATTRIBUTE2 ENP_ATTRIBUTE2
, ENP_ATTRIBUTE3 ENP_ATTRIBUTE3
, ENP_ATTRIBUTE4 ENP_ATTRIBUTE4
, ENP_ATTRIBUTE5 ENP_ATTRIBUTE5
, ENP_ATTRIBUTE6 ENP_ATTRIBUTE6
, ENP_ATTRIBUTE7 ENP_ATTRIBUTE7
, ENP_ATTRIBUTE8 ENP_ATTRIBUTE8
, ENP_ATTRIBUTE9 ENP_ATTRIBUTE9
, ENP_ATTRIBUTE10 ENP_ATTRIBUTE10
, ENP_ATTRIBUTE11 ENP_ATTRIBUTE11
, ENP_ATTRIBUTE12 ENP_ATTRIBUTE12
, ENP_ATTRIBUTE13 ENP_ATTRIBUTE13
, ENP_ATTRIBUTE14 ENP_ATTRIBUTE14
, ENP_ATTRIBUTE15 ENP_ATTRIBUTE15
, ENP_ATTRIBUTE16 ENP_ATTRIBUTE16
, ENP_ATTRIBUTE17 ENP_ATTRIBUTE17
, ENP_ATTRIBUTE18 ENP_ATTRIBUTE18
, ENP_ATTRIBUTE19 ENP_ATTRIBUTE19
, ENP_ATTRIBUTE20 ENP_ATTRIBUTE20
, ENP_ATTRIBUTE21 ENP_ATTRIBUTE21
, ENP_ATTRIBUTE22 ENP_ATTRIBUTE22
, ENP_ATTRIBUTE23 ENP_ATTRIBUTE23
, ENP_ATTRIBUTE24 ENP_ATTRIBUTE24
, ENP_ATTRIBUTE25 ENP_ATTRIBUTE25
, ENP_ATTRIBUTE26 ENP_ATTRIBUTE26
, ENP_ATTRIBUTE27 ENP_ATTRIBUTE27
, ENP_ATTRIBUTE28 ENP_ATTRIBUTE28
, ENP_ATTRIBUTE29 ENP_ATTRIBUTE29
, ENP_ATTRIBUTE30 ENP_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
, CLS_ENRT_DT_TO_USE_CD CLS_ENRT_DT_TO_USE_CD
, DFLT_ENRT_DT DFLT_ENRT_DT
, ENRT_CVG_STRT_DT_CD ENRT_CVG_STRT_DT_CD
, ENRT_CVG_STRT_DT ENRT_CVG_STRT_DT
, ENRT_CVG_END_DT ENRT_CVG_END_DT
, ENRT_CVG_END_DT_CD ENRT_CVG_END_DT_CD
, RT_STRT_DT_RL RT_STRT_DT_RL
, PROCG_END_DT PROCG_END_DT
, RT_STRT_DT_CD RT_STRT_DT_CD
, RT_END_DT_CD RT_END_DT_CD
, ENRT_CVG_STRT_DT_RL ENRT_CVG_STRT_DT_RL
, ASND_LF_EVT_DT ASND_LF_EVT_DT
, AUTO_DISTR_FLAG AUTO_DISTR_FLAG
, BDGT_UPD_END_DT BDGT_UPD_END_DT
, BDGT_UPD_STRT_DT BDGT_UPD_STRT_DT
, DFLT_WS_ACC_CD DFLT_WS_ACC_CD
, EMP_INTERVIEW_TYPE_CD EMP_INTERVIEW_TYPE_CD
, HRCHY_TO_USE_CD HRCHY_TO_USE_CD
, LER_ID LER_ID
, POS_STRUCTURE_VERSION_ID POS_STRUCTURE_VERSION_ID
, PRSVR_BDGT_CD PRSVR_BDGT_CD
, USES_BDGT_FLAG USES_BDGT_FLAG
, WS_UPD_END_DT WS_UPD_END_DT
, WS_UPD_STRT_DT WS_UPD_STRT_DT
, WTHN_YR_PERD_ID WTHN_YR_PERD_ID
, ASG_UPDT_EFF_DATE ASG_UPDT_EFF_DATE
, PERF_REVW_STRT_DT PERF_REVW_STRT_DT
, ENRT_PERD_DET_OVRLP_BCKDT_CD ENRT_PERD_DET_OVRLP_BCKDT_CD
, APPROVAL_MODE_CD APPROVAL_MODE_CD
, DATA_FREEZE_DATE DATA_FREEZE_DATE
, HRCHY_AME_APP_ID HRCHY_AME_APP_ID
, HRCHY_AME_TRN_CD HRCHY_AME_TRN_CD
, HRCHY_RL HRCHY_RL
, SAL_CHG_REASON_CD SAL_CHG_REASON_CD
, REINSTATE_CD REINSTATE_CD
, REINSTATE_OVRDN_CD REINSTATE_OVRDN_CD
, DEFER_DEENROL_FLAG DEFER_DEENROL_FLAG
, REOPEN_LE_ON_REPROCESS REOPEN_LE_ON_REPROCESS
FROM "BEN"."BEN_ENRT_PERD"