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: TablePER.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: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Primary Key: PER_SECURITY_PROFILES_PK
  1. ColumnSECURITY_PROFILE_ID
Unique Key: PER_SECURITY_PROFILES_UK2
  1. ColumnSECURITY_PROFILE_NAME
  2. ColumnBUSINESS_GROUP_ID
Indexes
Index Type Uniqueness Tablespace Column
PER_SECURITY_PROFILES_PK NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnSECURITY_PROFILE_ID
PER_SECURITY_PROFILES_UK2 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnSECURITY_PROFILE_NAME
ColumnBUSINESS_GROUP_ID
PER_SECURITY_PROFILES_FK1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnBUSINESS_GROUP_ID
PER_SECURITY_PROFILES_FK2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPOSITION_ID
PER_SECURITY_PROFILES_FK3 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnORGANIZATION_ID
PER_SECURITY_PROFILES_FK4 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPOSITION_STRUCTURE_ID
PER_SECURITY_PROFILES_FK5 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnORGANIZATION_STRUCTURE_ID
Foreign Keys
Table
Foreign Table Foreign Key Column
PER_SECURITY_PROFILES PER_SECURITY_PROFILES_FK1 TableHR_ALL_ORGANIZATION_UNITS PER_SECURITY_PROFILES BUSINESS_GROUP_ID
PER_SECURITY_PROFILES PER_SECURITY_PROFILES_FK3 TableHR_ALL_ORGANIZATION_UNITS PER_SECURITY_PROFILES ORGANIZATION_ID
PER_SECURITY_PROFILES PER_SECURITY_PROFILES_FK2 TablePER_ALL_POSITIONS PER_SECURITY_PROFILES POSITION_ID
PER_SECURITY_PROFILES PER_SECURITY_PROFILES_FK5 TablePER_ORGANIZATION_STRUCTURES PER_SECURITY_PROFILES ORGANIZATION_STRUCTURE_ID
PER_SECURITY_PROFILES PER_SECURITY_PROFILES_FK4 TablePER_POSITION_STRUCTURES PER_SECURITY_PROFILES POSITION_STRUCTURE_ID
TablePAY_PAYROLL_LIST PAY_PAYROLL_LIST_FK2 PER_SECURITY_PROFILES PAY_PAYROLL_LIST SECURITY_PROFILE_ID
TablePAY_SECURITY_PAYROLLS PAY_SECURITY_PAYROLLS_FK2 PER_SECURITY_PROFILES PAY_SECURITY_PAYROLLS SECURITY_PROFILE_ID
TablePER_ASSIGNMENT_LIST PER_ASSIGNMENT_LIST_FK1 PER_SECURITY_PROFILES PER_ASSIGNMENT_LIST SECURITY_PROFILE_ID
TablePER_ORGANIZATION_LIST PER_ORGANIZATION_LIST_FK2 PER_SECURITY_PROFILES PER_ORGANIZATION_LIST SECURITY_PROFILE_ID
TablePER_PERSON_LIST PER_PERSON_LIST_FK1 PER_SECURITY_PROFILES PER_PERSON_LIST SECURITY_PROFILE_ID
TablePER_PERSON_LIST_CHANGES PER_PERSON_LIST_CHANGES_FK2 PER_SECURITY_PROFILES PER_PERSON_LIST_CHANGES SECURITY_PROFILE_ID
TablePER_POSITION_LIST PER_POSITION_LIST_FK1 PER_SECURITY_PROFILES PER_POSITION_LIST SECURITY_PROFILE_ID
TablePER_SECURITY_ORGANIZATIONS PER_SECURITY_ORGANIZATIONS_FK2 PER_SECURITY_PROFILES PER_SECURITY_ORGANIZATIONS SECURITY_PROFILE_ID
TablePER_SECURITY_USERS PER_SECURITY_USERS_FK1 PER_SECURITY_PROFILES PER_SECURITY_USERS SECURITY_PROFILE_ID
TablePER_SEC_PROFILE_ASSIGNMENTS PER_SEC_PROFILE_ASSIGNMENTS_FK 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:

SchemaAPPS
SynonymPER_SECURITY_PROFILES
TriggerPER_SECURITY_PROFILES_WHO
SchemaPUBLIC
SynonymPER_SECURITY_PROFILES