TS_SEARCHED_VW

index back

Search Criteria - Searched

Search Criteria - Searched
SELECT OPRID, TS_SRCH_ID, TS_SRCH_STATUS, LANGUAGE_CD FROM PS_TS_PROFILE WHERE TS_SRCH_STATUS <> 'N'

PeopleSoft Field NameField TypeColumn TypeDescription
OPRIDCharacter(30)VARCHAR2(30) NOT NULLA user's ID (see PSOPRDEFN).
TS_SRCH_IDCharacter(30)VARCHAR2(30) NOT NULLText Search Identifier
TS_SRCH_STATUSCharacter(1)VARCHAR2(1) NOT NULLSearch Status
C=Complete
I=In Process
N=New Search
R=Replace Complete
S=Search Complete
U=Undo Complete

Default: N

LANGUAGE_CDCharacter(3)VARCHAR2(3) NOT NULLLanguage Code translate values
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19