[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | BEN_ACTY_BASE_RT_F |
|---|---|
| Object Type: | TABLE |
| Owner: | BEN |
| FND Design Data: |  BEN.BEN_ACTY_BASE_RT_F
|
| Subobject Name: | |
| Status: | VALID |
BEN_ACTY_BASE_RT_F identifies parameters which control how contributions into, distributions out of, or accrued benefits provided by comp objects are calculated. Activity Rates are maintained at many levels within the comp hierarchy, for example, program, plan, option in plan, plan type in program.
.
Examples are employee payroll contributions in the amount of $25.43 per month for a coverage option in a medical plan, employer payroll contributions in the amount of $35.77 per month based on participant's age of 25 , for each thousand dollars of life insurance coverage, and employer payroll distribution of $50.00 per month for flex credits.
| Tablespace: |  APPS_TS_TX_DATA |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
ACTY_BASE_RT_IDEFFECTIVE_START_DATEEFFECTIVE_END_DATE| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| BEN_ACTY_BASE_RT_F_PK | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
ACTY_BASE_RT_ID
EFFECTIVE_START_DATE
EFFECTIVE_END_DATE
|
| BEN_ACTY_BASE_RT_F_FK10 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
BUSINESS_GROUP_ID
|
| BEN_ACTY_BASE_RT_F_FK2 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
COMP_LVL_FCTR_ID
|
| BEN_ACTY_BASE_RT_F_N1 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
ELEMENT_TYPE_ID
|
| BEN_ACTY_BASE_RT_F_N10 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
RNDG_RL
|
| BEN_ACTY_BASE_RT_F_N11 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
PRTL_MO_EFF_DT_DET_RL
|
| BEN_ACTY_BASE_RT_F_N12 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
PRTL_MO_DET_MTHD_RL
|
| BEN_ACTY_BASE_RT_F_N13 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
VAL_CALC_RL
|
| BEN_ACTY_BASE_RT_F_N14 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
PARNT_ACTY_BASE_RT_ID
|
| BEN_ACTY_BASE_RT_F_N15 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
CMBN_PLIP_ID
|
| BEN_ACTY_BASE_RT_F_N16 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
OIPLIP_ID
|
| BEN_ACTY_BASE_RT_F_N17 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
ACTL_PREM_ID
|
| BEN_ACTY_BASE_RT_F_N18 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
OPT_ID
|
| BEN_ACTY_BASE_RT_F_N19 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
NAME
|
| BEN_ACTY_BASE_RT_F_N2 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
PGM_ID
|
| BEN_ACTY_BASE_RT_F_N3 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
PL_ID
|
| BEN_ACTY_BASE_RT_F_N4 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
OIPL_ID
|
| BEN_ACTY_BASE_RT_F_N5 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
PLIP_ID
|
| BEN_ACTY_BASE_RT_F_N6 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
PTIP_ID
|
| BEN_ACTY_BASE_RT_F_N7 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
CMBN_PTIP_ID
|
| BEN_ACTY_BASE_RT_F_N8 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
CMBN_PTIP_OPT_ID
|
| BEN_ACTY_BASE_RT_F_N9 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
VSTG_FOR_ACTY_RT_ID
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| ACTY_BASE_RT_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. | |
| USE_TO_CALC_NET_FLX_CR_FLAG | VARCHAR2 | (30) | Yes | Use to calculate net flexible credit Y or N. |
| ASN_ON_ENRT_FLAG | VARCHAR2 | (30) | Yes | Assign on Enrollment Y or N. |
| ABV_MX_ELCN_VAL_ALWD_FLAG | VARCHAR2 | (30) | Yes | Indicates whether maximum elections value allowed Yor N. |
| BLW_MN_ELCN_ALWD_FLAG | VARCHAR2 | (30) | Yes | Below minimum elections allowed Y or N. |
| DSPLY_ON_ENRT_FLAG | VARCHAR2 | (30) | Yes | Display on Enrollment Y or N. |
| USE_CALC_ACTY_BS_RT_FLAG | VARCHAR2 | (30) | Yes | Use Calculation Activity Base Rate Y or N. |
| USES_DED_SCHED_FLAG | VARCHAR2 | (30) | Yes | Uses Deduction Schedule Y or N. |
| USES_VARBL_RT_FLAG | VARCHAR2 | (30) | Yes | Uses Variable Rate Y or N. |
| VSTG_SCHED_APLS_FLAG | VARCHAR2 | (30) | Yes | Vesting Schedule Applies Y or N. |
| PROC_EACH_PP_DFLT_FLAG | VARCHAR2 | (30) | Yes | Process Each Pay Period Default Y or N. |
| PRDCT_FLX_CR_WHEN_ELIG_FLAG | VARCHAR2 | (30) | Yes | Predict flexible credit when eligible Y or N. |
| NO_STD_RT_USED_FLAG | VARCHAR2 | (30) | Yes | No Standard Rate Used Y or N. |
| USES_PYMT_SCHED_FLAG | VARCHAR2 | (30) | Yes | Uses Payment Schedule Y or N. |
| VAL_OVRID_ALWD_FLAG | VARCHAR2 | (30) | Yes | Value Override Allowed Y or N. |
| DFLT_FLAG | VARCHAR2 | (30) | Yes | Default Y or N. |
| NO_MX_ELCN_VAL_DFND_FLAG | VARCHAR2 | (30) | Yes | No Maximum Election Value Defined Y or N. |
| ENTR_VAL_AT_ENRT_FLAG | VARCHAR2 | (30) | Yes | Enter Value At Enrollment Y or N. |
| NO_MN_ELCN_VAL_DFND_FLAG | VARCHAR2 | (30) | Yes | No Minimum Election Value Defined Y or N. |
| ONLY_ONE_BAL_TYP_ALWD_FLAG | VARCHAR2 | (30) | Yes | Only One Balance Type Allowed Y or N. |
| ENTR_ANN_VAL_FLAG | VARCHAR2 | (30) | Yes | Enter Annual Value Y or N. |
| OIPLIP_ID | NUMBER | (15) | Foreign Key to BEN_OIPLIP_F. | |
| BUSINESS_GROUP_ID | NUMBER | (15) | Yes | Foreign Key to HR_ORGANIZATION_UNITS |
| ELE_RQD_FLAG | VARCHAR2 | (30) | Yes | Eligibility required Y or N. |
| ONE_ANN_PYMT_CD | VARCHAR2 | (30) | One annual payment code. | |
| PRORT_MN_ANN_ELCN_VAL_CD | VARCHAR2 | (30) | Prorate minimum annual election value code. | |
| PRORT_MN_ANN_ELCN_VAL_RL | NUMBER | (15) | Foreign key to FF_FORMULAS_F. | |
| PRORT_MX_ANN_ELCN_VAL_CD | VARCHAR2 | (30) | Prorate maximum annual election value code. | |
| PRORT_MX_ANN_ELCN_VAL_RL | NUMBER | (15) | Foreign key to FF_FORMULAS_F. | |
| ABR_ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive Flexfield structure defining column. | |
| ABR_ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
| ABR_ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
| ABR_ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
| ABR_ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
| ABR_ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
| ABR_ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
| ABR_ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
| ABR_ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
| ABR_ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
| ABR_ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
| ABR_ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
| ABR_ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
| ABR_ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
| ABR_ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
| ABR_ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
| ABR_ATTRIBUTE16 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
| ABR_ATTRIBUTE17 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
| ABR_ATTRIBUTE18 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
| ABR_ATTRIBUTE19 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
| ABR_ATTRIBUTE20 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
| ABR_ATTRIBUTE21 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
| ABR_ATTRIBUTE22 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
| ABR_ATTRIBUTE23 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
| ABR_ATTRIBUTE24 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
| ABR_ATTRIBUTE25 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
| ABR_ATTRIBUTE26 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
| ABR_ATTRIBUTE27 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
| ABR_ATTRIBUTE28 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
| ABR_ATTRIBUTE29 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
| ABR_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. | |
| ACTY_TYP_CD | VARCHAR2 | (30) | Activity type. | |
| RNDG_RL | NUMBER | (15) | Foreign key to FF_FORMULAS_F. | |
| PRTL_MO_EFF_DT_DET_RL | NUMBER | (15) | Foreign key to FF_FORMULAS_F. | |
| NAME | VARCHAR2 | (240) | Name of the activity base rate. | |
| RT_TYP_CD | VARCHAR2 | (30) | Rate type. | |
| BNFT_RT_TYP_CD | VARCHAR2 | (30) | Benefit rate type. | |
| TX_TYP_CD | VARCHAR2 | (30) | Tax type. | |
| PRTL_MO_DET_MTHD_RL | NUMBER | (15) | Foreign key to FF_FORMULAS_F. | |
| PARNT_CHLD_CD | VARCHAR2 | (30) | Parent or child. | |
| VAL_CALC_RL | NUMBER | (15) | Foreign key to FF_FORMULAS_F. | |
| RT_MLT_CD | VARCHAR2 | (30) | Rate multiply code. | |
| PARNT_ACTY_BASE_RT_ID | NUMBER | (15) | Foreign key to BEN_ACTY_BASE_RT_F. | |
| RCRRG_CD | VARCHAR2 | (30) | Recurring code. | |
| MN_ELCN_VAL | NUMBER | Minimum election value. | ||
| MX_ELCN_VAL | NUMBER | Maximum election value. | ||
| NNMNTRY_UOM | VARCHAR2 | (30) | Non-monentary unit of measure. | |
| VAL | NUMBER | Value. | ||
| INCRMT_ELCN_VAL | NUMBER | Increment election value. | ||
| RNDG_CD | VARCHAR2 | (30) | Rounding code. | |
| PRTL_MO_DET_MTHD_CD | VARCHAR2 | (30) | Partial month determination method. | |
| ACTY_BASE_RT_STAT_CD | VARCHAR2 | (30) | Activity base rate status. | |
| PROCG_SRC_CD | VARCHAR2 | (30) | Processing source. | |
| DFLT_VAL | NUMBER | Default value. | ||
| FRGN_ERG_DED_TYP_CD | VARCHAR2 | (30) | Foreign earnings or deduction. | |
| FRGN_ERG_DED_NAME | VARCHAR2 | (180) | Foreign earnings deduction name. | |
| FRGN_ERG_DED_IDENT | VARCHAR2 | (90) | Foreign earnings deduction identifier. | |
| PRTL_MO_EFF_DT_DET_CD | VARCHAR2 | (30) | Partial month effective date determination code. | |
| ANN_MN_ELCN_VAL | NUMBER | Annual maximum election value. | ||
| ANN_MX_ELCN_VAL | NUMBER | Annual minimum election value. | ||
| RT_USG_CD | VARCHAR2 | (30) | Rate usage. | |
| LWR_LMT_VAL | NUMBER | Lower limit value. | ||
| LWR_LMT_CALC_RL | NUMBER | (15) | Foreign key to FF_FORMULAS_F. | |
| UPR_LMT_VAL | NUMBER | Upper limit value. | ||
| UPR_LMT_CALC_RL | NUMBER | (15) | Foreign key to FF_FORMULAS_F. | |
| SUBJ_TO_IMPTD_INCM_FLAG | VARCHAR2 | (30) | Subject To Imputed Income Y or N. | |
| WSH_RL_DY_MO_NUM | NUMBER | (15) | Wash rule day of the month. | |
| INPUT_VALUE_ID | NUMBER | (9) | Foreign key to PAY_INPUT_VALUES_F. | |
| ELEMENT_TYPE_ID | NUMBER | (15) | Foreign key to PAY_ELEMENT_TYPES_F. | |
| CMBN_PLIP_ID | NUMBER | (15) | Foreign key to BEN_CMBN_PLIP_F. | |
| PGM_ID | NUMBER | (15) | Foreign key to BEN_PGM_F. | |
| PL_ID | NUMBER | (15) | Foreign Key to BEN_PL_F. | |
| OIPL_ID | NUMBER | (15) | Foreign Key to BEN_OIPL_F. | |
| PLIP_ID | NUMBER | (15) | Foreign key to BEN_PLIP_F. | |
| PTIP_ID | NUMBER | (15) | Foreign Key to BEN_PTIP_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. | |
| COMP_LVL_FCTR_ID | NUMBER | (15) | Foreign Key to BEN_COMP_LVL_FCTR_F. | |
| VSTG_FOR_ACTY_RT_ID | NUMBER | (15) | Foreign key to BEN_VSTG_FOR_ACTY_RT_F. | |
| PTD_COMP_LVL_FCTR_ID | NUMBER | (15) | Foreign key to BEN_PTD_COMP_LVL_FCTR_F. | |
| CLM_COMP_LVL_FCTR_ID | NUMBER | (15) | Foreign Key to BEN_CLM_COMP_LVL_FCTR_F. | |
| ACTL_PREM_ID | NUMBER | (15) | Foreign Key to BEN_ACTL_PREM_F. | |
| ASMT_TO_USE_CD | VARCHAR2 | (30) | Assignment to use. | |
| DET_PL_YTD_CNTRS_CD | VARCHAR2 | (30) | Determine plan year to date contributions. | |
| TTL_COMP_LVL_FCTR_ID | NUMBER | (15) | Foreign Key to BEN_COMP_LVL_FCTR. | |
| COST_ALLOCATION_KEYFLEX_ID | NUMBER | (15) | Foreign Key To PAY_COST_ALLOCATION_KEYFLEX. | |
| ALWS_CHG_CD | VARCHAR2 | (30) | Allows Change. | |
| ELE_ENTRY_VAL_CD | VARCHAR2 | (30) | Element Entry Code. | |
| INPUT_VA_CALC_RL | NUMBER | (15) | Foreign key to FF_FORMULAS_F. | |
| PAY_RATE_GRADE_RULE_ID | NUMBER | (15) | Grade point rate | |
| ORDR_NUM | NUMBER | (15) | Order Number | |
| OPT_ID | NUMBER | (15) | Foreign Key to BEN_OPT_F. | |
| SUB_ACTY_TYP_CD | VARCHAR2 | (30) | Sub Activity type Code. | |
| RATE_PERIODIZATION_CD | VARCHAR2 | (30) | Rate Periodization Code | |
| RATE_PERIODIZATION_RL | NUMBER | Rate Periodization Rule | ||
| MN_MX_ELCN_RL | NUMBER | (15) | Election Value Range Rule | |
| MAPPING_TABLE_NAME | VARCHAR2 | (60) | Mapping Table Name | |
| MAPPING_TABLE_PK_ID | NUMBER | (15) | Value of Primary Key column in the Mapping Table | |
| CONTEXT_PGM_ID | NUMBER | (15) | Program ID | |
| CONTEXT_PL_ID | NUMBER | (15) | Plan ID | |
| CONTEXT_OPT_ID | NUMBER | (15) | Option ID | |
| CURRENCY_DET_CD | VARCHAR2 | (30) | Element Determination Rule to get the Element Type | |
| ELEMENT_DET_RL | NUMBER | (15) | Determine Currency for the Person Rates record | |
| ABR_SEQ_NUM | NUMBER | (15) | Sequence Number |
Cut, paste (and edit) the following text to query this object:
SELECT ACTY_BASE_RT_ID
, EFFECTIVE_START_DATE
, EFFECTIVE_END_DATE
, USE_TO_CALC_NET_FLX_CR_FLAG
, ASN_ON_ENRT_FLAG
, ABV_MX_ELCN_VAL_ALWD_FLAG
, BLW_MN_ELCN_ALWD_FLAG
, DSPLY_ON_ENRT_FLAG
, USE_CALC_ACTY_BS_RT_FLAG
, USES_DED_SCHED_FLAG
, USES_VARBL_RT_FLAG
, VSTG_SCHED_APLS_FLAG
, PROC_EACH_PP_DFLT_FLAG
, PRDCT_FLX_CR_WHEN_ELIG_FLAG
, NO_STD_RT_USED_FLAG
, USES_PYMT_SCHED_FLAG
, VAL_OVRID_ALWD_FLAG
, DFLT_FLAG
, NO_MX_ELCN_VAL_DFND_FLAG
, ENTR_VAL_AT_ENRT_FLAG
, NO_MN_ELCN_VAL_DFND_FLAG
, ONLY_ONE_BAL_TYP_ALWD_FLAG
, ENTR_ANN_VAL_FLAG
, OIPLIP_ID
, BUSINESS_GROUP_ID
, ELE_RQD_FLAG
, ONE_ANN_PYMT_CD
, PRORT_MN_ANN_ELCN_VAL_CD
, PRORT_MN_ANN_ELCN_VAL_RL
, PRORT_MX_ANN_ELCN_VAL_CD
, PRORT_MX_ANN_ELCN_VAL_RL
, ABR_ATTRIBUTE_CATEGORY
, ABR_ATTRIBUTE1
, ABR_ATTRIBUTE2
, ABR_ATTRIBUTE3
, ABR_ATTRIBUTE4
, ABR_ATTRIBUTE5
, ABR_ATTRIBUTE6
, ABR_ATTRIBUTE7
, ABR_ATTRIBUTE8
, ABR_ATTRIBUTE9
, ABR_ATTRIBUTE10
, ABR_ATTRIBUTE11
, ABR_ATTRIBUTE12
, ABR_ATTRIBUTE13
, ABR_ATTRIBUTE14
, ABR_ATTRIBUTE15
, ABR_ATTRIBUTE16
, ABR_ATTRIBUTE17
, ABR_ATTRIBUTE18
, ABR_ATTRIBUTE19
, ABR_ATTRIBUTE20
, ABR_ATTRIBUTE21
, ABR_ATTRIBUTE22
, ABR_ATTRIBUTE23
, ABR_ATTRIBUTE24
, ABR_ATTRIBUTE25
, ABR_ATTRIBUTE26
, ABR_ATTRIBUTE27
, ABR_ATTRIBUTE28
, ABR_ATTRIBUTE29
, ABR_ATTRIBUTE30
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, CREATED_BY
, CREATION_DATE
, OBJECT_VERSION_NUMBER
, ACTY_TYP_CD
, RNDG_RL
, PRTL_MO_EFF_DT_DET_RL
, NAME
, RT_TYP_CD
, BNFT_RT_TYP_CD
, TX_TYP_CD
, PRTL_MO_DET_MTHD_RL
, PARNT_CHLD_CD
, VAL_CALC_RL
, RT_MLT_CD
, PARNT_ACTY_BASE_RT_ID
, RCRRG_CD
, MN_ELCN_VAL
, MX_ELCN_VAL
, NNMNTRY_UOM
, VAL
, INCRMT_ELCN_VAL
, RNDG_CD
, PRTL_MO_DET_MTHD_CD
, ACTY_BASE_RT_STAT_CD
, PROCG_SRC_CD
, DFLT_VAL
, FRGN_ERG_DED_TYP_CD
, FRGN_ERG_DED_NAME
, FRGN_ERG_DED_IDENT
, PRTL_MO_EFF_DT_DET_CD
, ANN_MN_ELCN_VAL
, ANN_MX_ELCN_VAL
, RT_USG_CD
, LWR_LMT_VAL
, LWR_LMT_CALC_RL
, UPR_LMT_VAL
, UPR_LMT_CALC_RL
, SUBJ_TO_IMPTD_INCM_FLAG
, WSH_RL_DY_MO_NUM
, INPUT_VALUE_ID
, ELEMENT_TYPE_ID
, CMBN_PLIP_ID
, PGM_ID
, PL_ID
, OIPL_ID
, PLIP_ID
, PTIP_ID
, CMBN_PTIP_ID
, CMBN_PTIP_OPT_ID
, COMP_LVL_FCTR_ID
, VSTG_FOR_ACTY_RT_ID
, PTD_COMP_LVL_FCTR_ID
, CLM_COMP_LVL_FCTR_ID
, ACTL_PREM_ID
, ASMT_TO_USE_CD
, DET_PL_YTD_CNTRS_CD
, TTL_COMP_LVL_FCTR_ID
, COST_ALLOCATION_KEYFLEX_ID
, ALWS_CHG_CD
, ELE_ENTRY_VAL_CD
, INPUT_VA_CALC_RL
, PAY_RATE_GRADE_RULE_ID
, ORDR_NUM
, OPT_ID
, SUB_ACTY_TYP_CD
, RATE_PERIODIZATION_CD
, RATE_PERIODIZATION_RL
, MN_MX_ELCN_RL
, MAPPING_TABLE_NAME
, MAPPING_TABLE_PK_ID
, CONTEXT_PGM_ID
, CONTEXT_PL_ID
, CONTEXT_OPT_ID
, CURRENCY_DET_CD
, ELEMENT_DET_RL
, ABR_SEQ_NUM
FROM BEN.BEN_ACTY_BASE_RT_F;
BEN.BEN_ACTY_BASE_RT_F does not reference any database object
BEN.BEN_ACTY_BASE_RT_F is referenced by following:
APPS
BEN_ACTY_BASE_RT_F
BEN_ACTY_BASE_RT_F_WHO
|
|
|
|