FND Design Data [Home] [Help]

Table: PER_JOB_GROUPS

Product: PER - Human Resources
Description: Holds Job Group Information. Each Job will be a member of a Job Group and a Job Group can optionally be within a business group.
Implementation/DBA Data: TableHR.PER_JOB_GROUPS
Primary Key: PER_JOB_GROUPS_PK
  1. ColumnJOB_GROUP_ID
Primary Key: PER_JOB_GROUPS_UK1
  1. ColumnINTERNAL_NAME
  2. ColumnBUSINESS_GROUP_ID
Foreign Keys
Table
Foreign Table Foreign Key Column
PER_JOB_GROUPS FK Joins to TableHR_ALL_ORGANIZATION_UNITS PER_JOB_GROUPS.BUSINESS_GROUP_ID
TableAP_POL_HEADERS FK Joins to PER_JOB_GROUPS AP_POL_HEADERS.JOB_GROUP_ID
TablePA_PROJECTS_ALL FK Joins to PER_JOB_GROUPS PA_PROJECTS_ALL.BILL_JOB_GROUP_ID
TablePA_PROJECTS_ALL FK Joins to PER_JOB_GROUPS PA_PROJECTS_ALL.COST_JOB_GROUP_ID
TablePA_PROJECTS_ALL FK Joins to PER_JOB_GROUPS PA_PROJECTS_ALL.BILL_JOB_GROUP_ID
TablePA_PROJECTS_ALL FK Joins to PER_JOB_GROUPS PA_PROJECTS_ALL.COST_JOB_GROUP_ID
TablePA_PROJECT_ASSIGNMENTS FK Joins to PER_JOB_GROUPS PA_PROJECT_ASSIGNMENTS.FCST_JOB_GROUP_ID
TablePA_PROJECT_TYPES_ALL FK Joins to PER_JOB_GROUPS PA_PROJECT_TYPES_ALL.BILL_JOB_GROUP_ID
TablePA_PROJECT_TYPES_ALL FK Joins to PER_JOB_GROUPS PA_PROJECT_TYPES_ALL.BILL_JOB_GROUP_ID
TablePA_PROJECT_TYPES_ALL FK Joins to PER_JOB_GROUPS PA_PROJECT_TYPES_ALL.COST_JOB_GROUP_ID
TablePA_PROJECT_TYPES_ALL FK Joins to PER_JOB_GROUPS PA_PROJECT_TYPES_ALL.COST_JOB_GROUP_ID
TablePA_RBS_VERSIONS_B FK Joins to PER_JOB_GROUPS PA_RBS_VERSIONS_B.JOB_GROUP_ID
TablePA_RESOURCE_LISTS_ALL_BG FK Joins to PER_JOB_GROUPS PA_RESOURCE_LISTS_ALL_BG.JOB_GROUP_ID
TablePER_JOBS FK Joins to PER_JOB_GROUPS PER_JOBS.JOB_GROUP_ID
TablePER_ROLES FK Joins to PER_JOB_GROUPS PER_ROLES.JOB_GROUP_ID