FND Design Data [Home] [Help]

Table: PER_ORG_STRUCTURE_VERSIONS

Product: PER - Human Resources
Description: Version control information for specific organization hierarchies.
Implementation/DBA Data: TableHR.PER_ORG_STRUCTURE_VERSIONS
Primary Key: PER_ORG_STRUCTURE_VERSIONS_PK
  1. ColumnORG_STRUCTURE_VERSION_ID
Foreign Keys
Table
Foreign Table Foreign Key Column
PER_ORG_STRUCTURE_VERSIONS FK Joins to TableHR_ALL_ORGANIZATION_UNITS PER_ORG_STRUCTURE_VERSIONS.BUSINESS_GROUP_ID
PER_ORG_STRUCTURE_VERSIONS FK Joins to TablePER_ORGANIZATION_STRUCTURES PER_ORG_STRUCTURE_VERSIONS.ORGANIZATION_STRUCTURE_ID
TableGHR_MASS_REALIGNMENT FK Joins to PER_ORG_STRUCTURE_VERSIONS GHR_MASS_REALIGNMENT.OLD_ORG_STRUCTURE_VERSION_ID
TableGHR_MASS_TRANSFERS FK Joins to PER_ORG_STRUCTURE_VERSIONS GHR_MASS_TRANSFERS.OLD_ORG_STRUCTURE_VERSION_ID
TableIGW_IMPLEMENTATIONS_ALL FK Joins to PER_ORG_STRUCTURE_VERSIONS IGW_IMPLEMENTATIONS_ALL.APR_ORG_STRUCTURE_VERSION_ID
TableIGW_IMPLEMENTATIONS_ALL FK Joins to PER_ORG_STRUCTURE_VERSIONS IGW_IMPLEMENTATIONS_ALL.PRP_ORG_STRUCTURE_VERSION_ID
TablePA_IMPLEMENTATIONS_ALL FK Joins to PER_ORG_STRUCTURE_VERSIONS PA_IMPLEMENTATIONS_ALL.ORG_STRUCTURE_VERSION_ID
TablePA_IND_RATE_SCHEDULES_ALL_BG FK Joins to PER_ORG_STRUCTURE_VERSIONS PA_IND_RATE_SCHEDULES_ALL_BG.ORG_STRUCTURE_VERSION_ID
TablePA_IND_RATE_SCH_REVISIONS FK Joins to PER_ORG_STRUCTURE_VERSIONS PA_IND_RATE_SCH_REVISIONS.ORG_STRUCTURE_VERSION_ID
TablePA_PROJECT_ASSIGNMENTS FK Joins to PER_ORG_STRUCTURE_VERSIONS PA_PROJECT_ASSIGNMENTS.SEARCH_EXP_ORG_STRUCT_VER_ID
TablePER_ORG_STRUCTURE_ELEMENTS FK Joins to PER_ORG_STRUCTURE_VERSIONS PER_ORG_STRUCTURE_ELEMENTS.ORG_STRUCTURE_VERSION_ID