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


TABLE: HR.PER_PARTICIPANTS

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


A person participating in an event such as an appraisal or assessment
is a participant. Participants are recorded in series and the
completion date for an individual's participation provides a sequential
list for each stage of the process (e.g. apraisee -> appraiser ->
approver).


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Primary Key: PER_PARTICIPANTS_PK
  1. ColumnPARTICIPANT_ID
Indexes
Index Type Uniqueness Tablespace Column
PER_PARTICIPANTS_PK NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnPARTICIPANT_ID
PER_PARTICIPANTS_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPERSON_ID
PER_PARTICIPANTS_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPARTICIPATION_IN_ID
ColumnPARTICIPATION_IN_TABLE
ColumnPARTICIPATION_IN_COLUMN
PER_PARTICPANTS_FK1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnBUSINESS_GROUP_ID
Foreign Keys
Table
Foreign Table Foreign Key Column
PER_PARTICIPANTS PER_PARTICPANTS_FK1 TableHR_ALL_ORGANIZATION_UNITS PER_PARTICIPANTS BUSINESS_GROUP_ID
Columns
Name Datatype Length Mandatory Comments
PARTICIPANT_ID NUMBER (15) Yes Primary key of the Participant
BUSINESS_GROUP_ID NUMBER (15) Yes Foreign key to HR_ORGANIZATION_UNITS.
OBJECT_VERSION_NUMBER NUMBER (9) Yes System-generated version of row. Increments by one with each update.
PARTICIPATION_IN_TABLE VARCHAR2 (80) Yes The table to which the participant record is related
PARTICIPATION_IN_COLUMN VARCHAR2 (80) Yes The column to which the participant_in_id is related
PARTICIPATION_IN_ID NUMBER (15) Yes The ID of the foreign key in table defined in PARTICIPATION_IN_TA
PARTICIPATION_TYPE VARCHAR2 (30)
Denotes the type of participation. e.g. as a group appraiser or reviewer
PARTICIPATION_STATUS VARCHAR2 (30)
The status of the participation, either open or closed. i.e. whether a participant may make modifications or not.
LAST_NOTIFIED_DATE DATE

The last date a participant was sent a notification.
DATE_COMPLETED DATE

The date on which the participation takes place
COMMENTS VARCHAR2 (2000)
The participants comments about their role in a process
PERSON_ID NUMBER (15) Yes The person who is the participant
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive flexfield structure defining column.
ATTRIBUTE1 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE2 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE3 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE4 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE5 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE6 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE7 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE8 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE9 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE10 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE11 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE12 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE13 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE14 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE15 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE16 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE17 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE18 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE19 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE20 VARCHAR2 (150)
Descriptive flexfield column.
LAST_UPDATE_DATE DATE

Standard Who column.
LAST_UPDATED_BY NUMBER (15)
Standard Who column.
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column.
CREATED_BY NUMBER (15)
Standard Who column.
CREATION_DATE DATE

Standard Who column.
QUESTIONNAIRE_TEMPLATE_ID NUMBER (15)
Foreign Key to HR_QUESTIONNAIRES. Contains the Questionnaire associated to this Participant.
PARTICIPANT_USAGE_STATUS VARCHAR2 (30)
Track appraisal offline status for participant
Query Text

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


SELECT PARTICIPANT_ID
,      BUSINESS_GROUP_ID
,      OBJECT_VERSION_NUMBER
,      PARTICIPATION_IN_TABLE
,      PARTICIPATION_IN_COLUMN
,      PARTICIPATION_IN_ID
,      PARTICIPATION_TYPE
,      PARTICIPATION_STATUS
,      LAST_NOTIFIED_DATE
,      DATE_COMPLETED
,      COMMENTS
,      PERSON_ID
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE16
,      ATTRIBUTE17
,      ATTRIBUTE18
,      ATTRIBUTE19
,      ATTRIBUTE20
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
,      QUESTIONNAIRE_TEMPLATE_ID
,      PARTICIPANT_USAGE_STATUS
FROM HR.PER_PARTICIPANTS;

Dependencies

[top of page]

HR.PER_PARTICIPANTS does not reference any database object

HR.PER_PARTICIPANTS is referenced by following:

SchemaHR
ViewPER_PARTICIPANTS#