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.PER_MM_ASSIGNMENTS

Object Details

Object Name:	PER_MM_ASSIGNMENTS
Object Type:	TABLE
Owner:	HR
FND Design Data:	PER.PER_MM_ASSIGNMENTS
Subobject Name:
Status:	VALID

PER_MM_ASSIGNMENTS holds assignments that were defined as part of a mass move.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Primary Key: PER_MM_ASSIGNMENTS_PK

MASS_MOVE_ID
ASSIGNMENT_ID

Indexes

Index	Type	Uniqueness	Tablespace	Column
PER_MM_ASSIGNMENTS_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	MASS_MOVE_ID ASSIGNMENT_ID
PER_MM_ASSIGNMENTS_FK2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	POSITION_ID
PER_MM_ASSIGNMENTS_FK3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	GRADE_ID

Foreign Keys

Table		Foreign Table	Foreign Key Column
PER_MM_ASSIGNMENTS		PER_GRADES	PER_MM_ASSIGNMENTS GRADE_ID
PER_MM_ASSIGNMENTS		PER_MASS_MOVES	PER_MM_ASSIGNMENTS MASS_MOVE_ID

Columns

Name	Datatype	Length	Mandatory	Comments
MASS_MOVE_ID	NUMBER	(15)	Yes	Foreign key to PER_MASS_MOVES.
ASSIGNMENT_ID	NUMBER	(15)	Yes	Foreign key to PER_ALL_ASSIGNMENTS_F.
OBJECT_VERSION_NUMBER	NUMBER	(9)	Yes	Object Version Number of the assignment being moved as of table population.
POSITION_ID	NUMBER	(15)	Yes	Foreign key of source position to PER_ALL_POSITIONS.
DEFAULT_FROM	VARCHAR2	(1)	Yes	Where the standard conditions and location information will default from? Assignment, Position, Organization, or Business Group.
SELECT_ASSIGNMENT	VARCHAR2	(1)	Yes	Is the assignment selected to be moved to the target position?
ASSIGNMENT_MOVED	VARCHAR2	(1)	Yes	Identifies if the assignment has been moved.
GRADE_ID	NUMBER	(15)		Foreign key to PER_GRADES
TAX_UNIT_ID	NUMBER	(15)		Foreign key of GRE/Legal Entity.
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 MASS_MOVE_ID
,      ASSIGNMENT_ID
,      OBJECT_VERSION_NUMBER
,      POSITION_ID
,      DEFAULT_FROM
,      SELECT_ASSIGNMENT
,      ASSIGNMENT_MOVED
,      GRADE_ID
,      TAX_UNIT_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
FROM HR.PER_MM_ASSIGNMENTS;

Dependencies

[top of page]

HR.PER_MM_ASSIGNMENTS does not reference any database object

HR.PER_MM_ASSIGNMENTS is referenced by following:

HR: PER_MM_ASSIGNMENTS#