[Home] [Help] [Dependency Information]
Object Name: | BEN_ACTL_PREM_F |
---|---|
Object Type: | TABLE |
Owner: | BEN |
FND Design Data: | BEN.BEN_ACTL_PREM_F |
Subobject Name: | |
Status: | VALID |
BEN_ACTL_PREM_F is the per participant or total volume/total coverage premium an insurance carrier charges the plan sponsor for a given benefit and can be recorded for a plan or option in plan. You can use the actual premium to caluclate the activity rate for employee and employer contributions. For example, the employee contribution may equal the actual premium times 40%, with the employer contribution equaling the actual premium times 60%.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
BEN_ACTL_PREM_F_PK | NORMAL | UNIQUE | APPS_TS_TX_IDX |
ACTL_PREM_ID
EFFECTIVE_START_DATE EFFECTIVE_END_DATE |
BEN_ACTL_PREM_F_FK1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | ORGANIZATION_ID |
BEN_ACTL_PREM_F_FK2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | COMP_LVL_FCTR_ID |
BEN_ACTL_PREM_F_FK3 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | BUSINESS_GROUP_ID |
BEN_ACTL_PREM_F_FK4 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | COST_ALLOCATION_KEYFLEX_ID |
BEN_ACTL_PREM_F_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | PL_ID |
BEN_ACTL_PREM_F_N2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | OIPL_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ACTL_PREM_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. | |
NAME | VARCHAR2 | (240) | Yes | Name of the actual premium. |
ACTY_REF_PERD_CD | VARCHAR2 | (30) | Yes | Activity reference period. |
UOM | VARCHAR2 | (30) | Yes | Unit of measure. |
CR_LKBK_CRNT_PY_ONLY_FLAG | VARCHAR2 | (30) | Yes | Credit lookback to current payroll only Y or N. |
BUSINESS_GROUP_ID | NUMBER | (15) | Yes | Foreign Key to HR_ORGANIZATION_UNITS |
APR_ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive Flexfield structure defining column. | |
APR_ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
APR_ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
APR_ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
APR_ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
APR_ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
APR_ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
APR_ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
APR_ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
APR_ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
APR_ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
APR_ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
APR_ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
APR_ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
APR_ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
APR_ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
APR_ATTRIBUTE16 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
APR_ATTRIBUTE17 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
APR_ATTRIBUTE18 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
APR_ATTRIBUTE19 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
APR_ATTRIBUTE20 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
APR_ATTRIBUTE21 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
APR_ATTRIBUTE22 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
APR_ATTRIBUTE23 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
APR_ATTRIBUTE24 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
APR_ATTRIBUTE25 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
APR_ATTRIBUTE26 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
APR_ATTRIBUTE27 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
APR_ATTRIBUTE28 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
APR_ATTRIBUTE29 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
APR_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. | |
PRTL_MO_DET_MTHD_CD | VARCHAR2 | (30) | Partial month determination method. | |
PRTL_MO_DET_MTHD_RL | NUMBER | (15) | Foreign key to FF_FORMULAS_F. | |
WSH_RL_DY_MO_NUM | NUMBER | (9) | Wash rule day of the month. | |
RT_TYP_CD | VARCHAR2 | (30) | Rate type. | |
BNFT_RT_TYP_CD | VARCHAR2 | (30) | Benefit rate type. | |
VAL | NUMBER | (15) | Value. | |
MLT_CD | VARCHAR2 | (30) | Multiply code. | |
PRDCT_CD | VARCHAR2 | (30) | Product. | |
RNDG_CD | VARCHAR2 | (30) | Rounding code. | |
RNDG_RL | NUMBER | (15) | Foreign key to FF_FORMULAS_F. | |
VAL_CALC_RL | NUMBER | (15) | Foreign key to FF_FORMULAS_F. | |
PREM_ASNMT_CD | VARCHAR2 | (30) | Premium assignment. | |
PREM_ASNMT_LVL_CD | VARCHAR2 | (30) | Premium assignment level. | |
ACTL_PREM_TYP_CD | VARCHAR2 | (30) | Actual premium type. | |
PREM_PYR_CD | VARCHAR2 | (30) | Premium payer. | |
CR_LKBK_VAL | NUMBER | Lookback value. | ||
CR_LKBK_UOM | VARCHAR2 | (30) | Lookback unit of measure. | |
PRSPTV_R_RTSPTV_CD | VARCHAR2 | (30) | Prospective or retrospective. | |
UPR_LMT_VAL | NUMBER | Upper limit value. | ||
UPR_LMT_CALC_RL | NUMBER | (15) | Foreign key to FF_FORMULAS_F. | |
LWR_LMT_VAL | NUMBER | Lower limit value. | ||
LWR_LMT_CALC_RL | NUMBER | (15) | Foreign key to FF_FORMULAS_F. | |
VRBL_RT_ADD_ON_CALC_RL | NUMBER | (15) | Foreign key to FF_FORMULAS_F. | |
COST_ALLOCATION_KEYFLEX_ID | NUMBER | (15) | Foreign key to PAY_COST_ALLOCATION_KEYFLEX_F. | |
ORGANIZATION_ID | NUMBER | (15) | Foreign key to HR_ORGANIZATION_UNITS. | |
OIPL_ID | NUMBER | (15) | Foreign Key to BEN_OIPL_F. | |
PL_ID | NUMBER | (15) | Foreign Key to BEN_PL_F. | |
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 ACTL_PREM_ID
, EFFECTIVE_START_DATE
, EFFECTIVE_END_DATE
, NAME
, ACTY_REF_PERD_CD
, UOM
, CR_LKBK_CRNT_PY_ONLY_FLAG
, BUSINESS_GROUP_ID
, APR_ATTRIBUTE_CATEGORY
, APR_ATTRIBUTE1
, APR_ATTRIBUTE2
, APR_ATTRIBUTE3
, APR_ATTRIBUTE4
, APR_ATTRIBUTE5
, APR_ATTRIBUTE6
, APR_ATTRIBUTE7
, APR_ATTRIBUTE8
, APR_ATTRIBUTE9
, APR_ATTRIBUTE10
, APR_ATTRIBUTE11
, APR_ATTRIBUTE12
, APR_ATTRIBUTE13
, APR_ATTRIBUTE14
, APR_ATTRIBUTE15
, APR_ATTRIBUTE16
, APR_ATTRIBUTE17
, APR_ATTRIBUTE18
, APR_ATTRIBUTE19
, APR_ATTRIBUTE20
, APR_ATTRIBUTE21
, APR_ATTRIBUTE22
, APR_ATTRIBUTE23
, APR_ATTRIBUTE24
, APR_ATTRIBUTE25
, APR_ATTRIBUTE26
, APR_ATTRIBUTE27
, APR_ATTRIBUTE28
, APR_ATTRIBUTE29
, APR_ATTRIBUTE30
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, CREATED_BY
, CREATION_DATE
, OBJECT_VERSION_NUMBER
, PRTL_MO_DET_MTHD_CD
, PRTL_MO_DET_MTHD_RL
, WSH_RL_DY_MO_NUM
, RT_TYP_CD
, BNFT_RT_TYP_CD
, VAL
, MLT_CD
, PRDCT_CD
, RNDG_CD
, RNDG_RL
, VAL_CALC_RL
, PREM_ASNMT_CD
, PREM_ASNMT_LVL_CD
, ACTL_PREM_TYP_CD
, PREM_PYR_CD
, CR_LKBK_VAL
, CR_LKBK_UOM
, PRSPTV_R_RTSPTV_CD
, UPR_LMT_VAL
, UPR_LMT_CALC_RL
, LWR_LMT_VAL
, LWR_LMT_CALC_RL
, VRBL_RT_ADD_ON_CALC_RL
, COST_ALLOCATION_KEYFLEX_ID
, ORGANIZATION_ID
, OIPL_ID
, PL_ID
, COMP_LVL_FCTR_ID
FROM BEN.BEN_ACTL_PREM_F;
BEN.BEN_ACTL_PREM_F does not reference any database object
BEN.BEN_ACTL_PREM_F is referenced by following:
|
|
|