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

TABLE: HR.PER_MM_POSITIONS

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


PER_MM_POSITIONS holds positions that were defined as part of a mass move.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Primary Key: PER_MM_POSITIONS_PK
  1. ColumnMASS_MOVE_ID
  2. ColumnPOSITION_ID
Indexes
Index Type Uniqueness Tablespace Column
PER_MM_POSITIONS_PK NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnMASS_MOVE_ID
ColumnPOSITION_ID
PER_MM_POSITIONS_FK2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnNEW_POSITION_ID
PER_MM_POSITIONS_FK3 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnNEW_POSITION_DEFINITION_ID
PER_MM_POSITIONS_FK4 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPOSITION_ID
PER_MM_POSITIONS_FK5 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnTARGET_JOB_ID
Foreign Keys
Table
Foreign Table Foreign Key Column
PER_MM_POSITIONS PER_MM_POSITIONS_FK5 TablePER_JOBS PER_MM_POSITIONS TARGET_JOB_ID
PER_MM_POSITIONS PER_MM_POSITIONS_FK1 TablePER_MASS_MOVES PER_MM_POSITIONS MASS_MOVE_ID
PER_MM_POSITIONS PER_MM_POSITIONS_FK3 TablePER_POSITION_DEFINITIONS PER_MM_POSITIONS NEW_POSITION_DEFINITION_ID
Columns
Name Datatype Length Mandatory Comments
MASS_MOVE_ID NUMBER (15) Yes Foreign key to PER_MASS_MOVES.
POSITION_ID NUMBER (15) Yes Foreign key of source position to PER_ALL_POSITIONS.
OBJECT_VERSION_NUMBER NUMBER (9) Yes System-generated version of row. Increments by one with each update.
DEFAULT_FROM VARCHAR2 (1) Yes Where the standard conditions and location information will default from? Position, Organization, or Business Group.
DEACTIVATE_OLD_POSITION VARCHAR2 (1) Yes Flag indicating the source position will be end dated.
SELECT_POSITION VARCHAR2 (1) Yes Is the position selected as having assignments to be moved?
POSITION_MOVED VARCHAR2 (1) Yes Flag indicating the position was successfully moved.
NEW_POSITION_ID NUMBER (15)
Foreign key of target position to PER_ALL_POSITIONS.
NEW_POSITION_DEFINITION_ID NUMBER (15)
Foreign key to PER_POSITION_DEFINITIONS of the desired target position definition.
TARGET_JOB_ID NUMBER (15)
Foreign key of target job to PER_JOBS.
SEGMENT1 VARCHAR2 (60)
Key flexfield segment column.
SEGMENT2 VARCHAR2 (60)
Key flexfield segment column.
SEGMENT3 VARCHAR2 (60)
Key flexfield segment column.
SEGMENT4 VARCHAR2 (60)
Key flexfield segment column.
SEGMENT5 VARCHAR2 (60)
Key flexfield segment column.
SEGMENT6 VARCHAR2 (60)
Key flexfield segment column.
SEGMENT7 VARCHAR2 (60)
Key flexfield segment column.
SEGMENT8 VARCHAR2 (60)
Key flexfield segment column.
SEGMENT9 VARCHAR2 (60)
Key flexfield segment column.
SEGMENT10 VARCHAR2 (60)
Key flexfield segment column.
SEGMENT11 VARCHAR2 (60)
Key flexfield segment column.
SEGMENT12 VARCHAR2 (60)
Key flexfield segment column.
SEGMENT13 VARCHAR2 (60)
Key flexfield segment column.
SEGMENT14 VARCHAR2 (60)
Key flexfield segment column.
SEGMENT15 VARCHAR2 (60)
Key flexfield segment column.
SEGMENT16 VARCHAR2 (60)
Key flexfield segment column.
SEGMENT17 VARCHAR2 (60)
Key flexfield segment column.
SEGMENT18 VARCHAR2 (60)
Key flexfield segment column.
SEGMENT19 VARCHAR2 (60)
Key flexfield segment column.
SEGMENT20 VARCHAR2 (60)
Key flexfield segment column.
SEGMENT21 VARCHAR2 (60)
Key flexfield segment column.
SEGMENT22 VARCHAR2 (60)
Key flexfield segment column.
SEGMENT23 VARCHAR2 (60)
Key flexfield segment column.
SEGMENT24 VARCHAR2 (60)
Key flexfield segment column.
SEGMENT25 VARCHAR2 (60)
Key flexfield segment column.
SEGMENT26 VARCHAR2 (60)
Key flexfield segment column.
SEGMENT27 VARCHAR2 (60)
Key flexfield segment column.
SEGMENT28 VARCHAR2 (60)
Key flexfield segment column.
SEGMENT29 VARCHAR2 (60)
Key flexfield segment column.
SEGMENT30 VARCHAR2 (60)
Key flexfield segment column.
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
,      POSITION_ID
,      OBJECT_VERSION_NUMBER
,      DEFAULT_FROM
,      DEACTIVATE_OLD_POSITION
,      SELECT_POSITION
,      POSITION_MOVED
,      NEW_POSITION_ID
,      NEW_POSITION_DEFINITION_ID
,      TARGET_JOB_ID
,      SEGMENT1
,      SEGMENT2
,      SEGMENT3
,      SEGMENT4
,      SEGMENT5
,      SEGMENT6
,      SEGMENT7
,      SEGMENT8
,      SEGMENT9
,      SEGMENT10
,      SEGMENT11
,      SEGMENT12
,      SEGMENT13
,      SEGMENT14
,      SEGMENT15
,      SEGMENT16
,      SEGMENT17
,      SEGMENT18
,      SEGMENT19
,      SEGMENT20
,      SEGMENT21
,      SEGMENT22
,      SEGMENT23
,      SEGMENT24
,      SEGMENT25
,      SEGMENT26
,      SEGMENT27
,      SEGMENT28
,      SEGMENT29
,      SEGMENT30
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
FROM HR.PER_MM_POSITIONS;

Dependencies

[top of page]

HR.PER_MM_POSITIONS does not reference any database object

HR.PER_MM_POSITIONS is referenced by following:

SchemaHR
ViewPER_MM_POSITIONS#