Skip to content

DBA Data[Home] [Help] [Dependency Information]

VIEW: BEN.BEN_ENRT_PERD#

Object Details
Object Name: BEN_ENRT_PERD#
Object Type: VIEW
Owner: BEN
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
ENRT_PERD_ID NUMBER (15) Yes
BUSINESS_GROUP_ID NUMBER (15) Yes
END_DT DATE
Yes
STRT_DT DATE
Yes
POPL_ENRT_TYP_CYCL_ID NUMBER (15) Yes
YR_PERD_ID NUMBER (15) Yes
ENRT_CVG_END_DT_RL NUMBER (15)
RT_END_DT_RL NUMBER (15)
ENP_ATTRIBUTE_CATEGORY VARCHAR2 (30)
ENP_ATTRIBUTE1 VARCHAR2 (150)
ENP_ATTRIBUTE2 VARCHAR2 (150)
ENP_ATTRIBUTE3 VARCHAR2 (150)
ENP_ATTRIBUTE4 VARCHAR2 (150)
ENP_ATTRIBUTE5 VARCHAR2 (150)
ENP_ATTRIBUTE6 VARCHAR2 (150)
ENP_ATTRIBUTE7 VARCHAR2 (150)
ENP_ATTRIBUTE8 VARCHAR2 (150)
ENP_ATTRIBUTE9 VARCHAR2 (150)
ENP_ATTRIBUTE10 VARCHAR2 (150)
ENP_ATTRIBUTE11 VARCHAR2 (150)
ENP_ATTRIBUTE12 VARCHAR2 (150)
ENP_ATTRIBUTE13 VARCHAR2 (150)
ENP_ATTRIBUTE14 VARCHAR2 (150)
ENP_ATTRIBUTE15 VARCHAR2 (150)
ENP_ATTRIBUTE16 VARCHAR2 (150)
ENP_ATTRIBUTE17 VARCHAR2 (150)
ENP_ATTRIBUTE18 VARCHAR2 (150)
ENP_ATTRIBUTE19 VARCHAR2 (150)
ENP_ATTRIBUTE20 VARCHAR2 (150)
ENP_ATTRIBUTE21 VARCHAR2 (150)
ENP_ATTRIBUTE22 VARCHAR2 (150)
ENP_ATTRIBUTE23 VARCHAR2 (150)
ENP_ATTRIBUTE24 VARCHAR2 (150)
ENP_ATTRIBUTE25 VARCHAR2 (150)
ENP_ATTRIBUTE26 VARCHAR2 (150)
ENP_ATTRIBUTE27 VARCHAR2 (150)
ENP_ATTRIBUTE28 VARCHAR2 (150)
ENP_ATTRIBUTE29 VARCHAR2 (150)
ENP_ATTRIBUTE30 VARCHAR2 (150)
LAST_UPDATE_DATE DATE

LAST_UPDATED_BY NUMBER (15)
LAST_UPDATE_LOGIN NUMBER (15)
CREATED_BY NUMBER (15)
CREATION_DATE DATE

OBJECT_VERSION_NUMBER NUMBER (9)
CLS_ENRT_DT_TO_USE_CD VARCHAR2 (30)
DFLT_ENRT_DT DATE

ENRT_CVG_STRT_DT_CD VARCHAR2 (30)
ENRT_CVG_STRT_DT DATE

ENRT_CVG_END_DT DATE

ENRT_CVG_END_DT_CD VARCHAR2 (30)
RT_STRT_DT_RL NUMBER (15)
PROCG_END_DT DATE

RT_STRT_DT_CD VARCHAR2 (30)
RT_END_DT_CD VARCHAR2 (30)
ENRT_CVG_STRT_DT_RL NUMBER (15)
ASND_LF_EVT_DT DATE

AUTO_DISTR_FLAG VARCHAR2 (30) Yes
BDGT_UPD_END_DT DATE

BDGT_UPD_STRT_DT DATE

DFLT_WS_ACC_CD VARCHAR2 (30)
EMP_INTERVIEW_TYPE_CD VARCHAR2 (30)
HRCHY_TO_USE_CD VARCHAR2 (30)
LER_ID NUMBER (15)
POS_STRUCTURE_VERSION_ID NUMBER (15)
PRSVR_BDGT_CD VARCHAR2 (30)
USES_BDGT_FLAG VARCHAR2 (30) Yes
WS_UPD_END_DT DATE

WS_UPD_STRT_DT DATE

WTHN_YR_PERD_ID NUMBER (15)
ASG_UPDT_EFF_DATE DATE

PERF_REVW_STRT_DT DATE

ENRT_PERD_DET_OVRLP_BCKDT_CD VARCHAR2 (30)
APPROVAL_MODE_CD VARCHAR2 (30)
DATA_FREEZE_DATE DATE

HRCHY_AME_APP_ID NUMBER (15)
HRCHY_AME_TRN_CD VARCHAR2 (30)
HRCHY_RL NUMBER (15)
SAL_CHG_REASON_CD VARCHAR2 (30)
REINSTATE_CD VARCHAR2 (30)
REINSTATE_OVRDN_CD VARCHAR2 (30)
DEFER_DEENROL_FLAG VARCHAR2 (30)
REOPEN_LE_ON_REPROCESS VARCHAR2 (30)
Query Text

Cut, paste (and edit) the following text to query this object:


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

Dependencies

[top of page]

BEN.BEN_ENRT_PERD# references the following:

SchemaBEN
TableBEN_ENRT_PERD
BEN.BEN_ENRT_PERD# is referenced by following:

SchemaAPPS
SynonymBEN_ENRT_PERD
TriggerBEN_ENRT_PERD_WHO