Recruiting Search Indexes

PeopleSoft Recruiting Solutions uses the PeopleTools Search Framework (which accesses its underlying search engine by way of Integration Broker) to generate search results for various applicant and job searches. To perform searches, the system uses a set of indexes that contain the relevant data, it does not search the database tables directly. The index must be routinely updated to reflect the latest database changes.

Indexes are based on PeopleTools Search Framework search definitions, which in turn belong to search categories.

Oracle delivers the following search definitions to support recruiting searches:

  • HC_HRS_APPLICANT

  • HC_HRS_APP_INDEX

  • HC_HRS_JOB_OPENING

  • HC_HRS_JOB_POSTING

  • HC_HRS_APPLICATION_CONTENT

  • HC_HRS_JOB_CONTENT

  • HC_JPM_PERSON_PROFILE (also supports profile searching in PeopleSoft Human Resources)

  • HC_JPM_NONPERSON_PROFILE (also supports profile searching in PeopleSoft Human Resources)

  • HC_HRS_DATA_MAP