FND Design Data [Home] [Help]

Table: PER_SALARY_SURVEY_MAPPINGS

Product: PER - Human Resources
Description: Mapping information for a salary survey line.
Implementation/DBA Data: TableHR.PER_SALARY_SURVEY_MAPPINGS
Primary Key: PER_SURVEY_MAPPINGS_ID
  1. ColumnSALARY_SURVEY_MAPPING_ID
Primary Key: PER_SURVEY_MAPPINGS_UK
  1. ColumnLOCATION_ID
  2. ColumnGRADE_ID
  3. ColumnCOMPANY_ORGANIZATION_ID
  4. ColumnCOMPANY_AGE_CODE
  5. ColumnPARENT_ID
  6. ColumnPARENT_TABLE_NAME
  7. ColumnSALARY_SURVEY_LINE_ID
Foreign Keys
Table
Foreign Table Foreign Key Column
PER_SALARY_SURVEY_MAPPINGS FK Joins to TablePER_SALARY_SURVEY_LINES PER_SALARY_SURVEY_MAPPINGS.SALARY_SURVEY_LINE_ID
PER_SALARY_SURVEY_MAPPINGS FK Joins to TableHR_LOCATIONS_ALL PER_SALARY_SURVEY_MAPPINGS.LOCATION_ID
PER_SALARY_SURVEY_MAPPINGS FK Joins to TablePER_GRADES PER_SALARY_SURVEY_MAPPINGS.GRADE_ID
PER_SALARY_SURVEY_MAPPINGS FK Joins to TableHR_ALL_ORGANIZATION_UNITS PER_SALARY_SURVEY_MAPPINGS.BUSINESS_GROUP_ID
PER_SALARY_SURVEY_MAPPINGS FK Joins to TableHR_ALL_ORGANIZATION_UNITS PER_SALARY_SURVEY_MAPPINGS.COMPANY_ORGANIZATION_ID