[Home] [Help] [Dependency Information]
Object Name: | PAY_ASSIGNMENT_LINK_USAGES_F |
---|---|
Object Type: | TABLE |
Owner: | HR |
FND Design Data: | PAY.PAY_ASSIGNMENT_LINK_USAGES_F |
Subobject Name: | |
Status: | VALID |
PAY_ASSIGNMENT_LINK_USAGES_F is the DateTracked table that is the
intersection between PAY_ELEMENT_LINKS_F and PER_ALL_ASSIGNMENTS_F.
This is a denormalization of derived information to improve
performance when calculating whether an assignment is eligible for a
specific element. Currently, it is used to denormalize only the
PEOPLE_GROUP_ID flexfield eligibility criteria.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
PAY_ASSIGNMENT_LINK_USAGES_PK | NORMAL | UNIQUE | APPS_TS_TX_IDX |
ASSIGNMENT_LINK_USAGE_ID
EFFECTIVE_START_DATE EFFECTIVE_END_DATE |
PAY_ASSIGNMENT_LINK_USAGES_U50 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
ASSIGNMENT_ID
ELEMENT_LINK_ID EFFECTIVE_START_DATE EFFECTIVE_END_DATE |
PAY_ASSIGNMENT_LINK_USAGES_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | ELEMENT_LINK_ID |
PAY_ASSIGNMENT_LINK_USAGES_N2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | ASSIGNMENT_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ASSIGNMENT_LINK_USAGE_ID | NUMBER | (15) | Yes | System-generated primary key column. |
EFFECTIVE_START_DATE | DATE | Yes | Effective start date of eligibility. | |
EFFECTIVE_END_DATE | DATE | Yes | Effective end date of eligibility. | |
ELEMENT_LINK_ID | NUMBER | (9) | Yes | Foreign key to PAY_ELEMENT_LINKS_F. |
ASSIGNMENT_ID | NUMBER | (10) | Yes | Foreign key to PER_ALL_ASSIGNMENTS_F. |
Cut, paste (and edit) the following text to query this object:
SELECT ASSIGNMENT_LINK_USAGE_ID
, EFFECTIVE_START_DATE
, EFFECTIVE_END_DATE
, ELEMENT_LINK_ID
, ASSIGNMENT_ID
FROM HR.PAY_ASSIGNMENT_LINK_USAGES_F;
HR.PAY_ASSIGNMENT_LINK_USAGES_F does not reference any database object
HR.PAY_ASSIGNMENT_LINK_USAGES_F is referenced by following:
|
|
|