TS_SRCH_RDY_VW

index back

Search Criteria - Search Ready

Search Criteria - Ready for Search
SELECT OPRID, TS_SRCH_ID, TS_SRCH_STATUS, LANGUAGE_CD, TS_SRCH_LONG, TS_EXCLUDE_AMPER, TS_MSG_SET_LOWER, TS_MSG_SET_UPPER, TS_SRCH_TYPE , TS_SRCH_ONLY, TS_SRCH_RDY, TS_RPLC_RDY, TS_UNDO_RDY, TS_SRCH_PNL, TS_SRCH_MEN, TS_SRCH_REC, TS_SRCH_MSG, TS_SRCH_BPS, TS_SRCH_QRY, TS_SRCH_OTH, TS_SRCH_APP, PRCSINSTANCE, TS_SRCH_DTTM , TS_RPLC_DTTM, TS_UNDO_DTTM FROM PS_TS_PROFILE WHERE TS_SRCH_STATUS = 'N' AND TS_SRCH_RDY = 'Y'

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
TS_SRCH_LONGCharacter(1)VARCHAR2(1) NOT NULLSearch Long Fields

Y/N Table Edit

Default: N

TS_EXCLUDE_AMPERCharacter(1)VARCHAR2(1) NOT NULLExclude & from Menu Search

Y/N Table Edit

Default: Y

TS_MSG_SET_LOWERNumber(5,0)INTEGER NOT NULLLower Message Set
TS_MSG_SET_UPPERNumber(5,0)INTEGER NOT NULLUpper Message Set
TS_SRCH_TYPECharacter(1)VARCHAR2(1) NOT NULLSearch Type
B=Base Language
N=Non-Base Language
T=Both Base and Non-Base

Default: N

TS_SRCH_ONLYCharacter(1)VARCHAR2(1) NOT NULLSearch Only (No Replace)

Y/N Table Edit

Default: N

TS_SRCH_RDYCharacter(1)VARCHAR2(1) NOT NULLSearch Ready

Y/N Table Edit

Default: N

TS_RPLC_RDYCharacter(1)VARCHAR2(1) NOT NULLReplace Ready

Y/N Table Edit

Default: N

TS_UNDO_RDYCharacter(1)VARCHAR2(1) NOT NULLUndo Ready

Y/N Table Edit

Default: N

TS_SRCH_PNLCharacter(1)VARCHAR2(1) NOT NULLPages

Y/N Table Edit

Default: Y

TS_SRCH_MENCharacter(1)VARCHAR2(1) NOT NULLMenus

Y/N Table Edit

Default: Y

TS_SRCH_RECCharacter(1)VARCHAR2(1) NOT NULLRecords, Fields, Xlats

Y/N Table Edit

Default: Y

TS_SRCH_MSGCharacter(1)VARCHAR2(1) NOT NULLMessages

Y/N Table Edit

Default: Y

TS_SRCH_BPSCharacter(1)VARCHAR2(1) NOT NULLBusiness Processes

Y/N Table Edit

Default: Y

TS_SRCH_QRYCharacter(1)VARCHAR2(1) NOT NULLQueries and Strings

Y/N Table Edit

Default: Y

TS_SRCH_OTHCharacter(1)VARCHAR2(1) NOT NULLOther System Objects

Y/N Table Edit

Default: Y

TS_SRCH_APPCharacter(1)VARCHAR2(1) NOT NULLApplication Objects

Y/N Table Edit

Default: Y

PRCSINSTANCENumber(10,0)DECIMAL(10) NOT NULLProcess Instance
TS_SRCH_DTTMDateTime(26)TIMESTAMPSearch DateTime
TS_RPLC_DTTMDateTime(26)TIMESTAMPReplace DateTime
TS_UNDO_DTTMDateTime(26)TIMESTAMPReplace DateTime
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19