[Home] [Help] [Dependency Information]
Object Name: | BEN_MTCHG_RT_F |
---|---|
Object Type: | TABLE |
Owner: | BEN |
FND Design Data: | BEN.BEN_MTCHG_RT_F |
Subobject Name: | |
Status: | VALID |
BEN_MTCHG_RT_F identifies requirements for calculating matching contributions and describes calculation requirements unique to base rates that represent matching contributions. Multiple instances for a matching contribution may be necessary if the match varies according to the amount contributed according to the base rate. Matching rates are used specifically for employer contribution matches to employee contributions to 401(k) section profit sharing plans in the United States.
.
For example, if the employee contributes from 1% to 10% of pay the employer will match 50% up
to 6% of pay or a maximum of $5000.
.
1% is the from percent value.
10% is the to percent value.
50% is the percent value.
6% is the maximum percent of pay number.
$5000 is the maximum amount of pay number.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
BEN_MTCHG_RT_F_PK | NORMAL | UNIQUE | APPS_TS_TX_IDX |
MTCHG_RT_ID
EFFECTIVE_START_DATE EFFECTIVE_END_DATE |
BEN_MTCHG_RT_F_FK2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | COMP_LVL_FCTR_ID |
BEN_MTCHG_RT_F_FK3 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | BUSINESS_GROUP_ID |
BEN_MTCHG_RT_F_N3 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | ACTY_BASE_RT_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
MTCHG_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. | |
BUSINESS_GROUP_ID | NUMBER | (15) | Yes | Foreign Key to HR_ORGANIZATION_UNITS |
ORDR_NUM | NUMBER | (15) | Yes | Order number. |
NO_MX_MTCH_AMT_FLAG | VARCHAR2 | (30) | Yes | No Maximum Match Amount Y or N. |
NO_MX_PCT_OF_PY_NUM_FLAG | VARCHAR2 | (30) | Yes | No Maximum Percent Of Pay Number Y or N. |
CNTNU_MTCH_AFTR_MX_RL_FLAG | VARCHAR2 | (30) | Yes | Continue matching after maximum rule Y or N. |
NO_MX_AMT_OF_PY_NUM_FLAG | VARCHAR2 | (30) | Yes | No Maximum Amount Of Pay Number Y or N. |
COMP_LVL_FCTR_ID | NUMBER | (15) | Foreign Key to BEN_COMP_LVL_FCTR_F. | |
MTR_ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive Flexfield structure defining column. | |
MTR_ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
MTR_ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
MTR_ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
MTR_ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
MTR_ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
MTR_ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
MTR_ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
MTR_ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
MTR_ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
MTR_ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
MTR_ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
MTR_ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
MTR_ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
MTR_ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
MTR_ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
MTR_ATTRIBUTE16 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
MTR_ATTRIBUTE17 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
MTR_ATTRIBUTE18 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
MTR_ATTRIBUTE19 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
MTR_ATTRIBUTE20 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
MTR_ATTRIBUTE21 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
MTR_ATTRIBUTE22 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
MTR_ATTRIBUTE23 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
MTR_ATTRIBUTE24 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
MTR_ATTRIBUTE25 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
MTR_ATTRIBUTE26 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
MTR_ATTRIBUTE27 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
MTR_ATTRIBUTE28 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
MTR_ATTRIBUTE29 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
MTR_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. | |
FROM_PCT_VAL | NUMBER | From percent. | ||
TO_PCT_VAL | NUMBER | To percent value. | ||
PCT_VAL | NUMBER | Percent value. | ||
MX_AMT_OF_PY_NUM | NUMBER | Maximum amount of pay. | ||
MX_PCT_OF_PY_NUM | NUMBER | Maximum percent of pay. | ||
MX_MTCH_AMT | NUMBER | Maximum match amount. | ||
MN_MTCH_AMT | NUMBER | Minimum match amount. | ||
ACTY_BASE_RT_ID | NUMBER | (15) | Foreign Key to BEN_ACTY_BASE_RT_F. | |
MTCHG_RT_CALC_RL | NUMBER | (15) | Foreign key to FF_FORMULAS_F. |
Cut, paste (and edit) the following text to query this object:
SELECT MTCHG_RT_ID
, EFFECTIVE_START_DATE
, EFFECTIVE_END_DATE
, BUSINESS_GROUP_ID
, ORDR_NUM
, NO_MX_MTCH_AMT_FLAG
, NO_MX_PCT_OF_PY_NUM_FLAG
, CNTNU_MTCH_AFTR_MX_RL_FLAG
, NO_MX_AMT_OF_PY_NUM_FLAG
, COMP_LVL_FCTR_ID
, MTR_ATTRIBUTE_CATEGORY
, MTR_ATTRIBUTE1
, MTR_ATTRIBUTE2
, MTR_ATTRIBUTE3
, MTR_ATTRIBUTE4
, MTR_ATTRIBUTE5
, MTR_ATTRIBUTE6
, MTR_ATTRIBUTE7
, MTR_ATTRIBUTE8
, MTR_ATTRIBUTE9
, MTR_ATTRIBUTE10
, MTR_ATTRIBUTE11
, MTR_ATTRIBUTE12
, MTR_ATTRIBUTE13
, MTR_ATTRIBUTE14
, MTR_ATTRIBUTE15
, MTR_ATTRIBUTE16
, MTR_ATTRIBUTE17
, MTR_ATTRIBUTE18
, MTR_ATTRIBUTE19
, MTR_ATTRIBUTE20
, MTR_ATTRIBUTE21
, MTR_ATTRIBUTE22
, MTR_ATTRIBUTE23
, MTR_ATTRIBUTE24
, MTR_ATTRIBUTE25
, MTR_ATTRIBUTE26
, MTR_ATTRIBUTE27
, MTR_ATTRIBUTE28
, MTR_ATTRIBUTE29
, MTR_ATTRIBUTE30
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, CREATED_BY
, CREATION_DATE
, OBJECT_VERSION_NUMBER
, FROM_PCT_VAL
, TO_PCT_VAL
, PCT_VAL
, MX_AMT_OF_PY_NUM
, MX_PCT_OF_PY_NUM
, MX_MTCH_AMT
, MN_MTCH_AMT
, ACTY_BASE_RT_ID
, MTCHG_RT_CALC_RL
FROM BEN.BEN_MTCHG_RT_F;
BEN.BEN_MTCHG_RT_F does not reference any database object
BEN.BEN_MTCHG_RT_F is referenced by following:
|
|
|