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]

VIEW: HR.PER_SECURITY_PROFILES#

Object Details

Object Name:	PER_SECURITY_PROFILES#
Object Type:	VIEW
Owner:	HR
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length	Mandatory
SECURITY_PROFILE_ID	NUMBER	(15)	Yes
BUSINESS_GROUP_ID	NUMBER	(15)
POSITION_ID	NUMBER	(15)
ORGANIZATION_ID	NUMBER	(15)
POSITION_STRUCTURE_ID	NUMBER	(15)
ORGANIZATION_STRUCTURE_ID	NUMBER	(15)
INCLUDE_TOP_ORGANIZATION_FLAG	VARCHAR2	(30)	Yes
INCLUDE_TOP_POSITION_FLAG	VARCHAR2	(30)	Yes
SECURITY_PROFILE_NAME	VARCHAR2	(240)	Yes
VIEW_ALL_APPLICANTS_FLAG	VARCHAR2	(30)	Yes
VIEW_ALL_EMPLOYEES_FLAG	VARCHAR2	(30)	Yes
VIEW_ALL_FLAG	VARCHAR2	(30)	Yes
VIEW_ALL_ORGANIZATIONS_FLAG	VARCHAR2	(30)	Yes
VIEW_ALL_PAYROLLS_FLAG	VARCHAR2	(30)	Yes
VIEW_ALL_POSITIONS_FLAG	VARCHAR2	(30)	Yes
INCLUDE_EXCLUDE_PAYROLL_FLAG	VARCHAR2	(30)
REPORTING_ORACLE_USERNAME	VARCHAR2	(30)
REQUEST_ID	NUMBER	(15)
PROGRAM_APPLICATION_ID	NUMBER	(15)
PROGRAM_ID	NUMBER	(15)
PROGRAM_UPDATE_DATE	DATE
LAST_UPDATE_DATE	DATE
LAST_UPDATED_BY	NUMBER	(15)
LAST_UPDATE_LOGIN	NUMBER	(15)
CREATED_BY	NUMBER	(15)
CREATION_DATE	DATE
ALLOW_GRANTED_USERS_FLAG	VARCHAR2	(30)
RESTRICT_BY_SUPERVISOR_FLAG	VARCHAR2	(30)
SUPERVISOR_LEVELS	NUMBER
EXCLUDE_SECONDARY_ASGS_FLAG	VARCHAR2	(30)
EXCLUDE_PERSON_FLAG	VARCHAR2	(30)
NAMED_PERSON_ID	NUMBER	(10)
CUSTOM_RESTRICTION_FLAG	VARCHAR2	(30)
RESTRICTION_TEXT	VARCHAR2	(4000)
EXCLUDE_BUSINESS_GROUPS_FLAG	VARCHAR2	(30)
ORG_SECURITY_MODE	VARCHAR2	(30)	Yes
VIEW_ALL_CWK_FLAG	VARCHAR2	(30)	Yes
VIEW_ALL_CONTACTS_FLAG	VARCHAR2	(30)	Yes
RESTRICT_ON_INDIVIDUAL_ASG	VARCHAR2	(30)
TOP_ORGANIZATION_METHOD	VARCHAR2	(30)
TOP_POSITION_METHOD	VARCHAR2	(30)
VIEW_ALL_CANDIDATES_FLAG	VARCHAR2	(30)	Yes

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# references the following:

HR: PER_SECURITY_PROFILES

HR.PER_SECURITY_PROFILES# is referenced by following:

APPS: PER_SECURITY_PROFILES; PER_SECURITY_PROFILES_WHO