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

TABLE: HR.HR_ASSIGNMENT_SET_AMENDMENTS

Object Details
Object Name: HR_ASSIGNMENT_SET_AMENDMENTS
Object Type: TABLE
Owner: HR
FND Design Data: TablePER.HR_ASSIGNMENT_SET_AMENDMENTS
Subobject Name:
Status: VALID


HR_ASSIGNMENT_SET_AMENDMENTS holds the explicit amendments to an
assignment set that identify whether a specific assignment should be
included or excluded.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Primary Key: HR_ASSIGNMENT_SET_AMENDMEN_PK
  1. ColumnASSIGNMENT_ID
  2. ColumnASSIGNMENT_SET_ID
Indexes
Index Type Uniqueness Tablespace Column
HR_ASSIGNMENT_SET_AMENDMEN_PK NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnASSIGNMENT_ID
ColumnASSIGNMENT_SET_ID
HR_ASSIGNMENT_SET_AMENDMEN_FK2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnASSIGNMENT_SET_ID
Foreign Keys
Table
Foreign Table Foreign Key Column
HR_ASSIGNMENT_SET_AMENDMENTS HR_ASSIGNMENT_SET_AMENDMEN_FK2 TableHR_ASSIGNMENT_SETS HR_ASSIGNMENT_SET_AMENDMENTS ASSIGNMENT_SET_ID
Columns
Name Datatype Length Mandatory Comments
ASSIGNMENT_ID NUMBER (10) Yes Foreign key to PER_ASSIGNMENTS.
ASSIGNMENT_SET_ID NUMBER (15) Yes Foreign key to HR_ASSIGNMENT_SETS.
INCLUDE_OR_EXCLUDE VARCHAR2 (30)
Identifies whether to explicitly include or exclude the assignment.
LAST_UPDATE_DATE DATE

Standard Who column.
LAST_UPDATED_BY NUMBER (15)
Standard Who column.
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column.
CREATED_BY NUMBER (15)
Standard Who column.
CREATION_DATE DATE

Standard Who column.
Query Text

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


SELECT ASSIGNMENT_ID
,      ASSIGNMENT_SET_ID
,      INCLUDE_OR_EXCLUDE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
FROM HR.HR_ASSIGNMENT_SET_AMENDMENTS;

Dependencies

[top of page]

HR.HR_ASSIGNMENT_SET_AMENDMENTS does not reference any database object

HR.HR_ASSIGNMENT_SET_AMENDMENTS is referenced by following:

SchemaHR
ViewHR_ASSIGNMENT_SET_AMENDMENTS#