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]

TABLE: BEN.BEN_ENRT_PERD

Object Details

Object Name:	BEN_ENRT_PERD
Object Type:	TABLE
Owner:	BEN
FND Design Data:	BEN.BEN_ENRT_PERD
Subobject Name:
Status:	VALID

BEN_ENRT_PERD identifies a specific instance of an enrollment period for a program or plan for a defined type of enrollment type cycle. For example, the Vision flex program open enrollment for plan year 2001.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Primary Key: BEN_ENRT_PERD_PK

ENRT_PERD_ID

Indexes

Index	Type	Uniqueness	Tablespace	Column
BEN_ENRT_PERD_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	ENRT_PERD_ID
BEN_ENRT_PERD_FK1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	BUSINESS_GROUP_ID
BEN_ENRT_PERD_FK2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	YR_PERD_ID
BEN_ENRT_PERD_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	POPL_ENRT_TYP_CYCL_ID
BEN_ENRT_PERD_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	RT_STRT_DT_RL
BEN_ENRT_PERD_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ENRT_CVG_STRT_DT_RL
BEN_ENRT_PERD_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ENRT_CVG_END_DT_RL
BEN_ENRT_PERD_N5	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	RT_END_DT_RL

Columns

Name	Datatype	Length	Mandatory	Comments
ENRT_PERD_ID	NUMBER	(15)	Yes	System generated primary key column.
BUSINESS_GROUP_ID	NUMBER	(15)	Yes	Foreign Key to HR_ORGANIZATION_UNITS
END_DT	DATE		Yes	End date.
STRT_DT	DATE		Yes	Start date.
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.
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.
ENP_ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Descriptive Flexfield structure defining column.
ENP_ATTRIBUTE1	VARCHAR2	(150)		Descriptive Flexfield segment column.
ENP_ATTRIBUTE2	VARCHAR2	(150)		Descriptive Flexfield segment column.
ENP_ATTRIBUTE3	VARCHAR2	(150)		Descriptive Flexfield segment column.
ENP_ATTRIBUTE4	VARCHAR2	(150)		Descriptive Flexfield segment column.
ENP_ATTRIBUTE5	VARCHAR2	(150)		Descriptive Flexfield segment column.
ENP_ATTRIBUTE6	VARCHAR2	(150)		Descriptive Flexfield segment column.
ENP_ATTRIBUTE7	VARCHAR2	(150)		Descriptive Flexfield segment column.
ENP_ATTRIBUTE8	VARCHAR2	(150)		Descriptive Flexfield segment column.
ENP_ATTRIBUTE9	VARCHAR2	(150)		Descriptive Flexfield segment column.
ENP_ATTRIBUTE10	VARCHAR2	(150)		Descriptive Flexfield segment column.
ENP_ATTRIBUTE11	VARCHAR2	(150)		Descriptive Flexfield segment column.
ENP_ATTRIBUTE12	VARCHAR2	(150)		Descriptive Flexfield segment column.
ENP_ATTRIBUTE13	VARCHAR2	(150)		Descriptive Flexfield segment column.
ENP_ATTRIBUTE14	VARCHAR2	(150)		Descriptive Flexfield segment column.
ENP_ATTRIBUTE15	VARCHAR2	(150)		Descriptive Flexfield segment column.
ENP_ATTRIBUTE16	VARCHAR2	(150)		Descriptive Flexfield segment column.
ENP_ATTRIBUTE17	VARCHAR2	(150)		Descriptive Flexfield segment column.
ENP_ATTRIBUTE18	VARCHAR2	(150)		Descriptive Flexfield segment column.
ENP_ATTRIBUTE19	VARCHAR2	(150)		Descriptive Flexfield segment column.
ENP_ATTRIBUTE20	VARCHAR2	(150)		Descriptive Flexfield segment column.
ENP_ATTRIBUTE21	VARCHAR2	(150)		Descriptive Flexfield segment column.
ENP_ATTRIBUTE22	VARCHAR2	(150)		Descriptive Flexfield segment column.
ENP_ATTRIBUTE23	VARCHAR2	(150)		Descriptive Flexfield segment column.
ENP_ATTRIBUTE24	VARCHAR2	(150)		Descriptive Flexfield segment column.
ENP_ATTRIBUTE25	VARCHAR2	(150)		Descriptive Flexfield segment column.
ENP_ATTRIBUTE26	VARCHAR2	(150)		Descriptive Flexfield segment column.
ENP_ATTRIBUTE27	VARCHAR2	(150)		Descriptive Flexfield segment column.
ENP_ATTRIBUTE28	VARCHAR2	(150)		Descriptive Flexfield segment column.
ENP_ATTRIBUTE29	VARCHAR2	(150)		Descriptive Flexfield segment column.
ENP_ATTRIBUTE30	VARCHAR2	(150)		Descriptive Flexfield segment column.
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).
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_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.
OBJECT_VERSION_NUMBER	NUMBER	(9)		System-generated primary key. Increments by one each update.
CLS_ENRT_DT_TO_USE_CD	VARCHAR2	(30)		Close enrollment date to use code.
DFLT_ENRT_DT	DATE			Default enrollment date.
ENRT_CVG_STRT_DT_CD	VARCHAR2	(30)		Enrollment coverage start date code.
ENRT_CVG_STRT_DT	DATE			Enrollment coverage start date.
ENRT_CVG_END_DT	DATE			Enrollment coverage end date.
ENRT_CVG_END_DT_CD	VARCHAR2	(30)		Enrollment coverage end date code.
RT_STRT_DT_RL	NUMBER	(15)		Foreign key to FF_FORMULAS_F.
PROCG_END_DT	DATE			Processing end date.
RT_STRT_DT_CD	VARCHAR2	(30)		Rate start date code.
RT_END_DT_CD	VARCHAR2	(30)		Rate end date code.
ENRT_CVG_STRT_DT_RL	NUMBER	(15)		Foreign key to FF_FORMULAS_F.
ASND_LF_EVT_DT	DATE			Assigned life event date.
AUTO_DISTR_FLAG	VARCHAR2	(30)	Yes	auto distr flag.
BDGT_UPD_END_DT	DATE			bdgt upd end dt.
BDGT_UPD_STRT_DT	DATE			bdgt upd strt dt.
DFLT_WS_ACC_CD	VARCHAR2	(30)		dflt ws acc cd.
EMP_INTERVIEW_TYPE_CD	VARCHAR2	(30)		emp interview type cd.
HRCHY_TO_USE_CD	VARCHAR2	(30)		hrchy to use cd.
LER_ID	NUMBER	(15)		Foreign Key to BEN_LER_F.
POS_STRUCTURE_VERSION_ID	NUMBER	(15)		position structure id.
PRSVR_BDGT_CD	VARCHAR2	(30)		prsvr bdgt cd.
USES_BDGT_FLAG	VARCHAR2	(30)	Yes	uses bdgt flag.
WS_UPD_END_DT	DATE			ws upd end dt.
WS_UPD_STRT_DT	DATE			ws upd strt dt.
WTHN_YR_PERD_ID	NUMBER	(15)		wthn yr perd id.
ASG_UPDT_EFF_DATE	DATE			Assignment Update effective Date
PERF_REVW_STRT_DT	DATE			Performance Review Start Date
ENRT_PERD_DET_OVRLP_BCKDT_CD	VARCHAR2	(30)		Enrollment period detect overlap backed out.
APPROVAL_MODE_CD	VARCHAR2	(30)		Approval mode code.
DATA_FREEZE_DATE	DATE			Data Freeze Date.
HRCHY_AME_APP_ID	NUMBER	(15)		Hierarchy application id.
HRCHY_AME_TRN_CD	VARCHAR2	(30)		Hierarchy AME code.
HRCHY_RL	NUMBER	(15)		Hierarchy Rule.
SAL_CHG_REASON_CD	VARCHAR2	(30)		Salary Change reason code.
REINSTATE_CD	VARCHAR2	(30)		Reinstate Code
REINSTATE_OVRDN_CD	VARCHAR2	(30)		Reinstate Override Code
DEFER_DEENROL_FLAG	VARCHAR2	(30)		Defer Deenrollment Flag.

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
FROM BEN.BEN_ENRT_PERD;

Dependencies

[top of page]

BEN.BEN_ENRT_PERD does not reference any database object

BEN.BEN_ENRT_PERD is referenced by following:

APPS: BEN_ENRT_PERD; BEN_ENRT_PERD_WHO