eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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:	PER.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:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Primary Key: HR_ASSIGNMENT_SET_AMENDMEN_PK

ASSIGNMENT_ID
ASSIGNMENT_SET_ID

Indexes

Index	Type	Uniqueness	Tablespace	Column
HR_ASSIGNMENT_SET_AMENDMEN_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	ASSIGNMENT_ID ASSIGNMENT_SET_ID
HR_ASSIGNMENT_SET_AMENDMEN_FK2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ASSIGNMENT_SET_ID

Foreign Keys

Table		Foreign Table	Foreign Key Column
HR_ASSIGNMENT_SET_AMENDMENTS		HR_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:

APPS: HR_ASSIGNMENT_SET_AMENDMENTS; HR_ASSIGNMENT_SET_AMENDMEN_WHO
PUBLIC: HR_ASSIGNMENT_SET_AMENDMENTS