HRS_SRCHIDX_CTL

(SQL Table)
Index Back

Search Index Build Control

This table houses the from date that will be used to select applicants or job postings for SES index feeds.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 HRS_SRCH_INDEX_CD Character(1) VARCHAR2(1) NOT NULL Search Index field
A=Applicants
J=Job Postings
R=Recruitment
2 HRS_FROM_DATE Date(10) DATE From Application Date
3 HRS_INDEX_FROM Character(2) VARCHAR2(2) NOT NULL From Application Date
12=Last 12 Months
18=Last 18 Months
24=Last 24 Months
6=Last 6 Months
A=All

Default Value: 6