TS_RPLC_RDY_VW

index back

Search Criteria-Replace Ready

Search Criteria - Ready for Replace
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 = 'S' AND TS_RPLC_RDY = '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
TS_SRCH_LONG Character(1) VARCHAR2(1) NOT NULL Search Long Fields

Y/N Table Edit

Default: N

TS_EXCLUDE_AMPER Character(1) VARCHAR2(1) NOT NULL Exclude & from Menu Search

Y/N Table Edit

Default: Y

TS_MSG_SET_LOWER Number(5,0) INTEGER NOT NULL Lower Message Set
TS_MSG_SET_UPPER Number(5,0) INTEGER NOT NULL Upper Message Set
TS_SRCH_TYPE Character(1) VARCHAR2(1) NOT NULL Search Type
B=Base Language
N=Non-Base Language
T=Both Base and Non-Base

Default: N

TS_SRCH_ONLY Character(1) VARCHAR2(1) NOT NULL Search Only (No Replace)

Y/N Table Edit

Default: N

TS_SRCH_RDY Character(1) VARCHAR2(1) NOT NULL Search Ready

Y/N Table Edit

Default: N

TS_RPLC_RDY Character(1) VARCHAR2(1) NOT NULL Replace Ready

Y/N Table Edit

Default: N

TS_UNDO_RDY Character(1) VARCHAR2(1) NOT NULL Undo Ready

Y/N Table Edit

Default: N

TS_SRCH_PNL Character(1) VARCHAR2(1) NOT NULL Pages

Y/N Table Edit

Default: Y

TS_SRCH_MEN Character(1) VARCHAR2(1) NOT NULL Menus

Y/N Table Edit

Default: Y

TS_SRCH_REC Character(1) VARCHAR2(1) NOT NULL Records, Fields, Xlats

Y/N Table Edit

Default: Y

TS_SRCH_MSG Character(1) VARCHAR2(1) NOT NULL Messages

Y/N Table Edit

Default: Y

TS_SRCH_BPS Character(1) VARCHAR2(1) NOT NULL Business Processes

Y/N Table Edit

Default: Y

TS_SRCH_QRY Character(1) VARCHAR2(1) NOT NULL Queries and Strings

Y/N Table Edit

Default: Y

TS_SRCH_OTH Character(1) VARCHAR2(1) NOT NULL Other System Objects

Y/N Table Edit

Default: Y

TS_SRCH_APP Character(1) VARCHAR2(1) NOT NULL Application Objects

Y/N Table Edit

Default: Y

PRCSINSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
TS_SRCH_DTTM DateTime(26) TIMESTAMP Search DateTime
TS_RPLC_DTTM DateTime(26) TIMESTAMP Replace DateTime
TS_UNDO_DTTM DateTime(26) TIMESTAMP Replace DateTime
index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19