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_PERSON_LIST

Object Details

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

PER_PERSON_LIST holds the list of people 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 people 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_PERSON_LIST_UK1	NORMAL	UNIQUE	APPS_TS_TX_IDX	SECURITY_PROFILE_ID PERSON_ID GRANTED_USER_ID
PER_PERSON_LIST_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PERSON_ID
PER_PERSON_LIST_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	GRANTED_USER_ID PERSON_ID
PER_PERSON_LIST_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	SECURITY_PROFILE_ID GRANTED_USER_ID

Foreign Keys

Table		Foreign Table	Foreign Key Column
PER_PERSON_LIST		PER_SECURITY_PROFILES	PER_PERSON_LIST SECURITY_PROFILE_ID

Columns

Name	Datatype	Length	Mandatory	Comments
SECURITY_PROFILE_ID	NUMBER	(15)		Foreign key to PER_SECURITY_PROFILES.
PERSON_ID	NUMBER	(10)	Yes	Foreign key to PER_PEOPLE.
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.
GRANTED_USER_ID	NUMBER	(15)		Foreign key to FND_USER.

Query Text

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


SELECT SECURITY_PROFILE_ID
,      PERSON_ID
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      GRANTED_USER_ID
FROM HR.PER_PERSON_LIST;

Dependencies

[top of page]

HR.PER_PERSON_LIST does not reference any database object

HR.PER_PERSON_LIST is referenced by following:

HR: PER_PERSON_LIST#