[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | PAY_ELEMENT_ENTRIES_F |
|---|---|
| Object Type: | TABLE |
| Owner: | HR |
| FND Design Data: |  PAY.PAY_ELEMENT_ENTRIES_F
|
| Subobject Name: | |
| Status: | VALID |
PAY_ELEMENT_ENTRIES_F is the DateTracked table that holds the list of
element entries for each assignment. The actual values for each entry
are held in PAY_ELEMENT_ENTRY_VALUES_F.
| Tablespace: |  APPS_TS_TX_DATA |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
ELEMENT_ENTRY_IDEFFECTIVE_START_DATEEFFECTIVE_END_DATE| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| PAY_ELEMENT_ENTRIES_F_PK | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
ELEMENT_ENTRY_ID
EFFECTIVE_START_DATE
EFFECTIVE_END_DATE
|
| PAY_ELEMENT_ENTRIES_F_FK1 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
COST_ALLOCATION_KEYFLEX_ID
|
| PAY_ELEMENT_ENTRIES_F_FK3 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
UPDATING_ACTION_ID
|
| PAY_ELEMENT_ENTRIES_F_N4 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
ELEMENT_LINK_ID
ASSIGNMENT_ID
|
| PAY_ELEMENT_ENTRIES_F_N5 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
ORIGINAL_ENTRY_ID
|
| PAY_ELEMENT_ENTRIES_F_N50 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
ASSIGNMENT_ID
ENTRY_TYPE
EFFECTIVE_START_DATE
EFFECTIVE_END_DATE
|
| PAY_ELEMENT_ENTRIES_F_N51 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
ASSIGNMENT_ID
ELEMENT_LINK_ID
EFFECTIVE_START_DATE
EFFECTIVE_END_DATE
|
| PAY_ELEMENT_ENTRIES_F_N52 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
PERSONAL_PAYMENT_METHOD_ID
|
| PAY_ELEMENT_ENTRIES_F_N53 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
ELEMENT_TYPE_ID
ASSIGNMENT_ID
|
| PAY_ELEMENT_ENTRIES_F_N6 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
CREATOR_ID
CREATOR_TYPE
|
| Table | |
Foreign Table | Foreign Key Column | PAY_ELEMENT_ENTRIES_F |  |
PAY_ASSIGNMENT_ACTIONS
|
PAY_ELEMENT_ENTRIES_F UPDATING_ACTION_ID | PAY_ELEMENT_ENTRIES_F | |
PAY_COST_ALLOCATION_KEYFLEX
|
PAY_ELEMENT_ENTRIES_F COST_ALLOCATION_KEYFLEX_ID |
|---|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| ELEMENT_ENTRY_ID | NUMBER | (15) | Yes | System-generated primary key column. |
| EFFECTIVE_START_DATE | DATE | Yes | Effective start date for an element entry. | |
| EFFECTIVE_END_DATE | DATE | Yes | Effective end date for an element entry. | |
| COST_ALLOCATION_KEYFLEX_ID | NUMBER | (9) | Foreign key to PAY_COST_ALLOCATION_KEYFLEX. | |
| ASSIGNMENT_ID | NUMBER | (10) | Yes | Foreign key to PER_ALL_ASSIGNMENTS_F. |
| UPDATING_ACTION_ID | NUMBER | (15) | Foreign key to PAY_ASSIGNMENT_ACTIONS. | |
| ELEMENT_LINK_ID | NUMBER | (9) | Yes | Foreign key to PAY_ELEMENT_LINKS_F. All entries are subject to a specific element link rule. |
| ORIGINAL_ENTRY_ID | NUMBER | (15) | Foreign key to PAY_ELEMENT_ENTRIES_F (ELEMENT_ENTRY_ID). | |
| CREATOR_TYPE | VARCHAR2 | (30) | Yes | Sub-system responsible for maintaining an element entry. (Validated by a lookup). |
| ENTRY_TYPE | VARCHAR2 | (30) | Yes | Sub-type for an element entry. (Validated by a lookup). |
| COMMENT_ID | NUMBER | (15) | Foreign key to HR_COMMENTS. | |
| CREATOR_ID | NUMBER | (15) | Process responsible for creating an element entry. | |
| REASON | VARCHAR2 | (30) | Reason for element entry. (Validated by a lookup). | |
| TARGET_ENTRY_ID | NUMBER | (15) | Foreign key to PAY_ELEMENT_ENTRIES_F (ELEMENT_ENTRY_ID). | |
| SOURCE_ID | NUMBER | (15) | Process responsible for maintaining an element entry. | |
| ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive flexfield structure definition column. | |
| ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE16 | VARCHAR2 | (150) | Descriptive flexfield column. | |
| ATTRIBUTE17 | VARCHAR2 | (150) | Descriptive flexfield column. | |
| ATTRIBUTE18 | VARCHAR2 | (150) | Descriptive flexfield column. | |
| ATTRIBUTE19 | VARCHAR2 | (150) | Descriptive flexfield column. | |
| ATTRIBUTE20 | VARCHAR2 | (150) | Descriptive flexfield column. | |
| ENTRY_INFORMATION_CATEGORY | VARCHAR2 | (30) | Developer descriptive flexfield column. | |
| ENTRY_INFORMATION1 | VARCHAR2 | (150) | Developer descriptive flexfield column. | |
| ENTRY_INFORMATION2 | VARCHAR2 | (150) | Developer descriptive flexfield column. | |
| ENTRY_INFORMATION3 | VARCHAR2 | (150) | Developer descriptive flexfield column. | |
| ENTRY_INFORMATION4 | VARCHAR2 | (150) | Developer descriptive flexfield column. | |
| ENTRY_INFORMATION5 | VARCHAR2 | (150) | Developer descriptive flexfield column. | |
| ENTRY_INFORMATION6 | VARCHAR2 | (150) | Developer descriptive flexfield column. | |
| ENTRY_INFORMATION7 | VARCHAR2 | (150) | Developer descriptive flexfield column. | |
| ENTRY_INFORMATION8 | VARCHAR2 | (150) | Developer descriptive flexfield column. | |
| ENTRY_INFORMATION9 | VARCHAR2 | (150) | Developer descriptive flexfield column. | |
| ENTRY_INFORMATION10 | VARCHAR2 | (150) | Developer descriptive flexfield column. | |
| ENTRY_INFORMATION11 | VARCHAR2 | (150) | Developer descriptive flexfield column. | |
| ENTRY_INFORMATION12 | VARCHAR2 | (150) | Developer descriptive flexfield column. | |
| ENTRY_INFORMATION13 | VARCHAR2 | (150) | Developer descriptive flexfield column. | |
| ENTRY_INFORMATION14 | VARCHAR2 | (150) | Developer descriptive flexfield column. | |
| ENTRY_INFORMATION15 | VARCHAR2 | (150) | Developer descriptive flexfield column. | |
| ENTRY_INFORMATION16 | VARCHAR2 | (150) | Developer descriptive flexfield column. | |
| ENTRY_INFORMATION17 | VARCHAR2 | (150) | Developer descriptive flexfield column. | |
| ENTRY_INFORMATION18 | VARCHAR2 | (150) | Developer descriptive flexfield column. | |
| ENTRY_INFORMATION19 | VARCHAR2 | (150) | Developer descriptive flexfield column. | |
| ENTRY_INFORMATION20 | VARCHAR2 | (150) | Developer descriptive flexfield column. | |
| ENTRY_INFORMATION21 | VARCHAR2 | (150) | Developer descriptive flexfield column. | |
| ENTRY_INFORMATION22 | VARCHAR2 | (150) | Developer descriptive flexfield column. | |
| ENTRY_INFORMATION23 | VARCHAR2 | (150) | Developer descriptive flexfield column. | |
| ENTRY_INFORMATION24 | VARCHAR2 | (150) | Developer descriptive flexfield column. | |
| ENTRY_INFORMATION25 | VARCHAR2 | (150) | Developer descriptive flexfield column. | |
| ENTRY_INFORMATION26 | VARCHAR2 | (150) | Developer descriptive flexfield column. | |
| ENTRY_INFORMATION27 | VARCHAR2 | (150) | Developer descriptive flexfield column. | |
| ENTRY_INFORMATION28 | VARCHAR2 | (150) | Developer descriptive flexfield column. | |
| ENTRY_INFORMATION29 | VARCHAR2 | (150) | Developer descriptive flexfield column. | |
| ENTRY_INFORMATION30 | VARCHAR2 | (150) | Developer descriptive flexfield 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. | ||
| SUBPRIORITY | NUMBER | (9) | Used to determine run processing order of entries of same priority. | |
| PERSONAL_PAYMENT_METHOD_ID | NUMBER | (9) | Foreign key to PAY_PERSONAL_PAYMENT_METHODS | |
| DATE_EARNED | DATE | Date earned for entry - used for mid-period GRE change. | ||
| OBJECT_VERSION_NUMBER | NUMBER | (9) | System-generated version of row. Increments by one with each update. | |
| BALANCE_ADJ_COST_FLAG | VARCHAR2 | (30) | Indicates whether a balance adjustment is to be costed. | |
| SOURCE_ASG_ACTION_ID | NUMBER | (15) | Foreign key to PAY_ASSIGNMENT_ACTIONS. Identifies the source entries assignment action id. | |
| SOURCE_LINK_ID | NUMBER | (9) | Foreign key to PAY_ELEMENT_LINKS_F. Identifies the source entries element link id. | |
| SOURCE_TRIGGER_ENTRY | NUMBER | (15) | The element entry responsible for triggering a separate action. | |
| SOURCE_PERIOD | NUMBER | (15) | Source Period of element entry | |
| SOURCE_RUN_TYPE | NUMBER | (9) | Source Run Type of element entry | |
| UPDATING_ACTION_TYPE | VARCHAR2 | (30) | Action Type causing the update | |
| SOURCE_START_DATE | DATE | Identifies the start of a date range the source relates to e.g. used for proration | ||
| SOURCE_END_DATE | DATE | Identifies the end of a date range the source relates to e.g. used for proration | ||
| ELEMENT_TYPE_ID | NUMBER | (9) | Foreign key to PAY_ELEMENT_TYPES_F | |
| ALL_ENTRY_VALUES_NULL | VARCHAR2 | (30) | Equals 'Y' when all the values for an entry are NULL. If one or more of the entry values are NOT NULL, or if there are no values for the entry, then this column will be NULL. | |
| LABEL_IDENTIFIER | VARCHAR2 | (30) | Label Identifier | |
| PREV_UPD_ACTION_ID | NUMBER | (15) | Updating action ID value |
Cut, paste (and edit) the following text to query this object:
SELECT ELEMENT_ENTRY_ID
, EFFECTIVE_START_DATE
, EFFECTIVE_END_DATE
, COST_ALLOCATION_KEYFLEX_ID
, ASSIGNMENT_ID
, UPDATING_ACTION_ID
, ELEMENT_LINK_ID
, ORIGINAL_ENTRY_ID
, CREATOR_TYPE
, ENTRY_TYPE
, COMMENT_ID
, CREATOR_ID
, REASON
, TARGET_ENTRY_ID
, SOURCE_ID
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, ATTRIBUTE16
, ATTRIBUTE17
, ATTRIBUTE18
, ATTRIBUTE19
, ATTRIBUTE20
, ENTRY_INFORMATION_CATEGORY
, ENTRY_INFORMATION1
, ENTRY_INFORMATION2
, ENTRY_INFORMATION3
, ENTRY_INFORMATION4
, ENTRY_INFORMATION5
, ENTRY_INFORMATION6
, ENTRY_INFORMATION7
, ENTRY_INFORMATION8
, ENTRY_INFORMATION9
, ENTRY_INFORMATION10
, ENTRY_INFORMATION11
, ENTRY_INFORMATION12
, ENTRY_INFORMATION13
, ENTRY_INFORMATION14
, ENTRY_INFORMATION15
, ENTRY_INFORMATION16
, ENTRY_INFORMATION17
, ENTRY_INFORMATION18
, ENTRY_INFORMATION19
, ENTRY_INFORMATION20
, ENTRY_INFORMATION21
, ENTRY_INFORMATION22
, ENTRY_INFORMATION23
, ENTRY_INFORMATION24
, ENTRY_INFORMATION25
, ENTRY_INFORMATION26
, ENTRY_INFORMATION27
, ENTRY_INFORMATION28
, ENTRY_INFORMATION29
, ENTRY_INFORMATION30
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, CREATED_BY
, CREATION_DATE
, SUBPRIORITY
, PERSONAL_PAYMENT_METHOD_ID
, DATE_EARNED
, OBJECT_VERSION_NUMBER
, BALANCE_ADJ_COST_FLAG
, SOURCE_ASG_ACTION_ID
, SOURCE_LINK_ID
, SOURCE_TRIGGER_ENTRY
, SOURCE_PERIOD
, SOURCE_RUN_TYPE
, UPDATING_ACTION_TYPE
, SOURCE_START_DATE
, SOURCE_END_DATE
, ELEMENT_TYPE_ID
, ALL_ENTRY_VALUES_NULL
, LABEL_IDENTIFIER
, PREV_UPD_ACTION_ID
FROM HR.PAY_ELEMENT_ENTRIES_F;
HR.PAY_ELEMENT_ENTRIES_F does not reference any database object
HR.PAY_ELEMENT_ENTRIES_F is referenced by following:
HR
PAY_ELEMENT_ENTRIES_F#
|
|
|
|