[Home] [Help] [Dependency Information]
Object Name: | BEN_BNFT_PRVDR_POOL_F |
---|---|
Object Type: | TABLE |
Owner: | BEN |
FND Design Data: | BEN.BEN_BNFT_PRVDR_POOL_F |
Subobject Name: | |
Status: | VALID |
BEN_BNFT_PRVDR_POOL_F specifies the pools or groups of compensation objects that may
provide credits or additional funds to pay for benefits or to be received
as cash by the participant. Possible sources of these credits or
additional funds are: the program, plan types within the program,
groups of plan types within the program (combinations of plan types),
groups of plan types within the program further restricted by option
(combinations of plan types and options), plans in the program, groups of
plans in the program (combinations of plans).
.
Credits provided by options in plans are grouped into the plan to which the options belong.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
BEN_BNFT_PRVDR_POOL_F_PK | NORMAL | UNIQUE | APPS_TS_TX_IDX |
BNFT_PRVDR_POOL_ID
EFFECTIVE_START_DATE EFFECTIVE_END_DATE |
BEN_BNFT_PRVDR_POOL_F_FK1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | BUSINESS_GROUP_ID |
BEN_BNFT_PRVDR_POOL_F_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | CMBN_PLIP_ID |
BEN_BNFT_PRVDR_POOL_F_N2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | PLIP_ID |
BEN_BNFT_PRVDR_POOL_F_N3 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | PTIP_ID |
BEN_BNFT_PRVDR_POOL_F_N4 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | PGM_ID |
BEN_BNFT_PRVDR_POOL_F_N5 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | CMBN_PTIP_ID |
BEN_BNFT_PRVDR_POOL_F_N6 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | CMBN_PTIP_OPT_ID |
BEN_BNFT_PRVDR_POOL_F_N7 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | PCT_RNDG_RL |
BEN_BNFT_PRVDR_POOL_F_N8 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | VAL_RNDG_RL |
BEN_BNFT_PRVDR_POOL_F_N9 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | DFLT_EXCS_TRTMT_RL |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
BNFT_PRVDR_POOL_ID | NUMBER | (15) | Yes | Foreign key to BEN_BNFT_PRVDR_POOL_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 |
NAME | VARCHAR2 | (240) | Yes | Name of the benefit provider pool. |
PGM_POOL_FLAG | VARCHAR2 | (30) | Yes | Program Pool Y or N. |
EXCS_ALWYS_FFTD_FLAG | VARCHAR2 | (30) | Yes | Excess Always Forfeited Y or N. |
USE_FOR_PGM_POOL_FLAG | VARCHAR2 | (30) | Yes | Use For Program Pool Y or N. |
NO_MN_DSTRBL_PCT_FLAG | VARCHAR2 | (30) | Yes | No Minimum Distributable Percent Y or N. |
NO_MN_DSTRBL_VAL_FLAG | VARCHAR2 | (30) | Yes | No Minimum Distributable Value Y or N. |
NO_MX_DSTRBL_PCT_FLAG | VARCHAR2 | (30) | Yes | No Maximum Distributable Percent Y or N. |
NO_MX_DSTRBL_VAL_FLAG | VARCHAR2 | (30) | Yes | No Maximum Distributable Value Y or N. |
AUTO_ALCT_EXCS_FLAG | VARCHAR2 | (30) | Yes | Automatically allocate excess Y or N. |
PGM_ID | NUMBER | (15) | Yes | Foreign key to BEN_PGM_F. |
CMBN_PTIP_ID | NUMBER | (15) | Foreign key to BEN_CMBN_PTIP_F. | |
CMBN_PTIP_OPT_ID | NUMBER | (15) | Foreign key to BEN_CMBN_PTIP_OPT_F. | |
PCT_RNDG_RL | NUMBER | (15) | Foreign key to FF_FORMULAS_F. | |
VAL_RNDG_RL | NUMBER | (15) | Foreign key to FF_FORMULAS_F. | |
OIPLIP_ID | NUMBER | (15) | Foreign Key to BEN_OIPLIP_F. | |
BPP_ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive Flexfield structure defining column. | |
BPP_ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
BPP_ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
BPP_ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
BPP_ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
BPP_ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
BPP_ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
BPP_ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
BPP_ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
BPP_ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
BPP_ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
BPP_ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
BPP_ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
BPP_ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
BPP_ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
BPP_ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
BPP_ATTRIBUTE16 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
BPP_ATTRIBUTE17 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
BPP_ATTRIBUTE18 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
BPP_ATTRIBUTE19 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
BPP_ATTRIBUTE20 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
BPP_ATTRIBUTE21 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
BPP_ATTRIBUTE22 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
BPP_ATTRIBUTE23 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
BPP_ATTRIBUTE24 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
BPP_ATTRIBUTE25 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
BPP_ATTRIBUTE26 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
BPP_ATTRIBUTE27 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
BPP_ATTRIBUTE28 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
BPP_ATTRIBUTE29 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
BPP_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. | |
PCT_RNDG_CD | VARCHAR2 | (30) | Percent rounding code. | |
VAL_RNDG_CD | VARCHAR2 | (30) | Value rounding code. | |
CMBN_PLIP_ID | NUMBER | (15) | Foreign key to BEN_CMBN_PLIP_F. | |
PLIP_ID | NUMBER | (15) | Foreign key to BEN_PLIP_F. | |
PTIP_ID | NUMBER | (15) | Foreign Key to BEN_PTIP_F. | |
DFLT_EXCS_TRTMT_CD | VARCHAR2 | (30) | Default excess treatment. | |
DFLT_EXCS_TRTMT_RL | NUMBER | (15) | Foreign key to FF_FORMULAS_F. | |
RLOVR_RSTRCN_CD | VARCHAR2 | (30) | Rollover restrictions. | |
MN_DSTRBL_PCT_NUM | NUMBER | (15) | Minimum distributable percent. | |
MN_DSTRBL_VAL | NUMBER | Minimum distributable value. | ||
MX_DSTRBL_PCT_NUM | NUMBER | (15) | Maximum distributable percent. | |
MX_DSTRBL_VAL | NUMBER | Maximum distributable value. | ||
EXCS_TRTMT_CD | VARCHAR2 | (30) | Excess treatment code. | |
ALWS_NGTV_CRS_FLAG | VARCHAR2 | (30) | Yes | Allows negative credits Y or N. |
USES_NET_CRS_MTHD_FLAG | VARCHAR2 | (30) | Yes | Uses Net Credits Method Y or N. |
MX_DFCIT_PCT_POOL_CRS_NUM | NUMBER | Maximum deficit percent of pool credits. | ||
MX_DFCIT_PCT_COMP_NUM | NUMBER | Maximum deficit percent of compensation. | ||
COMP_LVL_FCTR_ID | NUMBER | (15) | Foreign Key to BEN_COMP_LVL_FCTR_F. |
Cut, paste (and edit) the following text to query this object:
SELECT BNFT_PRVDR_POOL_ID
, EFFECTIVE_START_DATE
, EFFECTIVE_END_DATE
, BUSINESS_GROUP_ID
, NAME
, PGM_POOL_FLAG
, EXCS_ALWYS_FFTD_FLAG
, USE_FOR_PGM_POOL_FLAG
, NO_MN_DSTRBL_PCT_FLAG
, NO_MN_DSTRBL_VAL_FLAG
, NO_MX_DSTRBL_PCT_FLAG
, NO_MX_DSTRBL_VAL_FLAG
, AUTO_ALCT_EXCS_FLAG
, PGM_ID
, CMBN_PTIP_ID
, CMBN_PTIP_OPT_ID
, PCT_RNDG_RL
, VAL_RNDG_RL
, OIPLIP_ID
, BPP_ATTRIBUTE_CATEGORY
, BPP_ATTRIBUTE1
, BPP_ATTRIBUTE2
, BPP_ATTRIBUTE3
, BPP_ATTRIBUTE4
, BPP_ATTRIBUTE5
, BPP_ATTRIBUTE6
, BPP_ATTRIBUTE7
, BPP_ATTRIBUTE8
, BPP_ATTRIBUTE9
, BPP_ATTRIBUTE10
, BPP_ATTRIBUTE11
, BPP_ATTRIBUTE12
, BPP_ATTRIBUTE13
, BPP_ATTRIBUTE14
, BPP_ATTRIBUTE15
, BPP_ATTRIBUTE16
, BPP_ATTRIBUTE17
, BPP_ATTRIBUTE18
, BPP_ATTRIBUTE19
, BPP_ATTRIBUTE20
, BPP_ATTRIBUTE21
, BPP_ATTRIBUTE22
, BPP_ATTRIBUTE23
, BPP_ATTRIBUTE24
, BPP_ATTRIBUTE25
, BPP_ATTRIBUTE26
, BPP_ATTRIBUTE27
, BPP_ATTRIBUTE28
, BPP_ATTRIBUTE29
, BPP_ATTRIBUTE30
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, CREATED_BY
, CREATION_DATE
, OBJECT_VERSION_NUMBER
, PCT_RNDG_CD
, VAL_RNDG_CD
, CMBN_PLIP_ID
, PLIP_ID
, PTIP_ID
, DFLT_EXCS_TRTMT_CD
, DFLT_EXCS_TRTMT_RL
, RLOVR_RSTRCN_CD
, MN_DSTRBL_PCT_NUM
, MN_DSTRBL_VAL
, MX_DSTRBL_PCT_NUM
, MX_DSTRBL_VAL
, EXCS_TRTMT_CD
, ALWS_NGTV_CRS_FLAG
, USES_NET_CRS_MTHD_FLAG
, MX_DFCIT_PCT_POOL_CRS_NUM
, MX_DFCIT_PCT_COMP_NUM
, COMP_LVL_FCTR_ID
FROM BEN.BEN_BNFT_PRVDR_POOL_F;
BEN.BEN_BNFT_PRVDR_POOL_F does not reference any database object
BEN.BEN_BNFT_PRVDR_POOL_F is referenced by following:
|
|
|