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

TABLE: HR.HR_H2PI_ELEMENT_ENTRIES

Object Details
Object Name: HR_H2PI_ELEMENT_ENTRIES
Object Type: TABLE
Owner: HR
FND Design Data: TablePER.HR_H2PI_ELEMENT_ENTRIES
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.

Storage Details
Tablespace: TablespaceAPPS_TS_INTERFACE
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
LAST_UPD_DATE DATE

Last update date
BUSINESS_GROUP_ID NUMBER (15) Yes Business group ID
CLIENT_ID NUMBER (15) Yes Client id
ELEMENT_ENTRY_ID NUMBER (15) Yes System generated primary key column
PERSON_ID NUMBER (10) Yes Person ID
EFFECTIVE_START_DATE DATE
Yes Effective start date for element entry
EFFECTIVE_END_DATE DATE
Yes Effective end date for element entry
ASSIGNMENT_ID NUMBER (10) Yes Assignment ID
ELEMENT_LINK_ID NUMBER (9) Yes Element Link ID
CREATOR_TYPE VARCHAR2 (10) Yes Subsystem resposible for maintaining elememt entry
ENTRY_TYPE VARCHAR2 (1) Yes Subtype for an element entry
DATE_EARNED DATE

Date earned for entry- used for mid period GRE changes
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 (240)
Key flexfield segment column
ID_FLEX_NUM NUMBER (15)
Key flexfield structure foreign key
SUMMARY_FLAG VARCHAR2 (1)
Key flexfield structure summary flag
ENABLED_FLAG VARCHAR2 (1)
Key flexfield structure 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
STATUS VARCHAR2 (1)
Status of record for upload
PERSONAL_PAYMENT_METHOD_ID NUMBER (9)
Query Text

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


SELECT LAST_UPD_DATE
,      BUSINESS_GROUP_ID
,      CLIENT_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
,      STATUS
,      PERSONAL_PAYMENT_METHOD_ID
FROM HR.HR_H2PI_ELEMENT_ENTRIES;

Dependencies

[top of page]

HR.HR_H2PI_ELEMENT_ENTRIES does not reference any database object

HR.HR_H2PI_ELEMENT_ENTRIES is referenced by following:

SchemaHR
ViewHR_H2PI_ELEMENT_ENTRIES#