eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

TABLE: HR.PER_SECURITY_PROFILES

Object Details

Object Name:	PER_SECURITY_PROFILES
Object Type:	TABLE
Owner:	HR
FND Design Data:	PER.PER_SECURITY_PROFILES
Subobject Name:
Status:	VALID

PER_SECURITY_PROFILES holds user definitions of security profiles
based on organizations, positions and payrolls that the system will
use to restrict access to specific records in the Oracle HRMS
database. Access to secure database objects in Oracle HRMS is
controlled by means of a security profile that is linked to an Oracle
ID associated with your responsibility. Currently, the secure
database objects are organizations, positions, payrolls and people.
If the VIEW_ALL_FLAG is set to Y, then no security restriction applies
and anyone using this security profile can see all objects within
their product type. If the VIEW_ALL_FLAG is set to N, then any
combination of organization, position and payroll security can apply.
The restrictions of the security profile will determine the list of
people who are visible to the user. Security profiles are used by the
Generate Secure User process to create specific data objects for each
Oracle ID and by the Security List Maintenance process to populate the
secure lists for organization, position, payroll and people.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Primary Key: PER_SECURITY_PROFILES_PK

SECURITY_PROFILE_ID

Unique Key: PER_SECURITY_PROFILES_UK2

SECURITY_PROFILE_NAME
BUSINESS_GROUP_ID

Indexes

Index	Type	Uniqueness	Tablespace	Column
PER_SECURITY_PROFILES_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	SECURITY_PROFILE_ID
PER_SECURITY_PROFILES_UK2	NORMAL	UNIQUE	APPS_TS_TX_IDX	SECURITY_PROFILE_NAME BUSINESS_GROUP_ID
PER_SECURITY_PROFILES_FK1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	BUSINESS_GROUP_ID
PER_SECURITY_PROFILES_FK2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	POSITION_ID
PER_SECURITY_PROFILES_FK3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ORGANIZATION_ID
PER_SECURITY_PROFILES_FK4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	POSITION_STRUCTURE_ID
PER_SECURITY_PROFILES_FK5	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ORGANIZATION_STRUCTURE_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	HR_ALL_ORGANIZATION_UNITS	PER_SECURITY_PROFILES ORGANIZATION_ID
PER_SECURITY_PROFILES	PER_ALL_POSITIONS	PER_SECURITY_PROFILES POSITION_ID
PER_SECURITY_PROFILES	PER_ORGANIZATION_STRUCTURES	PER_SECURITY_PROFILES ORGANIZATION_STRUCTURE_ID
PER_SECURITY_PROFILES	PER_POSITION_STRUCTURES	PER_SECURITY_PROFILES POSITION_STRUCTURE_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	PER_SECURITY_PROFILES	PER_PERSON_LIST SECURITY_PROFILE_ID
PER_PERSON_LIST_CHANGES	PER_SECURITY_PROFILES	PER_PERSON_LIST_CHANGES 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

Columns

Name	Datatype	Length	Mandatory	Comments
SECURITY_PROFILE_ID	NUMBER	(15)	Yes	System-generated primary key column.
BUSINESS_GROUP_ID	NUMBER	(15)		Foreign key to HR_ORGANIZATION_UNITS.
POSITION_ID	NUMBER	(15)		Foreign key to PER_ALL_POSITIONS.
ORGANIZATION_ID	NUMBER	(15)		Foreign key to HR_ORGANIZATION_UNITS.
POSITION_STRUCTURE_ID	NUMBER	(15)		Foreign key to PER_POSITION_STRUCTURES.
ORGANIZATION_STRUCTURE_ID	NUMBER	(15)		Foreign key to PER_ORGANIZATION_STRUCTURES.
INCLUDE_TOP_ORGANIZATION_FLAG	VARCHAR2	(30)	Yes	Include top organization in hierarchy in access list (Y/N).
INCLUDE_TOP_POSITION_FLAG	VARCHAR2	(30)	Yes	Include top position in hierarchy in access list ( Y/N).
SECURITY_PROFILE_NAME	VARCHAR2	(240)	Yes	Security profile name.
VIEW_ALL_APPLICANTS_FLAG	VARCHAR2	(30)	Yes	Grant access to applicants (Y for all applicants, N for restricted access, X for no access)
VIEW_ALL_EMPLOYEES_FLAG	VARCHAR2	(30)	Yes	Grant access to employees (Y for all employees, N for restricted access, X for no access)
VIEW_ALL_FLAG	VARCHAR2	(30)	Yes	Grant unrestricted access to all data (Y/N).
VIEW_ALL_ORGANIZATIONS_FLAG	VARCHAR2	(30)	Yes	Grant unrestricted access to all organizations ( Y/N).
VIEW_ALL_PAYROLLS_FLAG	VARCHAR2	(30)	Yes	Grant unrestricted access to all payrolls (Y/N).
VIEW_ALL_POSITIONS_FLAG	VARCHAR2	(30)	Yes	Grant unrestricted access to all positions (Y/N).
INCLUDE_EXCLUDE_PAYROLL_FLAG	VARCHAR2	(30)		Include or exclude specific payrolls.
REPORTING_ORACLE_USERNAME	VARCHAR2	(30)		Reporting user name for the ID set up by the DBA.
REQUEST_ID	NUMBER	(15)		Standard Who column.
PROGRAM_APPLICATION_ID	NUMBER	(15)		Standard Who column.
PROGRAM_ID	NUMBER	(15)		Standard Who column.
PROGRAM_UPDATE_DATE	DATE			Standard Who column.
LAST_UPDATE_DATE	DATE			Standard Who column.
LAST_UPDATED_BY	NUMBER	(15)		Standard Who column.
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who column.
CREATED_BY	NUMBER	(15)		Standard Who column.
CREATION_DATE	DATE			Standard Who column.
ALLOW_GRANTED_USERS_FLAG	VARCHAR2	(30)		This column specifies whether people outside the security profile may be made visible to a person on an ad-hoc basis
RESTRICT_BY_SUPERVISOR_FLAG	VARCHAR2	(30)		Restrict the people that are visible to those within your supervisor hierarchy
SUPERVISOR_LEVELS	NUMBER			The number of levels to use for the supervisor hierarchy
EXCLUDE_SECONDARY_ASGS_FLAG	VARCHAR2	(30)		Only use primary assignments when building the supervisor hierarchy
EXCLUDE_PERSON_FLAG	VARCHAR2	(30)		Exclude the current person from the list of visible people
NAMED_PERSON_ID	NUMBER	(10)		The person to use for the top level in the supervisor hierarchy, or to use for the exclude user flag (optional)
CUSTOM_RESTRICTION_FLAG	VARCHAR2	(30)		Specifies if a custom restriction is to be used
RESTRICTION_TEXT	VARCHAR2	(4000)		The sql fragment of the custom restriction
EXCLUDE_BUSINESS_GROUPS_FLAG	VARCHAR2	(30)		Specifies if all business groups are included for global security profiles
ORG_SECURITY_MODE	VARCHAR2	(30)	Yes	Stores the mode by which organizations are secured.
VIEW_ALL_CWK_FLAG	VARCHAR2	(30)	Yes	view all contingent workers flag
VIEW_ALL_CONTACTS_FLAG	VARCHAR2	(30)	Yes	view all contacts flag
RESTRICT_ON_INDIVIDUAL_ASG	VARCHAR2	(30)		Restrict on an individual assignment basis.
TOP_ORGANIZATION_METHOD	VARCHAR2	(30)		Indicates whether the top organization is statically defined or whether it is used-based.
TOP_POSITION_METHOD	VARCHAR2	(30)		Indicates whether the top position is statically defined or whether it is used-based.
VIEW_ALL_CANDIDATES_FLAG	VARCHAR2	(30)	Yes	view all candidates flag

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT SECURITY_PROFILE_ID
,      BUSINESS_GROUP_ID
,      POSITION_ID
,      ORGANIZATION_ID
,      POSITION_STRUCTURE_ID
,      ORGANIZATION_STRUCTURE_ID
,      INCLUDE_TOP_ORGANIZATION_FLAG
,      INCLUDE_TOP_POSITION_FLAG
,      SECURITY_PROFILE_NAME
,      VIEW_ALL_APPLICANTS_FLAG
,      VIEW_ALL_EMPLOYEES_FLAG
,      VIEW_ALL_FLAG
,      VIEW_ALL_ORGANIZATIONS_FLAG
,      VIEW_ALL_PAYROLLS_FLAG
,      VIEW_ALL_POSITIONS_FLAG
,      INCLUDE_EXCLUDE_PAYROLL_FLAG
,      REPORTING_ORACLE_USERNAME
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
,      ALLOW_GRANTED_USERS_FLAG
,      RESTRICT_BY_SUPERVISOR_FLAG
,      SUPERVISOR_LEVELS
,      EXCLUDE_SECONDARY_ASGS_FLAG
,      EXCLUDE_PERSON_FLAG
,      NAMED_PERSON_ID
,      CUSTOM_RESTRICTION_FLAG
,      RESTRICTION_TEXT
,      EXCLUDE_BUSINESS_GROUPS_FLAG
,      ORG_SECURITY_MODE
,      VIEW_ALL_CWK_FLAG
,      VIEW_ALL_CONTACTS_FLAG
,      RESTRICT_ON_INDIVIDUAL_ASG
,      TOP_ORGANIZATION_METHOD
,      TOP_POSITION_METHOD
,      VIEW_ALL_CANDIDATES_FLAG
FROM HR.PER_SECURITY_PROFILES;

Dependencies

[top of page]

HR.PER_SECURITY_PROFILES does not reference any database object

HR.PER_SECURITY_PROFILES is referenced by following:

APPS: PER_SECURITY_PROFILES; PER_SECURITY_PROFILES_WHO
PUBLIC: PER_SECURITY_PROFILES