eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

VIEW: APPS.BENBV_ENRT_PERD_V

Object Details

Object Name:	BENBV_ENRT_PERD_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	BEN.BENBV_ENRT_PERD_V
Subobject Name:
Status:	VALID

* Warning: Oracle Internal Use Only *

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
END_DT	DATE		Yes	Enrollment period end date.
STRT_DT	DATE		Yes	Enrollment period strt date.
ENRT_CVG_END_DT_RL	NUMBER	(15)		Foreign Key to FF_FORMULAS_F
RT_END_DT_RL	NUMBER	(15)		Foreign Key to FF_FORMULAS_F
DFLT_ENRT_DT	DATE			Default enrollment date.
ENRT_CVG_STRT_DT	DATE			Enrollment coverage start date.
ENRT_CVG_END_DT	DATE			Enrollment coverage end date.
RT_STRT_DT_RL	NUMBER	(15)		Foreign Key to FF_FORMULAS_F
PROCG_END_DT	DATE			Processing end date.
ENRT_CVG_STRT_DT_RL	NUMBER	(15)		Foreign Key to FF_FORMULAS_F
ASND_LF_EVT_DT	DATE			Assigned life event date.
BDGT_UPD_END_DT	DATE			Budget update end date.
BDGT_UPD_STRT_DT	DATE			Budget update start date.
WS_UPD_END_DT	DATE			Worksheet update end date.
WS_UPD_STRT_DT	DATE			Worksheet update start date.
PERF_REVW_STRT_DT	DATE			Performance review start date.
ASG_UPDT_EFF_DATE	DATE			Asignment update effective date.
DATA_FREEZE_DATE	DATE			Data Freeze Date.
HRCHY_RL	NUMBER	(15)		Hierarchy Rule.
_DF:ENP	CHAR	(25)
CLS_ENRT_DT_TO_USE_CD	VARCHAR2	(30)		Close enrollment date to use (Lookup code based on lookup type BEN_CLS_ENRT_DT_TO_USE).
CLS_ENRT_DT_TO_USE_CD_M	VARCHAR2	(4000)		Close enrollment date to use (Lookup meaning based on lookup type BEN_CLS_ENRT_DT_TO_USE).
ENRT_CVG_STRT_DT_CD	VARCHAR2	(30)		Enrollment coverage start date code (Lookup code based on lookup type BEN_ENRT_CVG_STRT).
ENRT_CVG_STRT_DT_CD_M	VARCHAR2	(4000)		Enrollment coverage start date code (Lookup meaning based on lookup type BEN_ENRT_CVG_STRT).
ENRT_CVG_END_DT_CD	VARCHAR2	(30)		Enrollment coverage end date code (Lookup code based on lookup type BEN_ENRT_CVG_END).
ENRT_CVG_END_DT_CD_M	VARCHAR2	(4000)		Enrollment coverage end date code (Lookup meaning based on lookup type BEN_ENRT_CVG_END).
RT_STRT_DT_CD	VARCHAR2	(30)		Rate start date (Lookup code based on lookup type BEN_RT_STRT).
RT_STRT_DT_CD_M	VARCHAR2	(4000)		Rate start date (Lookup meaning based on lookup type BEN_RT_STRT).
RT_END_DT_CD	VARCHAR2	(30)		Rate end date (Lookup code based on lookup type BEN_RT_END).
RT_END_DT_CD_M	VARCHAR2	(4000)		Rate end date (Lookup meaning based on lookup type BEN_RT_END).
DFLT_WS_ACC_CD	VARCHAR2	(30)		Default worksheet access (Lookup code based on lookup type BEN_WS_ACC).
DFLT_WS_ACC_CD_M	VARCHAR2	(4000)		Default worksheet access (Lookup meaning based on lookup type BEN_WS_ACC).
EMP_INTERVIEW_TYPE_CD	VARCHAR2	(30)		Employee interview type (Lookup code based on lookup type EMP_INTERVIEW_TYPE).
EMP_INTERVIEW_TYPE_CD_M	VARCHAR2	(4000)		Employee interview type (Lookup meaning based on lookup type EMP_INTERVIEW_TYPE).
HRCHY_TO_USE_CD	VARCHAR2	(30)		Hierarchy to use (Lookup code based on lookup type BEN_HRCHY_TO_USE).
HRCHY_TO_USE_CD_M	VARCHAR2	(4000)		Hierarchy to use (Lookup meaning based on lookup type BEN_HRCHY_TO_USE).
PRSVR_BDGT_CD	VARCHAR2	(30)		Preserve budget code (Lookup code based on lookup type BEN_PRSVR_BDGT).
PRSVR_BDGT_CD_M	VARCHAR2	(4000)		Preserve budget code (Lookup meaning based on lookup type BEN_PRSVR_BDGT).
ENRT_PERD_DET_OVRLP_BCKDT_CD	VARCHAR2	(30)		Period determination (Lookup code based on lookup type BEN_ENRT_PERD_DET_CD).
ENRT_PERD_DET_OVRLP_BCKDT_CD_M	VARCHAR2	(4000)		Period determination (Lookup meaning based on lookup type BEN_ENRT_PERD_DET_CD).
SAL_CHG_REASON_CD	VARCHAR2	(30)		Salary change reason code(Lookup Code of Lookup Type PROPOSAL_REASON)
SAL_CHG_REASON_CD_M	VARCHAR2	(4000)		Salary change reason code(Lookup meaning of Lookup Type PROPOSAL_REASON)
APPROVAL_MODE_CD	VARCHAR2	(30)		Approval Mode Code (Lookup Code of Lookup Type BEN_CWB_APPROVAL_MODE)
APPROVAL_MODE_CD_M	VARCHAR2	(4000)		Approval Mode Code (Lookup meaning of Lookup Type BEN_CWB_APPROVAL_MODE)
HRCHY_AME_TRN_CD	VARCHAR2	(30)		Hierarchy AME Code
HRCHY_AME_TRN_CD_M	VARCHAR2	(4000)
AUTO_DISTR_FLAG	VARCHAR2	(30)	Yes	Auto distribute (Lookup code based on lookup type YES_NO).
AUTO_DISTR_FLAG_M	VARCHAR2	(4000)		Auto distribute (Lookup meaning based on lookup type YES_NO).
USES_BDGT_FLAG	VARCHAR2	(30)	Yes	Uses budget (Lookup code based on lookup type YES_NO).
USES_BDGT_FLAG_M	VARCHAR2	(4000)		Uses budget (Lookup meaning based on lookup type YES_NO).
ENRT_PERD_ID	NUMBER	(15)	Yes	System generated primary key column.
BUSINESS_GROUP_ID	NUMBER	(15)	Yes	Foreign Key to HR_ORGANIZATION_UNITS.
POPL_ENRT_TYP_CYCL_ID	NUMBER	(15)	Yes	Foreign key to BEN_POPL_ENRT_TYP_CYCL_F.
YR_PERD_ID	NUMBER	(15)	Yes	Foreign key to BEN_YR_PERD.
LER_ID	NUMBER	(15)		Foreign key to BEN_LER_F.
POS_STRUCTURE_VERSION_ID	NUMBER	(15)		Foreign key to PER_POS_STRUCTURE_VERSIONS.
WTHN_YR_PERD_ID	NUMBER	(15)		Foreign key to BEN_WTHN_YR_PERD.
HRCHY_AME_APP_ID	NUMBER	(15)
LAST_UPDATE_DATE	DATE			Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY	NUMBER	(15)		Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
CREATED_BY	NUMBER	(15)		Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE	DATE			Standard who column - date when this row was created.

Query Text

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


SELECT END_DT
,      STRT_DT
,      ENRT_CVG_END_DT_RL
,      RT_END_DT_RL
,      DFLT_ENRT_DT
,      ENRT_CVG_STRT_DT
,      ENRT_CVG_END_DT
,      RT_STRT_DT_RL
,      PROCG_END_DT
,      ENRT_CVG_STRT_DT_RL
,      ASND_LF_EVT_DT
,      BDGT_UPD_END_DT
,      BDGT_UPD_STRT_DT
,      WS_UPD_END_DT
,      WS_UPD_STRT_DT
,      PERF_REVW_STRT_DT
,      ASG_UPDT_EFF_DATE
,      DATA_FREEZE_DATE
,      HRCHY_RL
,      _DF:ENP
,      CLS_ENRT_DT_TO_USE_CD
,      CLS_ENRT_DT_TO_USE_CD_M
,      ENRT_CVG_STRT_DT_CD
,      ENRT_CVG_STRT_DT_CD_M
,      ENRT_CVG_END_DT_CD
,      ENRT_CVG_END_DT_CD_M
,      RT_STRT_DT_CD
,      RT_STRT_DT_CD_M
,      RT_END_DT_CD
,      RT_END_DT_CD_M
,      DFLT_WS_ACC_CD
,      DFLT_WS_ACC_CD_M
,      EMP_INTERVIEW_TYPE_CD
,      EMP_INTERVIEW_TYPE_CD_M
,      HRCHY_TO_USE_CD
,      HRCHY_TO_USE_CD_M
,      PRSVR_BDGT_CD
,      PRSVR_BDGT_CD_M
,      ENRT_PERD_DET_OVRLP_BCKDT_CD
,      ENRT_PERD_DET_OVRLP_BCKDT_CD_M
,      SAL_CHG_REASON_CD
,      SAL_CHG_REASON_CD_M
,      APPROVAL_MODE_CD
,      APPROVAL_MODE_CD_M
,      HRCHY_AME_TRN_CD
,      HRCHY_AME_TRN_CD_M
,      AUTO_DISTR_FLAG
,      AUTO_DISTR_FLAG_M
,      USES_BDGT_FLAG
,      USES_BDGT_FLAG_M
,      ENRT_PERD_ID
,      BUSINESS_GROUP_ID
,      POPL_ENRT_TYP_CYCL_ID
,      YR_PERD_ID
,      LER_ID
,      POS_STRUCTURE_VERSION_ID
,      WTHN_YR_PERD_ID
,      HRCHY_AME_APP_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATED_BY
,      CREATION_DATE
FROM APPS.BENBV_ENRT_PERD_V;

Dependencies

[top of page]

APPS.BENBV_ENRT_PERD_V references the following:

APPS: BEN_ENRT_PERD; HR_BIS - show dependent code

APPS.BENBV_ENRT_PERD_V is not referenced by any database object