[Home] [Help] [Dependency Information]
Object Name: | BEN_LEE_RSN_RL_F |
---|---|
Object Type: | TABLE |
Owner: | BEN |
FND Design Data: | BEN.BEN_LEE_RSN_RL_F |
Subobject Name: | |
Status: | VALID |
BEN_LEE_RSN_RL_F specifies the rules to be enforced for a particular type of enrollment, for a specific reason, for a particular comensation program or plan. It identifies a rule used to determine life event enrollment requirements in those cases when the standard, delivered method does not meet the business requirement. For example, where the life event enrollment parameters vary by location, organization unit.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
BEN_LEE_RSN_RL_F_PK | NORMAL | UNIQUE | APPS_TS_TX_IDX |
LEE_RSN_RL_ID
EFFECTIVE_START_DATE EFFECTIVE_END_DATE |
BEN_LEE_RSN_RL_F_FK1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | BUSINESS_GROUP_ID |
BEN_LEE_RSN_RL_F_N2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | FORMULA_ID |
BEN_LEE_RSN_RL_F_N3 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | LEE_RSN_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
LEE_RSN_RL_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 |
FORMULA_ID | NUMBER | (15) | Yes | Foreign key to FF_FORMULAS_F. |
LEE_RSN_ID | NUMBER | (15) | Yes | Foreign key to BEN_LEE_RSN_F. |
LRR_ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive Flexfield structure defining column. | |
LRR_ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
LRR_ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
LRR_ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
LRR_ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
LRR_ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
LRR_ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
LRR_ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
LRR_ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
LRR_ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
LRR_ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
LRR_ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
LRR_ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
LRR_ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
LRR_ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
LRR_ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
LRR_ATTRIBUTE16 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
LRR_ATTRIBUTE17 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
LRR_ATTRIBUTE18 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
LRR_ATTRIBUTE19 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
LRR_ATTRIBUTE20 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
LRR_ATTRIBUTE21 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
LRR_ATTRIBUTE22 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
LRR_ATTRIBUTE23 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
LRR_ATTRIBUTE24 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
LRR_ATTRIBUTE25 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
LRR_ATTRIBUTE26 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
LRR_ATTRIBUTE27 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
LRR_ATTRIBUTE28 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
LRR_ATTRIBUTE29 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
LRR_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. | |
ORDR_TO_APLY_NUM | NUMBER | (15) | Order to apply. |
Cut, paste (and edit) the following text to query this object:
SELECT LEE_RSN_RL_ID
, EFFECTIVE_START_DATE
, EFFECTIVE_END_DATE
, BUSINESS_GROUP_ID
, FORMULA_ID
, LEE_RSN_ID
, LRR_ATTRIBUTE_CATEGORY
, LRR_ATTRIBUTE1
, LRR_ATTRIBUTE2
, LRR_ATTRIBUTE3
, LRR_ATTRIBUTE4
, LRR_ATTRIBUTE5
, LRR_ATTRIBUTE6
, LRR_ATTRIBUTE7
, LRR_ATTRIBUTE8
, LRR_ATTRIBUTE9
, LRR_ATTRIBUTE10
, LRR_ATTRIBUTE11
, LRR_ATTRIBUTE12
, LRR_ATTRIBUTE13
, LRR_ATTRIBUTE14
, LRR_ATTRIBUTE15
, LRR_ATTRIBUTE16
, LRR_ATTRIBUTE17
, LRR_ATTRIBUTE18
, LRR_ATTRIBUTE19
, LRR_ATTRIBUTE20
, LRR_ATTRIBUTE21
, LRR_ATTRIBUTE22
, LRR_ATTRIBUTE23
, LRR_ATTRIBUTE24
, LRR_ATTRIBUTE25
, LRR_ATTRIBUTE26
, LRR_ATTRIBUTE27
, LRR_ATTRIBUTE28
, LRR_ATTRIBUTE29
, LRR_ATTRIBUTE30
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, CREATED_BY
, CREATION_DATE
, OBJECT_VERSION_NUMBER
, ORDR_TO_APLY_NUM
FROM BEN.BEN_LEE_RSN_RL_F;
BEN.BEN_LEE_RSN_RL_F does not reference any database object
BEN.BEN_LEE_RSN_RL_F is referenced by following:
|
|
|