# DW_AOR_PRSN_SEC_PRFL_D

It stores information about person security profile.

## Details

Module:

## Key Columns

ROLE_ID

## Columns

Columns
Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column
--- | --- | --- | --- | --- | --- | --- | ---
ROLE_ID | NUMBER | 38 | 0 | True | System generated primary key column. |  |
SOURCE_RECORD_ID | VARCHAR2 | 128 |  |  | This column is for Oracle Internal use only. Unique Source Record Identifier with asg_responsibility_id |  |
ROLE_COMMON_NAME | VARCHAR2 | 999 |  |  | The Common Name, CN, defined within LDAP |  |
PSP_NAME | VARCHAR2 | 256 |  |  | Name for the Person Security Profiles. |  |
SECURE_BY_AOR | VARCHAR2 | 32 |  |  | Restricts person security profiles based on areas of responsibility. |  |
ENABLE_EXCLUSION | VARCHAR2 | 32 |  |  | Enable exclusion |  |
ALL_EMPLOYEE_ACCESS | VARCHAR2 | 32 |  |  | All Employee Access |  |
ALL_CONT_WORKER_ACCESS | VARCHAR2 | 32 |  |  | Contigent worker access |  |
ALL_PENDING_WORKER_ACCESS | VARCHAR2 | 32 |  |  | Pending worker access |  |
ALL_NON_WORKER_ACCESS | VARCHAR2 | 32 |  |  | Non Worker Access |  |
SECURE_BY_CUSTOM_RESTRICTION | VARCHAR2 | 32 |  |  | Secured by custom restriction |  |
ALL_CAND_WITH_OFFER_ACCESS | VARCHAR2 | 32 |  |  | candidate with offer access |  |
SCOPE_OF_RESPONSIBILITY | VARCHAR2 | 32 |  |  | Scope of areas of responsibility which will be used to identify secured access |  |
RESPONSIBILITY_TYPE | VARCHAR2 | 32 |  |  | Responsibility type for areas of responsibility. |  |

Copyright © 2019, 2025, Oracle and/or its affiliates.