[Home] [Help] [Dependency Information]
Object Name: | BEN_ENRT_PERD_FOR_PL_F |
---|---|
Object Type: | TABLE |
Owner: | BEN |
FND Design Data: | BEN.BEN_ENRT_PERD_FOR_PL_F |
Subobject Name: | |
Status: | VALID |
BEN_ENRT_PERD_FOR_PL_F identifies the plans in program for which the enrollment period has been defined. Enrollment periods may be specified for programs or plans not in programs. When the enrollment period is defined for a program, the user is allowed to specify to which plans in the program the enrollment period applies.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
BEN_ENRT_PERD_FOR_PL_F_PK | NORMAL | UNIQUE | APPS_TS_TX_IDX |
ENRT_PERD_FOR_PL_ID
EFFECTIVE_START_DATE EFFECTIVE_END_DATE |
BEN_ENRT_PERD_FOR_PL_F_FK1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | ENRT_PERD_ID |
BEN_ENRT_PERD_FOR_PL_F_FK2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | BUSINESS_GROUP_ID |
BEN_ENRT_PERD_FOR_PL_F_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | LEE_RSN_ID |
BEN_ENRT_PERD_FOR_PL_F_N2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | PL_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ENRT_PERD_FOR_PL_ID | NUMBER | (15) | Yes | System generated primary key column. |
EFFECTIVE_START_DATE | DATE | Yes | Effective start date. | |
EFFECTIVE_END_DATE | DATE | Yes | Effective end date. | |
BUSINESS_GROUP_ID | NUMBER | (15) | Yes | Foreign Key to HR_ORGANIZATION_UNITS |
PL_ID | NUMBER | (15) | Yes | Foreign Key to BEN_PL_F. |
ERP_ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive Flexfield structure defining column. | |
ERP_ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
ERP_ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
ERP_ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
ERP_ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
ERP_ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
ERP_ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
ERP_ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
ERP_ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
ERP_ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
ERP_ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
ERP_ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
ERP_ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
ERP_ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
ERP_ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
ERP_ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
ERP_ATTRIBUTE16 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
ERP_ATTRIBUTE17 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
ERP_ATTRIBUTE18 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
ERP_ATTRIBUTE19 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
ERP_ATTRIBUTE20 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
ERP_ATTRIBUTE21 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
ERP_ATTRIBUTE22 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
ERP_ATTRIBUTE23 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
ERP_ATTRIBUTE24 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
ERP_ATTRIBUTE25 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
ERP_ATTRIBUTE26 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
ERP_ATTRIBUTE27 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
ERP_ATTRIBUTE28 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
ERP_ATTRIBUTE29 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
ERP_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. | |
ENRT_CVG_STRT_DT_CD | VARCHAR2 | (30) | Enrollment coverage start date code. | |
ENRT_CVG_STRT_DT_RL | NUMBER | (15) | Foreign key to FF_FORMULAS_F. | |
ENRT_CVG_END_DT_CD | VARCHAR2 | (30) | Enrollment coverage end date code. | |
ENRT_CVG_END_DT_RL | NUMBER | (15) | Foreign key to FF_FORMULAS_F. | |
RT_STRT_DT_CD | VARCHAR2 | (30) | Rate start date code. | |
RT_STRT_DT_RL | NUMBER | (15) | Foreign key to FF_FORMULAS_F. | |
RT_END_DT_CD | VARCHAR2 | (30) | Rate end date code. | |
RT_END_DT_RL | NUMBER | (15) | Foreign key to FF_FORMULAS_F. | |
ENRT_PERD_ID | NUMBER | (15) | Foreign key to BEN_ENRT_PERD_F. | |
LEE_RSN_ID | NUMBER | (15) | Foreign key to BEN_LEE_RSN_F. |
Cut, paste (and edit) the following text to query this object:
SELECT ENRT_PERD_FOR_PL_ID
, EFFECTIVE_START_DATE
, EFFECTIVE_END_DATE
, BUSINESS_GROUP_ID
, PL_ID
, ERP_ATTRIBUTE_CATEGORY
, ERP_ATTRIBUTE1
, ERP_ATTRIBUTE2
, ERP_ATTRIBUTE3
, ERP_ATTRIBUTE4
, ERP_ATTRIBUTE5
, ERP_ATTRIBUTE6
, ERP_ATTRIBUTE7
, ERP_ATTRIBUTE8
, ERP_ATTRIBUTE9
, ERP_ATTRIBUTE10
, ERP_ATTRIBUTE11
, ERP_ATTRIBUTE12
, ERP_ATTRIBUTE13
, ERP_ATTRIBUTE14
, ERP_ATTRIBUTE15
, ERP_ATTRIBUTE16
, ERP_ATTRIBUTE17
, ERP_ATTRIBUTE18
, ERP_ATTRIBUTE19
, ERP_ATTRIBUTE20
, ERP_ATTRIBUTE21
, ERP_ATTRIBUTE22
, ERP_ATTRIBUTE23
, ERP_ATTRIBUTE24
, ERP_ATTRIBUTE25
, ERP_ATTRIBUTE26
, ERP_ATTRIBUTE27
, ERP_ATTRIBUTE28
, ERP_ATTRIBUTE29
, ERP_ATTRIBUTE30
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, CREATED_BY
, CREATION_DATE
, OBJECT_VERSION_NUMBER
, ENRT_CVG_STRT_DT_CD
, ENRT_CVG_STRT_DT_RL
, ENRT_CVG_END_DT_CD
, ENRT_CVG_END_DT_RL
, RT_STRT_DT_CD
, RT_STRT_DT_RL
, RT_END_DT_CD
, RT_END_DT_RL
, ENRT_PERD_ID
, LEE_RSN_ID
FROM BEN.BEN_ENRT_PERD_FOR_PL_F;
BEN.BEN_ENRT_PERD_FOR_PL_F does not reference any database object
BEN.BEN_ENRT_PERD_FOR_PL_F is referenced by following:
|
|
|