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

TABLE: HR.PAY_TEMPLATE_CORE_OBJECTS

Object Details
Object Name: PAY_TEMPLATE_CORE_OBJECTS
Object Type: TABLE
Owner: HR
FND Design Data: TablePAY.PAY_TEMPLATE_CORE_OBJECTS
Subobject Name:
Status: VALID


PAY_TEMPLATE_CORE_OBJECTS is used to keep track of the core schema objects generated from element templates.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Primary Key: PAY_TEMPLATE_CORE_OBJECTS_PK
  1. ColumnTEMPLATE_CORE_OBJECT_ID
Indexes
Index Type Uniqueness Tablespace Column
PAY_TEMPLATE_CORE_OBJECTS_PK NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnTEMPLATE_CORE_OBJECT_ID
PAY_TEMPLATE_CORE_OBJECTS_UK1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnCORE_OBJECT_TYPE
ColumnCORE_OBJECT_ID
PAY_TEMPLATE_CORE_OBJECTS_FK1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnTEMPLATE_ID
PAY_TEMPLATE_CORE_OBJECTS_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnCORE_OBJECT_TYPE
ColumnSHADOW_OBJECT_ID
Columns
Name Datatype Length Mandatory Comments
TEMPLATE_CORE_OBJECT_ID NUMBER (9) Yes System generated primary key column.
TEMPLATE_ID NUMBER (9) Yes Foreign key to PAY_ELEMENT_TEMPLATES.
CORE_OBJECT_TYPE VARCHAR2 (30) Yes Type of generated core object.
CORE_OBJECT_ID NUMBER (9) Yes Primary key of the generated core object.
SHADOW_OBJECT_ID NUMBER (9) Yes Primary key of the shadow schema object used to generate the core schema object.
EFFECTIVE_DATE DATE
Yes Effective date of core object creation.
OBJECT_VERSION_NUMBER NUMBER (9)
Object version number 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.
Query Text

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


SELECT TEMPLATE_CORE_OBJECT_ID
,      TEMPLATE_ID
,      CORE_OBJECT_TYPE
,      CORE_OBJECT_ID
,      SHADOW_OBJECT_ID
,      EFFECTIVE_DATE
,      OBJECT_VERSION_NUMBER
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
FROM HR.PAY_TEMPLATE_CORE_OBJECTS;

Dependencies

[top of page]

HR.PAY_TEMPLATE_CORE_OBJECTS does not reference any database object

HR.PAY_TEMPLATE_CORE_OBJECTS is referenced by following:

SchemaHR
ViewPAY_TEMPLATE_CORE_OBJECTS#