[Home] [Help] [Dependency Information]
Object Name: | BEN_PRTT_ASSOCD_INSTN_F |
---|---|
Object Type: | TABLE |
Owner: | BEN |
FND Design Data: | BEN.BEN_PRTT_ASSOCD_INSTN_F |
Subobject Name: | |
Status: | VALID |
BEN_PRTT_ASSOCD_INSTN_F identifies multiple values for reimbursement or other processing instructions. For example, if a person requests reimbursement for a higher amount than is currently available, each increment reimbursed of part of the requested value will be associated with each additional increment thus identifying the parts of the total payment.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
BEN_PRTT_ASSOCD_INSTN_F_PK | NORMAL | UNIQUE | APPS_TS_TX_IDX |
PRTT_ASSOCD_INSTN_ID
EFFECTIVE_START_DATE EFFECTIVE_END_DATE |
BEN_PRTT_ASSOCD_INSTN_F_FK1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | BUSINESS_GROUP_ID |
BEN_PRTT_ASSOCD_INSTN_F_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | SOURCE_ELEMENT_ENTRY_VALUE_ID |
BEN_PRTT_ASSOCD_INSTN_F_N2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | TARGET_ELEMENT_ENTRY_VALUE_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PRTT_ASSOCD_INSTN_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 |
TAKE_BOTH_FLAG | VARCHAR2 | (30) | Yes | Take Both Y or N. |
SOURCE_ELEMENT_ENTRY_VALUE_ID | NUMBER | (15) | Foreign key to PAY_ELEMENT_ENTRIES_F. | |
TARGET_ELEMENT_ENTRY_VALUE_ID | NUMBER | (15) | Foreign key to PAY_ELEMENT_ENTRIES_F. | |
PAI_ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive Flexfield structure defining column. | |
PAI_ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
PAI_ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
PAI_ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
PAI_ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
PAI_ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
PAI_ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
PAI_ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
PAI_ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
PAI_ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
PAI_ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
PAI_ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
PAI_ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
PAI_ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
PAI_ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
PAI_ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
PAI_ATTRIBUTE16 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
PAI_ATTRIBUTE17 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
PAI_ATTRIBUTE18 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
PAI_ATTRIBUTE19 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
PAI_ATTRIBUTE20 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
PAI_ATTRIBUTE21 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
PAI_ATTRIBUTE22 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
PAI_ATTRIBUTE23 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
PAI_ATTRIBUTE24 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
PAI_ATTRIBUTE25 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
PAI_ATTRIBUTE26 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
PAI_ATTRIBUTE27 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
PAI_ATTRIBUTE28 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
PAI_ATTRIBUTE29 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
PAI_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. |
Cut, paste (and edit) the following text to query this object:
SELECT PRTT_ASSOCD_INSTN_ID
, EFFECTIVE_START_DATE
, EFFECTIVE_END_DATE
, BUSINESS_GROUP_ID
, TAKE_BOTH_FLAG
, SOURCE_ELEMENT_ENTRY_VALUE_ID
, TARGET_ELEMENT_ENTRY_VALUE_ID
, PAI_ATTRIBUTE_CATEGORY
, PAI_ATTRIBUTE1
, PAI_ATTRIBUTE2
, PAI_ATTRIBUTE3
, PAI_ATTRIBUTE4
, PAI_ATTRIBUTE5
, PAI_ATTRIBUTE6
, PAI_ATTRIBUTE7
, PAI_ATTRIBUTE8
, PAI_ATTRIBUTE9
, PAI_ATTRIBUTE10
, PAI_ATTRIBUTE11
, PAI_ATTRIBUTE12
, PAI_ATTRIBUTE13
, PAI_ATTRIBUTE14
, PAI_ATTRIBUTE15
, PAI_ATTRIBUTE16
, PAI_ATTRIBUTE17
, PAI_ATTRIBUTE18
, PAI_ATTRIBUTE19
, PAI_ATTRIBUTE20
, PAI_ATTRIBUTE21
, PAI_ATTRIBUTE22
, PAI_ATTRIBUTE23
, PAI_ATTRIBUTE24
, PAI_ATTRIBUTE25
, PAI_ATTRIBUTE26
, PAI_ATTRIBUTE27
, PAI_ATTRIBUTE28
, PAI_ATTRIBUTE29
, PAI_ATTRIBUTE30
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, CREATED_BY
, CREATION_DATE
, OBJECT_VERSION_NUMBER
FROM BEN.BEN_PRTT_ASSOCD_INSTN_F;
BEN.BEN_PRTT_ASSOCD_INSTN_F does not reference any database object
BEN.BEN_PRTT_ASSOCD_INSTN_F is referenced by following:
|
|
|