[Home] [Help] [Dependency Information]
Object Name: | BEN_PTD_LMT_F |
---|---|
Object Type: | TABLE |
Owner: | BEN |
FND Design Data: | BEN.BEN_PTD_LMT_F |
Subobject Name: | |
Status: | VALID |
BEN_PTD_LMT_F specifies cumulative limits for the results of contributions or distributions for a
participant. These values are compared to the balances derived from PAY_RUN_RESULT_VALUES for the periods specified. Government regulations often limit the maximum amount that can be contributed. The period to date limit is often based on plan year to date or calendar year to date balances.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
BEN_PTD_LMT_F_PK | NORMAL | UNIQUE | APPS_TS_TX_IDX |
PTD_LMT_ID
EFFECTIVE_END_DATE EFFECTIVE_START_DATE |
BEN_PTD_LMT_F_FK1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | BUSINESS_GROUP_ID |
BEN_PTD_LMT_F_FK3 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | BALANCE_TYPE_ID |
BEN_PTD_LMT_F_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | PTD_LMT_CALC_RL |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PTD_LMT_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 period to date limit. |
BUSINESS_GROUP_ID | NUMBER | (15) | Yes | Foreign Key to HR_ORGANIZATION_UNITS |
LMT_DET_CD | VARCHAR2 | (30) | Yes | Limit determination code. |
COMP_LVL_FCTR_ID | NUMBER | (15) | Foreign Key to BEN_COMP_LVL_FCTR_F. | |
PDL_ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive Flexfield structure defining column. | |
PDL_ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
PDL_ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
PDL_ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
PDL_ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
PDL_ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
PDL_ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
PDL_ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
PDL_ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
PDL_ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
PDL_ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
PDL_ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
PDL_ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
PDL_ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
PDL_ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
PDL_ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
PDL_ATTRIBUTE16 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
PDL_ATTRIBUTE17 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
PDL_ATTRIBUTE18 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
PDL_ATTRIBUTE19 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
PDL_ATTRIBUTE20 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
PDL_ATTRIBUTE21 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
PDL_ATTRIBUTE22 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
PDL_ATTRIBUTE23 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
PDL_ATTRIBUTE24 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
PDL_ATTRIBUTE25 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
PDL_ATTRIBUTE26 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
PDL_ATTRIBUTE27 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
PDL_ATTRIBUTE28 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
PDL_ATTRIBUTE29 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
PDL_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. | |
BALANCE_TYPE_ID | NUMBER | (15) | Foreign key to PAY_BALANCE_TYPES_F. | |
MX_COMP_TO_CNSDR | NUMBER | Maximum compensation to consider. | ||
MX_VAL | NUMBER | Maximum value. | ||
MX_PCT_VAL | NUMBER | Maximum percent value. | ||
PTD_LMT_CALC_RL | NUMBER | (15) | Foreign key to FF_FORMULAS_F. |
Cut, paste (and edit) the following text to query this object:
SELECT PTD_LMT_ID
, EFFECTIVE_START_DATE
, EFFECTIVE_END_DATE
, NAME
, BUSINESS_GROUP_ID
, LMT_DET_CD
, COMP_LVL_FCTR_ID
, PDL_ATTRIBUTE_CATEGORY
, PDL_ATTRIBUTE1
, PDL_ATTRIBUTE2
, PDL_ATTRIBUTE3
, PDL_ATTRIBUTE4
, PDL_ATTRIBUTE5
, PDL_ATTRIBUTE6
, PDL_ATTRIBUTE7
, PDL_ATTRIBUTE8
, PDL_ATTRIBUTE9
, PDL_ATTRIBUTE10
, PDL_ATTRIBUTE11
, PDL_ATTRIBUTE12
, PDL_ATTRIBUTE13
, PDL_ATTRIBUTE14
, PDL_ATTRIBUTE15
, PDL_ATTRIBUTE16
, PDL_ATTRIBUTE17
, PDL_ATTRIBUTE18
, PDL_ATTRIBUTE19
, PDL_ATTRIBUTE20
, PDL_ATTRIBUTE21
, PDL_ATTRIBUTE22
, PDL_ATTRIBUTE23
, PDL_ATTRIBUTE24
, PDL_ATTRIBUTE25
, PDL_ATTRIBUTE26
, PDL_ATTRIBUTE27
, PDL_ATTRIBUTE28
, PDL_ATTRIBUTE29
, PDL_ATTRIBUTE30
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, CREATED_BY
, CREATION_DATE
, OBJECT_VERSION_NUMBER
, BALANCE_TYPE_ID
, MX_COMP_TO_CNSDR
, MX_VAL
, MX_PCT_VAL
, PTD_LMT_CALC_RL
FROM BEN.BEN_PTD_LMT_F;
BEN.BEN_PTD_LMT_F does not reference any database object
BEN.BEN_PTD_LMT_F is referenced by following:
|
|
|