DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.HR_H2PI_ELEMENT_ENTRIES_V

Object Details
Object Name: HR_H2PI_ELEMENT_ENTRIES_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewPER.HR_H2PI_ELEMENT_ENTRIES_V
Subobject Name:
Status: VALID

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

[View Source]

Columns
Name Datatype Length Mandatory Comments
LAST_UPD_DATE DATE

Last update date.
BUSINESS_GROUP_ID NUMBER (15) Yes Foreign key to HR_ORGANIZATION_UNITS.
ELEMENT_ENTRY_ID NUMBER (15) Yes System-generated primary key column.
PERSON_ID NUMBER (10) Yes Foreign key to PER_PEOPLE.
EFFECTIVE_START_DATE DATE
Yes Effective start date for an element entry.
EFFECTIVE_END_DATE DATE
Yes Effective end date for an element entry.
ASSIGNMENT_ID NUMBER (10) Yes Foreign key to PER_ALL_ASSIGNMENTS_F.
ELEMENT_LINK_ID NUMBER (9) Yes Foreign key to PAY_ELEMENT_LINKS_F. All entries are subject to a specific element link rule.
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).
DATE_EARNED DATE

Date earned for entry - used for mid-period GRE change.
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive flexfield structure defining column.
ATTRIBUTE1 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE2 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE3 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE4 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE5 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE6 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE7 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE8 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE9 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE10 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE11 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE12 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE13 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE14 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE15 VARCHAR2 (150)
Descriptive flexfield column.
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.
CONCATENATED_SEGMENTS VARCHAR2 (2000)
Key flexfield segment column.
ID_FLEX_NUM NUMBER (15)
Key flexfield structure foreign key.
SUMMARY_FLAG VARCHAR2 (1)
Key flexfield summary flag.
ENABLED_FLAG VARCHAR2 (1)
Key flexfield enabled flag.
START_DATE_ACTIVE DATE

Date before which key flexfield combination is invalid.
END_DATE_ACTIVE DATE

Date after which key flexfield combination is invalid.
SEGMENT1 VARCHAR2 (60)
Key flexfield segment column.
SEGMENT2 VARCHAR2 (60)
Key flexfield segment column.
SEGMENT3 VARCHAR2 (60)
Key flexfield segment column.
SEGMENT4 VARCHAR2 (60)
Key flexfield segment column.
SEGMENT5 VARCHAR2 (60)
Key flexfield segment column.
SEGMENT6 VARCHAR2 (60)
Key flexfield segment column.
SEGMENT7 VARCHAR2 (60)
Key flexfield segment column.
SEGMENT8 VARCHAR2 (60)
Key flexfield segment column.
SEGMENT9 VARCHAR2 (60)
Key flexfield segment column.
SEGMENT10 VARCHAR2 (60)
Key flexfield segment column.
SEGMENT11 VARCHAR2 (60)
Key flexfield segment column.
SEGMENT12 VARCHAR2 (60)
Key flexfield segment column.
SEGMENT13 VARCHAR2 (60)
Key flexfield segment column.
SEGMENT14 VARCHAR2 (60)
Key flexfield segment column.
SEGMENT15 VARCHAR2 (60)
Key flexfield segment column.
SEGMENT16 VARCHAR2 (60)
Key flexfield segment column.
SEGMENT17 VARCHAR2 (60)
Key flexfield segment column.
SEGMENT18 VARCHAR2 (60)
Key flexfield segment column.
SEGMENT19 VARCHAR2 (60)
Key flexfield segment column.
SEGMENT20 VARCHAR2 (60)
Key flexfield segment column.
SEGMENT21 VARCHAR2 (60)
Key flexfield segment column.
SEGMENT22 VARCHAR2 (60)
Key flexfield segment column.
SEGMENT23 VARCHAR2 (60)
Key flexfield segment column.
SEGMENT24 VARCHAR2 (60)
Key flexfield segment column.
SEGMENT25 VARCHAR2 (60)
Key flexfield segment column.
SEGMENT26 VARCHAR2 (60)
Key flexfield segment column.
SEGMENT27 VARCHAR2 (60)
Key flexfield segment column.
SEGMENT28 VARCHAR2 (60)
Key flexfield segment column.
SEGMENT29 VARCHAR2 (60)
Key flexfield segment column.
SEGMENT30 VARCHAR2 (60)
Key flexfield segment column.
PERSONAL_PAYMENT_METHOD_ID NUMBER (9)
Foreign key to PAY_PERSONAL_PAYMENT_METHODS
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT LAST_UPD_DATE
,      BUSINESS_GROUP_ID
,      ELEMENT_ENTRY_ID
,      PERSON_ID
,      EFFECTIVE_START_DATE
,      EFFECTIVE_END_DATE
,      ASSIGNMENT_ID
,      ELEMENT_LINK_ID
,      CREATOR_TYPE
,      ENTRY_TYPE
,      DATE_EARNED
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE16
,      ATTRIBUTE17
,      ATTRIBUTE18
,      ATTRIBUTE19
,      ATTRIBUTE20
,      CONCATENATED_SEGMENTS
,      ID_FLEX_NUM
,      SUMMARY_FLAG
,      ENABLED_FLAG
,      START_DATE_ACTIVE
,      END_DATE_ACTIVE
,      SEGMENT1
,      SEGMENT2
,      SEGMENT3
,      SEGMENT4
,      SEGMENT5
,      SEGMENT6
,      SEGMENT7
,      SEGMENT8
,      SEGMENT9
,      SEGMENT10
,      SEGMENT11
,      SEGMENT12
,      SEGMENT13
,      SEGMENT14
,      SEGMENT15
,      SEGMENT16
,      SEGMENT17
,      SEGMENT18
,      SEGMENT19
,      SEGMENT20
,      SEGMENT21
,      SEGMENT22
,      SEGMENT23
,      SEGMENT24
,      SEGMENT25
,      SEGMENT26
,      SEGMENT27
,      SEGMENT28
,      SEGMENT29
,      SEGMENT30
,      PERSONAL_PAYMENT_METHOD_ID
FROM APPS.HR_H2PI_ELEMENT_ENTRIES_V;

Dependencies

[top of page]

APPS.HR_H2PI_ELEMENT_ENTRIES_V references the following:

SchemaAPPS
ViewHR_H2PI_ASSIGNMENTS_V
SynonymPAY_COST_ALLOCATION_KEYFLEX
SynonymPAY_ELEMENT_ENTRIES_F
APPS.HR_H2PI_ELEMENT_ENTRIES_V is referenced by following:

SchemaAPPS
ViewHR_H2PI_ELEMENT_ENTRY_VALUES_V
Package BodyHR_H2PI_PERSON_UPLOAD - show dependent code
SchemaPUBLIC
SynonymHR_H2PI_ELEMENT_ENTRIES_V