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_SEC_PROFILE_ASSIGNMENTS

Object Details

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

PER_SEC_PROFILE_ASSIGNMENTS holds definitions of a security profile
assignments to a user, responsibility and business group.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Primary Key: PER_SEC_PROFILE_ASSIGNMENTS_PK

SEC_PROFILE_ASSIGNMENT_ID

Unique Key: PER_SEC_PROFILE_ASSIGNMENTS_UK

USER_ID
RESPONSIBILITY_ID
RESPONSIBILITY_APPLICATION_ID
SECURITY_GROUP_ID
BUSINESS_GROUP_ID
SECURITY_PROFILE_ID
START_DATE
END_DATE

Indexes

Index	Type	Uniqueness	Tablespace	Column
PER_SEC_PROFILE_ASSIGNMENTS_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	SEC_PROFILE_ASSIGNMENT_ID
PER_SEC_PROFILE_ASSIGNMENTS_UK	NORMAL	UNIQUE	APPS_TS_TX_IDX	USER_ID RESPONSIBILITY_ID RESPONSIBILITY_APPLICATION_ID SECURITY_GROUP_ID BUSINESS_GROUP_ID SECURITY_PROFILE_ID START_DATE END_DATE
PER_SEC_PROFILE_ASSIGNMENTS_FK	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	SECURITY_PROFILE_ID
PER_SEC_PROFILE_ASSIGNMENT_FK2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	BUSINESS_GROUP_ID

Foreign Keys

Table		Foreign Table	Foreign Key Column
PER_SEC_PROFILE_ASSIGNMENTS		HR_ALL_ORGANIZATION_UNITS	PER_SEC_PROFILE_ASSIGNMENTS BUSINESS_GROUP_ID
PER_SEC_PROFILE_ASSIGNMENTS		PER_SECURITY_PROFILES	PER_SEC_PROFILE_ASSIGNMENTS SECURITY_PROFILE_ID

Columns

Name	Datatype	Length	Mandatory	Comments
SEC_PROFILE_ASSIGNMENT_ID	NUMBER	(15)	Yes	System-generated primary key column.
USER_ID	NUMBER	(15)	Yes	Foreign key to FND_USER.
SECURITY_GROUP_ID	NUMBER	(15)	Yes	Foreign key to FND_SECURITY_GROUPS.
SECURITY_PROFILE_ID	NUMBER	(15)	Yes	Foreign key to PER_SECURITY_PROFILES.
RESPONSIBILITY_ID	NUMBER	(15)	Yes	Foreign key to FND_RESPONSIBILITY.
RESPONSIBILITY_APPLICATION_ID	NUMBER	(15)	Yes	Foreign key to FND_RESPONSIBILITY.
START_DATE	DATE		Yes	Start date of the security profile assignment.
END_DATE	DATE			End date of the security profile assignment.
CREATED_BY	NUMBER	(15)		Standard Who column.
CREATION_DATE	DATE			Standard Who column.
LAST_UPDATED_BY	NUMBER	(15)		Standard Who column.
LAST_UPDATE_DATE	DATE			Standard Who column.
LAST_UPDATE_LOGIN	NUMBER	(12)		Standard Who column.
OBJECT_VERSION_NUMBER	NUMBER	(9)	Yes	System-generated version of row. Increments by one with each update.
BUSINESS_GROUP_ID	NUMBER	(15)		Foreign key to HR_ALL_ORGANIZATION_UNITS.

Query Text

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


SELECT SEC_PROFILE_ASSIGNMENT_ID
,      USER_ID
,      SECURITY_GROUP_ID
,      SECURITY_PROFILE_ID
,      RESPONSIBILITY_ID
,      RESPONSIBILITY_APPLICATION_ID
,      START_DATE
,      END_DATE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      OBJECT_VERSION_NUMBER
,      BUSINESS_GROUP_ID
FROM HR.PER_SEC_PROFILE_ASSIGNMENTS;

Dependencies

[top of page]

HR.PER_SEC_PROFILE_ASSIGNMENTS does not reference any database object

HR.PER_SEC_PROFILE_ASSIGNMENTS is referenced by following:

APPS: PER_SEC_PROFILE_ASSIGNMENTS; PER_SEC_PROFILE_ASSIGNMENT_WHO
PUBLIC: PER_SEC_PROFILE_ASSIGNMENTS