HRS_SRCHIDX_SDP (SQL Table)	Index Back
Saved Search Definition Props This table houses the index start date that is calculated when a full index is run

HRS_SRCHIDX_SDP

(SQL Table)

Saved Search Definition Props

This table houses the index start date that is calculated when a full index is run

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PTSF_SBO_NAME Character(65) VARCHAR2(65) NOT NULL Search Definition (see PSPTSF_SD).

2 FROM_DATE Date(10) DATE From Date

3 DAYS Number(3,0) SMALLINT NOT NULL Days

4 HRS_DAYS_IDX Number(5,0) INTEGER NOT NULL Days to Index

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PTSF_SBO_NAME	Character(65)	VARCHAR2(65) NOT NULL	Search Definition (see PSPTSF_SD).
2	FROM_DATE	Date(10)	DATE	From Date
3	DAYS	Number(3,0)	SMALLINT NOT NULL	Days
4	HRS_DAYS_IDX	Number(5,0)	INTEGER NOT NULL	Days to Index