[Home] [Help] [Dependency Information]
Object Name: | BEN_CLPSE_LF_EVT_F |
---|---|
Object Type: | TABLE |
Owner: | BEN |
FND Design Data: | BEN.BEN_CLPSE_LF_EVT_F |
Subobject Name: | |
Status: | VALID |
BEN_CLPSE_LF_EVT_F identifies the life event(s) that will be consolidated into one
resulting life even when being evaluated concurrently. It also specifies the number of days apart from each other the group of one or more life events must have occurred, and status the
collapsed life events should be set to. For example,Voided.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
BEN_CLPSE_LF_EVT_F_PK | NORMAL | UNIQUE | APPS_TS_TX_IDX |
CLPSE_LF_EVT_ID
EFFECTIVE_START_DATE EFFECTIVE_END_DATE |
BEN_CLPSE_LF_EVT_F_FK1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | BUSINESS_GROUP_ID |
BEN_CLPSE_LF_EVT_F_N10 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | LER9_ID |
BEN_CLPSE_LF_EVT_F_N11 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | LER10_ID |
BEN_CLPSE_LF_EVT_F_N12 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | EVAL_LER_ID |
BEN_CLPSE_LF_EVT_F_N2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | LER1_ID |
BEN_CLPSE_LF_EVT_F_N3 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | LER2_ID |
BEN_CLPSE_LF_EVT_F_N4 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | LER3_ID |
BEN_CLPSE_LF_EVT_F_N5 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | LER4_ID |
BEN_CLPSE_LF_EVT_F_N6 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | LER5_ID |
BEN_CLPSE_LF_EVT_F_N7 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | LER6_ID |
BEN_CLPSE_LF_EVT_F_N8 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | LER7_ID |
BEN_CLPSE_LF_EVT_F_N9 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | LER8_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CLPSE_LF_EVT_ID | NUMBER | (15) | Yes | Foreign Key to BEN_CLPSE_LF_EVT_F. |
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 |
SEQ | NUMBER | (15) | Yes | Sequence. |
EVAL_LER_ID | NUMBER | (15) | Yes | Foreign key to BEN_LER_F. |
LER1_ID | NUMBER | (15) | Yes | Foreign key to BEN_LER_F. |
EVAL_CD | VARCHAR2 | (30) | Yes | Life event evaluation code. |
EVAL_LER_DET_CD | VARCHAR2 | (30) | Yes | Life event determination date code. |
OBJECT_VERSION_NUMBER | NUMBER | (9) | Yes | System-generated primary key. Increments by one each update. |
LER9_ID | NUMBER | (15) | Foreign key to BEN_LER_F. | |
LER10_ID | NUMBER | (15) | Foreign key to BEN_LER_F. | |
BOOL1_CD | VARCHAR2 | (30) | Boolean code. | |
BOOL2_CD | VARCHAR2 | (30) | Boolean code. | |
LER2_ID | NUMBER | (15) | Foreign key to BEN_LER_F. | |
BOOL3_CD | VARCHAR2 | (30) | Boolean code. | |
LER3_ID | NUMBER | (15) | Foreign key to BEN_LER_F. | |
BOOL4_CD | VARCHAR2 | (30) | Boolean code. | |
LER4_ID | NUMBER | (15) | Foreign key to BEN_LER_F. | |
BOOL5_CD | VARCHAR2 | (30) | Boolean code. | |
LER5_ID | NUMBER | (15) | Foreign key to BEN_LER_F. | |
BOOL6_CD | VARCHAR2 | (30) | Boolean code. | |
LER6_ID | NUMBER | (15) | Foreign key to BEN_LER_F. | |
BOOL7_CD | VARCHAR2 | (30) | Boolean code. | |
LER7_ID | NUMBER | (15) | Foreign key to BEN_LER_F. | |
BOOL8_CD | VARCHAR2 | (30) | Boolean code. | |
LER8_ID | NUMBER | (15) | Foreign key to BEN_LER_F. | |
BOOL9_CD | VARCHAR2 | (30) | Boolean code. | |
EVAL_RL | NUMBER | (15) | Foreign key to FF_FORMULAS_F. | |
TLRNC_DYS_NUM | NUMBER | (15) | Tolerance days. | |
EVAL_LER_DET_RL | NUMBER | (15) | Foreign key to FF_FORMULAS_F. | |
CLP_ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive Flexfield structure defining column. | |
CLP_ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
CLP_ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
CLP_ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
CLP_ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
CLP_ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
CLP_ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
CLP_ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
CLP_ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
CLP_ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
CLP_ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
CLP_ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
CLP_ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
CLP_ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
CLP_ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
CLP_ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
CLP_ATTRIBUTE16 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
CLP_ATTRIBUTE17 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
CLP_ATTRIBUTE18 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
CLP_ATTRIBUTE19 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
CLP_ATTRIBUTE20 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
CLP_ATTRIBUTE21 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
CLP_ATTRIBUTE22 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
CLP_ATTRIBUTE23 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
CLP_ATTRIBUTE24 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
CLP_ATTRIBUTE25 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
CLP_ATTRIBUTE26 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
CLP_ATTRIBUTE27 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
CLP_ATTRIBUTE28 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
CLP_ATTRIBUTE29 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
CLP_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. |
Cut, paste (and edit) the following text to query this object:
SELECT CLPSE_LF_EVT_ID
, EFFECTIVE_START_DATE
, EFFECTIVE_END_DATE
, BUSINESS_GROUP_ID
, SEQ
, EVAL_LER_ID
, LER1_ID
, EVAL_CD
, EVAL_LER_DET_CD
, OBJECT_VERSION_NUMBER
, LER9_ID
, LER10_ID
, BOOL1_CD
, BOOL2_CD
, LER2_ID
, BOOL3_CD
, LER3_ID
, BOOL4_CD
, LER4_ID
, BOOL5_CD
, LER5_ID
, BOOL6_CD
, LER6_ID
, BOOL7_CD
, LER7_ID
, BOOL8_CD
, LER8_ID
, BOOL9_CD
, EVAL_RL
, TLRNC_DYS_NUM
, EVAL_LER_DET_RL
, CLP_ATTRIBUTE_CATEGORY
, CLP_ATTRIBUTE1
, CLP_ATTRIBUTE2
, CLP_ATTRIBUTE3
, CLP_ATTRIBUTE4
, CLP_ATTRIBUTE5
, CLP_ATTRIBUTE6
, CLP_ATTRIBUTE7
, CLP_ATTRIBUTE8
, CLP_ATTRIBUTE9
, CLP_ATTRIBUTE10
, CLP_ATTRIBUTE11
, CLP_ATTRIBUTE12
, CLP_ATTRIBUTE13
, CLP_ATTRIBUTE14
, CLP_ATTRIBUTE15
, CLP_ATTRIBUTE16
, CLP_ATTRIBUTE17
, CLP_ATTRIBUTE18
, CLP_ATTRIBUTE19
, CLP_ATTRIBUTE20
, CLP_ATTRIBUTE21
, CLP_ATTRIBUTE22
, CLP_ATTRIBUTE23
, CLP_ATTRIBUTE24
, CLP_ATTRIBUTE25
, CLP_ATTRIBUTE26
, CLP_ATTRIBUTE27
, CLP_ATTRIBUTE28
, CLP_ATTRIBUTE29
, CLP_ATTRIBUTE30
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, CREATED_BY
, CREATION_DATE
FROM BEN.BEN_CLPSE_LF_EVT_F;
BEN.BEN_CLPSE_LF_EVT_F does not reference any database object
BEN.BEN_CLPSE_LF_EVT_F is referenced by following:
|
|
|