Table: PER_SECURITY_PROFILES

Product:	PER - Human Resources
Description:	Security profile definitions to restrict user access to specific HRMS records.
Implementation/DBA Data:	HR.PER_SECURITY_PROFILES

Primary Key: PER_SECURITY_PROFILES_PK

1. SECURITY_PROFILE_ID

Primary Key: PER_SECURITY_PROFILES_UK2

1. SECURITY_PROFILE_NAME
2. BUSINESS_GROUP_ID

Foreign Keys

Table		Foreign Table	Foreign Key Column
PER_SECURITY_PROFILES		HR_ALL_ORGANIZATION_UNITS	PER_SECURITY_PROFILES.BUSINESS_GROUP_ID
PER_SECURITY_PROFILES		PER_ALL_POSITIONS	PER_SECURITY_PROFILES.POSITION_ID
PER_SECURITY_PROFILES		HR_ALL_ORGANIZATION_UNITS	PER_SECURITY_PROFILES.ORGANIZATION_ID
PER_SECURITY_PROFILES		PER_POSITION_STRUCTURES	PER_SECURITY_PROFILES.POSITION_STRUCTURE_ID
PER_SECURITY_PROFILES		PER_ORGANIZATION_STRUCTURES	PER_SECURITY_PROFILES.ORGANIZATION_STRUCTURE_ID
AP_AUD_AUDITORS		PER_SECURITY_PROFILES	AP_AUD_AUDITORS.SECURITY_PROFILE_ID
PAY_PAYROLL_LIST		PER_SECURITY_PROFILES	PAY_PAYROLL_LIST.SECURITY_PROFILE_ID
PAY_SECURITY_PAYROLLS		PER_SECURITY_PROFILES	PAY_SECURITY_PAYROLLS.SECURITY_PROFILE_ID
PER_ASSIGNMENT_LIST		PER_SECURITY_PROFILES	PER_ASSIGNMENT_LIST.SECURITY_PROFILE_ID
PER_ORGANIZATION_LIST		PER_SECURITY_PROFILES	PER_ORGANIZATION_LIST.SECURITY_PROFILE_ID
PER_PERSON_LIST_CHANGES		PER_SECURITY_PROFILES	PER_PERSON_LIST_CHANGES.SECURITY_PROFILE_ID
PER_PERSON_LIST		PER_SECURITY_PROFILES	PER_PERSON_LIST.SECURITY_PROFILE_ID
PER_POSITION_LIST		PER_SECURITY_PROFILES	PER_POSITION_LIST.SECURITY_PROFILE_ID
PER_SECURITY_ORGANIZATIONS		PER_SECURITY_PROFILES	PER_SECURITY_ORGANIZATIONS.SECURITY_PROFILE_ID
PER_SECURITY_USERS		PER_SECURITY_PROFILES	PER_SECURITY_USERS.SECURITY_PROFILE_ID
PER_SEC_PROFILE_ASSIGNMENTS		PER_SECURITY_PROFILES	PER_SEC_PROFILE_ASSIGNMENTS.SECURITY_PROFILE_ID