[Home] [Help] [Dependency Information]
Object Name: | BEN_BNFT_PRVDD_LDGR_F |
---|---|
Object Type: | TABLE |
Owner: | BEN |
FND Design Data: | BEN.BEN_BNFT_PRVDD_LDGR_F |
Subobject Name: | |
Status: | VALID |
BEN_BNFT_PRVDD_LDGR_F is the ledger for a participant and a benefit provider pool. The ledger shows:
1) how many credits were provided by the pool.
2) how many credits were used by the participant as a result of him or her selecting one or more plans or options in plans that are part of the benefit pool.
3) how many credits were forfeited according to the restrictions of the pool.
4) how much was remaining and thus distributed as cash to the participant.
.
The ledger should always balance to zero.
.
The name of the ledger is populated by the benefit pool creation process
which creates a ledger for the pool. The name of the ledger is the name of the
compensation object, for example, program, plan type in program, plan in program, option in plan, plus the name of the person associated with the ledger, plus the value of the ledger column in benefit pool ledger definition.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
BEN_BNFT_PRVDD_LDGR_F_PK | NORMAL | UNIQUE | APPS_TS_TX_IDX |
BNFT_PRVDD_LDGR_ID
EFFECTIVE_START_DATE EFFECTIVE_END_DATE |
BEN_BNFT_PRVDD_LDGR_F_FK1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | PER_IN_LER_ID |
BEN_BNFT_PRVDD_LDGR_F_FK2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | BUSINESS_GROUP_ID |
BEN_BNFT_PRVDD_LDGR_F_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | ACTY_BASE_RT_ID |
BEN_BNFT_PRVDD_LDGR_F_N2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | BNFT_PRVDR_POOL_ID |
BEN_BNFT_PRVDD_LDGR_F_N3 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | PRTT_ENRT_RSLT_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
BNFT_PRVDD_LDGR_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. | |
PRTT_RO_OF_UNUSD_AMT_FLAG | VARCHAR2 | (30) | Yes | Participant Rollover Of Unsused Amount Y or N. |
PER_IN_LER_ID | NUMBER | (15) | Yes | Foreign Key to BEN_PER_IN_LER. |
ACTY_BASE_RT_ID | NUMBER | (15) | Yes | Foreign Key to BEN_ACTY_BASE_RT_F. |
BUSINESS_GROUP_ID | NUMBER | (15) | Yes | Foreign Key to HR_ORGANIZATION_UNITS |
BPL_ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive Flexfield structure defining column. | |
BPL_ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
BPL_ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
BPL_ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
BPL_ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
BPL_ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
BPL_ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
BPL_ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
BPL_ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
BPL_ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
BPL_ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
BPL_ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
BPL_ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
BPL_ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
BPL_ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
BPL_ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
BPL_ATTRIBUTE16 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
BPL_ATTRIBUTE17 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
BPL_ATTRIBUTE18 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
BPL_ATTRIBUTE19 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
BPL_ATTRIBUTE20 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
BPL_ATTRIBUTE21 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
BPL_ATTRIBUTE22 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
BPL_ATTRIBUTE23 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
BPL_ATTRIBUTE24 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
BPL_ATTRIBUTE25 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
BPL_ATTRIBUTE26 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
BPL_ATTRIBUTE27 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
BPL_ATTRIBUTE28 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
BPL_ATTRIBUTE29 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
BPL_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. | |
FRFTD_VAL | NUMBER | Forfeited value. | ||
PRVDD_VAL | NUMBER | Provided value. | ||
RLD_UP_VAL | NUMBER | Rolled up value. | ||
USED_VAL | NUMBER | Used value. | ||
CASH_RECD_VAL | NUMBER | Cash received. | ||
BNFT_PRVDR_POOL_ID | NUMBER | (15) | Foreign key to BEN_BNFT_PRVDR_POOL_F. | |
PRTT_ENRT_RSLT_ID | NUMBER | (15) | Foreign key to BEN_PRTT_ENRT_RSLT_F. | |
ACTY_REF_PERD_CD | VARCHAR2 | (30) | Activity reference period. | |
CMCD_FRFTD_VAL | NUMBER | Communicated forfeited value. | ||
CMCD_PRVDD_VAL | NUMBER | Communicated provided value. | ||
CMCD_RLD_UP_VAL | NUMBER | Communicated rolled up value. | ||
CMCD_USED_VAL | NUMBER | Communicated used value. | ||
CMCD_CASH_RECD_VAL | NUMBER | Communicated cash received. | ||
CMCD_REF_PERD_CD | VARCHAR2 | (30) | Communicated reference period. | |
ANN_FRFTD_VAL | NUMBER | Annual forfeited value. | ||
ANN_PRVDD_VAL | NUMBER | Annual provided value. | ||
ANN_RLD_UP_VAL | NUMBER | Annual rolled up value. | ||
ANN_USED_VAL | NUMBER | Annual used value. | ||
ANN_CASH_RECD_VAL | NUMBER | Annual cash received. |
Cut, paste (and edit) the following text to query this object:
SELECT BNFT_PRVDD_LDGR_ID
, EFFECTIVE_START_DATE
, EFFECTIVE_END_DATE
, PRTT_RO_OF_UNUSD_AMT_FLAG
, PER_IN_LER_ID
, ACTY_BASE_RT_ID
, BUSINESS_GROUP_ID
, BPL_ATTRIBUTE_CATEGORY
, BPL_ATTRIBUTE1
, BPL_ATTRIBUTE2
, BPL_ATTRIBUTE3
, BPL_ATTRIBUTE4
, BPL_ATTRIBUTE5
, BPL_ATTRIBUTE6
, BPL_ATTRIBUTE7
, BPL_ATTRIBUTE8
, BPL_ATTRIBUTE9
, BPL_ATTRIBUTE10
, BPL_ATTRIBUTE11
, BPL_ATTRIBUTE12
, BPL_ATTRIBUTE13
, BPL_ATTRIBUTE14
, BPL_ATTRIBUTE15
, BPL_ATTRIBUTE16
, BPL_ATTRIBUTE17
, BPL_ATTRIBUTE18
, BPL_ATTRIBUTE19
, BPL_ATTRIBUTE20
, BPL_ATTRIBUTE21
, BPL_ATTRIBUTE22
, BPL_ATTRIBUTE23
, BPL_ATTRIBUTE24
, BPL_ATTRIBUTE25
, BPL_ATTRIBUTE26
, BPL_ATTRIBUTE27
, BPL_ATTRIBUTE28
, BPL_ATTRIBUTE29
, BPL_ATTRIBUTE30
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, CREATED_BY
, CREATION_DATE
, OBJECT_VERSION_NUMBER
, FRFTD_VAL
, PRVDD_VAL
, RLD_UP_VAL
, USED_VAL
, CASH_RECD_VAL
, BNFT_PRVDR_POOL_ID
, PRTT_ENRT_RSLT_ID
, ACTY_REF_PERD_CD
, CMCD_FRFTD_VAL
, CMCD_PRVDD_VAL
, CMCD_RLD_UP_VAL
, CMCD_USED_VAL
, CMCD_CASH_RECD_VAL
, CMCD_REF_PERD_CD
, ANN_FRFTD_VAL
, ANN_PRVDD_VAL
, ANN_RLD_UP_VAL
, ANN_USED_VAL
, ANN_CASH_RECD_VAL
FROM BEN.BEN_BNFT_PRVDD_LDGR_F;
BEN.BEN_BNFT_PRVDD_LDGR_F does not reference any database object
BEN.BEN_BNFT_PRVDD_LDGR_F is referenced by following:
|
|
|