TS_SRCH_ONLY_VW

index back

Search Criteria - Search Only

Search Criteria - Search Only Searches
SELECT OPRID, TS_SRCH_ID, TS_SRCH_STATUS, LANGUAGE_CD FROM PS_TS_PROFILE WHERE TS_SRCH_STATUS <> 'N' AND TS_SRCH_ONLY = 'Y'

PeopleSoft Field Name Field Type Column Type Description
OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
TS_SRCH_ID Character(30) VARCHAR2(30) NOT NULL Text Search Identifier
TS_SRCH_STATUS Character(1) VARCHAR2(1) NOT NULL Search Status
C=Complete
I=In Process
N=New Search
R=Replace Complete
S=Search Complete
U=Undo Complete

Default: N

LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code translate values
index back (c)David Kurtz 2020, www.go-faster.co.uk PeopleTools 8.58
PTRef generated on 21-DEC-20