FND Design Data [Home] [Help]

Table: PER_JOBS

Product: PER - Human Resources
Description: Jobs defined for a Business Group.
Implementation/DBA Data: TableHR.PER_JOBS
Primary Key: PER_JOBS_PK
  1. ColumnJOB_ID
Primary Key: PER_JOBS_UK2
  1. ColumnNAME
  2. ColumnBUSINESS_GROUP_ID
Foreign Keys
Table
Foreign Table Foreign Key Column
PER_JOBS FK Joins to TableHR_ALL_ORGANIZATION_UNITS PER_JOBS.BUSINESS_GROUP_ID
PER_JOBS FK Joins to TablePER_JOB_DEFINITIONS PER_JOBS.JOB_DEFINITION_ID
PER_JOBS FK Joins to TablePER_JOB_GROUPS PER_JOBS.JOB_GROUP_ID
TableAP_POL_SCHEDULE_OPTIONS FK Joins to PER_JOBS AP_POL_SCHEDULE_OPTIONS.ROLE_ID
TableGHR_PA_REQUESTS FK Joins to PER_JOBS GHR_PA_REQUESTS.TO_JOB_ID
TableHR_ALL_POSITIONS_F FK Joins to PER_JOBS HR_ALL_POSITIONS_F.JOB_ID
TableIRC_DEFAULT_POSTINGS FK Joins to PER_JOBS IRC_DEFAULT_POSTINGS.JOB_ID
TableIRC_REC_TEAM_MEMBERS FK Joins to PER_JOBS IRC_REC_TEAM_MEMBERS.JOB_ID
TableIRC_TEMPLATE_ASSOCIATIONS FK Joins to PER_JOBS IRC_TEMPLATE_ASSOCIATIONS.JOB_ID
TablePAY_ELEMENT_LINKS_F FK Joins to PER_JOBS PAY_ELEMENT_LINKS_F.JOB_ID
TablePAY_JOB_WC_CODE_USAGES FK Joins to PER_JOBS PAY_JOB_WC_CODE_USAGES.JOB_ID
TablePAY_WCI_OCCUPATIONS FK Joins to PER_JOBS PAY_WCI_OCCUPATIONS.JOB_ID
TablePA_BILL_RATES_ALL FK Joins to PER_JOBS PA_BILL_RATES_ALL.JOB_ID
TablePA_CC_DIST_LINES_ALL FK Joins to PER_JOBS PA_CC_DIST_LINES_ALL.TP_JOB_ID
TablePA_EXPENDITURE_ITEMS_ALL FK Joins to PER_JOBS PA_EXPENDITURE_ITEMS_ALL.JOB_ID
TablePA_EXPENDITURE_ITEMS_ALL FK Joins to PER_JOBS PA_EXPENDITURE_ITEMS_ALL.BILL_JOB_ID
TablePA_FORECAST_ITEMS FK Joins to PER_JOBS PA_FORECAST_ITEMS.JOB_ID
TablePA_FORECAST_ITEM_DETAILS FK Joins to PER_JOBS PA_FORECAST_ITEM_DETAILS.JOB_ID
TablePA_JOB_ASSIGNMENT_OVERRIDES FK Joins to PER_JOBS PA_JOB_ASSIGNMENT_OVERRIDES.JOB_ID
TablePA_JOB_BILL_RATE_OVERRIDES FK Joins to PER_JOBS PA_JOB_BILL_RATE_OVERRIDES.JOB_ID
TablePA_JOB_BILL_TITLE_OVERRIDES FK Joins to PER_JOBS PA_JOB_BILL_TITLE_OVERRIDES.JOB_ID
TablePA_PROJECT_ASSIGNMENTS FK Joins to PER_JOBS PA_PROJECT_ASSIGNMENTS.FCST_JOB_ID
TablePA_PROJECT_ROLE_TYPES FK Joins to PER_JOBS PA_PROJECT_ROLE_TYPES.DEFAULT_JOB_ID
TablePA_RESOURCES_DENORM FK Joins to PER_JOBS PA_RESOURCES_DENORM.JOB_ID
TablePA_RESOURCE_ASSIGNMENTS FK Joins to PER_JOBS PA_RESOURCE_ASSIGNMENTS.JOB_ID
TablePA_RESOURCE_ASSIGNMENTS FK Joins to PER_JOBS PA_RESOURCE_ASSIGNMENTS.RATE_JOB_ID
TablePA_RESOURCE_LIST_MEMBERS FK Joins to PER_JOBS PA_RESOURCE_LIST_MEMBERS.JOB_ID
TablePA_RESOURCE_MAPS FK Joins to PER_JOBS PA_RESOURCE_MAPS.JOB_ID
TablePA_RESOURCE_TXN_ATTRIBUTES FK Joins to PER_JOBS PA_RESOURCE_TXN_ATTRIBUTES.JOB_ID
TablePA_ROLE_JOB_BGS FK Joins to PER_JOBS PA_ROLE_JOB_BGS.JOB_ID
TablePA_ROLE_PROFILES FK Joins to PER_JOBS PA_ROLE_PROFILES.JOB_ID
TablePER_ALL_ASSIGNMENTS_F FK Joins to PER_JOBS PER_ALL_ASSIGNMENTS_F.JOB_ID
TablePER_BUDGET_ELEMENTS FK Joins to PER_JOBS PER_BUDGET_ELEMENTS.JOB_ID
TablePER_CAREER_PATH_ELEMENTS FK Joins to PER_JOBS PER_CAREER_PATH_ELEMENTS.SUBORDINATE_JOB_ID
TablePER_CAREER_PATH_ELEMENTS FK Joins to PER_JOBS PER_CAREER_PATH_ELEMENTS.PARENT_JOB_ID
TablePER_COMPETENCE_ELEMENTS FK Joins to PER_JOBS PER_COMPETENCE_ELEMENTS.JOB_ID
TablePER_DEPLOYMENT_FACTORS FK Joins to PER_JOBS PER_DEPLOYMENT_FACTORS.JOB_ID
TablePER_JOB_EVALUATIONS FK Joins to PER_JOBS PER_JOB_EVALUATIONS.JOB_ID
TablePER_JOB_EXTRA_INFO FK Joins to PER_JOBS PER_JOB_EXTRA_INFO.JOB_ID
TablePER_JOB_REQUIREMENTS FK Joins to PER_JOBS PER_JOB_REQUIREMENTS.JOB_ID
TablePER_MM_POSITIONS FK Joins to PER_JOBS PER_MM_POSITIONS.TARGET_JOB_ID
TablePER_ALL_POSITIONS FK Joins to PER_JOBS PER_ALL_POSITIONS.JOB_ID
TablePER_ROLES FK Joins to PER_JOBS PER_ROLES.JOB_ID
TablePER_ALL_VACANCIES FK Joins to PER_JOBS PER_ALL_VACANCIES.JOB_ID
TablePER_VALID_GRADES FK Joins to PER_JOBS PER_VALID_GRADES.JOB_ID
TablePJI_RESOURCES_DENORM FK Joins to PER_JOBS PJI_RESOURCES_DENORM.JOB_ID
TablePJI_RM_RES_F FK Joins to PER_JOBS PJI_RM_RES_F.JOB_ID
TablePJI_RM_RES_WT_F FK Joins to PER_JOBS PJI_RM_RES_WT_F.JOB_ID
TablePQH_BUDGET_DETAILS FK Joins to PER_JOBS PQH_BUDGET_DETAILS.JOB_ID
TablePQH_POSITION_TRANSACTIONS FK Joins to PER_JOBS PQH_POSITION_TRANSACTIONS.JOB_ID
TablePQH_TXN_JOB_REQUIREMENTS FK Joins to PER_JOBS PQH_TXN_JOB_REQUIREMENTS.JOB_ID
TablePQH_WORKSHEET_DETAILS FK Joins to PER_JOBS PQH_WORKSHEET_DETAILS.JOB_ID
TablePSP_PAYROLL_SUB_LINES FK Joins to PER_JOBS PSP_PAYROLL_SUB_LINES.JOB_ID