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

TABLE: HR.HR_H2PI_ELEMENT_LINKS

Object Details
Object Name: HR_H2PI_ELEMENT_LINKS
Object Type: TABLE
Owner: HR
FND Design Data: TablePER.HR_H2PI_ELEMENT_LINKS
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
ELEMENT_LINK_ID NUMBER (9) Yes System generated primary key column
BUSINESS_GROUP_ID NUMBER (15) Yes Business group ID
CLIENT_ID NUMBER (15) Yes Client id
EFFECTIVE_START_DATE DATE
Yes Effective start date
EFFECTIVE_END_DATE DATE
Yes Effective end date
PAYROLL_ID NUMBER (9)
Payroll ID
COST_ALLOCATION_KEYFLEX_ID NUMBER (9)
Cost allocation ID
ELEMENT_TYPE_ID NUMBER (9)
Element Type ID
ORGANIZATION_ID NUMBER (15)
Organization ID
LOCATION_ID NUMBER (15)
Location ID
PAY_BASIS_ID NUMBER (9)
Pay Basis ID
LINK_TO_ALL_PAYROLLS_FLAG VARCHAR2 (30) Yes Indicates whether this element is linked to all payorlls
STATUS VARCHAR2 (1)
Status of column for upload
Query Text

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


SELECT LAST_UPD_DATE
,      ELEMENT_LINK_ID
,      BUSINESS_GROUP_ID
,      CLIENT_ID
,      EFFECTIVE_START_DATE
,      EFFECTIVE_END_DATE
,      PAYROLL_ID
,      COST_ALLOCATION_KEYFLEX_ID
,      ELEMENT_TYPE_ID
,      ORGANIZATION_ID
,      LOCATION_ID
,      PAY_BASIS_ID
,      LINK_TO_ALL_PAYROLLS_FLAG
,      STATUS
FROM HR.HR_H2PI_ELEMENT_LINKS;

Dependencies

[top of page]

HR.HR_H2PI_ELEMENT_LINKS does not reference any database object

HR.HR_H2PI_ELEMENT_LINKS is referenced by following:

SchemaAPPS
SynonymHR_H2PI_ELEMENT_LINKS
SchemaPUBLIC
SynonymHR_H2PI_ELEMENT_LINKS