DBA Data[Home] [Help] [Dependency Information]

TABLE: HR.HR_WORKING_PERSON_LISTS

Object Details
Object Name: HR_WORKING_PERSON_LISTS
Object Type: TABLE
Owner: HR
FND Design Data: TablePER.HR_WORKING_PERSON_LISTS
Subobject Name:
Status: VALID


Holds a list of people who constitute a user current list, used in the
Line Manager Web pages


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Primary Key: HR_WORKING_PERSON_LISTS_PK
  1. ColumnWORKING_PERSON_LIST_ID
Indexes
Index Type Uniqueness Tablespace Column
HR_WORKING_PERSON_LISTS_PK NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnWORKING_PERSON_LIST_ID
HR_WORKING_PERSON_LISTS_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnOWNING_PERSON_ID
ColumnSELECTED_PERSON_ID
ColumnSELECTED_ASSIGNMENT_ID
HR_WORKING_PERSON_LISTS_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnSELECTED_PERSON_ID
Columns
Name Datatype Length Mandatory Comments
WORKING_PERSON_LIST_ID NUMBER (9) Yes Primary key of HR_WORKING_PERSON_LISTS.
OWNING_PERSON_ID NUMBER (10) Yes Foreign key to PER_ALL_PEOPLE_F, holds the ID of the person whow owns the list.
SELECTED_PERSON_ID NUMBER (10) Yes Foreign key to PER_ALL_PEOPLE_F, holds the ID of the selected person.
CURRENT_SELECTION VARCHAR2 (30)
An indication that the person is currently being worked with.
MULTIPLE_SELECTION VARCHAR2 (30)
An indication that the row is part of a set currently being worked with.
SELECTED_ASSIGNEMENT_ID NUMBER (15)
SELECTED_ASSIGNMENT_ID NUMBER (15)
Assignment Id of the selected person
Query Text

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


SELECT WORKING_PERSON_LIST_ID
,      OWNING_PERSON_ID
,      SELECTED_PERSON_ID
,      CURRENT_SELECTION
,      MULTIPLE_SELECTION
,      SELECTED_ASSIGNEMENT_ID
,      SELECTED_ASSIGNMENT_ID
FROM HR.HR_WORKING_PERSON_LISTS;

Dependencies

[top of page]

HR.HR_WORKING_PERSON_LISTS does not reference any database object

HR.HR_WORKING_PERSON_LISTS is referenced by following:

SchemaAPPS
SynonymHR_WORKING_PERSON_LISTS
SchemaPUBLIC
SynonymHR_WORKING_PERSON_LISTS