FND Design Data [Home] [Help]

Table: PER_SECURITY_PROFILES

Product: PER - Human Resources
Description: Security profile definitions to restrict user access to specific HRMS records.
Implementation/DBA Data: TableHR.PER_SECURITY_PROFILES
Primary Key: PER_SECURITY_PROFILES_PK
  1. ColumnSECURITY_PROFILE_ID
Primary Key: PER_SECURITY_PROFILES_UK2
  1. ColumnSECURITY_PROFILE_NAME
  2. ColumnBUSINESS_GROUP_ID
Foreign Keys
Table
Foreign Table Foreign Key Column
PER_SECURITY_PROFILES FK Joins to TableHR_ALL_ORGANIZATION_UNITS PER_SECURITY_PROFILES.BUSINESS_GROUP_ID
PER_SECURITY_PROFILES FK Joins to TablePER_ALL_POSITIONS PER_SECURITY_PROFILES.POSITION_ID
PER_SECURITY_PROFILES FK Joins to TableHR_ALL_ORGANIZATION_UNITS PER_SECURITY_PROFILES.ORGANIZATION_ID
PER_SECURITY_PROFILES FK Joins to TablePER_POSITION_STRUCTURES PER_SECURITY_PROFILES.POSITION_STRUCTURE_ID
PER_SECURITY_PROFILES FK Joins to TablePER_ORGANIZATION_STRUCTURES PER_SECURITY_PROFILES.ORGANIZATION_STRUCTURE_ID
TableAP_AUD_AUDITORS FK Joins to PER_SECURITY_PROFILES AP_AUD_AUDITORS.SECURITY_PROFILE_ID
TablePAY_PAYROLL_LIST FK Joins to PER_SECURITY_PROFILES PAY_PAYROLL_LIST.SECURITY_PROFILE_ID
TablePAY_SECURITY_PAYROLLS FK Joins to PER_SECURITY_PROFILES PAY_SECURITY_PAYROLLS.SECURITY_PROFILE_ID
TablePER_ASSIGNMENT_LIST FK Joins to PER_SECURITY_PROFILES PER_ASSIGNMENT_LIST.SECURITY_PROFILE_ID
TablePER_ORGANIZATION_LIST FK Joins to PER_SECURITY_PROFILES PER_ORGANIZATION_LIST.SECURITY_PROFILE_ID
TablePER_PERSON_LIST_CHANGES FK Joins to PER_SECURITY_PROFILES PER_PERSON_LIST_CHANGES.SECURITY_PROFILE_ID
TablePER_PERSON_LIST FK Joins to PER_SECURITY_PROFILES PER_PERSON_LIST.SECURITY_PROFILE_ID
TablePER_POSITION_LIST FK Joins to PER_SECURITY_PROFILES PER_POSITION_LIST.SECURITY_PROFILE_ID
TablePER_SECURITY_ORGANIZATIONS FK Joins to PER_SECURITY_PROFILES PER_SECURITY_ORGANIZATIONS.SECURITY_PROFILE_ID
TablePER_SECURITY_USERS FK Joins to PER_SECURITY_PROFILES PER_SECURITY_USERS.SECURITY_PROFILE_ID
TablePER_SEC_PROFILE_ASSIGNMENTS FK Joins to PER_SECURITY_PROFILES PER_SEC_PROFILE_ASSIGNMENTS.SECURITY_PROFILE_ID