FND Design Data [Home] [Help]

Table: PER_ORGANIZATION_STRUCTURES

Product: PER - Human Resources
Description: Organization hierarchy names.
Implementation/DBA Data: TableHR.PER_ORGANIZATION_STRUCTURES
Primary Key: PER_ORGANIZATION_STRUCTURE_PK
  1. ColumnORGANIZATION_STRUCTURE_ID
Primary Key: PER_ORGANIZATION_STRUCTURE_UK2
  1. ColumnNAME
  2. ColumnBUSINESS_GROUP_ID
Foreign Keys
Table
Foreign Table Foreign Key Column
PER_ORGANIZATION_STRUCTURES FK Joins to TableHR_ALL_ORGANIZATION_UNITS PER_ORGANIZATION_STRUCTURES.BUSINESS_GROUP_ID
TableIGW_IMPLEMENTATIONS_ALL FK Joins to PER_ORGANIZATION_STRUCTURES IGW_IMPLEMENTATIONS_ALL.APR_ORG_STRUCTURE_ID
TableIGW_IMPLEMENTATIONS_ALL FK Joins to PER_ORGANIZATION_STRUCTURES IGW_IMPLEMENTATIONS_ALL.PRP_ORG_STRUCTURE_ID
TablePA_IMPLEMENTATIONS_ALL FK Joins to PER_ORGANIZATION_STRUCTURES PA_IMPLEMENTATIONS_ALL.ORGANIZATION_STRUCTURE_ID
TablePA_IND_RATE_SCHEDULES_ALL_BG FK Joins to PER_ORGANIZATION_STRUCTURES PA_IND_RATE_SCHEDULES_ALL_BG.ORGANIZATION_STRUCTURE_ID
TablePA_IND_RATE_SCH_REVISIONS FK Joins to PER_ORGANIZATION_STRUCTURES PA_IND_RATE_SCH_REVISIONS.ORGANIZATION_STRUCTURE_ID
TablePER_ORG_STRUCTURE_VERSIONS FK Joins to PER_ORGANIZATION_STRUCTURES PER_ORG_STRUCTURE_VERSIONS.ORGANIZATION_STRUCTURE_ID
TablePER_SECURITY_PROFILES FK Joins to PER_ORGANIZATION_STRUCTURES PER_SECURITY_PROFILES.ORGANIZATION_STRUCTURE_ID
TablePQH_RULE_SETS FK Joins to PER_ORGANIZATION_STRUCTURES PQH_RULE_SETS.ORGANIZATION_STRUCTURE_ID