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


TABLE: HR.PER_RECRUITMENT_ACTIVITY_FOR

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


PER_RECRUITMENT_ACTIVITY_FOR holds details of the vacancies associated
with a specific recruitment activity. There may be multiple records
associated with one activity, for example, where a single
advertisement covers multiple vacancies.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Primary Key: PER_RECRUITMENT_ACTIVITY_F_PK
  1. ColumnRECRUITMENT_ACTIVITY_FOR_ID
Indexes
Index Type Uniqueness Tablespace Column
PER_RECRUITMENT_ACTIVITY_F_PK NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnRECRUITMENT_ACTIVITY_FOR_ID
PER_RECRUITMENT_ACTIVITY_F_FK1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnBUSINESS_GROUP_ID
PER_RECRUITMENT_ACTIVITY_F_FK2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnVACANCY_ID
PER_RECRUITMENT_ACTIVITY_F_FK3 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnRECRUITMENT_ACTIVITY_ID
Foreign Keys
Table
Foreign Table Foreign Key Column
PER_RECRUITMENT_ACTIVITY_FOR PER_RECRUITMENT_ACTIVITY_F_FK1 TableHR_ALL_ORGANIZATION_UNITS PER_RECRUITMENT_ACTIVITY_FOR BUSINESS_GROUP_ID
PER_RECRUITMENT_ACTIVITY_FOR PER_RECRUITMENT_ACTIVITY_F_FK2 TablePER_ALL_VACANCIES PER_RECRUITMENT_ACTIVITY_FOR VACANCY_ID
PER_RECRUITMENT_ACTIVITY_FOR PER_RECRUITMENT_ACTIVITY_F_FK3 TablePER_RECRUITMENT_ACTIVITIES PER_RECRUITMENT_ACTIVITY_FOR RECRUITMENT_ACTIVITY_ID
Columns
Name Datatype Length Mandatory Comments
RECRUITMENT_ACTIVITY_FOR_ID NUMBER (15) Yes System-generated primary key column.
BUSINESS_GROUP_ID NUMBER (15) Yes Foreign key to HR_ORGANIZATION_UNITS.
VACANCY_ID NUMBER (15) Yes Foreign key to PER_ALL_VACANCIES.
RECRUITMENT_ACTIVITY_ID NUMBER (15) Yes Foreign key to PER_RECRUITMENT_ACTIVITIES.
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.
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.
OBJECT_VERSION_NUMBER NUMBER (9) Yes System-generated version of row. Increments by one with each update.
Query Text

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


SELECT RECRUITMENT_ACTIVITY_FOR_ID
,      BUSINESS_GROUP_ID
,      VACANCY_ID
,      RECRUITMENT_ACTIVITY_ID
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
,      OBJECT_VERSION_NUMBER
FROM HR.PER_RECRUITMENT_ACTIVITY_FOR;

Dependencies

[top of page]

HR.PER_RECRUITMENT_ACTIVITY_FOR does not reference any database object

HR.PER_RECRUITMENT_ACTIVITY_FOR is referenced by following:

SchemaAPPS
SynonymPER_RECRUITMENT_ACTIVITY_FOR
TriggerPER_RECRUITMENT_ACTIVITY_F_WHO
TriggerPER_REC_ACTIVITY_FOR_OVN
SchemaPUBLIC
SynonymPER_RECRUITMENT_ACTIVITY_FOR