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


TABLE: HR.PER_MASS_MOVES

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


PER_MASS_MOVES holds a high level definition of a mass move including
source and target organizations.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Primary Key: PER_MASS_MOVES_PK
  1. ColumnMASS_MOVE_ID
Indexes
Index Type Uniqueness Tablespace Column
PER_MASS_MOVES_PK NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnMASS_MOVE_ID
PER_MASS_MOVES_FK1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnBUSINESS_GROUP_ID
Foreign Keys
Table
Foreign Table Foreign Key Column
PER_MASS_MOVES PER_MASS_MOVES_FK1 TableHR_ALL_ORGANIZATION_UNITS PER_MASS_MOVES BUSINESS_GROUP_ID
TablePER_MM_ASSIGNMENTS PER_MM_ASSIGNMENTS_FK1 PER_MASS_MOVES PER_MM_ASSIGNMENTS MASS_MOVE_ID
TablePER_MM_JOB_REQUIREMENTS PER_MM_JOB_REQUIREMENTS_FK1 PER_MASS_MOVES PER_MM_JOB_REQUIREMENTS MASS_MOVE_ID
TablePER_MM_POSITIONS PER_MM_POSITIONS_FK1 PER_MASS_MOVES PER_MM_POSITIONS MASS_MOVE_ID
TablePER_MM_VALID_GRADES PER_MM_VALID_GRADES_FK1 PER_MASS_MOVES PER_MM_VALID_GRADES MASS_MOVE_ID
Columns
Name Datatype Length Mandatory Comments
MASS_MOVE_ID NUMBER (15) Yes Primary key.
BUSINESS_GROUP_ID NUMBER (15) Yes Foreign key of business group to HR_ORGANIZATION_UNITS.
EFFECTIVE_DATE DATE
Yes Date the mass move changes becomes effective.
OLD_ORGANIZATION_ID NUMBER (15) Yes Foreign key of source organization to HR_ORGANIZATION_UNITS.
NEW_ORGANIZATION_ID NUMBER (15) Yes Foreign key of target organization to HR_ORGANIZATION_UNITS.
STATUS VARCHAR2 (60) Yes System assigned status (e.g. Unprocessed, Complete, Complete with Warnings, In-Error).
REASON VARCHAR2 (240)
Breif description or purpose of the mass move.
BATCH_RUN_NUMBER NUMBER (9)
Identifies the batch run.
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
,      BUSINESS_GROUP_ID
,      EFFECTIVE_DATE
,      OLD_ORGANIZATION_ID
,      NEW_ORGANIZATION_ID
,      STATUS
,      REASON
,      BATCH_RUN_NUMBER
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
FROM HR.PER_MASS_MOVES;

Dependencies

[top of page]

HR.PER_MASS_MOVES does not reference any database object

HR.PER_MASS_MOVES is referenced by following:

SchemaHR
ViewPER_MASS_MOVES#