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_ASSIGNMENT_LIST

Object Details

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

PER_ASSIGNMENT_LIST holds the list of assignments that a specific secure user
can access. This list is created and maintained by the PERSLM
security process using the security profile definition where
it contains restricting criteria. The list shows assignments currently assigned,
(since the last date PERLSM was run), to the organizations, positions, payrolls
and any other custom attributes identified by the security profile.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
PER_ASSIGNMENT_LIST_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	SECURITY_PROFILE_ID USER_ID

Foreign Keys

Table		Foreign Table	Foreign Key Column
PER_ASSIGNMENT_LIST		PER_SECURITY_PROFILES	PER_ASSIGNMENT_LIST SECURITY_PROFILE_ID

Columns

Name	Datatype	Length	Mandatory	Comments
USER_ID	NUMBER	(15)		Foreign key to FND_USER.
SECURITY_PROFILE_ID	NUMBER	(15)	Yes	Foreign key to PER_SECURITY_PROFILES.
ASSIGNMENT_ID	NUMBER	(15)	Yes	Foreign key to PER_ALL_ASSIGNMENTS_F.
PERSON_ID	NUMBER	(15)	Yes	Foreign key to PER_ALL_PEOPLE_F.
REQUEST_ID	NUMBER	(15)		Standard Who column.
PROGRAM_ID	NUMBER	(15)		Standard Who column.
PROGRAM_APPLICATION_ID	NUMBER	(15)		Standard Who column.
PROGRAM_UPDATE_DATE	DATE			Standard Who column.

Query Text

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


SELECT USER_ID
,      SECURITY_PROFILE_ID
,      ASSIGNMENT_ID
,      PERSON_ID
,      REQUEST_ID
,      PROGRAM_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_UPDATE_DATE
FROM HR.PER_ASSIGNMENT_LIST;

Dependencies

[top of page]

HR.PER_ASSIGNMENT_LIST does not reference any database object

HR.PER_ASSIGNMENT_LIST is referenced by following:

APPS: PER_ASSIGNMENT_LIST
PUBLIC: PER_ASSIGNMENT_LIST