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


TABLE: HR.GHR_MASS_REALIGNMENT

Object Details
Object Name: GHR_MASS_REALIGNMENT
Object Type: TABLE
Owner: HR
FND Design Data: TableGHR.GHR_MASS_REALIGNMENT
Subobject Name:
Status: VALID


GHR_MASS_REALIGNMENT is used to store criteria for mass realignment.
It is also used to store the target information for employee
/ position.


Storage Details
Tablespace: TablespaceAPPS_TS_INTERFACE
PCT Free: 10
PCT Used:
Primary Key: GHR_MASS_REALIGNMENT_PK
  1. ColumnMASS_REALIGNMENT_ID
Unique Key: GHR_MASS_REALIGNMENT_UK
  1. ColumnNAME
Indexes
Index Type Uniqueness Tablespace Column
GHR_MASS_REALIGNMENT_PK NORMAL UNIQUE TablespaceAPPS_TS_INTERFACE ColumnMASS_REALIGNMENT_ID
GHR_MASS_REALIGNMENT_UK NORMAL UNIQUE TablespaceAPPS_TS_INTERFACE ColumnNAME
GHR_MASS_REALIGNMENT_FK1 NORMAL NONUNIQUE TablespaceAPPS_TS_INTERFACE ColumnOLD_ORGANIZATION_ID
GHR_MASS_REALIGNMENT_FK2 NORMAL NONUNIQUE TablespaceAPPS_TS_INTERFACE ColumnNEW_ORGANIZATION_ID
GHR_MASS_REALIGNMENT_FK4 NORMAL NONUNIQUE TablespaceAPPS_TS_INTERFACE ColumnOLD_ORG_STRUCTURE_VERSION_ID
GHR_MASS_REALIGNMENT_FK5 NORMAL NONUNIQUE TablespaceAPPS_TS_INTERFACE ColumnOLD_POS_STRUCTURE_VERSION_ID
GHR_MASS_REALIGNMENT_FK6 NORMAL NONUNIQUE TablespaceAPPS_TS_INTERFACE ColumnTARGET_PERSONNEL_OFFICE_ID
GHR_MASS_REALIGNMENT_FK7 NORMAL NONUNIQUE TablespaceAPPS_TS_INTERFACE ColumnPERSONNEL_OFFICE_ID
GHR_MASS_REALIGNMENT_FK8 NORMAL NONUNIQUE TablespaceAPPS_TS_INTERFACE ColumnTARGET_POSITION_ORG_ID
GHR_MASS_REALIGNMENT_FK9 NORMAL NONUNIQUE TablespaceAPPS_TS_INTERFACE ColumnPA_REQUEST_ID
Foreign Keys
Table
Foreign Table Foreign Key Column
GHR_MASS_REALIGNMENT GHR_MASS_REALIGNMENT_FK9 TableGHR_PA_REQUESTS GHR_MASS_REALIGNMENT PA_REQUEST_ID
GHR_MASS_REALIGNMENT GHR_MASS_REALIGNMENT_FK6 TableGHR_POIS GHR_MASS_REALIGNMENT TARGET_PERSONNEL_OFFICE_ID
GHR_MASS_REALIGNMENT GHR_MASS_REALIGNMENT_FK7 TableGHR_POIS GHR_MASS_REALIGNMENT PERSONNEL_OFFICE_ID
GHR_MASS_REALIGNMENT GHR_MASS_REALIGNMENT_FK1 TableHR_ALL_ORGANIZATION_UNITS GHR_MASS_REALIGNMENT OLD_ORGANIZATION_ID
GHR_MASS_REALIGNMENT GHR_MASS_REALIGNMENT_FK8 TableHR_ALL_ORGANIZATION_UNITS GHR_MASS_REALIGNMENT TARGET_POSITION_ORG_ID
GHR_MASS_REALIGNMENT GHR_MASS_REALIGNMENT_FK2 TableHR_ALL_ORGANIZATION_UNITS GHR_MASS_REALIGNMENT NEW_ORGANIZATION_ID
GHR_MASS_REALIGNMENT GHR_MASS_REALIGNMENT_FK4 TablePER_ORG_STRUCTURE_VERSIONS GHR_MASS_REALIGNMENT OLD_ORG_STRUCTURE_VERSION_ID
Columns
Name Datatype Length Mandatory Comments
MASS_REALIGNMENT_ID NUMBER (15) Yes Primary key generated from sequence GHR_MASS_REALIGNMENT_S
EFFECTIVE_DATE DATE
Yes Effective Date of mass realignment
NAME VARCHAR2 (32) Yes User defined name for mass realignment
REASON VARCHAR2 (2000)
Reason for de-selecting
STATUS VARCHAR2 (1) Yes Current status of mass realignment e.g. E(rror), P(rocessed)
PA_REQUEST_ID NUMBER (15)
Foreign key to GHR_PA_REQUESTS
NEW_ORGANIZATION_ID NUMBER (15) Yes Foreign Key to HR_ORGANIZATION_UNITS
AGENCY_CODE_SUBELEMENT VARCHAR2 (30)
Agency Code / Sub-element
NEW_ORGANIZATION_NAME VARCHAR2 (240)
Organization Name
OLD_ORGANIZATION_ID NUMBER (15)
Foreign Key to HR_ORGANIZATION_UNITS
OLD_ORGANIZATION_NAME VARCHAR2 (240)
Organization Name
OLD_ORG_STRUCTURE_VERSION_ID NUMBER (15)
Organization hierarchy's version
OLD_ORG_STRUCTURE_NAME VARCHAR2 (30)
Organization hierarchy's name
OLD_POSITION_ID NUMBER (15)
Foreign key to PER_POSITIONS
OLD_POSITION_NAME VARCHAR2 (240)
Position Name
OLD_POS_STRUCTURE_VERSION_ID NUMBER (15)
Position hierarchy version
OLD_POS_STRUCTURE_NAME VARCHAR2 (30)
Position hierarchy name
ORG_STRUCTURE_ID VARCHAR2 (20)
Organization structure Id
OFFICE_SYMBOL VARCHAR2 (18)
Office Symbol
PERSONNEL_OFFICE_ID VARCHAR2 (4)
Personnel Office Id
TARGET_AGENCY_CODE_SUBELEMENT VARCHAR2 (30)
Agency Code / Sub-element
TARGET_APPROPRIATION_CODE1 VARCHAR2 (30)
First appropration code
TARGET_APPROPRIATION_CODE2 VARCHAR2 (30)
Second appropration code
TARGET_DUTY_STN_LOCATION_ID NUMBER (15)
Location Id of duty station
TARGET_DUTY_STATION_ID NUMBER (15)
Duty Station Id
TARGET_DUTY_STATION_CODE VARCHAR2 (9)
Duty station code as defined by OPM
TARGET_OFFICE_SYMBOL VARCHAR2 (18)
Office Symbol
TARGET_ORG_FUNCTION_CODE VARCHAR2 (30)
Organization functional code
TARGET_PAYROLL_OFFICE_ID VARCHAR2 (30)
Payroll office Id
TARGET_PERSONNEL_OFFICE_ID VARCHAR2 (4)
Personnel Office Id
TARGET_POSITION_ORG_ID NUMBER (15)
Position's organization Id
TARGET_POSITION_ORG_NAME VARCHAR2 (240)
Organization Name
CREATED_BY NUMBER (15) Yes Standard who column.
CREATION_DATE DATE
Yes Standard who column.
LAST_UPDATED_BY NUMBER (15) Yes Standard who column.
LAST_UPDATE_DATE DATE
Yes Standard who column.
LAST_UPDATE_LOGIN NUMBER (15)
Standard who column.
BUSINESS_GROUP_ID NUMBER (15)
Business Group ID
Query Text

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


SELECT MASS_REALIGNMENT_ID
,      EFFECTIVE_DATE
,      NAME
,      REASON
,      STATUS
,      PA_REQUEST_ID
,      NEW_ORGANIZATION_ID
,      AGENCY_CODE_SUBELEMENT
,      NEW_ORGANIZATION_NAME
,      OLD_ORGANIZATION_ID
,      OLD_ORGANIZATION_NAME
,      OLD_ORG_STRUCTURE_VERSION_ID
,      OLD_ORG_STRUCTURE_NAME
,      OLD_POSITION_ID
,      OLD_POSITION_NAME
,      OLD_POS_STRUCTURE_VERSION_ID
,      OLD_POS_STRUCTURE_NAME
,      ORG_STRUCTURE_ID
,      OFFICE_SYMBOL
,      PERSONNEL_OFFICE_ID
,      TARGET_AGENCY_CODE_SUBELEMENT
,      TARGET_APPROPRIATION_CODE1
,      TARGET_APPROPRIATION_CODE2
,      TARGET_DUTY_STN_LOCATION_ID
,      TARGET_DUTY_STATION_ID
,      TARGET_DUTY_STATION_CODE
,      TARGET_OFFICE_SYMBOL
,      TARGET_ORG_FUNCTION_CODE
,      TARGET_PAYROLL_OFFICE_ID
,      TARGET_PERSONNEL_OFFICE_ID
,      TARGET_POSITION_ORG_ID
,      TARGET_POSITION_ORG_NAME
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      BUSINESS_GROUP_ID
FROM HR.GHR_MASS_REALIGNMENT;

Dependencies

[top of page]

HR.GHR_MASS_REALIGNMENT does not reference any database object

HR.GHR_MASS_REALIGNMENT is referenced by following:

SchemaAPPS
SynonymGHR_MASS_REALIGNMENT
TriggerGHR_MASS_REALIGNMENT_WHO
SchemaPUBLIC
SynonymGHR_MASS_REALIGNMENT