FND Design Data [Home] [Help]

Table: GHR_MASS_REALIGNMENT

Product: GHR - US Federal Human Resources
Description: This table is used to store criteria for mass realignment.
Implementation/DBA Data: TableHR.GHR_MASS_REALIGNMENT
Primary Key: GHR_MASS_REALIGNMENT_PK
  1. ColumnMASS_REALIGNMENT_ID
Primary Key: GHR_MASS_REALIGNMENT_UK
  1. ColumnNAME
Foreign Keys
Table
Foreign Table Foreign Key Column
GHR_MASS_REALIGNMENT FK Joins to TableHR_ALL_ORGANIZATION_UNITS GHR_MASS_REALIGNMENT.OLD_ORGANIZATION_ID
GHR_MASS_REALIGNMENT FK Joins to TableHR_ALL_ORGANIZATION_UNITS GHR_MASS_REALIGNMENT.NEW_ORGANIZATION_ID
GHR_MASS_REALIGNMENT FK Joins to TablePER_ORG_STRUCTURE_VERSIONS GHR_MASS_REALIGNMENT.OLD_ORG_STRUCTURE_VERSION_ID
GHR_MASS_REALIGNMENT FK Joins to TablePER_POS_STRUCTURE_VERSIONS GHR_MASS_REALIGNMENT.OLD_POS_STRUCTURE_VERSION_ID
GHR_MASS_REALIGNMENT FK Joins to TableGHR_POIS GHR_MASS_REALIGNMENT.TARGET_PERSONNEL_OFFICE_ID
GHR_MASS_REALIGNMENT FK Joins to TableGHR_POIS GHR_MASS_REALIGNMENT.PERSONNEL_OFFICE_ID
GHR_MASS_REALIGNMENT FK Joins to TableHR_ALL_ORGANIZATION_UNITS GHR_MASS_REALIGNMENT.TARGET_POSITION_ORG_ID
GHR_MASS_REALIGNMENT FK Joins to TableGHR_PA_REQUESTS GHR_MASS_REALIGNMENT.PA_REQUEST_ID